PREVIEW / etf_1hour / 2002-04-24
file: by_date/etf_1hour/2002/2002-04-24.parquet size: 14 KB rows: 311
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-24 09:00:00 | SPY | ETF | 110.56 | 110.86 | 110.46 | 110.63 | 1683900.0 |
| 2002-04-24 10:00:00 | SPY | ETF | 110.61 | 111.03 | 110.28 | 110.9 | 3942900.0 |
| 2002-04-24 11:00:00 | SPY | ETF | 110.88 | 111.24 | 110.71 | 111.16 | 1596100.0 |
| 2002-04-24 12:00:00 | SPY | ETF | 111.12 | 111.18 | 110.88 | 110.93 | 999000.0 |
| 2002-04-24 13:00:00 | SPY | ETF | 110.93 | 110.99 | 110.69 | 110.79 | 1326700.0 |
| 2002-04-24 14:00:00 | SPY | ETF | 110.79 | 111.06 | 110.1 | 110.27 | 2966300.0 |
| 2002-04-24 15:00:00 | SPY | ETF | 110.27 | 110.29 | 109.51 | 109.59 | 3724000.0 |
| 2002-04-24 16:00:00 | SPY | ETF | 109.63 | 109.65 | 109.32 | 109.55 | 2110500.0 |
| 2002-04-24 17:00:00 | SPY | ETF | 109.51 | 109.55 | 109.46 | 109.55 | 2500.0 |
| 2002-04-24 18:00:00 | SPY | ETF | 109.46 | 109.52 | 109.46 | 109.52 | 600.0 |
| 2002-04-24 09:00:00 | QQQ | ETF | 33.21 | 33.31 | 33.0 | 33.05 | 7253200.0 |
| 2002-04-24 10:00:00 | QQQ | ETF | 33.05 | 33.2 | 32.77 | 33.05 | 14269700.0 |
| 2002-04-24 11:00:00 | QQQ | ETF | 33.05 | 33.27 | 32.9 | 33.23 | 6898700.0 |
| 2002-04-24 12:00:00 | QQQ | ETF | 33.24 | 33.3 | 33.08 | 33.1 | 4006300.0 |
| 2002-04-24 13:00:00 | QQQ | ETF | 33.13 | 33.16 | 32.93 | 32.99 | 4947600.0 |
| 2002-04-24 14:00:00 | QQQ | ETF | 32.98 | 33.1 | 32.57 | 32.62 | 11115400.0 |
| 2002-04-24 15:00:00 | QQQ | ETF | 32.65 | 32.68 | 32.35 | 32.4 | 13976400.0 |
| 2002-04-24 16:00:00 | QQQ | ETF | 32.4 | 32.59 | 32.37 | 32.54 | 4268500.0 |
| 2002-04-24 17:00:00 | QQQ | ETF | 32.55 | 32.6 | 32.52 | 32.54 | 95700.0 |
| 2002-04-24 18:00:00 | QQQ | ETF | 32.52 | 32.57 | 32.52 | 32.55 | 55800.0 |
| 2002-04-24 09:00:00 | IWM | ETF | 51.0 | 51.25 | 50.95 | 51.25 | 160600.0 |
| 2002-04-24 10:00:00 | IWM | ETF | 51.2 | 51.325 | 50.955 | 51.29 | 115000.0 |
| 2002-04-24 11:00:00 | IWM | ETF | 51.29 | 51.29 | 51.1 | 51.23 | 57400.0 |
| 2002-04-24 12:00:00 | IWM | ETF | 51.185 | 51.2 | 50.995 | 51.0 | 61200.0 |
| 2002-04-24 13:00:00 | IWM | ETF | 50.975 | 51.025 | 50.8 | 50.86 | 320600.0 |
| 2002-04-24 14:00:00 | IWM | ETF | 50.79 | 50.9 | 50.505 | 50.515 | 108000.0 |
| 2002-04-24 15:00:00 | IWM | ETF | 50.57 | 50.575 | 50.385 | 50.52 | 210400.0 |
| 2002-04-24 16:00:00 | IWM | ETF | 50.52 | 50.52 | 50.46 | 50.46 | 5600.0 |
| 2002-04-24 09:00:00 | DIA | ETF | 101.12 | 101.4 | 101.0 | 101.15 | 299700.0 |
| 2002-04-24 10:00:00 | DIA | ETF | 101.12 | 101.39 | 100.8 | 101.28 | 332900.0 |
| 2002-04-24 11:00:00 | DIA | ETF | 101.31 | 101.7 | 101.12 | 101.66 | 308400.0 |
| 2002-04-24 12:00:00 | DIA | ETF | 101.58 | 101.74 | 101.45 | 101.56 | 120600.0 |
| 2002-04-24 13:00:00 | DIA | ETF | 101.47 | 101.61 | 101.25 | 101.36 | 72600.0 |
| 2002-04-24 14:00:00 | DIA | ETF | 101.37 | 101.6 | 100.81 | 100.94 | 479400.0 |
| 2002-04-24 15:00:00 | DIA | ETF | 101.03 | 101.03 | 100.28 | 100.46 | 1072400.0 |
| 2002-04-24 16:00:00 | DIA | ETF | 100.39 | 100.47 | 100.2 | 100.25 | 80000.0 |
| 2002-04-24 17:00:00 | DIA | ETF | 100.3 | 100.3 | 100.3 | 100.3 | 1500.0 |
> showing 37 of 311 rows — these rows as CSV