PREVIEW / etf_30min / 2024-10-15
file: by_date/etf_30min/2024/2024-10-15.parquet size: 862 KB rows: 34,482
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-10-15 04:00:00 | SPY | ETF | 584.4 | 584.48 | 583.98 | 583.99 | 10874.0 |
| 2024-10-15 04:30:00 | SPY | ETF | 583.81 | 584.14 | 583.81 | 584.02 | 14217.0 |
| 2024-10-15 05:00:00 | SPY | ETF | 584.09 | 584.15 | 583.8 | 584.15 | 4122.0 |
| 2024-10-15 05:30:00 | SPY | ETF | 584.11 | 584.12 | 583.9 | 583.9 | 59715.0 |
| 2024-10-15 06:00:00 | SPY | ETF | 583.97 | 584.12 | 583.7 | 584.07 | 19971.0 |
| 2024-10-15 06:30:00 | SPY | ETF | 584.14 | 584.56 | 584.14 | 584.55 | 5753.0 |
| 2024-10-15 07:00:00 | SPY | ETF | 584.35 | 584.5 | 584.12 | 584.31 | 26175.0 |
| 2024-10-15 07:30:00 | SPY | ETF | 584.26 | 584.4 | 584.09 | 584.33 | 69322.0 |
| 2024-10-15 08:00:00 | SPY | ETF | 584.51 | 584.93 | 584.17 | 584.42 | 37341.0 |
| 2024-10-15 08:30:00 | SPY | ETF | 584.43 | 584.6 | 584.14 | 584.54 | 37096.0 |
| 2024-10-15 09:00:00 | SPY | ETF | 584.6 | 584.83 | 584.52 | 584.61 | 97126.0 |
| 2024-10-15 09:30:00 | SPY | ETF | 584.59 | 584.9 | 584.11 | 584.215 | 2836582.0 |
| 2024-10-15 10:00:00 | SPY | ETF | 584.21 | 584.63 | 583.19 | 583.2576 | 1868001.0 |
| 2024-10-15 10:30:00 | SPY | ETF | 583.24 | 583.31 | 581.29 | 581.95 | 4661821.0 |
| 2024-10-15 11:00:00 | SPY | ETF | 581.97 | 582.8 | 581.8202 | 582.32 | 1162902.0 |
| 2024-10-15 11:30:00 | SPY | ETF | 582.32 | 582.66 | 581.25 | 581.3994 | 1488256.0 |
| 2024-10-15 12:00:00 | SPY | ETF | 581.405 | 582.31 | 581.34 | 582.12 | 1106866.0 |
| 2024-10-15 12:30:00 | SPY | ETF | 582.14 | 582.55 | 581.64 | 581.8 | 893293.0 |
| 2024-10-15 13:00:00 | SPY | ETF | 581.79 | 581.96 | 580.82 | 581.08 | 1058562.0 |
| 2024-10-15 13:30:00 | SPY | ETF | 581.07 | 581.75 | 580.85 | 580.98 | 1389484.0 |
| 2024-10-15 14:00:00 | SPY | ETF | 581.0 | 581.42 | 580.36 | 580.54 | 1616590.0 |
| 2024-10-15 14:30:00 | SPY | ETF | 580.54 | 580.78 | 580.0 | 580.11 | 1334390.0 |
| 2024-10-15 15:00:00 | SPY | ETF | 580.12 | 580.19 | 578.88 | 579.31 | 2851249.0 |
| 2024-10-15 15:30:00 | SPY | ETF | 579.34 | 580.195 | 578.545 | 579.79 | 7481732.0 |
| 2024-10-15 16:00:00 | SPY | ETF | 579.76 | 579.97 | 579.35 | 579.68 | 2474278.0 |
| 2024-10-15 16:30:00 | SPY | ETF | 579.68 | 579.78 | 579.5 | 579.57 | 70058.0 |
| 2024-10-15 17:00:00 | SPY | ETF | 579.6 | 579.78 | 579.52 | 579.7125 | 50460.0 |
| 2024-10-15 17:30:00 | SPY | ETF | 579.7 | 579.7 | 579.61 | 579.6997 | 10175.0 |
| 2024-10-15 18:00:00 | SPY | ETF | 579.67 | 579.67 | 578.99 | 579.51 | 19983.0 |
| 2024-10-15 18:30:00 | SPY | ETF | 579.55 | 579.84 | 579.44 | 579.84 | 15512.0 |
| 2024-10-15 19:00:00 | SPY | ETF | 579.79 | 580.0 | 579.79 | 579.97 | 17155.0 |
| 2024-10-15 19:30:00 | SPY | ETF | 580.0 | 580.05 | 579.8 | 579.86 | 43617.0 |
| 2024-10-15 04:00:00 | QQQ | ETF | 497.08 | 497.17 | 496.29 | 496.29 | 15950.0 |
| 2024-10-15 04:30:00 | QQQ | ETF | 496.25 | 496.73 | 496.18 | 496.53 | 23337.0 |
| 2024-10-15 05:00:00 | QQQ | ETF | 496.64 | 496.79 | 496.4 | 496.69 | 9606.0 |
| 2024-10-15 05:30:00 | QQQ | ETF | 496.8 | 496.8 | 496.47 | 496.58 | 4118.0 |
| 2024-10-15 06:00:00 | QQQ | ETF | 496.79 | 497.13 | 496.53 | 496.84 | 25589.0 |
| 2024-10-15 06:30:00 | QQQ | ETF | 496.9 | 497.59 | 496.9 | 497.4 | 32036.0 |
| 2024-10-15 07:00:00 | QQQ | ETF | 497.28 | 497.57 | 497.06 | 497.15 | 53876.0 |
| 2024-10-15 07:30:00 | QQQ | ETF | 497.2 | 497.4 | 496.96 | 497.4 | 38164.0 |
| 2024-10-15 08:00:00 | QQQ | ETF | 497.35 | 497.79 | 496.684 | 497.46 | 47709.0 |
| 2024-10-15 08:30:00 | QQQ | ETF | 497.5 | 497.75 | 497.16 | 497.65 | 45016.0 |
| 2024-10-15 09:00:00 | QQQ | ETF | 497.71 | 498.23 | 497.67 | 497.8 | 75231.0 |
| 2024-10-15 09:30:00 | QQQ | ETF | 497.83 | 498.5 | 497.191 | 497.74 | 1916788.0 |
| 2024-10-15 10:00:00 | QQQ | ETF | 497.77 | 498.18 | 494.88 | 495.0 | 1980552.0 |
| 2024-10-15 10:30:00 | QQQ | ETF | 494.94 | 494.95 | 490.56 | 492.23 | 5122707.0 |
| 2024-10-15 11:00:00 | QQQ | ETF | 492.23 | 493.38 | 491.46 | 492.18 | 1719762.0 |
| 2024-10-15 11:30:00 | QQQ | ETF | 492.16 | 493.03 | 490.95 | 491.065 | 1715351.0 |
| 2024-10-15 12:00:00 | QQQ | ETF | 491.09 | 492.49 | 490.751 | 491.85 | 1117300.0 |
| 2024-10-15 12:30:00 | QQQ | ETF | 491.86 | 492.58 | 491.38 | 491.65 | 1009222.0 |
> showing 50 of 34,482 rows — these rows as CSV