PREVIEW / etf_30min / 2024-01-05
file: by_date/etf_30min/2024/2024-01-05.parquet size: 791 KB rows: 30,960
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-05 04:00:00 | SPY | ETF | 466.86 | 467.28 | 466.35 | 466.82 | 10803.0 |
| 2024-01-05 04:30:00 | SPY | ETF | 466.8 | 466.8 | 466.28 | 466.3 | 3385.0 |
| 2024-01-05 05:00:00 | SPY | ETF | 466.34 | 466.48 | 466.19 | 466.19 | 6231.0 |
| 2024-01-05 05:30:00 | SPY | ETF | 466.22 | 466.23 | 465.88 | 466.18 | 5289.0 |
| 2024-01-05 06:00:00 | SPY | ETF | 466.32 | 466.43 | 465.88 | 465.88 | 6024.0 |
| 2024-01-05 06:30:00 | SPY | ETF | 465.89 | 466.17 | 465.65 | 466.17 | 13709.0 |
| 2024-01-05 07:00:00 | SPY | ETF | 466.22 | 466.4 | 466.0 | 466.39 | 80180.0 |
| 2024-01-05 07:30:00 | SPY | ETF | 466.4 | 466.5 | 465.91 | 466.11 | 63329.0 |
| 2024-01-05 08:00:00 | SPY | ETF | 466.2191 | 467.52 | 465.6904 | 466.4388 | 285689.0 |
| 2024-01-05 08:30:00 | SPY | ETF | 466.41 | 466.66 | 464.61 | 466.37 | 1784581.0 |
| 2024-01-05 09:00:00 | SPY | ETF | 466.41 | 467.69 | 466.38 | 467.49 | 1103612.0 |
| 2024-01-05 09:30:00 | SPY | ETF | 467.49 | 468.59 | 467.13 | 468.1699 | 6445677.0 |
| 2024-01-05 10:00:00 | SPY | ETF | 468.15 | 470.42 | 468.15 | 469.49 | 7417269.0 |
| 2024-01-05 10:30:00 | SPY | ETF | 469.47 | 470.36 | 469.23 | 470.14 | 4135902.0 |
| 2024-01-05 11:00:00 | SPY | ETF | 470.14 | 470.44 | 469.05 | 469.122 | 4159031.0 |
| 2024-01-05 11:30:00 | SPY | ETF | 469.13 | 469.4 | 468.59 | 468.79 | 3171371.0 |
| 2024-01-05 12:00:00 | SPY | ETF | 468.77 | 468.84 | 467.235 | 467.3803 | 4162443.0 |
| 2024-01-05 12:30:00 | SPY | ETF | 467.38 | 467.9 | 467.14 | 467.54 | 3070314.0 |
| 2024-01-05 13:00:00 | SPY | ETF | 467.525 | 467.88 | 466.68 | 467.86 | 3007365.0 |
| 2024-01-05 13:30:00 | SPY | ETF | 467.8501 | 468.69 | 467.85 | 468.35 | 2935611.0 |
| 2024-01-05 14:00:00 | SPY | ETF | 468.37 | 468.98 | 468.065 | 468.21 | 3000496.0 |
| 2024-01-05 14:30:00 | SPY | ETF | 468.2 | 468.49 | 466.65 | 466.815 | 3835549.0 |
| 2024-01-05 15:00:00 | SPY | ETF | 466.82 | 467.32 | 466.5 | 466.93 | 3906925.0 |
| 2024-01-05 15:30:00 | SPY | ETF | 466.93 | 468.29 | 466.43 | 467.96 | 8468817.0 |
| 2024-01-05 16:00:00 | SPY | ETF | 467.97 | 468.47 | 467.86 | 468.05 | 2986062.0 |
| 2024-01-05 16:30:00 | SPY | ETF | 468.03 | 468.03 | 467.92 | 467.96 | 279562.0 |
| 2024-01-05 17:00:00 | SPY | ETF | 467.96 | 468.02 | 467.95 | 467.99 | 8376.0 |
| 2024-01-05 17:30:00 | SPY | ETF | 468.08 | 468.45 | 468.08 | 468.37 | 50575.0 |
| 2024-01-05 18:00:00 | SPY | ETF | 468.3 | 468.4 | 468.3 | 468.4 | 9881.0 |
| 2024-01-05 18:30:00 | SPY | ETF | 468.38 | 468.46 | 468.34 | 468.37 | 16826.0 |
| 2024-01-05 19:00:00 | SPY | ETF | 468.38 | 468.38 | 468.29 | 468.2997 | 4702.0 |
| 2024-01-05 19:30:00 | SPY | ETF | 468.3 | 468.47 | 468.3 | 468.45 | 14485.0 |
| 2024-01-05 04:00:00 | QQQ | ETF | 395.51 | 395.81 | 395.1 | 395.62 | 17206.0 |
| 2024-01-05 04:30:00 | QQQ | ETF | 395.63 | 395.63 | 395.12 | 395.22 | 20658.0 |
| 2024-01-05 05:00:00 | QQQ | ETF | 395.24 | 395.35 | 394.77 | 394.88 | 28820.0 |
| 2024-01-05 05:30:00 | QQQ | ETF | 394.84 | 394.93 | 394.61 | 394.92 | 19530.0 |
| 2024-01-05 06:00:00 | QQQ | ETF | 394.99 | 395.12 | 394.69 | 394.71 | 13028.0 |
| 2024-01-05 06:30:00 | QQQ | ETF | 394.69 | 394.98 | 394.5 | 394.98 | 26581.0 |
| 2024-01-05 07:00:00 | QQQ | ETF | 395.0 | 395.25 | 394.81 | 395.22 | 75409.0 |
| 2024-01-05 07:30:00 | QQQ | ETF | 395.17 | 395.32 | 394.9 | 395.04 | 120719.0 |
| 2024-01-05 08:00:00 | QQQ | ETF | 396.08 | 396.31 | 394.5904 | 395.41 | 215470.0 |
| 2024-01-05 08:30:00 | QQQ | ETF | 395.33 | 395.9 | 393.66 | 395.23 | 1332873.0 |
| 2024-01-05 09:00:00 | QQQ | ETF | 395.29 | 396.47 | 395.22 | 396.39 | 757865.0 |
| 2024-01-05 09:30:00 | QQQ | ETF | 396.44 | 397.57 | 396.16 | 397.01 | 5125323.0 |
| 2024-01-05 10:00:00 | QQQ | ETF | 397.02 | 399.01 | 397.02 | 398.59 | 4462849.0 |
| 2024-01-05 10:30:00 | QQQ | ETF | 398.6 | 399.31 | 398.35 | 399.18 | 3104263.0 |
| 2024-01-05 11:00:00 | QQQ | ETF | 399.19 | 399.56 | 398.0987 | 398.1199 | 2756551.0 |
| 2024-01-05 11:30:00 | QQQ | ETF | 398.13 | 398.43 | 397.53 | 398.06 | 2015746.0 |
| 2024-01-05 12:00:00 | QQQ | ETF | 398.05 | 398.11 | 396.45 | 396.6399 | 2147737.0 |
| 2024-01-05 12:30:00 | QQQ | ETF | 396.6 | 397.25 | 396.44 | 396.9391 | 1477554.0 |
> showing 50 of 30,960 rows — these rows as CSV