PREVIEW / etf_30min / 2004-06-07
file: by_date/etf_30min/2004/2004-06-07.parquet size: 36 KB rows: 1,196
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-06-07 08:00:00 | SPY | ETF | 113.58 | 113.58 | 113.47 | 113.51 | 14700.0 |
| 2004-06-07 08:30:00 | SPY | ETF | 113.55 | 113.6 | 113.51 | 113.55 | 68800.0 |
| 2004-06-07 09:00:00 | SPY | ETF | 113.55 | 113.55 | 113.45 | 113.46 | 27800.0 |
| 2004-06-07 09:30:00 | SPY | ETF | 113.43 | 113.76 | 113.42 | 113.72 | 4184800.0 |
| 2004-06-07 10:00:00 | SPY | ETF | 113.71 | 113.79 | 113.57 | 113.73 | 2912800.0 |
| 2004-06-07 10:30:00 | SPY | ETF | 113.73 | 113.82 | 113.62 | 113.73 | 2606000.0 |
| 2004-06-07 11:00:00 | SPY | ETF | 113.74 | 114.08 | 113.67 | 114.02 | 4523500.0 |
| 2004-06-07 11:30:00 | SPY | ETF | 114.02 | 114.09 | 113.92 | 113.97 | 1732300.0 |
| 2004-06-07 12:00:00 | SPY | ETF | 113.97 | 114.07 | 113.93 | 113.99 | 680100.0 |
| 2004-06-07 12:30:00 | SPY | ETF | 113.97 | 114.0 | 113.86 | 113.98 | 637500.0 |
| 2004-06-07 13:00:00 | SPY | ETF | 113.98 | 114.07 | 113.95 | 114.06 | 568300.0 |
| 2004-06-07 13:30:00 | SPY | ETF | 114.06 | 114.27 | 114.05 | 114.23 | 1771200.0 |
| 2004-06-07 14:00:00 | SPY | ETF | 114.2 | 114.23 | 114.09 | 114.1 | 973300.0 |
| 2004-06-07 14:30:00 | SPY | ETF | 114.11 | 114.45 | 114.09 | 114.4 | 2027100.0 |
| 2004-06-07 15:00:00 | SPY | ETF | 114.39 | 114.56 | 114.35 | 114.54 | 2270900.0 |
| 2004-06-07 15:30:00 | SPY | ETF | 114.55 | 114.7 | 114.49 | 114.65 | 3518000.0 |
| 2004-06-07 16:00:00 | SPY | ETF | 114.65 | 114.81 | 114.55 | 114.7 | 1806800.0 |
| 2004-06-07 16:30:00 | SPY | ETF | 114.71 | 114.71 | 114.57 | 114.62 | 157000.0 |
| 2004-06-07 17:00:00 | SPY | ETF | 114.63 | 114.66 | 114.62 | 114.62 | 46500.0 |
| 2004-06-07 17:30:00 | SPY | ETF | 114.64 | 114.66 | 114.63 | 114.63 | 3100.0 |
| 2004-06-07 18:00:00 | SPY | ETF | 114.66 | 114.69 | 114.66 | 114.68 | 9900.0 |
| 2004-06-07 18:30:00 | SPY | ETF | 114.67 | 114.67 | 114.67 | 114.67 | 1000.0 |
| 2004-06-07 19:00:00 | SPY | ETF | 114.66 | 114.66 | 114.66 | 114.66 | 100.0 |
| 2004-06-07 19:30:00 | SPY | ETF | 114.66 | 114.69 | 114.65 | 114.65 | 2900.0 |
| 2004-06-07 08:00:00 | QQQ | ETF | 36.49 | 36.49 | 36.46 | 36.46 | 13600.0 |
| 2004-06-07 08:30:00 | QQQ | ETF | 36.47 | 36.5 | 36.47 | 36.47 | 80500.0 |
| 2004-06-07 09:00:00 | QQQ | ETF | 36.47 | 36.49 | 36.43 | 36.43 | 45800.0 |
| 2004-06-07 09:30:00 | QQQ | ETF | 36.44 | 36.56 | 36.39 | 36.54 | 13649600.0 |
| 2004-06-07 10:00:00 | QQQ | ETF | 36.541 | 36.541 | 36.4 | 36.49 | 8534600.0 |
| 2004-06-07 10:30:00 | QQQ | ETF | 36.495 | 36.52 | 36.41 | 36.47 | 3897700.0 |
| 2004-06-07 11:00:00 | QQQ | ETF | 36.47 | 36.67 | 36.45 | 36.65 | 11692600.0 |
| 2004-06-07 11:30:00 | QQQ | ETF | 36.66 | 36.7 | 36.59 | 36.65 | 8052400.0 |
| 2004-06-07 12:00:00 | QQQ | ETF | 36.65 | 36.737 | 36.64 | 36.685 | 4922600.0 |
| 2004-06-07 12:30:00 | QQQ | ETF | 36.686 | 36.71 | 36.61 | 36.65 | 3765600.0 |
| 2004-06-07 13:00:00 | QQQ | ETF | 36.65 | 36.705 | 36.64 | 36.7 | 2325200.0 |
| 2004-06-07 13:30:00 | QQQ | ETF | 36.703 | 36.8 | 36.69 | 36.78 | 6638700.0 |
| 2004-06-07 14:00:00 | QQQ | ETF | 36.777 | 36.8 | 36.73 | 36.76 | 3961400.0 |
| 2004-06-07 14:30:00 | QQQ | ETF | 36.757 | 36.9 | 36.73 | 36.87 | 7499700.0 |
| 2004-06-07 15:00:00 | QQQ | ETF | 36.87 | 37.02 | 36.86 | 37.0 | 9329700.0 |
| 2004-06-07 15:30:00 | QQQ | ETF | 37.0 | 37.09 | 36.959 | 37.066 | 13990900.0 |
| 2004-06-07 16:00:00 | QQQ | ETF | 37.06 | 37.1 | 37.03 | 37.08 | 4045800.0 |
| 2004-06-07 16:30:00 | QQQ | ETF | 37.08 | 37.08 | 36.98 | 37.01 | 764000.0 |
| 2004-06-07 17:00:00 | QQQ | ETF | 37.0 | 37.01 | 36.99 | 37.0 | 25800.0 |
| 2004-06-07 17:30:00 | QQQ | ETF | 36.981 | 36.981 | 36.96 | 36.98 | 86800.0 |
| 2004-06-07 18:00:00 | QQQ | ETF | 36.98 | 37.0 | 36.98 | 37.0 | 52000.0 |
| 2004-06-07 18:30:00 | QQQ | ETF | 37.0 | 37.0 | 36.99 | 36.99 | 9700.0 |
| 2004-06-07 19:00:00 | QQQ | ETF | 37.0 | 37.0 | 37.0 | 37.0 | 3000.0 |
| 2004-06-07 19:30:00 | QQQ | ETF | 37.0 | 37.04 | 36.99 | 37.0 | 4400.0 |
| 2004-06-07 08:00:00 | IWM | ETF | 57.03 | 57.03 | 57.03 | 57.03 | 2000.0 |
| 2004-06-07 09:00:00 | IWM | ETF | 57.06 | 57.06 | 56.96 | 56.96 | 33000.0 |
> showing 50 of 1,196 rows — these rows as CSV