PREVIEW / etf_1hour / 2000-01-11
file: by_date/etf_1hour/2000/2000-01-11.parquet size: 8 KB rows: 136
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-11 09:00:00 | SPY | ETF | 145.8125 | 145.9688 | 145.375 | 145.9062 | 1007400.0 |
| 2000-01-11 10:00:00 | SPY | ETF | 145.8438 | 146.0 | 145.25 | 145.75 | 1236500.0 |
| 2000-01-11 11:00:00 | SPY | ETF | 145.9375 | 146.0938 | 145.3125 | 145.375 | 964600.0 |
| 2000-01-11 12:00:00 | SPY | ETF | 145.3125 | 145.6562 | 144.9688 | 145.0 | 866200.0 |
| 2000-01-11 13:00:00 | SPY | ETF | 145.0 | 145.3438 | 144.7188 | 145.3438 | 482000.0 |
| 2000-01-11 14:00:00 | SPY | ETF | 145.3438 | 145.5625 | 144.375 | 144.375 | 752200.0 |
| 2000-01-11 15:00:00 | SPY | ETF | 144.4062 | 144.6875 | 143.5 | 144.0938 | 1867900.0 |
| 2000-01-11 16:00:00 | SPY | ETF | 143.9375 | 144.3438 | 143.7812 | 144.3125 | 122000.0 |
| 2000-01-11 17:00:00 | SPY | ETF | 144.5 | 144.5 | 144.5 | 144.5 | 70000.0 |
| 2000-01-11 09:00:00 | QQQ | ETF | 91.75 | 92.6875 | 91.5625 | 92.6562 | 3177200.0 |
| 2000-01-11 10:00:00 | QQQ | ETF | 92.6562 | 92.875 | 91.5781 | 92.25 | 3708000.0 |
| 2000-01-11 11:00:00 | QQQ | ETF | 92.3125 | 92.7812 | 91.4375 | 91.5 | 3919600.0 |
| 2000-01-11 12:00:00 | QQQ | ETF | 91.4375 | 92.0 | 90.5 | 90.5 | 4961400.0 |
| 2000-01-11 13:00:00 | QQQ | ETF | 90.5 | 91.3594 | 90.0 | 91.25 | 3950800.0 |
| 2000-01-11 14:00:00 | QQQ | ETF | 91.3594 | 91.75 | 90.1875 | 90.4375 | 3933600.0 |
| 2000-01-11 15:00:00 | QQQ | ETF | 90.1875 | 90.2188 | 87.625 | 88.2812 | 7371000.0 |
| 2000-01-11 16:00:00 | QQQ | ETF | 88.25 | 88.625 | 87.0 | 88.5 | 1237200.0 |
| 2000-01-11 17:00:00 | QQQ | ETF | 88.625 | 88.75 | 87.5 | 87.875 | 68800.0 |
| 2000-01-11 18:00:00 | QQQ | ETF | 87.625 | 88.0 | 87.5 | 88.0 | 2600.0 |
| 2000-01-11 09:00:00 | DIA | ETF | 115.1562 | 116.125 | 115.1562 | 116.0 | 339300.0 |
| 2000-01-11 10:00:00 | DIA | ETF | 116.1875 | 116.4688 | 115.7812 | 116.4375 | 295100.0 |
| 2000-01-11 11:00:00 | DIA | ETF | 116.5 | 116.75 | 115.875 | 116.0312 | 147100.0 |
| 2000-01-11 12:00:00 | DIA | ETF | 116.1562 | 116.4375 | 115.7812 | 115.7812 | 44400.0 |
| 2000-01-11 13:00:00 | DIA | ETF | 115.9688 | 116.3125 | 115.6875 | 116.0625 | 338000.0 |
| 2000-01-11 14:00:00 | DIA | ETF | 116.125 | 116.375 | 115.5 | 115.625 | 63700.0 |
| 2000-01-11 15:00:00 | DIA | ETF | 115.625 | 115.9375 | 115.0938 | 115.125 | 412900.0 |
| 2000-01-11 16:00:00 | DIA | ETF | 115.0312 | 115.1875 | 115.0312 | 115.125 | 14000.0 |
> showing 27 of 136 rows — these rows as CSV