PREVIEW / etf_30min / 2004-05-20
file: by_date/etf_30min/2004/2004-05-20.parquet size: 33 KB rows: 1,106
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 |
|---|---|---|---|---|---|---|---|
| 2004-05-20 08:00:00 | SPY | ETF | 109.33 | 109.34 | 109.2 | 109.25 | 47300.0 |
| 2004-05-20 08:30:00 | SPY | ETF | 109.22 | 109.54 | 109.2 | 109.49 | 122300.0 |
| 2004-05-20 09:00:00 | SPY | ETF | 109.49 | 109.53 | 109.45 | 109.47 | 45200.0 |
| 2004-05-20 09:30:00 | SPY | ETF | 109.45 | 109.8 | 109.3 | 109.67 | 5904800.0 |
| 2004-05-20 10:00:00 | SPY | ETF | 109.67 | 109.719 | 109.43 | 109.61 | 3544100.0 |
| 2004-05-20 10:30:00 | SPY | ETF | 109.58 | 109.87 | 109.5 | 109.67 | 2017700.0 |
| 2004-05-20 11:00:00 | SPY | ETF | 109.7 | 109.86 | 109.52 | 109.6 | 1621900.0 |
| 2004-05-20 11:30:00 | SPY | ETF | 109.6 | 109.71 | 109.57 | 109.6 | 1248300.0 |
| 2004-05-20 12:00:00 | SPY | ETF | 109.59 | 109.6 | 109.04 | 109.04 | 5506200.0 |
| 2004-05-20 12:30:00 | SPY | ETF | 109.06 | 109.54 | 109.04 | 109.43 | 1769000.0 |
| 2004-05-20 13:00:00 | SPY | ETF | 109.44 | 109.53 | 109.3 | 109.51 | 1536200.0 |
| 2004-05-20 13:30:00 | SPY | ETF | 109.51 | 109.68 | 109.39 | 109.61 | 1243600.0 |
| 2004-05-20 14:00:00 | SPY | ETF | 109.6 | 109.79 | 109.52 | 109.63 | 2859800.0 |
| 2004-05-20 14:30:00 | SPY | ETF | 109.6301 | 109.69 | 109.36 | 109.52 | 1469800.0 |
| 2004-05-20 15:00:00 | SPY | ETF | 109.55 | 109.76 | 109.36 | 109.7 | 3077100.0 |
| 2004-05-20 15:30:00 | SPY | ETF | 109.73 | 109.81 | 109.46 | 109.52 | 2613200.0 |
| 2004-05-20 16:00:00 | SPY | ETF | 109.51 | 109.68 | 109.45 | 109.62 | 1018900.0 |
| 2004-05-20 16:30:00 | SPY | ETF | 109.6 | 109.63 | 109.48 | 109.5 | 261600.0 |
| 2004-05-20 17:00:00 | SPY | ETF | 109.54 | 109.54 | 109.48 | 109.49 | 1600.0 |
| 2004-05-20 17:30:00 | SPY | ETF | 109.63 | 109.63 | 109.57 | 109.57 | 1200.0 |
| 2004-05-20 18:00:00 | SPY | ETF | 109.57 | 109.62 | 109.54 | 109.6 | 40400.0 |
| 2004-05-20 18:30:00 | SPY | ETF | 109.6 | 109.62 | 109.56 | 109.56 | 2400.0 |
| 2004-05-20 19:00:00 | SPY | ETF | 109.59 | 109.61 | 109.59 | 109.61 | 800.0 |
| 2004-05-20 08:00:00 | QQQ | ETF | 34.7 | 34.7 | 34.65 | 34.67 | 60400.0 |
| 2004-05-20 08:30:00 | QQQ | ETF | 34.67 | 34.82 | 34.67 | 34.8 | 157900.0 |
| 2004-05-20 09:00:00 | QQQ | ETF | 34.79 | 34.83 | 34.78 | 34.78 | 79900.0 |
| 2004-05-20 09:30:00 | QQQ | ETF | 34.78 | 35.02 | 34.73 | 34.94 | 16523700.0 |
| 2004-05-20 10:00:00 | QQQ | ETF | 34.934 | 34.97 | 34.808 | 34.87 | 6914200.0 |
| 2004-05-20 10:30:00 | QQQ | ETF | 34.87 | 35.0 | 34.8 | 34.94 | 5551900.0 |
| 2004-05-20 11:00:00 | QQQ | ETF | 34.94 | 34.98 | 34.783 | 34.84 | 7249100.0 |
| 2004-05-20 11:30:00 | QQQ | ETF | 34.85 | 34.9 | 34.8 | 34.84 | 3481900.0 |
| 2004-05-20 12:00:00 | QQQ | ETF | 34.832 | 34.85 | 34.58 | 34.6 | 10944500.0 |
| 2004-05-20 12:30:00 | QQQ | ETF | 34.61 | 34.813 | 34.56 | 34.8 | 11427500.0 |
| 2004-05-20 13:00:00 | QQQ | ETF | 34.79 | 34.85 | 34.71 | 34.84 | 4176600.0 |
| 2004-05-20 13:30:00 | QQQ | ETF | 34.82 | 34.9 | 34.799 | 34.85 | 4324200.0 |
| 2004-05-20 14:00:00 | QQQ | ETF | 34.846 | 34.91 | 34.76 | 34.79 | 4185100.0 |
| 2004-05-20 14:30:00 | QQQ | ETF | 34.799 | 34.83 | 34.65 | 34.79 | 7181800.0 |
| 2004-05-20 15:00:00 | QQQ | ETF | 34.79 | 34.886 | 34.697 | 34.84 | 4605900.0 |
| 2004-05-20 15:30:00 | QQQ | ETF | 34.848 | 34.88 | 34.75 | 34.77 | 5231900.0 |
| 2004-05-20 16:00:00 | QQQ | ETF | 34.77 | 34.861 | 34.74 | 34.82 | 1612100.0 |
| 2004-05-20 16:30:00 | QQQ | ETF | 34.82 | 34.84 | 34.73 | 34.82 | 352900.0 |
| 2004-05-20 17:00:00 | QQQ | ETF | 34.82 | 34.85 | 34.798 | 34.83 | 87300.0 |
| 2004-05-20 17:30:00 | QQQ | ETF | 34.82 | 34.82 | 34.8 | 34.8 | 14300.0 |
| 2004-05-20 18:00:00 | QQQ | ETF | 34.837 | 34.86 | 34.8 | 34.86 | 80400.0 |
| 2004-05-20 18:30:00 | QQQ | ETF | 34.85 | 34.85 | 34.85 | 34.85 | 1000.0 |
| 2004-05-20 19:00:00 | QQQ | ETF | 34.85 | 34.87 | 34.85 | 34.87 | 600.0 |
| 2004-05-20 19:30:00 | QQQ | ETF | 34.84 | 34.85 | 34.84 | 34.84 | 5500.0 |
| 2004-05-20 08:00:00 | IWM | ETF | 53.7 | 53.7 | 53.7 | 53.7 | 1000.0 |
| 2004-05-20 08:30:00 | IWM | ETF | 53.87 | 54.04 | 53.87 | 54.04 | 12000.0 |
| 2004-05-20 09:00:00 | IWM | ETF | 53.975 | 54.0 | 53.975 | 54.0 | 1200.0 |
> showing 50 of 1,106 rows — these rows as CSV