PREVIEW / etf_30min / 2000-05-05
file: by_date/etf_30min/2000/2000-05-05.parquet size: 9 KB rows: 171
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-05 09:30:00 | SPY | ETF | 141.0625 | 142.25 | 140.9375 | 141.6875 | 1531400.0 |
| 2000-05-05 10:00:00 | SPY | ETF | 141.5 | 143.3125 | 141.4375 | 143.0 | 791900.0 |
| 2000-05-05 10:30:00 | SPY | ETF | 143.125 | 144.0 | 142.9688 | 143.375 | 953300.0 |
| 2000-05-05 11:00:00 | SPY | ETF | 143.375 | 143.5938 | 143.125 | 143.5 | 128200.0 |
| 2000-05-05 11:30:00 | SPY | ETF | 143.5938 | 143.625 | 143.0 | 143.25 | 132200.0 |
| 2000-05-05 12:00:00 | SPY | ETF | 143.25 | 143.4062 | 143.0625 | 143.25 | 567600.0 |
| 2000-05-05 12:30:00 | SPY | ETF | 143.2188 | 143.3125 | 142.9375 | 143.1875 | 191900.0 |
| 2000-05-05 13:00:00 | SPY | ETF | 143.1875 | 143.4688 | 142.9375 | 143.4688 | 288800.0 |
| 2000-05-05 13:30:00 | SPY | ETF | 143.4688 | 143.5625 | 143.125 | 143.125 | 245900.0 |
| 2000-05-05 14:00:00 | SPY | ETF | 143.2812 | 143.6875 | 143.1875 | 143.6875 | 115900.0 |
| 2000-05-05 14:30:00 | SPY | ETF | 143.6875 | 143.875 | 143.0625 | 143.2812 | 85800.0 |
| 2000-05-05 15:00:00 | SPY | ETF | 143.4062 | 143.4375 | 142.625 | 143.0 | 303100.0 |
| 2000-05-05 15:30:00 | SPY | ETF | 142.9375 | 143.6875 | 142.7188 | 143.3438 | 1001600.0 |
| 2000-05-05 16:00:00 | SPY | ETF | 143.5625 | 143.75 | 143.3125 | 143.5312 | 446600.0 |
| 2000-05-05 09:30:00 | QQQ | ETF | 88.125 | 90.5625 | 88.0312 | 90.125 | 5046200.0 |
| 2000-05-05 10:00:00 | QQQ | ETF | 89.75 | 91.9375 | 89.5 | 91.4375 | 3491100.0 |
| 2000-05-05 10:30:00 | QQQ | ETF | 91.4375 | 92.3125 | 91.1875 | 91.6875 | 1758900.0 |
| 2000-05-05 11:00:00 | QQQ | ETF | 91.625 | 91.875 | 91.25 | 91.625 | 968900.0 |
| 2000-05-05 11:30:00 | QQQ | ETF | 91.7812 | 91.875 | 91.0 | 91.25 | 761900.0 |
| 2000-05-05 12:00:00 | QQQ | ETF | 91.25 | 91.6562 | 91.125 | 91.125 | 513300.0 |
| 2000-05-05 12:30:00 | QQQ | ETF | 91.125 | 91.4688 | 90.8125 | 91.25 | 810000.0 |
| 2000-05-05 13:00:00 | QQQ | ETF | 91.25 | 91.625 | 91.0312 | 91.5 | 580000.0 |
| 2000-05-05 13:30:00 | QQQ | ETF | 91.5 | 91.8125 | 91.3125 | 91.3125 | 744000.0 |
| 2000-05-05 14:00:00 | QQQ | ETF | 91.3125 | 91.875 | 91.25 | 91.875 | 527900.0 |
| 2000-05-05 14:30:00 | QQQ | ETF | 91.8125 | 92.125 | 91.25 | 91.625 | 1173900.0 |
| 2000-05-05 15:00:00 | QQQ | ETF | 91.6875 | 91.75 | 90.5 | 91.125 | 1245900.0 |
| 2000-05-05 15:30:00 | QQQ | ETF | 91.25 | 92.1875 | 90.875 | 92.0 | 2343200.0 |
| 2000-05-05 16:00:00 | QQQ | ETF | 92.0 | 92.125 | 91.25 | 91.25 | 497600.0 |
| 2000-05-05 16:30:00 | QQQ | ETF | 91.5 | 91.5 | 91.5 | 91.5 | 700.0 |
| 2000-05-05 17:00:00 | QQQ | ETF | 91.5 | 91.5 | 91.5 | 91.5 | 1400.0 |
| 2000-05-05 17:30:00 | QQQ | ETF | 91.4375 | 91.4375 | 91.4375 | 91.4375 | 2000.0 |
| 2000-05-05 09:30:00 | DIA | ETF | 103.3125 | 104.8125 | 103.3125 | 104.0938 | 278700.0 |
| 2000-05-05 10:00:00 | DIA | ETF | 104.0625 | 105.375 | 103.9062 | 105.0 | 173500.0 |
| 2000-05-05 10:30:00 | DIA | ETF | 104.9375 | 105.875 | 104.9375 | 105.5938 | 90400.0 |
| 2000-05-05 11:00:00 | DIA | ETF | 105.5938 | 105.6875 | 105.375 | 105.5938 | 191100.0 |
| 2000-05-05 11:30:00 | DIA | ETF | 105.5 | 105.5625 | 105.1875 | 105.375 | 114100.0 |
| 2000-05-05 12:00:00 | DIA | ETF | 105.375 | 105.4688 | 105.25 | 105.3125 | 6800.0 |
| 2000-05-05 12:30:00 | DIA | ETF | 105.25 | 105.4062 | 105.0 | 105.4062 | 57300.0 |
| 2000-05-05 13:00:00 | DIA | ETF | 105.3125 | 105.5938 | 105.125 | 105.4375 | 46600.0 |
| 2000-05-05 13:30:00 | DIA | ETF | 105.4688 | 105.5625 | 105.25 | 105.25 | 9200.0 |
| 2000-05-05 14:00:00 | DIA | ETF | 105.375 | 105.6562 | 105.2812 | 105.6562 | 36900.0 |
| 2000-05-05 14:30:00 | DIA | ETF | 105.7188 | 105.8125 | 105.2812 | 105.4375 | 19300.0 |
| 2000-05-05 15:00:00 | DIA | ETF | 105.4375 | 105.5625 | 105.125 | 105.1875 | 64500.0 |
| 2000-05-05 15:30:00 | DIA | ETF | 105.25 | 105.875 | 105.0938 | 105.4688 | 202800.0 |
| 2000-05-05 16:00:00 | DIA | ETF | 105.6562 | 105.8438 | 105.4688 | 105.8438 | 60200.0 |
> showing 45 of 171 rows — these rows as CSV