PREVIEW / etf_30min / 2001-03-26
file: by_date/etf_30min/2001/2001-03-26.parquet size: 14 KB rows: 352
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-03-26 09:30:00 | SPY | ETF | 115.7 | 115.8 | 115.2 | 115.4 | 1559000.0 |
| 2001-03-26 10:00:00 | SPY | ETF | 115.27 | 115.82 | 115.02 | 115.6 | 1114100.0 |
| 2001-03-26 10:30:00 | SPY | ETF | 115.62 | 116.01 | 115.46 | 115.56 | 558600.0 |
| 2001-03-26 11:00:00 | SPY | ETF | 115.67 | 115.94 | 115.33 | 115.81 | 399600.0 |
| 2001-03-26 11:30:00 | SPY | ETF | 115.71 | 115.99 | 115.49 | 115.99 | 278400.0 |
| 2001-03-26 12:00:00 | SPY | ETF | 115.95 | 116.27 | 115.9 | 116.0 | 365700.0 |
| 2001-03-26 12:30:00 | SPY | ETF | 116.0 | 116.1 | 115.67 | 115.8 | 347500.0 |
| 2001-03-26 13:00:00 | SPY | ETF | 115.79 | 115.99 | 115.61 | 115.71 | 515100.0 |
| 2001-03-26 13:30:00 | SPY | ETF | 115.74 | 115.74 | 115.14 | 115.43 | 564800.0 |
| 2001-03-26 14:00:00 | SPY | ETF | 115.35 | 115.44 | 114.84 | 115.12 | 661200.0 |
| 2001-03-26 14:30:00 | SPY | ETF | 115.06 | 115.6 | 115.04 | 115.2 | 493400.0 |
| 2001-03-26 15:00:00 | SPY | ETF | 115.19 | 115.29 | 114.77 | 115.0 | 501900.0 |
| 2001-03-26 15:30:00 | SPY | ETF | 114.97 | 115.7 | 114.81 | 115.5 | 1007100.0 |
| 2001-03-26 16:00:00 | SPY | ETF | 115.62 | 116.25 | 115.4 | 115.8 | 542600.0 |
| 2001-03-26 16:30:00 | SPY | ETF | 115.53 | 115.8 | 115.53 | 115.8 | 51000.0 |
| 2001-03-26 17:30:00 | SPY | ETF | 116.0 | 116.0 | 116.0 | 116.0 | 1000.0 |
| 2001-03-26 18:00:00 | SPY | ETF | 116.01 | 116.01 | 116.0 | 116.0 | 1000.0 |
| 2001-03-26 09:30:00 | QQQ | ETF | 43.47 | 43.49 | 42.77 | 42.81 | 7914000.0 |
| 2001-03-26 10:00:00 | QQQ | ETF | 42.84 | 43.2 | 42.6 | 42.99 | 4882700.0 |
| 2001-03-26 10:30:00 | QQQ | ETF | 42.95 | 43.21 | 42.7 | 42.92 | 4478600.0 |
| 2001-03-26 11:00:00 | QQQ | ETF | 42.92 | 43.05 | 42.6 | 42.8 | 3141900.0 |
| 2001-03-26 11:30:00 | QQQ | ETF | 42.77 | 43.02 | 42.67 | 43.0 | 2233800.0 |
| 2001-03-26 12:00:00 | QQQ | ETF | 43.01 | 43.19 | 42.9 | 42.96 | 2193300.0 |
| 2001-03-26 12:30:00 | QQQ | ETF | 42.97 | 42.97 | 42.53 | 42.62 | 2915600.0 |
| 2001-03-26 13:00:00 | QQQ | ETF | 42.62 | 42.8 | 42.54 | 42.6 | 1920700.0 |
| 2001-03-26 13:30:00 | QQQ | ETF | 42.61 | 42.65 | 42.03 | 42.22 | 4707700.0 |
| 2001-03-26 14:00:00 | QQQ | ETF | 42.22 | 42.25 | 41.7 | 41.94 | 4257000.0 |
| 2001-03-26 14:30:00 | QQQ | ETF | 41.91 | 42.26 | 41.8 | 41.84 | 3135000.0 |
| 2001-03-26 15:00:00 | QQQ | ETF | 41.86 | 42.0 | 41.55 | 41.75 | 3834300.0 |
| 2001-03-26 15:30:00 | QQQ | ETF | 41.7 | 41.94 | 41.58 | 41.93 | 4039500.0 |
| 2001-03-26 16:00:00 | QQQ | ETF | 41.9 | 42.22 | 41.75 | 41.84 | 1418100.0 |
| 2001-03-26 16:30:00 | QQQ | ETF | 41.82 | 43.4 | 41.81 | 41.97 | 62400.0 |
| 2001-03-26 17:00:00 | QQQ | ETF | 41.85 | 42.49 | 41.85 | 41.92 | 771100.0 |
| 2001-03-26 17:30:00 | QQQ | ETF | 41.9 | 41.96 | 41.9 | 41.96 | 8200.0 |
| 2001-03-26 18:00:00 | QQQ | ETF | 41.9 | 41.98 | 41.9 | 41.9 | 7600.0 |
| 2001-03-26 09:30:00 | IWM | ETF | 44.5 | 44.7 | 44.3 | 44.7 | 86400.0 |
| 2001-03-26 10:00:00 | IWM | ETF | 44.7 | 44.825 | 44.5 | 44.825 | 10600.0 |
| 2001-03-26 10:30:00 | IWM | ETF | 44.795 | 44.8 | 44.795 | 44.8 | 5400.0 |
| 2001-03-26 11:00:00 | IWM | ETF | 44.73 | 44.75 | 44.625 | 44.72 | 2600.0 |
| 2001-03-26 11:30:00 | IWM | ETF | 44.85 | 44.85 | 44.81 | 44.825 | 1200.0 |
| 2001-03-26 12:00:00 | IWM | ETF | 44.875 | 44.975 | 44.775 | 44.95 | 6200.0 |
| 2001-03-26 12:30:00 | IWM | ETF | 44.925 | 44.925 | 44.875 | 44.875 | 13600.0 |
| 2001-03-26 13:00:00 | IWM | ETF | 44.875 | 44.875 | 44.7 | 44.7 | 5000.0 |
| 2001-03-26 13:30:00 | IWM | ETF | 44.575 | 44.675 | 44.5 | 44.675 | 300600.0 |
| 2001-03-26 14:00:00 | IWM | ETF | 44.665 | 44.695 | 44.325 | 44.325 | 25600.0 |
| 2001-03-26 14:30:00 | IWM | ETF | 44.405 | 44.605 | 44.405 | 44.575 | 1000.0 |
| 2001-03-26 15:00:00 | IWM | ETF | 44.4 | 44.5 | 44.4 | 44.425 | 251800.0 |
| 2001-03-26 15:30:00 | IWM | ETF | 44.52 | 44.65 | 44.52 | 44.65 | 63600.0 |
| 2001-03-26 16:00:00 | IWM | ETF | 44.75 | 44.75 | 44.725 | 44.725 | 26400.0 |
| 2001-03-26 09:30:00 | DIA | ETF | 96.0 | 96.55 | 95.9 | 95.9 | 1022400.0 |
> showing 50 of 352 rows — these rows as CSV