PREVIEW / etf_5min / 2019-05-08
file: by_date/etf_5min/2019/2019-05-08.parquet size: 1.4 MB rows: 61,660
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-08 04:00:00 | SPY | ETF | 288.98 | 289.01 | 288.91 | 289.0 | 1636.0 |
| 2019-05-08 04:05:00 | SPY | ETF | 289.01 | 289.02 | 288.97 | 288.97 | 1236.0 |
| 2019-05-08 04:10:00 | SPY | ETF | 288.99 | 289.31 | 288.97 | 289.31 | 5179.0 |
| 2019-05-08 04:15:00 | SPY | ETF | 289.32 | 289.42 | 289.29 | 289.36 | 1454.0 |
| 2019-05-08 04:20:00 | SPY | ETF | 289.34 | 289.34 | 289.26 | 289.26 | 1276.0 |
| 2019-05-08 04:25:00 | SPY | ETF | 289.31 | 289.31 | 289.19 | 289.19 | 200.0 |
| 2019-05-08 04:30:00 | SPY | ETF | 289.11 | 289.11 | 288.97 | 288.97 | 2965.0 |
| 2019-05-08 04:35:00 | SPY | ETF | 289.06 | 289.07 | 289.06 | 289.07 | 290.0 |
| 2019-05-08 04:40:00 | SPY | ETF | 289.09 | 289.09 | 288.89 | 288.96 | 2941.0 |
| 2019-05-08 04:45:00 | SPY | ETF | 288.99 | 288.99 | 288.41 | 288.51 | 3557.0 |
| 2019-05-08 04:50:00 | SPY | ETF | 288.54 | 288.63 | 288.54 | 288.62 | 2950.0 |
| 2019-05-08 04:55:00 | SPY | ETF | 288.63 | 288.69 | 288.63 | 288.69 | 300.0 |
| 2019-05-08 05:00:00 | SPY | ETF | 288.57 | 288.57 | 288.36 | 288.41 | 2056.0 |
| 2019-05-08 05:05:00 | SPY | ETF | 288.4 | 288.4 | 288.31 | 288.31 | 1250.0 |
| 2019-05-08 05:10:00 | SPY | ETF | 288.34 | 288.35 | 288.26 | 288.33 | 900.0 |
| 2019-05-08 05:15:00 | SPY | ETF | 288.49 | 288.49 | 288.49 | 288.49 | 300.0 |
| 2019-05-08 05:20:00 | SPY | ETF | 288.59 | 288.59 | 288.29 | 288.29 | 745.0 |
| 2019-05-08 05:25:00 | SPY | ETF | 288.17 | 288.22 | 287.94 | 288.22 | 2999.0 |
| 2019-05-08 05:30:00 | SPY | ETF | 288.17 | 288.17 | 287.94 | 287.99 | 1985.0 |
| 2019-05-08 05:35:00 | SPY | ETF | 287.92 | 288.07 | 287.84 | 287.89 | 2190.0 |
| 2019-05-08 05:40:00 | SPY | ETF | 287.87 | 287.97 | 287.72 | 287.72 | 1955.0 |
| 2019-05-08 05:45:00 | SPY | ETF | 287.72 | 287.84 | 287.64 | 287.64 | 5000.0 |
| 2019-05-08 05:50:00 | SPY | ETF | 287.71 | 287.71 | 287.5 | 287.57 | 5544.0 |
| 2019-05-08 05:55:00 | SPY | ETF | 287.52 | 287.59 | 287.37 | 287.37 | 1385.0 |
| 2019-05-08 06:00:00 | SPY | ETF | 287.44 | 287.47 | 287.32 | 287.47 | 1871.0 |
| 2019-05-08 06:05:00 | SPY | ETF | 287.34 | 287.35 | 287.3 | 287.34 | 2525.0 |
| 2019-05-08 06:10:00 | SPY | ETF | 287.34 | 287.34 | 287.16 | 287.16 | 1557.0 |
| 2019-05-08 06:15:00 | SPY | ETF | 287.32 | 287.34 | 287.32 | 287.32 | 2450.0 |
| 2019-05-08 06:20:00 | SPY | ETF | 287.34 | 287.34 | 287.33 | 287.34 | 500.0 |
| 2019-05-08 06:25:00 | SPY | ETF | 287.32 | 287.49 | 287.32 | 287.36 | 4057.0 |
| 2019-05-08 06:30:00 | SPY | ETF | 287.31 | 287.54 | 287.31 | 287.54 | 2050.0 |
| 2019-05-08 06:35:00 | SPY | ETF | 287.41 | 287.44 | 287.38 | 287.42 | 2688.0 |
| 2019-05-08 06:40:00 | SPY | ETF | 287.39 | 287.46 | 287.24 | 287.46 | 13284.0 |
| 2019-05-08 06:45:00 | SPY | ETF | 287.54 | 287.55 | 287.49 | 287.51 | 6700.0 |
| 2019-05-08 06:50:00 | SPY | ETF | 287.5 | 287.58 | 287.48 | 287.48 | 2007.0 |
| 2019-05-08 06:55:00 | SPY | ETF | 287.46 | 287.56 | 287.43 | 287.46 | 6402.0 |
| 2019-05-08 07:00:00 | SPY | ETF | 287.44 | 287.45 | 286.79 | 286.87 | 38154.0 |
| 2019-05-08 07:05:00 | SPY | ETF | 286.82 | 287.03 | 286.75 | 287.03 | 15624.0 |
| 2019-05-08 07:10:00 | SPY | ETF | 286.97 | 287.0 | 286.67 | 286.73 | 58848.0 |
| 2019-05-08 07:15:00 | SPY | ETF | 286.74 | 286.89 | 286.49 | 286.76 | 63584.0 |
| 2019-05-08 07:20:00 | SPY | ETF | 286.7 | 286.87 | 286.69 | 286.82 | 18254.0 |
| 2019-05-08 07:25:00 | SPY | ETF | 286.88 | 287.14 | 286.88 | 286.99 | 28975.0 |
| 2019-05-08 07:30:00 | SPY | ETF | 286.93 | 286.93 | 286.82 | 286.88 | 41636.0 |
| 2019-05-08 07:35:00 | SPY | ETF | 286.83 | 287.06 | 286.81 | 287.06 | 46079.0 |
| 2019-05-08 07:40:00 | SPY | ETF | 287.02 | 287.02 | 286.79 | 286.96 | 32076.0 |
| 2019-05-08 07:45:00 | SPY | ETF | 286.94 | 286.94 | 286.72 | 286.81 | 51485.0 |
| 2019-05-08 07:50:00 | SPY | ETF | 286.84 | 287.03 | 286.84 | 287.03 | 46975.0 |
| 2019-05-08 07:55:00 | SPY | ETF | 287.02 | 287.21 | 287.02 | 287.13 | 145419.0 |
| 2019-05-08 08:00:00 | SPY | ETF | 287.38 | 289.0 | 286.44 | 287.09 | 49060.0 |
| 2019-05-08 08:05:00 | SPY | ETF | 287.09 | 287.28 | 287.07 | 287.18 | 125135.0 |
> showing 50 of 61,660 rows — these rows as CSV