PREVIEW / etf_30min / 2015-11-16
file: by_date/etf_30min/2015/2015-11-16.parquet size: 388 KB rows: 12,918
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-11-16 04:00:00 | SPY | ETF | 202.55 | 203.16 | 202.45 | 202.91 | 114500.0 |
| 2015-11-16 04:30:00 | SPY | ETF | 202.93 | 202.95 | 202.66 | 202.94 | 181977.0 |
| 2015-11-16 05:00:00 | SPY | ETF | 202.9 | 203.3 | 202.85 | 203.15 | 48377.0 |
| 2015-11-16 05:30:00 | SPY | ETF | 202.9 | 202.98 | 202.82 | 202.82 | 21479.0 |
| 2015-11-16 06:00:00 | SPY | ETF | 202.83 | 202.97 | 202.69 | 202.81 | 63223.0 |
| 2015-11-16 06:30:00 | SPY | ETF | 202.85 | 203.23 | 202.77 | 203.14 | 133122.0 |
| 2015-11-16 07:00:00 | SPY | ETF | 203.11 | 203.3 | 203.06 | 203.1 | 366096.0 |
| 2015-11-16 07:30:00 | SPY | ETF | 203.15 | 203.15 | 202.92 | 202.97 | 258825.0 |
| 2015-11-16 08:00:00 | SPY | ETF | 203.2 | 203.21 | 202.76 | 202.76 | 884518.0 |
| 2015-11-16 08:30:00 | SPY | ETF | 202.76 | 202.94 | 202.34 | 202.36 | 678260.0 |
| 2015-11-16 09:00:00 | SPY | ETF | 202.36 | 202.44 | 202.04 | 202.3 | 1960797.0 |
| 2015-11-16 09:30:00 | SPY | ETF | 202.32 | 203.76 | 202.18 | 203.15 | 18416923.0 |
| 2015-11-16 10:00:00 | SPY | ETF | 203.15 | 203.7 | 202.89 | 203.32 | 9885837.0 |
| 2015-11-16 10:30:00 | SPY | ETF | 203.32 | 203.46 | 202.8 | 202.865 | 5822453.0 |
| 2015-11-16 11:00:00 | SPY | ETF | 202.85 | 203.23 | 202.66 | 202.7 | 5612330.0 |
| 2015-11-16 11:30:00 | SPY | ETF | 202.7 | 203.42 | 202.7 | 203.23 | 4670895.0 |
| 2015-11-16 12:00:00 | SPY | ETF | 203.24 | 203.65 | 203.14 | 203.575 | 3878577.0 |
| 2015-11-16 12:30:00 | SPY | ETF | 203.58 | 204.0 | 203.57 | 203.78 | 5219512.0 |
| 2015-11-16 13:00:00 | SPY | ETF | 203.79 | 204.44 | 203.7 | 204.18 | 5700881.0 |
| 2015-11-16 13:30:00 | SPY | ETF | 204.18 | 204.48 | 204.1 | 204.47 | 3522094.0 |
| 2015-11-16 14:00:00 | SPY | ETF | 204.48 | 204.66 | 204.37 | 204.6 | 5021978.0 |
| 2015-11-16 14:30:00 | SPY | ETF | 204.6 | 204.95 | 204.575 | 204.8 | 7373551.0 |
| 2015-11-16 15:00:00 | SPY | ETF | 204.8 | 205.54 | 204.795 | 205.36 | 10341450.0 |
| 2015-11-16 15:30:00 | SPY | ETF | 205.37 | 205.64 | 205.22 | 205.6 | 13272236.0 |
| 2015-11-16 16:00:00 | SPY | ETF | 205.61 | 205.79 | 203.0728 | 205.5 | 8338611.0 |
| 2015-11-16 16:30:00 | SPY | ETF | 205.51 | 205.71 | 205.5 | 205.58 | 809084.0 |
| 2015-11-16 17:00:00 | SPY | ETF | 205.63 | 205.65 | 205.57 | 205.6 | 577760.0 |
| 2015-11-16 17:30:00 | SPY | ETF | 205.58 | 205.6 | 205.53 | 205.53 | 31902.0 |
| 2015-11-16 18:00:00 | SPY | ETF | 205.51 | 205.51 | 205.27 | 205.38 | 216846.0 |
| 2015-11-16 18:30:00 | SPY | ETF | 205.38 | 205.65 | 205.33 | 205.43 | 18117.0 |
| 2015-11-16 19:00:00 | SPY | ETF | 205.41 | 205.45 | 205.34 | 205.43 | 42579.0 |
| 2015-11-16 19:30:00 | SPY | ETF | 205.43 | 205.47 | 205.36 | 205.41 | 19233.0 |
| 2015-11-16 04:00:00 | QQQ | ETF | 109.99 | 110.22 | 109.89 | 110.19 | 4515.0 |
| 2015-11-16 05:00:00 | QQQ | ETF | 110.13 | 110.16 | 110.13 | 110.15 | 400.0 |
| 2015-11-16 05:30:00 | QQQ | ETF | 110.13 | 110.13 | 110.1 | 110.1 | 20815.0 |
| 2015-11-16 06:00:00 | QQQ | ETF | 110.07 | 110.14 | 110.0 | 110.11 | 2000.0 |
| 2015-11-16 06:30:00 | QQQ | ETF | 110.07 | 110.2 | 110.04 | 110.2 | 12907.0 |
| 2015-11-16 07:00:00 | QQQ | ETF | 110.11 | 110.19 | 110.1 | 110.11 | 22780.0 |
| 2015-11-16 07:30:00 | QQQ | ETF | 110.08 | 110.09 | 110.0 | 110.0 | 14543.0 |
| 2015-11-16 08:00:00 | QQQ | ETF | 110.17 | 110.18 | 109.89 | 109.89 | 80347.0 |
| 2015-11-16 08:30:00 | QQQ | ETF | 109.85 | 109.85 | 109.67 | 109.71 | 160583.0 |
| 2015-11-16 09:00:00 | QQQ | ETF | 109.72 | 109.75 | 109.53 | 109.71 | 238485.0 |
| 2015-11-16 09:30:00 | QQQ | ETF | 109.71 | 110.35 | 109.48 | 110.02 | 4936741.0 |
| 2015-11-16 10:00:00 | QQQ | ETF | 110.01 | 110.45 | 109.84 | 110.19 | 2865710.0 |
| 2015-11-16 10:30:00 | QQQ | ETF | 110.17 | 110.21 | 109.79 | 109.83 | 1592192.0 |
| 2015-11-16 11:00:00 | QQQ | ETF | 109.82 | 109.98 | 109.6 | 109.64 | 1551405.0 |
| 2015-11-16 11:30:00 | QQQ | ETF | 109.6499 | 110.01 | 109.6499 | 109.91 | 1101794.0 |
| 2015-11-16 12:00:00 | QQQ | ETF | 109.92 | 110.165 | 109.8676 | 110.1227 | 1070625.0 |
| 2015-11-16 12:30:00 | QQQ | ETF | 110.13 | 110.4 | 110.13 | 110.33 | 1980668.0 |
| 2015-11-16 13:00:00 | QQQ | ETF | 110.33 | 110.779 | 110.27 | 110.5903 | 1942598.0 |
> showing 50 of 12,918 rows — these rows as CSV