PREVIEW / etf_30min / 2001-06-14
file: by_date/etf_30min/2001/2001-06-14.parquet size: 15 KB rows: 367
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-14 09:30:00 | SPY | ETF | 124.18 | 124.3 | 123.71 | 124.15 | 2039200.0 |
| 2001-06-14 10:00:00 | SPY | ETF | 124.12 | 124.24 | 123.65 | 123.89 | 1508800.0 |
| 2001-06-14 10:30:00 | SPY | ETF | 123.82 | 123.85 | 123.3 | 123.42 | 743500.0 |
| 2001-06-14 11:00:00 | SPY | ETF | 123.43 | 123.49 | 122.96 | 123.26 | 794600.0 |
| 2001-06-14 11:30:00 | SPY | ETF | 123.29 | 123.48 | 123.02 | 123.48 | 526400.0 |
| 2001-06-14 12:00:00 | SPY | ETF | 123.45 | 123.54 | 123.2 | 123.25 | 315600.0 |
| 2001-06-14 12:30:00 | SPY | ETF | 123.24 | 123.5 | 123.12 | 123.18 | 142900.0 |
| 2001-06-14 13:00:00 | SPY | ETF | 123.14 | 123.3 | 123.05 | 123.15 | 502900.0 |
| 2001-06-14 13:30:00 | SPY | ETF | 123.1 | 123.14 | 122.8 | 122.88 | 1018100.0 |
| 2001-06-14 14:00:00 | SPY | ETF | 122.88 | 123.0 | 122.55 | 122.88 | 906600.0 |
| 2001-06-14 14:30:00 | SPY | ETF | 122.89 | 123.2 | 122.76 | 122.96 | 712300.0 |
| 2001-06-14 15:00:00 | SPY | ETF | 122.9 | 123.43 | 122.86 | 123.0 | 986900.0 |
| 2001-06-14 15:30:00 | SPY | ETF | 123.0 | 123.0 | 122.24 | 122.48 | 1611800.0 |
| 2001-06-14 16:00:00 | SPY | ETF | 122.4 | 122.48 | 121.75 | 122.0 | 471300.0 |
| 2001-06-14 16:30:00 | SPY | ETF | 123.17 | 123.17 | 121.9 | 121.9 | 25900.0 |
| 2001-06-14 17:00:00 | SPY | ETF | 122.12 | 122.12 | 122.12 | 122.12 | 200.0 |
| 2001-06-14 17:30:00 | SPY | ETF | 121.84 | 121.84 | 121.84 | 121.84 | 300.0 |
| 2001-06-14 09:30:00 | QQQ | ETF | 44.02 | 44.4 | 43.59 | 44.24 | 13254800.0 |
| 2001-06-14 10:00:00 | QQQ | ETF | 44.2 | 44.3 | 43.7 | 43.81 | 10276600.0 |
| 2001-06-14 10:30:00 | QQQ | ETF | 43.79 | 43.81 | 43.27 | 43.43 | 8629500.0 |
| 2001-06-14 11:00:00 | QQQ | ETF | 43.43 | 43.5 | 43.1 | 43.44 | 6433600.0 |
| 2001-06-14 11:30:00 | QQQ | ETF | 43.44 | 43.7 | 43.3 | 43.68 | 4076200.0 |
| 2001-06-14 12:00:00 | QQQ | ETF | 43.68 | 43.79 | 43.41 | 43.47 | 4255600.0 |
| 2001-06-14 12:30:00 | QQQ | ETF | 43.45 | 43.65 | 43.3 | 43.31 | 2520500.0 |
| 2001-06-14 13:00:00 | QQQ | ETF | 43.31 | 43.48 | 43.15 | 43.3 | 2777000.0 |
| 2001-06-14 13:30:00 | QQQ | ETF | 43.27 | 43.35 | 43.0 | 43.01 | 4201500.0 |
| 2001-06-14 14:00:00 | QQQ | ETF | 43.01 | 43.06 | 42.7 | 42.97 | 7611500.0 |
| 2001-06-14 14:30:00 | QQQ | ETF | 43.0 | 43.2 | 42.81 | 42.95 | 5409700.0 |
| 2001-06-14 15:00:00 | QQQ | ETF | 42.96 | 43.45 | 42.9 | 43.04 | 6128600.0 |
| 2001-06-14 15:30:00 | QQQ | ETF | 43.05 | 43.07 | 42.61 | 42.67 | 9203600.0 |
| 2001-06-14 16:00:00 | QQQ | ETF | 42.65 | 42.75 | 42.0 | 42.27 | 3101300.0 |
| 2001-06-14 16:30:00 | QQQ | ETF | 42.26 | 42.4 | 42.0 | 42.38 | 150100.0 |
| 2001-06-14 17:00:00 | QQQ | ETF | 42.25 | 42.5 | 42.25 | 42.33 | 118100.0 |
| 2001-06-14 17:30:00 | QQQ | ETF | 42.35 | 42.38 | 42.25 | 42.3 | 23600.0 |
| 2001-06-14 18:00:00 | QQQ | ETF | 42.35 | 42.35 | 42.2 | 42.3 | 24600.0 |
| 2001-06-14 09:30:00 | IWM | ETF | 49.875 | 50.025 | 49.75 | 49.92 | 125600.0 |
| 2001-06-14 10:00:00 | IWM | ETF | 49.915 | 49.95 | 49.75 | 49.82 | 8800.0 |
| 2001-06-14 10:30:00 | IWM | ETF | 49.81 | 49.82 | 49.58 | 49.595 | 70200.0 |
| 2001-06-14 11:00:00 | IWM | ETF | 49.6 | 49.6 | 49.35 | 49.54 | 116600.0 |
| 2001-06-14 11:30:00 | IWM | ETF | 49.535 | 49.625 | 49.53 | 49.62 | 5400.0 |
| 2001-06-14 12:00:00 | IWM | ETF | 49.64 | 49.64 | 49.505 | 49.6 | 30200.0 |
| 2001-06-14 12:30:00 | IWM | ETF | 49.595 | 49.595 | 49.52 | 49.52 | 3600.0 |
| 2001-06-14 13:00:00 | IWM | ETF | 49.515 | 49.55 | 49.475 | 49.475 | 54400.0 |
| 2001-06-14 13:30:00 | IWM | ETF | 49.475 | 49.475 | 49.4 | 49.4 | 43200.0 |
| 2001-06-14 14:00:00 | IWM | ETF | 49.4 | 49.4 | 49.25 | 49.365 | 29400.0 |
| 2001-06-14 14:30:00 | IWM | ETF | 49.38 | 49.425 | 49.275 | 49.395 | 153400.0 |
| 2001-06-14 15:00:00 | IWM | ETF | 49.385 | 49.575 | 49.385 | 49.43 | 34400.0 |
| 2001-06-14 15:30:00 | IWM | ETF | 49.43 | 49.43 | 49.075 | 49.31 | 170600.0 |
| 2001-06-14 16:00:00 | IWM | ETF | 49.205 | 49.205 | 49.075 | 49.075 | 13200.0 |
| 2001-06-14 09:30:00 | DIA | ETF | 108.2 | 108.2 | 107.65 | 108.07 | 676900.0 |
> showing 50 of 367 rows — these rows as CSV