PREVIEW / etf_5min / 2018-10-24
file: by_date/etf_5min/2018/2018-10-24.parquet size: 1.5 MB rows: 65,351
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-24 04:00:00 | SPY | ETF | 272.42 | 272.45 | 272.0 | 272.37 | 7155.0 |
| 2018-10-24 04:05:00 | SPY | ETF | 272.3 | 272.31 | 271.9 | 272.07 | 9011.0 |
| 2018-10-24 04:10:00 | SPY | ETF | 272.02 | 272.29 | 271.96 | 272.24 | 6545.0 |
| 2018-10-24 04:15:00 | SPY | ETF | 272.05 | 272.05 | 271.86 | 271.86 | 2310.0 |
| 2018-10-24 04:20:00 | SPY | ETF | 271.83 | 271.89 | 271.81 | 271.89 | 7731.0 |
| 2018-10-24 04:25:00 | SPY | ETF | 271.89 | 271.96 | 271.72 | 271.96 | 12418.0 |
| 2018-10-24 04:30:00 | SPY | ETF | 271.9 | 272.04 | 271.88 | 272.01 | 8320.0 |
| 2018-10-24 04:35:00 | SPY | ETF | 271.99 | 271.99 | 271.78 | 271.99 | 13969.0 |
| 2018-10-24 04:40:00 | SPY | ETF | 271.96 | 271.96 | 271.64 | 271.66 | 17310.0 |
| 2018-10-24 04:45:00 | SPY | ETF | 271.65 | 271.65 | 271.45 | 271.47 | 19940.0 |
| 2018-10-24 04:50:00 | SPY | ETF | 271.51 | 271.51 | 271.42 | 271.42 | 3300.0 |
| 2018-10-24 04:55:00 | SPY | ETF | 271.5 | 271.53 | 271.42 | 271.48 | 11100.0 |
| 2018-10-24 05:00:00 | SPY | ETF | 271.46 | 271.49 | 271.46 | 271.49 | 3400.0 |
| 2018-10-24 05:05:00 | SPY | ETF | 271.56 | 271.84 | 271.41 | 271.74 | 15339.0 |
| 2018-10-24 05:10:00 | SPY | ETF | 271.76 | 271.84 | 271.73 | 271.75 | 15276.0 |
| 2018-10-24 05:15:00 | SPY | ETF | 271.89 | 272.06 | 271.89 | 272.0 | 6898.0 |
| 2018-10-24 05:20:00 | SPY | ETF | 272.0 | 272.09 | 271.92 | 272.01 | 8450.0 |
| 2018-10-24 05:25:00 | SPY | ETF | 272.09 | 272.19 | 271.95 | 271.95 | 3500.0 |
| 2018-10-24 05:30:00 | SPY | ETF | 271.95 | 272.0 | 271.82 | 271.91 | 9600.0 |
| 2018-10-24 05:35:00 | SPY | ETF | 271.99 | 272.09 | 271.97 | 272.09 | 6170.0 |
| 2018-10-24 05:40:00 | SPY | ETF | 272.13 | 272.19 | 272.1 | 272.19 | 5990.0 |
| 2018-10-24 05:45:00 | SPY | ETF | 272.2 | 272.31 | 272.2 | 272.22 | 2525.0 |
| 2018-10-24 05:50:00 | SPY | ETF | 272.28 | 272.3 | 272.25 | 272.25 | 22000.0 |
| 2018-10-24 05:55:00 | SPY | ETF | 272.3 | 272.3 | 272.21 | 272.29 | 11700.0 |
| 2018-10-24 06:00:00 | SPY | ETF | 272.21 | 272.28 | 272.21 | 272.25 | 1743.0 |
| 2018-10-24 06:05:00 | SPY | ETF | 272.22 | 272.43 | 272.15 | 272.43 | 17800.0 |
| 2018-10-24 06:10:00 | SPY | ETF | 272.33 | 272.38 | 272.33 | 272.33 | 1900.0 |
| 2018-10-24 06:15:00 | SPY | ETF | 272.31 | 272.33 | 272.23 | 272.23 | 5650.0 |
| 2018-10-24 06:20:00 | SPY | ETF | 272.26 | 272.33 | 272.21 | 272.33 | 14160.0 |
| 2018-10-24 06:25:00 | SPY | ETF | 272.26 | 272.34 | 272.26 | 272.31 | 9500.0 |
| 2018-10-24 06:30:00 | SPY | ETF | 272.39 | 272.49 | 272.2 | 272.25 | 27553.0 |
| 2018-10-24 06:35:00 | SPY | ETF | 272.27 | 272.27 | 272.2 | 272.27 | 14582.0 |
| 2018-10-24 06:40:00 | SPY | ETF | 272.34 | 272.39 | 272.32 | 272.39 | 16610.0 |
| 2018-10-24 06:45:00 | SPY | ETF | 272.38 | 272.55 | 272.33 | 272.55 | 28660.0 |
| 2018-10-24 06:50:00 | SPY | ETF | 272.55 | 272.64 | 272.53 | 272.59 | 31450.0 |
| 2018-10-24 06:55:00 | SPY | ETF | 272.63 | 272.65 | 272.52 | 272.65 | 20815.0 |
| 2018-10-24 07:00:00 | SPY | ETF | 272.66 | 272.69 | 272.49 | 272.51 | 34875.0 |
| 2018-10-24 07:05:00 | SPY | ETF | 272.56 | 272.58 | 272.49 | 272.51 | 6874.0 |
| 2018-10-24 07:10:00 | SPY | ETF | 272.5 | 272.63 | 272.5 | 272.63 | 12850.0 |
| 2018-10-24 07:15:00 | SPY | ETF | 272.63 | 272.79 | 272.6 | 272.76 | 123889.0 |
| 2018-10-24 07:20:00 | SPY | ETF | 272.78 | 272.83 | 272.61 | 272.65 | 48603.0 |
| 2018-10-24 07:25:00 | SPY | ETF | 272.63 | 272.84 | 272.61 | 272.84 | 58808.0 |
| 2018-10-24 07:30:00 | SPY | ETF | 272.89 | 273.29 | 272.81 | 273.25 | 150517.0 |
| 2018-10-24 07:35:00 | SPY | ETF | 273.27 | 273.45 | 273.24 | 273.45 | 94258.0 |
| 2018-10-24 07:40:00 | SPY | ETF | 273.48 | 273.66 | 273.48 | 273.55 | 48165.0 |
| 2018-10-24 07:45:00 | SPY | ETF | 273.58 | 273.83 | 273.5 | 273.79 | 75109.0 |
| 2018-10-24 07:50:00 | SPY | ETF | 273.66 | 273.83 | 273.61 | 273.76 | 121254.0 |
| 2018-10-24 07:55:00 | SPY | ETF | 273.77 | 274.03 | 273.75 | 273.96 | 93953.0 |
| 2018-10-24 08:00:00 | SPY | ETF | 272.61 | 273.95 | 272.0 | 273.86 | 175789.0 |
| 2018-10-24 08:05:00 | SPY | ETF | 273.94 | 274.1 | 273.87 | 274.09 | 124299.0 |
> showing 50 of 65,351 rows — these rows as CSV