PREVIEW / etf_5min / 2019-01-31
file: by_date/etf_5min/2019/2019-01-31.parquet size: 1.6 MB rows: 66,501
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-01-31 04:00:00 | SPY | ETF | 268.16 | 268.16 | 268.14 | 268.14 | 5825.0 |
| 2019-01-31 04:10:00 | SPY | ETF | 268.29 | 268.39 | 268.26 | 268.34 | 4770.0 |
| 2019-01-31 04:15:00 | SPY | ETF | 268.28 | 268.28 | 268.25 | 268.25 | 1000.0 |
| 2019-01-31 04:20:00 | SPY | ETF | 268.2 | 268.2 | 268.18 | 268.19 | 1100.0 |
| 2019-01-31 04:25:00 | SPY | ETF | 268.18 | 268.19 | 268.1 | 268.1 | 2130.0 |
| 2019-01-31 04:30:00 | SPY | ETF | 268.1 | 268.1 | 268.04 | 268.04 | 800.0 |
| 2019-01-31 04:35:00 | SPY | ETF | 268.1 | 268.1 | 268.1 | 268.1 | 518.0 |
| 2019-01-31 04:40:00 | SPY | ETF | 268.09 | 268.14 | 268.07 | 268.14 | 1000.0 |
| 2019-01-31 04:45:00 | SPY | ETF | 268.15 | 268.15 | 268.15 | 268.15 | 3500.0 |
| 2019-01-31 04:50:00 | SPY | ETF | 268.08 | 268.08 | 268.05 | 268.05 | 400.0 |
| 2019-01-31 05:00:00 | SPY | ETF | 268.01 | 268.01 | 267.92 | 267.93 | 3695.0 |
| 2019-01-31 05:05:00 | SPY | ETF | 267.93 | 268.0 | 267.9 | 267.9 | 1231.0 |
| 2019-01-31 05:10:00 | SPY | ETF | 267.9 | 267.93 | 267.86 | 267.93 | 2395.0 |
| 2019-01-31 05:15:00 | SPY | ETF | 268.0 | 268.0 | 268.0 | 268.0 | 500.0 |
| 2019-01-31 05:20:00 | SPY | ETF | 268.03 | 268.04 | 268.02 | 268.02 | 685.0 |
| 2019-01-31 05:25:00 | SPY | ETF | 267.87 | 267.87 | 267.79 | 267.79 | 1360.0 |
| 2019-01-31 05:30:00 | SPY | ETF | 267.78 | 267.91 | 267.78 | 267.91 | 1400.0 |
| 2019-01-31 05:35:00 | SPY | ETF | 267.9 | 268.19 | 267.89 | 268.16 | 1300.0 |
| 2019-01-31 05:40:00 | SPY | ETF | 268.1 | 268.1 | 268.07 | 268.07 | 354.0 |
| 2019-01-31 05:45:00 | SPY | ETF | 268.13 | 268.13 | 268.11 | 268.11 | 310.0 |
| 2019-01-31 05:50:00 | SPY | ETF | 268.1 | 268.1 | 267.94 | 267.94 | 3200.0 |
| 2019-01-31 05:55:00 | SPY | ETF | 268.0 | 268.0 | 268.0 | 268.0 | 769.0 |
| 2019-01-31 06:00:00 | SPY | ETF | 268.03 | 268.04 | 267.94 | 268.03 | 3931.0 |
| 2019-01-31 06:05:00 | SPY | ETF | 268.01 | 268.01 | 267.92 | 268.01 | 6700.0 |
| 2019-01-31 06:10:00 | SPY | ETF | 267.98 | 268.0 | 267.94 | 268.0 | 4112.0 |
| 2019-01-31 06:15:00 | SPY | ETF | 268.01 | 268.2 | 268.01 | 268.12 | 13964.0 |
| 2019-01-31 06:20:00 | SPY | ETF | 268.11 | 268.11 | 268.11 | 268.11 | 100.0 |
| 2019-01-31 06:25:00 | SPY | ETF | 268.11 | 268.16 | 268.05 | 268.16 | 2230.0 |
| 2019-01-31 06:30:00 | SPY | ETF | 268.2 | 268.2 | 268.17 | 268.17 | 1500.0 |
| 2019-01-31 06:35:00 | SPY | ETF | 268.18 | 268.24 | 268.12 | 268.14 | 3705.0 |
| 2019-01-31 06:40:00 | SPY | ETF | 268.18 | 268.18 | 268.11 | 268.11 | 1200.0 |
| 2019-01-31 06:45:00 | SPY | ETF | 268.19 | 268.24 | 268.12 | 268.24 | 8115.0 |
| 2019-01-31 06:50:00 | SPY | ETF | 268.24 | 268.29 | 268.24 | 268.27 | 2400.0 |
| 2019-01-31 06:55:00 | SPY | ETF | 268.29 | 268.3 | 268.29 | 268.3 | 600.0 |
| 2019-01-31 07:00:00 | SPY | ETF | 268.28 | 268.28 | 268.07 | 268.07 | 10215.0 |
| 2019-01-31 07:05:00 | SPY | ETF | 268.07 | 268.09 | 267.89 | 268.0 | 34941.0 |
| 2019-01-31 07:10:00 | SPY | ETF | 267.98 | 268.04 | 267.97 | 267.98 | 19374.0 |
| 2019-01-31 07:15:00 | SPY | ETF | 268.08 | 268.23 | 268.08 | 268.14 | 5066.0 |
| 2019-01-31 07:20:00 | SPY | ETF | 268.17 | 268.17 | 268.13 | 268.17 | 6514.0 |
| 2019-01-31 07:25:00 | SPY | ETF | 268.19 | 268.19 | 268.11 | 268.11 | 27900.0 |
| 2019-01-31 07:30:00 | SPY | ETF | 268.1 | 268.1 | 267.96 | 268.01 | 15733.0 |
| 2019-01-31 07:35:00 | SPY | ETF | 267.99 | 268.0 | 267.83 | 267.94 | 53575.0 |
| 2019-01-31 07:40:00 | SPY | ETF | 268.0 | 268.24 | 267.94 | 268.22 | 34260.0 |
| 2019-01-31 07:45:00 | SPY | ETF | 268.24 | 268.26 | 267.99 | 268.14 | 111716.0 |
| 2019-01-31 07:50:00 | SPY | ETF | 268.15 | 268.28 | 268.15 | 268.2 | 18420.0 |
| 2019-01-31 07:55:00 | SPY | ETF | 268.2 | 268.23 | 268.11 | 268.16 | 17613.0 |
| 2019-01-31 08:00:00 | SPY | ETF | 268.13 | 268.56 | 267.97 | 268.22 | 32558.0 |
| 2019-01-31 08:05:00 | SPY | ETF | 268.16 | 268.16 | 268.05 | 268.09 | 10735.0 |
| 2019-01-31 08:10:00 | SPY | ETF | 268.09 | 268.11 | 268.03 | 268.07 | 8454.0 |
| 2019-01-31 08:15:00 | SPY | ETF | 268.07 | 268.21 | 268.07 | 268.1 | 53112.0 |
> showing 50 of 66,501 rows — these rows as CSV