PREVIEW / etf_30min / 2001-05-09
file: by_date/etf_30min/2001/2001-05-09.parquet size: 14 KB rows: 360
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-09 09:30:00 | SPY | ETF | 125.25 | 125.66 | 125.25 | 125.52 | 1759100.0 |
| 2001-05-09 10:00:00 | SPY | ETF | 125.6 | 125.63 | 125.06 | 125.45 | 836700.0 |
| 2001-05-09 10:30:00 | SPY | ETF | 125.45 | 125.74 | 125.16 | 125.6 | 763700.0 |
| 2001-05-09 11:00:00 | SPY | ETF | 125.56 | 126.3 | 125.5 | 126.04 | 1259900.0 |
| 2001-05-09 11:30:00 | SPY | ETF | 126.01 | 126.3 | 125.93 | 126.2 | 619400.0 |
| 2001-05-09 12:00:00 | SPY | ETF | 126.2 | 126.43 | 126.01 | 126.35 | 467400.0 |
| 2001-05-09 12:30:00 | SPY | ETF | 126.34 | 126.55 | 126.25 | 126.38 | 620900.0 |
| 2001-05-09 13:00:00 | SPY | ETF | 126.42 | 126.44 | 126.05 | 126.17 | 460800.0 |
| 2001-05-09 13:30:00 | SPY | ETF | 126.12 | 126.3 | 125.89 | 126.0 | 344400.0 |
| 2001-05-09 14:00:00 | SPY | ETF | 125.92 | 125.98 | 125.66 | 125.7 | 330100.0 |
| 2001-05-09 14:30:00 | SPY | ETF | 125.8 | 126.0 | 125.62 | 125.66 | 398500.0 |
| 2001-05-09 15:00:00 | SPY | ETF | 125.65 | 125.65 | 125.29 | 125.52 | 557700.0 |
| 2001-05-09 15:30:00 | SPY | ETF | 125.5 | 125.96 | 125.5 | 125.96 | 562100.0 |
| 2001-05-09 16:00:00 | SPY | ETF | 125.83 | 126.5 | 125.65 | 125.82 | 393500.0 |
| 2001-05-09 16:30:00 | SPY | ETF | 125.65 | 125.65 | 125.65 | 125.65 | 500.0 |
| 2001-05-09 17:00:00 | SPY | ETF | 125.59 | 125.7 | 125.59 | 125.68 | 8600.0 |
| 2001-05-09 17:30:00 | SPY | ETF | 125.68 | 125.68 | 125.62 | 125.62 | 2100.0 |
| 2001-05-09 09:30:00 | QQQ | ETF | 47.05 | 47.1 | 46.51 | 46.9 | 9666800.0 |
| 2001-05-09 10:00:00 | QQQ | ETF | 46.89 | 46.95 | 46.44 | 46.7 | 4763100.0 |
| 2001-05-09 10:30:00 | QQQ | ETF | 46.7 | 47.07 | 46.52 | 47.02 | 4193900.0 |
| 2001-05-09 11:00:00 | QQQ | ETF | 47.02 | 47.64 | 46.95 | 47.3 | 5789200.0 |
| 2001-05-09 11:30:00 | QQQ | ETF | 47.3 | 47.48 | 47.15 | 47.41 | 5087200.0 |
| 2001-05-09 12:00:00 | QQQ | ETF | 47.43 | 47.79 | 47.28 | 47.74 | 3559100.0 |
| 2001-05-09 12:30:00 | QQQ | ETF | 47.74 | 47.95 | 47.7 | 47.85 | 4043500.0 |
| 2001-05-09 13:00:00 | QQQ | ETF | 47.85 | 47.85 | 47.41 | 47.57 | 2250500.0 |
| 2001-05-09 13:30:00 | QQQ | ETF | 47.57 | 47.7 | 47.3 | 47.34 | 2119800.0 |
| 2001-05-09 14:00:00 | QQQ | ETF | 47.36 | 47.4 | 46.81 | 46.95 | 3443000.0 |
| 2001-05-09 14:30:00 | QQQ | ETF | 46.95 | 47.25 | 46.76 | 46.77 | 2950700.0 |
| 2001-05-09 15:00:00 | QQQ | ETF | 46.76 | 46.85 | 46.5 | 46.7 | 3973900.0 |
| 2001-05-09 15:30:00 | QQQ | ETF | 46.74 | 47.01 | 46.56 | 46.73 | 5766500.0 |
| 2001-05-09 16:00:00 | QQQ | ETF | 46.7 | 46.8 | 46.4 | 46.62 | 1443800.0 |
| 2001-05-09 16:30:00 | QQQ | ETF | 46.6 | 47.27 | 46.45 | 46.45 | 47200.0 |
| 2001-05-09 17:00:00 | QQQ | ETF | 46.53 | 46.68 | 46.48 | 46.65 | 16100.0 |
| 2001-05-09 17:30:00 | QQQ | ETF | 46.64 | 46.7 | 46.6 | 46.7 | 36400.0 |
| 2001-05-09 18:00:00 | QQQ | ETF | 46.66 | 46.72 | 46.65 | 46.71 | 3500.0 |
| 2001-05-09 09:30:00 | IWM | ETF | 48.55 | 48.85 | 48.55 | 48.675 | 20000.0 |
| 2001-05-09 10:00:00 | IWM | ETF | 48.73 | 48.85 | 48.675 | 48.85 | 29600.0 |
| 2001-05-09 10:30:00 | IWM | ETF | 48.71 | 48.99 | 48.71 | 48.855 | 14200.0 |
| 2001-05-09 11:00:00 | IWM | ETF | 48.825 | 49.025 | 48.825 | 49.025 | 5800.0 |
| 2001-05-09 11:30:00 | IWM | ETF | 48.925 | 49.125 | 48.925 | 48.975 | 10800.0 |
| 2001-05-09 12:00:00 | IWM | ETF | 48.975 | 49.125 | 48.95 | 49.0 | 4800.0 |
| 2001-05-09 12:30:00 | IWM | ETF | 49.075 | 49.2 | 48.95 | 49.045 | 44600.0 |
| 2001-05-09 13:00:00 | IWM | ETF | 49.045 | 49.165 | 49.045 | 49.045 | 4200.0 |
| 2001-05-09 13:30:00 | IWM | ETF | 49.045 | 49.125 | 48.95 | 48.95 | 13800.0 |
| 2001-05-09 14:00:00 | IWM | ETF | 48.9 | 49.025 | 48.825 | 48.905 | 5800.0 |
| 2001-05-09 14:30:00 | IWM | ETF | 48.905 | 49.05 | 48.85 | 49.025 | 15600.0 |
| 2001-05-09 15:00:00 | IWM | ETF | 48.875 | 48.91 | 48.675 | 48.75 | 27600.0 |
| 2001-05-09 15:30:00 | IWM | ETF | 48.73 | 48.925 | 48.73 | 48.925 | 33400.0 |
| 2001-05-09 16:00:00 | IWM | ETF | 48.7 | 48.73 | 48.7 | 48.73 | 5400.0 |
| 2001-05-09 09:30:00 | DIA | ETF | 108.3 | 108.59 | 108.16 | 108.4 | 274600.0 |
> showing 50 of 360 rows — these rows as CSV