PREVIEW / etf_30min / 2002-03-28
file: by_date/etf_30min/2002/2002-03-28.parquet size: 18 KB rows: 489
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-28 09:30:00 | SPY | ETF | 114.97 | 115.49 | 114.68 | 115.37 | 3129000.0 |
| 2002-03-28 10:00:00 | SPY | ETF | 115.41 | 115.77 | 115.37 | 115.5 | 2850200.0 |
| 2002-03-28 10:30:00 | SPY | ETF | 115.52 | 115.59 | 115.41 | 115.48 | 1072300.0 |
| 2002-03-28 11:00:00 | SPY | ETF | 115.49 | 115.6 | 115.33 | 115.37 | 758700.0 |
| 2002-03-28 11:30:00 | SPY | ETF | 115.38 | 115.38 | 115.04 | 115.04 | 1104200.0 |
| 2002-03-28 12:00:00 | SPY | ETF | 115.03 | 115.19 | 114.98 | 115.12 | 727000.0 |
| 2002-03-28 12:30:00 | SPY | ETF | 115.1 | 115.3 | 114.9 | 114.9 | 653000.0 |
| 2002-03-28 13:00:00 | SPY | ETF | 114.92 | 115.15 | 114.72 | 115.15 | 1164400.0 |
| 2002-03-28 13:30:00 | SPY | ETF | 115.15 | 115.29 | 115.02 | 115.21 | 532500.0 |
| 2002-03-28 14:00:00 | SPY | ETF | 115.19 | 115.36 | 114.99 | 115.3 | 696300.0 |
| 2002-03-28 14:30:00 | SPY | ETF | 115.28 | 115.44 | 115.16 | 115.25 | 583100.0 |
| 2002-03-28 15:00:00 | SPY | ETF | 115.2 | 115.34 | 115.1 | 115.26 | 378000.0 |
| 2002-03-28 15:30:00 | SPY | ETF | 115.24 | 115.27 | 114.89 | 114.91 | 2173500.0 |
| 2002-03-28 16:00:00 | SPY | ETF | 114.9 | 115.07 | 114.43 | 114.5 | 1533300.0 |
| 2002-03-28 16:30:00 | SPY | ETF | 114.5 | 114.5 | 114.3 | 114.45 | 9400.0 |
| 2002-03-28 17:00:00 | SPY | ETF | 114.42 | 114.56 | 114.42 | 114.45 | 5900.0 |
| 2002-03-28 17:30:00 | SPY | ETF | 114.49 | 114.49 | 114.49 | 114.49 | 3000.0 |
| 2002-03-28 09:30:00 | QQQ | ETF | 36.02 | 36.16 | 35.9 | 36.12 | 8649500.0 |
| 2002-03-28 10:00:00 | QQQ | ETF | 36.14 | 36.36 | 36.11 | 36.25 | 10416100.0 |
| 2002-03-28 10:30:00 | QQQ | ETF | 36.24 | 36.26 | 36.12 | 36.18 | 3969200.0 |
| 2002-03-28 11:00:00 | QQQ | ETF | 36.17 | 36.3 | 36.15 | 36.17 | 3443900.0 |
| 2002-03-28 11:30:00 | QQQ | ETF | 36.16 | 36.21 | 36.07 | 36.08 | 3188200.0 |
| 2002-03-28 12:00:00 | QQQ | ETF | 36.08 | 36.13 | 36.03 | 36.1 | 2840800.0 |
| 2002-03-28 12:30:00 | QQQ | ETF | 36.1 | 36.2 | 36.05 | 36.05 | 1778500.0 |
| 2002-03-28 13:00:00 | QQQ | ETF | 36.05 | 36.17 | 35.95 | 36.15 | 3312400.0 |
| 2002-03-28 13:30:00 | QQQ | ETF | 36.14 | 36.28 | 36.11 | 36.24 | 2353500.0 |
| 2002-03-28 14:00:00 | QQQ | ETF | 36.24 | 36.34 | 36.14 | 36.31 | 2904200.0 |
| 2002-03-28 14:30:00 | QQQ | ETF | 36.28 | 36.37 | 36.24 | 36.27 | 4410900.0 |
| 2002-03-28 15:00:00 | QQQ | ETF | 36.3 | 36.32 | 36.19 | 36.29 | 3423500.0 |
| 2002-03-28 15:30:00 | QQQ | ETF | 36.3 | 36.31 | 36.12 | 36.15 | 6311100.0 |
| 2002-03-28 16:00:00 | QQQ | ETF | 36.14 | 36.25 | 36.04 | 36.09 | 1447900.0 |
| 2002-03-28 16:30:00 | QQQ | ETF | 36.09 | 36.1 | 36.06 | 36.08 | 31400.0 |
| 2002-03-28 17:00:00 | QQQ | ETF | 36.07 | 36.16 | 36.01 | 36.09 | 80700.0 |
| 2002-03-28 17:30:00 | QQQ | ETF | 36.08 | 36.09 | 36.06 | 36.06 | 1600.0 |
| 2002-03-28 18:00:00 | QQQ | ETF | 36.05 | 36.09 | 36.03 | 36.04 | 40400.0 |
| 2002-03-28 09:30:00 | IWM | ETF | 50.45 | 50.675 | 50.4 | 50.65 | 202000.0 |
| 2002-03-28 10:00:00 | IWM | ETF | 50.675 | 50.715 | 50.565 | 50.7 | 295000.0 |
| 2002-03-28 10:30:00 | IWM | ETF | 50.67 | 50.715 | 50.58 | 50.65 | 498000.0 |
| 2002-03-28 11:00:00 | IWM | ETF | 50.635 | 50.68 | 50.55 | 50.575 | 82600.0 |
| 2002-03-28 11:30:00 | IWM | ETF | 50.505 | 50.59 | 50.445 | 50.46 | 43200.0 |
| 2002-03-28 12:00:00 | IWM | ETF | 50.455 | 50.525 | 50.295 | 50.295 | 115400.0 |
| 2002-03-28 12:30:00 | IWM | ETF | 50.325 | 50.44 | 50.325 | 50.385 | 13400.0 |
| 2002-03-28 13:00:00 | IWM | ETF | 50.375 | 50.465 | 50.285 | 50.36 | 16000.0 |
| 2002-03-28 13:30:00 | IWM | ETF | 50.42 | 50.515 | 50.365 | 50.405 | 70600.0 |
| 2002-03-28 14:00:00 | IWM | ETF | 50.395 | 50.5 | 50.395 | 50.5 | 28400.0 |
| 2002-03-28 14:30:00 | IWM | ETF | 50.475 | 50.565 | 50.435 | 50.49 | 19400.0 |
| 2002-03-28 15:00:00 | IWM | ETF | 50.49 | 50.55 | 50.44 | 50.55 | 45200.0 |
| 2002-03-28 15:30:00 | IWM | ETF | 50.465 | 50.465 | 50.225 | 50.225 | 142400.0 |
| 2002-03-28 16:00:00 | IWM | ETF | 50.255 | 50.325 | 50.05 | 50.05 | 144600.0 |
| 2002-03-28 09:30:00 | DIA | ETF | 104.6 | 104.87 | 104.24 | 104.78 | 312800.0 |
> showing 50 of 489 rows — these rows as CSV