PREVIEW / etf_30min / 2000-01-03
file: by_date/etf_30min/2000/2000-01-03.parquet size: 10 KB rows: 227
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-01-03 09:30:00 | SPY | ETF | 148.25 | 148.25 | 146.4688 | 146.625 | 963000.0 |
| 2000-01-03 10:00:00 | SPY | ETF | 146.8125 | 147.25 | 146.5625 | 146.9688 | 673000.0 |
| 2000-01-03 10:30:00 | SPY | ETF | 146.9688 | 146.9688 | 144.4062 | 144.625 | 784100.0 |
| 2000-01-03 11:00:00 | SPY | ETF | 144.6875 | 144.6875 | 143.875 | 144.25 | 872600.0 |
| 2000-01-03 11:30:00 | SPY | ETF | 144.4375 | 144.9062 | 144.3438 | 144.75 | 156300.0 |
| 2000-01-03 12:00:00 | SPY | ETF | 144.6875 | 144.9375 | 144.1562 | 144.4375 | 455000.0 |
| 2000-01-03 12:30:00 | SPY | ETF | 144.4688 | 144.6875 | 144.0625 | 144.5312 | 185000.0 |
| 2000-01-03 13:00:00 | SPY | ETF | 144.5625 | 144.8438 | 144.1875 | 144.625 | 922100.0 |
| 2000-01-03 13:30:00 | SPY | ETF | 144.6875 | 145.1562 | 144.5312 | 144.7188 | 367300.0 |
| 2000-01-03 14:00:00 | SPY | ETF | 144.6562 | 145.0938 | 144.25 | 144.5 | 341000.0 |
| 2000-01-03 14:30:00 | SPY | ETF | 144.5938 | 144.9688 | 144.3438 | 144.7812 | 204300.0 |
| 2000-01-03 15:00:00 | SPY | ETF | 144.6562 | 145.0625 | 144.5938 | 144.8125 | 697700.0 |
| 2000-01-03 15:30:00 | SPY | ETF | 144.8125 | 145.5625 | 144.7812 | 145.5625 | 1061700.0 |
| 2000-01-03 16:00:00 | SPY | ETF | 145.5625 | 145.625 | 145.375 | 145.4375 | 429600.0 |
| 2000-01-03 09:30:00 | QQQ | ETF | 96.1875 | 96.1875 | 93.125 | 93.2188 | 7919800.0 |
| 2000-01-03 10:00:00 | QQQ | ETF | 93.25 | 94.3438 | 93.125 | 94.0 | 4132800.0 |
| 2000-01-03 10:30:00 | QQQ | ETF | 94.0 | 94.2188 | 91.0 | 91.6875 | 4234200.0 |
| 2000-01-03 11:00:00 | QQQ | ETF | 91.7188 | 92.25 | 90.75 | 92.25 | 3779400.0 |
| 2000-01-03 11:30:00 | QQQ | ETF | 92.375 | 93.1562 | 92.125 | 92.9062 | 3349200.0 |
| 2000-01-03 12:00:00 | QQQ | ETF | 92.875 | 93.0 | 92.2656 | 92.625 | 1220800.0 |
| 2000-01-03 12:30:00 | QQQ | ETF | 92.6406 | 92.8438 | 92.125 | 92.6406 | 785600.0 |
| 2000-01-03 13:00:00 | QQQ | ETF | 92.7031 | 93.125 | 92.4375 | 93.0781 | 685400.0 |
| 2000-01-03 13:30:00 | QQQ | ETF | 93.0781 | 93.75 | 92.8125 | 93.375 | 2124400.0 |
| 2000-01-03 14:00:00 | QQQ | ETF | 93.3594 | 93.75 | 92.75 | 92.9219 | 1481200.0 |
| 2000-01-03 14:30:00 | QQQ | ETF | 92.9375 | 93.75 | 92.9062 | 93.0625 | 1504600.0 |
| 2000-01-03 15:00:00 | QQQ | ETF | 93.1094 | 93.75 | 93.1094 | 93.4688 | 1111000.0 |
| 2000-01-03 15:30:00 | QQQ | ETF | 93.3906 | 94.75 | 93.2812 | 94.75 | 2950400.0 |
| 2000-01-03 16:00:00 | QQQ | ETF | 94.5 | 94.8594 | 94.5 | 94.75 | 664200.0 |
| 2000-01-03 16:30:00 | QQQ | ETF | 94.7188 | 94.75 | 94.7188 | 94.75 | 12600.0 |
| 2000-01-03 09:30:00 | DIA | ETF | 116.0312 | 116.0312 | 114.9375 | 114.9375 | 306700.0 |
| 2000-01-03 10:00:00 | DIA | ETF | 114.9375 | 115.375 | 114.9375 | 115.0312 | 27200.0 |
| 2000-01-03 10:30:00 | DIA | ETF | 115.0 | 115.0625 | 113.2812 | 113.625 | 178100.0 |
| 2000-01-03 11:00:00 | DIA | ETF | 113.5312 | 113.7188 | 113.0 | 113.6875 | 123400.0 |
| 2000-01-03 11:30:00 | DIA | ETF | 113.5625 | 113.7812 | 113.5 | 113.5 | 40400.0 |
| 2000-01-03 12:00:00 | DIA | ETF | 113.6562 | 113.7812 | 113.25 | 113.625 | 45600.0 |
| 2000-01-03 12:30:00 | DIA | ETF | 113.4375 | 113.625 | 113.25 | 113.5312 | 8600.0 |
| 2000-01-03 13:00:00 | DIA | ETF | 113.5 | 113.7188 | 113.2812 | 113.5625 | 13300.0 |
| 2000-01-03 13:30:00 | DIA | ETF | 113.6875 | 113.875 | 113.4375 | 113.625 | 35500.0 |
| 2000-01-03 14:00:00 | DIA | ETF | 113.625 | 113.7188 | 113.1875 | 113.375 | 46600.0 |
| 2000-01-03 14:30:00 | DIA | ETF | 113.375 | 113.625 | 113.1875 | 113.375 | 68900.0 |
| 2000-01-03 15:00:00 | DIA | ETF | 113.5312 | 113.7812 | 113.2812 | 113.5625 | 96200.0 |
| 2000-01-03 15:30:00 | DIA | ETF | 113.4688 | 113.9375 | 113.3438 | 113.6562 | 274200.0 |
| 2000-01-03 16:00:00 | DIA | ETF | 113.5 | 113.5 | 113.4688 | 113.5 | 5900.0 |
> showing 43 of 227 rows — these rows as CSV