PREVIEW / etf_30min / 2008-12-04
file: by_date/etf_30min/2008/2008-12-04.parquet size: 182 KB rows: 6,482
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-04 04:00:00 | SPY | ETF | 87.51 | 87.59 | 87.47 | 87.47 | 2200.0 |
| 2008-12-04 04:30:00 | SPY | ETF | 87.34 | 87.76 | 87.24 | 87.76 | 3850.0 |
| 2008-12-04 05:00:00 | SPY | ETF | 87.67 | 87.82 | 87.57 | 87.82 | 950.0 |
| 2008-12-04 05:30:00 | SPY | ETF | 87.97 | 87.97 | 87.65 | 87.65 | 8100.0 |
| 2008-12-04 06:00:00 | SPY | ETF | 87.48 | 87.76 | 87.4 | 87.62 | 9269.0 |
| 2008-12-04 06:30:00 | SPY | ETF | 87.77 | 87.77 | 87.31 | 87.6 | 83090.0 |
| 2008-12-04 07:00:00 | SPY | ETF | 87.43 | 87.54 | 86.78 | 87.2 | 514055.0 |
| 2008-12-04 07:30:00 | SPY | ETF | 87.19 | 87.82 | 86.74 | 86.96 | 1602546.0 |
| 2008-12-04 08:00:00 | SPY | ETF | 87.15 | 87.15 | 85.58 | 85.63 | 4684933.0 |
| 2008-12-04 08:30:00 | SPY | ETF | 85.7 | 87.52 | 85.68 | 86.0 | 5595403.0 |
| 2008-12-04 09:00:00 | SPY | ETF | 86.05 | 87.32 | 85.96 | 86.05 | 1251921.0 |
| 2008-12-04 09:30:00 | SPY | ETF | 86.06 | 87.55 | 85.93 | 87.17 | 35217845.0 |
| 2008-12-04 10:00:00 | SPY | ETF | 87.17 | 87.76 | 86.5 | 86.99 | 36705211.0 |
| 2008-12-04 10:30:00 | SPY | ETF | 86.99 | 88.05 | 86.8605 | 87.92 | 29379145.0 |
| 2008-12-04 11:00:00 | SPY | ETF | 87.92 | 88.0 | 87.14 | 87.74 | 25309077.0 |
| 2008-12-04 11:30:00 | SPY | ETF | 87.73 | 87.74 | 86.78 | 87.2 | 23526520.0 |
| 2008-12-04 12:00:00 | SPY | ETF | 87.2 | 87.31 | 86.34 | 86.71 | 18138981.0 |
| 2008-12-04 12:30:00 | SPY | ETF | 86.71 | 87.14 | 86.5 | 86.8 | 13148278.0 |
| 2008-12-04 13:00:00 | SPY | ETF | 86.8008 | 86.88 | 86.07 | 86.085 | 17359755.0 |
| 2008-12-04 13:30:00 | SPY | ETF | 86.08 | 87.27 | 86.03 | 86.97 | 22834578.0 |
| 2008-12-04 14:00:00 | SPY | ETF | 86.97 | 87.4 | 86.6 | 86.9 | 23366717.0 |
| 2008-12-04 14:30:00 | SPY | ETF | 86.89 | 87.52 | 86.33 | 86.35 | 32363774.0 |
| 2008-12-04 15:00:00 | SPY | ETF | 86.35 | 87.2 | 84.0 | 84.12 | 51869768.0 |
| 2008-12-04 15:30:00 | SPY | ETF | 84.12 | 85.29 | 83.74 | 84.88 | 71552642.0 |
| 2008-12-04 16:00:00 | SPY | ETF | 84.92 | 87.5338 | 84.87 | 85.22 | 17509202.0 |
| 2008-12-04 16:30:00 | SPY | ETF | 85.22 | 87.5338 | 85.05 | 85.19 | 5886231.0 |
| 2008-12-04 17:00:00 | SPY | ETF | 85.2 | 85.36 | 85.04 | 85.12 | 2104957.0 |
| 2008-12-04 17:30:00 | SPY | ETF | 85.09 | 85.17 | 85.01 | 85.15 | 36597.0 |
| 2008-12-04 18:00:00 | SPY | ETF | 85.16 | 85.22 | 85.12 | 85.22 | 157118.0 |
| 2008-12-04 18:30:00 | SPY | ETF | 85.19 | 85.32 | 85.19 | 85.31 | 27114.0 |
| 2008-12-04 19:00:00 | SPY | ETF | 85.32 | 85.45 | 85.3 | 85.38 | 93789.0 |
| 2008-12-04 19:30:00 | SPY | ETF | 85.43 | 85.43 | 85.1 | 85.22 | 42844.0 |
| 2008-12-04 06:00:00 | QQQ | ETF | 28.58 | 28.58 | 28.58 | 28.58 | 100.0 |
| 2008-12-04 06:30:00 | QQQ | ETF | 28.56 | 28.57 | 28.51 | 28.57 | 4652.0 |
| 2008-12-04 07:00:00 | QQQ | ETF | 28.51 | 28.56 | 28.42 | 28.5 | 306471.0 |
| 2008-12-04 07:30:00 | QQQ | ETF | 28.5 | 28.71 | 28.34 | 28.45 | 352507.0 |
| 2008-12-04 08:00:00 | QQQ | ETF | 28.42 | 28.5 | 27.97 | 27.98 | 2912576.0 |
| 2008-12-04 08:30:00 | QQQ | ETF | 27.97 | 28.12 | 27.97 | 27.98 | 1941137.0 |
| 2008-12-04 09:00:00 | QQQ | ETF | 27.99 | 28.2 | 27.95 | 28.15 | 1000087.0 |
| 2008-12-04 09:30:00 | QQQ | ETF | 28.16 | 28.58 | 28.11 | 28.43 | 16221171.0 |
| 2008-12-04 10:00:00 | QQQ | ETF | 28.43 | 28.64 | 28.24 | 28.36 | 19140829.0 |
| 2008-12-04 10:30:00 | QQQ | ETF | 28.36 | 28.78 | 28.33 | 28.75 | 15220559.0 |
| 2008-12-04 11:00:00 | QQQ | ETF | 28.75 | 28.76 | 28.43 | 28.66 | 12260270.0 |
| 2008-12-04 11:30:00 | QQQ | ETF | 28.65 | 28.65 | 28.33 | 28.4899 | 10430320.0 |
| 2008-12-04 12:00:00 | QQQ | ETF | 28.48 | 28.51 | 28.2 | 28.31 | 8083656.0 |
| 2008-12-04 12:30:00 | QQQ | ETF | 28.32 | 28.45 | 28.27 | 28.35 | 6731736.0 |
| 2008-12-04 13:00:00 | QQQ | ETF | 28.34 | 28.36 | 28.1 | 28.12 | 6477807.0 |
| 2008-12-04 13:30:00 | QQQ | ETF | 28.11 | 28.42 | 28.09 | 28.3 | 7731821.0 |
| 2008-12-04 14:00:00 | QQQ | ETF | 28.31 | 28.43 | 28.22 | 28.27 | 7479745.0 |
| 2008-12-04 14:30:00 | QQQ | ETF | 28.26 | 28.46 | 28.12 | 28.15 | 10091289.0 |
> showing 50 of 6,482 rows — these rows as CSV