PREVIEW / etf_30min / 2002-08-14
file: by_date/etf_30min/2002/2002-08-14.parquet size: 21 KB rows: 569
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-08-14 09:30:00 | SPY | ETF | 89.02 | 89.33 | 88.8 | 88.89 | 4972100.0 |
| 2002-08-14 10:00:00 | SPY | ETF | 88.89 | 88.95 | 88.02 | 88.3 | 5913700.0 |
| 2002-08-14 10:30:00 | SPY | ETF | 88.35 | 89.25 | 88.2 | 88.9 | 3635500.0 |
| 2002-08-14 11:00:00 | SPY | ETF | 88.94 | 89.05 | 88.45 | 88.45 | 2298200.0 |
| 2002-08-14 11:30:00 | SPY | ETF | 88.44 | 88.69 | 88.36 | 88.48 | 1022300.0 |
| 2002-08-14 12:00:00 | SPY | ETF | 88.44 | 88.8 | 88.35 | 88.69 | 729400.0 |
| 2002-08-14 12:30:00 | SPY | ETF | 88.66 | 89.15 | 88.65 | 88.98 | 1293100.0 |
| 2002-08-14 13:00:00 | SPY | ETF | 88.98 | 89.0 | 88.5 | 88.55 | 818400.0 |
| 2002-08-14 13:30:00 | SPY | ETF | 88.52 | 89.99 | 88.52 | 89.84 | 4590900.0 |
| 2002-08-14 14:00:00 | SPY | ETF | 89.84 | 90.65 | 89.82 | 90.4 | 3807900.0 |
| 2002-08-14 14:30:00 | SPY | ETF | 90.4 | 91.38 | 90.35 | 91.21 | 4895100.0 |
| 2002-08-14 15:00:00 | SPY | ETF | 91.27 | 92.2 | 91.02 | 91.95 | 8133500.0 |
| 2002-08-14 15:30:00 | SPY | ETF | 92.04 | 92.62 | 91.77 | 92.35 | 7756300.0 |
| 2002-08-14 16:00:00 | SPY | ETF | 92.38 | 92.45 | 92.21 | 92.22 | 1691100.0 |
| 2002-08-14 09:30:00 | QQQ | ETF | 22.67 | 22.82 | 22.54 | 22.7 | 11119900.0 |
| 2002-08-14 10:00:00 | QQQ | ETF | 22.67 | 22.71 | 22.47 | 22.55 | 10720500.0 |
| 2002-08-14 10:30:00 | QQQ | ETF | 22.54 | 22.89 | 22.52 | 22.78 | 6828700.0 |
| 2002-08-14 11:00:00 | QQQ | ETF | 22.8 | 22.85 | 22.66 | 22.67 | 3731700.0 |
| 2002-08-14 11:30:00 | QQQ | ETF | 22.7 | 22.76 | 22.63 | 22.72 | 2532200.0 |
| 2002-08-14 12:00:00 | QQQ | ETF | 22.72 | 22.81 | 22.67 | 22.79 | 1980400.0 |
| 2002-08-14 12:30:00 | QQQ | ETF | 22.8 | 22.98 | 22.78 | 22.93 | 3914700.0 |
| 2002-08-14 13:00:00 | QQQ | ETF | 22.93 | 22.96 | 22.82 | 22.85 | 2867600.0 |
| 2002-08-14 13:30:00 | QQQ | ETF | 22.85 | 23.27 | 22.83 | 23.23 | 11211200.0 |
| 2002-08-14 14:00:00 | QQQ | ETF | 23.23 | 23.5 | 23.22 | 23.43 | 9540400.0 |
| 2002-08-14 14:30:00 | QQQ | ETF | 23.43 | 23.8 | 23.4 | 23.74 | 9056600.0 |
| 2002-08-14 15:00:00 | QQQ | ETF | 23.71 | 23.95 | 23.66 | 23.87 | 10879900.0 |
| 2002-08-14 15:30:00 | QQQ | ETF | 23.86 | 24.12 | 23.82 | 24.03 | 12783700.0 |
| 2002-08-14 16:00:00 | QQQ | ETF | 24.05 | 24.08 | 23.96 | 24.04 | 833700.0 |
| 2002-08-14 09:30:00 | IWM | ETF | 37.775 | 37.955 | 37.625 | 37.725 | 682600.0 |
| 2002-08-14 10:00:00 | IWM | ETF | 37.685 | 37.685 | 37.075 | 37.415 | 478000.0 |
| 2002-08-14 10:30:00 | IWM | ETF | 37.415 | 37.875 | 37.34 | 37.82 | 321800.0 |
| 2002-08-14 11:00:00 | IWM | ETF | 37.715 | 37.83 | 37.595 | 37.595 | 162800.0 |
| 2002-08-14 11:30:00 | IWM | ETF | 37.585 | 37.66 | 37.545 | 37.6 | 82600.0 |
| 2002-08-14 12:00:00 | IWM | ETF | 37.545 | 37.62 | 37.535 | 37.555 | 32600.0 |
| 2002-08-14 12:30:00 | IWM | ETF | 37.635 | 37.75 | 37.57 | 37.725 | 73000.0 |
| 2002-08-14 13:00:00 | IWM | ETF | 37.695 | 37.725 | 37.625 | 37.625 | 19400.0 |
| 2002-08-14 13:30:00 | IWM | ETF | 37.63 | 38.02 | 37.63 | 38.02 | 383800.0 |
| 2002-08-14 14:00:00 | IWM | ETF | 38.02 | 38.25 | 38.0 | 38.225 | 314000.0 |
| 2002-08-14 14:30:00 | IWM | ETF | 38.225 | 38.445 | 38.19 | 38.445 | 158000.0 |
| 2002-08-14 15:00:00 | IWM | ETF | 38.45 | 38.775 | 38.395 | 38.72 | 979400.0 |
| 2002-08-14 15:30:00 | IWM | ETF | 38.65 | 38.955 | 38.58 | 38.85 | 308800.0 |
| 2002-08-14 16:00:00 | IWM | ETF | 38.8 | 38.84 | 38.8 | 38.84 | 4400.0 |
| 2002-08-14 09:30:00 | DIA | ETF | 85.0 | 85.15 | 84.56 | 84.64 | 868600.0 |
| 2002-08-14 10:00:00 | DIA | ETF | 84.61 | 84.69 | 83.7 | 84.0 | 1416400.0 |
| 2002-08-14 10:30:00 | DIA | ETF | 84.0 | 84.8 | 83.8 | 84.45 | 1118900.0 |
| 2002-08-14 11:00:00 | DIA | ETF | 84.46 | 84.6 | 84.02 | 84.06 | 561500.0 |
| 2002-08-14 11:30:00 | DIA | ETF | 84.08 | 84.24 | 83.88 | 83.88 | 492400.0 |
| 2002-08-14 12:00:00 | DIA | ETF | 83.9 | 84.24 | 83.72 | 84.18 | 445000.0 |
| 2002-08-14 12:30:00 | DIA | ETF | 84.18 | 84.49 | 84.07 | 84.37 | 608300.0 |
| 2002-08-14 13:00:00 | DIA | ETF | 84.37 | 84.41 | 83.85 | 83.94 | 468900.0 |
> showing 50 of 569 rows — these rows as CSV