PREVIEW / etf_30min / 2010-12-10
file: by_date/etf_30min/2010/2010-12-10.parquet size: 267 KB rows: 8,810
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-10 04:30:00 | SPY | ETF | 124.1 | 124.1 | 124.1 | 124.1 | 100.0 |
| 2010-12-10 05:00:00 | SPY | ETF | 124.01 | 124.23 | 124.0 | 124.23 | 10400.0 |
| 2010-12-10 05:30:00 | SPY | ETF | 124.2 | 124.24 | 124.2 | 124.24 | 12100.0 |
| 2010-12-10 06:00:00 | SPY | ETF | 124.17 | 124.17 | 124.15 | 124.15 | 2800.0 |
| 2010-12-10 06:30:00 | SPY | ETF | 124.1 | 124.1 | 124.07 | 124.1 | 3800.0 |
| 2010-12-10 07:00:00 | SPY | ETF | 124.1 | 124.23 | 124.07 | 124.17 | 130010.0 |
| 2010-12-10 07:30:00 | SPY | ETF | 124.18 | 124.24 | 124.17 | 124.23 | 149100.0 |
| 2010-12-10 08:00:00 | SPY | ETF | 124.23 | 124.31 | 124.23 | 124.25 | 488287.0 |
| 2010-12-10 08:30:00 | SPY | ETF | 124.24 | 124.27 | 123.97 | 124.0 | 642744.0 |
| 2010-12-10 09:00:00 | SPY | ETF | 124.0 | 124.14 | 123.9 | 124.14 | 776682.0 |
| 2010-12-10 09:30:00 | SPY | ETF | 124.14 | 124.21 | 123.95 | 124.01 | 15013234.0 |
| 2010-12-10 10:00:00 | SPY | ETF | 124.01 | 124.02 | 123.73 | 123.98 | 9737786.0 |
| 2010-12-10 10:30:00 | SPY | ETF | 123.99 | 124.02 | 123.8 | 123.96 | 6014734.0 |
| 2010-12-10 11:00:00 | SPY | ETF | 123.96 | 124.09 | 123.94 | 123.94 | 5647815.0 |
| 2010-12-10 11:30:00 | SPY | ETF | 123.95 | 124.16 | 123.91 | 124.15 | 5935079.0 |
| 2010-12-10 12:00:00 | SPY | ETF | 124.15 | 124.22 | 124.09 | 124.19 | 5895356.0 |
| 2010-12-10 12:30:00 | SPY | ETF | 124.19 | 124.35 | 124.19 | 124.26 | 5923532.0 |
| 2010-12-10 13:00:00 | SPY | ETF | 124.2601 | 124.36 | 124.23 | 124.288 | 3827586.0 |
| 2010-12-10 13:30:00 | SPY | ETF | 124.2815 | 124.47 | 124.28 | 124.45 | 4334188.0 |
| 2010-12-10 14:00:00 | SPY | ETF | 124.45 | 124.51 | 124.39 | 124.39 | 4712520.0 |
| 2010-12-10 14:30:00 | SPY | ETF | 124.39 | 124.5 | 124.34 | 124.48 | 6212817.0 |
| 2010-12-10 15:00:00 | SPY | ETF | 124.49 | 124.5 | 124.32 | 124.48 | 7316171.0 |
| 2010-12-10 15:30:00 | SPY | ETF | 124.48 | 124.6 | 124.46 | 124.51 | 22900010.0 |
| 2010-12-10 16:00:00 | SPY | ETF | 124.5 | 124.63 | 123.9 | 124.55 | 10579499.0 |
| 2010-12-10 16:30:00 | SPY | ETF | 124.55 | 124.62 | 124.55 | 124.6 | 165400.0 |
| 2010-12-10 17:00:00 | SPY | ETF | 124.61 | 124.65 | 124.58 | 124.63 | 147634.0 |
| 2010-12-10 17:30:00 | SPY | ETF | 124.61 | 124.62 | 124.52 | 124.55 | 48092.0 |
| 2010-12-10 18:00:00 | SPY | ETF | 124.54 | 124.57 | 124.5 | 124.54 | 76973.0 |
| 2010-12-10 18:30:00 | SPY | ETF | 124.53 | 124.54 | 124.51 | 124.54 | 8297.0 |
| 2010-12-10 19:00:00 | SPY | ETF | 124.53 | 124.56 | 124.52 | 124.55 | 15290.0 |
| 2010-12-10 19:30:00 | SPY | ETF | 124.55 | 124.6 | 124.51 | 124.56 | 19575.0 |
| 2010-12-10 06:00:00 | QQQ | ETF | 54.3 | 54.32 | 54.3 | 54.32 | 800.0 |
| 2010-12-10 06:30:00 | QQQ | ETF | 54.22 | 54.23 | 54.22 | 54.23 | 1000.0 |
| 2010-12-10 07:00:00 | QQQ | ETF | 54.23 | 54.29 | 54.22 | 54.23 | 162615.0 |
| 2010-12-10 07:30:00 | QQQ | ETF | 54.26 | 54.3 | 54.25 | 54.3 | 14324.0 |
| 2010-12-10 08:00:00 | QQQ | ETF | 54.24 | 54.32 | 54.24 | 54.29 | 181840.0 |
| 2010-12-10 08:30:00 | QQQ | ETF | 54.29 | 54.32 | 54.18 | 54.19 | 146200.0 |
| 2010-12-10 09:00:00 | QQQ | ETF | 54.2 | 54.28 | 54.15 | 54.28 | 362935.0 |
| 2010-12-10 09:30:00 | QQQ | ETF | 54.29 | 54.33 | 54.17 | 54.2 | 6727936.0 |
| 2010-12-10 10:00:00 | QQQ | ETF | 54.2 | 54.26 | 54.09 | 54.25 | 6321825.0 |
| 2010-12-10 10:30:00 | QQQ | ETF | 54.2505 | 54.31 | 54.21 | 54.28 | 3329504.0 |
| 2010-12-10 11:00:00 | QQQ | ETF | 54.27 | 54.32 | 54.23 | 54.25 | 1196028.0 |
| 2010-12-10 11:30:00 | QQQ | ETF | 54.25 | 54.33 | 54.23 | 54.325 | 1051460.0 |
| 2010-12-10 12:00:00 | QQQ | ETF | 54.325 | 54.37 | 54.3 | 54.36 | 1378627.0 |
| 2010-12-10 12:30:00 | QQQ | ETF | 54.3596 | 54.46 | 54.3596 | 54.43 | 1923859.0 |
| 2010-12-10 13:00:00 | QQQ | ETF | 54.422 | 54.49 | 54.4 | 54.4401 | 1367952.0 |
| 2010-12-10 13:30:00 | QQQ | ETF | 54.44 | 54.52 | 54.43 | 54.515 | 1623207.0 |
| 2010-12-10 14:00:00 | QQQ | ETF | 54.51 | 54.53 | 54.46 | 54.46 | 1313296.0 |
| 2010-12-10 14:30:00 | QQQ | ETF | 54.46 | 54.51 | 54.44 | 54.5 | 989925.0 |
| 2010-12-10 15:00:00 | QQQ | ETF | 54.509 | 54.51 | 54.42 | 54.49 | 1794779.0 |
> showing 50 of 8,810 rows — these rows as CSV