PREVIEW / etf_5min / 2019-06-14
file: by_date/etf_5min/2019/2019-06-14.parquet size: 1.3 MB rows: 57,437
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-06-14 04:00:00 | SPY | ETF | 289.38 | 289.38 | 289.34 | 289.34 | 1291.0 |
| 2019-06-14 04:05:00 | SPY | ETF | 289.37 | 289.39 | 289.37 | 289.39 | 1105.0 |
| 2019-06-14 04:10:00 | SPY | ETF | 289.39 | 289.39 | 289.37 | 289.37 | 697.0 |
| 2019-06-14 04:15:00 | SPY | ETF | 289.3 | 289.3 | 289.3 | 289.3 | 5002.0 |
| 2019-06-14 04:20:00 | SPY | ETF | 289.16 | 289.16 | 289.16 | 289.16 | 110.0 |
| 2019-06-14 04:25:00 | SPY | ETF | 289.0 | 289.01 | 289.0 | 289.01 | 1513.0 |
| 2019-06-14 04:30:00 | SPY | ETF | 289.01 | 289.08 | 288.95 | 289.08 | 6606.0 |
| 2019-06-14 04:35:00 | SPY | ETF | 288.91 | 288.91 | 288.87 | 288.87 | 956.0 |
| 2019-06-14 04:50:00 | SPY | ETF | 288.99 | 288.99 | 288.99 | 288.99 | 303.0 |
| 2019-06-14 04:55:00 | SPY | ETF | 289.09 | 289.09 | 289.09 | 289.09 | 204.0 |
| 2019-06-14 05:10:00 | SPY | ETF | 289.07 | 289.09 | 289.07 | 289.07 | 9564.0 |
| 2019-06-14 05:15:00 | SPY | ETF | 289.18 | 289.2 | 289.14 | 289.2 | 6558.0 |
| 2019-06-14 05:25:00 | SPY | ETF | 289.11 | 289.13 | 289.11 | 289.13 | 3202.0 |
| 2019-06-14 05:30:00 | SPY | ETF | 289.11 | 289.14 | 289.1 | 289.14 | 3370.0 |
| 2019-06-14 05:40:00 | SPY | ETF | 289.03 | 289.03 | 288.94 | 288.94 | 830.0 |
| 2019-06-14 05:45:00 | SPY | ETF | 288.88 | 288.91 | 288.84 | 288.89 | 7365.0 |
| 2019-06-14 05:50:00 | SPY | ETF | 288.98 | 289.01 | 288.98 | 289.01 | 2010.0 |
| 2019-06-14 05:55:00 | SPY | ETF | 288.99 | 288.99 | 288.99 | 288.99 | 103.0 |
| 2019-06-14 06:05:00 | SPY | ETF | 288.96 | 288.96 | 288.96 | 288.96 | 300.0 |
| 2019-06-14 06:10:00 | SPY | ETF | 288.9 | 288.9 | 288.84 | 288.87 | 1969.0 |
| 2019-06-14 06:15:00 | SPY | ETF | 288.76 | 288.76 | 288.7 | 288.7 | 540.0 |
| 2019-06-14 06:20:00 | SPY | ETF | 288.7 | 288.7 | 288.64 | 288.67 | 8884.0 |
| 2019-06-14 06:25:00 | SPY | ETF | 288.6 | 288.6 | 288.55 | 288.55 | 883.0 |
| 2019-06-14 06:30:00 | SPY | ETF | 288.6 | 288.62 | 288.52 | 288.62 | 3909.0 |
| 2019-06-14 06:35:00 | SPY | ETF | 288.68 | 288.74 | 288.65 | 288.68 | 13313.0 |
| 2019-06-14 06:50:00 | SPY | ETF | 288.84 | 288.96 | 288.84 | 288.87 | 16012.0 |
| 2019-06-14 06:55:00 | SPY | ETF | 288.93 | 288.93 | 288.81 | 288.81 | 22269.0 |
| 2019-06-14 07:00:00 | SPY | ETF | 288.84 | 288.92 | 288.84 | 288.85 | 7883.0 |
| 2019-06-14 07:05:00 | SPY | ETF | 288.81 | 288.99 | 288.81 | 288.94 | 13200.0 |
| 2019-06-14 07:10:00 | SPY | ETF | 288.97 | 289.08 | 288.95 | 289.08 | 9591.0 |
| 2019-06-14 07:15:00 | SPY | ETF | 289.01 | 289.01 | 288.95 | 288.95 | 4755.0 |
| 2019-06-14 07:20:00 | SPY | ETF | 288.96 | 288.96 | 288.82 | 288.82 | 12540.0 |
| 2019-06-14 07:25:00 | SPY | ETF | 288.85 | 288.9 | 288.85 | 288.89 | 4002.0 |
| 2019-06-14 07:30:00 | SPY | ETF | 288.9 | 288.91 | 288.9 | 288.91 | 1281.0 |
| 2019-06-14 07:35:00 | SPY | ETF | 288.91 | 288.99 | 288.91 | 288.97 | 4324.0 |
| 2019-06-14 07:40:00 | SPY | ETF | 288.94 | 288.94 | 288.81 | 288.81 | 5176.0 |
| 2019-06-14 07:45:00 | SPY | ETF | 288.87 | 289.05 | 288.87 | 288.99 | 6994.0 |
| 2019-06-14 07:50:00 | SPY | ETF | 289.01 | 289.13 | 289.01 | 289.13 | 15501.0 |
| 2019-06-14 07:55:00 | SPY | ETF | 289.09 | 289.23 | 289.09 | 289.2 | 62188.0 |
| 2019-06-14 08:00:00 | SPY | ETF | 288.95 | 290.07 | 288.8501 | 289.11 | 75281.0 |
| 2019-06-14 08:05:00 | SPY | ETF | 289.14 | 289.2 | 289.06 | 289.2 | 51483.0 |
| 2019-06-14 08:10:00 | SPY | ETF | 289.15 | 289.15 | 289.08 | 289.08 | 16533.0 |
| 2019-06-14 08:15:00 | SPY | ETF | 289.06 | 289.06 | 289.03 | 289.03 | 12809.0 |
| 2019-06-14 08:20:00 | SPY | ETF | 289.1 | 289.12 | 289.06 | 289.09 | 22132.0 |
| 2019-06-14 08:25:00 | SPY | ETF | 289.17 | 289.2 | 289.08 | 289.09 | 12317.0 |
| 2019-06-14 08:30:00 | SPY | ETF | 289.15 | 289.32 | 289.05 | 289.05 | 90088.0 |
| 2019-06-14 08:35:00 | SPY | ETF | 289.06 | 289.2 | 289.0 | 289.2 | 46488.0 |
| 2019-06-14 08:40:00 | SPY | ETF | 289.08 | 289.21 | 289.08 | 289.17 | 11129.0 |
| 2019-06-14 08:45:00 | SPY | ETF | 289.16 | 289.17 | 289.05 | 289.13 | 22035.0 |
| 2019-06-14 08:50:00 | SPY | ETF | 289.13 | 289.1601 | 289.06 | 289.08 | 26507.0 |
> showing 50 of 57,437 rows — these rows as CSV