PREVIEW / etf_30min / 2010-12-13
file: by_date/etf_30min/2010/2010-12-13.parquet size: 272 KB rows: 9,144
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-13 04:00:00 | SPY | ETF | 124.6 | 124.6 | 124.6 | 124.6 | 100.0 |
| 2010-12-13 04:30:00 | SPY | ETF | 124.66 | 124.66 | 124.58 | 124.58 | 15100.0 |
| 2010-12-13 05:30:00 | SPY | ETF | 124.63 | 124.68 | 124.63 | 124.68 | 7900.0 |
| 2010-12-13 06:00:00 | SPY | ETF | 124.69 | 124.69 | 124.58 | 124.63 | 7700.0 |
| 2010-12-13 06:30:00 | SPY | ETF | 124.66 | 124.71 | 124.6 | 124.71 | 63200.0 |
| 2010-12-13 07:00:00 | SPY | ETF | 124.73 | 125.01 | 124.7 | 124.94 | 152605.0 |
| 2010-12-13 07:30:00 | SPY | ETF | 124.94 | 124.96 | 124.87 | 124.93 | 92588.0 |
| 2010-12-13 08:00:00 | SPY | ETF | 124.93 | 125.08 | 124.9 | 125.07 | 542725.0 |
| 2010-12-13 08:30:00 | SPY | ETF | 125.05 | 125.15 | 125.0 | 125.05 | 844142.0 |
| 2010-12-13 09:00:00 | SPY | ETF | 125.05 | 125.13 | 125.01 | 125.04 | 438648.0 |
| 2010-12-13 09:30:00 | SPY | ETF | 125.05 | 125.05 | 124.67 | 124.74 | 14302568.0 |
| 2010-12-13 10:00:00 | SPY | ETF | 124.73 | 125.05 | 124.73 | 124.88 | 8961891.0 |
| 2010-12-13 10:30:00 | SPY | ETF | 124.8883 | 125.14 | 124.86 | 125.125 | 8145866.0 |
| 2010-12-13 11:00:00 | SPY | ETF | 125.12 | 125.12 | 124.92 | 124.94 | 7281586.0 |
| 2010-12-13 11:30:00 | SPY | ETF | 124.94 | 125.09 | 124.9 | 125.06 | 6209083.0 |
| 2010-12-13 12:00:00 | SPY | ETF | 125.05 | 125.0999 | 124.93 | 125.02 | 4411270.0 |
| 2010-12-13 12:30:00 | SPY | ETF | 125.02 | 125.09 | 124.98 | 125.04 | 3296359.0 |
| 2010-12-13 13:00:00 | SPY | ETF | 125.03 | 125.08 | 125.0 | 125.07 | 3702560.0 |
| 2010-12-13 13:30:00 | SPY | ETF | 125.07 | 125.12 | 124.96 | 125.1 | 5437424.0 |
| 2010-12-13 14:00:00 | SPY | ETF | 125.09 | 125.19 | 125.05 | 125.075 | 6736004.0 |
| 2010-12-13 14:30:00 | SPY | ETF | 125.08 | 125.2 | 125.05 | 125.065 | 4723074.0 |
| 2010-12-13 15:00:00 | SPY | ETF | 125.07 | 125.1 | 124.85 | 124.9 | 10081823.0 |
| 2010-12-13 15:30:00 | SPY | ETF | 124.91 | 124.92 | 124.52 | 124.55 | 24052989.0 |
| 2010-12-13 16:00:00 | SPY | ETF | 124.57 | 125.09 | 124.5106 | 124.61 | 16385203.0 |
| 2010-12-13 16:30:00 | SPY | ETF | 124.6 | 124.63 | 124.5451 | 124.62 | 2996405.0 |
| 2010-12-13 17:00:00 | SPY | ETF | 124.61 | 124.69 | 124.6 | 124.62 | 433824.0 |
| 2010-12-13 17:30:00 | SPY | ETF | 124.61 | 124.7 | 124.61 | 124.66 | 25110.0 |
| 2010-12-13 18:00:00 | SPY | ETF | 124.65 | 124.65 | 124.56 | 124.56 | 65774.0 |
| 2010-12-13 18:30:00 | SPY | ETF | 124.58 | 124.58 | 124.51 | 124.53 | 51750.0 |
| 2010-12-13 19:00:00 | SPY | ETF | 124.53 | 124.54 | 124.48 | 124.5 | 59137.0 |
| 2010-12-13 19:30:00 | SPY | ETF | 124.49 | 124.52 | 124.47 | 124.52 | 20375.0 |
| 2010-12-13 04:00:00 | QQQ | ETF | 54.56 | 54.56 | 54.56 | 54.56 | 200.0 |
| 2010-12-13 04:30:00 | QQQ | ETF | 54.54 | 54.58 | 54.54 | 54.58 | 108000.0 |
| 2010-12-13 05:00:00 | QQQ | ETF | 54.52 | 54.52 | 54.52 | 54.52 | 100.0 |
| 2010-12-13 05:30:00 | QQQ | ETF | 54.56 | 54.57 | 54.56 | 54.57 | 10000.0 |
| 2010-12-13 06:00:00 | QQQ | ETF | 54.57 | 54.57 | 54.55 | 54.55 | 567.0 |
| 2010-12-13 06:30:00 | QQQ | ETF | 54.56 | 54.58 | 54.53 | 54.55 | 20092.0 |
| 2010-12-13 07:00:00 | QQQ | ETF | 54.56 | 54.66 | 54.56 | 54.64 | 51525.0 |
| 2010-12-13 07:30:00 | QQQ | ETF | 54.63 | 54.65 | 54.63 | 54.65 | 45600.0 |
| 2010-12-13 08:00:00 | QQQ | ETF | 54.66 | 54.71 | 54.65 | 54.7 | 185128.0 |
| 2010-12-13 08:30:00 | QQQ | ETF | 54.7 | 54.74 | 54.66 | 54.71 | 226749.0 |
| 2010-12-13 09:00:00 | QQQ | ETF | 54.72 | 54.76 | 54.71 | 54.72 | 428636.0 |
| 2010-12-13 09:30:00 | QQQ | ETF | 54.71 | 54.715 | 54.51 | 54.5282 | 8269913.0 |
| 2010-12-13 10:00:00 | QQQ | ETF | 54.53 | 54.67 | 54.525 | 54.63 | 3726159.0 |
| 2010-12-13 10:30:00 | QQQ | ETF | 54.625 | 54.74 | 54.6 | 54.73 | 2640768.0 |
| 2010-12-13 11:00:00 | QQQ | ETF | 54.72 | 54.73 | 54.61 | 54.62 | 1870058.0 |
| 2010-12-13 11:30:00 | QQQ | ETF | 54.62 | 54.65 | 54.59 | 54.615 | 2162532.0 |
| 2010-12-13 12:00:00 | QQQ | ETF | 54.62 | 54.63 | 54.55 | 54.58 | 1816839.0 |
| 2010-12-13 12:30:00 | QQQ | ETF | 54.58 | 54.62 | 54.56 | 54.609 | 1097814.0 |
| 2010-12-13 13:00:00 | QQQ | ETF | 54.6038 | 54.63 | 54.59 | 54.608 | 826950.0 |
> showing 50 of 9,144 rows — these rows as CSV