PREVIEW / etf_30min / 2001-02-21
file: by_date/etf_30min/2001/2001-02-21.parquet size: 14 KB rows: 339
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-02-21 09:30:00 | SPY | ETF | 127.9 | 128.56 | 127.62 | 128.28 | 1803100.0 |
| 2001-02-21 10:00:00 | SPY | ETF | 128.4 | 128.4 | 127.3 | 127.75 | 883600.0 |
| 2001-02-21 10:30:00 | SPY | ETF | 127.86 | 128.2 | 127.46 | 127.79 | 1074900.0 |
| 2001-02-21 11:00:00 | SPY | ETF | 127.67 | 127.8 | 127.31 | 127.73 | 474200.0 |
| 2001-02-21 11:30:00 | SPY | ETF | 127.76 | 128.42 | 127.46 | 128.17 | 429400.0 |
| 2001-02-21 12:00:00 | SPY | ETF | 128.2 | 128.84 | 128.17 | 128.47 | 1110400.0 |
| 2001-02-21 12:30:00 | SPY | ETF | 128.6 | 128.69 | 128.34 | 128.5 | 254700.0 |
| 2001-02-21 13:00:00 | SPY | ETF | 128.42 | 128.53 | 127.72 | 127.8 | 398400.0 |
| 2001-02-21 13:30:00 | SPY | ETF | 127.85 | 128.04 | 127.36 | 127.39 | 301800.0 |
| 2001-02-21 14:00:00 | SPY | ETF | 127.45 | 127.63 | 127.0 | 127.24 | 516200.0 |
| 2001-02-21 14:30:00 | SPY | ETF | 127.21 | 127.45 | 126.9 | 127.19 | 214800.0 |
| 2001-02-21 15:00:00 | SPY | ETF | 127.17 | 127.31 | 126.25 | 126.39 | 1070800.0 |
| 2001-02-21 15:30:00 | SPY | ETF | 126.35 | 126.74 | 125.52 | 125.6 | 1161900.0 |
| 2001-02-21 16:00:00 | SPY | ETF | 125.57 | 127.48 | 125.5 | 127.48 | 692700.0 |
| 2001-02-21 18:00:00 | SPY | ETF | 126.0 | 126.0 | 126.0 | 126.0 | 100.0 |
| 2001-02-21 09:30:00 | QQQ | ETF | 51.55 | 53.46 | 51.5 | 52.75 | 14362600.0 |
| 2001-02-21 10:00:00 | QQQ | ETF | 52.8 | 52.89 | 51.74 | 52.47 | 5561800.0 |
| 2001-02-21 10:30:00 | QQQ | ETF | 52.48 | 53.2 | 52.18 | 52.45 | 5012600.0 |
| 2001-02-21 11:00:00 | QQQ | ETF | 52.45 | 52.73 | 52.0 | 52.65 | 2970700.0 |
| 2001-02-21 11:30:00 | QQQ | ETF | 52.65 | 53.39 | 52.4 | 53.16 | 3262000.0 |
| 2001-02-21 12:00:00 | QQQ | ETF | 53.2 | 54.07 | 53.16 | 53.7 | 5020600.0 |
| 2001-02-21 12:30:00 | QQQ | ETF | 53.7 | 53.99 | 53.49 | 53.6 | 3381500.0 |
| 2001-02-21 13:00:00 | QQQ | ETF | 53.6 | 53.63 | 52.81 | 52.85 | 3232500.0 |
| 2001-02-21 13:30:00 | QQQ | ETF | 52.85 | 53.14 | 52.56 | 52.64 | 2632800.0 |
| 2001-02-21 14:00:00 | QQQ | ETF | 52.63 | 52.68 | 52.05 | 52.39 | 4450300.0 |
| 2001-02-21 14:30:00 | QQQ | ETF | 52.4 | 52.88 | 51.93 | 52.14 | 3622800.0 |
| 2001-02-21 15:00:00 | QQQ | ETF | 52.1 | 52.35 | 51.14 | 51.47 | 6282400.0 |
| 2001-02-21 15:30:00 | QQQ | ETF | 51.44 | 51.9 | 50.92 | 51.4 | 8251800.0 |
| 2001-02-21 16:00:00 | QQQ | ETF | 51.4 | 51.59 | 51.2 | 51.5 | 1392000.0 |
| 2001-02-21 16:30:00 | QQQ | ETF | 51.5 | 51.9 | 51.26 | 51.35 | 104300.0 |
| 2001-02-21 17:00:00 | QQQ | ETF | 51.31 | 51.5 | 50.06 | 50.5 | 254600.0 |
| 2001-02-21 17:30:00 | QQQ | ETF | 50.5 | 50.85 | 50.4 | 50.6 | 87600.0 |
| 2001-02-21 18:00:00 | QQQ | ETF | 50.59 | 51.5 | 50.54 | 50.65 | 45800.0 |
| 2001-02-21 09:30:00 | IWM | ETF | 48.6 | 49.075 | 48.45 | 48.7 | 63800.0 |
| 2001-02-21 10:00:00 | IWM | ETF | 48.6 | 48.725 | 48.5 | 48.725 | 152800.0 |
| 2001-02-21 10:30:00 | IWM | ETF | 48.7 | 48.795 | 48.63 | 48.63 | 3600.0 |
| 2001-02-21 11:00:00 | IWM | ETF | 48.5 | 48.5 | 48.43 | 48.45 | 1600.0 |
| 2001-02-21 11:30:00 | IWM | ETF | 48.595 | 48.64 | 48.55 | 48.64 | 10000.0 |
| 2001-02-21 12:00:00 | IWM | ETF | 48.7 | 48.875 | 48.7 | 48.8 | 23200.0 |
| 2001-02-21 12:30:00 | IWM | ETF | 48.87 | 48.87 | 48.725 | 48.775 | 8600.0 |
| 2001-02-21 13:00:00 | IWM | ETF | 48.875 | 48.875 | 48.525 | 48.525 | 9200.0 |
| 2001-02-21 13:30:00 | IWM | ETF | 48.625 | 48.75 | 48.625 | 48.655 | 11400.0 |
| 2001-02-21 14:00:00 | IWM | ETF | 48.69 | 48.69 | 48.575 | 48.575 | 2400.0 |
| 2001-02-21 14:30:00 | IWM | ETF | 48.505 | 48.74 | 48.45 | 48.65 | 50200.0 |
| 2001-02-21 15:00:00 | IWM | ETF | 48.5 | 48.5 | 48.225 | 48.34 | 13600.0 |
| 2001-02-21 15:30:00 | IWM | ETF | 48.155 | 48.2 | 48.025 | 48.025 | 32400.0 |
| 2001-02-21 16:00:00 | IWM | ETF | 48.175 | 48.175 | 48.175 | 48.175 | 2400.0 |
| 2001-02-21 09:30:00 | DIA | ETF | 107.15 | 107.4 | 106.85 | 107.1 | 200100.0 |
| 2001-02-21 10:00:00 | DIA | ETF | 107.2 | 107.2 | 106.36 | 106.7 | 225000.0 |
| 2001-02-21 10:30:00 | DIA | ETF | 106.65 | 106.76 | 106.46 | 106.56 | 93100.0 |
> showing 50 of 339 rows — these rows as CSV