PREVIEW / etf_30min / 2002-09-09
file: by_date/etf_30min/2002/2002-09-09.parquet size: 19 KB rows: 515
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-09-09 09:30:00 | SPY | ETF | 89.1 | 89.48 | 89.1 | 89.23 | 2704600.0 |
| 2002-09-09 10:00:00 | SPY | ETF | 89.2 | 89.3 | 88.88 | 89.05 | 2470200.0 |
| 2002-09-09 10:30:00 | SPY | ETF | 89.06 | 89.38 | 88.8 | 89.37 | 1340400.0 |
| 2002-09-09 11:00:00 | SPY | ETF | 89.3 | 89.64 | 89.01 | 89.1 | 2712400.0 |
| 2002-09-09 11:30:00 | SPY | ETF | 89.1 | 89.28 | 89.0 | 89.09 | 1248900.0 |
| 2002-09-09 12:00:00 | SPY | ETF | 89.1 | 89.49 | 89.08 | 89.4 | 1315800.0 |
| 2002-09-09 12:30:00 | SPY | ETF | 89.41 | 89.95 | 89.33 | 89.92 | 1624000.0 |
| 2002-09-09 13:00:00 | SPY | ETF | 89.95 | 90.28 | 89.77 | 90.22 | 3297100.0 |
| 2002-09-09 13:30:00 | SPY | ETF | 90.25 | 90.38 | 90.03 | 90.1 | 1700700.0 |
| 2002-09-09 14:00:00 | SPY | ETF | 90.08 | 91.05 | 90.04 | 90.95 | 4703400.0 |
| 2002-09-09 14:30:00 | SPY | ETF | 90.99 | 91.25 | 90.88 | 91.2 | 2527600.0 |
| 2002-09-09 15:00:00 | SPY | ETF | 91.15 | 91.35 | 90.81 | 90.98 | 2874900.0 |
| 2002-09-09 15:30:00 | SPY | ETF | 90.97 | 91.27 | 90.8 | 90.8 | 2669100.0 |
| 2002-09-09 16:00:00 | SPY | ETF | 90.84 | 90.85 | 90.59 | 90.66 | 974400.0 |
| 2002-09-09 09:30:00 | QQQ | ETF | 22.67 | 22.72 | 22.54 | 22.57 | 8345100.0 |
| 2002-09-09 10:00:00 | QQQ | ETF | 22.57 | 22.61 | 22.39 | 22.46 | 8552800.0 |
| 2002-09-09 10:30:00 | QQQ | ETF | 22.45 | 22.6 | 22.4 | 22.57 | 4770300.0 |
| 2002-09-09 11:00:00 | QQQ | ETF | 22.6 | 22.65 | 22.47 | 22.49 | 4827900.0 |
| 2002-09-09 11:30:00 | QQQ | ETF | 22.46 | 22.58 | 22.46 | 22.51 | 2493200.0 |
| 2002-09-09 12:00:00 | QQQ | ETF | 22.5 | 22.64 | 22.5 | 22.57 | 1284300.0 |
| 2002-09-09 12:30:00 | QQQ | ETF | 22.57 | 22.83 | 22.56 | 22.8 | 4327000.0 |
| 2002-09-09 13:00:00 | QQQ | ETF | 22.8 | 23.0 | 22.75 | 22.98 | 4383700.0 |
| 2002-09-09 13:30:00 | QQQ | ETF | 22.99 | 23.1 | 22.92 | 23.02 | 4004000.0 |
| 2002-09-09 14:00:00 | QQQ | ETF | 23.0 | 23.3 | 22.96 | 23.27 | 7200100.0 |
| 2002-09-09 14:30:00 | QQQ | ETF | 23.27 | 23.35 | 23.18 | 23.29 | 6606700.0 |
| 2002-09-09 15:00:00 | QQQ | ETF | 23.29 | 23.37 | 23.13 | 23.22 | 5620300.0 |
| 2002-09-09 15:30:00 | QQQ | ETF | 23.22 | 23.34 | 23.16 | 23.18 | 7062800.0 |
| 2002-09-09 16:00:00 | QQQ | ETF | 23.17 | 23.21 | 23.08 | 23.08 | 471000.0 |
| 2002-09-09 09:30:00 | IWM | ETF | 39.05 | 39.05 | 38.69 | 38.7 | 174600.0 |
| 2002-09-09 10:00:00 | IWM | ETF | 38.605 | 38.65 | 38.37 | 38.51 | 116400.0 |
| 2002-09-09 10:30:00 | IWM | ETF | 38.48 | 38.66 | 38.415 | 38.645 | 75800.0 |
| 2002-09-09 11:00:00 | IWM | ETF | 38.65 | 38.775 | 38.6 | 38.63 | 128000.0 |
| 2002-09-09 11:30:00 | IWM | ETF | 38.605 | 38.665 | 38.6 | 38.6 | 47800.0 |
| 2002-09-09 12:00:00 | IWM | ETF | 38.6 | 38.685 | 38.6 | 38.66 | 12400.0 |
| 2002-09-09 12:30:00 | IWM | ETF | 38.685 | 38.84 | 38.68 | 38.84 | 63000.0 |
| 2002-09-09 13:00:00 | IWM | ETF | 38.84 | 38.985 | 38.825 | 38.985 | 106200.0 |
| 2002-09-09 13:30:00 | IWM | ETF | 38.975 | 39.03 | 38.94 | 38.97 | 72200.0 |
| 2002-09-09 14:00:00 | IWM | ETF | 38.985 | 39.255 | 38.985 | 39.255 | 178200.0 |
| 2002-09-09 14:30:00 | IWM | ETF | 39.335 | 39.335 | 39.225 | 39.255 | 41000.0 |
| 2002-09-09 15:00:00 | IWM | ETF | 39.3 | 39.425 | 39.175 | 39.265 | 122800.0 |
| 2002-09-09 15:30:00 | IWM | ETF | 39.27 | 39.31 | 39.03 | 39.03 | 77000.0 |
| 2002-09-09 16:00:00 | IWM | ETF | 39.03 | 39.03 | 39.03 | 39.03 | 3000.0 |
| 2002-09-09 09:30:00 | DIA | ETF | 83.88 | 83.99 | 83.56 | 83.68 | 700300.0 |
| 2002-09-09 10:00:00 | DIA | ETF | 83.68 | 83.8 | 83.35 | 83.53 | 660000.0 |
| 2002-09-09 10:30:00 | DIA | ETF | 83.51 | 83.89 | 83.3 | 83.8 | 474300.0 |
| 2002-09-09 11:00:00 | DIA | ETF | 83.81 | 84.16 | 83.58 | 83.65 | 878900.0 |
| 2002-09-09 11:30:00 | DIA | ETF | 83.64 | 83.85 | 83.58 | 83.68 | 238200.0 |
| 2002-09-09 12:00:00 | DIA | ETF | 83.73 | 84.09 | 83.68 | 83.9 | 179000.0 |
| 2002-09-09 12:30:00 | DIA | ETF | 83.99 | 84.43 | 83.88 | 84.4 | 343000.0 |
| 2002-09-09 13:00:00 | DIA | ETF | 84.37 | 84.72 | 84.27 | 84.68 | 537500.0 |
> showing 50 of 515 rows — these rows as CSV