PREVIEW / etf_1hour / 2000-03-24
file: by_date/etf_1hour/2000/2000-03-24.parquet size: 8 KB rows: 128
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-03-24 09:00:00 | SPY | ETF | 152.875 | 153.5938 | 152.5625 | 153.25 | 964800.0 |
| 2000-03-24 10:00:00 | SPY | ETF | 153.4375 | 155.75 | 153.25 | 155.5312 | 3069000.0 |
| 2000-03-24 11:00:00 | SPY | ETF | 155.375 | 155.5312 | 154.375 | 154.75 | 1406000.0 |
| 2000-03-24 12:00:00 | SPY | ETF | 154.75 | 154.9062 | 153.9688 | 154.2188 | 930900.0 |
| 2000-03-24 13:00:00 | SPY | ETF | 154.25 | 154.4062 | 153.0625 | 153.1875 | 1107800.0 |
| 2000-03-24 14:00:00 | SPY | ETF | 153.1875 | 153.7188 | 152.3438 | 152.4375 | 772700.0 |
| 2000-03-24 15:00:00 | SPY | ETF | 152.5 | 153.4688 | 151.7188 | 153.2812 | 2883300.0 |
| 2000-03-24 16:00:00 | SPY | ETF | 153.0625 | 153.625 | 153.0625 | 153.5625 | 256400.0 |
| 2000-03-24 09:00:00 | QQQ | ETF | 117.4688 | 118.4688 | 116.875 | 118.375 | 2606700.0 |
| 2000-03-24 10:00:00 | QQQ | ETF | 118.375 | 120.5 | 118.0312 | 120.25 | 4331000.0 |
| 2000-03-24 11:00:00 | QQQ | ETF | 120.125 | 120.3125 | 119.125 | 119.625 | 2077600.0 |
| 2000-03-24 12:00:00 | QQQ | ETF | 119.5625 | 119.75 | 118.75 | 119.0 | 1563000.0 |
| 2000-03-24 13:00:00 | QQQ | ETF | 119.0 | 119.5 | 117.0 | 117.0 | 2586500.0 |
| 2000-03-24 14:00:00 | QQQ | ETF | 117.0 | 117.8125 | 115.6875 | 116.3125 | 4396100.0 |
| 2000-03-24 15:00:00 | QQQ | ETF | 116.3125 | 117.7188 | 115.0312 | 117.25 | 4036300.0 |
| 2000-03-24 16:00:00 | QQQ | ETF | 117.25 | 118.0312 | 117.0 | 118.0 | 354200.0 |
| 2000-03-24 17:00:00 | QQQ | ETF | 117.75 | 118.0 | 117.5625 | 118.0 | 1800.0 |
| 2000-03-24 18:00:00 | QQQ | ETF | 117.6875 | 117.6875 | 117.5625 | 117.5625 | 400.0 |
| 2000-03-24 09:00:00 | DIA | ETF | 110.5312 | 111.0 | 110.2812 | 110.6562 | 239300.0 |
| 2000-03-24 10:00:00 | DIA | ETF | 110.5 | 112.4688 | 110.5 | 112.375 | 457700.0 |
| 2000-03-24 11:00:00 | DIA | ETF | 112.3438 | 112.3438 | 111.5 | 111.8438 | 230600.0 |
| 2000-03-24 12:00:00 | DIA | ETF | 111.8125 | 111.9062 | 111.1875 | 111.2812 | 109800.0 |
| 2000-03-24 13:00:00 | DIA | ETF | 111.2812 | 111.5938 | 110.8125 | 111.0 | 208400.0 |
| 2000-03-24 14:00:00 | DIA | ETF | 110.8438 | 111.4688 | 110.5 | 110.75 | 166200.0 |
| 2000-03-24 15:00:00 | DIA | ETF | 110.875 | 111.4688 | 110.2812 | 111.1562 | 446100.0 |
| 2000-03-24 16:00:00 | DIA | ETF | 111.375 | 111.75 | 111.125 | 111.125 | 25300.0 |
> showing 26 of 128 rows — these rows as CSV