PREVIEW / etf_30min / 2000-12-18
file: by_date/etf_30min/2000/2000-12-18.parquet size: 12 KB rows: 322
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-18 09:30:00 | SPY | ETF | 132.0625 | 133.0625 | 132.0625 | 132.5625 | 963500.0 |
| 2000-12-18 10:00:00 | SPY | ETF | 132.5 | 133.4062 | 132.4688 | 133.2188 | 462200.0 |
| 2000-12-18 10:30:00 | SPY | ETF | 133.0938 | 133.4688 | 132.5625 | 132.8438 | 569600.0 |
| 2000-12-18 11:00:00 | SPY | ETF | 132.9375 | 133.25 | 132.5 | 132.5625 | 343700.0 |
| 2000-12-18 11:30:00 | SPY | ETF | 132.6562 | 132.9375 | 132.1875 | 132.7188 | 494600.0 |
| 2000-12-18 12:00:00 | SPY | ETF | 132.7188 | 132.8438 | 132.125 | 132.4062 | 304900.0 |
| 2000-12-18 12:30:00 | SPY | ETF | 132.3125 | 132.875 | 132.3125 | 132.7812 | 346300.0 |
| 2000-12-18 13:00:00 | SPY | ETF | 132.8125 | 133.2188 | 132.5625 | 132.8125 | 604400.0 |
| 2000-12-18 13:30:00 | SPY | ETF | 132.8438 | 133.0 | 132.5 | 132.8125 | 357000.0 |
| 2000-12-18 14:00:00 | SPY | ETF | 132.875 | 132.9688 | 132.5 | 132.625 | 204000.0 |
| 2000-12-18 14:30:00 | SPY | ETF | 132.5625 | 132.875 | 132.3438 | 132.5625 | 378900.0 |
| 2000-12-18 15:00:00 | SPY | ETF | 132.5938 | 132.625 | 131.8438 | 131.9375 | 615100.0 |
| 2000-12-18 15:30:00 | SPY | ETF | 131.875 | 132.5312 | 131.75 | 132.375 | 723800.0 |
| 2000-12-18 16:00:00 | SPY | ETF | 132.4688 | 132.9688 | 132.3125 | 132.7188 | 393600.0 |
| 2000-12-18 16:30:00 | SPY | ETF | 132.7188 | 132.7188 | 132.7188 | 132.7188 | 700.0 |
| 2000-12-18 09:30:00 | QQQ | ETF | 65.1562 | 65.9688 | 64.75 | 64.875 | 7915700.0 |
| 2000-12-18 10:00:00 | QQQ | ETF | 64.875 | 65.875 | 64.8125 | 65.4375 | 4909800.0 |
| 2000-12-18 10:30:00 | QQQ | ETF | 65.375 | 65.625 | 64.3125 | 64.6562 | 3699400.0 |
| 2000-12-18 11:00:00 | QQQ | ETF | 64.625 | 64.9375 | 63.375 | 63.4375 | 3232500.0 |
| 2000-12-18 11:30:00 | QQQ | ETF | 63.5 | 63.8125 | 62.8125 | 63.5625 | 3222400.0 |
| 2000-12-18 12:00:00 | QQQ | ETF | 63.5625 | 63.75 | 62.75 | 63.1875 | 2008400.0 |
| 2000-12-18 12:30:00 | QQQ | ETF | 63.1875 | 64.0 | 63.0625 | 63.875 | 1525500.0 |
| 2000-12-18 13:00:00 | QQQ | ETF | 63.8125 | 64.625 | 63.625 | 63.875 | 2615000.0 |
| 2000-12-18 13:30:00 | QQQ | ETF | 63.9375 | 64.1562 | 63.375 | 63.8125 | 1550100.0 |
| 2000-12-18 14:00:00 | QQQ | ETF | 63.8438 | 64.25 | 63.5 | 63.625 | 1273600.0 |
| 2000-12-18 14:30:00 | QQQ | ETF | 63.6875 | 64.125 | 63.25 | 63.7188 | 1736800.0 |
| 2000-12-18 15:00:00 | QQQ | ETF | 63.75 | 63.8125 | 62.75 | 62.75 | 2571400.0 |
| 2000-12-18 15:30:00 | QQQ | ETF | 62.75 | 63.5 | 62.5625 | 63.375 | 3456500.0 |
| 2000-12-18 16:00:00 | QQQ | ETF | 63.4375 | 64.0938 | 63.3125 | 64.0 | 964700.0 |
| 2000-12-18 16:30:00 | QQQ | ETF | 64.0 | 64.1875 | 63.75 | 64.125 | 28400.0 |
| 2000-12-18 17:00:00 | QQQ | ETF | 64.125 | 64.25 | 64.0625 | 64.25 | 20000.0 |
| 2000-12-18 17:30:00 | QQQ | ETF | 64.125 | 64.1875 | 64.0 | 64.1875 | 106800.0 |
| 2000-12-18 18:00:00 | QQQ | ETF | 64.1875 | 64.5 | 64.0938 | 64.125 | 216800.0 |
| 2000-12-18 09:30:00 | IWM | ETF | 45.8438 | 46.3125 | 45.8438 | 46.125 | 102000.0 |
| 2000-12-18 10:00:00 | IWM | ETF | 46.0156 | 46.4688 | 46.0156 | 46.4062 | 18000.0 |
| 2000-12-18 10:30:00 | IWM | ETF | 46.25 | 46.25 | 46.1875 | 46.2188 | 4800.0 |
| 2000-12-18 11:00:00 | IWM | ETF | 46.0312 | 46.0312 | 45.9844 | 45.9844 | 18000.0 |
| 2000-12-18 11:30:00 | IWM | ETF | 45.9844 | 46.0 | 45.8125 | 46.0 | 15800.0 |
| 2000-12-18 12:00:00 | IWM | ETF | 46.0156 | 46.0156 | 45.8125 | 45.8125 | 800.0 |
| 2000-12-18 13:00:00 | IWM | ETF | 46.1562 | 46.1562 | 46.0 | 46.0 | 5600.0 |
| 2000-12-18 13:30:00 | IWM | ETF | 46.0625 | 46.2188 | 46.0625 | 46.125 | 3000.0 |
| 2000-12-18 14:00:00 | IWM | ETF | 46.1562 | 46.1562 | 46.0156 | 46.1562 | 6400.0 |
| 2000-12-18 14:30:00 | IWM | ETF | 46.1562 | 46.1875 | 46.125 | 46.125 | 3800.0 |
| 2000-12-18 15:00:00 | IWM | ETF | 46.0312 | 46.0938 | 45.875 | 45.875 | 16400.0 |
| 2000-12-18 15:30:00 | IWM | ETF | 46.0 | 46.1875 | 45.8125 | 46.1875 | 19600.0 |
| 2000-12-18 16:00:00 | IWM | ETF | 46.25 | 46.3125 | 46.25 | 46.3125 | 24200.0 |
| 2000-12-18 09:30:00 | DIA | ETF | 105.4375 | 105.875 | 105.4062 | 105.6875 | 544800.0 |
| 2000-12-18 10:00:00 | DIA | ETF | 105.625 | 106.25 | 105.5625 | 106.0 | 106600.0 |
| 2000-12-18 10:30:00 | DIA | ETF | 105.9688 | 106.3438 | 105.75 | 106.0312 | 127200.0 |
| 2000-12-18 11:00:00 | DIA | ETF | 106.0938 | 106.3438 | 106.0 | 106.0625 | 189500.0 |
> showing 50 of 322 rows — these rows as CSV