PREVIEW / etf_1min / 2016-06-24
file: by_date/etf_1min/2016/2016-06-24.parquet size: 3.6 MB rows: 186,331
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-24 04:00:00 | SPY | ETF | 204.6 | 204.74 | 204.03 | 204.34 | 16298.0 |
| 2016-06-24 04:01:00 | SPY | ETF | 204.36 | 204.36 | 204.08 | 204.08 | 4901.0 |
| 2016-06-24 04:02:00 | SPY | ETF | 204.4 | 204.5 | 204.15 | 204.5 | 1481.0 |
| 2016-06-24 04:03:00 | SPY | ETF | 204.42 | 204.5 | 204.35 | 204.37 | 6310.0 |
| 2016-06-24 04:04:00 | SPY | ETF | 204.34 | 204.37 | 204.17 | 204.17 | 19998.0 |
| 2016-06-24 04:05:00 | SPY | ETF | 204.11 | 204.28 | 204.11 | 204.28 | 6161.0 |
| 2016-06-24 04:06:00 | SPY | ETF | 204.25 | 204.36 | 204.17 | 204.17 | 10116.0 |
| 2016-06-24 04:07:00 | SPY | ETF | 204.17 | 204.17 | 204.02 | 204.16 | 7650.0 |
| 2016-06-24 04:08:00 | SPY | ETF | 204.03 | 204.03 | 203.87 | 204.01 | 8619.0 |
| 2016-06-24 04:09:00 | SPY | ETF | 203.9 | 203.93 | 203.7 | 203.88 | 8918.0 |
| 2016-06-24 04:10:00 | SPY | ETF | 203.98 | 204.0 | 203.81 | 203.82 | 9890.0 |
| 2016-06-24 04:11:00 | SPY | ETF | 203.67 | 204.01 | 203.67 | 204.01 | 1325.0 |
| 2016-06-24 04:12:00 | SPY | ETF | 203.9 | 204.19 | 203.9 | 204.14 | 26159.0 |
| 2016-06-24 04:13:00 | SPY | ETF | 203.9 | 204.05 | 203.9 | 204.05 | 380.0 |
| 2016-06-24 04:14:00 | SPY | ETF | 203.98 | 204.08 | 203.98 | 204.08 | 400.0 |
| 2016-06-24 04:15:00 | SPY | ETF | 204.15 | 204.21 | 204.15 | 204.21 | 3654.0 |
| 2016-06-24 04:16:00 | SPY | ETF | 204.19 | 204.19 | 203.93 | 203.93 | 3885.0 |
| 2016-06-24 04:17:00 | SPY | ETF | 203.95 | 204.15 | 203.91 | 204.05 | 2047.0 |
| 2016-06-24 04:18:00 | SPY | ETF | 204.14 | 204.28 | 204.14 | 204.28 | 5430.0 |
| 2016-06-24 04:19:00 | SPY | ETF | 204.28 | 204.51 | 204.28 | 204.51 | 5980.0 |
| 2016-06-24 04:20:00 | SPY | ETF | 204.43 | 204.46 | 204.29 | 204.29 | 1360.0 |
| 2016-06-24 04:21:00 | SPY | ETF | 204.44 | 204.44 | 204.12 | 204.31 | 4164.0 |
| 2016-06-24 04:22:00 | SPY | ETF | 204.37 | 204.37 | 204.17 | 204.34 | 1241.0 |
| 2016-06-24 04:23:00 | SPY | ETF | 204.26 | 204.28 | 204.14 | 204.14 | 1600.0 |
| 2016-06-24 04:24:00 | SPY | ETF | 204.27 | 204.34 | 204.27 | 204.3 | 6980.0 |
| 2016-06-24 04:25:00 | SPY | ETF | 204.46 | 204.59 | 204.46 | 204.59 | 1012.0 |
| 2016-06-24 04:26:00 | SPY | ETF | 204.63 | 204.7 | 204.56 | 204.59 | 1030.0 |
| 2016-06-24 04:27:00 | SPY | ETF | 204.63 | 204.75 | 204.59 | 204.59 | 9651.0 |
| 2016-06-24 04:28:00 | SPY | ETF | 204.7 | 204.7 | 204.6 | 204.65 | 2930.0 |
| 2016-06-24 04:29:00 | SPY | ETF | 204.7 | 204.79 | 204.6 | 204.6 | 5522.0 |
| 2016-06-24 04:30:00 | SPY | ETF | 204.55 | 204.55 | 204.29 | 204.29 | 3518.0 |
| 2016-06-24 04:31:00 | SPY | ETF | 204.26 | 204.45 | 204.21 | 204.45 | 16260.0 |
| 2016-06-24 04:32:00 | SPY | ETF | 204.34 | 204.34 | 204.21 | 204.21 | 600.0 |
| 2016-06-24 04:33:00 | SPY | ETF | 204.16 | 204.16 | 204.1 | 204.1 | 1400.0 |
| 2016-06-24 04:34:00 | SPY | ETF | 204.09 | 204.26 | 204.06 | 204.08 | 9610.0 |
| 2016-06-24 04:35:00 | SPY | ETF | 204.21 | 204.47 | 204.2 | 204.47 | 10125.0 |
| 2016-06-24 04:36:00 | SPY | ETF | 204.21 | 204.4 | 204.12 | 204.12 | 13340.0 |
| 2016-06-24 04:37:00 | SPY | ETF | 204.39 | 204.39 | 204.39 | 204.39 | 1220.0 |
| 2016-06-24 04:38:00 | SPY | ETF | 204.43 | 204.43 | 204.14 | 204.14 | 8005.0 |
| 2016-06-24 04:39:00 | SPY | ETF | 204.31 | 204.31 | 204.17 | 204.25 | 9700.0 |
| 2016-06-24 04:40:00 | SPY | ETF | 204.24 | 204.25 | 204.21 | 204.24 | 1825.0 |
| 2016-06-24 04:41:00 | SPY | ETF | 204.14 | 204.3 | 204.14 | 204.3 | 8330.0 |
| 2016-06-24 04:43:00 | SPY | ETF | 204.26 | 204.26 | 204.09 | 204.09 | 9550.0 |
| 2016-06-24 04:44:00 | SPY | ETF | 204.16 | 204.16 | 204.16 | 204.16 | 480.0 |
| 2016-06-24 04:45:00 | SPY | ETF | 204.24 | 204.25 | 204.2 | 204.25 | 2040.0 |
| 2016-06-24 04:46:00 | SPY | ETF | 204.2 | 204.37 | 204.2 | 204.37 | 6900.0 |
| 2016-06-24 04:47:00 | SPY | ETF | 204.28 | 204.38 | 204.28 | 204.37 | 2600.0 |
| 2016-06-24 04:48:00 | SPY | ETF | 204.37 | 204.37 | 204.19 | 204.21 | 4800.0 |
| 2016-06-24 04:49:00 | SPY | ETF | 204.25 | 204.29 | 204.17 | 204.17 | 3600.0 |
| 2016-06-24 04:50:00 | SPY | ETF | 204.17 | 204.3 | 204.15 | 204.15 | 1060.0 |
> showing 50 of 186,331 rows — these rows as CSV