PREVIEW / etf_5min / 2018-10-29
file: by_date/etf_5min/2018/2018-10-29.parquet size: 1.5 MB rows: 65,573
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-29 04:00:00 | SPY | ETF | 266.32 | 266.32 | 266.3 | 266.3 | 8132.0 |
| 2018-10-29 04:05:00 | SPY | ETF | 266.43 | 266.57 | 266.29 | 266.57 | 8787.0 |
| 2018-10-29 04:10:00 | SPY | ETF | 266.52 | 266.52 | 266.43 | 266.45 | 1250.0 |
| 2018-10-29 04:15:00 | SPY | ETF | 266.4 | 266.4 | 266.2 | 266.25 | 5586.0 |
| 2018-10-29 04:20:00 | SPY | ETF | 266.24 | 266.34 | 266.11 | 266.11 | 4000.0 |
| 2018-10-29 04:25:00 | SPY | ETF | 266.1 | 266.1 | 265.89 | 265.94 | 18548.0 |
| 2018-10-29 04:30:00 | SPY | ETF | 265.85 | 266.01 | 265.85 | 265.98 | 1550.0 |
| 2018-10-29 04:35:00 | SPY | ETF | 265.83 | 266.09 | 265.83 | 266.09 | 600.0 |
| 2018-10-29 04:40:00 | SPY | ETF | 266.09 | 266.09 | 266.01 | 266.01 | 1115.0 |
| 2018-10-29 04:45:00 | SPY | ETF | 266.12 | 266.13 | 266.01 | 266.09 | 16000.0 |
| 2018-10-29 04:50:00 | SPY | ETF | 266.07 | 266.29 | 266.07 | 266.28 | 26600.0 |
| 2018-10-29 04:55:00 | SPY | ETF | 266.21 | 266.21 | 266.11 | 266.11 | 5108.0 |
| 2018-10-29 05:00:00 | SPY | ETF | 266.06 | 266.06 | 265.86 | 265.86 | 4831.0 |
| 2018-10-29 05:10:00 | SPY | ETF | 266.07 | 266.2 | 266.07 | 266.2 | 5750.0 |
| 2018-10-29 05:15:00 | SPY | ETF | 266.21 | 266.28 | 266.21 | 266.28 | 1515.0 |
| 2018-10-29 05:20:00 | SPY | ETF | 266.23 | 266.41 | 266.23 | 266.41 | 2850.0 |
| 2018-10-29 05:25:00 | SPY | ETF | 266.45 | 266.68 | 266.45 | 266.63 | 11900.0 |
| 2018-10-29 05:30:00 | SPY | ETF | 266.65 | 266.83 | 266.65 | 266.81 | 9175.0 |
| 2018-10-29 05:35:00 | SPY | ETF | 266.89 | 267.3 | 266.89 | 267.3 | 12495.0 |
| 2018-10-29 05:40:00 | SPY | ETF | 267.28 | 267.44 | 267.22 | 267.44 | 5265.0 |
| 2018-10-29 05:45:00 | SPY | ETF | 267.37 | 267.49 | 267.25 | 267.49 | 8550.0 |
| 2018-10-29 05:50:00 | SPY | ETF | 267.59 | 267.64 | 267.42 | 267.54 | 14339.0 |
| 2018-10-29 05:55:00 | SPY | ETF | 267.51 | 267.74 | 267.44 | 267.66 | 4710.0 |
| 2018-10-29 06:00:00 | SPY | ETF | 267.62 | 267.69 | 267.5 | 267.65 | 19800.0 |
| 2018-10-29 06:05:00 | SPY | ETF | 267.69 | 267.92 | 267.69 | 267.76 | 19010.0 |
| 2018-10-29 06:10:00 | SPY | ETF | 267.81 | 267.81 | 267.57 | 267.57 | 17510.0 |
| 2018-10-29 06:15:00 | SPY | ETF | 267.64 | 267.69 | 267.64 | 267.67 | 1700.0 |
| 2018-10-29 06:20:00 | SPY | ETF | 267.7 | 267.7 | 267.66 | 267.67 | 600.0 |
| 2018-10-29 06:25:00 | SPY | ETF | 267.76 | 267.96 | 267.76 | 267.89 | 17782.0 |
| 2018-10-29 06:30:00 | SPY | ETF | 267.81 | 268.25 | 267.76 | 268.25 | 42017.0 |
| 2018-10-29 06:35:00 | SPY | ETF | 268.26 | 268.43 | 268.17 | 268.31 | 29260.0 |
| 2018-10-29 06:40:00 | SPY | ETF | 268.34 | 268.36 | 268.21 | 268.21 | 9870.0 |
| 2018-10-29 06:45:00 | SPY | ETF | 268.24 | 268.41 | 268.18 | 268.41 | 47350.0 |
| 2018-10-29 06:50:00 | SPY | ETF | 268.45 | 268.59 | 268.35 | 268.59 | 19233.0 |
| 2018-10-29 06:55:00 | SPY | ETF | 268.6 | 268.84 | 268.51 | 268.63 | 52418.0 |
| 2018-10-29 07:00:00 | SPY | ETF | 268.63 | 268.75 | 268.54 | 268.75 | 54058.0 |
| 2018-10-29 07:05:00 | SPY | ETF | 268.67 | 268.83 | 268.63 | 268.83 | 19665.0 |
| 2018-10-29 07:10:00 | SPY | ETF | 268.78 | 268.93 | 268.71 | 268.89 | 48982.0 |
| 2018-10-29 07:15:00 | SPY | ETF | 268.83 | 269.12 | 268.81 | 269.04 | 36177.0 |
| 2018-10-29 07:20:00 | SPY | ETF | 269.1 | 269.41 | 269.04 | 269.36 | 58715.0 |
| 2018-10-29 07:25:00 | SPY | ETF | 269.38 | 269.66 | 269.34 | 269.55 | 41455.0 |
| 2018-10-29 07:30:00 | SPY | ETF | 269.55 | 269.56 | 269.25 | 269.25 | 69002.0 |
| 2018-10-29 07:35:00 | SPY | ETF | 269.25 | 269.25 | 269.12 | 269.14 | 27186.0 |
| 2018-10-29 07:40:00 | SPY | ETF | 269.12 | 269.16 | 268.89 | 268.89 | 43762.0 |
| 2018-10-29 07:45:00 | SPY | ETF | 268.875 | 269.08 | 268.75 | 269.08 | 45304.0 |
| 2018-10-29 07:50:00 | SPY | ETF | 269.07 | 269.12 | 268.96 | 269.0 | 20411.0 |
| 2018-10-29 07:55:00 | SPY | ETF | 268.99 | 268.99 | 268.66 | 268.75 | 57439.0 |
| 2018-10-29 08:00:00 | SPY | ETF | 268.75 | 269.61 | 268.59 | 268.9 | 102304.0 |
| 2018-10-29 08:05:00 | SPY | ETF | 268.92 | 268.95 | 268.83 | 268.9 | 19498.0 |
| 2018-10-29 08:10:00 | SPY | ETF | 268.95 | 269.25 | 268.95 | 269.11 | 45557.0 |
> showing 50 of 65,573 rows — these rows as CSV