PREVIEW / etf_1hour / 2002-01-11
file: by_date/etf_1hour/2002/2002-01-11.parquet size: 13 KB rows: 280
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-11 09:00:00 | SPY | ETF | 116.21 | 116.28 | 115.68 | 115.77 | 973600.0 |
| 2002-01-11 10:00:00 | SPY | ETF | 115.77 | 116.2 | 115.76 | 116.02 | 2181200.0 |
| 2002-01-11 11:00:00 | SPY | ETF | 116.04 | 116.04 | 115.84 | 115.95 | 835200.0 |
| 2002-01-11 12:00:00 | SPY | ETF | 115.95 | 115.99 | 115.55 | 115.72 | 584400.0 |
| 2002-01-11 13:00:00 | SPY | ETF | 115.74 | 115.75 | 115.06 | 115.31 | 2038000.0 |
| 2002-01-11 14:00:00 | SPY | ETF | 115.26 | 115.45 | 114.88 | 115.3 | 3357900.0 |
| 2002-01-11 15:00:00 | SPY | ETF | 115.24 | 115.4 | 114.71 | 114.77 | 1955800.0 |
| 2002-01-11 16:00:00 | SPY | ETF | 114.78 | 115.03 | 114.7 | 114.93 | 1577300.0 |
| 2002-01-11 17:00:00 | SPY | ETF | 114.79 | 115.15 | 114.75 | 115.15 | 2900.0 |
| 2002-01-11 18:00:00 | SPY | ETF | 114.78 | 114.78 | 114.78 | 114.78 | 100.0 |
| 2002-01-11 09:00:00 | QQQ | ETF | 41.35 | 41.44 | 41.15 | 41.35 | 6091000.0 |
| 2002-01-11 10:00:00 | QQQ | ETF | 41.25 | 41.6 | 41.25 | 41.43 | 8628000.0 |
| 2002-01-11 11:00:00 | QQQ | ETF | 41.43 | 41.47 | 41.25 | 41.33 | 3295800.0 |
| 2002-01-11 12:00:00 | QQQ | ETF | 41.34 | 41.35 | 40.95 | 41.08 | 4755500.0 |
| 2002-01-11 13:00:00 | QQQ | ETF | 41.07 | 41.1 | 40.62 | 40.8 | 11321700.0 |
| 2002-01-11 14:00:00 | QQQ | ETF | 40.78 | 40.91 | 40.47 | 40.78 | 15399400.0 |
| 2002-01-11 15:00:00 | QQQ | ETF | 40.8 | 40.98 | 40.63 | 40.68 | 8879700.0 |
| 2002-01-11 16:00:00 | QQQ | ETF | 40.69 | 40.95 | 40.5 | 40.84 | 1469000.0 |
| 2002-01-11 17:00:00 | QQQ | ETF | 40.84 | 40.9 | 40.75 | 40.9 | 23800.0 |
| 2002-01-11 18:00:00 | QQQ | ETF | 40.82 | 40.89 | 40.82 | 40.83 | 11600.0 |
| 2002-01-11 09:00:00 | IWM | ETF | 49.375 | 49.47 | 49.16 | 49.275 | 73400.0 |
| 2002-01-11 10:00:00 | IWM | ETF | 49.255 | 49.475 | 49.25 | 49.445 | 200400.0 |
| 2002-01-11 11:00:00 | IWM | ETF | 49.435 | 49.445 | 49.3 | 49.385 | 105200.0 |
| 2002-01-11 12:00:00 | IWM | ETF | 49.305 | 49.375 | 49.2 | 49.295 | 24800.0 |
| 2002-01-11 13:00:00 | IWM | ETF | 49.275 | 49.285 | 48.995 | 49.045 | 153200.0 |
| 2002-01-11 14:00:00 | IWM | ETF | 48.99 | 49.085 | 48.84 | 49.0 | 74800.0 |
| 2002-01-11 15:00:00 | IWM | ETF | 49.005 | 49.095 | 48.55 | 48.55 | 159800.0 |
| 2002-01-11 16:00:00 | IWM | ETF | 48.65 | 48.7 | 48.6 | 48.7 | 7200.0 |
| 2002-01-11 09:00:00 | DIA | ETF | 100.92 | 101.1 | 100.63 | 100.68 | 201100.0 |
| 2002-01-11 10:00:00 | DIA | ETF | 100.67 | 101.1 | 100.67 | 101.0 | 420300.0 |
| 2002-01-11 11:00:00 | DIA | ETF | 101.02 | 101.03 | 100.83 | 100.93 | 357400.0 |
| 2002-01-11 12:00:00 | DIA | ETF | 100.94 | 100.95 | 100.65 | 100.82 | 91200.0 |
| 2002-01-11 13:00:00 | DIA | ETF | 100.76 | 100.76 | 100.2 | 100.5 | 433800.0 |
| 2002-01-11 14:00:00 | DIA | ETF | 100.43 | 100.58 | 100.04 | 100.35 | 460900.0 |
| 2002-01-11 15:00:00 | DIA | ETF | 100.4 | 100.47 | 99.92 | 99.94 | 392300.0 |
| 2002-01-11 16:00:00 | DIA | ETF | 99.95 | 100.1 | 99.85 | 100.07 | 74800.0 |
> showing 36 of 280 rows — these rows as CSV