PREVIEW / etf_5min / 2019-01-18
file: by_date/etf_5min/2019/2019-01-18.parquet size: 1.5 MB rows: 66,075
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-01-18 04:00:00 | SPY | ETF | 263.56 | 263.61 | 263.51 | 263.61 | 51737.0 |
| 2019-01-18 04:05:00 | SPY | ETF | 263.5 | 263.69 | 263.5 | 263.69 | 25061.0 |
| 2019-01-18 04:10:00 | SPY | ETF | 263.6 | 263.65 | 263.6 | 263.65 | 669.0 |
| 2019-01-18 04:15:00 | SPY | ETF | 263.62 | 263.75 | 263.62 | 263.72 | 7007.0 |
| 2019-01-18 04:20:00 | SPY | ETF | 263.69 | 263.8 | 263.69 | 263.74 | 2331.0 |
| 2019-01-18 04:25:00 | SPY | ETF | 263.79 | 263.79 | 263.75 | 263.75 | 2619.0 |
| 2019-01-18 04:30:00 | SPY | ETF | 263.77 | 263.77 | 263.67 | 263.67 | 1977.0 |
| 2019-01-18 04:35:00 | SPY | ETF | 263.75 | 263.8 | 263.69 | 263.69 | 6534.0 |
| 2019-01-18 04:40:00 | SPY | ETF | 263.75 | 263.81 | 263.68 | 263.68 | 4407.0 |
| 2019-01-18 04:45:00 | SPY | ETF | 263.66 | 263.67 | 263.63 | 263.66 | 5087.0 |
| 2019-01-18 04:55:00 | SPY | ETF | 263.66 | 263.73 | 263.66 | 263.73 | 420.0 |
| 2019-01-18 05:00:00 | SPY | ETF | 263.74 | 263.79 | 263.74 | 263.79 | 2494.0 |
| 2019-01-18 05:05:00 | SPY | ETF | 263.79 | 263.82 | 263.7 | 263.7 | 3647.0 |
| 2019-01-18 05:10:00 | SPY | ETF | 263.7 | 263.72 | 263.61 | 263.72 | 3493.0 |
| 2019-01-18 05:15:00 | SPY | ETF | 263.69 | 263.69 | 263.69 | 263.69 | 1050.0 |
| 2019-01-18 05:20:00 | SPY | ETF | 263.61 | 263.69 | 263.61 | 263.63 | 1315.0 |
| 2019-01-18 05:25:00 | SPY | ETF | 263.64 | 263.64 | 263.41 | 263.5 | 5680.0 |
| 2019-01-18 05:30:00 | SPY | ETF | 263.47 | 263.5 | 263.43 | 263.5 | 2800.0 |
| 2019-01-18 05:35:00 | SPY | ETF | 263.41 | 263.41 | 263.34 | 263.38 | 2400.0 |
| 2019-01-18 05:40:00 | SPY | ETF | 263.44 | 263.45 | 263.44 | 263.45 | 550.0 |
| 2019-01-18 05:45:00 | SPY | ETF | 263.47 | 263.47 | 263.47 | 263.47 | 3200.0 |
| 2019-01-18 05:50:00 | SPY | ETF | 263.55 | 263.64 | 263.55 | 263.64 | 2005.0 |
| 2019-01-18 05:55:00 | SPY | ETF | 263.54 | 263.57 | 263.47 | 263.57 | 3400.0 |
| 2019-01-18 06:00:00 | SPY | ETF | 263.59 | 263.77 | 263.56 | 263.66 | 12854.0 |
| 2019-01-18 06:05:00 | SPY | ETF | 263.71 | 263.72 | 263.65 | 263.72 | 13600.0 |
| 2019-01-18 06:10:00 | SPY | ETF | 263.65 | 263.65 | 263.58 | 263.58 | 1700.0 |
| 2019-01-18 06:15:00 | SPY | ETF | 263.55 | 263.55 | 263.55 | 263.55 | 1000.0 |
| 2019-01-18 06:20:00 | SPY | ETF | 263.6 | 263.72 | 263.6 | 263.66 | 5800.0 |
| 2019-01-18 06:25:00 | SPY | ETF | 263.73 | 263.79 | 263.69 | 263.79 | 14860.0 |
| 2019-01-18 06:30:00 | SPY | ETF | 263.8 | 263.87 | 263.8 | 263.87 | 2909.0 |
| 2019-01-18 06:35:00 | SPY | ETF | 263.84 | 264.04 | 263.79 | 263.96 | 6846.0 |
| 2019-01-18 06:40:00 | SPY | ETF | 263.96 | 263.98 | 263.93 | 263.94 | 2325.0 |
| 2019-01-18 06:45:00 | SPY | ETF | 263.98 | 264.01 | 263.98 | 263.98 | 10456.0 |
| 2019-01-18 06:50:00 | SPY | ETF | 263.98 | 264.14 | 263.94 | 264.11 | 14782.0 |
| 2019-01-18 06:55:00 | SPY | ETF | 264.15 | 264.23 | 264.14 | 264.14 | 24832.0 |
| 2019-01-18 07:00:00 | SPY | ETF | 264.16 | 264.22 | 264.07 | 264.15 | 32209.0 |
| 2019-01-18 07:05:00 | SPY | ETF | 264.15 | 264.26 | 264.12 | 264.24 | 19945.0 |
| 2019-01-18 07:10:00 | SPY | ETF | 264.27 | 264.32 | 264.14 | 264.22 | 9629.0 |
| 2019-01-18 07:15:00 | SPY | ETF | 264.19 | 264.19 | 264.07 | 264.1 | 11508.0 |
| 2019-01-18 07:20:00 | SPY | ETF | 264.08 | 264.1 | 263.99 | 264.0 | 14789.0 |
| 2019-01-18 07:25:00 | SPY | ETF | 264.02 | 264.08 | 264.01 | 264.07 | 8288.0 |
| 2019-01-18 07:30:00 | SPY | ETF | 264.1 | 264.19 | 264.02 | 264.03 | 6891.0 |
| 2019-01-18 07:35:00 | SPY | ETF | 264.05 | 264.05 | 263.98 | 264.03 | 67219.0 |
| 2019-01-18 07:40:00 | SPY | ETF | 263.98 | 264.08 | 263.98 | 264.02 | 3607.0 |
| 2019-01-18 07:45:00 | SPY | ETF | 264.07 | 264.15 | 264.05 | 264.11 | 11117.0 |
| 2019-01-18 07:50:00 | SPY | ETF | 264.1 | 264.11 | 264.07 | 264.1 | 12254.0 |
| 2019-01-18 07:55:00 | SPY | ETF | 264.1 | 264.17 | 264.06 | 264.08 | 14814.0 |
| 2019-01-18 08:00:00 | SPY | ETF | 264.12 | 266.55 | 263.5 | 264.1 | 67574.0 |
| 2019-01-18 08:05:00 | SPY | ETF | 264.06 | 264.06 | 264.02 | 264.02 | 7960.0 |
| 2019-01-18 08:10:00 | SPY | ETF | 264.06 | 264.1 | 264.02 | 264.04 | 24999.0 |
> showing 50 of 66,075 rows — these rows as CSV