PREVIEW / etf_5min / 2019-02-22
file: by_date/etf_5min/2019/2019-02-22.parquet size: 1.4 MB rows: 62,307
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-22 04:00:00 | SPY | ETF | 278.02 | 278.19 | 278.02 | 278.19 | 1156.0 |
| 2019-02-22 04:05:00 | SPY | ETF | 278.06 | 278.19 | 278.06 | 278.19 | 756.0 |
| 2019-02-22 04:10:00 | SPY | ETF | 278.16 | 278.16 | 278.16 | 278.16 | 306.0 |
| 2019-02-22 04:15:00 | SPY | ETF | 278.1 | 278.35 | 278.1 | 278.35 | 4357.0 |
| 2019-02-22 04:25:00 | SPY | ETF | 278.15 | 278.15 | 278.14 | 278.14 | 2000.0 |
| 2019-02-22 04:30:00 | SPY | ETF | 278.13 | 278.18 | 278.13 | 278.18 | 900.0 |
| 2019-02-22 04:35:00 | SPY | ETF | 278.18 | 278.18 | 278.18 | 278.18 | 620.0 |
| 2019-02-22 04:40:00 | SPY | ETF | 278.15 | 278.15 | 278.13 | 278.13 | 2400.0 |
| 2019-02-22 04:45:00 | SPY | ETF | 278.1 | 278.14 | 278.09 | 278.1 | 3207.0 |
| 2019-02-22 04:50:00 | SPY | ETF | 278.24 | 278.24 | 278.24 | 278.24 | 123.0 |
| 2019-02-22 04:55:00 | SPY | ETF | 278.17 | 278.2 | 278.08 | 278.2 | 2245.0 |
| 2019-02-22 05:00:00 | SPY | ETF | 278.13 | 278.14 | 278.13 | 278.14 | 524.0 |
| 2019-02-22 05:05:00 | SPY | ETF | 278.18 | 278.25 | 278.18 | 278.25 | 2500.0 |
| 2019-02-22 05:15:00 | SPY | ETF | 278.25 | 278.25 | 278.25 | 278.25 | 303.0 |
| 2019-02-22 05:20:00 | SPY | ETF | 278.26 | 278.26 | 278.24 | 278.24 | 3300.0 |
| 2019-02-22 05:25:00 | SPY | ETF | 278.23 | 278.23 | 278.2 | 278.2 | 1000.0 |
| 2019-02-22 05:30:00 | SPY | ETF | 278.3 | 278.3 | 278.3 | 278.3 | 300.0 |
| 2019-02-22 05:35:00 | SPY | ETF | 278.26 | 278.26 | 278.26 | 278.26 | 600.0 |
| 2019-02-22 05:40:00 | SPY | ETF | 278.28 | 278.33 | 278.28 | 278.33 | 1200.0 |
| 2019-02-22 05:45:00 | SPY | ETF | 278.38 | 278.38 | 278.35 | 278.37 | 1800.0 |
| 2019-02-22 05:50:00 | SPY | ETF | 278.39 | 278.52 | 278.39 | 278.52 | 5226.0 |
| 2019-02-22 05:55:00 | SPY | ETF | 278.47 | 278.47 | 278.41 | 278.41 | 1105.0 |
| 2019-02-22 06:00:00 | SPY | ETF | 278.49 | 278.49 | 278.49 | 278.49 | 200.0 |
| 2019-02-22 06:05:00 | SPY | ETF | 278.42 | 278.42 | 278.42 | 278.42 | 1000.0 |
| 2019-02-22 06:10:00 | SPY | ETF | 278.38 | 278.38 | 278.38 | 278.38 | 1750.0 |
| 2019-02-22 06:15:00 | SPY | ETF | 278.43 | 278.43 | 278.43 | 278.43 | 200.0 |
| 2019-02-22 06:25:00 | SPY | ETF | 278.54 | 278.54 | 278.47 | 278.47 | 630.0 |
| 2019-02-22 06:30:00 | SPY | ETF | 278.44 | 278.44 | 278.4 | 278.4 | 600.0 |
| 2019-02-22 06:35:00 | SPY | ETF | 278.5 | 278.6 | 278.5 | 278.54 | 11200.0 |
| 2019-02-22 06:40:00 | SPY | ETF | 278.64 | 278.64 | 278.63 | 278.63 | 631.0 |
| 2019-02-22 06:45:00 | SPY | ETF | 278.53 | 278.53 | 278.49 | 278.5 | 11150.0 |
| 2019-02-22 06:50:00 | SPY | ETF | 278.46 | 278.47 | 278.46 | 278.47 | 485.0 |
| 2019-02-22 06:55:00 | SPY | ETF | 278.5 | 278.5 | 278.5 | 278.5 | 100.0 |
| 2019-02-22 07:00:00 | SPY | ETF | 278.57 | 278.6 | 278.47 | 278.53 | 12048.0 |
| 2019-02-22 07:05:00 | SPY | ETF | 278.51 | 278.63 | 278.5 | 278.63 | 10223.0 |
| 2019-02-22 07:10:00 | SPY | ETF | 278.63 | 278.65 | 278.63 | 278.65 | 575.0 |
| 2019-02-22 07:15:00 | SPY | ETF | 278.59 | 278.61 | 278.57 | 278.57 | 11800.0 |
| 2019-02-22 07:20:00 | SPY | ETF | 278.52 | 278.55 | 278.52 | 278.55 | 11942.0 |
| 2019-02-22 07:25:00 | SPY | ETF | 278.58 | 278.58 | 278.46 | 278.46 | 6488.0 |
| 2019-02-22 07:30:00 | SPY | ETF | 278.46 | 278.5 | 278.46 | 278.47 | 5518.0 |
| 2019-02-22 07:35:00 | SPY | ETF | 278.49 | 278.49 | 278.45 | 278.45 | 8367.0 |
| 2019-02-22 07:40:00 | SPY | ETF | 278.45 | 278.51 | 278.45 | 278.51 | 13944.0 |
| 2019-02-22 07:45:00 | SPY | ETF | 278.49 | 278.49 | 278.4 | 278.44 | 6538.0 |
| 2019-02-22 07:50:00 | SPY | ETF | 278.43 | 278.45 | 278.42 | 278.42 | 12754.0 |
| 2019-02-22 07:55:00 | SPY | ETF | 278.42 | 278.45 | 278.42 | 278.45 | 3192.0 |
| 2019-02-22 08:00:00 | SPY | ETF | 278.46 | 278.61 | 277.39 | 278.5 | 22474.0 |
| 2019-02-22 08:05:00 | SPY | ETF | 278.5 | 278.5 | 278.48 | 278.49 | 4925.0 |
| 2019-02-22 08:10:00 | SPY | ETF | 278.48 | 278.5 | 278.47 | 278.48 | 37263.0 |
| 2019-02-22 08:15:00 | SPY | ETF | 278.48 | 278.5 | 278.43 | 278.49 | 12268.0 |
| 2019-02-22 08:20:00 | SPY | ETF | 278.49 | 278.5 | 278.44 | 278.47 | 14325.0 |
> showing 50 of 62,307 rows — these rows as CSV