PREVIEW / etf_5min / 2019-04-18
file: by_date/etf_5min/2019/2019-04-18.parquet size: 1.4 MB rows: 61,456
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-04-18 04:00:00 | SPY | ETF | 288.68 | 288.68 | 288.1 | 288.29 | 3899.0 |
| 2019-04-18 04:05:00 | SPY | ETF | 288.37 | 288.41 | 288.3 | 288.37 | 2169.0 |
| 2019-04-18 04:10:00 | SPY | ETF | 288.4 | 288.4 | 288.4 | 288.4 | 150.0 |
| 2019-04-18 04:15:00 | SPY | ETF | 288.48 | 288.48 | 288.48 | 288.48 | 320.0 |
| 2019-04-18 04:20:00 | SPY | ETF | 288.48 | 288.48 | 288.48 | 288.48 | 100.0 |
| 2019-04-18 04:25:00 | SPY | ETF | 288.5 | 288.5 | 288.5 | 288.5 | 100.0 |
| 2019-04-18 04:45:00 | SPY | ETF | 288.68 | 288.68 | 288.68 | 288.68 | 500.0 |
| 2019-04-18 04:50:00 | SPY | ETF | 288.65 | 288.71 | 288.65 | 288.71 | 600.0 |
| 2019-04-18 05:05:00 | SPY | ETF | 288.63 | 288.63 | 288.63 | 288.63 | 100.0 |
| 2019-04-18 05:35:00 | SPY | ETF | 288.85 | 288.85 | 288.85 | 288.85 | 430.0 |
| 2019-04-18 05:40:00 | SPY | ETF | 288.89 | 288.89 | 288.89 | 288.89 | 300.0 |
| 2019-04-18 05:45:00 | SPY | ETF | 289.0 | 289.1 | 289.0 | 289.1 | 887.0 |
| 2019-04-18 05:50:00 | SPY | ETF | 289.2 | 289.33 | 289.13 | 289.18 | 2625.0 |
| 2019-04-18 05:55:00 | SPY | ETF | 289.1 | 289.1 | 289.1 | 289.1 | 170.0 |
| 2019-04-18 06:00:00 | SPY | ETF | 288.98 | 288.98 | 288.93 | 288.93 | 600.0 |
| 2019-04-18 06:05:00 | SPY | ETF | 288.98 | 288.98 | 288.96 | 288.96 | 1020.0 |
| 2019-04-18 06:10:00 | SPY | ETF | 289.06 | 289.06 | 288.98 | 288.98 | 4000.0 |
| 2019-04-18 06:15:00 | SPY | ETF | 288.99 | 288.99 | 288.99 | 288.99 | 300.0 |
| 2019-04-18 06:20:00 | SPY | ETF | 289.01 | 289.08 | 289.01 | 289.08 | 494.0 |
| 2019-04-18 06:25:00 | SPY | ETF | 289.06 | 289.06 | 289.05 | 289.05 | 1300.0 |
| 2019-04-18 06:30:00 | SPY | ETF | 289.15 | 289.15 | 289.13 | 289.13 | 789.0 |
| 2019-04-18 06:35:00 | SPY | ETF | 289.11 | 289.11 | 289.11 | 289.11 | 300.0 |
| 2019-04-18 06:40:00 | SPY | ETF | 289.01 | 289.01 | 289.0 | 289.0 | 1600.0 |
| 2019-04-18 06:45:00 | SPY | ETF | 288.96 | 289.0 | 288.96 | 289.0 | 1450.0 |
| 2019-04-18 06:50:00 | SPY | ETF | 289.01 | 289.01 | 288.98 | 288.98 | 3000.0 |
| 2019-04-18 06:55:00 | SPY | ETF | 288.98 | 289.03 | 288.98 | 289.03 | 605.0 |
| 2019-04-18 07:00:00 | SPY | ETF | 288.99 | 289.0 | 288.99 | 289.0 | 711.0 |
| 2019-04-18 07:05:00 | SPY | ETF | 289.0 | 289.0 | 288.99 | 289.0 | 17977.0 |
| 2019-04-18 07:10:00 | SPY | ETF | 289.0 | 289.0 | 288.96 | 288.96 | 12995.0 |
| 2019-04-18 07:15:00 | SPY | ETF | 288.96 | 289.0 | 288.96 | 289.0 | 1400.0 |
| 2019-04-18 07:20:00 | SPY | ETF | 288.99 | 289.06 | 288.95 | 289.03 | 25800.0 |
| 2019-04-18 07:25:00 | SPY | ETF | 289.03 | 289.1 | 289.02 | 289.1 | 23891.0 |
| 2019-04-18 07:30:00 | SPY | ETF | 289.11 | 289.16 | 289.1 | 289.11 | 26100.0 |
| 2019-04-18 07:35:00 | SPY | ETF | 289.08 | 289.08 | 288.98 | 289.04 | 66900.0 |
| 2019-04-18 07:40:00 | SPY | ETF | 289.0 | 289.0 | 288.98 | 288.98 | 13500.0 |
| 2019-04-18 07:45:00 | SPY | ETF | 288.98 | 289.04 | 288.97 | 289.04 | 53400.0 |
| 2019-04-18 07:50:00 | SPY | ETF | 289.05 | 289.08 | 289.05 | 289.08 | 4978.0 |
| 2019-04-18 07:55:00 | SPY | ETF | 289.08 | 289.3 | 289.08 | 289.26 | 73964.0 |
| 2019-04-18 08:00:00 | SPY | ETF | 288.98 | 289.43 | 288.49 | 289.36 | 60448.0 |
| 2019-04-18 08:05:00 | SPY | ETF | 289.36 | 289.47 | 289.34 | 289.43 | 23998.0 |
| 2019-04-18 08:10:00 | SPY | ETF | 289.45 | 289.48 | 289.36 | 289.38 | 16194.0 |
| 2019-04-18 08:15:00 | SPY | ETF | 289.4 | 289.45 | 289.35 | 289.45 | 18175.0 |
| 2019-04-18 08:20:00 | SPY | ETF | 289.45 | 289.5 | 289.44 | 289.5 | 19857.0 |
| 2019-04-18 08:25:00 | SPY | ETF | 289.5 | 289.58 | 289.49 | 289.55 | 38747.0 |
| 2019-04-18 08:30:00 | SPY | ETF | 289.54 | 289.98 | 289.54 | 289.63 | 273589.0 |
| 2019-04-18 08:35:00 | SPY | ETF | 289.63 | 289.66 | 289.55 | 289.56 | 65490.0 |
| 2019-04-18 08:40:00 | SPY | ETF | 289.58 | 289.7 | 289.53 | 289.53 | 41509.0 |
| 2019-04-18 08:45:00 | SPY | ETF | 289.58 | 289.71 | 289.58 | 289.62 | 33078.0 |
| 2019-04-18 08:50:00 | SPY | ETF | 289.6 | 289.6 | 289.56 | 289.59 | 16448.0 |
| 2019-04-18 08:55:00 | SPY | ETF | 289.61 | 289.77 | 289.61 | 289.77 | 39844.0 |
> showing 50 of 61,456 rows — these rows as CSV