PREVIEW / etf_1hour / 2002-03-15
file: by_date/etf_1hour/2002/2002-03-15.parquet size: 13 KB rows: 295
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-03-15 09:00:00 | SPY | ETF | 115.97 | 116.37 | 115.92 | 116.13 | 3924600.0 |
| 2002-03-15 10:00:00 | SPY | ETF | 116.11 | 116.54 | 115.9 | 116.5 | 4725600.0 |
| 2002-03-15 11:00:00 | SPY | ETF | 116.51 | 116.87 | 116.48 | 116.7 | 3638200.0 |
| 2002-03-15 12:00:00 | SPY | ETF | 116.69 | 116.79 | 116.32 | 116.69 | 2545800.0 |
| 2002-03-15 13:00:00 | SPY | ETF | 116.7 | 116.7 | 116.43 | 116.55 | 1116400.0 |
| 2002-03-15 14:00:00 | SPY | ETF | 116.57 | 116.94 | 116.56 | 116.94 | 1247400.0 |
| 2002-03-15 15:00:00 | SPY | ETF | 116.92 | 116.95 | 116.55 | 116.79 | 2207400.0 |
| 2002-03-15 16:00:00 | SPY | ETF | 116.85 | 116.94 | 116.58 | 116.64 | 1462300.0 |
| 2002-03-15 17:00:00 | SPY | ETF | 116.6 | 116.6 | 116.6 | 116.6 | 700.0 |
| 2002-03-15 18:00:00 | SPY | ETF | 116.66 | 116.66 | 116.66 | 116.66 | 200.0 |
| 2002-03-15 09:00:00 | QQQ | ETF | 36.89 | 36.99 | 36.67 | 36.75 | 10348100.0 |
| 2002-03-15 10:00:00 | QQQ | ETF | 36.75 | 37.13 | 36.59 | 37.08 | 13597100.0 |
| 2002-03-15 11:00:00 | QQQ | ETF | 37.09 | 37.22 | 37.04 | 37.08 | 7440500.0 |
| 2002-03-15 12:00:00 | QQQ | ETF | 37.07 | 37.16 | 36.81 | 37.1 | 7102000.0 |
| 2002-03-15 13:00:00 | QQQ | ETF | 37.08 | 37.11 | 36.94 | 37.02 | 2456700.0 |
| 2002-03-15 14:00:00 | QQQ | ETF | 37.02 | 37.33 | 37.02 | 37.25 | 7349500.0 |
| 2002-03-15 15:00:00 | QQQ | ETF | 37.24 | 37.25 | 36.96 | 37.15 | 9083900.0 |
| 2002-03-15 16:00:00 | QQQ | ETF | 37.2 | 37.26 | 37.15 | 37.2 | 3066100.0 |
| 2002-03-15 17:00:00 | QQQ | ETF | 37.23 | 37.29 | 37.2 | 37.29 | 734600.0 |
| 2002-03-15 18:00:00 | QQQ | ETF | 37.29 | 37.3 | 37.28 | 37.28 | 2400.0 |
| 2002-03-15 09:00:00 | IWM | ETF | 49.305 | 49.375 | 49.05 | 49.285 | 74200.0 |
| 2002-03-15 10:00:00 | IWM | ETF | 49.275 | 49.47 | 49.185 | 49.47 | 593600.0 |
| 2002-03-15 11:00:00 | IWM | ETF | 49.4 | 49.67 | 49.4 | 49.65 | 181800.0 |
| 2002-03-15 12:00:00 | IWM | ETF | 49.65 | 49.66 | 49.475 | 49.59 | 99400.0 |
| 2002-03-15 13:00:00 | IWM | ETF | 49.575 | 49.625 | 49.5 | 49.615 | 41800.0 |
| 2002-03-15 14:00:00 | IWM | ETF | 49.61 | 49.8 | 49.545 | 49.755 | 77600.0 |
| 2002-03-15 15:00:00 | IWM | ETF | 49.79 | 49.79 | 49.535 | 49.655 | 252800.0 |
| 2002-03-15 16:00:00 | IWM | ETF | 49.66 | 49.66 | 49.625 | 49.625 | 44400.0 |
| 2002-03-15 09:00:00 | DIA | ETF | 105.5 | 105.7 | 105.3 | 105.37 | 2054000.0 |
| 2002-03-15 10:00:00 | DIA | ETF | 105.42 | 105.72 | 105.17 | 105.7 | 2596900.0 |
| 2002-03-15 11:00:00 | DIA | ETF | 105.72 | 106.07 | 105.67 | 105.91 | 2083200.0 |
| 2002-03-15 12:00:00 | DIA | ETF | 105.88 | 106.02 | 105.62 | 105.93 | 1293900.0 |
| 2002-03-15 13:00:00 | DIA | ETF | 105.93 | 105.94 | 105.68 | 105.81 | 198200.0 |
| 2002-03-15 14:00:00 | DIA | ETF | 105.84 | 106.12 | 105.84 | 106.1 | 707100.0 |
| 2002-03-15 15:00:00 | DIA | ETF | 106.09 | 106.16 | 105.82 | 106.08 | 319500.0 |
| 2002-03-15 16:00:00 | DIA | ETF | 106.12 | 106.18 | 105.49 | 106.15 | 116100.0 |
| 2002-03-15 18:00:00 | DIA | ETF | 106.12 | 106.12 | 106.12 | 106.12 | 100.0 |
> showing 37 of 295 rows — these rows as CSV