PREVIEW / etf_30min / 2000-12-08
file: by_date/etf_30min/2000/2000-12-08.parquet size: 12 KB rows: 323
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-12-08 09:30:00 | SPY | ETF | 137.0625 | 137.0625 | 136.25 | 136.9375 | 1274200.0 |
| 2000-12-08 10:00:00 | SPY | ETF | 136.9688 | 137.4062 | 136.7188 | 137.0625 | 887000.0 |
| 2000-12-08 10:30:00 | SPY | ETF | 137.1562 | 137.2812 | 136.5 | 136.7188 | 445100.0 |
| 2000-12-08 11:00:00 | SPY | ETF | 136.7188 | 136.7188 | 136.0938 | 136.4375 | 274200.0 |
| 2000-12-08 11:30:00 | SPY | ETF | 136.4688 | 137.0 | 136.3125 | 136.75 | 364100.0 |
| 2000-12-08 12:00:00 | SPY | ETF | 136.875 | 137.8125 | 136.6562 | 137.25 | 983500.0 |
| 2000-12-08 12:30:00 | SPY | ETF | 137.4062 | 137.7188 | 137.0 | 137.5625 | 225300.0 |
| 2000-12-08 13:00:00 | SPY | ETF | 137.5625 | 137.6562 | 137.2188 | 137.3438 | 169800.0 |
| 2000-12-08 13:30:00 | SPY | ETF | 137.4688 | 137.9375 | 137.3125 | 137.9375 | 468300.0 |
| 2000-12-08 14:00:00 | SPY | ETF | 138.0 | 139.125 | 137.5625 | 137.875 | 1000100.0 |
| 2000-12-08 14:30:00 | SPY | ETF | 138.0 | 138.0625 | 137.0312 | 137.2188 | 675100.0 |
| 2000-12-08 15:00:00 | SPY | ETF | 137.2188 | 137.9688 | 136.875 | 137.625 | 525200.0 |
| 2000-12-08 15:30:00 | SPY | ETF | 137.625 | 137.75 | 137.0312 | 137.6562 | 556200.0 |
| 2000-12-08 16:00:00 | SPY | ETF | 137.75 | 137.9062 | 133.75 | 133.9688 | 1852500.0 |
| 2000-12-08 16:30:00 | SPY | ETF | 133.9688 | 134.5 | 133.5 | 133.8125 | 112400.0 |
| 2000-12-08 17:00:00 | SPY | ETF | 134.0 | 134.3125 | 134.0 | 134.25 | 144100.0 |
| 2000-12-08 17:30:00 | SPY | ETF | 134.125 | 134.25 | 134.125 | 134.25 | 800.0 |
| 2000-12-08 18:00:00 | SPY | ETF | 134.25 | 134.25 | 134.25 | 134.25 | 200.0 |
| 2000-12-08 09:30:00 | QQQ | ETF | 71.0938 | 71.5 | 69.6875 | 71.4375 | 9933800.0 |
| 2000-12-08 10:00:00 | QQQ | ETF | 71.375 | 72.0312 | 71.0312 | 71.375 | 5887500.0 |
| 2000-12-08 10:30:00 | QQQ | ETF | 71.2812 | 71.75 | 70.6875 | 71.0 | 4628800.0 |
| 2000-12-08 11:00:00 | QQQ | ETF | 70.9375 | 71.0625 | 70.2188 | 70.4375 | 3463400.0 |
| 2000-12-08 11:30:00 | QQQ | ETF | 70.375 | 71.1875 | 70.375 | 70.7188 | 2725600.0 |
| 2000-12-08 12:00:00 | QQQ | ETF | 70.6875 | 71.8125 | 70.625 | 71.3125 | 2432700.0 |
| 2000-12-08 12:30:00 | QQQ | ETF | 71.3125 | 71.5938 | 71.0 | 71.4688 | 1462700.0 |
| 2000-12-08 13:00:00 | QQQ | ETF | 71.5 | 71.5 | 71.125 | 71.25 | 1350200.0 |
| 2000-12-08 13:30:00 | QQQ | ETF | 71.2812 | 71.9375 | 71.25 | 71.875 | 1905800.0 |
| 2000-12-08 14:00:00 | QQQ | ETF | 72.0 | 73.5 | 71.5 | 72.0 | 7139000.0 |
| 2000-12-08 14:30:00 | QQQ | ETF | 71.875 | 72.125 | 71.0 | 71.125 | 5701300.0 |
| 2000-12-08 15:00:00 | QQQ | ETF | 71.125 | 71.4688 | 70.375 | 71.0625 | 4989200.0 |
| 2000-12-08 15:30:00 | QQQ | ETF | 71.0 | 72.1875 | 70.9375 | 71.875 | 3776000.0 |
| 2000-12-08 16:00:00 | QQQ | ETF | 72.0625 | 72.25 | 67.625 | 68.375 | 6219300.0 |
| 2000-12-08 16:30:00 | QQQ | ETF | 68.25 | 71.875 | 68.0 | 68.4375 | 380700.0 |
| 2000-12-08 17:00:00 | QQQ | ETF | 68.5 | 68.75 | 68.0 | 68.75 | 195600.0 |
| 2000-12-08 17:30:00 | QQQ | ETF | 68.6875 | 69.0 | 68.5 | 69.0 | 50500.0 |
| 2000-12-08 18:00:00 | QQQ | ETF | 69.0 | 69.3125 | 68.875 | 69.125 | 35000.0 |
| 2000-12-08 09:30:00 | IWM | ETF | 46.9688 | 47.1875 | 46.9688 | 47.1875 | 123000.0 |
| 2000-12-08 10:00:00 | IWM | ETF | 47.3125 | 47.375 | 47.2188 | 47.2812 | 11200.0 |
| 2000-12-08 10:30:00 | IWM | ETF | 47.4375 | 47.4375 | 47.25 | 47.25 | 14800.0 |
| 2000-12-08 11:00:00 | IWM | ETF | 47.375 | 47.375 | 47.25 | 47.2812 | 38400.0 |
| 2000-12-08 11:30:00 | IWM | ETF | 47.25 | 47.3125 | 47.25 | 47.25 | 36400.0 |
| 2000-12-08 12:00:00 | IWM | ETF | 47.2188 | 47.3125 | 47.2188 | 47.3125 | 5800.0 |
| 2000-12-08 12:30:00 | IWM | ETF | 47.2812 | 47.4062 | 47.2812 | 47.4062 | 1000.0 |
| 2000-12-08 13:00:00 | IWM | ETF | 47.4062 | 47.4062 | 47.4062 | 47.4062 | 600.0 |
| 2000-12-08 13:30:00 | IWM | ETF | 47.375 | 47.375 | 47.375 | 47.375 | 800.0 |
| 2000-12-08 14:00:00 | IWM | ETF | 47.5 | 47.75 | 47.25 | 47.75 | 25000.0 |
| 2000-12-08 14:30:00 | IWM | ETF | 47.5625 | 47.5625 | 47.3594 | 47.3594 | 6400.0 |
| 2000-12-08 15:00:00 | IWM | ETF | 47.2969 | 47.5 | 47.25 | 47.5 | 17200.0 |
| 2000-12-08 15:30:00 | IWM | ETF | 47.5938 | 47.7812 | 47.375 | 47.7812 | 6400.0 |
| 2000-12-08 16:00:00 | IWM | ETF | 47.875 | 47.875 | 46.6562 | 46.6562 | 80400.0 |
> showing 50 of 323 rows — these rows as CSV