PREVIEW / etf_5min / 2014-10-30
file: by_date/etf_5min/2014/2014-10-30.parquet size: 973 KB rows: 39,754
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-30 04:00:00 | SPY | ETF | 198.41 | 198.47 | 198.41 | 198.47 | 262.0 |
| 2014-10-30 04:05:00 | SPY | ETF | 198.52 | 198.52 | 198.46 | 198.46 | 800.0 |
| 2014-10-30 04:15:00 | SPY | ETF | 198.4 | 198.4 | 198.4 | 198.4 | 700.0 |
| 2014-10-30 04:20:00 | SPY | ETF | 198.37 | 198.4 | 198.37 | 198.4 | 7050.0 |
| 2014-10-30 04:25:00 | SPY | ETF | 198.37 | 198.42 | 198.37 | 198.42 | 500.0 |
| 2014-10-30 04:30:00 | SPY | ETF | 198.45 | 198.46 | 198.4 | 198.4 | 350.0 |
| 2014-10-30 04:35:00 | SPY | ETF | 198.26 | 198.26 | 198.26 | 198.26 | 5030.0 |
| 2014-10-30 04:40:00 | SPY | ETF | 198.17 | 198.19 | 198.15 | 198.16 | 10000.0 |
| 2014-10-30 04:45:00 | SPY | ETF | 198.16 | 198.16 | 198.16 | 198.16 | 350.0 |
| 2014-10-30 04:50:00 | SPY | ETF | 198.1 | 198.1 | 198.1 | 198.1 | 1000.0 |
| 2014-10-30 04:55:00 | SPY | ETF | 198.19 | 198.19 | 198.16 | 198.16 | 8600.0 |
| 2014-10-30 05:00:00 | SPY | ETF | 198.03 | 198.06 | 198.03 | 198.06 | 429.0 |
| 2014-10-30 05:05:00 | SPY | ETF | 198.04 | 198.04 | 197.86 | 197.87 | 6700.0 |
| 2014-10-30 05:10:00 | SPY | ETF | 197.86 | 197.91 | 197.82 | 197.84 | 3802.0 |
| 2014-10-30 05:15:00 | SPY | ETF | 197.71 | 197.74 | 197.59 | 197.64 | 18776.0 |
| 2014-10-30 05:20:00 | SPY | ETF | 197.51 | 197.54 | 197.34 | 197.54 | 20478.0 |
| 2014-10-30 05:25:00 | SPY | ETF | 197.5 | 197.62 | 197.5 | 197.59 | 2052.0 |
| 2014-10-30 05:30:00 | SPY | ETF | 197.55 | 197.55 | 197.39 | 197.39 | 6255.0 |
| 2014-10-30 05:35:00 | SPY | ETF | 197.39 | 197.51 | 197.39 | 197.51 | 4500.0 |
| 2014-10-30 05:40:00 | SPY | ETF | 197.52 | 197.52 | 197.36 | 197.36 | 9672.0 |
| 2014-10-30 05:45:00 | SPY | ETF | 197.34 | 197.34 | 197.02 | 197.06 | 3990.0 |
| 2014-10-30 05:50:00 | SPY | ETF | 197.06 | 197.21 | 197.06 | 197.19 | 18022.0 |
| 2014-10-30 05:55:00 | SPY | ETF | 197.12 | 197.26 | 197.09 | 197.2 | 9600.0 |
| 2014-10-30 06:00:00 | SPY | ETF | 197.32 | 197.35 | 197.27 | 197.27 | 9100.0 |
| 2014-10-30 06:05:00 | SPY | ETF | 197.4 | 197.4 | 197.27 | 197.3 | 3295.0 |
| 2014-10-30 06:10:00 | SPY | ETF | 197.29 | 197.29 | 197.2 | 197.29 | 3445.0 |
| 2014-10-30 06:15:00 | SPY | ETF | 197.33 | 197.34 | 197.33 | 197.34 | 2268.0 |
| 2014-10-30 06:20:00 | SPY | ETF | 197.35 | 197.4 | 197.35 | 197.4 | 812.0 |
| 2014-10-30 06:25:00 | SPY | ETF | 197.35 | 197.35 | 197.23 | 197.23 | 1696.0 |
| 2014-10-30 06:30:00 | SPY | ETF | 197.22 | 197.27 | 197.22 | 197.27 | 23600.0 |
| 2014-10-30 06:35:00 | SPY | ETF | 197.27 | 197.34 | 197.27 | 197.31 | 32200.0 |
| 2014-10-30 06:40:00 | SPY | ETF | 197.28 | 197.28 | 196.94 | 196.99 | 34638.0 |
| 2014-10-30 06:45:00 | SPY | ETF | 196.96 | 196.97 | 196.74 | 196.75 | 102673.0 |
| 2014-10-30 06:50:00 | SPY | ETF | 196.83 | 196.96 | 196.78 | 196.94 | 18368.0 |
| 2014-10-30 06:55:00 | SPY | ETF | 196.9 | 196.96 | 196.9 | 196.96 | 19789.0 |
| 2014-10-30 07:00:00 | SPY | ETF | 196.92 | 196.92 | 196.81 | 196.88 | 29655.0 |
| 2014-10-30 07:05:00 | SPY | ETF | 196.91 | 197.03 | 196.91 | 197.03 | 13825.0 |
| 2014-10-30 07:10:00 | SPY | ETF | 197.01 | 197.04 | 196.94 | 196.95 | 26270.0 |
| 2014-10-30 07:15:00 | SPY | ETF | 196.93 | 196.93 | 196.8 | 196.81 | 65344.0 |
| 2014-10-30 07:20:00 | SPY | ETF | 196.81 | 196.92 | 196.71 | 196.79 | 140778.0 |
| 2014-10-30 07:25:00 | SPY | ETF | 196.79 | 196.84 | 196.75 | 196.75 | 15417.0 |
| 2014-10-30 07:30:00 | SPY | ETF | 196.74 | 196.74 | 196.52 | 196.54 | 217785.0 |
| 2014-10-30 07:35:00 | SPY | ETF | 196.54 | 196.74 | 196.52 | 196.66 | 182695.0 |
| 2014-10-30 07:40:00 | SPY | ETF | 196.66 | 196.75 | 196.63 | 196.74 | 102993.0 |
| 2014-10-30 07:45:00 | SPY | ETF | 196.74 | 196.74 | 196.67 | 196.72 | 33920.0 |
| 2014-10-30 07:50:00 | SPY | ETF | 196.71 | 196.76 | 196.64 | 196.73 | 48705.0 |
| 2014-10-30 07:55:00 | SPY | ETF | 196.78 | 196.94 | 196.76 | 196.93 | 179267.0 |
| 2014-10-30 08:00:00 | SPY | ETF | 196.93 | 198.59 | 196.58 | 198.59 | 236355.0 |
| 2014-10-30 08:05:00 | SPY | ETF | 196.95 | 197.02 | 196.89 | 197.0 | 105072.0 |
| 2014-10-30 08:10:00 | SPY | ETF | 196.98 | 197.03 | 196.94 | 196.98 | 281835.0 |
> showing 50 of 39,754 rows — these rows as CSV