PREVIEW / etf_30min / 2001-06-21
file: by_date/etf_30min/2001/2001-06-21.parquet size: 15 KB rows: 380
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-21 09:30:00 | SPY | ETF | 122.22 | 122.8 | 122.15 | 122.47 | 2092200.0 |
| 2001-06-21 10:00:00 | SPY | ETF | 122.51 | 123.44 | 122.46 | 123.23 | 1451600.0 |
| 2001-06-21 10:30:00 | SPY | ETF | 123.23 | 123.33 | 122.7 | 122.85 | 558100.0 |
| 2001-06-21 11:00:00 | SPY | ETF | 122.91 | 123.1 | 122.51 | 122.95 | 647500.0 |
| 2001-06-21 11:30:00 | SPY | ETF | 122.95 | 123.39 | 122.8 | 123.32 | 231000.0 |
| 2001-06-21 12:00:00 | SPY | ETF | 123.31 | 123.46 | 123.09 | 123.38 | 458800.0 |
| 2001-06-21 12:30:00 | SPY | ETF | 123.35 | 123.85 | 123.16 | 123.85 | 820900.0 |
| 2001-06-21 13:00:00 | SPY | ETF | 123.8 | 123.88 | 123.57 | 123.88 | 525400.0 |
| 2001-06-21 13:30:00 | SPY | ETF | 123.85 | 124.3 | 123.76 | 124.22 | 865900.0 |
| 2001-06-21 14:00:00 | SPY | ETF | 124.31 | 124.31 | 123.9 | 124.0 | 522200.0 |
| 2001-06-21 14:30:00 | SPY | ETF | 124.05 | 124.1 | 123.86 | 123.96 | 713900.0 |
| 2001-06-21 15:00:00 | SPY | ETF | 124.05 | 124.28 | 123.65 | 123.65 | 1230500.0 |
| 2001-06-21 15:30:00 | SPY | ETF | 123.66 | 123.97 | 123.66 | 123.88 | 1033500.0 |
| 2001-06-21 16:00:00 | SPY | ETF | 123.86 | 124.04 | 123.55 | 123.55 | 724100.0 |
| 2001-06-21 16:30:00 | SPY | ETF | 123.6 | 123.9 | 123.51 | 123.9 | 2100.0 |
| 2001-06-21 17:00:00 | SPY | ETF | 123.61 | 123.61 | 123.52 | 123.52 | 6200.0 |
| 2001-06-21 17:30:00 | SPY | ETF | 123.55 | 123.55 | 123.55 | 123.55 | 500.0 |
| 2001-06-21 09:30:00 | QQQ | ETF | 42.67 | 43.1 | 42.3 | 42.57 | 9690300.0 |
| 2001-06-21 10:00:00 | QQQ | ETF | 42.54 | 43.17 | 42.51 | 43.02 | 6582300.0 |
| 2001-06-21 10:30:00 | QQQ | ETF | 43.03 | 43.1 | 42.56 | 42.68 | 4168700.0 |
| 2001-06-21 11:00:00 | QQQ | ETF | 42.72 | 43.03 | 42.49 | 42.91 | 2893000.0 |
| 2001-06-21 11:30:00 | QQQ | ETF | 42.91 | 43.3 | 42.75 | 43.26 | 3074800.0 |
| 2001-06-21 12:00:00 | QQQ | ETF | 43.23 | 43.3 | 43.01 | 43.2 | 2217600.0 |
| 2001-06-21 12:30:00 | QQQ | ETF | 43.18 | 43.53 | 43.06 | 43.49 | 3420300.0 |
| 2001-06-21 13:00:00 | QQQ | ETF | 43.52 | 43.7 | 43.3 | 43.65 | 3537400.0 |
| 2001-06-21 13:30:00 | QQQ | ETF | 43.66 | 44.08 | 43.6 | 44.01 | 7099700.0 |
| 2001-06-21 14:00:00 | QQQ | ETF | 44.0 | 44.07 | 43.73 | 43.95 | 5213700.0 |
| 2001-06-21 14:30:00 | QQQ | ETF | 43.92 | 44.05 | 43.7 | 43.88 | 3930000.0 |
| 2001-06-21 15:00:00 | QQQ | ETF | 43.88 | 44.23 | 43.56 | 43.59 | 4599500.0 |
| 2001-06-21 15:30:00 | QQQ | ETF | 43.61 | 43.71 | 43.37 | 43.65 | 6137000.0 |
| 2001-06-21 16:00:00 | QQQ | ETF | 43.66 | 43.72 | 43.3 | 43.39 | 1600000.0 |
| 2001-06-21 16:30:00 | QQQ | ETF | 43.4 | 43.65 | 43.25 | 43.26 | 1050200.0 |
| 2001-06-21 17:00:00 | QQQ | ETF | 43.32 | 43.5 | 43.2 | 43.31 | 305900.0 |
| 2001-06-21 17:30:00 | QQQ | ETF | 43.31 | 43.33 | 43.21 | 43.21 | 17300.0 |
| 2001-06-21 18:00:00 | QQQ | ETF | 43.28 | 43.32 | 43.17 | 43.29 | 12100.0 |
| 2001-06-21 09:30:00 | IWM | ETF | 49.325 | 49.7 | 49.325 | 49.445 | 68400.0 |
| 2001-06-21 10:00:00 | IWM | ETF | 49.45 | 49.69 | 49.45 | 49.675 | 58400.0 |
| 2001-06-21 10:30:00 | IWM | ETF | 49.685 | 49.685 | 49.4 | 49.415 | 17400.0 |
| 2001-06-21 11:00:00 | IWM | ETF | 49.425 | 49.425 | 49.275 | 49.325 | 54400.0 |
| 2001-06-21 11:30:00 | IWM | ETF | 49.325 | 49.35 | 49.3 | 49.3 | 34200.0 |
| 2001-06-21 12:00:00 | IWM | ETF | 49.425 | 49.49 | 49.375 | 49.49 | 26600.0 |
| 2001-06-21 12:30:00 | IWM | ETF | 49.435 | 49.51 | 49.4 | 49.5 | 60000.0 |
| 2001-06-21 13:00:00 | IWM | ETF | 49.55 | 49.645 | 49.505 | 49.575 | 158400.0 |
| 2001-06-21 13:30:00 | IWM | ETF | 49.595 | 49.75 | 49.595 | 49.74 | 25400.0 |
| 2001-06-21 14:00:00 | IWM | ETF | 49.75 | 49.75 | 49.605 | 49.625 | 32200.0 |
| 2001-06-21 14:30:00 | IWM | ETF | 49.645 | 49.65 | 49.61 | 49.63 | 14800.0 |
| 2001-06-21 15:00:00 | IWM | ETF | 49.625 | 49.8 | 49.58 | 49.585 | 71200.0 |
| 2001-06-21 15:30:00 | IWM | ETF | 49.575 | 49.69 | 49.4 | 49.605 | 76200.0 |
| 2001-06-21 16:00:00 | IWM | ETF | 49.6 | 49.655 | 49.495 | 49.495 | 20400.0 |
| 2001-06-21 09:30:00 | DIA | ETF | 106.35 | 106.56 | 106.0 | 106.3 | 234400.0 |
> showing 50 of 380 rows — these rows as CSV