PREVIEW / etf_30min / 2015-12-14
file: by_date/etf_30min/2015/2015-12-14.parquet size: 404 KB rows: 13,553
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-14 04:00:00 | SPY | ETF | 202.5 | 203.1 | 202.5 | 203.1 | 32348.0 |
| 2015-12-14 04:30:00 | SPY | ETF | 203.08 | 203.3 | 203.01 | 203.17 | 39898.0 |
| 2015-12-14 05:00:00 | SPY | ETF | 203.23 | 203.23 | 202.82 | 202.83 | 24347.0 |
| 2015-12-14 05:30:00 | SPY | ETF | 202.81 | 203.11 | 202.81 | 203.11 | 41165.0 |
| 2015-12-14 06:00:00 | SPY | ETF | 203.09 | 203.13 | 201.89 | 202.0 | 139074.0 |
| 2015-12-14 06:30:00 | SPY | ETF | 202.04 | 202.04 | 201.25 | 201.88 | 299739.0 |
| 2015-12-14 07:00:00 | SPY | ETF | 201.87 | 202.11 | 200.79 | 201.26 | 455384.0 |
| 2015-12-14 07:30:00 | SPY | ETF | 201.23 | 201.57 | 201.18 | 201.52 | 336265.0 |
| 2015-12-14 08:00:00 | SPY | ETF | 202.02 | 202.3 | 201.02 | 201.45 | 631247.0 |
| 2015-12-14 08:30:00 | SPY | ETF | 201.4 | 202.4 | 201.37 | 202.13 | 768510.0 |
| 2015-12-14 09:00:00 | SPY | ETF | 202.15 | 202.46 | 201.97 | 202.06 | 879912.0 |
| 2015-12-14 09:30:00 | SPY | ETF | 202.07 | 202.73 | 201.5 | 201.57 | 15997125.0 |
| 2015-12-14 10:00:00 | SPY | ETF | 201.58 | 203.05 | 200.83 | 200.93 | 28969598.0 |
| 2015-12-14 10:30:00 | SPY | ETF | 200.93 | 201.75 | 200.86 | 201.384 | 12496047.0 |
| 2015-12-14 11:00:00 | SPY | ETF | 201.37 | 201.46 | 200.27 | 200.57 | 12771301.0 |
| 2015-12-14 11:30:00 | SPY | ETF | 200.57 | 201.08 | 199.95 | 201.04 | 13200446.0 |
| 2015-12-14 12:00:00 | SPY | ETF | 201.03 | 202.07 | 200.84 | 202.05 | 11780426.0 |
| 2015-12-14 12:30:00 | SPY | ETF | 202.05 | 202.44 | 201.37 | 202.32 | 11607865.0 |
| 2015-12-14 13:00:00 | SPY | ETF | 202.33 | 202.57 | 201.58 | 201.791 | 9046629.0 |
| 2015-12-14 13:30:00 | SPY | ETF | 201.79 | 201.91 | 201.27 | 201.76 | 5723128.0 |
| 2015-12-14 14:00:00 | SPY | ETF | 201.751 | 202.09 | 201.34 | 201.62 | 7193782.0 |
| 2015-12-14 14:30:00 | SPY | ETF | 201.62 | 202.42 | 201.39 | 202.15 | 6673051.0 |
| 2015-12-14 15:00:00 | SPY | ETF | 202.15 | 202.15 | 201.54 | 202.02 | 7945264.0 |
| 2015-12-14 15:30:00 | SPY | ETF | 202.01 | 203.0 | 201.895 | 202.99 | 21615150.0 |
| 2015-12-14 16:00:00 | SPY | ETF | 202.99 | 203.15 | 201.2161 | 202.55 | 9801425.0 |
| 2015-12-14 16:30:00 | SPY | ETF | 202.54 | 203.0 | 202.53 | 202.79 | 2578726.0 |
| 2015-12-14 17:00:00 | SPY | ETF | 202.76 | 202.76 | 202.69 | 202.7 | 87435.0 |
| 2015-12-14 17:30:00 | SPY | ETF | 202.69 | 202.83 | 202.67 | 202.83 | 60032.0 |
| 2015-12-14 18:00:00 | SPY | ETF | 202.84 | 203.45 | 202.83 | 203.38 | 324175.0 |
| 2015-12-14 18:30:00 | SPY | ETF | 203.38 | 203.47 | 203.0 | 203.31 | 143410.0 |
| 2015-12-14 19:00:00 | SPY | ETF | 203.3 | 203.37 | 202.96 | 203.03 | 85477.0 |
| 2015-12-14 19:30:00 | SPY | ETF | 203.05 | 203.11 | 202.9 | 203.1 | 44024.0 |
| 2015-12-14 20:00:00 | SPY | ETF | 202.8623 | 202.8623 | 202.8623 | 202.8623 | 400000.0 |
| 2015-12-14 04:00:00 | QQQ | ETF | 111.3 | 111.51 | 111.3 | 111.51 | 1200.0 |
| 2015-12-14 04:30:00 | QQQ | ETF | 111.6 | 111.7 | 111.6 | 111.7 | 600.0 |
| 2015-12-14 05:00:00 | QQQ | ETF | 111.51 | 111.51 | 111.48 | 111.48 | 300.0 |
| 2015-12-14 05:30:00 | QQQ | ETF | 111.52 | 111.53 | 111.52 | 111.53 | 2000.0 |
| 2015-12-14 06:00:00 | QQQ | ETF | 111.55 | 111.55 | 111.04 | 111.04 | 4400.0 |
| 2015-12-14 06:30:00 | QQQ | ETF | 110.95 | 110.98 | 110.71 | 110.91 | 3100.0 |
| 2015-12-14 07:00:00 | QQQ | ETF | 111.03 | 111.03 | 110.39 | 110.57 | 110789.0 |
| 2015-12-14 07:30:00 | QQQ | ETF | 110.53 | 110.67 | 110.48 | 110.63 | 53173.0 |
| 2015-12-14 08:00:00 | QQQ | ETF | 110.64 | 110.75 | 110.4 | 110.6 | 40922.0 |
| 2015-12-14 08:30:00 | QQQ | ETF | 110.58 | 111.08 | 110.56 | 110.93 | 161678.0 |
| 2015-12-14 09:00:00 | QQQ | ETF | 110.95 | 111.09 | 110.86 | 110.96 | 231626.0 |
| 2015-12-14 09:30:00 | QQQ | ETF | 110.98 | 111.2 | 110.53 | 110.62 | 7066916.0 |
| 2015-12-14 10:00:00 | QQQ | ETF | 110.63 | 111.28 | 110.09 | 110.16 | 10473544.0 |
| 2015-12-14 10:30:00 | QQQ | ETF | 110.155 | 110.77 | 110.115 | 110.48 | 4063371.0 |
| 2015-12-14 11:00:00 | QQQ | ETF | 110.47 | 110.52 | 109.87 | 109.905 | 2987380.0 |
| 2015-12-14 11:30:00 | QQQ | ETF | 109.9 | 110.14 | 109.38 | 110.1125 | 3086509.0 |
| 2015-12-14 12:00:00 | QQQ | ETF | 110.12 | 110.6826 | 109.9807 | 110.67 | 2642837.0 |
> showing 50 of 13,553 rows — these rows as CSV