PREVIEW / etf_30min / 2000-11-10
file: by_date/etf_30min/2000/2000-11-10.parquet size: 12 KB rows: 301
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-10 09:30:00 | SPY | ETF | 139.0 | 139.3125 | 138.5 | 138.6875 | 986300.0 |
| 2000-11-10 10:00:00 | SPY | ETF | 138.5625 | 139.0 | 138.125 | 138.9688 | 656200.0 |
| 2000-11-10 10:30:00 | SPY | ETF | 138.8125 | 139.4375 | 138.6562 | 138.875 | 448700.0 |
| 2000-11-10 11:00:00 | SPY | ETF | 138.8125 | 139.1562 | 138.2812 | 138.4375 | 93100.0 |
| 2000-11-10 11:30:00 | SPY | ETF | 138.5938 | 138.625 | 137.8125 | 138.0938 | 540300.0 |
| 2000-11-10 12:00:00 | SPY | ETF | 138.125 | 138.5312 | 138.0 | 138.25 | 671500.0 |
| 2000-11-10 12:30:00 | SPY | ETF | 138.375 | 138.4062 | 137.75 | 138.375 | 325000.0 |
| 2000-11-10 13:00:00 | SPY | ETF | 138.1875 | 138.5938 | 138.125 | 138.3438 | 1293500.0 |
| 2000-11-10 13:30:00 | SPY | ETF | 138.4062 | 138.8438 | 137.9375 | 138.125 | 320400.0 |
| 2000-11-10 14:00:00 | SPY | ETF | 138.0 | 138.125 | 137.375 | 137.375 | 390500.0 |
| 2000-11-10 14:30:00 | SPY | ETF | 137.5312 | 138.4688 | 137.375 | 138.25 | 563700.0 |
| 2000-11-10 15:00:00 | SPY | ETF | 138.375 | 138.5 | 137.75 | 138.5 | 636900.0 |
| 2000-11-10 15:30:00 | SPY | ETF | 138.4062 | 138.4375 | 136.875 | 136.9688 | 1002300.0 |
| 2000-11-10 16:00:00 | SPY | ETF | 136.9062 | 137.0 | 136.5312 | 136.625 | 462000.0 |
| 2000-11-10 16:30:00 | SPY | ETF | 136.625 | 136.625 | 136.625 | 136.625 | 3000.0 |
| 2000-11-10 09:30:00 | QQQ | ETF | 74.25 | 75.1875 | 73.9375 | 74.3125 | 6695100.0 |
| 2000-11-10 10:00:00 | QQQ | ETF | 74.375 | 74.6875 | 73.4375 | 74.5625 | 5533700.0 |
| 2000-11-10 10:30:00 | QQQ | ETF | 74.5 | 75.0 | 74.1875 | 74.1875 | 2926500.0 |
| 2000-11-10 11:00:00 | QQQ | ETF | 74.2812 | 74.375 | 73.25 | 73.75 | 2184600.0 |
| 2000-11-10 11:30:00 | QQQ | ETF | 73.6875 | 73.875 | 73.0625 | 73.375 | 3242400.0 |
| 2000-11-10 12:00:00 | QQQ | ETF | 73.5 | 74.0 | 73.375 | 73.875 | 2055300.0 |
| 2000-11-10 12:30:00 | QQQ | ETF | 73.875 | 74.125 | 73.0625 | 74.125 | 3589600.0 |
| 2000-11-10 13:00:00 | QQQ | ETF | 74.125 | 74.1875 | 73.5 | 73.9375 | 2035700.0 |
| 2000-11-10 13:30:00 | QQQ | ETF | 73.9375 | 74.2812 | 73.25 | 73.4688 | 1912100.0 |
| 2000-11-10 14:00:00 | QQQ | ETF | 73.4375 | 73.625 | 73.0 | 73.125 | 2490400.0 |
| 2000-11-10 14:30:00 | QQQ | ETF | 73.125 | 73.9062 | 72.9375 | 73.6562 | 3152700.0 |
| 2000-11-10 15:00:00 | QQQ | ETF | 73.6875 | 73.875 | 73.125 | 73.8125 | 2459500.0 |
| 2000-11-10 15:30:00 | QQQ | ETF | 73.6875 | 73.8438 | 72.0 | 72.0 | 6322800.0 |
| 2000-11-10 16:00:00 | QQQ | ETF | 72.0 | 72.25 | 71.75 | 71.75 | 2291200.0 |
| 2000-11-10 16:30:00 | QQQ | ETF | 71.875 | 72.125 | 71.5625 | 71.5625 | 77600.0 |
| 2000-11-10 17:00:00 | QQQ | ETF | 71.6875 | 72.0 | 71.5 | 71.5 | 29700.0 |
| 2000-11-10 17:30:00 | QQQ | ETF | 71.625 | 73.3125 | 71.625 | 72.0 | 49100.0 |
| 2000-11-10 18:00:00 | QQQ | ETF | 71.5 | 72.125 | 71.5 | 72.125 | 14000.0 |
| 2000-11-10 09:30:00 | IWM | ETF | 49.375 | 49.375 | 48.875 | 48.875 | 8600.0 |
| 2000-11-10 10:00:00 | IWM | ETF | 48.625 | 48.7969 | 48.625 | 48.7969 | 3800.0 |
| 2000-11-10 11:00:00 | IWM | ETF | 48.6562 | 48.6875 | 48.6562 | 48.6875 | 27800.0 |
| 2000-11-10 11:30:00 | IWM | ETF | 48.4688 | 48.5156 | 48.3438 | 48.3438 | 46200.0 |
| 2000-11-10 12:00:00 | IWM | ETF | 48.4062 | 48.4688 | 48.4062 | 48.4688 | 600.0 |
| 2000-11-10 12:30:00 | IWM | ETF | 48.4688 | 48.4688 | 48.25 | 48.3438 | 29400.0 |
| 2000-11-10 13:00:00 | IWM | ETF | 48.375 | 48.4375 | 48.375 | 48.4375 | 600.0 |
| 2000-11-10 13:30:00 | IWM | ETF | 48.4375 | 48.4375 | 48.3438 | 48.3438 | 4800.0 |
| 2000-11-10 14:00:00 | IWM | ETF | 48.3438 | 48.4062 | 48.25 | 48.375 | 9600.0 |
| 2000-11-10 14:30:00 | IWM | ETF | 48.3125 | 48.3125 | 48.1562 | 48.1562 | 2600.0 |
| 2000-11-10 15:00:00 | IWM | ETF | 48.375 | 48.375 | 48.375 | 48.375 | 400.0 |
| 2000-11-10 15:30:00 | IWM | ETF | 48.3125 | 48.3125 | 48.0625 | 48.0625 | 47800.0 |
| 2000-11-10 16:00:00 | IWM | ETF | 48.0 | 48.0 | 48.0 | 48.0 | 2000.0 |
| 2000-11-10 09:30:00 | DIA | ETF | 107.5625 | 107.8125 | 107.0625 | 107.25 | 137200.0 |
| 2000-11-10 10:00:00 | DIA | ETF | 107.4375 | 107.5 | 106.75 | 107.4688 | 89600.0 |
| 2000-11-10 10:30:00 | DIA | ETF | 107.5 | 107.75 | 107.25 | 107.5625 | 67800.0 |
| 2000-11-10 11:00:00 | DIA | ETF | 107.4062 | 107.5938 | 107.0 | 107.0312 | 30100.0 |
> showing 50 of 301 rows — these rows as CSV