PREVIEW / etf_30min / 2025-06-11
file: by_date/etf_30min/2025/2025-06-11.parquet size: 954 KB rows: 39,868
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-06-11 04:00:00 | SPY | ETF | 601.89 | 602.23 | 601.8 | 602.07 | 86022.0 |
| 2025-06-11 04:30:00 | SPY | ETF | 602.05 | 602.68 | 602.03 | 602.38 | 12270.0 |
| 2025-06-11 05:00:00 | SPY | ETF | 602.45 | 602.49 | 602.13 | 602.23 | 15383.0 |
| 2025-06-11 05:30:00 | SPY | ETF | 602.38 | 602.38 | 601.81 | 601.81 | 5383.0 |
| 2025-06-11 06:00:00 | SPY | ETF | 601.82 | 602.24 | 601.73 | 602.19 | 9568.0 |
| 2025-06-11 06:30:00 | SPY | ETF | 602.08 | 602.34 | 601.8 | 602.2 | 51544.0 |
| 2025-06-11 07:00:00 | SPY | ETF | 602.23 | 602.23 | 601.13 | 601.86 | 59557.0 |
| 2025-06-11 07:30:00 | SPY | ETF | 601.87 | 602.5 | 601.78 | 602.32 | 23339.0 |
| 2025-06-11 08:00:00 | SPY | ETF | 602.33 | 603.85 | 600.99 | 602.73 | 971236.0 |
| 2025-06-11 08:30:00 | SPY | ETF | 602.7 | 606.4 | 602.68 | 604.54 | 1372805.0 |
| 2025-06-11 09:00:00 | SPY | ETF | 604.55 | 604.78 | 603.9201 | 604.18 | 400861.0 |
| 2025-06-11 09:30:00 | SPY | ETF | 604.19 | 604.25 | 602.25 | 603.65 | 5384252.0 |
| 2025-06-11 10:00:00 | SPY | ETF | 603.66 | 604.885 | 603.3 | 604.735 | 2865516.0 |
| 2025-06-11 10:30:00 | SPY | ETF | 604.74 | 605.06 | 604.38 | 604.7 | 2277799.0 |
| 2025-06-11 11:00:00 | SPY | ETF | 604.7 | 604.9879 | 603.46 | 604.22 | 2815351.0 |
| 2025-06-11 11:30:00 | SPY | ETF | 604.21 | 604.44 | 603.23 | 603.58 | 2175238.0 |
| 2025-06-11 12:00:00 | SPY | ETF | 603.59 | 603.87 | 601.96 | 603.22 | 3690781.0 |
| 2025-06-11 12:30:00 | SPY | ETF | 603.21 | 603.6 | 602.74 | 603.42 | 2220372.0 |
| 2025-06-11 13:00:00 | SPY | ETF | 603.405 | 604.43 | 603.26 | 604.35 | 1922261.0 |
| 2025-06-11 13:30:00 | SPY | ETF | 604.35 | 604.445 | 602.36 | 602.507 | 2240500.0 |
| 2025-06-11 14:00:00 | SPY | ETF | 602.51 | 602.78 | 599.27 | 600.71 | 7174025.0 |
| 2025-06-11 14:30:00 | SPY | ETF | 600.73 | 602.16 | 599.86 | 600.79 | 4706386.0 |
| 2025-06-11 15:00:00 | SPY | ETF | 600.82 | 601.12 | 599.93 | 600.48 | 3877547.0 |
| 2025-06-11 15:30:00 | SPY | ETF | 600.47 | 601.59 | 599.73 | 601.4 | 7961222.0 |
| 2025-06-11 16:00:00 | SPY | ETF | 601.41 | 602.0 | 601.08 | 601.73 | 1568042.0 |
| 2025-06-11 16:30:00 | SPY | ETF | 601.73 | 601.75 | 601.26 | 601.36 | 333238.0 |
| 2025-06-11 17:00:00 | SPY | ETF | 601.35 | 601.56 | 600.9503 | 600.97 | 86769.0 |
| 2025-06-11 17:30:00 | SPY | ETF | 600.91 | 602.9843 | 600.9 | 601.0696 | 137400.0 |
| 2025-06-11 18:00:00 | SPY | ETF | 600.92 | 601.65 | 600.62 | 601.58 | 70883.0 |
| 2025-06-11 18:30:00 | SPY | ETF | 601.54 | 601.71 | 600.21 | 600.4314 | 54555.0 |
| 2025-06-11 19:00:00 | SPY | ETF | 600.33 | 600.5899 | 600.08 | 600.32 | 83143.0 |
| 2025-06-11 19:30:00 | SPY | ETF | 600.3 | 601.01 | 600.3 | 600.4895 | 47488.0 |
| 2025-06-11 04:00:00 | QQQ | ETF | 533.52 | 533.75 | 533.3 | 533.5 | 17809.0 |
| 2025-06-11 04:30:00 | QQQ | ETF | 533.48 | 534.21 | 533.47 | 533.91 | 18332.0 |
| 2025-06-11 05:00:00 | QQQ | ETF | 533.85 | 533.92 | 533.51 | 533.73 | 26965.0 |
| 2025-06-11 05:30:00 | QQQ | ETF | 533.76 | 533.82 | 533.12 | 533.12 | 18332.0 |
| 2025-06-11 06:00:00 | QQQ | ETF | 533.22 | 533.6 | 532.98 | 533.37 | 19641.0 |
| 2025-06-11 06:30:00 | QQQ | ETF | 533.45 | 533.7 | 533.14 | 533.44 | 17265.0 |
| 2025-06-11 07:00:00 | QQQ | ETF | 533.44 | 533.5 | 532.37 | 532.91 | 46693.0 |
| 2025-06-11 07:30:00 | QQQ | ETF | 533.14 | 533.71 | 533.09 | 533.51 | 17016.0 |
| 2025-06-11 08:00:00 | QQQ | ETF | 533.38 | 535.01 | 532.21 | 533.92 | 285647.0 |
| 2025-06-11 08:30:00 | QQQ | ETF | 534.13 | 537.5 | 534.02 | 535.92 | 968263.0 |
| 2025-06-11 09:00:00 | QQQ | ETF | 535.92 | 536.22 | 535.36 | 535.62 | 293338.0 |
| 2025-06-11 09:30:00 | QQQ | ETF | 535.63 | 535.81 | 533.19 | 534.76 | 4358831.0 |
| 2025-06-11 10:00:00 | QQQ | ETF | 534.78 | 536.26 | 534.58 | 536.135 | 2665674.0 |
| 2025-06-11 10:30:00 | QQQ | ETF | 536.14 | 536.69 | 535.84 | 536.56 | 1938041.0 |
| 2025-06-11 11:00:00 | QQQ | ETF | 536.55 | 536.78 | 534.84 | 535.638 | 2643456.0 |
| 2025-06-11 11:30:00 | QQQ | ETF | 535.66 | 535.84 | 534.64 | 535.03 | 1826946.0 |
| 2025-06-11 12:00:00 | QQQ | ETF | 535.07 | 535.3393 | 532.97 | 534.64 | 3012113.0 |
| 2025-06-11 12:30:00 | QQQ | ETF | 534.63 | 534.925 | 534.15 | 534.64 | 1377255.0 |
> showing 50 of 39,868 rows — these rows as CSV