PREVIEW / etf_1hour / 2002-01-30
file: by_date/etf_1hour/2002/2002-01-30.parquet size: 13 KB rows: 278
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-01-30 08:00:00 | SPY | ETF | 110.39 | 111.044 | 110.0365 | 110.4784 | 43910.0 |
| 2002-01-30 09:00:00 | SPY | ETF | 110.6551 | 110.84 | 109.99 | 110.6 | 4464190.0 |
| 2002-01-30 10:00:00 | SPY | ETF | 110.57 | 110.7 | 109.38 | 109.86 | 5982600.0 |
| 2002-01-30 11:00:00 | SPY | ETF | 109.8 | 110.28 | 108.77 | 108.78 | 4099200.0 |
| 2002-01-30 12:00:00 | SPY | ETF | 108.8 | 109.36 | 108.4 | 109.14 | 5072200.0 |
| 2002-01-30 13:00:00 | SPY | ETF | 109.14 | 110.13 | 109.12 | 110.01 | 2708500.0 |
| 2002-01-30 14:00:00 | SPY | ETF | 110.8579 | 111.7681 | 110.2508 | 111.1862 | 2998880.0 |
| 2002-01-30 15:00:00 | SPY | ETF | 111.2671 | 113.39 | 111.1629 | 113.2818 | 3403780.0 |
| 2002-01-30 16:00:00 | SPY | ETF | 113.2999 | 113.408 | 111.8397 | 113.2278 | 544640.0 |
| 2002-01-30 17:00:00 | SPY | ETF | 113.39 | 113.4801 | 113.2999 | 113.4801 | 3440.0 |
| 2002-01-30 18:00:00 | SPY | ETF | 113.4801 | 113.4801 | 113.408 | 113.408 | 890.0 |
| 2002-01-30 09:00:00 | QQQ | ETF | 38.0 | 38.03 | 37.45 | 37.87 | 11011500.0 |
| 2002-01-30 10:00:00 | QQQ | ETF | 37.85 | 37.89 | 37.12 | 37.38 | 15494000.0 |
| 2002-01-30 11:00:00 | QQQ | ETF | 37.34 | 37.74 | 36.94 | 37.0 | 15017500.0 |
| 2002-01-30 12:00:00 | QQQ | ETF | 37.0 | 37.33 | 36.85 | 37.21 | 10250700.0 |
| 2002-01-30 13:00:00 | QQQ | ETF | 37.2 | 37.65 | 37.19 | 37.54 | 8077700.0 |
| 2002-01-30 14:00:00 | QQQ | ETF | 37.55 | 37.95 | 37.35 | 37.73 | 18262400.0 |
| 2002-01-30 15:00:00 | QQQ | ETF | 37.73 | 38.3 | 37.68 | 38.28 | 20641800.0 |
| 2002-01-30 16:00:00 | QQQ | ETF | 38.25 | 38.39 | 37.65 | 38.39 | 2157500.0 |
| 2002-01-30 17:00:00 | QQQ | ETF | 38.39 | 38.47 | 38.33 | 38.38 | 137500.0 |
| 2002-01-30 18:00:00 | QQQ | ETF | 38.39 | 38.46 | 38.38 | 38.46 | 18000.0 |
| 2002-01-30 09:00:00 | IWM | ETF | 47.2 | 47.225 | 46.95 | 46.995 | 379000.0 |
| 2002-01-30 10:00:00 | IWM | ETF | 47.075 | 47.075 | 46.595 | 46.745 | 168000.0 |
| 2002-01-30 11:00:00 | IWM | ETF | 46.79 | 46.835 | 46.575 | 46.595 | 39800.0 |
| 2002-01-30 12:00:00 | IWM | ETF | 46.54 | 46.66 | 46.5 | 46.66 | 102800.0 |
| 2002-01-30 13:00:00 | IWM | ETF | 46.6 | 47.0 | 46.6 | 46.98 | 170000.0 |
| 2002-01-30 14:00:00 | IWM | ETF | 46.99 | 47.37 | 46.99 | 47.27 | 207800.0 |
| 2002-01-30 15:00:00 | IWM | ETF | 47.34 | 47.77 | 47.34 | 47.75 | 173400.0 |
| 2002-01-30 16:00:00 | IWM | ETF | 47.6 | 47.795 | 47.6 | 47.695 | 5400.0 |
| 2002-01-30 09:00:00 | DIA | ETF | 96.5 | 96.64 | 96.05 | 96.48 | 577500.0 |
| 2002-01-30 10:00:00 | DIA | ETF | 96.48 | 96.5 | 95.61 | 96.11 | 1268600.0 |
| 2002-01-30 11:00:00 | DIA | ETF | 96.2 | 96.54 | 95.66 | 95.7 | 639600.0 |
| 2002-01-30 12:00:00 | DIA | ETF | 95.7 | 96.04 | 95.3 | 95.8 | 1064700.0 |
| 2002-01-30 13:00:00 | DIA | ETF | 95.81 | 96.45 | 95.79 | 96.36 | 449900.0 |
| 2002-01-30 14:00:00 | DIA | ETF | 96.36 | 97.04 | 96.19 | 96.95 | 1063000.0 |
| 2002-01-30 15:00:00 | DIA | ETF | 96.98 | 97.85 | 96.94 | 97.64 | 696900.0 |
| 2002-01-30 16:00:00 | DIA | ETF | 97.61 | 97.88 | 97.6 | 97.84 | 106400.0 |
> showing 37 of 278 rows — these rows as CSV