PREVIEW / etf_1hour / 2002-05-01
file: by_date/etf_1hour/2002/2002-05-01.parquet size: 14 KB rows: 310
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-05-01 09:00:00 | SPY | ETF | 107.97 | 108.13 | 107.58 | 107.63 | 1913200.0 |
| 2002-05-01 10:00:00 | SPY | ETF | 107.58 | 107.63 | 106.8 | 107.28 | 4753500.0 |
| 2002-05-01 11:00:00 | SPY | ETF | 107.27 | 107.39 | 106.9 | 107.34 | 2429800.0 |
| 2002-05-01 12:00:00 | SPY | ETF | 107.35 | 107.84 | 107.2 | 107.59 | 2693600.0 |
| 2002-05-01 13:00:00 | SPY | ETF | 107.62 | 108.6 | 107.44 | 108.33 | 3719100.0 |
| 2002-05-01 14:00:00 | SPY | ETF | 108.3 | 109.0 | 108.21 | 108.83 | 3890500.0 |
| 2002-05-01 15:00:00 | SPY | ETF | 108.85 | 109.25 | 108.77 | 108.96 | 3074100.0 |
| 2002-05-01 16:00:00 | SPY | ETF | 108.95 | 109.93 | 108.92 | 109.21 | 1629400.0 |
| 2002-05-01 17:00:00 | SPY | ETF | 109.19 | 109.35 | 109.13 | 109.35 | 4900.0 |
| 2002-05-01 18:00:00 | SPY | ETF | 109.3 | 109.34 | 109.05 | 109.34 | 600.0 |
| 2002-05-01 09:00:00 | QQQ | ETF | 31.67 | 31.69 | 31.24 | 31.27 | 8681300.0 |
| 2002-05-01 10:00:00 | QQQ | ETF | 31.27 | 31.31 | 30.72 | 31.0 | 31138100.0 |
| 2002-05-01 11:00:00 | QQQ | ETF | 31.02 | 31.02 | 30.65 | 30.88 | 10530300.0 |
| 2002-05-01 12:00:00 | QQQ | ETF | 30.88 | 31.16 | 30.83 | 30.92 | 8086500.0 |
| 2002-05-01 13:00:00 | QQQ | ETF | 30.93 | 31.41 | 30.8 | 31.27 | 12969800.0 |
| 2002-05-01 14:00:00 | QQQ | ETF | 31.25 | 31.7 | 31.2 | 31.6 | 17443700.0 |
| 2002-05-01 15:00:00 | QQQ | ETF | 31.6 | 31.84 | 31.42 | 31.56 | 17467300.0 |
| 2002-05-01 16:00:00 | QQQ | ETF | 31.49 | 31.81 | 30.88 | 31.57 | 2903100.0 |
| 2002-05-01 17:00:00 | QQQ | ETF | 31.55 | 31.59 | 31.5 | 31.55 | 49400.0 |
| 2002-05-01 18:00:00 | QQQ | ETF | 31.55 | 31.58 | 31.54 | 31.54 | 18500.0 |
| 2002-05-01 09:00:00 | IWM | ETF | 50.75 | 50.75 | 50.515 | 50.515 | 179800.0 |
| 2002-05-01 10:00:00 | IWM | ETF | 50.58 | 50.58 | 49.98 | 50.15 | 236600.0 |
| 2002-05-01 11:00:00 | IWM | ETF | 50.175 | 50.285 | 50.11 | 50.24 | 145400.0 |
| 2002-05-01 12:00:00 | IWM | ETF | 50.285 | 50.57 | 50.28 | 50.565 | 52000.0 |
| 2002-05-01 13:00:00 | IWM | ETF | 50.51 | 50.78 | 50.43 | 50.725 | 260400.0 |
| 2002-05-01 14:00:00 | IWM | ETF | 50.75 | 50.97 | 50.685 | 50.875 | 274800.0 |
| 2002-05-01 15:00:00 | IWM | ETF | 50.895 | 50.98 | 50.8 | 50.86 | 260400.0 |
| 2002-05-01 16:00:00 | IWM | ETF | 50.735 | 51.0 | 50.735 | 51.0 | 18200.0 |
| 2002-05-01 09:00:00 | DIA | ETF | 99.64 | 99.82 | 99.31 | 99.38 | 617800.0 |
| 2002-05-01 10:00:00 | DIA | ETF | 99.35 | 99.37 | 98.38 | 98.85 | 1109200.0 |
| 2002-05-01 11:00:00 | DIA | ETF | 98.85 | 98.85 | 98.35 | 98.75 | 1249800.0 |
| 2002-05-01 12:00:00 | DIA | ETF | 98.75 | 99.47 | 98.64 | 99.26 | 1045500.0 |
| 2002-05-01 13:00:00 | DIA | ETF | 99.31 | 100.4 | 99.19 | 100.12 | 2892200.0 |
| 2002-05-01 14:00:00 | DIA | ETF | 100.1 | 100.8 | 100.04 | 100.57 | 913600.0 |
| 2002-05-01 15:00:00 | DIA | ETF | 100.51 | 101.06 | 100.46 | 100.65 | 630100.0 |
| 2002-05-01 16:00:00 | DIA | ETF | 100.68 | 100.99 | 100.54 | 100.94 | 152300.0 |
| 2002-05-01 18:00:00 | DIA | ETF | 100.9 | 100.9 | 100.9 | 100.9 | 100.0 |
> showing 37 of 310 rows — these rows as CSV