PREVIEW / etf_30min / 2001-05-21
file: by_date/etf_30min/2001/2001-05-21.parquet size: 15 KB rows: 386
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-21 09:30:00 | SPY | ETF | 129.84 | 129.84 | 129.15 | 129.49 | 697600.0 |
| 2001-05-21 10:00:00 | SPY | ETF | 129.5 | 130.21 | 129.42 | 130.08 | 1149000.0 |
| 2001-05-21 10:30:00 | SPY | ETF | 130.15 | 130.19 | 129.75 | 130.17 | 1109300.0 |
| 2001-05-21 11:00:00 | SPY | ETF | 130.09 | 130.5 | 130.07 | 130.5 | 1463000.0 |
| 2001-05-21 11:30:00 | SPY | ETF | 130.52 | 130.93 | 130.49 | 130.79 | 1159000.0 |
| 2001-05-21 12:00:00 | SPY | ETF | 130.9 | 131.11 | 130.79 | 130.85 | 416600.0 |
| 2001-05-21 12:30:00 | SPY | ETF | 130.84 | 130.95 | 130.74 | 130.82 | 274300.0 |
| 2001-05-21 13:00:00 | SPY | ETF | 130.78 | 131.18 | 130.78 | 130.9 | 280000.0 |
| 2001-05-21 13:30:00 | SPY | ETF | 130.86 | 130.86 | 130.57 | 130.57 | 322600.0 |
| 2001-05-21 14:00:00 | SPY | ETF | 130.61 | 130.93 | 130.52 | 130.87 | 236700.0 |
| 2001-05-21 14:30:00 | SPY | ETF | 130.87 | 131.32 | 130.8 | 131.32 | 474300.0 |
| 2001-05-21 15:00:00 | SPY | ETF | 131.33 | 131.65 | 131.24 | 131.6 | 1070500.0 |
| 2001-05-21 15:30:00 | SPY | ETF | 131.52 | 131.8 | 131.41 | 131.77 | 1260400.0 |
| 2001-05-21 16:00:00 | SPY | ETF | 131.8 | 131.84 | 130.95 | 131.61 | 593500.0 |
| 2001-05-21 16:30:00 | SPY | ETF | 131.65 | 131.65 | 131.65 | 131.65 | 1000.0 |
| 2001-05-21 17:30:00 | SPY | ETF | 131.7 | 131.7 | 131.65 | 131.65 | 600.0 |
| 2001-05-21 09:30:00 | QQQ | ETF | 48.17 | 48.57 | 47.96 | 48.31 | 10377300.0 |
| 2001-05-21 10:00:00 | QQQ | ETF | 48.3 | 49.1 | 48.3 | 49.0 | 8952000.0 |
| 2001-05-21 10:30:00 | QQQ | ETF | 49.04 | 49.38 | 48.83 | 49.35 | 5460500.0 |
| 2001-05-21 11:00:00 | QQQ | ETF | 49.33 | 49.71 | 49.29 | 49.65 | 4637000.0 |
| 2001-05-21 11:30:00 | QQQ | ETF | 49.67 | 50.14 | 49.53 | 50.07 | 9710700.0 |
| 2001-05-21 12:00:00 | QQQ | ETF | 50.02 | 50.47 | 50.0 | 50.21 | 7938000.0 |
| 2001-05-21 12:30:00 | QQQ | ETF | 50.25 | 50.29 | 50.11 | 50.25 | 3449400.0 |
| 2001-05-21 13:00:00 | QQQ | ETF | 50.24 | 50.55 | 50.23 | 50.3 | 3110300.0 |
| 2001-05-21 13:30:00 | QQQ | ETF | 50.3 | 50.3 | 50.0 | 50.01 | 4407800.0 |
| 2001-05-21 14:00:00 | QQQ | ETF | 50.07 | 50.37 | 49.9 | 50.29 | 4230200.0 |
| 2001-05-21 14:30:00 | QQQ | ETF | 50.35 | 50.75 | 50.23 | 50.75 | 5373900.0 |
| 2001-05-21 15:00:00 | QQQ | ETF | 50.75 | 50.87 | 50.59 | 50.83 | 4643600.0 |
| 2001-05-21 15:30:00 | QQQ | ETF | 50.78 | 51.12 | 50.75 | 51.1 | 7231500.0 |
| 2001-05-21 16:00:00 | QQQ | ETF | 51.08 | 51.15 | 50.9 | 51.1 | 2102500.0 |
| 2001-05-21 16:30:00 | QQQ | ETF | 51.1 | 51.11 | 51.0 | 51.05 | 50900.0 |
| 2001-05-21 17:00:00 | QQQ | ETF | 51.05 | 51.12 | 51.0 | 51.1 | 24400.0 |
| 2001-05-21 17:30:00 | QQQ | ETF | 51.02 | 51.07 | 51.02 | 51.03 | 11500.0 |
| 2001-05-21 18:00:00 | QQQ | ETF | 51.02 | 51.05 | 51.02 | 51.03 | 9800.0 |
| 2001-05-21 09:30:00 | IWM | ETF | 50.425 | 50.475 | 50.35 | 50.475 | 17200.0 |
| 2001-05-21 10:00:00 | IWM | ETF | 50.475 | 50.7 | 50.475 | 50.6 | 52400.0 |
| 2001-05-21 10:30:00 | IWM | ETF | 50.67 | 50.875 | 50.67 | 50.825 | 9400.0 |
| 2001-05-21 11:00:00 | IWM | ETF | 50.8 | 50.9 | 50.73 | 50.9 | 11400.0 |
| 2001-05-21 11:30:00 | IWM | ETF | 50.9 | 51.075 | 50.9 | 51.075 | 18000.0 |
| 2001-05-21 12:00:00 | IWM | ETF | 51.075 | 51.075 | 50.95 | 51.075 | 7000.0 |
| 2001-05-21 12:30:00 | IWM | ETF | 51.025 | 51.05 | 51.0 | 51.05 | 14400.0 |
| 2001-05-21 13:00:00 | IWM | ETF | 51.05 | 51.1 | 51.05 | 51.1 | 4000.0 |
| 2001-05-21 13:30:00 | IWM | ETF | 51.1 | 51.12 | 50.995 | 51.095 | 23000.0 |
| 2001-05-21 14:00:00 | IWM | ETF | 51.0 | 51.0 | 51.0 | 51.0 | 1200.0 |
| 2001-05-21 14:30:00 | IWM | ETF | 50.95 | 51.15 | 50.95 | 51.15 | 109200.0 |
| 2001-05-21 15:00:00 | IWM | ETF | 51.175 | 51.275 | 51.175 | 51.275 | 65400.0 |
| 2001-05-21 15:30:00 | IWM | ETF | 51.275 | 51.375 | 51.275 | 51.32 | 39200.0 |
| 2001-05-21 16:00:00 | IWM | ETF | 51.45 | 51.45 | 51.45 | 51.45 | 1800.0 |
| 2001-05-21 09:30:00 | DIA | ETF | 113.0 | 113.0 | 112.4 | 112.65 | 459300.0 |
| 2001-05-21 10:00:00 | DIA | ETF | 112.65 | 113.15 | 112.55 | 112.78 | 570300.0 |
> showing 50 of 386 rows — these rows as CSV