PREVIEW / etf_1hour / 2002-03-01
file: by_date/etf_1hour/2002/2002-03-01.parquet size: 14 KB rows: 298
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-03-01 09:00:00 | SPY | ETF | 111.72 | 111.9 | 111.51 | 111.68 | 2903500.0 |
| 2002-03-01 10:00:00 | SPY | ETF | 111.72 | 112.62 | 111.66 | 112.43 | 5554600.0 |
| 2002-03-01 11:00:00 | SPY | ETF | 112.42 | 113.18 | 112.36 | 112.8 | 4478700.0 |
| 2002-03-01 12:00:00 | SPY | ETF | 112.81 | 112.96 | 112.61 | 112.82 | 2764600.0 |
| 2002-03-01 13:00:00 | SPY | ETF | 112.76 | 113.19 | 112.69 | 112.95 | 2146400.0 |
| 2002-03-01 14:00:00 | SPY | ETF | 112.96 | 113.18 | 112.77 | 113.01 | 1523100.0 |
| 2002-03-01 15:00:00 | SPY | ETF | 113.03 | 113.73 | 112.86 | 113.66 | 4639800.0 |
| 2002-03-01 16:00:00 | SPY | ETF | 113.66 | 113.87 | 113.52 | 113.86 | 1649000.0 |
| 2002-03-01 17:00:00 | SPY | ETF | 113.74 | 113.74 | 113.3 | 113.5 | 13900.0 |
| 2002-03-01 18:00:00 | SPY | ETF | 113.43 | 113.44 | 113.35 | 113.35 | 11000.0 |
| 2002-03-01 09:00:00 | QQQ | ETF | 34.15 | 34.37 | 34.09 | 34.19 | 7595400.0 |
| 2002-03-01 10:00:00 | QQQ | ETF | 34.19 | 34.87 | 34.16 | 34.73 | 17512700.0 |
| 2002-03-01 11:00:00 | QQQ | ETF | 34.74 | 35.16 | 34.7 | 34.98 | 15287200.0 |
| 2002-03-01 12:00:00 | QQQ | ETF | 34.98 | 35.16 | 34.89 | 35.05 | 6446400.0 |
| 2002-03-01 13:00:00 | QQQ | ETF | 35.05 | 35.38 | 35.01 | 35.28 | 10553500.0 |
| 2002-03-01 14:00:00 | QQQ | ETF | 35.27 | 35.48 | 35.11 | 35.27 | 9405300.0 |
| 2002-03-01 15:00:00 | QQQ | ETF | 35.31 | 35.73 | 35.21 | 35.7 | 15638300.0 |
| 2002-03-01 16:00:00 | QQQ | ETF | 35.7 | 35.86 | 35.65 | 35.8 | 1984700.0 |
| 2002-03-01 17:00:00 | QQQ | ETF | 35.81 | 35.84 | 35.31 | 35.4 | 566500.0 |
| 2002-03-01 18:00:00 | QQQ | ETF | 35.4 | 35.43 | 35.26 | 35.3 | 110700.0 |
| 2002-03-01 09:00:00 | IWM | ETF | 46.825 | 46.845 | 46.65 | 46.72 | 60000.0 |
| 2002-03-01 10:00:00 | IWM | ETF | 46.665 | 47.0 | 46.665 | 47.0 | 257800.0 |
| 2002-03-01 11:00:00 | IWM | ETF | 46.98 | 47.22 | 46.92 | 47.07 | 143200.0 |
| 2002-03-01 12:00:00 | IWM | ETF | 47.1 | 47.2 | 47.04 | 47.19 | 68200.0 |
| 2002-03-01 13:00:00 | IWM | ETF | 47.19 | 47.35 | 47.13 | 47.26 | 74600.0 |
| 2002-03-01 14:00:00 | IWM | ETF | 47.32 | 47.34 | 47.21 | 47.215 | 24000.0 |
| 2002-03-01 15:00:00 | IWM | ETF | 47.28 | 47.52 | 47.215 | 47.52 | 232000.0 |
| 2002-03-01 16:00:00 | IWM | ETF | 47.55 | 47.75 | 47.51 | 47.75 | 43000.0 |
| 2002-03-01 09:00:00 | DIA | ETF | 101.79 | 101.8 | 101.4 | 101.58 | 466100.0 |
| 2002-03-01 10:00:00 | DIA | ETF | 101.63 | 102.65 | 101.6 | 102.47 | 1475200.0 |
| 2002-03-01 11:00:00 | DIA | ETF | 102.41 | 103.11 | 102.37 | 102.8 | 1970700.0 |
| 2002-03-01 12:00:00 | DIA | ETF | 102.83 | 103.23 | 102.71 | 103.06 | 475700.0 |
| 2002-03-01 13:00:00 | DIA | ETF | 103.07 | 103.55 | 103.0 | 103.3 | 912400.0 |
| 2002-03-01 14:00:00 | DIA | ETF | 103.3 | 103.4 | 103.07 | 103.21 | 808400.0 |
| 2002-03-01 15:00:00 | DIA | ETF | 103.28 | 103.95 | 103.11 | 103.88 | 1670800.0 |
| 2002-03-01 16:00:00 | DIA | ETF | 103.86 | 104.2 | 103.8 | 103.8 | 633800.0 |
| 2002-03-01 17:00:00 | DIA | ETF | 103.94 | 104.1 | 103.9 | 103.9 | 5700.0 |
| 2002-03-01 18:00:00 | DIA | ETF | 103.52 | 103.52 | 102.76 | 103.5 | 4100.0 |
> showing 38 of 298 rows — these rows as CSV