PREVIEW / etf_1hour / 2002-03-18
file: by_date/etf_1hour/2002/2002-03-18.parquet size: 14 KB rows: 310
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-18 09:00:00 | SPY | ETF | 117.1 | 117.56 | 117.07 | 117.34 | 2594500.0 |
| 2002-03-18 10:00:00 | SPY | ETF | 117.31 | 117.49 | 116.91 | 116.95 | 2476000.0 |
| 2002-03-18 11:00:00 | SPY | ETF | 116.97 | 117.05 | 116.1 | 116.21 | 3692000.0 |
| 2002-03-18 12:00:00 | SPY | ETF | 116.2 | 116.52 | 116.13 | 116.33 | 1130900.0 |
| 2002-03-18 13:00:00 | SPY | ETF | 116.34 | 116.48 | 116.12 | 116.24 | 1284700.0 |
| 2002-03-18 14:00:00 | SPY | ETF | 116.27 | 116.68 | 116.1 | 116.53 | 1237400.0 |
| 2002-03-18 15:00:00 | SPY | ETF | 116.53 | 117.04 | 116.47 | 116.76 | 2328500.0 |
| 2002-03-18 16:00:00 | SPY | ETF | 116.76 | 116.84 | 116.62 | 116.62 | 716400.0 |
| 2002-03-18 17:00:00 | SPY | ETF | 116.78 | 116.78 | 116.72 | 116.73 | 45100.0 |
| 2002-03-18 18:00:00 | SPY | ETF | 116.71 | 116.71 | 116.68 | 116.68 | 500.0 |
| 2002-03-18 09:00:00 | QQQ | ETF | 37.63 | 37.94 | 37.63 | 37.81 | 13508900.0 |
| 2002-03-18 10:00:00 | QQQ | ETF | 37.83 | 37.91 | 37.62 | 37.68 | 11708300.0 |
| 2002-03-18 11:00:00 | QQQ | ETF | 37.69 | 37.75 | 37.18 | 37.25 | 14313100.0 |
| 2002-03-18 12:00:00 | QQQ | ETF | 37.25 | 37.39 | 37.18 | 37.27 | 5569700.0 |
| 2002-03-18 13:00:00 | QQQ | ETF | 37.26 | 37.37 | 37.09 | 37.14 | 7630700.0 |
| 2002-03-18 14:00:00 | QQQ | ETF | 37.13 | 37.46 | 37.05 | 37.32 | 8546700.0 |
| 2002-03-18 15:00:00 | QQQ | ETF | 37.32 | 37.6 | 37.29 | 37.48 | 12273300.0 |
| 2002-03-18 16:00:00 | QQQ | ETF | 37.48 | 37.85 | 37.38 | 37.43 | 1805500.0 |
| 2002-03-18 17:00:00 | QQQ | ETF | 37.42 | 37.42 | 37.34 | 37.41 | 26000.0 |
| 2002-03-18 18:00:00 | QQQ | ETF | 37.4 | 37.42 | 37.32 | 37.32 | 17100.0 |
| 2002-03-18 09:00:00 | IWM | ETF | 49.745 | 50.095 | 49.745 | 50.095 | 176800.0 |
| 2002-03-18 10:00:00 | IWM | ETF | 50.025 | 50.045 | 49.8 | 49.8 | 312400.0 |
| 2002-03-18 11:00:00 | IWM | ETF | 49.8 | 49.835 | 49.55 | 49.62 | 117800.0 |
| 2002-03-18 12:00:00 | IWM | ETF | 49.615 | 49.82 | 49.6 | 49.81 | 72800.0 |
| 2002-03-18 13:00:00 | IWM | ETF | 49.81 | 49.89 | 49.775 | 49.82 | 75000.0 |
| 2002-03-18 14:00:00 | IWM | ETF | 49.75 | 50.02 | 49.75 | 49.985 | 145600.0 |
| 2002-03-18 15:00:00 | IWM | ETF | 49.895 | 50.18 | 49.895 | 50.035 | 400000.0 |
| 2002-03-18 16:00:00 | IWM | ETF | 50.04 | 50.04 | 49.905 | 49.95 | 6000.0 |
| 2002-03-18 09:00:00 | DIA | ETF | 106.35 | 106.78 | 106.35 | 106.5 | 823300.0 |
| 2002-03-18 10:00:00 | DIA | ETF | 106.48 | 106.66 | 106.18 | 106.2 | 457500.0 |
| 2002-03-18 11:00:00 | DIA | ETF | 106.21 | 106.34 | 105.4 | 105.5 | 578900.0 |
| 2002-03-18 12:00:00 | DIA | ETF | 105.49 | 105.82 | 105.4 | 105.58 | 449200.0 |
| 2002-03-18 13:00:00 | DIA | ETF | 105.6 | 105.67 | 105.28 | 105.37 | 1253100.0 |
| 2002-03-18 14:00:00 | DIA | ETF | 105.35 | 105.82 | 105.27 | 105.66 | 222200.0 |
| 2002-03-18 15:00:00 | DIA | ETF | 105.69 | 106.1 | 105.63 | 105.78 | 758700.0 |
| 2002-03-18 16:00:00 | DIA | ETF | 105.83 | 105.85 | 105.65 | 105.81 | 58400.0 |
> showing 36 of 310 rows — these rows as CSV