PREVIEW / etf_30min / 2004-04-15
file: by_date/etf_30min/2004/2004-04-15.parquet size: 35 KB rows: 1,158
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-04-15 08:00:00 | SPY | ETF | 113.45 | 113.45 | 113.35 | 113.35 | 14700.0 |
| 2004-04-15 08:30:00 | SPY | ETF | 113.36 | 113.62 | 113.25 | 113.61 | 43100.0 |
| 2004-04-15 09:00:00 | SPY | ETF | 113.6 | 113.61 | 113.39 | 113.46 | 82500.0 |
| 2004-04-15 09:30:00 | SPY | ETF | 113.45 | 113.78 | 113.28 | 113.42 | 3387000.0 |
| 2004-04-15 10:00:00 | SPY | ETF | 113.43 | 113.52 | 113.19 | 113.34 | 5141800.0 |
| 2004-04-15 10:30:00 | SPY | ETF | 113.33 | 113.39 | 112.86 | 112.88 | 6278400.0 |
| 2004-04-15 11:00:00 | SPY | ETF | 112.91 | 113.19 | 112.85 | 113.05 | 3377200.0 |
| 2004-04-15 11:30:00 | SPY | ETF | 113.06 | 113.22 | 112.9 | 113.1 | 1584800.0 |
| 2004-04-15 12:00:00 | SPY | ETF | 113.12 | 113.32 | 112.7 | 112.87 | 2343300.0 |
| 2004-04-15 12:30:00 | SPY | ETF | 112.85 | 113.16 | 112.67 | 113.15 | 2557700.0 |
| 2004-04-15 13:00:00 | SPY | ETF | 113.16 | 113.18 | 112.8 | 112.86 | 1564400.0 |
| 2004-04-15 13:30:00 | SPY | ETF | 112.85 | 113.03 | 112.7 | 112.75 | 904000.0 |
| 2004-04-15 14:00:00 | SPY | ETF | 112.74 | 112.75 | 112.36 | 112.63 | 4054700.0 |
| 2004-04-15 14:30:00 | SPY | ETF | 112.64 | 113.05 | 112.59 | 113.0 | 1796000.0 |
| 2004-04-15 15:00:00 | SPY | ETF | 113.0 | 113.18 | 112.88 | 113.08 | 2193700.0 |
| 2004-04-15 15:30:00 | SPY | ETF | 113.07 | 113.39 | 113.04 | 113.17 | 2535200.0 |
| 2004-04-15 16:00:00 | SPY | ETF | 113.2 | 113.21 | 112.8 | 112.85 | 1679200.0 |
| 2004-04-15 16:30:00 | SPY | ETF | 112.85 | 112.96 | 112.65 | 112.76 | 321300.0 |
| 2004-04-15 17:00:00 | SPY | ETF | 112.79 | 112.79 | 112.7 | 112.71 | 22200.0 |
| 2004-04-15 17:30:00 | SPY | ETF | 112.7 | 113.22 | 112.7 | 112.71 | 37900.0 |
| 2004-04-15 18:00:00 | SPY | ETF | 112.7 | 112.75 | 112.7 | 112.75 | 15300.0 |
| 2004-04-15 18:30:00 | SPY | ETF | 112.77 | 112.77 | 112.73 | 112.73 | 2200.0 |
| 2004-04-15 19:00:00 | SPY | ETF | 112.73 | 112.77 | 112.73 | 112.77 | 6500.0 |
| 2004-04-15 19:30:00 | SPY | ETF | 112.74 | 112.74 | 112.7 | 112.7 | 4500.0 |
| 2004-04-15 08:00:00 | QQQ | ETF | 36.85 | 36.88 | 36.8 | 36.88 | 69800.0 |
| 2004-04-15 08:30:00 | QQQ | ETF | 36.88 | 36.91 | 36.81 | 36.82 | 157300.0 |
| 2004-04-15 09:00:00 | QQQ | ETF | 36.83 | 36.83 | 36.77 | 36.77 | 72200.0 |
| 2004-04-15 09:30:00 | QQQ | ETF | 36.75 | 36.86 | 36.63 | 36.67 | 6266300.0 |
| 2004-04-15 10:00:00 | QQQ | ETF | 36.66 | 36.75 | 36.55 | 36.61 | 7169200.0 |
| 2004-04-15 10:30:00 | QQQ | ETF | 36.6 | 36.63 | 36.37 | 36.42 | 8416100.0 |
| 2004-04-15 11:00:00 | QQQ | ETF | 36.43 | 36.57 | 36.4 | 36.46 | 5685300.0 |
| 2004-04-15 11:30:00 | QQQ | ETF | 36.46 | 36.51 | 36.35 | 36.43 | 3698700.0 |
| 2004-04-15 12:00:00 | QQQ | ETF | 36.44 | 36.5 | 36.26 | 36.318 | 7348100.0 |
| 2004-04-15 12:30:00 | QQQ | ETF | 36.34 | 36.37 | 36.23 | 36.35 | 5161600.0 |
| 2004-04-15 13:00:00 | QQQ | ETF | 36.35 | 36.37 | 36.23 | 36.26 | 3306000.0 |
| 2004-04-15 13:30:00 | QQQ | ETF | 36.263 | 36.33 | 36.13 | 36.15 | 6685600.0 |
| 2004-04-15 14:00:00 | QQQ | ETF | 36.15 | 36.2 | 36.02 | 36.173 | 10470600.0 |
| 2004-04-15 14:30:00 | QQQ | ETF | 36.172 | 36.29 | 36.14 | 36.287 | 6907100.0 |
| 2004-04-15 15:00:00 | QQQ | ETF | 36.28 | 36.4 | 36.22 | 36.34 | 6551200.0 |
| 2004-04-15 15:30:00 | QQQ | ETF | 36.311 | 36.46 | 36.311 | 36.312 | 6588800.0 |
| 2004-04-15 16:00:00 | QQQ | ETF | 36.309 | 36.32 | 36.0 | 36.09 | 4986100.0 |
| 2004-04-15 16:30:00 | QQQ | ETF | 36.081 | 36.1 | 35.945 | 35.99 | 595500.0 |
| 2004-04-15 17:00:00 | QQQ | ETF | 35.98 | 36.01 | 35.92 | 35.93 | 1520600.0 |
| 2004-04-15 17:30:00 | QQQ | ETF | 35.93 | 35.96 | 35.91 | 35.93 | 166100.0 |
| 2004-04-15 18:00:00 | QQQ | ETF | 35.93 | 35.95 | 35.92 | 35.94 | 79200.0 |
| 2004-04-15 18:30:00 | QQQ | ETF | 35.94 | 35.96 | 35.94 | 35.96 | 22700.0 |
| 2004-04-15 19:00:00 | QQQ | ETF | 35.95 | 35.95 | 35.95 | 35.95 | 6800.0 |
| 2004-04-15 19:30:00 | QQQ | ETF | 35.96 | 35.97 | 35.93 | 35.93 | 16000.0 |
| 2004-04-15 08:30:00 | IWM | ETF | 58.25 | 58.25 | 58.25 | 58.25 | 4000.0 |
| 2004-04-15 09:00:00 | IWM | ETF | 58.21 | 58.21 | 58.21 | 58.21 | 1000.0 |
> showing 50 of 1,158 rows — these rows as CSV