PREVIEW / etf_30min / 2001-10-08
file: by_date/etf_30min/2001/2001-10-08.parquet size: 16 KB rows: 388
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-10-08 09:30:00 | SPY | ETF | 106.27 | 106.7 | 105.93 | 106.67 | 2172700.0 |
| 2001-10-08 10:00:00 | SPY | ETF | 106.65 | 106.73 | 105.87 | 106.31 | 1444400.0 |
| 2001-10-08 10:30:00 | SPY | ETF | 106.36 | 107.21 | 106.35 | 106.84 | 1574200.0 |
| 2001-10-08 11:00:00 | SPY | ETF | 106.85 | 107.3 | 106.83 | 106.95 | 899400.0 |
| 2001-10-08 11:30:00 | SPY | ETF | 107.0 | 107.1 | 106.57 | 106.79 | 525000.0 |
| 2001-10-08 12:00:00 | SPY | ETF | 106.9 | 106.9 | 106.46 | 106.67 | 389900.0 |
| 2001-10-08 12:30:00 | SPY | ETF | 106.6 | 106.9 | 106.5 | 106.6 | 284600.0 |
| 2001-10-08 13:00:00 | SPY | ETF | 106.52 | 106.86 | 106.41 | 106.68 | 262200.0 |
| 2001-10-08 13:30:00 | SPY | ETF | 106.71 | 106.88 | 106.53 | 106.63 | 351800.0 |
| 2001-10-08 14:00:00 | SPY | ETF | 106.7 | 106.8 | 106.17 | 106.32 | 939500.0 |
| 2001-10-08 14:30:00 | SPY | ETF | 106.35 | 106.49 | 106.07 | 106.12 | 620000.0 |
| 2001-10-08 15:00:00 | SPY | ETF | 106.05 | 106.23 | 105.93 | 106.08 | 776600.0 |
| 2001-10-08 15:30:00 | SPY | ETF | 106.1 | 106.68 | 106.1 | 106.53 | 1057600.0 |
| 2001-10-08 16:00:00 | SPY | ETF | 106.51 | 106.7 | 106.47 | 106.47 | 1212800.0 |
| 2001-10-08 16:30:00 | SPY | ETF | 106.53 | 106.54 | 106.5 | 106.54 | 10900.0 |
| 2001-10-08 17:00:00 | SPY | ETF | 106.55 | 106.55 | 106.53 | 106.53 | 900.0 |
| 2001-10-08 17:30:00 | SPY | ETF | 106.53 | 106.53 | 106.53 | 106.53 | 500.0 |
| 2001-10-08 18:00:00 | SPY | ETF | 106.45 | 106.45 | 106.45 | 106.45 | 100.0 |
| 2001-10-08 09:30:00 | QQQ | ETF | 31.13 | 31.97 | 30.96 | 31.94 | 13235600.0 |
| 2001-10-08 10:00:00 | QQQ | ETF | 31.93 | 31.96 | 31.4 | 31.76 | 7793900.0 |
| 2001-10-08 10:30:00 | QQQ | ETF | 31.81 | 32.31 | 31.78 | 31.99 | 7898700.0 |
| 2001-10-08 11:00:00 | QQQ | ETF | 31.98 | 32.35 | 31.97 | 32.15 | 5345700.0 |
| 2001-10-08 11:30:00 | QQQ | ETF | 32.11 | 32.28 | 31.87 | 32.01 | 3183200.0 |
| 2001-10-08 12:00:00 | QQQ | ETF | 31.95 | 32.09 | 31.72 | 31.86 | 3666600.0 |
| 2001-10-08 12:30:00 | QQQ | ETF | 31.86 | 32.04 | 31.82 | 31.88 | 2047900.0 |
| 2001-10-08 13:00:00 | QQQ | ETF | 31.88 | 32.16 | 31.78 | 32.12 | 2816200.0 |
| 2001-10-08 13:30:00 | QQQ | ETF | 32.13 | 32.25 | 31.9 | 32.07 | 3555900.0 |
| 2001-10-08 14:00:00 | QQQ | ETF | 32.06 | 32.13 | 31.65 | 31.72 | 3165400.0 |
| 2001-10-08 14:30:00 | QQQ | ETF | 31.73 | 31.85 | 31.5 | 31.5 | 4163400.0 |
| 2001-10-08 15:00:00 | QQQ | ETF | 31.51 | 31.7 | 31.44 | 31.62 | 3619800.0 |
| 2001-10-08 15:30:00 | QQQ | ETF | 31.61 | 31.95 | 31.57 | 31.85 | 3148100.0 |
| 2001-10-08 16:00:00 | QQQ | ETF | 31.87 | 31.98 | 31.81 | 31.9 | 1379300.0 |
| 2001-10-08 16:30:00 | QQQ | ETF | 31.94 | 31.94 | 31.84 | 31.9 | 49100.0 |
| 2001-10-08 17:00:00 | QQQ | ETF | 31.91 | 31.97 | 31.85 | 31.92 | 31400.0 |
| 2001-10-08 17:30:00 | QQQ | ETF | 31.9 | 32.0 | 31.85 | 31.93 | 32300.0 |
| 2001-10-08 18:00:00 | QQQ | ETF | 31.92 | 32.0 | 31.87 | 31.95 | 15600.0 |
| 2001-10-08 09:30:00 | IWM | ETF | 40.75 | 41.105 | 40.75 | 41.105 | 57800.0 |
| 2001-10-08 10:00:00 | IWM | ETF | 41.025 | 41.09 | 41.025 | 41.085 | 17600.0 |
| 2001-10-08 10:30:00 | IWM | ETF | 41.1 | 41.395 | 41.1 | 41.25 | 16400.0 |
| 2001-10-08 11:00:00 | IWM | ETF | 41.24 | 41.32 | 41.24 | 41.32 | 2800.0 |
| 2001-10-08 11:30:00 | IWM | ETF | 41.33 | 41.335 | 41.25 | 41.265 | 3000.0 |
| 2001-10-08 12:00:00 | IWM | ETF | 41.215 | 41.215 | 41.215 | 41.215 | 200.0 |
| 2001-10-08 12:30:00 | IWM | ETF | 41.155 | 41.155 | 41.155 | 41.155 | 1200.0 |
| 2001-10-08 13:00:00 | IWM | ETF | 41.16 | 41.17 | 41.11 | 41.11 | 3200.0 |
| 2001-10-08 13:30:00 | IWM | ETF | 41.105 | 41.2 | 41.105 | 41.2 | 22200.0 |
| 2001-10-08 14:00:00 | IWM | ETF | 41.1 | 41.1 | 41.025 | 41.025 | 2600.0 |
| 2001-10-08 14:30:00 | IWM | ETF | 41.025 | 41.045 | 40.875 | 40.875 | 50200.0 |
| 2001-10-08 15:00:00 | IWM | ETF | 40.8 | 40.925 | 40.8 | 40.91 | 8400.0 |
| 2001-10-08 15:30:00 | IWM | ETF | 40.87 | 41.04 | 40.75 | 40.925 | 140600.0 |
| 2001-10-08 16:00:00 | IWM | ETF | 41.005 | 41.005 | 40.925 | 40.925 | 3600.0 |
> showing 50 of 388 rows — these rows as CSV