PREVIEW / etf_1hour / 2002-04-30
file: by_date/etf_1hour/2002/2002-04-30.parquet size: 14 KB rows: 316
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-30 09:00:00 | SPY | ETF | 107.02 | 107.1 | 106.64 | 106.73 | 1666700.0 |
| 2002-04-30 10:00:00 | SPY | ETF | 106.73 | 107.87 | 106.72 | 107.66 | 5923300.0 |
| 2002-04-30 11:00:00 | SPY | ETF | 107.64 | 108.46 | 107.51 | 108.45 | 3666600.0 |
| 2002-04-30 12:00:00 | SPY | ETF | 108.45 | 108.59 | 108.3 | 108.44 | 1167900.0 |
| 2002-04-30 13:00:00 | SPY | ETF | 108.43 | 108.6 | 108.27 | 108.49 | 817400.0 |
| 2002-04-30 14:00:00 | SPY | ETF | 108.5 | 108.59 | 108.18 | 108.49 | 2316000.0 |
| 2002-04-30 15:00:00 | SPY | ETF | 108.47 | 108.64 | 107.84 | 107.97 | 2163300.0 |
| 2002-04-30 16:00:00 | SPY | ETF | 107.93 | 108.1 | 107.76 | 107.91 | 1323500.0 |
| 2002-04-30 17:00:00 | SPY | ETF | 107.92 | 108.05 | 107.85 | 107.92 | 15700.0 |
| 2002-04-30 18:00:00 | SPY | ETF | 108.06 | 108.2 | 108.0 | 108.0 | 800.0 |
| 2002-04-30 09:00:00 | QQQ | ETF | 31.03 | 31.32 | 30.94 | 31.04 | 12628400.0 |
| 2002-04-30 10:00:00 | QQQ | ETF | 31.01 | 31.8 | 31.0 | 31.76 | 25913700.0 |
| 2002-04-30 11:00:00 | QQQ | ETF | 31.74 | 32.11 | 31.64 | 32.1 | 15310100.0 |
| 2002-04-30 12:00:00 | QQQ | ETF | 32.1 | 32.19 | 31.9 | 31.92 | 7700900.0 |
| 2002-04-30 13:00:00 | QQQ | ETF | 31.92 | 31.99 | 31.77 | 31.96 | 8763500.0 |
| 2002-04-30 14:00:00 | QQQ | ETF | 31.96 | 32.09 | 31.77 | 32.03 | 6946000.0 |
| 2002-04-30 15:00:00 | QQQ | ETF | 32.03 | 32.12 | 31.58 | 31.76 | 13639100.0 |
| 2002-04-30 16:00:00 | QQQ | ETF | 31.76 | 32.1 | 31.04 | 31.74 | 4151000.0 |
| 2002-04-30 17:00:00 | QQQ | ETF | 31.74 | 31.79 | 31.72 | 31.76 | 132100.0 |
| 2002-04-30 18:00:00 | QQQ | ETF | 31.78 | 31.8 | 31.75 | 31.8 | 15600.0 |
| 2002-04-30 09:00:00 | IWM | ETF | 49.9 | 50.01 | 49.81 | 50.01 | 49600.0 |
| 2002-04-30 10:00:00 | IWM | ETF | 49.99 | 50.37 | 49.98 | 50.315 | 189200.0 |
| 2002-04-30 11:00:00 | IWM | ETF | 50.3 | 50.55 | 50.285 | 50.55 | 225000.0 |
| 2002-04-30 12:00:00 | IWM | ETF | 50.56 | 50.645 | 50.455 | 50.58 | 130400.0 |
| 2002-04-30 13:00:00 | IWM | ETF | 50.57 | 50.595 | 50.4 | 50.595 | 168600.0 |
| 2002-04-30 14:00:00 | IWM | ETF | 50.55 | 50.62 | 50.5 | 50.57 | 355600.0 |
| 2002-04-30 15:00:00 | IWM | ETF | 50.535 | 50.795 | 50.505 | 50.795 | 236600.0 |
| 2002-04-30 16:00:00 | IWM | ETF | 50.625 | 50.83 | 50.625 | 50.65 | 81000.0 |
| 2002-04-30 09:00:00 | DIA | ETF | 98.67 | 98.67 | 98.27 | 98.52 | 250700.0 |
| 2002-04-30 10:00:00 | DIA | ETF | 98.46 | 99.5 | 98.46 | 99.33 | 1633500.0 |
| 2002-04-30 11:00:00 | DIA | ETF | 99.3 | 99.97 | 99.16 | 99.97 | 599300.0 |
| 2002-04-30 12:00:00 | DIA | ETF | 99.94 | 100.1 | 99.85 | 100.02 | 211200.0 |
| 2002-04-30 13:00:00 | DIA | ETF | 100.0 | 100.2 | 99.91 | 100.1 | 218700.0 |
| 2002-04-30 14:00:00 | DIA | ETF | 100.1 | 100.17 | 99.73 | 99.94 | 234600.0 |
| 2002-04-30 15:00:00 | DIA | ETF | 99.94 | 100.16 | 99.36 | 99.44 | 405600.0 |
| 2002-04-30 16:00:00 | DIA | ETF | 99.52 | 99.58 | 99.4 | 99.42 | 114300.0 |
| 2002-04-30 17:00:00 | DIA | ETF | 99.6 | 99.6 | 99.6 | 99.6 | 100.0 |
> showing 37 of 316 rows — these rows as CSV