PREVIEW / etf_30min / 2002-03-06
file: by_date/etf_30min/2002/2002-03-06.parquet size: 19 KB rows: 495
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-06 09:30:00 | SPY | ETF | 115.1 | 115.58 | 115.08 | 115.55 | 1850800.0 |
| 2002-03-06 10:00:00 | SPY | ETF | 115.55 | 115.88 | 115.07 | 115.82 | 2319300.0 |
| 2002-03-06 10:30:00 | SPY | ETF | 115.85 | 116.27 | 115.73 | 116.1 | 1801300.0 |
| 2002-03-06 11:00:00 | SPY | ETF | 116.11 | 116.2 | 115.83 | 116.01 | 1129400.0 |
| 2002-03-06 11:30:00 | SPY | ETF | 116.04 | 116.14 | 115.85 | 116.04 | 448100.0 |
| 2002-03-06 12:00:00 | SPY | ETF | 116.06 | 116.42 | 116.01 | 116.25 | 1346500.0 |
| 2002-03-06 12:30:00 | SPY | ETF | 116.26 | 116.47 | 116.1 | 116.2 | 829600.0 |
| 2002-03-06 13:00:00 | SPY | ETF | 116.23 | 116.34 | 115.98 | 116.13 | 691300.0 |
| 2002-03-06 13:30:00 | SPY | ETF | 116.11 | 116.19 | 115.86 | 116.02 | 1002800.0 |
| 2002-03-06 14:00:00 | SPY | ETF | 116.02 | 116.35 | 115.74 | 116.28 | 1403700.0 |
| 2002-03-06 14:30:00 | SPY | ETF | 116.34 | 116.83 | 116.22 | 116.74 | 1950700.0 |
| 2002-03-06 15:00:00 | SPY | ETF | 116.74 | 117.15 | 116.6 | 117.04 | 1525900.0 |
| 2002-03-06 15:30:00 | SPY | ETF | 117.0 | 117.1 | 116.7 | 116.81 | 1955900.0 |
| 2002-03-06 16:00:00 | SPY | ETF | 116.86 | 117.75 | 116.4 | 116.7 | 1073700.0 |
| 2002-03-06 16:30:00 | SPY | ETF | 116.74 | 116.8 | 116.65 | 116.78 | 45000.0 |
| 2002-03-06 17:00:00 | SPY | ETF | 116.75 | 116.75 | 116.75 | 116.75 | 500.0 |
| 2002-03-06 17:30:00 | SPY | ETF | 116.71 | 116.74 | 116.66 | 116.66 | 2300.0 |
| 2002-03-06 18:00:00 | SPY | ETF | 117.0 | 117.0 | 116.7 | 116.7 | 25800.0 |
| 2002-03-06 18:30:00 | SPY | ETF | 116.5 | 116.5 | 116.5 | 116.5 | 100.0 |
| 2002-03-06 09:30:00 | QQQ | ETF | 37.08 | 37.17 | 36.8 | 37.01 | 10550800.0 |
| 2002-03-06 10:00:00 | QQQ | ETF | 37.03 | 37.05 | 36.6 | 37.04 | 11537700.0 |
| 2002-03-06 10:30:00 | QQQ | ETF | 37.02 | 37.35 | 36.91 | 37.22 | 8518600.0 |
| 2002-03-06 11:00:00 | QQQ | ETF | 37.23 | 37.32 | 36.95 | 37.15 | 4740900.0 |
| 2002-03-06 11:30:00 | QQQ | ETF | 37.15 | 37.25 | 37.06 | 37.21 | 2388100.0 |
| 2002-03-06 12:00:00 | QQQ | ETF | 37.23 | 37.57 | 37.2 | 37.47 | 5999300.0 |
| 2002-03-06 12:30:00 | QQQ | ETF | 37.49 | 37.69 | 37.44 | 37.48 | 4967500.0 |
| 2002-03-06 13:00:00 | QQQ | ETF | 37.49 | 37.6 | 37.28 | 37.39 | 3273100.0 |
| 2002-03-06 13:30:00 | QQQ | ETF | 37.4 | 37.45 | 37.08 | 37.2 | 5105700.0 |
| 2002-03-06 14:00:00 | QQQ | ETF | 37.2 | 37.44 | 37.04 | 37.43 | 6498100.0 |
| 2002-03-06 14:30:00 | QQQ | ETF | 37.42 | 37.66 | 37.35 | 37.54 | 4745700.0 |
| 2002-03-06 15:00:00 | QQQ | ETF | 37.53 | 37.93 | 37.48 | 37.85 | 6636500.0 |
| 2002-03-06 15:30:00 | QQQ | ETF | 37.85 | 37.95 | 37.6 | 37.78 | 7635500.0 |
| 2002-03-06 16:00:00 | QQQ | ETF | 37.78 | 37.8 | 37.54 | 37.61 | 1098900.0 |
| 2002-03-06 16:30:00 | QQQ | ETF | 37.62 | 37.7 | 37.45 | 37.66 | 35400.0 |
| 2002-03-06 17:00:00 | QQQ | ETF | 37.66 | 37.75 | 37.45 | 37.65 | 28100.0 |
| 2002-03-06 17:30:00 | QQQ | ETF | 37.65 | 37.66 | 37.64 | 37.65 | 21600.0 |
| 2002-03-06 18:00:00 | QQQ | ETF | 37.67 | 37.68 | 37.61 | 37.65 | 21200.0 |
| 2002-03-06 18:30:00 | QQQ | ETF | 37.67 | 37.67 | 37.67 | 37.67 | 300.0 |
| 2002-03-06 09:30:00 | IWM | ETF | 48.61 | 48.64 | 48.35 | 48.45 | 124200.0 |
| 2002-03-06 10:00:00 | IWM | ETF | 48.48 | 48.48 | 48.2 | 48.41 | 108800.0 |
| 2002-03-06 10:30:00 | IWM | ETF | 48.4 | 48.625 | 48.4 | 48.625 | 102800.0 |
| 2002-03-06 11:00:00 | IWM | ETF | 48.63 | 48.68 | 48.58 | 48.68 | 43400.0 |
| 2002-03-06 11:30:00 | IWM | ETF | 48.71 | 48.73 | 48.645 | 48.73 | 29200.0 |
| 2002-03-06 12:00:00 | IWM | ETF | 48.74 | 48.99 | 48.74 | 48.955 | 59600.0 |
| 2002-03-06 12:30:00 | IWM | ETF | 48.985 | 49.005 | 48.895 | 48.99 | 20800.0 |
| 2002-03-06 13:00:00 | IWM | ETF | 48.99 | 48.99 | 48.94 | 48.96 | 3200.0 |
| 2002-03-06 13:30:00 | IWM | ETF | 48.94 | 48.94 | 48.795 | 48.795 | 18000.0 |
| 2002-03-06 14:00:00 | IWM | ETF | 48.92 | 48.99 | 48.825 | 48.99 | 24000.0 |
| 2002-03-06 14:30:00 | IWM | ETF | 48.98 | 49.12 | 48.98 | 49.095 | 72600.0 |
| 2002-03-06 15:00:00 | IWM | ETF | 49.1 | 49.22 | 48.98 | 49.22 | 63000.0 |
> showing 50 of 495 rows — these rows as CSV