PREVIEW / etf_5min / 2018-12-11
file: by_date/etf_5min/2018/2018-12-11.parquet size: 1.6 MB rows: 66,081
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-12-11 04:00:00 | SPY | ETF | 263.94 | 263.94 | 263.94 | 263.94 | 180.0 |
| 2018-12-11 04:05:00 | SPY | ETF | 263.84 | 263.99 | 263.84 | 263.94 | 4039.0 |
| 2018-12-11 04:10:00 | SPY | ETF | 263.96 | 264.0 | 263.96 | 264.0 | 1926.0 |
| 2018-12-11 04:15:00 | SPY | ETF | 264.0 | 264.15 | 264.0 | 264.15 | 2658.0 |
| 2018-12-11 04:20:00 | SPY | ETF | 264.18 | 264.19 | 264.1 | 264.1 | 576.0 |
| 2018-12-11 04:25:00 | SPY | ETF | 264.1 | 264.13 | 264.09 | 264.13 | 3338.0 |
| 2018-12-11 04:30:00 | SPY | ETF | 264.09 | 264.09 | 263.97 | 264.0 | 1521.0 |
| 2018-12-11 04:35:00 | SPY | ETF | 263.98 | 263.98 | 263.92 | 263.94 | 845.0 |
| 2018-12-11 04:40:00 | SPY | ETF | 263.92 | 264.2 | 263.82 | 264.2 | 4677.0 |
| 2018-12-11 04:45:00 | SPY | ETF | 264.18 | 264.34 | 264.18 | 264.34 | 2337.0 |
| 2018-12-11 04:50:00 | SPY | ETF | 264.36 | 264.43 | 264.36 | 264.43 | 1557.0 |
| 2018-12-11 04:55:00 | SPY | ETF | 264.44 | 264.5 | 264.42 | 264.5 | 4210.0 |
| 2018-12-11 05:00:00 | SPY | ETF | 264.56 | 264.88 | 264.56 | 264.88 | 2820.0 |
| 2018-12-11 05:05:00 | SPY | ETF | 264.89 | 265.2 | 264.89 | 265.2 | 5158.0 |
| 2018-12-11 05:10:00 | SPY | ETF | 265.16 | 265.35 | 265.16 | 265.3 | 4745.0 |
| 2018-12-11 05:15:00 | SPY | ETF | 265.26 | 265.4 | 265.21 | 265.38 | 1547.0 |
| 2018-12-11 05:20:00 | SPY | ETF | 265.42 | 265.42 | 265.25 | 265.36 | 11202.0 |
| 2018-12-11 05:25:00 | SPY | ETF | 265.33 | 265.5 | 265.33 | 265.36 | 8434.0 |
| 2018-12-11 05:30:00 | SPY | ETF | 265.32 | 265.4 | 265.32 | 265.35 | 5077.0 |
| 2018-12-11 05:35:00 | SPY | ETF | 265.4 | 265.52 | 265.4 | 265.52 | 6014.0 |
| 2018-12-11 05:40:00 | SPY | ETF | 265.44 | 265.45 | 265.36 | 265.37 | 5316.0 |
| 2018-12-11 05:45:00 | SPY | ETF | 265.4 | 265.57 | 265.4 | 265.57 | 4352.0 |
| 2018-12-11 05:50:00 | SPY | ETF | 265.58 | 265.7 | 265.58 | 265.7 | 8793.0 |
| 2018-12-11 05:55:00 | SPY | ETF | 265.7 | 265.77 | 265.63 | 265.63 | 6798.0 |
| 2018-12-11 06:00:00 | SPY | ETF | 265.62 | 265.84 | 265.6 | 265.84 | 707.0 |
| 2018-12-11 06:05:00 | SPY | ETF | 265.82 | 265.88 | 265.79 | 265.88 | 7504.0 |
| 2018-12-11 06:10:00 | SPY | ETF | 265.76 | 265.82 | 265.68 | 265.74 | 8339.0 |
| 2018-12-11 06:15:00 | SPY | ETF | 265.78 | 266.0 | 265.78 | 266.0 | 2059.0 |
| 2018-12-11 06:20:00 | SPY | ETF | 265.98 | 266.12 | 265.98 | 266.0 | 12890.0 |
| 2018-12-11 06:25:00 | SPY | ETF | 265.95 | 266.05 | 265.94 | 265.99 | 3868.0 |
| 2018-12-11 06:30:00 | SPY | ETF | 266.1 | 266.24 | 266.07 | 266.18 | 8224.0 |
| 2018-12-11 06:35:00 | SPY | ETF | 266.2 | 266.43 | 266.2 | 266.31 | 14723.0 |
| 2018-12-11 06:40:00 | SPY | ETF | 266.31 | 266.39 | 266.15 | 266.15 | 5607.0 |
| 2018-12-11 06:45:00 | SPY | ETF | 266.1 | 266.78 | 266.06 | 266.59 | 46207.0 |
| 2018-12-11 06:50:00 | SPY | ETF | 266.5 | 266.5 | 266.23 | 266.25 | 18529.0 |
| 2018-12-11 06:55:00 | SPY | ETF | 266.28 | 266.52 | 266.28 | 266.4 | 24217.0 |
| 2018-12-11 07:00:00 | SPY | ETF | 266.3 | 266.69 | 266.3 | 266.52 | 37385.0 |
| 2018-12-11 07:05:00 | SPY | ETF | 266.5 | 266.82 | 266.5 | 266.72 | 23396.0 |
| 2018-12-11 07:10:00 | SPY | ETF | 266.75 | 266.93 | 266.64 | 266.93 | 36789.0 |
| 2018-12-11 07:15:00 | SPY | ETF | 266.89 | 267.1 | 266.81 | 267.1 | 116525.0 |
| 2018-12-11 07:20:00 | SPY | ETF | 267.14 | 267.22 | 267.0 | 267.04 | 64666.0 |
| 2018-12-11 07:25:00 | SPY | ETF | 267.07 | 267.17 | 267.06 | 267.08 | 31604.0 |
| 2018-12-11 07:30:00 | SPY | ETF | 267.08 | 267.08 | 266.85 | 267.01 | 36111.0 |
| 2018-12-11 07:35:00 | SPY | ETF | 267.05 | 267.12 | 267.01 | 267.02 | 7434.0 |
| 2018-12-11 07:40:00 | SPY | ETF | 267.02 | 267.13 | 266.94 | 267.05 | 154349.0 |
| 2018-12-11 07:45:00 | SPY | ETF | 267.02 | 267.18 | 266.99 | 267.12 | 85547.0 |
| 2018-12-11 07:50:00 | SPY | ETF | 267.12 | 267.21 | 267.03 | 267.04 | 20790.0 |
| 2018-12-11 07:55:00 | SPY | ETF | 267.01 | 267.01 | 266.84 | 266.85 | 49953.0 |
| 2018-12-11 08:00:00 | SPY | ETF | 266.85 | 267.2 | 263.84 | 266.95 | 101219.0 |
| 2018-12-11 08:05:00 | SPY | ETF | 266.91 | 266.91 | 266.61 | 266.69 | 46718.0 |
> showing 50 of 66,081 rows — these rows as CSV