PREVIEW / etf_30min / 2001-05-16
file: by_date/etf_30min/2001/2001-05-16.parquet size: 15 KB rows: 372
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-16 09:30:00 | SPY | ETF | 124.84 | 125.32 | 124.62 | 124.86 | 1197200.0 |
| 2001-05-16 10:00:00 | SPY | ETF | 124.94 | 125.46 | 124.77 | 125.37 | 633200.0 |
| 2001-05-16 10:30:00 | SPY | ETF | 125.39 | 126.61 | 125.39 | 126.35 | 1613300.0 |
| 2001-05-16 11:00:00 | SPY | ETF | 126.35 | 126.95 | 126.27 | 126.8 | 976400.0 |
| 2001-05-16 11:30:00 | SPY | ETF | 126.8 | 126.92 | 126.52 | 126.63 | 350000.0 |
| 2001-05-16 12:00:00 | SPY | ETF | 126.7 | 126.79 | 126.52 | 126.61 | 276000.0 |
| 2001-05-16 12:30:00 | SPY | ETF | 126.61 | 126.96 | 126.53 | 126.91 | 297500.0 |
| 2001-05-16 13:00:00 | SPY | ETF | 126.93 | 127.26 | 126.93 | 127.15 | 508400.0 |
| 2001-05-16 13:30:00 | SPY | ETF | 127.14 | 127.75 | 127.02 | 127.7 | 986400.0 |
| 2001-05-16 14:00:00 | SPY | ETF | 127.72 | 128.23 | 127.65 | 128.15 | 1043000.0 |
| 2001-05-16 14:30:00 | SPY | ETF | 128.2 | 128.59 | 128.03 | 128.56 | 837200.0 |
| 2001-05-16 15:00:00 | SPY | ETF | 128.58 | 128.95 | 128.42 | 128.67 | 1396500.0 |
| 2001-05-16 15:30:00 | SPY | ETF | 128.67 | 129.2 | 128.57 | 128.96 | 1935800.0 |
| 2001-05-16 16:00:00 | SPY | ETF | 128.97 | 129.07 | 128.39 | 128.39 | 2549500.0 |
| 2001-05-16 16:30:00 | SPY | ETF | 128.93 | 129.05 | 128.92 | 129.05 | 11600.0 |
| 2001-05-16 17:00:00 | SPY | ETF | 128.99 | 129.03 | 128.99 | 129.02 | 15600.0 |
| 2001-05-16 17:30:00 | SPY | ETF | 129.02 | 129.13 | 129.02 | 129.12 | 7700.0 |
| 2001-05-16 09:30:00 | QQQ | ETF | 44.31 | 44.87 | 44.06 | 44.53 | 10647800.0 |
| 2001-05-16 10:00:00 | QQQ | ETF | 44.53 | 45.01 | 44.32 | 44.95 | 5768600.0 |
| 2001-05-16 10:30:00 | QQQ | ETF | 44.9 | 45.66 | 44.86 | 45.45 | 7388900.0 |
| 2001-05-16 11:00:00 | QQQ | ETF | 45.43 | 45.95 | 45.23 | 45.7 | 7316100.0 |
| 2001-05-16 11:30:00 | QQQ | ETF | 45.7 | 45.84 | 45.4 | 45.46 | 2881500.0 |
| 2001-05-16 12:00:00 | QQQ | ETF | 45.53 | 45.74 | 45.45 | 45.6 | 1950100.0 |
| 2001-05-16 12:30:00 | QQQ | ETF | 45.58 | 45.89 | 45.55 | 45.87 | 1447600.0 |
| 2001-05-16 13:00:00 | QQQ | ETF | 45.88 | 46.17 | 45.8 | 46.02 | 3652900.0 |
| 2001-05-16 13:30:00 | QQQ | ETF | 46.03 | 46.53 | 45.93 | 46.53 | 5951700.0 |
| 2001-05-16 14:00:00 | QQQ | ETF | 46.53 | 47.05 | 46.45 | 46.96 | 6642700.0 |
| 2001-05-16 14:30:00 | QQQ | ETF | 46.95 | 47.34 | 46.8 | 47.25 | 6139900.0 |
| 2001-05-16 15:00:00 | QQQ | ETF | 47.27 | 47.46 | 46.94 | 47.15 | 6195700.0 |
| 2001-05-16 15:30:00 | QQQ | ETF | 47.15 | 47.52 | 47.0 | 47.26 | 8258900.0 |
| 2001-05-16 16:00:00 | QQQ | ETF | 47.25 | 47.36 | 46.6 | 47.17 | 2142000.0 |
| 2001-05-16 16:30:00 | QQQ | ETF | 47.19 | 47.36 | 47.14 | 47.34 | 261100.0 |
| 2001-05-16 17:00:00 | QQQ | ETF | 47.31 | 47.4 | 47.25 | 47.34 | 302500.0 |
| 2001-05-16 17:30:00 | QQQ | ETF | 47.34 | 47.48 | 47.26 | 47.44 | 75700.0 |
| 2001-05-16 18:00:00 | QQQ | ETF | 47.42 | 47.49 | 47.35 | 47.42 | 26500.0 |
| 2001-05-16 09:30:00 | IWM | ETF | 48.55 | 48.85 | 48.55 | 48.835 | 37600.0 |
| 2001-05-16 10:00:00 | IWM | ETF | 48.6 | 48.8 | 48.6 | 48.8 | 3800.0 |
| 2001-05-16 10:30:00 | IWM | ETF | 49.05 | 49.275 | 49.05 | 49.275 | 20600.0 |
| 2001-05-16 11:00:00 | IWM | ETF | 49.175 | 49.345 | 49.125 | 49.345 | 129000.0 |
| 2001-05-16 11:30:00 | IWM | ETF | 49.345 | 49.345 | 49.2 | 49.2 | 4400.0 |
| 2001-05-16 12:00:00 | IWM | ETF | 49.295 | 49.295 | 49.175 | 49.245 | 5600.0 |
| 2001-05-16 12:30:00 | IWM | ETF | 49.25 | 49.25 | 49.25 | 49.25 | 20000.0 |
| 2001-05-16 13:00:00 | IWM | ETF | 49.27 | 49.375 | 49.25 | 49.255 | 2000.0 |
| 2001-05-16 13:30:00 | IWM | ETF | 49.275 | 49.4 | 49.275 | 49.4 | 7000.0 |
| 2001-05-16 14:00:00 | IWM | ETF | 49.475 | 49.6 | 49.425 | 49.595 | 63400.0 |
| 2001-05-16 14:30:00 | IWM | ETF | 49.595 | 49.775 | 49.55 | 49.775 | 57400.0 |
| 2001-05-16 15:00:00 | IWM | ETF | 49.745 | 49.85 | 49.675 | 49.75 | 75600.0 |
| 2001-05-16 15:30:00 | IWM | ETF | 49.75 | 49.875 | 49.75 | 49.865 | 96000.0 |
| 2001-05-16 16:00:00 | IWM | ETF | 49.865 | 49.865 | 49.865 | 49.865 | 6600.0 |
| 2001-05-16 09:30:00 | DIA | ETF | 108.4 | 108.9 | 108.35 | 108.59 | 451100.0 |
> showing 50 of 372 rows — these rows as CSV