PREVIEW / etf_30min / 2024-01-10
file: by_date/etf_30min/2024/2024-01-10.parquet size: 784 KB rows: 30,862
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-10 04:00:00 | SPY | ETF | 473.91 | 474.88 | 473.91 | 474.8 | 13492.0 |
| 2024-01-10 04:30:00 | SPY | ETF | 474.78 | 474.98 | 474.55 | 474.69 | 8765.0 |
| 2024-01-10 05:00:00 | SPY | ETF | 474.68 | 474.73 | 474.3 | 474.37 | 3311.0 |
| 2024-01-10 05:30:00 | SPY | ETF | 474.31 | 474.4 | 474.18 | 474.28 | 2406.0 |
| 2024-01-10 06:00:00 | SPY | ETF | 474.34 | 474.39 | 474.0 | 474.01 | 8799.0 |
| 2024-01-10 06:30:00 | SPY | ETF | 473.94 | 474.0 | 473.54 | 473.78 | 15229.0 |
| 2024-01-10 07:00:00 | SPY | ETF | 473.82 | 474.26 | 473.82 | 474.24 | 72023.0 |
| 2024-01-10 07:30:00 | SPY | ETF | 474.26 | 474.26 | 473.81 | 473.91 | 114636.0 |
| 2024-01-10 08:00:00 | SPY | ETF | 473.8 | 474.8696 | 473.23 | 474.08 | 101569.0 |
| 2024-01-10 08:30:00 | SPY | ETF | 474.02 | 474.02 | 473.6 | 473.61 | 78699.0 |
| 2024-01-10 09:00:00 | SPY | ETF | 473.59 | 474.16 | 473.4 | 474.16 | 188247.0 |
| 2024-01-10 09:30:00 | SPY | ETF | 474.16 | 475.34 | 474.14 | 474.71 | 5431693.0 |
| 2024-01-10 10:00:00 | SPY | ETF | 474.71 | 474.81 | 473.87 | 474.7 | 2857240.0 |
| 2024-01-10 10:30:00 | SPY | ETF | 474.7 | 475.2503 | 474.695 | 475.22 | 2464302.0 |
| 2024-01-10 11:00:00 | SPY | ETF | 475.23 | 475.275 | 474.425 | 474.78 | 2437720.0 |
| 2024-01-10 11:30:00 | SPY | ETF | 474.79 | 475.075 | 474.48 | 474.92 | 1978833.0 |
| 2024-01-10 12:00:00 | SPY | ETF | 474.93 | 475.18 | 474.6 | 475.12 | 1737676.0 |
| 2024-01-10 12:30:00 | SPY | ETF | 475.13 | 475.475 | 475.07 | 475.3897 | 2027758.0 |
| 2024-01-10 13:00:00 | SPY | ETF | 475.39 | 475.9299 | 474.8101 | 475.3 | 3180410.0 |
| 2024-01-10 13:30:00 | SPY | ETF | 475.31 | 475.87 | 475.2301 | 475.753 | 2059676.0 |
| 2024-01-10 14:00:00 | SPY | ETF | 475.76 | 476.83 | 475.675 | 476.62 | 3562676.0 |
| 2024-01-10 14:30:00 | SPY | ETF | 476.62 | 477.2801 | 476.48 | 477.25 | 3060919.0 |
| 2024-01-10 15:00:00 | SPY | ETF | 477.25 | 477.4481 | 475.885 | 476.22 | 5156056.0 |
| 2024-01-10 15:30:00 | SPY | ETF | 476.24 | 476.84 | 475.18 | 476.52 | 9745781.0 |
| 2024-01-10 16:00:00 | SPY | ETF | 476.52 | 476.71 | 475.2887 | 476.68 | 4961367.0 |
| 2024-01-10 16:30:00 | SPY | ETF | 476.68 | 476.72 | 476.56 | 476.65 | 150471.0 |
| 2024-01-10 17:00:00 | SPY | ETF | 476.67 | 476.72 | 476.57 | 476.64 | 33310.0 |
| 2024-01-10 17:30:00 | SPY | ETF | 476.69 | 476.69 | 476.56 | 476.66 | 21645.0 |
| 2024-01-10 18:00:00 | SPY | ETF | 476.6 | 476.8 | 476.44 | 476.8 | 19608.0 |
| 2024-01-10 18:30:00 | SPY | ETF | 476.85 | 476.85 | 476.56 | 476.76 | 7842.0 |
| 2024-01-10 19:00:00 | SPY | ETF | 476.73 | 476.8 | 476.63 | 476.71 | 20748.0 |
| 2024-01-10 19:30:00 | SPY | ETF | 476.77 | 477.21 | 476.76 | 477.08 | 37759.0 |
| 2024-01-10 04:00:00 | QQQ | ETF | 406.46 | 407.5 | 406.36 | 407.38 | 26458.0 |
| 2024-01-10 04:30:00 | QQQ | ETF | 407.46 | 407.62 | 407.28 | 407.44 | 17047.0 |
| 2024-01-10 05:00:00 | QQQ | ETF | 407.43 | 407.51 | 406.88 | 406.99 | 18036.0 |
| 2024-01-10 05:30:00 | QQQ | ETF | 406.93 | 407.04 | 406.8 | 406.83 | 7819.0 |
| 2024-01-10 06:00:00 | QQQ | ETF | 406.84 | 407.15 | 406.58 | 406.59 | 15820.0 |
| 2024-01-10 06:30:00 | QQQ | ETF | 406.55 | 406.58 | 405.97 | 406.24 | 51006.0 |
| 2024-01-10 07:00:00 | QQQ | ETF | 406.28 | 406.69 | 406.25 | 406.63 | 61388.0 |
| 2024-01-10 07:30:00 | QQQ | ETF | 406.63 | 406.64 | 406.08 | 406.08 | 42558.0 |
| 2024-01-10 08:00:00 | QQQ | ETF | 406.2402 | 407.0304 | 405.4 | 406.04 | 125641.0 |
| 2024-01-10 08:30:00 | QQQ | ETF | 406.03 | 406.03 | 405.446 | 405.52 | 117018.0 |
| 2024-01-10 09:00:00 | QQQ | ETF | 405.5 | 406.12 | 405.34 | 406.08 | 221405.0 |
| 2024-01-10 09:30:00 | QQQ | ETF | 406.07 | 406.9 | 405.4591 | 406.03 | 3404538.0 |
| 2024-01-10 10:00:00 | QQQ | ETF | 406.02 | 406.68 | 405.17 | 406.52 | 2538161.0 |
| 2024-01-10 10:30:00 | QQQ | ETF | 406.525 | 407.375 | 406.415 | 407.325 | 1651489.0 |
| 2024-01-10 11:00:00 | QQQ | ETF | 407.34 | 407.4584 | 406.44 | 406.705 | 1215267.0 |
| 2024-01-10 11:30:00 | QQQ | ETF | 406.74 | 407.19 | 406.5 | 407.03 | 1084954.0 |
| 2024-01-10 12:00:00 | QQQ | ETF | 407.04 | 407.4 | 406.79 | 407.29 | 843346.0 |
| 2024-01-10 12:30:00 | QQQ | ETF | 407.29 | 407.87 | 407.25 | 407.79 | 877724.0 |
> showing 50 of 30,862 rows — these rows as CSV