PREVIEW / etf_1hour / 2001-07-03
file: by_date/etf_1hour/2001/2001-07-03.parquet size: 9 KB rows: 137
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-03 09:00:00 | SPY | ETF | 123.98 | 123.98 | 123.05 | 123.23 | 1031100.0 |
| 2001-07-03 10:00:00 | SPY | ETF | 123.2 | 123.63 | 123.2 | 123.54 | 810300.0 |
| 2001-07-03 11:00:00 | SPY | ETF | 123.47 | 123.83 | 123.36 | 123.77 | 404400.0 |
| 2001-07-03 12:00:00 | SPY | ETF | 123.74 | 123.95 | 123.51 | 123.63 | 649400.0 |
| 2001-07-03 13:00:00 | SPY | ETF | 123.7 | 124.1 | 123.51 | 124.1 | 300900.0 |
| 2001-07-03 09:00:00 | QQQ | ETF | 45.25 | 45.3 | 44.8 | 45.14 | 7318900.0 |
| 2001-07-03 10:00:00 | QQQ | ETF | 45.14 | 45.58 | 45.13 | 45.44 | 6597900.0 |
| 2001-07-03 11:00:00 | QQQ | ETF | 45.45 | 45.68 | 45.33 | 45.66 | 3118600.0 |
| 2001-07-03 12:00:00 | QQQ | ETF | 45.67 | 45.68 | 45.33 | 45.4 | 3481900.0 |
| 2001-07-03 13:00:00 | QQQ | ETF | 45.43 | 45.66 | 45.37 | 45.64 | 351600.0 |
| 2001-07-03 09:00:00 | IWM | ETF | 49.625 | 49.65 | 49.3 | 49.3 | 187800.0 |
| 2001-07-03 10:00:00 | IWM | ETF | 49.39 | 49.67 | 49.39 | 49.55 | 615800.0 |
| 2001-07-03 11:00:00 | IWM | ETF | 49.6 | 49.725 | 49.505 | 49.65 | 25000.0 |
| 2001-07-03 12:00:00 | IWM | ETF | 49.65 | 49.77 | 49.5 | 49.5 | 65600.0 |
| 2001-07-03 13:00:00 | IWM | ETF | 49.505 | 49.505 | 49.5 | 49.5 | 1200.0 |
| 2001-07-03 09:00:00 | DIA | ETF | 105.95 | 105.97 | 105.35 | 105.45 | 196600.0 |
| 2001-07-03 10:00:00 | DIA | ETF | 105.49 | 105.74 | 105.4 | 105.67 | 169000.0 |
| 2001-07-03 11:00:00 | DIA | ETF | 105.58 | 105.8 | 105.5 | 105.78 | 68700.0 |
| 2001-07-03 12:00:00 | DIA | ETF | 105.83 | 105.88 | 105.7 | 105.8 | 150000.0 |
| 2001-07-03 13:00:00 | DIA | ETF | 105.68 | 106.05 | 105.66 | 106.05 | 45900.0 |
> showing 20 of 137 rows — these rows as CSV