PREVIEW / etf_30min / 2008-12-17
file: by_date/etf_30min/2008/2008-12-17.parquet size: 201 KB rows: 7,283
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-17 04:00:00 | SPY | ETF | 89.37 | 89.71 | 89.37 | 89.66 | 13124.0 |
| 2008-12-17 04:30:00 | SPY | ETF | 89.74 | 89.76 | 89.59 | 89.67 | 2624.0 |
| 2008-12-17 05:00:00 | SPY | ETF | 89.71 | 90.01 | 89.69 | 90.0 | 50612.0 |
| 2008-12-17 05:30:00 | SPY | ETF | 89.99 | 90.27 | 89.98 | 90.2 | 7000.0 |
| 2008-12-17 06:00:00 | SPY | ETF | 90.44 | 90.78 | 90.4 | 90.49 | 49030.0 |
| 2008-12-17 06:30:00 | SPY | ETF | 90.46 | 90.61 | 90.3 | 90.5 | 171210.0 |
| 2008-12-17 07:00:00 | SPY | ETF | 90.57 | 90.8 | 90.26 | 90.57 | 984771.0 |
| 2008-12-17 07:30:00 | SPY | ETF | 90.58 | 90.66 | 90.34 | 90.63 | 896875.0 |
| 2008-12-17 08:00:00 | SPY | ETF | 90.65 | 90.85 | 89.49 | 90.52 | 1935860.0 |
| 2008-12-17 08:30:00 | SPY | ETF | 90.53 | 91.19 | 90.52 | 91.11 | 1528956.0 |
| 2008-12-17 09:00:00 | SPY | ETF | 91.1 | 91.15 | 90.65 | 90.84 | 1414007.0 |
| 2008-12-17 09:30:00 | SPY | ETF | 90.84 | 91.22 | 90.28 | 91.13 | 32085576.0 |
| 2008-12-17 10:00:00 | SPY | ETF | 91.139 | 91.28 | 90.06 | 90.53 | 24278930.0 |
| 2008-12-17 10:30:00 | SPY | ETF | 90.52 | 91.14 | 90.38 | 91.09 | 19230687.0 |
| 2008-12-17 11:00:00 | SPY | ETF | 91.09 | 91.32 | 90.65 | 90.74 | 14253439.0 |
| 2008-12-17 11:30:00 | SPY | ETF | 90.74 | 91.13 | 90.43 | 91.08 | 13841615.0 |
| 2008-12-17 12:00:00 | SPY | ETF | 91.08 | 91.61 | 90.86 | 91.46 | 13953389.0 |
| 2008-12-17 12:30:00 | SPY | ETF | 91.46 | 91.84 | 91.15 | 91.56 | 11572351.0 |
| 2008-12-17 13:00:00 | SPY | ETF | 91.56 | 91.99 | 91.33 | 91.68 | 8202057.0 |
| 2008-12-17 13:30:00 | SPY | ETF | 91.68 | 92.43 | 91.6 | 91.98 | 17946340.0 |
| 2008-12-17 14:00:00 | SPY | ETF | 91.989 | 92.42 | 91.36 | 91.401 | 16951021.0 |
| 2008-12-17 14:30:00 | SPY | ETF | 91.4 | 91.66 | 90.99 | 91.56 | 21216966.0 |
| 2008-12-17 15:00:00 | SPY | ETF | 91.55 | 91.99 | 91.18 | 91.38 | 20100723.0 |
| 2008-12-17 15:30:00 | SPY | ETF | 91.37 | 91.9 | 90.83 | 91.01 | 34724544.0 |
| 2008-12-17 16:00:00 | SPY | ETF | 90.96 | 91.98 | 90.78 | 91.02 | 17525794.0 |
| 2008-12-17 16:30:00 | SPY | ETF | 91.05 | 91.761 | 90.94 | 91.18 | 562144.0 |
| 2008-12-17 17:00:00 | SPY | ETF | 91.16 | 91.17 | 90.99 | 91.02 | 5099357.0 |
| 2008-12-17 17:30:00 | SPY | ETF | 91.0 | 91.87 | 90.95 | 91.87 | 152651.0 |
| 2008-12-17 18:00:00 | SPY | ETF | 90.97 | 91.54 | 90.95 | 91.04 | 70142.0 |
| 2008-12-17 18:30:00 | SPY | ETF | 91.05 | 91.05 | 90.8 | 90.8 | 101735.0 |
| 2008-12-17 19:00:00 | SPY | ETF | 90.8 | 90.9 | 90.75 | 90.9 | 28263.0 |
| 2008-12-17 19:30:00 | SPY | ETF | 90.87 | 91.0 | 90.85 | 90.93 | 32304.0 |
| 2008-12-17 20:00:00 | SPY | ETF | 90.99 | 91.0 | 90.86 | 90.86 | 9016.0 |
| 2008-12-17 04:00:00 | QQQ | ETF | 29.78 | 29.79 | 29.76 | 29.79 | 2150.0 |
| 2008-12-17 04:30:00 | QQQ | ETF | 29.8 | 29.8 | 29.78 | 29.78 | 5200.0 |
| 2008-12-17 05:30:00 | QQQ | ETF | 30.11 | 30.11 | 30.11 | 30.11 | 300.0 |
| 2008-12-17 06:00:00 | QQQ | ETF | 30.28 | 30.28 | 30.28 | 30.28 | 875.0 |
| 2008-12-17 06:30:00 | QQQ | ETF | 30.21 | 30.22 | 30.08 | 30.22 | 5100.0 |
| 2008-12-17 07:00:00 | QQQ | ETF | 30.24 | 30.27 | 30.12 | 30.2 | 33090.0 |
| 2008-12-17 07:30:00 | QQQ | ETF | 30.2 | 30.23 | 30.15 | 30.21 | 52860.0 |
| 2008-12-17 08:00:00 | QQQ | ETF | 30.2 | 30.27 | 30.09 | 30.21 | 684933.0 |
| 2008-12-17 08:30:00 | QQQ | ETF | 30.19 | 30.6 | 30.18 | 30.34 | 519888.0 |
| 2008-12-17 09:00:00 | QQQ | ETF | 30.33 | 30.39 | 30.19 | 30.24 | 1490307.0 |
| 2008-12-17 09:30:00 | QQQ | ETF | 30.23 | 30.33 | 30.04 | 30.21 | 19823107.0 |
| 2008-12-17 10:00:00 | QQQ | ETF | 30.21 | 30.2411 | 29.82 | 30.0001 | 15847690.0 |
| 2008-12-17 10:30:00 | QQQ | ETF | 30.01 | 30.17 | 29.95 | 30.12 | 10026773.0 |
| 2008-12-17 11:00:00 | QQQ | ETF | 30.13 | 30.18 | 29.99 | 30.03 | 7923615.0 |
| 2008-12-17 11:30:00 | QQQ | ETF | 30.02 | 30.21 | 29.96 | 30.2 | 6807208.0 |
| 2008-12-17 12:00:00 | QQQ | ETF | 30.2 | 30.49 | 30.14 | 30.38 | 10985044.0 |
| 2008-12-17 12:30:00 | QQQ | ETF | 30.38 | 30.45 | 30.23 | 30.37 | 9781062.0 |
> showing 50 of 7,283 rows — these rows as CSV