PREVIEW / etf_30min / 2000-07-17
file: by_date/etf_30min/2000/2000-07-17.parquet size: 11 KB rows: 280
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-07-17 09:30:00 | SPY | ETF | 150.9688 | 151.1875 | 150.75 | 151.0625 | 627800.0 |
| 2000-07-17 10:00:00 | SPY | ETF | 151.0 | 151.1875 | 150.6875 | 151.0 | 384100.0 |
| 2000-07-17 10:30:00 | SPY | ETF | 151.0 | 151.2812 | 150.8438 | 150.875 | 109900.0 |
| 2000-07-17 11:00:00 | SPY | ETF | 151.0 | 151.375 | 151.0 | 151.2188 | 316600.0 |
| 2000-07-17 11:30:00 | SPY | ETF | 151.3438 | 151.5938 | 151.1562 | 151.3438 | 92000.0 |
| 2000-07-17 12:00:00 | SPY | ETF | 151.3438 | 151.5 | 151.3125 | 151.5 | 296200.0 |
| 2000-07-17 12:30:00 | SPY | ETF | 151.5 | 151.625 | 151.375 | 151.5 | 134900.0 |
| 2000-07-17 13:00:00 | SPY | ETF | 151.5 | 151.7812 | 151.4375 | 151.7188 | 93000.0 |
| 2000-07-17 13:30:00 | SPY | ETF | 151.625 | 151.9375 | 151.5312 | 151.9375 | 125700.0 |
| 2000-07-17 14:00:00 | SPY | ETF | 151.8125 | 151.9688 | 151.6875 | 151.875 | 234100.0 |
| 2000-07-17 14:30:00 | SPY | ETF | 151.9688 | 151.9688 | 151.5625 | 151.75 | 339600.0 |
| 2000-07-17 15:00:00 | SPY | ETF | 151.7188 | 151.9688 | 151.4375 | 151.8125 | 230000.0 |
| 2000-07-17 15:30:00 | SPY | ETF | 151.875 | 151.9688 | 151.0625 | 151.0625 | 362400.0 |
| 2000-07-17 16:00:00 | SPY | ETF | 151.2188 | 151.2188 | 150.8438 | 150.875 | 1123300.0 |
| 2000-07-17 16:30:00 | SPY | ETF | 151.0 | 151.0 | 151.0 | 151.0 | 300.0 |
| 2000-07-17 09:30:00 | QQQ | ETF | 100.9375 | 100.9375 | 100.0 | 100.3438 | 1821700.0 |
| 2000-07-17 10:00:00 | QQQ | ETF | 100.4375 | 100.75 | 99.875 | 100.5625 | 1782600.0 |
| 2000-07-17 10:30:00 | QQQ | ETF | 100.625 | 101.125 | 100.4062 | 100.875 | 954800.0 |
| 2000-07-17 11:00:00 | QQQ | ETF | 100.875 | 101.8125 | 100.875 | 101.6875 | 993500.0 |
| 2000-07-17 11:30:00 | QQQ | ETF | 101.7188 | 101.875 | 101.5 | 101.8125 | 895200.0 |
| 2000-07-17 12:00:00 | QQQ | ETF | 101.8125 | 102.0625 | 101.375 | 101.5625 | 991600.0 |
| 2000-07-17 12:30:00 | QQQ | ETF | 101.5625 | 101.8125 | 101.3125 | 101.5 | 554200.0 |
| 2000-07-17 13:00:00 | QQQ | ETF | 101.4375 | 101.875 | 101.375 | 101.5625 | 583400.0 |
| 2000-07-17 13:30:00 | QQQ | ETF | 101.5625 | 102.0 | 101.4375 | 101.9375 | 740700.0 |
| 2000-07-17 14:00:00 | QQQ | ETF | 101.875 | 102.0625 | 101.6875 | 101.8125 | 561500.0 |
| 2000-07-17 14:30:00 | QQQ | ETF | 102.0 | 102.0 | 101.25 | 101.375 | 790000.0 |
| 2000-07-17 15:00:00 | QQQ | ETF | 101.3438 | 101.875 | 101.125 | 101.6562 | 887300.0 |
| 2000-07-17 15:30:00 | QQQ | ETF | 101.6875 | 101.875 | 101.4375 | 101.5 | 951000.0 |
| 2000-07-17 16:00:00 | QQQ | ETF | 101.4688 | 101.5625 | 101.375 | 101.4375 | 360200.0 |
| 2000-07-17 16:30:00 | QQQ | ETF | 101.125 | 101.375 | 101.125 | 101.375 | 201300.0 |
| 2000-07-17 17:00:00 | QQQ | ETF | 101.5 | 101.5 | 101.25 | 101.5 | 1200.0 |
| 2000-07-17 17:30:00 | QQQ | ETF | 101.5 | 101.5 | 101.0 | 101.0 | 25300.0 |
| 2000-07-17 18:00:00 | QQQ | ETF | 102.0 | 102.0 | 101.375 | 101.75 | 3100.0 |
| 2000-07-17 09:30:00 | IWM | ETF | 54.3594 | 54.3594 | 54.2188 | 54.2188 | 4200.0 |
| 2000-07-17 10:00:00 | IWM | ETF | 54.3125 | 54.3281 | 54.3125 | 54.3281 | 4200.0 |
| 2000-07-17 10:30:00 | IWM | ETF | 54.3281 | 54.3438 | 54.3281 | 54.3438 | 400.0 |
| 2000-07-17 11:30:00 | IWM | ETF | 54.4688 | 54.4688 | 54.4688 | 54.4688 | 20000.0 |
| 2000-07-17 12:00:00 | IWM | ETF | 54.4844 | 54.5 | 54.4844 | 54.5 | 1600.0 |
| 2000-07-17 13:30:00 | IWM | ETF | 54.5469 | 54.5469 | 54.5469 | 54.5469 | 400.0 |
| 2000-07-17 14:00:00 | IWM | ETF | 54.5781 | 54.5781 | 54.5 | 54.5 | 2800.0 |
| 2000-07-17 14:30:00 | IWM | ETF | 54.5938 | 54.5938 | 54.5938 | 54.5938 | 2000.0 |
| 2000-07-17 15:30:00 | IWM | ETF | 54.5625 | 54.5625 | 54.4375 | 54.5 | 11000.0 |
| 2000-07-17 09:30:00 | DIA | ETF | 107.875 | 108.4375 | 107.875 | 108.1875 | 76600.0 |
| 2000-07-17 10:00:00 | DIA | ETF | 108.1562 | 108.1562 | 107.75 | 107.9375 | 19800.0 |
| 2000-07-17 10:30:00 | DIA | ETF | 107.75 | 108.0 | 107.5625 | 107.6875 | 31300.0 |
| 2000-07-17 11:00:00 | DIA | ETF | 107.75 | 107.9062 | 107.6875 | 107.9062 | 8100.0 |
| 2000-07-17 11:30:00 | DIA | ETF | 107.75 | 107.9062 | 107.6875 | 107.875 | 16300.0 |
| 2000-07-17 12:00:00 | DIA | ETF | 107.9062 | 108.1875 | 107.875 | 108.0 | 73400.0 |
| 2000-07-17 12:30:00 | DIA | ETF | 108.125 | 108.25 | 108.0312 | 108.125 | 12500.0 |
| 2000-07-17 13:00:00 | DIA | ETF | 108.25 | 108.5 | 108.25 | 108.3125 | 44900.0 |
> showing 50 of 280 rows — these rows as CSV