PREVIEW / etf_1hour / 2000-04-13
file: by_date/etf_1hour/2000/2000-04-13.parquet size: 8 KB rows: 122
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-04-13 09:00:00 | SPY | ETF | 147.4688 | 147.5625 | 145.1562 | 146.7188 | 2586000.0 |
| 2000-04-13 10:00:00 | SPY | ETF | 146.9375 | 147.9688 | 145.6562 | 146.5 | 2699900.0 |
| 2000-04-13 11:00:00 | SPY | ETF | 146.5625 | 147.5 | 145.9375 | 147.0938 | 1097600.0 |
| 2000-04-13 12:00:00 | SPY | ETF | 147.0938 | 148.1562 | 146.875 | 147.125 | 805300.0 |
| 2000-04-13 13:00:00 | SPY | ETF | 147.25 | 147.75 | 146.75 | 147.75 | 387900.0 |
| 2000-04-13 14:00:00 | SPY | ETF | 147.7812 | 147.7812 | 145.3438 | 145.7812 | 997300.0 |
| 2000-04-13 15:00:00 | SPY | ETF | 146.0 | 147.3125 | 143.7812 | 144.0 | 3106400.0 |
| 2000-04-13 16:00:00 | SPY | ETF | 144.0 | 144.375 | 143.8438 | 144.25 | 500100.0 |
| 2000-04-13 09:00:00 | QQQ | ETF | 92.8125 | 93.0 | 88.6875 | 91.75 | 8510700.0 |
| 2000-04-13 10:00:00 | QQQ | ETF | 91.8125 | 95.0 | 90.625 | 92.4688 | 9780500.0 |
| 2000-04-13 11:00:00 | QQQ | ETF | 92.375 | 94.0 | 91.625 | 93.6875 | 6317400.0 |
| 2000-04-13 12:00:00 | QQQ | ETF | 93.6875 | 96.0 | 93.4375 | 94.6875 | 6831200.0 |
| 2000-04-13 13:00:00 | QQQ | ETF | 94.5 | 94.875 | 93.125 | 94.4375 | 2677300.0 |
| 2000-04-13 14:00:00 | QQQ | ETF | 94.5 | 94.625 | 90.5625 | 90.75 | 4184900.0 |
| 2000-04-13 15:00:00 | QQQ | ETF | 90.625 | 93.4688 | 88.3438 | 89.0 | 6836600.0 |
| 2000-04-13 16:00:00 | QQQ | ETF | 89.0 | 89.4375 | 88.25 | 88.5 | 947800.0 |
| 2000-04-13 17:00:00 | QQQ | ETF | 89.0 | 89.5 | 88.3125 | 88.5 | 5900.0 |
| 2000-04-13 18:00:00 | QQQ | ETF | 88.5 | 88.5 | 88.0 | 88.0 | 2600.0 |
| 2000-04-13 09:00:00 | DIA | ETF | 111.3438 | 111.4375 | 109.7812 | 110.9375 | 534100.0 |
| 2000-04-13 10:00:00 | DIA | ETF | 110.9375 | 111.5625 | 109.5312 | 110.0938 | 1293500.0 |
| 2000-04-13 11:00:00 | DIA | ETF | 110.0625 | 110.9062 | 109.8125 | 110.5312 | 905400.0 |
| 2000-04-13 12:00:00 | DIA | ETF | 110.2188 | 110.9375 | 110.2188 | 110.3125 | 227300.0 |
| 2000-04-13 13:00:00 | DIA | ETF | 110.5 | 110.9688 | 110.25 | 110.9688 | 441500.0 |
| 2000-04-13 14:00:00 | DIA | ETF | 111.0938 | 111.0938 | 109.2188 | 109.5938 | 251400.0 |
| 2000-04-13 15:00:00 | DIA | ETF | 109.5938 | 110.7188 | 109.0 | 109.0 | 603100.0 |
| 2000-04-13 16:00:00 | DIA | ETF | 108.75 | 109.0625 | 108.75 | 109.0312 | 67200.0 |
> showing 26 of 122 rows — these rows as CSV