PREVIEW / etf_30min / 2000-09-25
file: by_date/etf_30min/2000/2000-09-25.parquet size: 11 KB rows: 271
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-09-25 09:30:00 | SPY | ETF | 145.93 | 146.06 | 145.34 | 145.34 | 867500.0 |
| 2000-09-25 10:00:00 | SPY | ETF | 145.46 | 145.71 | 145.18 | 145.56 | 555300.0 |
| 2000-09-25 10:30:00 | SPY | ETF | 145.43 | 145.68 | 145.4 | 145.62 | 216700.0 |
| 2000-09-25 11:00:00 | SPY | ETF | 145.62 | 145.96 | 145.53 | 145.68 | 2234500.0 |
| 2000-09-25 11:30:00 | SPY | ETF | 145.75 | 145.78 | 145.18 | 145.37 | 449600.0 |
| 2000-09-25 12:00:00 | SPY | ETF | 145.31 | 145.34 | 144.9 | 145.25 | 358700.0 |
| 2000-09-25 12:30:00 | SPY | ETF | 145.28 | 145.37 | 145.03 | 145.18 | 456900.0 |
| 2000-09-25 13:00:00 | SPY | ETF | 145.21 | 145.4 | 145.09 | 145.15 | 40700.0 |
| 2000-09-25 13:30:00 | SPY | ETF | 145.12 | 145.18 | 144.71 | 144.96 | 172600.0 |
| 2000-09-25 14:00:00 | SPY | ETF | 144.87 | 144.96 | 144.5 | 144.5 | 93300.0 |
| 2000-09-25 14:30:00 | SPY | ETF | 144.56 | 144.71 | 144.43 | 144.68 | 78500.0 |
| 2000-09-25 15:00:00 | SPY | ETF | 144.62 | 144.9 | 144.06 | 144.28 | 334000.0 |
| 2000-09-25 15:30:00 | SPY | ETF | 144.18 | 144.37 | 143.71 | 144.12 | 1155500.0 |
| 2000-09-25 16:00:00 | SPY | ETF | 144.12 | 144.37 | 144.06 | 144.15 | 210400.0 |
| 2000-09-25 16:30:00 | SPY | ETF | 144.25 | 144.25 | 144.25 | 144.25 | 1000.0 |
| 2000-09-25 09:30:00 | QQQ | ETF | 93.625 | 94.25 | 93.25 | 93.4688 | 3176100.0 |
| 2000-09-25 10:00:00 | QQQ | ETF | 93.4375 | 93.9688 | 93.25 | 93.75 | 2145400.0 |
| 2000-09-25 10:30:00 | QQQ | ETF | 93.6875 | 93.9375 | 93.25 | 93.6875 | 1095700.0 |
| 2000-09-25 11:00:00 | QQQ | ETF | 93.7188 | 94.0938 | 93.5938 | 93.6875 | 779500.0 |
| 2000-09-25 11:30:00 | QQQ | ETF | 93.75 | 93.8438 | 92.75 | 92.875 | 1258400.0 |
| 2000-09-25 12:00:00 | QQQ | ETF | 92.9062 | 92.9375 | 92.375 | 92.8125 | 1334400.0 |
| 2000-09-25 12:30:00 | QQQ | ETF | 92.875 | 93.0938 | 92.625 | 92.8125 | 470600.0 |
| 2000-09-25 13:00:00 | QQQ | ETF | 92.875 | 93.125 | 92.75 | 92.75 | 637500.0 |
| 2000-09-25 13:30:00 | QQQ | ETF | 92.75 | 92.8438 | 92.125 | 92.5625 | 816700.0 |
| 2000-09-25 14:00:00 | QQQ | ETF | 92.5312 | 92.625 | 91.5625 | 91.625 | 1943300.0 |
| 2000-09-25 14:30:00 | QQQ | ETF | 91.625 | 91.9062 | 91.4062 | 91.75 | 1447100.0 |
| 2000-09-25 15:00:00 | QQQ | ETF | 91.8125 | 92.25 | 90.875 | 91.125 | 1889100.0 |
| 2000-09-25 15:30:00 | QQQ | ETF | 91.0312 | 91.3125 | 90.0625 | 90.4688 | 2704200.0 |
| 2000-09-25 16:00:00 | QQQ | ETF | 90.5 | 90.625 | 90.1875 | 90.4375 | 663100.0 |
| 2000-09-25 16:30:00 | QQQ | ETF | 90.0938 | 90.5625 | 90.0938 | 90.5625 | 109300.0 |
| 2000-09-25 17:00:00 | QQQ | ETF | 90.375 | 90.5625 | 90.375 | 90.5 | 2000.0 |
| 2000-09-25 17:30:00 | QQQ | ETF | 90.5 | 90.5625 | 90.375 | 90.375 | 3300.0 |
| 2000-09-25 18:00:00 | QQQ | ETF | 90.1875 | 90.75 | 90.1875 | 90.4688 | 1600.0 |
| 2000-09-25 09:30:00 | IWM | ETF | 52.1719 | 52.1719 | 52.0 | 52.0 | 16400.0 |
| 2000-09-25 10:00:00 | IWM | ETF | 52.0469 | 52.0469 | 52.0312 | 52.0312 | 15800.0 |
| 2000-09-25 10:30:00 | IWM | ETF | 52.0625 | 52.0938 | 52.0625 | 52.0625 | 2000.0 |
| 2000-09-25 11:00:00 | IWM | ETF | 52.0 | 52.125 | 52.0 | 52.125 | 11800.0 |
| 2000-09-25 11:30:00 | IWM | ETF | 52.125 | 52.125 | 51.9688 | 52.0312 | 4000.0 |
| 2000-09-25 12:00:00 | IWM | ETF | 52.0 | 52.0 | 51.8125 | 51.8125 | 31000.0 |
| 2000-09-25 12:30:00 | IWM | ETF | 51.875 | 51.875 | 51.875 | 51.875 | 200.0 |
| 2000-09-25 13:00:00 | IWM | ETF | 51.875 | 51.9062 | 51.875 | 51.9062 | 4200.0 |
| 2000-09-25 13:30:00 | IWM | ETF | 52.0 | 52.0312 | 51.875 | 51.875 | 1600.0 |
| 2000-09-25 14:00:00 | IWM | ETF | 52.0312 | 52.0312 | 51.9062 | 51.9375 | 23200.0 |
| 2000-09-25 14:30:00 | IWM | ETF | 51.7188 | 51.75 | 51.7188 | 51.75 | 3000.0 |
| 2000-09-25 15:30:00 | IWM | ETF | 51.625 | 51.6562 | 51.625 | 51.6562 | 400.0 |
| 2000-09-25 09:30:00 | DIA | ETF | 108.625 | 108.9688 | 108.5 | 108.5 | 88700.0 |
| 2000-09-25 10:00:00 | DIA | ETF | 108.5 | 108.7188 | 108.2812 | 108.6875 | 62900.0 |
| 2000-09-25 10:30:00 | DIA | ETF | 108.5 | 108.7812 | 108.5 | 108.5 | 27500.0 |
| 2000-09-25 11:00:00 | DIA | ETF | 108.5938 | 108.875 | 108.5938 | 108.8438 | 44400.0 |
| 2000-09-25 11:30:00 | DIA | ETF | 108.875 | 108.875 | 108.5312 | 108.625 | 21600.0 |
> showing 50 of 271 rows — these rows as CSV