PREVIEW / etf_5min / 2019-02-07
file: by_date/etf_5min/2019/2019-02-07.parquet size: 1.5 MB rows: 64,942
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-07 04:00:00 | SPY | ETF | 272.11 | 272.13 | 272.04 | 272.12 | 3910.0 |
| 2019-02-07 04:05:00 | SPY | ETF | 272.11 | 272.16 | 272.11 | 272.16 | 4910.0 |
| 2019-02-07 04:10:00 | SPY | ETF | 272.11 | 272.14 | 272.11 | 272.12 | 1225.0 |
| 2019-02-07 04:15:00 | SPY | ETF | 272.12 | 272.12 | 272.12 | 272.12 | 1100.0 |
| 2019-02-07 04:20:00 | SPY | ETF | 272.09 | 272.09 | 272.09 | 272.09 | 110.0 |
| 2019-02-07 04:30:00 | SPY | ETF | 272.09 | 272.09 | 272.09 | 272.09 | 248.0 |
| 2019-02-07 04:40:00 | SPY | ETF | 272.07 | 272.07 | 272.07 | 272.07 | 105.0 |
| 2019-02-07 04:50:00 | SPY | ETF | 272.05 | 272.17 | 272.02 | 272.17 | 1600.0 |
| 2019-02-07 05:10:00 | SPY | ETF | 272.05 | 272.05 | 272.0 | 272.0 | 1636.0 |
| 2019-02-07 05:15:00 | SPY | ETF | 271.81 | 271.81 | 271.5 | 271.5 | 7816.0 |
| 2019-02-07 05:20:00 | SPY | ETF | 271.52 | 271.55 | 271.4 | 271.55 | 3986.0 |
| 2019-02-07 05:25:00 | SPY | ETF | 271.5 | 271.5 | 271.36 | 271.36 | 1806.0 |
| 2019-02-07 05:30:00 | SPY | ETF | 271.27 | 271.35 | 271.22 | 271.33 | 15388.0 |
| 2019-02-07 05:35:00 | SPY | ETF | 271.4 | 271.46 | 271.37 | 271.38 | 7553.0 |
| 2019-02-07 05:40:00 | SPY | ETF | 271.4 | 271.43 | 271.38 | 271.39 | 1199.0 |
| 2019-02-07 05:45:00 | SPY | ETF | 271.39 | 271.47 | 271.37 | 271.47 | 1386.0 |
| 2019-02-07 05:50:00 | SPY | ETF | 271.48 | 271.54 | 271.4 | 271.53 | 13149.0 |
| 2019-02-07 05:55:00 | SPY | ETF | 271.51 | 271.51 | 271.35 | 271.4 | 2335.0 |
| 2019-02-07 06:00:00 | SPY | ETF | 271.34 | 271.45 | 271.3 | 271.4 | 9907.0 |
| 2019-02-07 06:05:00 | SPY | ETF | 271.41 | 271.42 | 271.33 | 271.33 | 3755.0 |
| 2019-02-07 06:10:00 | SPY | ETF | 271.33 | 271.33 | 270.99 | 270.99 | 33736.0 |
| 2019-02-07 06:15:00 | SPY | ETF | 270.99 | 271.11 | 270.97 | 271.11 | 18075.0 |
| 2019-02-07 06:20:00 | SPY | ETF | 271.09 | 271.1 | 270.88 | 270.98 | 36332.0 |
| 2019-02-07 06:25:00 | SPY | ETF | 270.97 | 271.04 | 270.8 | 271.04 | 14891.0 |
| 2019-02-07 06:30:00 | SPY | ETF | 271.06 | 271.08 | 271.05 | 271.06 | 23998.0 |
| 2019-02-07 06:35:00 | SPY | ETF | 271.06 | 271.06 | 270.72 | 270.74 | 32056.0 |
| 2019-02-07 06:40:00 | SPY | ETF | 270.85 | 271.09 | 270.85 | 271.03 | 19156.0 |
| 2019-02-07 06:45:00 | SPY | ETF | 271.0 | 271.13 | 271.0 | 271.06 | 4690.0 |
| 2019-02-07 06:50:00 | SPY | ETF | 271.03 | 271.03 | 270.81 | 270.87 | 21292.0 |
| 2019-02-07 06:55:00 | SPY | ETF | 270.87 | 270.92 | 270.82 | 270.92 | 24638.0 |
| 2019-02-07 07:00:00 | SPY | ETF | 270.94 | 271.05 | 270.82 | 271.05 | 51455.0 |
| 2019-02-07 07:05:00 | SPY | ETF | 271.02 | 271.1 | 270.86 | 270.92 | 63410.0 |
| 2019-02-07 07:10:00 | SPY | ETF | 270.92 | 271.0 | 270.92 | 270.95 | 21725.0 |
| 2019-02-07 07:15:00 | SPY | ETF | 271.0 | 271.1 | 270.98 | 271.08 | 50760.0 |
| 2019-02-07 07:20:00 | SPY | ETF | 271.12 | 271.28 | 271.12 | 271.21 | 60489.0 |
| 2019-02-07 07:25:00 | SPY | ETF | 271.2 | 271.2 | 271.06 | 271.14 | 6041.0 |
| 2019-02-07 07:30:00 | SPY | ETF | 271.18 | 271.18 | 271.05 | 271.08 | 20849.0 |
| 2019-02-07 07:35:00 | SPY | ETF | 271.09 | 271.09 | 271.02 | 271.02 | 11543.0 |
| 2019-02-07 07:40:00 | SPY | ETF | 271.02 | 271.08 | 270.94 | 270.94 | 26500.0 |
| 2019-02-07 07:45:00 | SPY | ETF | 270.94 | 271.0 | 270.91 | 270.93 | 8572.0 |
| 2019-02-07 07:50:00 | SPY | ETF | 270.93 | 271.02 | 270.93 | 271.0 | 13761.0 |
| 2019-02-07 07:55:00 | SPY | ETF | 270.99 | 270.99 | 270.9 | 270.9 | 20623.0 |
| 2019-02-07 08:00:00 | SPY | ETF | 270.95 | 272.07 | 270.91 | 271.09 | 70444.0 |
| 2019-02-07 08:05:00 | SPY | ETF | 271.09 | 271.11 | 271.02 | 271.04 | 42998.0 |
| 2019-02-07 08:10:00 | SPY | ETF | 271.05 | 271.07 | 270.68 | 270.72 | 111227.0 |
| 2019-02-07 08:15:00 | SPY | ETF | 270.74 | 270.8 | 270.65 | 270.78 | 121331.0 |
| 2019-02-07 08:20:00 | SPY | ETF | 270.8 | 270.9 | 270.79 | 270.84 | 31499.0 |
| 2019-02-07 08:25:00 | SPY | ETF | 270.84 | 270.99 | 270.84 | 270.97 | 41425.0 |
| 2019-02-07 08:30:00 | SPY | ETF | 270.98 | 271.1 | 270.95 | 271.06 | 45042.0 |
| 2019-02-07 08:35:00 | SPY | ETF | 271.06 | 271.07 | 271.0 | 271.07 | 33551.0 |
> showing 50 of 64,942 rows — these rows as CSV