PREVIEW / etf_1hour / 2002-04-01
file: by_date/etf_1hour/2002/2002-04-01.parquet size: 14 KB rows: 313
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 |
|---|---|---|---|---|---|---|---|
| 2002-04-01 09:00:00 | SPY | ETF | 114.23 | 114.32 | 113.82 | 113.91 | 1899000.0 |
| 2002-04-01 10:00:00 | SPY | ETF | 113.9 | 114.15 | 113.5 | 113.61 | 3159600.0 |
| 2002-04-01 11:00:00 | SPY | ETF | 113.62 | 113.91 | 113.58 | 113.82 | 1894500.0 |
| 2002-04-01 12:00:00 | SPY | ETF | 113.87 | 114.2 | 113.78 | 114.04 | 1251900.0 |
| 2002-04-01 13:00:00 | SPY | ETF | 114.02 | 114.58 | 114.0 | 114.53 | 1601200.0 |
| 2002-04-01 14:00:00 | SPY | ETF | 114.51 | 114.87 | 114.32 | 114.75 | 1849500.0 |
| 2002-04-01 15:00:00 | SPY | ETF | 114.8 | 115.1 | 114.71 | 114.83 | 2224100.0 |
| 2002-04-01 16:00:00 | SPY | ETF | 114.84 | 114.86 | 114.5 | 114.59 | 3567500.0 |
| 2002-04-01 17:00:00 | SPY | ETF | 114.53 | 114.53 | 114.52 | 114.52 | 400.0 |
| 2002-04-01 18:00:00 | SPY | ETF | 114.52 | 114.52 | 114.52 | 114.52 | 2700.0 |
| 2002-04-01 09:00:00 | QQQ | ETF | 35.8 | 35.83 | 35.53 | 35.68 | 7387400.0 |
| 2002-04-01 10:00:00 | QQQ | ETF | 35.69 | 35.9 | 35.46 | 35.63 | 15933100.0 |
| 2002-04-01 11:00:00 | QQQ | ETF | 35.69 | 35.84 | 35.65 | 35.77 | 3672300.0 |
| 2002-04-01 12:00:00 | QQQ | ETF | 35.76 | 36.17 | 35.75 | 36.07 | 8067500.0 |
| 2002-04-01 13:00:00 | QQQ | ETF | 36.06 | 36.48 | 36.05 | 36.47 | 9506700.0 |
| 2002-04-01 14:00:00 | QQQ | ETF | 36.47 | 36.71 | 36.34 | 36.67 | 8881400.0 |
| 2002-04-01 15:00:00 | QQQ | ETF | 36.65 | 36.9 | 36.56 | 36.77 | 12749300.0 |
| 2002-04-01 16:00:00 | QQQ | ETF | 36.76 | 36.8 | 36.34 | 36.74 | 2615100.0 |
| 2002-04-01 17:00:00 | QQQ | ETF | 36.74 | 36.77 | 36.7 | 36.72 | 31600.0 |
| 2002-04-01 18:00:00 | QQQ | ETF | 36.7 | 36.71 | 36.68 | 36.71 | 7500.0 |
| 2002-04-01 09:00:00 | IWM | ETF | 50.05 | 50.12 | 49.725 | 49.87 | 133600.0 |
| 2002-04-01 10:00:00 | IWM | ETF | 49.8 | 49.88 | 49.595 | 49.605 | 242000.0 |
| 2002-04-01 11:00:00 | IWM | ETF | 49.53 | 49.735 | 49.53 | 49.7 | 165600.0 |
| 2002-04-01 12:00:00 | IWM | ETF | 49.755 | 49.88 | 49.705 | 49.85 | 122800.0 |
| 2002-04-01 13:00:00 | IWM | ETF | 49.875 | 50.15 | 49.835 | 50.03 | 92800.0 |
| 2002-04-01 14:00:00 | IWM | ETF | 50.105 | 50.255 | 50.02 | 50.255 | 213200.0 |
| 2002-04-01 15:00:00 | IWM | ETF | 50.205 | 50.415 | 50.105 | 50.15 | 305200.0 |
| 2002-04-01 16:00:00 | IWM | ETF | 50.22 | 50.22 | 50.085 | 50.085 | 8000.0 |
| 2002-04-01 09:00:00 | DIA | ETF | 103.36 | 103.66 | 103.12 | 103.27 | 793100.0 |
| 2002-04-01 10:00:00 | DIA | ETF | 103.25 | 103.46 | 102.68 | 102.7 | 2061200.0 |
| 2002-04-01 11:00:00 | DIA | ETF | 102.75 | 102.99 | 102.67 | 102.94 | 1392800.0 |
| 2002-04-01 12:00:00 | DIA | ETF | 102.92 | 103.21 | 102.9 | 103.08 | 513700.0 |
| 2002-04-01 13:00:00 | DIA | ETF | 103.09 | 103.47 | 103.04 | 103.38 | 489700.0 |
| 2002-04-01 14:00:00 | DIA | ETF | 103.4 | 103.64 | 103.19 | 103.63 | 274500.0 |
| 2002-04-01 15:00:00 | DIA | ETF | 103.53 | 103.9 | 103.5 | 103.62 | 702700.0 |
| 2002-04-01 16:00:00 | DIA | ETF | 103.57 | 103.7 | 103.3 | 103.36 | 83600.0 |
> showing 36 of 313 rows — these rows as CSV