PREVIEW / etf_5min / 2018-02-08
file: by_date/etf_5min/2018/2018-02-08.parquet size: 1.6 MB rows: 68,548
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-02-08 04:00:00 | SPY | ETF | 266.89 | 267.12 | 266.72 | 266.92 | 6770.0 |
| 2018-02-08 04:05:00 | SPY | ETF | 266.93 | 267.29 | 266.93 | 267.18 | 7790.0 |
| 2018-02-08 04:10:00 | SPY | ETF | 267.24 | 267.5 | 267.19 | 267.19 | 11184.0 |
| 2018-02-08 04:15:00 | SPY | ETF | 267.24 | 267.4 | 267.24 | 267.4 | 2125.0 |
| 2018-02-08 04:20:00 | SPY | ETF | 267.39 | 267.4 | 267.32 | 267.39 | 850.0 |
| 2018-02-08 04:25:00 | SPY | ETF | 267.43 | 267.44 | 267.17 | 267.17 | 3214.0 |
| 2018-02-08 04:30:00 | SPY | ETF | 267.39 | 267.41 | 266.92 | 266.92 | 31795.0 |
| 2018-02-08 04:35:00 | SPY | ETF | 266.89 | 267.29 | 266.89 | 267.24 | 4851.0 |
| 2018-02-08 04:40:00 | SPY | ETF | 267.29 | 267.29 | 266.86 | 267.04 | 3405.0 |
| 2018-02-08 04:45:00 | SPY | ETF | 266.92 | 267.21 | 266.88 | 267.1 | 2200.0 |
| 2018-02-08 04:50:00 | SPY | ETF | 267.05 | 267.05 | 266.95 | 266.96 | 9300.0 |
| 2018-02-08 04:55:00 | SPY | ETF | 266.96 | 267.08 | 266.9 | 267.08 | 1600.0 |
| 2018-02-08 05:00:00 | SPY | ETF | 266.92 | 266.92 | 266.4 | 266.46 | 41789.0 |
| 2018-02-08 05:05:00 | SPY | ETF | 266.48 | 266.49 | 266.02 | 266.02 | 15919.0 |
| 2018-02-08 05:10:00 | SPY | ETF | 266.29 | 266.38 | 266.24 | 266.38 | 1250.0 |
| 2018-02-08 05:15:00 | SPY | ETF | 266.47 | 266.47 | 266.22 | 266.22 | 900.0 |
| 2018-02-08 05:20:00 | SPY | ETF | 266.24 | 266.45 | 266.24 | 266.45 | 800.0 |
| 2018-02-08 05:25:00 | SPY | ETF | 266.41 | 266.75 | 266.41 | 266.66 | 7600.0 |
| 2018-02-08 05:30:00 | SPY | ETF | 266.7 | 266.7 | 266.51 | 266.61 | 11550.0 |
| 2018-02-08 05:35:00 | SPY | ETF | 266.77 | 266.77 | 266.52 | 266.63 | 5000.0 |
| 2018-02-08 05:40:00 | SPY | ETF | 266.5 | 266.52 | 266.5 | 266.52 | 3120.0 |
| 2018-02-08 05:45:00 | SPY | ETF | 266.55 | 266.55 | 266.21 | 266.21 | 10026.0 |
| 2018-02-08 05:50:00 | SPY | ETF | 266.4 | 266.4 | 266.06 | 266.06 | 2010.0 |
| 2018-02-08 05:55:00 | SPY | ETF | 266.15 | 266.2 | 266.02 | 266.02 | 12125.0 |
| 2018-02-08 06:00:00 | SPY | ETF | 266.0 | 266.0 | 265.8 | 265.91 | 5440.0 |
| 2018-02-08 06:05:00 | SPY | ETF | 266.0 | 266.2 | 265.69 | 265.81 | 9044.0 |
| 2018-02-08 06:10:00 | SPY | ETF | 266.0 | 266.0 | 265.94 | 265.94 | 625.0 |
| 2018-02-08 06:15:00 | SPY | ETF | 265.88 | 266.12 | 265.83 | 266.12 | 926.0 |
| 2018-02-08 06:20:00 | SPY | ETF | 266.1 | 266.23 | 266.05 | 266.09 | 9775.0 |
| 2018-02-08 06:25:00 | SPY | ETF | 266.1 | 266.38 | 266.1 | 266.29 | 7110.0 |
| 2018-02-08 06:30:00 | SPY | ETF | 266.34 | 266.39 | 266.27 | 266.27 | 8550.0 |
| 2018-02-08 06:35:00 | SPY | ETF | 266.01 | 266.01 | 265.96 | 265.96 | 1800.0 |
| 2018-02-08 06:40:00 | SPY | ETF | 265.96 | 265.96 | 265.55 | 265.62 | 7283.0 |
| 2018-02-08 06:45:00 | SPY | ETF | 265.64 | 266.07 | 265.64 | 266.07 | 4320.0 |
| 2018-02-08 06:50:00 | SPY | ETF | 265.89 | 266.03 | 265.83 | 266.0 | 58400.0 |
| 2018-02-08 06:55:00 | SPY | ETF | 265.82 | 265.92 | 265.82 | 265.92 | 1200.0 |
| 2018-02-08 07:00:00 | SPY | ETF | 265.85 | 266.5 | 265.85 | 266.16 | 52169.0 |
| 2018-02-08 07:05:00 | SPY | ETF | 266.22 | 266.22 | 266.07 | 266.14 | 36638.0 |
| 2018-02-08 07:10:00 | SPY | ETF | 266.15 | 266.22 | 265.88 | 266.21 | 172774.0 |
| 2018-02-08 07:15:00 | SPY | ETF | 266.29 | 266.57 | 266.29 | 266.53 | 125088.0 |
| 2018-02-08 07:20:00 | SPY | ETF | 266.5 | 266.88 | 266.47 | 266.5 | 74647.0 |
| 2018-02-08 07:25:00 | SPY | ETF | 266.57 | 266.8 | 266.49 | 266.75 | 115308.0 |
| 2018-02-08 07:30:00 | SPY | ETF | 266.66 | 266.97 | 266.55 | 266.97 | 100464.0 |
| 2018-02-08 07:35:00 | SPY | ETF | 266.97 | 266.98 | 266.62 | 266.69 | 44054.0 |
| 2018-02-08 07:40:00 | SPY | ETF | 266.79 | 267.08 | 266.66 | 267.06 | 45606.0 |
| 2018-02-08 07:45:00 | SPY | ETF | 267.0 | 267.19 | 266.95 | 267.15 | 67430.0 |
| 2018-02-08 07:50:00 | SPY | ETF | 267.15 | 267.25 | 266.95 | 266.99 | 95221.0 |
| 2018-02-08 07:55:00 | SPY | ETF | 267.02 | 267.13 | 266.89 | 267.04 | 23550.0 |
| 2018-02-08 08:00:00 | SPY | ETF | 267.04 | 267.64 | 265.89 | 267.15 | 195934.0 |
| 2018-02-08 08:05:00 | SPY | ETF | 267.1 | 267.32 | 267.02 | 267.02 | 47033.0 |
> showing 50 of 68,548 rows — these rows as CSV