database seed

gistfile1.txt

  -- Seed data for indexer_metrics_api local development.                                                                                                                   
  -- Usage: make db-reset && make migrate && then paste this into psql                                                                                                      
                                                                                                                                                                            
  -- ============================================================================                                                                                           
  -- Blocks (one per day, spanning 2026-01-20 to 2026-02-08)
  -- ============================================================================
  INSERT INTO blocks (block_hash, prev_block_hash, height, block_time) VALUES
    (decode('0000000000000000000000000000000000000000000000000000000000000001','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000000','hex'),
     100000, '2026-01-20 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000002','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000001','hex'),
     101440, '2026-01-21 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000003','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000002','hex'),
     102880, '2026-01-22 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000004','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000003','hex'),
     104320, '2026-01-23 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000005','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000004','hex'),
     105760, '2026-01-24 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000006','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000005','hex'),
     107200, '2026-01-25 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000007','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000006','hex'),
     108640, '2026-01-26 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000008','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000007','hex'),
     110080, '2026-01-27 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000009','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000008','hex'),
     111520, '2026-01-28 12:00:00+00'),
    (decode('000000000000000000000000000000000000000000000000000000000000000a','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000009','hex'),
     112960, '2026-01-29 12:00:00+00'),
    (decode('000000000000000000000000000000000000000000000000000000000000000b','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000a','hex'),
     114400, '2026-01-30 12:00:00+00'),
    (decode('000000000000000000000000000000000000000000000000000000000000000c','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000b','hex'),
     115840, '2026-01-31 12:00:00+00'),
    (decode('000000000000000000000000000000000000000000000000000000000000000d','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000c','hex'),
     117280, '2026-02-01 12:00:00+00'),
    (decode('000000000000000000000000000000000000000000000000000000000000000e','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000d','hex'),
     118720, '2026-02-02 12:00:00+00'),
    (decode('000000000000000000000000000000000000000000000000000000000000000f','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000e','hex'),
     120160, '2026-02-03 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000010','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000f','hex'),
     121600, '2026-02-04 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000011','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000010','hex'),
     123040, '2026-02-05 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000012','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000011','hex'),
     124480, '2026-02-06 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000013','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000012','hex'),
     125920, '2026-02-07 12:00:00+00'),
    (decode('0000000000000000000000000000000000000000000000000000000000000014','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000013','hex'),
     127360, '2026-02-08 12:00:00+00');

  -- ============================================================================
  -- CEFFU inbound transactions
  -- ============================================================================

  -- Depositor A: 0xAAAA...AAAA — 5 deposits
  INSERT INTO indexer_tx_ceffu_inbound (txid, block_hash, sum_sats, sender_address, op_return_version, evm_recipient, refund_p2pkh) VALUES
    (decode('aa00000000000000000000000000000000000000000000000000000000000001','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000001','hex'),
     500000000, 'D6abc111111111111111111111111111', 1,
     decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','hex'),
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex')),
    (decode('aa00000000000000000000000000000000000000000000000000000000000002','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000003','hex'),
     750000000, 'D6abc111111111111111111111111111', 1,
     decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','hex'),
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex')),
    (decode('aa00000000000000000000000000000000000000000000000000000000000003','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000006','hex'),
     1200000000, 'D6abc111111111111111111111111111', 1,
     decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','hex'),
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex')),
    (decode('aa00000000000000000000000000000000000000000000000000000000000004','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000b','hex'),
     300000000, 'D6abc111111111111111111111111111', 1,
     decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','hex'),
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex')),
    (decode('aa00000000000000000000000000000000000000000000000000000000000005','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000013','hex'),
     2000000000, 'D6abc111111111111111111111111111', 1,
     decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','hex'),
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex'));

  -- Depositor B: 0xBBBB...BBBB — 3 deposits (whale)
  INSERT INTO indexer_tx_ceffu_inbound (txid, block_hash, sum_sats, sender_address, op_return_version, evm_recipient, refund_p2pkh) VALUES
    (decode('bb00000000000000000000000000000000000000000000000000000000000001','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000002','hex'),
     10000000000, 'D6abc222222222222222222222222222', 1,
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex'),
     decode('cccccccccccccccccccccccccccccccccccccccc','hex')),
    (decode('bb00000000000000000000000000000000000000000000000000000000000002','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000008','hex'),
     5000000000, 'D6abc222222222222222222222222222', 1,
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex'),
     decode('cccccccccccccccccccccccccccccccccccccccc','hex')),
    (decode('bb00000000000000000000000000000000000000000000000000000000000003','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000011','hex'),
     8000000000, 'D6abc222222222222222222222222222', 1,
     decode('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','hex'),
     decode('cccccccccccccccccccccccccccccccccccccccc','hex'));

  -- Depositor C: 0xCCCC...CCCC — 2 deposits
  INSERT INTO indexer_tx_ceffu_inbound (txid, block_hash, sum_sats, sender_address, op_return_version, evm_recipient, refund_p2pkh) VALUES
    (decode('cc00000000000000000000000000000000000000000000000000000000000001','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000005','hex'),
     3000000000, 'D6abc333333333333333333333333333', 1,
     decode('cccccccccccccccccccccccccccccccccccccccc','hex'),
     decode('dddddddddddddddddddddddddddddddddddddd','hex')),
    (decode('cc00000000000000000000000000000000000000000000000000000000000002','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000010','hex'),
     4500000000, 'D6abc333333333333333333333333333', 1,
     decode('cccccccccccccccccccccccccccccccccccccccc','hex'),
     decode('dddddddddddddddddddddddddddddddddddddd','hex'));

  -- Direct deposits (no OP_RETURN, no evm_recipient) — institutional / unattributed
  INSERT INTO indexer_tx_ceffu_inbound (txid, block_hash, sum_sats, sender_address) VALUES
    (decode('dd00000000000000000000000000000000000000000000000000000000000001','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000004','hex'),
     50000000000, 'D6abc444444444444444444444444444'),
    (decode('dd00000000000000000000000000000000000000000000000000000000000002','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000009','hex'),
     25000000000, 'D6abc555555555555555555555555555'),
    (decode('dd00000000000000000000000000000000000000000000000000000000000003','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000d','hex'),
     75000000000, 'D6abc444444444444444444444444444'),
    (decode('dd00000000000000000000000000000000000000000000000000000000000004','hex'),
     decode('0000000000000000000000000000000000000000000000000000000000000012','hex'),
     15000000000, NULL);

  -- Depositor D: 0xDDDD...DDDD — single deposit (one-time user)
  INSERT INTO indexer_tx_ceffu_inbound (txid, block_hash, sum_sats, sender_address, op_return_version, evm_recipient, refund_p2pkh) VALUES
    (decode('ee00000000000000000000000000000000000000000000000000000000000001','hex'),
     decode('000000000000000000000000000000000000000000000000000000000000000e','hex'),
     100000000, 'D6abc666666666666666666666666666', 1,
     decode('dddddddddddddddddddddddddddddddddddddd','hex'),
     decode('eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee','hex'));