PREVIEW / etf_1hour / 2002-04-17
file: by_date/etf_1hour/2002/2002-04-17.parquet size: 14 KB rows: 308
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-17 09:00:00 | SPY | ETF | 113.39 | 113.46 | 112.92 | 113.19 | 2182600.0 |
| 2002-04-17 10:00:00 | SPY | ETF | 113.22 | 113.67 | 112.97 | 113.41 | 3015600.0 |
| 2002-04-17 11:00:00 | SPY | ETF | 113.45 | 113.47 | 113.12 | 113.38 | 1078700.0 |
| 2002-04-17 12:00:00 | SPY | ETF | 113.39 | 113.42 | 112.96 | 113.23 | 1452600.0 |
| 2002-04-17 13:00:00 | SPY | ETF | 113.2 | 113.25 | 112.99 | 113.13 | 683500.0 |
| 2002-04-17 14:00:00 | SPY | ETF | 113.1 | 113.12 | 112.65 | 112.77 | 1309700.0 |
| 2002-04-17 15:00:00 | SPY | ETF | 112.78 | 113.08 | 112.6 | 113.05 | 1465400.0 |
| 2002-04-17 16:00:00 | SPY | ETF | 113.02 | 113.1 | 112.92 | 112.94 | 977700.0 |
| 2002-04-17 17:00:00 | SPY | ETF | 112.97 | 113.17 | 112.97 | 113.15 | 49600.0 |
| 2002-04-17 18:00:00 | SPY | ETF | 113.07 | 113.1 | 113.02 | 113.02 | 8100.0 |
| 2002-04-17 09:00:00 | QQQ | ETF | 35.4 | 35.43 | 34.92 | 35.11 | 11280200.0 |
| 2002-04-17 10:00:00 | QQQ | ETF | 35.11 | 35.5 | 35.01 | 35.32 | 16919900.0 |
| 2002-04-17 11:00:00 | QQQ | ETF | 35.32 | 35.38 | 35.15 | 35.23 | 6263500.0 |
| 2002-04-17 12:00:00 | QQQ | ETF | 35.26 | 35.27 | 34.92 | 35.05 | 7340700.0 |
| 2002-04-17 13:00:00 | QQQ | ETF | 35.05 | 35.08 | 34.74 | 34.92 | 5687800.0 |
| 2002-04-17 14:00:00 | QQQ | ETF | 34.91 | 34.95 | 34.65 | 34.83 | 7335400.0 |
| 2002-04-17 15:00:00 | QQQ | ETF | 34.83 | 35.0 | 34.76 | 34.97 | 8514900.0 |
| 2002-04-17 16:00:00 | QQQ | ETF | 34.97 | 35.03 | 34.8 | 35.0 | 1300400.0 |
| 2002-04-17 17:00:00 | QQQ | ETF | 35.0 | 35.13 | 34.97 | 35.1 | 263100.0 |
| 2002-04-17 18:00:00 | QQQ | ETF | 35.1 | 35.1 | 35.01 | 35.03 | 11100.0 |
| 2002-04-17 09:00:00 | IWM | ETF | 52.375 | 52.375 | 51.835 | 51.97 | 141800.0 |
| 2002-04-17 10:00:00 | IWM | ETF | 51.98 | 52.2 | 51.91 | 52.08 | 324600.0 |
| 2002-04-17 11:00:00 | IWM | ETF | 52.095 | 52.095 | 51.955 | 52.025 | 243000.0 |
| 2002-04-17 12:00:00 | IWM | ETF | 52.05 | 52.075 | 51.865 | 51.985 | 480600.0 |
| 2002-04-17 13:00:00 | IWM | ETF | 51.945 | 51.985 | 51.83 | 51.88 | 223600.0 |
| 2002-04-17 14:00:00 | IWM | ETF | 51.885 | 51.885 | 51.65 | 51.77 | 1109400.0 |
| 2002-04-17 15:00:00 | IWM | ETF | 51.785 | 51.81 | 51.625 | 51.75 | 1636600.0 |
| 2002-04-17 16:00:00 | IWM | ETF | 51.675 | 52.05 | 51.63 | 52.05 | 1410800.0 |
| 2002-04-17 09:00:00 | DIA | ETF | 103.42 | 103.42 | 102.66 | 102.9 | 326400.0 |
| 2002-04-17 10:00:00 | DIA | ETF | 102.86 | 103.25 | 102.66 | 103.03 | 431000.0 |
| 2002-04-17 11:00:00 | DIA | ETF | 102.98 | 103.05 | 102.78 | 102.92 | 219100.0 |
| 2002-04-17 12:00:00 | DIA | ETF | 102.88 | 102.99 | 102.57 | 102.78 | 152600.0 |
| 2002-04-17 13:00:00 | DIA | ETF | 102.73 | 102.88 | 102.64 | 102.7 | 72500.0 |
| 2002-04-17 14:00:00 | DIA | ETF | 102.63 | 102.65 | 102.1 | 102.23 | 798400.0 |
| 2002-04-17 15:00:00 | DIA | ETF | 102.23 | 102.5 | 102.0 | 102.45 | 418800.0 |
| 2002-04-17 16:00:00 | DIA | ETF | 102.42 | 102.48 | 102.4 | 102.41 | 40200.0 |
> showing 36 of 308 rows — these rows as CSV