PREVIEW / etf_5min / 2019-05-03
file: by_date/etf_5min/2019/2019-05-03.parquet size: 1.4 MB rows: 59,872
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-03 04:00:00 | SPY | ETF | 291.97 | 292.0 | 291.97 | 292.0 | 312.0 |
| 2019-05-03 04:05:00 | SPY | ETF | 292.13 | 292.16 | 292.13 | 292.16 | 1130.0 |
| 2019-05-03 04:10:00 | SPY | ETF | 292.14 | 292.14 | 292.14 | 292.14 | 1000.0 |
| 2019-05-03 04:15:00 | SPY | ETF | 292.24 | 292.24 | 292.24 | 292.24 | 300.0 |
| 2019-05-03 04:20:00 | SPY | ETF | 292.26 | 292.29 | 292.26 | 292.29 | 1525.0 |
| 2019-05-03 04:35:00 | SPY | ETF | 292.17 | 292.17 | 292.17 | 292.17 | 325.0 |
| 2019-05-03 04:40:00 | SPY | ETF | 292.19 | 292.19 | 292.19 | 292.19 | 500.0 |
| 2019-05-03 04:45:00 | SPY | ETF | 292.15 | 292.15 | 292.15 | 292.15 | 260.0 |
| 2019-05-03 04:55:00 | SPY | ETF | 292.16 | 292.16 | 292.16 | 292.16 | 1050.0 |
| 2019-05-03 05:00:00 | SPY | ETF | 292.19 | 292.21 | 292.15 | 292.21 | 2050.0 |
| 2019-05-03 05:05:00 | SPY | ETF | 292.22 | 292.22 | 292.21 | 292.21 | 2000.0 |
| 2019-05-03 05:10:00 | SPY | ETF | 292.2 | 292.2 | 292.2 | 292.2 | 1000.0 |
| 2019-05-03 05:15:00 | SPY | ETF | 292.24 | 292.26 | 292.24 | 292.26 | 1700.0 |
| 2019-05-03 05:20:00 | SPY | ETF | 292.21 | 292.21 | 292.19 | 292.19 | 400.0 |
| 2019-05-03 05:30:00 | SPY | ETF | 292.14 | 292.16 | 292.14 | 292.15 | 1900.0 |
| 2019-05-03 05:35:00 | SPY | ETF | 292.15 | 292.15 | 292.15 | 292.15 | 300.0 |
| 2019-05-03 05:40:00 | SPY | ETF | 292.14 | 292.18 | 292.13 | 292.18 | 2200.0 |
| 2019-05-03 05:45:00 | SPY | ETF | 292.17 | 292.17 | 292.17 | 292.17 | 100.0 |
| 2019-05-03 05:50:00 | SPY | ETF | 292.07 | 292.1 | 291.97 | 291.97 | 1340.0 |
| 2019-05-03 05:55:00 | SPY | ETF | 291.95 | 291.96 | 291.95 | 291.96 | 300.0 |
| 2019-05-03 06:00:00 | SPY | ETF | 291.96 | 291.96 | 291.96 | 291.96 | 100.0 |
| 2019-05-03 06:05:00 | SPY | ETF | 291.94 | 291.94 | 291.94 | 291.94 | 300.0 |
| 2019-05-03 06:10:00 | SPY | ETF | 291.91 | 291.91 | 291.91 | 291.91 | 200.0 |
| 2019-05-03 06:15:00 | SPY | ETF | 291.94 | 292.06 | 291.94 | 292.06 | 3753.0 |
| 2019-05-03 06:20:00 | SPY | ETF | 292.06 | 292.06 | 292.03 | 292.03 | 580.0 |
| 2019-05-03 06:25:00 | SPY | ETF | 292.03 | 292.03 | 292.02 | 292.03 | 2400.0 |
| 2019-05-03 06:30:00 | SPY | ETF | 292.05 | 292.07 | 292.02 | 292.05 | 28350.0 |
| 2019-05-03 06:35:00 | SPY | ETF | 292.02 | 292.02 | 291.99 | 291.99 | 650.0 |
| 2019-05-03 06:40:00 | SPY | ETF | 292.02 | 292.06 | 292.02 | 292.05 | 5610.0 |
| 2019-05-03 06:45:00 | SPY | ETF | 292.06 | 292.06 | 292.05 | 292.05 | 950.0 |
| 2019-05-03 06:50:00 | SPY | ETF | 292.05 | 292.09 | 292.05 | 292.09 | 2880.0 |
| 2019-05-03 06:55:00 | SPY | ETF | 292.02 | 292.02 | 291.94 | 291.94 | 4000.0 |
| 2019-05-03 07:00:00 | SPY | ETF | 291.94 | 291.96 | 291.89 | 291.96 | 2300.0 |
| 2019-05-03 07:05:00 | SPY | ETF | 291.97 | 291.98 | 291.97 | 291.98 | 400.0 |
| 2019-05-03 07:10:00 | SPY | ETF | 291.93 | 291.93 | 291.93 | 291.93 | 300.0 |
| 2019-05-03 07:15:00 | SPY | ETF | 291.97 | 292.04 | 291.97 | 292.04 | 8945.0 |
| 2019-05-03 07:20:00 | SPY | ETF | 292.05 | 292.07 | 292.03 | 292.06 | 8900.0 |
| 2019-05-03 07:25:00 | SPY | ETF | 292.04 | 292.05 | 291.99 | 292.05 | 5305.0 |
| 2019-05-03 07:30:00 | SPY | ETF | 291.98 | 292.05 | 291.98 | 292.04 | 838.0 |
| 2019-05-03 07:35:00 | SPY | ETF | 292.09 | 292.17 | 292.09 | 292.14 | 3530.0 |
| 2019-05-03 07:40:00 | SPY | ETF | 292.17 | 292.19 | 292.14 | 292.16 | 7005.0 |
| 2019-05-03 07:45:00 | SPY | ETF | 292.16 | 292.16 | 292.07 | 292.07 | 5550.0 |
| 2019-05-03 07:50:00 | SPY | ETF | 292.07 | 292.08 | 292.0 | 292.03 | 7140.0 |
| 2019-05-03 07:55:00 | SPY | ETF | 292.04 | 292.15 | 292.04 | 292.14 | 11150.0 |
| 2019-05-03 08:00:00 | SPY | ETF | 292.02 | 292.28 | 291.65 | 292.28 | 56663.0 |
| 2019-05-03 08:05:00 | SPY | ETF | 292.27 | 292.28 | 292.19 | 292.23 | 46278.0 |
| 2019-05-03 08:10:00 | SPY | ETF | 292.23 | 292.28 | 292.1 | 292.19 | 38460.0 |
| 2019-05-03 08:15:00 | SPY | ETF | 292.2 | 292.26 | 292.18 | 292.2 | 23935.0 |
| 2019-05-03 08:20:00 | SPY | ETF | 292.23 | 292.25 | 292.14 | 292.22 | 46600.0 |
| 2019-05-03 08:25:00 | SPY | ETF | 292.2 | 292.23 | 292.15 | 292.18 | 86113.0 |
> showing 50 of 59,872 rows — these rows as CSV