PREVIEW / etf_30min / 2001-12-03
file: by_date/etf_30min/2001/2001-12-03.parquet size: 16 KB rows: 416
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-12-03 09:30:00 | SPY | ETF | 113.65 | 113.77 | 113.3 | 113.49 | 2109700.0 |
| 2001-12-03 10:00:00 | SPY | ETF | 113.38 | 113.78 | 113.03 | 113.03 | 2159800.0 |
| 2001-12-03 10:30:00 | SPY | ETF | 113.02 | 113.47 | 113.01 | 113.45 | 1180400.0 |
| 2001-12-03 11:00:00 | SPY | ETF | 113.45 | 113.46 | 113.04 | 113.31 | 1349000.0 |
| 2001-12-03 11:30:00 | SPY | ETF | 113.42 | 113.72 | 113.37 | 113.6 | 1726600.0 |
| 2001-12-03 12:00:00 | SPY | ETF | 113.6 | 113.64 | 113.35 | 113.47 | 377300.0 |
| 2001-12-03 12:30:00 | SPY | ETF | 113.47 | 113.91 | 113.43 | 113.87 | 321400.0 |
| 2001-12-03 13:00:00 | SPY | ETF | 113.87 | 114.08 | 113.75 | 114.03 | 781100.0 |
| 2001-12-03 13:30:00 | SPY | ETF | 114.05 | 114.07 | 113.7 | 113.7 | 375900.0 |
| 2001-12-03 14:00:00 | SPY | ETF | 113.67 | 113.84 | 113.61 | 113.71 | 507900.0 |
| 2001-12-03 14:30:00 | SPY | ETF | 113.66 | 113.71 | 113.35 | 113.5 | 725100.0 |
| 2001-12-03 15:00:00 | SPY | ETF | 113.46 | 113.49 | 113.21 | 113.46 | 958600.0 |
| 2001-12-03 15:30:00 | SPY | ETF | 113.47 | 113.75 | 113.36 | 113.42 | 1386300.0 |
| 2001-12-03 16:00:00 | SPY | ETF | 113.36 | 113.99 | 113.25 | 113.5 | 1247100.0 |
| 2001-12-03 16:30:00 | SPY | ETF | 113.33 | 113.37 | 113.27 | 113.27 | 5100.0 |
| 2001-12-03 09:30:00 | QQQ | ETF | 39.29 | 39.6 | 39.19 | 39.27 | 10751600.0 |
| 2001-12-03 10:00:00 | QQQ | ETF | 39.23 | 39.5 | 38.9 | 38.95 | 11605400.0 |
| 2001-12-03 10:30:00 | QQQ | ETF | 38.96 | 39.23 | 38.9 | 39.19 | 4457400.0 |
| 2001-12-03 11:00:00 | QQQ | ETF | 39.17 | 39.2 | 38.87 | 39.12 | 3431400.0 |
| 2001-12-03 11:30:00 | QQQ | ETF | 39.14 | 39.32 | 39.08 | 39.24 | 3633200.0 |
| 2001-12-03 12:00:00 | QQQ | ETF | 39.24 | 39.25 | 39.05 | 39.13 | 1484900.0 |
| 2001-12-03 12:30:00 | QQQ | ETF | 39.12 | 39.41 | 39.09 | 39.39 | 2743100.0 |
| 2001-12-03 13:00:00 | QQQ | ETF | 39.4 | 39.5 | 39.26 | 39.47 | 3069400.0 |
| 2001-12-03 13:30:00 | QQQ | ETF | 39.48 | 39.51 | 39.21 | 39.22 | 2909100.0 |
| 2001-12-03 14:00:00 | QQQ | ETF | 39.23 | 39.29 | 39.13 | 39.2 | 2438200.0 |
| 2001-12-03 14:30:00 | QQQ | ETF | 39.19 | 39.24 | 39.05 | 39.13 | 2947500.0 |
| 2001-12-03 15:00:00 | QQQ | ETF | 39.14 | 39.17 | 38.95 | 39.14 | 3314800.0 |
| 2001-12-03 15:30:00 | QQQ | ETF | 39.13 | 39.25 | 39.01 | 39.02 | 5187900.0 |
| 2001-12-03 16:00:00 | QQQ | ETF | 39.03 | 39.1 | 38.91 | 39.0 | 1966000.0 |
| 2001-12-03 16:30:00 | QQQ | ETF | 39.0 | 39.0 | 38.93 | 38.95 | 71900.0 |
| 2001-12-03 17:00:00 | QQQ | ETF | 38.97 | 39.02 | 38.95 | 39.02 | 29900.0 |
| 2001-12-03 17:30:00 | QQQ | ETF | 39.02 | 39.03 | 38.98 | 38.98 | 16300.0 |
| 2001-12-03 18:00:00 | QQQ | ETF | 39.0 | 39.0 | 38.89 | 38.9 | 57900.0 |
| 2001-12-03 09:30:00 | IWM | ETF | 45.45 | 45.65 | 45.45 | 45.65 | 14200.0 |
| 2001-12-03 10:00:00 | IWM | ETF | 45.4 | 45.575 | 45.35 | 45.35 | 14400.0 |
| 2001-12-03 10:30:00 | IWM | ETF | 45.45 | 45.52 | 45.45 | 45.5 | 2400.0 |
| 2001-12-03 11:00:00 | IWM | ETF | 45.375 | 45.425 | 45.345 | 45.35 | 45400.0 |
| 2001-12-03 11:30:00 | IWM | ETF | 45.425 | 45.6 | 45.39 | 45.6 | 11800.0 |
| 2001-12-03 12:00:00 | IWM | ETF | 45.4 | 45.575 | 45.4 | 45.55 | 12000.0 |
| 2001-12-03 12:30:00 | IWM | ETF | 45.525 | 45.575 | 45.385 | 45.575 | 8400.0 |
| 2001-12-03 13:00:00 | IWM | ETF | 45.5 | 45.705 | 45.455 | 45.705 | 12600.0 |
| 2001-12-03 13:30:00 | IWM | ETF | 45.705 | 45.705 | 45.5 | 45.675 | 7800.0 |
| 2001-12-03 14:00:00 | IWM | ETF | 45.65 | 45.65 | 45.505 | 45.52 | 5600.0 |
| 2001-12-03 14:30:00 | IWM | ETF | 45.6 | 45.6 | 45.5 | 45.6 | 3000.0 |
| 2001-12-03 15:00:00 | IWM | ETF | 45.525 | 45.55 | 45.45 | 45.45 | 5200.0 |
| 2001-12-03 15:30:00 | IWM | ETF | 45.575 | 45.635 | 45.45 | 45.525 | 32200.0 |
| 2001-12-03 16:00:00 | IWM | ETF | 45.525 | 45.525 | 45.275 | 45.5 | 34800.0 |
| 2001-12-03 09:30:00 | DIA | ETF | 98.1 | 98.1 | 97.55 | 97.63 | 294400.0 |
| 2001-12-03 10:00:00 | DIA | ETF | 97.59 | 97.79 | 97.21 | 97.29 | 380800.0 |
| 2001-12-03 10:30:00 | DIA | ETF | 97.21 | 97.65 | 97.21 | 97.5 | 184100.0 |
> showing 50 of 416 rows — these rows as CSV