PREVIEW / etf_1hour / 2002-01-18
file: by_date/etf_1hour/2002/2002-01-18.parquet size: 13 KB rows: 284
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-18 09:00:00 | SPY | ETF | 113.0 | 113.43 | 113.0 | 113.23 | 2862100.0 |
| 2002-01-18 10:00:00 | SPY | ETF | 113.27 | 113.85 | 113.09 | 113.47 | 4321900.0 |
| 2002-01-18 11:00:00 | SPY | ETF | 113.49 | 113.53 | 113.01 | 113.15 | 1740700.0 |
| 2002-01-18 12:00:00 | SPY | ETF | 113.16 | 113.4 | 113.05 | 113.25 | 2014000.0 |
| 2002-01-18 13:00:00 | SPY | ETF | 113.23 | 113.48 | 113.18 | 113.44 | 638900.0 |
| 2002-01-18 14:00:00 | SPY | ETF | 113.4 | 113.43 | 112.81 | 112.97 | 1193100.0 |
| 2002-01-18 15:00:00 | SPY | ETF | 112.94 | 113.28 | 112.67 | 113.05 | 2259200.0 |
| 2002-01-18 16:00:00 | SPY | ETF | 113.09 | 113.25 | 113.04 | 113.23 | 1577600.0 |
| 2002-01-18 18:00:00 | SPY | ETF | 113.2 | 113.2 | 113.2 | 113.2 | 200.0 |
| 2002-01-18 09:00:00 | QQQ | ETF | 38.83 | 39.1 | 38.78 | 38.95 | 13434900.0 |
| 2002-01-18 10:00:00 | QQQ | ETF | 38.95 | 39.45 | 38.8 | 39.14 | 17654500.0 |
| 2002-01-18 11:00:00 | QQQ | ETF | 39.15 | 39.17 | 38.76 | 38.83 | 10225700.0 |
| 2002-01-18 12:00:00 | QQQ | ETF | 38.83 | 39.08 | 38.76 | 38.94 | 6194500.0 |
| 2002-01-18 13:00:00 | QQQ | ETF | 38.95 | 39.07 | 38.9 | 38.95 | 3515800.0 |
| 2002-01-18 14:00:00 | QQQ | ETF | 38.93 | 38.97 | 38.52 | 38.57 | 10840300.0 |
| 2002-01-18 15:00:00 | QQQ | ETF | 38.57 | 38.73 | 38.22 | 38.56 | 14859300.0 |
| 2002-01-18 16:00:00 | QQQ | ETF | 38.55 | 38.64 | 38.3 | 38.56 | 2789400.0 |
| 2002-01-18 17:00:00 | QQQ | ETF | 38.53 | 38.6 | 38.5 | 38.58 | 875600.0 |
| 2002-01-18 18:00:00 | QQQ | ETF | 38.55 | 38.59 | 38.55 | 38.59 | 2600.0 |
| 2002-01-18 09:00:00 | IWM | ETF | 47.55 | 47.64 | 47.455 | 47.575 | 157000.0 |
| 2002-01-18 10:00:00 | IWM | ETF | 47.55 | 47.83 | 47.545 | 47.745 | 120800.0 |
| 2002-01-18 11:00:00 | IWM | ETF | 47.735 | 47.795 | 47.565 | 47.565 | 249400.0 |
| 2002-01-18 12:00:00 | IWM | ETF | 47.645 | 47.645 | 47.375 | 47.495 | 87400.0 |
| 2002-01-18 13:00:00 | IWM | ETF | 47.505 | 47.625 | 47.495 | 47.605 | 34600.0 |
| 2002-01-18 14:00:00 | IWM | ETF | 47.605 | 47.62 | 47.265 | 47.265 | 36200.0 |
| 2002-01-18 15:00:00 | IWM | ETF | 47.3 | 47.36 | 47.05 | 47.15 | 97200.0 |
| 2002-01-18 16:00:00 | IWM | ETF | 47.15 | 47.15 | 46.9 | 46.95 | 196800.0 |
| 2002-01-18 09:00:00 | DIA | ETF | 97.48 | 98.01 | 97.43 | 97.98 | 550300.0 |
| 2002-01-18 10:00:00 | DIA | ETF | 97.98 | 98.38 | 97.66 | 98.16 | 936800.0 |
| 2002-01-18 11:00:00 | DIA | ETF | 98.15 | 98.15 | 97.65 | 97.79 | 716900.0 |
| 2002-01-18 12:00:00 | DIA | ETF | 97.82 | 98.08 | 97.74 | 97.86 | 245000.0 |
| 2002-01-18 13:00:00 | DIA | ETF | 97.9 | 98.2 | 97.9 | 98.08 | 218600.0 |
| 2002-01-18 14:00:00 | DIA | ETF | 98.12 | 98.12 | 97.48 | 97.64 | 315100.0 |
| 2002-01-18 15:00:00 | DIA | ETF | 97.59 | 98.0 | 97.42 | 97.79 | 416900.0 |
| 2002-01-18 16:00:00 | DIA | ETF | 97.83 | 98.2 | 97.78 | 97.96 | 18900.0 |
> showing 35 of 284 rows — these rows as CSV