PREVIEW / etf_5min / 2018-12-21
file: by_date/etf_5min/2018/2018-12-21.parquet size: 1.8 MB rows: 75,539
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-21 04:00:00 | SPY | ETF | 246.31 | 246.31 | 245.9 | 245.92 | 4045.0 |
| 2018-12-21 04:05:00 | SPY | ETF | 245.99 | 246.16 | 245.99 | 246.16 | 13656.0 |
| 2018-12-21 04:10:00 | SPY | ETF | 246.15 | 246.49 | 246.15 | 246.41 | 21555.0 |
| 2018-12-21 04:15:00 | SPY | ETF | 246.38 | 246.38 | 246.15 | 246.22 | 7662.0 |
| 2018-12-21 04:20:00 | SPY | ETF | 246.05 | 246.05 | 245.84 | 245.89 | 4588.0 |
| 2018-12-21 04:25:00 | SPY | ETF | 245.83 | 246.19 | 245.81 | 246.19 | 3754.0 |
| 2018-12-21 04:30:00 | SPY | ETF | 246.14 | 246.24 | 246.13 | 246.13 | 3315.0 |
| 2018-12-21 04:35:00 | SPY | ETF | 245.97 | 246.25 | 245.97 | 246.13 | 935.0 |
| 2018-12-21 04:40:00 | SPY | ETF | 246.3 | 246.3 | 246.3 | 246.3 | 100.0 |
| 2018-12-21 04:45:00 | SPY | ETF | 246.24 | 246.29 | 246.21 | 246.29 | 869.0 |
| 2018-12-21 04:50:00 | SPY | ETF | 246.24 | 246.32 | 246.18 | 246.32 | 4376.0 |
| 2018-12-21 04:55:00 | SPY | ETF | 246.35 | 246.4 | 246.32 | 246.36 | 2369.0 |
| 2018-12-21 05:00:00 | SPY | ETF | 246.35 | 246.37 | 246.09 | 246.21 | 10554.0 |
| 2018-12-21 05:05:00 | SPY | ETF | 246.24 | 246.28 | 246.08 | 246.28 | 13287.0 |
| 2018-12-21 05:10:00 | SPY | ETF | 246.28 | 246.28 | 246.0 | 246.28 | 3304.0 |
| 2018-12-21 05:15:00 | SPY | ETF | 246.2 | 246.2 | 245.67 | 245.85 | 7429.0 |
| 2018-12-21 05:20:00 | SPY | ETF | 245.8 | 245.95 | 245.8 | 245.95 | 3127.0 |
| 2018-12-21 05:25:00 | SPY | ETF | 245.83 | 246.05 | 245.8 | 246.05 | 9445.0 |
| 2018-12-21 05:30:00 | SPY | ETF | 246.0 | 246.32 | 246.0 | 246.28 | 6140.0 |
| 2018-12-21 05:35:00 | SPY | ETF | 246.26 | 246.45 | 246.26 | 246.43 | 9130.0 |
| 2018-12-21 05:40:00 | SPY | ETF | 246.42 | 246.42 | 246.26 | 246.26 | 645.0 |
| 2018-12-21 05:45:00 | SPY | ETF | 246.35 | 246.4 | 246.25 | 246.4 | 4957.0 |
| 2018-12-21 05:50:00 | SPY | ETF | 246.42 | 246.61 | 246.41 | 246.52 | 11032.0 |
| 2018-12-21 05:55:00 | SPY | ETF | 246.58 | 246.61 | 246.58 | 246.6 | 3588.0 |
| 2018-12-21 06:00:00 | SPY | ETF | 246.55 | 246.7 | 246.55 | 246.7 | 8095.0 |
| 2018-12-21 06:05:00 | SPY | ETF | 246.69 | 246.8 | 246.43 | 246.61 | 7602.0 |
| 2018-12-21 06:10:00 | SPY | ETF | 246.7 | 246.72 | 246.55 | 246.7 | 1047.0 |
| 2018-12-21 06:15:00 | SPY | ETF | 246.69 | 246.73 | 246.69 | 246.73 | 5279.0 |
| 2018-12-21 06:20:00 | SPY | ETF | 246.67 | 246.7 | 246.65 | 246.65 | 1457.0 |
| 2018-12-21 06:25:00 | SPY | ETF | 246.62 | 246.63 | 246.6 | 246.63 | 20873.0 |
| 2018-12-21 06:30:00 | SPY | ETF | 246.6 | 246.77 | 246.6 | 246.7 | 9764.0 |
| 2018-12-21 06:35:00 | SPY | ETF | 246.7 | 246.75 | 246.65 | 246.66 | 2455.0 |
| 2018-12-21 06:40:00 | SPY | ETF | 246.7 | 247.06 | 246.7 | 247.06 | 5551.0 |
| 2018-12-21 06:45:00 | SPY | ETF | 246.93 | 247.06 | 246.85 | 246.85 | 9609.0 |
| 2018-12-21 06:50:00 | SPY | ETF | 246.84 | 246.88 | 246.65 | 246.65 | 4503.0 |
| 2018-12-21 06:55:00 | SPY | ETF | 246.72 | 246.9 | 246.7 | 246.7 | 4964.0 |
| 2018-12-21 07:00:00 | SPY | ETF | 246.71 | 246.75 | 246.4 | 246.6 | 17738.0 |
| 2018-12-21 07:05:00 | SPY | ETF | 246.55 | 246.88 | 246.53 | 246.81 | 15950.0 |
| 2018-12-21 07:10:00 | SPY | ETF | 246.81 | 246.9 | 246.7 | 246.72 | 6283.0 |
| 2018-12-21 07:15:00 | SPY | ETF | 246.79 | 246.9 | 246.77 | 246.85 | 18390.0 |
| 2018-12-21 07:20:00 | SPY | ETF | 246.8 | 246.8 | 246.43 | 246.43 | 34959.0 |
| 2018-12-21 07:25:00 | SPY | ETF | 246.38 | 246.44 | 246.19 | 246.36 | 69679.0 |
| 2018-12-21 07:30:00 | SPY | ETF | 246.35 | 246.54 | 246.31 | 246.4 | 89414.0 |
| 2018-12-21 07:35:00 | SPY | ETF | 246.45 | 246.5 | 246.14 | 246.29 | 54142.0 |
| 2018-12-21 07:40:00 | SPY | ETF | 246.28 | 246.35 | 246.19 | 246.25 | 8977.0 |
| 2018-12-21 07:45:00 | SPY | ETF | 246.2 | 246.51 | 246.14 | 246.51 | 25071.0 |
| 2018-12-21 07:50:00 | SPY | ETF | 246.55 | 246.7 | 246.45 | 246.66 | 16380.0 |
| 2018-12-21 07:55:00 | SPY | ETF | 246.69 | 246.75 | 246.61 | 246.65 | 11569.0 |
| 2018-12-21 08:00:00 | SPY | ETF | 246.65 | 247.65 | 246.0 | 246.59 | 80741.0 |
| 2018-12-21 08:05:00 | SPY | ETF | 246.61 | 246.65 | 246.45 | 246.56 | 53438.0 |
> showing 50 of 75,539 rows — these rows as CSV