PREVIEW / etf_30min / 2001-06-04
file: by_date/etf_30min/2001/2001-06-04.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-06-04 09:30:00 | SPY | ETF | 126.8 | 127.22 | 126.5 | 126.59 | 923200.0 |
| 2001-06-04 10:00:00 | SPY | ETF | 126.67 | 126.74 | 126.21 | 126.38 | 760000.0 |
| 2001-06-04 10:30:00 | SPY | ETF | 126.38 | 126.49 | 126.08 | 126.49 | 408900.0 |
| 2001-06-04 11:00:00 | SPY | ETF | 126.4 | 126.6 | 126.2 | 126.54 | 133500.0 |
| 2001-06-04 11:30:00 | SPY | ETF | 126.55 | 126.66 | 126.38 | 126.66 | 326700.0 |
| 2001-06-04 12:00:00 | SPY | ETF | 126.65 | 126.87 | 126.55 | 126.77 | 179000.0 |
| 2001-06-04 12:30:00 | SPY | ETF | 126.8 | 127.0 | 126.7 | 126.84 | 468400.0 |
| 2001-06-04 13:00:00 | SPY | ETF | 126.84 | 127.07 | 126.66 | 126.75 | 388400.0 |
| 2001-06-04 13:30:00 | SPY | ETF | 126.68 | 126.9 | 126.6 | 126.72 | 110700.0 |
| 2001-06-04 14:00:00 | SPY | ETF | 126.72 | 126.78 | 126.5 | 126.76 | 156800.0 |
| 2001-06-04 14:30:00 | SPY | ETF | 126.77 | 127.0 | 126.66 | 126.98 | 161100.0 |
| 2001-06-04 15:00:00 | SPY | ETF | 126.95 | 127.18 | 126.91 | 126.98 | 288100.0 |
| 2001-06-04 15:30:00 | SPY | ETF | 127.02 | 127.27 | 127.0 | 127.18 | 508500.0 |
| 2001-06-04 16:00:00 | SPY | ETF | 127.16 | 128.3 | 127.01 | 127.34 | 530600.0 |
| 2001-06-04 16:30:00 | SPY | ETF | 127.23 | 127.23 | 127.23 | 127.23 | 1000.0 |
| 2001-06-04 09:30:00 | QQQ | ETF | 46.33 | 46.66 | 45.6 | 45.74 | 9108200.0 |
| 2001-06-04 10:00:00 | QQQ | ETF | 45.74 | 45.95 | 45.44 | 45.61 | 5730300.0 |
| 2001-06-04 10:30:00 | QQQ | ETF | 45.61 | 45.7 | 45.29 | 45.55 | 3645700.0 |
| 2001-06-04 11:00:00 | QQQ | ETF | 45.57 | 45.75 | 45.36 | 45.7 | 2112300.0 |
| 2001-06-04 11:30:00 | QQQ | ETF | 45.71 | 45.85 | 45.56 | 45.77 | 2243900.0 |
| 2001-06-04 12:00:00 | QQQ | ETF | 45.77 | 46.0 | 45.71 | 46.0 | 1947900.0 |
| 2001-06-04 12:30:00 | QQQ | ETF | 45.98 | 46.2 | 45.88 | 46.0 | 3349700.0 |
| 2001-06-04 13:00:00 | QQQ | ETF | 45.97 | 46.16 | 45.71 | 45.76 | 2057900.0 |
| 2001-06-04 13:30:00 | QQQ | ETF | 45.75 | 45.96 | 45.6 | 45.7 | 1317800.0 |
| 2001-06-04 14:00:00 | QQQ | ETF | 45.68 | 45.78 | 45.5 | 45.78 | 1964500.0 |
| 2001-06-04 14:30:00 | QQQ | ETF | 45.75 | 45.93 | 45.62 | 45.85 | 1601500.0 |
| 2001-06-04 15:00:00 | QQQ | ETF | 45.85 | 46.06 | 45.75 | 45.81 | 2081300.0 |
| 2001-06-04 15:30:00 | QQQ | ETF | 45.81 | 46.02 | 45.64 | 45.76 | 2701900.0 |
| 2001-06-04 16:00:00 | QQQ | ETF | 45.76 | 45.9 | 45.71 | 45.9 | 595000.0 |
| 2001-06-04 16:30:00 | QQQ | ETF | 45.87 | 45.9 | 45.8 | 45.81 | 14800.0 |
| 2001-06-04 17:00:00 | QQQ | ETF | 45.8 | 46.05 | 45.8 | 46.05 | 103000.0 |
| 2001-06-04 17:30:00 | QQQ | ETF | 46.01 | 46.15 | 46.0 | 46.09 | 55400.0 |
| 2001-06-04 18:00:00 | QQQ | ETF | 46.1 | 46.2 | 46.08 | 46.14 | 17100.0 |
| 2001-06-04 09:30:00 | IWM | ETF | 50.375 | 50.38 | 50.15 | 50.15 | 31000.0 |
| 2001-06-04 10:00:00 | IWM | ETF | 50.2 | 50.295 | 50.2 | 50.285 | 6000.0 |
| 2001-06-04 10:30:00 | IWM | ETF | 50.295 | 50.3 | 50.275 | 50.3 | 11400.0 |
| 2001-06-04 11:00:00 | IWM | ETF | 50.3 | 50.355 | 50.265 | 50.345 | 65800.0 |
| 2001-06-04 11:30:00 | IWM | ETF | 50.355 | 50.495 | 50.355 | 50.495 | 15000.0 |
| 2001-06-04 12:00:00 | IWM | ETF | 50.515 | 50.55 | 50.515 | 50.55 | 11400.0 |
| 2001-06-04 12:30:00 | IWM | ETF | 50.55 | 50.67 | 50.55 | 50.625 | 3800.0 |
| 2001-06-04 13:00:00 | IWM | ETF | 50.72 | 50.725 | 50.6 | 50.605 | 72200.0 |
| 2001-06-04 13:30:00 | IWM | ETF | 50.6 | 50.6 | 50.515 | 50.515 | 16200.0 |
| 2001-06-04 14:00:00 | IWM | ETF | 50.5 | 50.515 | 50.39 | 50.475 | 40200.0 |
| 2001-06-04 14:30:00 | IWM | ETF | 50.4 | 50.525 | 50.4 | 50.495 | 14800.0 |
| 2001-06-04 15:00:00 | IWM | ETF | 50.5 | 50.645 | 50.5 | 50.525 | 32200.0 |
| 2001-06-04 15:30:00 | IWM | ETF | 50.5 | 50.72 | 50.48 | 50.575 | 90200.0 |
| 2001-06-04 16:00:00 | IWM | ETF | 50.725 | 50.79 | 50.725 | 50.79 | 2800.0 |
| 2001-06-04 09:30:00 | DIA | ETF | 110.25 | 110.4 | 109.88 | 109.95 | 176200.0 |
| 2001-06-04 10:00:00 | DIA | ETF | 109.9 | 109.98 | 109.55 | 109.61 | 125300.0 |
| 2001-06-04 10:30:00 | DIA | ETF | 109.63 | 109.89 | 109.5 | 109.8 | 79800.0 |
> showing 50 of 352 rows — these rows as CSV