PREVIEW / etf_30min / 2001-02-14
file: by_date/etf_30min/2001/2001-02-14.parquet size: 14 KB rows: 321
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-14 09:30:00 | SPY | ETF | 132.6 | 132.65 | 131.76 | 131.85 | 1944000.0 |
| 2001-02-14 10:00:00 | SPY | ETF | 131.89 | 131.89 | 131.2 | 131.34 | 719900.0 |
| 2001-02-14 10:30:00 | SPY | ETF | 131.36 | 131.42 | 130.66 | 131.17 | 879200.0 |
| 2001-02-14 11:00:00 | SPY | ETF | 131.1 | 131.48 | 131.02 | 131.09 | 515600.0 |
| 2001-02-14 11:30:00 | SPY | ETF | 131.16 | 131.74 | 131.0 | 131.47 | 226700.0 |
| 2001-02-14 12:00:00 | SPY | ETF | 131.4 | 131.61 | 131.28 | 131.6 | 92500.0 |
| 2001-02-14 12:30:00 | SPY | ETF | 131.55 | 131.69 | 131.12 | 131.28 | 190700.0 |
| 2001-02-14 13:00:00 | SPY | ETF | 131.26 | 131.26 | 130.96 | 131.17 | 103400.0 |
| 2001-02-14 13:30:00 | SPY | ETF | 131.23 | 131.64 | 131.06 | 131.58 | 218900.0 |
| 2001-02-14 14:00:00 | SPY | ETF | 131.6 | 132.3 | 131.52 | 132.21 | 700700.0 |
| 2001-02-14 14:30:00 | SPY | ETF | 132.15 | 132.42 | 131.66 | 131.76 | 549500.0 |
| 2001-02-14 15:00:00 | SPY | ETF | 131.9 | 132.3 | 131.77 | 132.16 | 280400.0 |
| 2001-02-14 15:30:00 | SPY | ETF | 132.01 | 132.16 | 131.62 | 132.15 | 1180100.0 |
| 2001-02-14 16:00:00 | SPY | ETF | 132.24 | 132.3 | 131.72 | 131.72 | 635700.0 |
| 2001-02-14 16:30:00 | SPY | ETF | 132.06 | 132.06 | 132.06 | 132.06 | 3100.0 |
| 2001-02-14 09:30:00 | QQQ | ETF | 55.4 | 55.75 | 54.89 | 55.4 | 9640600.0 |
| 2001-02-14 10:00:00 | QQQ | ETF | 55.4 | 55.69 | 54.37 | 54.4 | 4955300.0 |
| 2001-02-14 10:30:00 | QQQ | ETF | 54.5 | 54.91 | 54.12 | 54.75 | 4920500.0 |
| 2001-02-14 11:00:00 | QQQ | ETF | 54.78 | 55.7 | 54.7 | 55.28 | 5600500.0 |
| 2001-02-14 11:30:00 | QQQ | ETF | 55.24 | 56.2 | 55.05 | 55.88 | 4647000.0 |
| 2001-02-14 12:00:00 | QQQ | ETF | 55.85 | 56.04 | 55.37 | 55.72 | 3221100.0 |
| 2001-02-14 12:30:00 | QQQ | ETF | 55.8 | 55.99 | 55.3 | 55.3 | 2023900.0 |
| 2001-02-14 13:00:00 | QQQ | ETF | 55.3 | 55.4 | 55.0 | 55.25 | 2005700.0 |
| 2001-02-14 13:30:00 | QQQ | ETF | 55.35 | 56.15 | 55.26 | 56.1 | 3144700.0 |
| 2001-02-14 14:00:00 | QQQ | ETF | 56.11 | 57.0 | 56.0 | 56.99 | 5268800.0 |
| 2001-02-14 14:30:00 | QQQ | ETF | 57.0 | 57.09 | 56.42 | 56.74 | 3937500.0 |
| 2001-02-14 15:00:00 | QQQ | ETF | 56.75 | 57.43 | 56.63 | 57.29 | 3876000.0 |
| 2001-02-14 15:30:00 | QQQ | ETF | 57.33 | 57.61 | 56.73 | 57.44 | 5561000.0 |
| 2001-02-14 16:00:00 | QQQ | ETF | 57.5 | 57.75 | 55.57 | 57.6 | 1729300.0 |
| 2001-02-14 16:30:00 | QQQ | ETF | 57.6 | 58.45 | 57.42 | 57.87 | 25000.0 |
| 2001-02-14 17:00:00 | QQQ | ETF | 57.89 | 58.15 | 57.85 | 58.09 | 28900.0 |
| 2001-02-14 17:30:00 | QQQ | ETF | 58.1 | 58.1 | 57.95 | 58.05 | 8600.0 |
| 2001-02-14 18:00:00 | QQQ | ETF | 58.0 | 58.05 | 57.92 | 58.0 | 8000.0 |
| 2001-02-14 09:30:00 | IWM | ETF | 50.2 | 50.2 | 49.8 | 50.0 | 9800.0 |
| 2001-02-14 10:00:00 | IWM | ETF | 49.95 | 49.97 | 49.685 | 49.875 | 16000.0 |
| 2001-02-14 10:30:00 | IWM | ETF | 49.7 | 49.725 | 49.7 | 49.725 | 1800.0 |
| 2001-02-14 11:00:00 | IWM | ETF | 49.725 | 50.025 | 49.725 | 49.75 | 22600.0 |
| 2001-02-14 11:30:00 | IWM | ETF | 49.86 | 50.025 | 49.86 | 50.025 | 800.0 |
| 2001-02-14 12:00:00 | IWM | ETF | 49.875 | 49.95 | 49.65 | 49.725 | 29200.0 |
| 2001-02-14 12:30:00 | IWM | ETF | 49.995 | 49.995 | 49.75 | 49.75 | 8400.0 |
| 2001-02-14 13:00:00 | IWM | ETF | 49.7 | 49.9 | 49.7 | 49.75 | 149200.0 |
| 2001-02-14 13:30:00 | IWM | ETF | 49.875 | 49.95 | 49.875 | 49.875 | 13800.0 |
| 2001-02-14 14:00:00 | IWM | ETF | 50.135 | 50.15 | 50.005 | 50.125 | 28600.0 |
| 2001-02-14 14:30:00 | IWM | ETF | 50.15 | 50.2 | 49.95 | 49.95 | 13000.0 |
| 2001-02-14 15:00:00 | IWM | ETF | 50.1 | 50.25 | 50.1 | 50.25 | 17200.0 |
| 2001-02-14 15:30:00 | IWM | ETF | 50.25 | 50.45 | 50.015 | 50.45 | 24000.0 |
| 2001-02-14 09:30:00 | DIA | ETF | 109.36 | 109.36 | 108.76 | 108.9 | 395200.0 |
| 2001-02-14 10:00:00 | DIA | ETF | 108.93 | 109.0 | 108.57 | 108.71 | 143000.0 |
| 2001-02-14 10:30:00 | DIA | ETF | 108.72 | 108.9 | 108.33 | 108.46 | 310300.0 |
| 2001-02-14 11:00:00 | DIA | ETF | 108.47 | 108.56 | 108.11 | 108.2 | 180500.0 |
> showing 50 of 321 rows — these rows as CSV