PREVIEW / etf_30min / 2001-05-17
file: by_date/etf_30min/2001/2001-05-17.parquet size: 15 KB rows: 398
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-05-17 09:30:00 | SPY | ETF | 128.97 | 129.7 | 128.83 | 129.61 | 2066100.0 |
| 2001-05-17 10:00:00 | SPY | ETF | 129.6 | 130.08 | 129.45 | 129.47 | 1258100.0 |
| 2001-05-17 10:30:00 | SPY | ETF | 129.47 | 129.55 | 128.56 | 129.09 | 1170300.0 |
| 2001-05-17 11:00:00 | SPY | ETF | 129.07 | 129.21 | 128.78 | 128.9 | 407600.0 |
| 2001-05-17 11:30:00 | SPY | ETF | 128.85 | 129.43 | 128.81 | 129.21 | 562000.0 |
| 2001-05-17 12:00:00 | SPY | ETF | 129.29 | 129.59 | 129.21 | 129.51 | 351000.0 |
| 2001-05-17 12:30:00 | SPY | ETF | 129.5 | 129.71 | 129.37 | 129.71 | 595800.0 |
| 2001-05-17 13:00:00 | SPY | ETF | 129.74 | 130.07 | 129.61 | 129.91 | 1131200.0 |
| 2001-05-17 13:30:00 | SPY | ETF | 129.95 | 129.99 | 129.37 | 129.38 | 732700.0 |
| 2001-05-17 14:00:00 | SPY | ETF | 129.41 | 129.79 | 129.26 | 129.65 | 500300.0 |
| 2001-05-17 14:30:00 | SPY | ETF | 129.84 | 129.84 | 129.04 | 129.07 | 712300.0 |
| 2001-05-17 15:00:00 | SPY | ETF | 129.19 | 129.45 | 129.06 | 129.28 | 549200.0 |
| 2001-05-17 15:30:00 | SPY | ETF | 129.28 | 129.66 | 129.2 | 129.31 | 908100.0 |
| 2001-05-17 16:00:00 | SPY | ETF | 129.3 | 129.39 | 129.15 | 129.15 | 595400.0 |
| 2001-05-17 16:30:00 | SPY | ETF | 129.12 | 129.17 | 129.12 | 129.12 | 5500.0 |
| 2001-05-17 17:30:00 | SPY | ETF | 128.8 | 128.8 | 128.8 | 128.8 | 4300.0 |
| 2001-05-17 09:30:00 | QQQ | ETF | 47.45 | 48.33 | 47.3 | 48.28 | 11360600.0 |
| 2001-05-17 10:00:00 | QQQ | ETF | 48.29 | 48.47 | 47.83 | 47.87 | 9030700.0 |
| 2001-05-17 10:30:00 | QQQ | ETF | 47.85 | 47.99 | 47.39 | 47.83 | 8145100.0 |
| 2001-05-17 11:00:00 | QQQ | ETF | 47.85 | 47.97 | 47.51 | 47.62 | 3147900.0 |
| 2001-05-17 11:30:00 | QQQ | ETF | 47.63 | 48.09 | 47.51 | 47.97 | 2064500.0 |
| 2001-05-17 12:00:00 | QQQ | ETF | 47.99 | 48.32 | 47.95 | 48.24 | 2532000.0 |
| 2001-05-17 12:30:00 | QQQ | ETF | 48.26 | 48.4 | 48.08 | 48.36 | 2242700.0 |
| 2001-05-17 13:00:00 | QQQ | ETF | 48.35 | 48.79 | 48.29 | 48.65 | 4707300.0 |
| 2001-05-17 13:30:00 | QQQ | ETF | 48.65 | 48.7 | 48.05 | 48.12 | 5306800.0 |
| 2001-05-17 14:00:00 | QQQ | ETF | 48.13 | 48.31 | 47.71 | 48.25 | 8077900.0 |
| 2001-05-17 14:30:00 | QQQ | ETF | 48.23 | 48.3 | 47.6 | 47.6 | 4243600.0 |
| 2001-05-17 15:00:00 | QQQ | ETF | 47.64 | 47.98 | 47.45 | 47.69 | 3950700.0 |
| 2001-05-17 15:30:00 | QQQ | ETF | 47.66 | 48.1 | 47.61 | 48.03 | 4822100.0 |
| 2001-05-17 16:00:00 | QQQ | ETF | 48.0 | 48.1 | 47.84 | 47.95 | 1309200.0 |
| 2001-05-17 16:30:00 | QQQ | ETF | 48.01 | 48.25 | 47.5 | 47.71 | 67400.0 |
| 2001-05-17 17:00:00 | QQQ | ETF | 47.75 | 47.75 | 47.47 | 47.5 | 55100.0 |
| 2001-05-17 17:30:00 | QQQ | ETF | 47.5 | 47.58 | 47.4 | 47.4 | 66600.0 |
| 2001-05-17 18:00:00 | QQQ | ETF | 47.45 | 47.5 | 47.31 | 47.31 | 31800.0 |
| 2001-05-17 09:30:00 | IWM | ETF | 49.875 | 50.2 | 49.875 | 50.15 | 31800.0 |
| 2001-05-17 10:00:00 | IWM | ETF | 50.1 | 50.325 | 50.1 | 50.225 | 35400.0 |
| 2001-05-17 10:30:00 | IWM | ETF | 50.125 | 50.19 | 49.75 | 49.75 | 35600.0 |
| 2001-05-17 11:00:00 | IWM | ETF | 50.05 | 50.05 | 50.02 | 50.02 | 11000.0 |
| 2001-05-17 11:30:00 | IWM | ETF | 50.0 | 50.145 | 49.97 | 50.145 | 10200.0 |
| 2001-05-17 12:00:00 | IWM | ETF | 50.145 | 50.22 | 50.125 | 50.22 | 2800.0 |
| 2001-05-17 12:30:00 | IWM | ETF | 50.225 | 50.26 | 50.025 | 50.25 | 2600.0 |
| 2001-05-17 13:00:00 | IWM | ETF | 50.32 | 50.425 | 50.25 | 50.25 | 8200.0 |
| 2001-05-17 13:30:00 | IWM | ETF | 50.4 | 50.425 | 50.2 | 50.375 | 2400.0 |
| 2001-05-17 14:00:00 | IWM | ETF | 50.375 | 50.375 | 50.175 | 50.2 | 2400.0 |
| 2001-05-17 14:30:00 | IWM | ETF | 50.34 | 50.34 | 50.22 | 50.25 | 2200.0 |
| 2001-05-17 15:00:00 | IWM | ETF | 50.25 | 50.25 | 50.05 | 50.055 | 2800.0 |
| 2001-05-17 15:30:00 | IWM | ETF | 50.05 | 50.375 | 50.05 | 50.375 | 18400.0 |
| 2001-05-17 16:00:00 | IWM | ETF | 50.39 | 50.39 | 50.375 | 50.38 | 3200.0 |
| 2001-05-17 09:30:00 | DIA | ETF | 112.4 | 113.1 | 112.15 | 112.91 | 894900.0 |
| 2001-05-17 10:00:00 | DIA | ETF | 113.0 | 113.39 | 112.9 | 112.93 | 1038300.0 |
> showing 50 of 398 rows — these rows as CSV