PREVIEW / etf_5min / 2019-02-26
file: by_date/etf_5min/2019/2019-02-26.parquet size: 1.4 MB rows: 62,361
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-02-26 04:00:00 | SPY | ETF | 278.97 | 278.97 | 278.86 | 278.86 | 4278.0 |
| 2019-02-26 04:10:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 1510.0 |
| 2019-02-26 04:15:00 | SPY | ETF | 278.73 | 278.73 | 278.73 | 278.73 | 321.0 |
| 2019-02-26 04:20:00 | SPY | ETF | 278.72 | 278.72 | 278.7 | 278.7 | 6475.0 |
| 2019-02-26 04:25:00 | SPY | ETF | 278.6 | 278.6 | 278.46 | 278.46 | 734.0 |
| 2019-02-26 04:30:00 | SPY | ETF | 278.49 | 278.49 | 278.49 | 278.49 | 1300.0 |
| 2019-02-26 04:35:00 | SPY | ETF | 278.68 | 278.68 | 278.68 | 278.68 | 300.0 |
| 2019-02-26 04:40:00 | SPY | ETF | 278.73 | 278.73 | 278.73 | 278.73 | 200.0 |
| 2019-02-26 04:55:00 | SPY | ETF | 278.96 | 278.96 | 278.96 | 278.96 | 250.0 |
| 2019-02-26 05:00:00 | SPY | ETF | 279.0 | 279.0 | 279.0 | 279.0 | 140.0 |
| 2019-02-26 05:15:00 | SPY | ETF | 278.91 | 278.91 | 278.91 | 278.91 | 200.0 |
| 2019-02-26 05:25:00 | SPY | ETF | 278.9 | 278.94 | 278.9 | 278.94 | 5366.0 |
| 2019-02-26 05:35:00 | SPY | ETF | 278.98 | 278.98 | 278.98 | 278.98 | 200.0 |
| 2019-02-26 05:40:00 | SPY | ETF | 278.9 | 278.96 | 278.9 | 278.94 | 500.0 |
| 2019-02-26 05:45:00 | SPY | ETF | 279.1 | 279.1 | 279.09 | 279.09 | 3000.0 |
| 2019-02-26 05:55:00 | SPY | ETF | 279.05 | 279.12 | 279.05 | 279.12 | 1000.0 |
| 2019-02-26 06:00:00 | SPY | ETF | 279.11 | 279.12 | 279.02 | 279.02 | 2225.0 |
| 2019-02-26 06:05:00 | SPY | ETF | 279.01 | 279.01 | 278.94 | 278.94 | 9400.0 |
| 2019-02-26 06:10:00 | SPY | ETF | 278.99 | 278.99 | 278.99 | 278.99 | 100.0 |
| 2019-02-26 06:15:00 | SPY | ETF | 279.03 | 279.03 | 278.99 | 278.99 | 1750.0 |
| 2019-02-26 06:20:00 | SPY | ETF | 278.94 | 278.94 | 278.9 | 278.9 | 800.0 |
| 2019-02-26 06:25:00 | SPY | ETF | 278.9 | 278.92 | 278.89 | 278.89 | 1500.0 |
| 2019-02-26 06:30:00 | SPY | ETF | 278.84 | 278.84 | 278.75 | 278.75 | 725.0 |
| 2019-02-26 06:35:00 | SPY | ETF | 278.7 | 278.77 | 278.7 | 278.72 | 2700.0 |
| 2019-02-26 06:40:00 | SPY | ETF | 278.78 | 278.78 | 278.77 | 278.77 | 5650.0 |
| 2019-02-26 06:45:00 | SPY | ETF | 278.86 | 278.94 | 278.83 | 278.91 | 1900.0 |
| 2019-02-26 06:50:00 | SPY | ETF | 278.94 | 278.94 | 278.88 | 278.88 | 1645.0 |
| 2019-02-26 06:55:00 | SPY | ETF | 278.84 | 278.92 | 278.84 | 278.92 | 1952.0 |
| 2019-02-26 07:00:00 | SPY | ETF | 279.03 | 279.07 | 278.98 | 279.06 | 14789.0 |
| 2019-02-26 07:05:00 | SPY | ETF | 279.04 | 279.06 | 279.03 | 279.04 | 6705.0 |
| 2019-02-26 07:10:00 | SPY | ETF | 279.07 | 279.08 | 279.06 | 279.06 | 4138.0 |
| 2019-02-26 07:15:00 | SPY | ETF | 279.08 | 279.1 | 279.0 | 279.06 | 7811.0 |
| 2019-02-26 07:20:00 | SPY | ETF | 279.1 | 279.17 | 279.09 | 279.1 | 42489.0 |
| 2019-02-26 07:25:00 | SPY | ETF | 279.11 | 279.26 | 279.11 | 279.24 | 44900.0 |
| 2019-02-26 07:30:00 | SPY | ETF | 279.23 | 279.24 | 279.17 | 279.24 | 10650.0 |
| 2019-02-26 07:35:00 | SPY | ETF | 279.19 | 279.2 | 279.19 | 279.2 | 5350.0 |
| 2019-02-26 07:40:00 | SPY | ETF | 279.2 | 279.25 | 279.19 | 279.19 | 3720.0 |
| 2019-02-26 07:45:00 | SPY | ETF | 279.19 | 279.22 | 279.09 | 279.19 | 11804.0 |
| 2019-02-26 07:50:00 | SPY | ETF | 279.19 | 279.23 | 279.15 | 279.23 | 12521.0 |
| 2019-02-26 07:55:00 | SPY | ETF | 279.21 | 279.22 | 279.19 | 279.2 | 5814.0 |
| 2019-02-26 08:00:00 | SPY | ETF | 279.21 | 279.2599 | 278.7 | 279.11 | 47949.0 |
| 2019-02-26 08:05:00 | SPY | ETF | 279.12 | 279.18 | 279.11 | 279.14 | 9636.0 |
| 2019-02-26 08:10:00 | SPY | ETF | 279.12 | 279.12 | 279.0 | 279.04 | 41158.0 |
| 2019-02-26 08:15:00 | SPY | ETF | 279.05 | 279.19 | 279.05 | 279.19 | 27034.0 |
| 2019-02-26 08:20:00 | SPY | ETF | 279.15 | 279.15 | 279.09 | 279.09 | 3624.0 |
| 2019-02-26 08:25:00 | SPY | ETF | 279.1 | 279.15 | 279.09 | 279.13 | 43194.0 |
| 2019-02-26 08:30:00 | SPY | ETF | 279.12 | 279.2 | 278.98 | 279.01 | 110835.0 |
| 2019-02-26 08:35:00 | SPY | ETF | 279.01 | 279.02 | 278.88 | 278.97 | 98533.0 |
| 2019-02-26 08:40:00 | SPY | ETF | 278.98 | 279.0201 | 278.96 | 278.96 | 6380.0 |
| 2019-02-26 08:45:00 | SPY | ETF | 278.95 | 278.95 | 278.88 | 278.94 | 18920.0 |
> showing 50 of 62,361 rows — these rows as CSV