PREVIEW / etf_30min / 2001-09-21
file: by_date/etf_30min/2001/2001-09-21.parquet size: 16 KB rows: 429
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-09-21 09:30:00 | SPY | ETF | 94.05 | 95.6 | 93.8 | 94.9 | 9785300.0 |
| 2001-09-21 10:00:00 | SPY | ETF | 94.85 | 96.7 | 94.6 | 96.55 | 5728800.0 |
| 2001-09-21 10:30:00 | SPY | ETF | 96.4 | 98.99 | 96.25 | 96.85 | 8439300.0 |
| 2001-09-21 11:00:00 | SPY | ETF | 96.86 | 97.19 | 96.02 | 96.02 | 2661100.0 |
| 2001-09-21 11:30:00 | SPY | ETF | 96.01 | 96.7 | 95.86 | 96.0 | 2531700.0 |
| 2001-09-21 12:00:00 | SPY | ETF | 96.0 | 96.99 | 95.63 | 96.97 | 2097500.0 |
| 2001-09-21 12:30:00 | SPY | ETF | 96.98 | 97.3 | 96.45 | 96.67 | 2311000.0 |
| 2001-09-21 13:00:00 | SPY | ETF | 96.67 | 97.49 | 96.37 | 96.65 | 1311400.0 |
| 2001-09-21 13:30:00 | SPY | ETF | 96.69 | 97.09 | 96.38 | 96.6 | 1513200.0 |
| 2001-09-21 14:00:00 | SPY | ETF | 96.6 | 97.05 | 96.25 | 96.8 | 1578100.0 |
| 2001-09-21 14:30:00 | SPY | ETF | 96.73 | 96.88 | 96.31 | 96.64 | 1558500.0 |
| 2001-09-21 15:00:00 | SPY | ETF | 96.6 | 96.7 | 95.9 | 96.4 | 2249300.0 |
| 2001-09-21 15:30:00 | SPY | ETF | 96.41 | 97.1 | 96.34 | 96.85 | 2969300.0 |
| 2001-09-21 16:00:00 | SPY | ETF | 96.81 | 97.45 | 96.72 | 97.28 | 1618300.0 |
| 2001-09-21 16:30:00 | SPY | ETF | 97.28 | 97.3 | 97.15 | 97.15 | 2800.0 |
| 2001-09-21 17:00:00 | SPY | ETF | 97.0 | 97.0 | 97.0 | 97.0 | 100.0 |
| 2001-09-21 17:30:00 | SPY | ETF | 97.35 | 97.35 | 97.0 | 97.0 | 1000.0 |
| 2001-09-21 18:00:00 | SPY | ETF | 97.15 | 97.15 | 97.15 | 97.15 | 1500.0 |
| 2001-09-21 09:30:00 | QQQ | ETF | 27.41 | 28.0 | 27.2 | 27.7 | 19390100.0 |
| 2001-09-21 10:00:00 | QQQ | ETF | 27.7 | 28.25 | 27.41 | 28.19 | 11984900.0 |
| 2001-09-21 10:30:00 | QQQ | ETF | 28.18 | 28.97 | 28.08 | 28.25 | 18661300.0 |
| 2001-09-21 11:00:00 | QQQ | ETF | 28.25 | 28.45 | 27.95 | 28.0 | 7279600.0 |
| 2001-09-21 11:30:00 | QQQ | ETF | 28.0 | 28.25 | 27.86 | 28.02 | 4398100.0 |
| 2001-09-21 12:00:00 | QQQ | ETF | 28.03 | 28.28 | 27.8 | 28.25 | 4202600.0 |
| 2001-09-21 12:30:00 | QQQ | ETF | 28.26 | 28.39 | 28.05 | 28.12 | 4209100.0 |
| 2001-09-21 13:00:00 | QQQ | ETF | 28.13 | 28.47 | 28.0 | 28.09 | 4896700.0 |
| 2001-09-21 13:30:00 | QQQ | ETF | 28.09 | 28.33 | 27.95 | 28.01 | 3765700.0 |
| 2001-09-21 14:00:00 | QQQ | ETF | 27.99 | 28.19 | 27.83 | 28.05 | 4151700.0 |
| 2001-09-21 14:30:00 | QQQ | ETF | 28.05 | 28.15 | 27.88 | 28.02 | 3740700.0 |
| 2001-09-21 15:00:00 | QQQ | ETF | 28.03 | 28.13 | 27.65 | 28.07 | 7645200.0 |
| 2001-09-21 15:30:00 | QQQ | ETF | 28.06 | 28.33 | 28.0 | 28.17 | 10240800.0 |
| 2001-09-21 16:00:00 | QQQ | ETF | 28.13 | 28.2 | 28.06 | 28.14 | 1287800.0 |
| 2001-09-21 16:30:00 | QQQ | ETF | 28.17 | 28.3 | 28.05 | 28.21 | 154000.0 |
| 2001-09-21 17:00:00 | QQQ | ETF | 28.12 | 28.19 | 28.0 | 28.14 | 45700.0 |
| 2001-09-21 17:30:00 | QQQ | ETF | 28.18 | 28.18 | 28.1 | 28.15 | 6900.0 |
| 2001-09-21 18:00:00 | QQQ | ETF | 28.15 | 28.25 | 28.14 | 28.21 | 14100.0 |
| 2001-09-21 09:30:00 | IWM | ETF | 37.25 | 37.5 | 36.75 | 37.375 | 203600.0 |
| 2001-09-21 10:00:00 | IWM | ETF | 37.375 | 37.495 | 37.115 | 37.41 | 311200.0 |
| 2001-09-21 10:30:00 | IWM | ETF | 37.55 | 38.025 | 37.475 | 37.475 | 51800.0 |
| 2001-09-21 11:00:00 | IWM | ETF | 37.675 | 37.725 | 37.2 | 37.2 | 8800.0 |
| 2001-09-21 11:30:00 | IWM | ETF | 37.18 | 37.5 | 37.18 | 37.445 | 4800.0 |
| 2001-09-21 12:00:00 | IWM | ETF | 37.35 | 37.445 | 37.22 | 37.37 | 8600.0 |
| 2001-09-21 12:30:00 | IWM | ETF | 37.355 | 37.5 | 37.175 | 37.5 | 9600.0 |
| 2001-09-21 13:00:00 | IWM | ETF | 37.365 | 37.5 | 37.225 | 37.36 | 22000.0 |
| 2001-09-21 13:30:00 | IWM | ETF | 37.27 | 37.55 | 37.27 | 37.55 | 15200.0 |
| 2001-09-21 14:00:00 | IWM | ETF | 37.37 | 37.77 | 37.33 | 37.77 | 43200.0 |
| 2001-09-21 14:30:00 | IWM | ETF | 37.53 | 37.67 | 37.5 | 37.65 | 19000.0 |
| 2001-09-21 15:00:00 | IWM | ETF | 37.65 | 37.675 | 37.5 | 37.575 | 12800.0 |
| 2001-09-21 15:30:00 | IWM | ETF | 37.455 | 37.87 | 37.455 | 37.825 | 293200.0 |
| 2001-09-21 16:00:00 | IWM | ETF | 37.83 | 37.83 | 37.83 | 37.83 | 200.0 |
> showing 50 of 429 rows — these rows as CSV