PREVIEW / etf_5min / 2018-10-10
file: by_date/etf_5min/2018/2018-10-10.parquet size: 1.6 MB rows: 67,944
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-10 04:05:00 | SPY | ETF | 287.45 | 287.45 | 287.32 | 287.32 | 308.0 |
| 2018-10-10 04:10:00 | SPY | ETF | 287.25 | 287.25 | 287.25 | 287.25 | 200.0 |
| 2018-10-10 04:25:00 | SPY | ETF | 287.21 | 287.21 | 287.21 | 287.21 | 100.0 |
| 2018-10-10 04:30:00 | SPY | ETF | 287.27 | 287.27 | 287.27 | 287.27 | 100.0 |
| 2018-10-10 04:35:00 | SPY | ETF | 287.27 | 287.27 | 287.27 | 287.27 | 115.0 |
| 2018-10-10 04:40:00 | SPY | ETF | 287.47 | 287.54 | 287.47 | 287.51 | 1200.0 |
| 2018-10-10 04:45:00 | SPY | ETF | 287.39 | 287.39 | 287.39 | 287.39 | 1500.0 |
| 2018-10-10 04:50:00 | SPY | ETF | 287.34 | 287.34 | 287.34 | 287.34 | 100.0 |
| 2018-10-10 04:55:00 | SPY | ETF | 287.36 | 287.39 | 287.31 | 287.31 | 1396.0 |
| 2018-10-10 05:00:00 | SPY | ETF | 287.26 | 287.27 | 287.24 | 287.24 | 1500.0 |
| 2018-10-10 05:20:00 | SPY | ETF | 287.34 | 287.39 | 287.34 | 287.39 | 400.0 |
| 2018-10-10 05:25:00 | SPY | ETF | 287.38 | 287.39 | 287.38 | 287.39 | 1200.0 |
| 2018-10-10 05:30:00 | SPY | ETF | 287.44 | 287.49 | 287.42 | 287.42 | 700.0 |
| 2018-10-10 05:35:00 | SPY | ETF | 287.42 | 287.46 | 287.41 | 287.46 | 1000.0 |
| 2018-10-10 05:40:00 | SPY | ETF | 287.46 | 287.46 | 287.46 | 287.46 | 1100.0 |
| 2018-10-10 05:45:00 | SPY | ETF | 287.41 | 287.41 | 287.41 | 287.41 | 300.0 |
| 2018-10-10 05:50:00 | SPY | ETF | 287.29 | 287.29 | 287.29 | 287.29 | 1055.0 |
| 2018-10-10 05:55:00 | SPY | ETF | 287.26 | 287.29 | 287.23 | 287.26 | 4585.0 |
| 2018-10-10 06:00:00 | SPY | ETF | 287.34 | 287.34 | 287.34 | 287.34 | 800.0 |
| 2018-10-10 06:05:00 | SPY | ETF | 287.39 | 287.39 | 287.37 | 287.39 | 2100.0 |
| 2018-10-10 06:10:00 | SPY | ETF | 287.36 | 287.36 | 287.35 | 287.36 | 1425.0 |
| 2018-10-10 06:15:00 | SPY | ETF | 287.49 | 287.51 | 287.49 | 287.51 | 1125.0 |
| 2018-10-10 06:25:00 | SPY | ETF | 287.48 | 287.48 | 287.48 | 287.48 | 400.0 |
| 2018-10-10 06:35:00 | SPY | ETF | 287.59 | 287.62 | 287.59 | 287.62 | 300.0 |
| 2018-10-10 06:40:00 | SPY | ETF | 287.67 | 287.67 | 287.63 | 287.63 | 4600.0 |
| 2018-10-10 06:45:00 | SPY | ETF | 287.72 | 287.74 | 287.68 | 287.68 | 10500.0 |
| 2018-10-10 06:50:00 | SPY | ETF | 287.66 | 287.66 | 287.63 | 287.63 | 200.0 |
| 2018-10-10 07:00:00 | SPY | ETF | 287.59 | 287.59 | 287.56 | 287.56 | 2682.0 |
| 2018-10-10 07:05:00 | SPY | ETF | 287.58 | 287.63 | 287.58 | 287.63 | 815.0 |
| 2018-10-10 07:10:00 | SPY | ETF | 287.61 | 287.69 | 287.61 | 287.67 | 28210.0 |
| 2018-10-10 07:15:00 | SPY | ETF | 287.68 | 287.78 | 287.68 | 287.78 | 16411.0 |
| 2018-10-10 07:20:00 | SPY | ETF | 287.79 | 287.8 | 287.79 | 287.79 | 1599.0 |
| 2018-10-10 07:25:00 | SPY | ETF | 287.78 | 287.8 | 287.77 | 287.79 | 5797.0 |
| 2018-10-10 07:30:00 | SPY | ETF | 287.76 | 287.76 | 287.58 | 287.61 | 59147.0 |
| 2018-10-10 07:35:00 | SPY | ETF | 287.56 | 287.56 | 287.51 | 287.55 | 5000.0 |
| 2018-10-10 07:40:00 | SPY | ETF | 287.52 | 287.53 | 287.46 | 287.47 | 8211.0 |
| 2018-10-10 07:45:00 | SPY | ETF | 287.47 | 287.47 | 287.35 | 287.41 | 12750.0 |
| 2018-10-10 07:50:00 | SPY | ETF | 287.31 | 287.31 | 287.12 | 287.18 | 26033.0 |
| 2018-10-10 07:55:00 | SPY | ETF | 287.18 | 287.28 | 287.16 | 287.16 | 11769.0 |
| 2018-10-10 08:00:00 | SPY | ETF | 287.4 | 287.83 | 287.1 | 287.17 | 48152.0 |
| 2018-10-10 08:05:00 | SPY | ETF | 287.15 | 288.01 | 287.1 | 287.12 | 38867.0 |
| 2018-10-10 08:10:00 | SPY | ETF | 287.1 | 287.17 | 287.09 | 287.1 | 73694.0 |
| 2018-10-10 08:15:00 | SPY | ETF | 287.11 | 287.11 | 287.03 | 287.1 | 34891.0 |
| 2018-10-10 08:20:00 | SPY | ETF | 287.05 | 287.17 | 286.93 | 286.95 | 58985.0 |
| 2018-10-10 08:25:00 | SPY | ETF | 286.95 | 286.97 | 286.69 | 286.82 | 154044.0 |
| 2018-10-10 08:30:00 | SPY | ETF | 286.84 | 286.9 | 286.44 | 286.5 | 208633.0 |
| 2018-10-10 08:35:00 | SPY | ETF | 286.5 | 286.64 | 286.46 | 286.62 | 69392.0 |
| 2018-10-10 08:40:00 | SPY | ETF | 286.65 | 286.65 | 286.51 | 286.63 | 31844.0 |
| 2018-10-10 08:45:00 | SPY | ETF | 286.61 | 286.73 | 286.56 | 286.65 | 61325.0 |
| 2018-10-10 08:50:00 | SPY | ETF | 286.64 | 286.65 | 286.47 | 286.53 | 98348.0 |
> showing 50 of 67,944 rows — these rows as CSV