PREVIEW / etf_30min / 2000-05-18
file: by_date/etf_30min/2000/2000-05-18.parquet size: 9 KB rows: 188
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-05-18 09:30:00 | SPY | ETF | 145.625 | 146.0625 | 145.3438 | 145.8125 | 569100.0 |
| 2000-05-18 10:00:00 | SPY | ETF | 145.7812 | 146.3125 | 145.6875 | 145.7812 | 239500.0 |
| 2000-05-18 10:30:00 | SPY | ETF | 145.9375 | 146.0938 | 145.1875 | 145.4375 | 154600.0 |
| 2000-05-18 11:00:00 | SPY | ETF | 145.5 | 145.5 | 145.125 | 145.1875 | 161400.0 |
| 2000-05-18 11:30:00 | SPY | ETF | 145.2188 | 145.2188 | 144.5625 | 144.8438 | 382800.0 |
| 2000-05-18 12:00:00 | SPY | ETF | 144.6875 | 145.0 | 144.625 | 144.9688 | 209000.0 |
| 2000-05-18 12:30:00 | SPY | ETF | 144.9688 | 145.0625 | 144.75 | 145.0 | 419300.0 |
| 2000-05-18 13:00:00 | SPY | ETF | 144.9375 | 145.0 | 144.375 | 144.625 | 147200.0 |
| 2000-05-18 13:30:00 | SPY | ETF | 144.5 | 144.8438 | 144.5 | 144.6875 | 227400.0 |
| 2000-05-18 14:00:00 | SPY | ETF | 144.6875 | 145.4375 | 144.6875 | 145.2812 | 257500.0 |
| 2000-05-18 14:30:00 | SPY | ETF | 145.25 | 145.2812 | 144.8125 | 144.875 | 304300.0 |
| 2000-05-18 15:00:00 | SPY | ETF | 144.75 | 144.9688 | 144.3125 | 144.5 | 298400.0 |
| 2000-05-18 15:30:00 | SPY | ETF | 144.5 | 144.5625 | 143.9375 | 144.0625 | 556600.0 |
| 2000-05-18 16:00:00 | SPY | ETF | 144.0312 | 144.3438 | 143.8125 | 143.8125 | 382000.0 |
| 2000-05-18 18:00:00 | SPY | ETF | 143.375 | 143.375 | 143.375 | 143.375 | 300.0 |
| 2000-05-18 09:30:00 | QQQ | ETF | 89.0 | 89.3438 | 87.6875 | 88.625 | 1857600.0 |
| 2000-05-18 10:00:00 | QQQ | ETF | 88.625 | 89.125 | 88.25 | 88.625 | 1485000.0 |
| 2000-05-18 10:30:00 | QQQ | ETF | 88.625 | 89.0 | 88.0 | 88.5 | 969700.0 |
| 2000-05-18 11:00:00 | QQQ | ETF | 88.5625 | 88.5938 | 87.5312 | 87.5312 | 971100.0 |
| 2000-05-18 11:30:00 | QQQ | ETF | 87.5312 | 87.7188 | 86.6875 | 87.0 | 2139700.0 |
| 2000-05-18 12:00:00 | QQQ | ETF | 86.9375 | 87.5 | 86.875 | 87.5 | 1696400.0 |
| 2000-05-18 12:30:00 | QQQ | ETF | 87.4688 | 87.625 | 87.25 | 87.5 | 754500.0 |
| 2000-05-18 13:00:00 | QQQ | ETF | 87.5938 | 87.625 | 86.875 | 87.0625 | 786700.0 |
| 2000-05-18 13:30:00 | QQQ | ETF | 87.125 | 87.2812 | 86.875 | 87.125 | 628000.0 |
| 2000-05-18 14:00:00 | QQQ | ETF | 87.125 | 87.9688 | 86.875 | 87.6875 | 1231500.0 |
| 2000-05-18 14:30:00 | QQQ | ETF | 87.625 | 87.75 | 87.0625 | 87.125 | 787100.0 |
| 2000-05-18 15:00:00 | QQQ | ETF | 87.125 | 87.375 | 86.3125 | 86.5 | 1952700.0 |
| 2000-05-18 15:30:00 | QQQ | ETF | 86.3438 | 86.5 | 85.5625 | 85.625 | 2657700.0 |
| 2000-05-18 16:00:00 | QQQ | ETF | 85.625 | 85.875 | 85.375 | 85.5 | 995600.0 |
| 2000-05-18 16:30:00 | QQQ | ETF | 85.8125 | 85.875 | 85.5 | 85.875 | 11800.0 |
| 2000-05-18 17:00:00 | QQQ | ETF | 85.625 | 85.875 | 85.625 | 85.875 | 1800.0 |
| 2000-05-18 17:30:00 | QQQ | ETF | 85.875 | 85.875 | 85.875 | 85.875 | 800.0 |
| 2000-05-18 18:00:00 | QQQ | ETF | 85.75 | 85.75 | 85.75 | 85.75 | 100.0 |
| 2000-05-18 09:30:00 | DIA | ETF | 108.0312 | 108.5938 | 107.9062 | 108.5625 | 63500.0 |
| 2000-05-18 10:00:00 | DIA | ETF | 108.5312 | 108.8125 | 108.3438 | 108.3438 | 132800.0 |
| 2000-05-18 10:30:00 | DIA | ETF | 108.5 | 108.5 | 108.0 | 108.375 | 23100.0 |
| 2000-05-18 11:00:00 | DIA | ETF | 108.3438 | 108.375 | 108.0625 | 108.125 | 70500.0 |
| 2000-05-18 11:30:00 | DIA | ETF | 108.0625 | 108.25 | 107.6875 | 107.8438 | 99200.0 |
| 2000-05-18 12:00:00 | DIA | ETF | 107.875 | 108.1562 | 107.875 | 108.0312 | 17200.0 |
| 2000-05-18 12:30:00 | DIA | ETF | 108.1875 | 108.25 | 108.0312 | 108.25 | 11800.0 |
| 2000-05-18 13:00:00 | DIA | ETF | 108.0938 | 108.3438 | 107.8438 | 107.8438 | 65600.0 |
| 2000-05-18 13:30:00 | DIA | ETF | 107.8438 | 108.125 | 107.8438 | 107.9688 | 39800.0 |
| 2000-05-18 14:00:00 | DIA | ETF | 107.9688 | 108.5938 | 107.9688 | 108.3125 | 60700.0 |
| 2000-05-18 14:30:00 | DIA | ETF | 108.5 | 108.5 | 108.0312 | 108.3125 | 78600.0 |
| 2000-05-18 15:00:00 | DIA | ETF | 108.2812 | 108.3125 | 107.9375 | 108.2188 | 51900.0 |
| 2000-05-18 15:30:00 | DIA | ETF | 107.9375 | 108.0625 | 107.5625 | 107.75 | 123800.0 |
| 2000-05-18 16:00:00 | DIA | ETF | 107.9062 | 107.9062 | 107.4062 | 107.4375 | 91800.0 |
> showing 47 of 188 rows — these rows as CSV