PREVIEW / etf_30min / 2001-03-23
file: by_date/etf_30min/2001/2001-03-23.parquet size: 15 KB rows: 362
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-23 09:30:00 | SPY | ETF | 113.25 | 113.25 | 111.83 | 112.19 | 2493200.0 |
| 2001-03-23 10:00:00 | SPY | ETF | 112.14 | 113.12 | 111.92 | 112.54 | 1150100.0 |
| 2001-03-23 10:30:00 | SPY | ETF | 112.42 | 113.35 | 112.4 | 113.15 | 1302500.0 |
| 2001-03-23 11:00:00 | SPY | ETF | 113.15 | 113.95 | 113.15 | 113.5 | 1037700.0 |
| 2001-03-23 11:30:00 | SPY | ETF | 113.55 | 113.89 | 113.05 | 113.25 | 500000.0 |
| 2001-03-23 12:00:00 | SPY | ETF | 113.3 | 113.45 | 112.85 | 113.06 | 508300.0 |
| 2001-03-23 12:30:00 | SPY | ETF | 113.16 | 113.16 | 112.4 | 112.68 | 465500.0 |
| 2001-03-23 13:00:00 | SPY | ETF | 112.8 | 113.7 | 112.78 | 113.47 | 347500.0 |
| 2001-03-23 13:30:00 | SPY | ETF | 113.36 | 113.78 | 113.02 | 113.4 | 723800.0 |
| 2001-03-23 14:00:00 | SPY | ETF | 113.26 | 113.82 | 113.2 | 113.8 | 284200.0 |
| 2001-03-23 14:30:00 | SPY | ETF | 113.85 | 114.29 | 113.8 | 114.01 | 1142900.0 |
| 2001-03-23 15:00:00 | SPY | ETF | 113.99 | 114.48 | 113.57 | 114.35 | 734900.0 |
| 2001-03-23 15:30:00 | SPY | ETF | 114.46 | 114.46 | 113.85 | 114.25 | 947800.0 |
| 2001-03-23 16:00:00 | SPY | ETF | 114.15 | 114.66 | 114.15 | 114.6 | 941200.0 |
| 2001-03-23 09:30:00 | QQQ | ETF | 43.55 | 43.83 | 42.51 | 42.9 | 21000700.0 |
| 2001-03-23 10:00:00 | QQQ | ETF | 42.9 | 43.5 | 42.45 | 42.83 | 11911200.0 |
| 2001-03-23 10:30:00 | QQQ | ETF | 42.81 | 43.11 | 42.65 | 43.1 | 5923900.0 |
| 2001-03-23 11:00:00 | QQQ | ETF | 43.1 | 43.33 | 42.7 | 42.9 | 5559500.0 |
| 2001-03-23 11:30:00 | QQQ | ETF | 42.93 | 43.03 | 42.5 | 42.55 | 3699600.0 |
| 2001-03-23 12:00:00 | QQQ | ETF | 42.5 | 42.55 | 41.98 | 42.04 | 4127200.0 |
| 2001-03-23 12:30:00 | QQQ | ETF | 42.05 | 42.1 | 41.5 | 41.82 | 10393100.0 |
| 2001-03-23 13:00:00 | QQQ | ETF | 41.76 | 42.3 | 41.73 | 42.25 | 3487900.0 |
| 2001-03-23 13:30:00 | QQQ | ETF | 42.17 | 42.47 | 41.77 | 42.0 | 2542000.0 |
| 2001-03-23 14:00:00 | QQQ | ETF | 41.95 | 42.59 | 41.87 | 42.57 | 2797500.0 |
| 2001-03-23 14:30:00 | QQQ | ETF | 42.59 | 43.0 | 42.5 | 42.73 | 6779800.0 |
| 2001-03-23 15:00:00 | QQQ | ETF | 42.7 | 43.02 | 42.3 | 42.86 | 4593800.0 |
| 2001-03-23 15:30:00 | QQQ | ETF | 42.83 | 42.93 | 42.42 | 42.5 | 5229000.0 |
| 2001-03-23 16:00:00 | QQQ | ETF | 42.5 | 42.9 | 42.0 | 42.85 | 1853900.0 |
| 2001-03-23 16:30:00 | QQQ | ETF | 42.85 | 42.9 | 42.55 | 42.85 | 155500.0 |
| 2001-03-23 17:00:00 | QQQ | ETF | 42.85 | 42.9 | 42.81 | 42.85 | 18700.0 |
| 2001-03-23 17:30:00 | QQQ | ETF | 42.8 | 42.85 | 42.8 | 42.85 | 2200.0 |
| 2001-03-23 18:00:00 | QQQ | ETF | 42.85 | 42.9 | 42.8 | 42.8 | 13100.0 |
| 2001-03-23 09:30:00 | IWM | ETF | 43.875 | 43.875 | 43.5 | 43.65 | 41200.0 |
| 2001-03-23 10:00:00 | IWM | ETF | 43.9 | 43.9 | 43.575 | 43.605 | 9800.0 |
| 2001-03-23 10:30:00 | IWM | ETF | 43.85 | 44.045 | 43.725 | 43.875 | 12200.0 |
| 2001-03-23 11:00:00 | IWM | ETF | 44.05 | 44.125 | 43.85 | 43.85 | 39000.0 |
| 2001-03-23 11:30:00 | IWM | ETF | 43.85 | 43.95 | 43.85 | 43.95 | 22800.0 |
| 2001-03-23 12:00:00 | IWM | ETF | 43.675 | 43.775 | 43.55 | 43.55 | 20800.0 |
| 2001-03-23 12:30:00 | IWM | ETF | 43.725 | 43.725 | 43.525 | 43.7 | 49600.0 |
| 2001-03-23 13:00:00 | IWM | ETF | 43.675 | 43.925 | 43.675 | 43.725 | 7600.0 |
| 2001-03-23 13:30:00 | IWM | ETF | 44.0 | 44.025 | 43.9 | 44.025 | 29200.0 |
| 2001-03-23 14:00:00 | IWM | ETF | 44.02 | 44.02 | 44.02 | 44.02 | 200.0 |
| 2001-03-23 14:30:00 | IWM | ETF | 44.05 | 44.25 | 44.05 | 44.145 | 26200.0 |
| 2001-03-23 15:00:00 | IWM | ETF | 44.25 | 44.25 | 44.0 | 44.0 | 29400.0 |
| 2001-03-23 15:30:00 | IWM | ETF | 44.25 | 44.25 | 43.875 | 44.0 | 5000.0 |
| 2001-03-23 16:00:00 | IWM | ETF | 44.17 | 44.17 | 44.125 | 44.125 | 2200.0 |
| 2001-03-23 09:30:00 | DIA | ETF | 94.49 | 95.1 | 93.45 | 93.82 | 1213800.0 |
| 2001-03-23 10:00:00 | DIA | ETF | 93.6 | 94.6 | 93.3 | 93.75 | 660300.0 |
| 2001-03-23 10:30:00 | DIA | ETF | 93.75 | 94.61 | 93.7 | 94.4 | 249800.0 |
| 2001-03-23 11:00:00 | DIA | ETF | 94.4 | 95.0 | 94.4 | 94.6 | 321700.0 |
> showing 50 of 362 rows — these rows as CSV