PREVIEW / etf_5min / 2019-03-11
file: by_date/etf_5min/2019/2019-03-11.parquet size: 1.4 MB rows: 62,600
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-03-11 04:00:00 | SPY | ETF | 275.33 | 275.41 | 275.29 | 275.41 | 1986.0 |
| 2019-03-11 04:05:00 | SPY | ETF | 275.36 | 275.36 | 275.32 | 275.32 | 500.0 |
| 2019-03-11 04:10:00 | SPY | ETF | 275.28 | 275.3 | 275.28 | 275.28 | 1200.0 |
| 2019-03-11 04:15:00 | SPY | ETF | 275.25 | 275.25 | 275.22 | 275.22 | 333.0 |
| 2019-03-11 04:25:00 | SPY | ETF | 275.22 | 275.22 | 275.22 | 275.22 | 493.0 |
| 2019-03-11 04:40:00 | SPY | ETF | 275.08 | 275.08 | 275.08 | 275.08 | 454.0 |
| 2019-03-11 04:45:00 | SPY | ETF | 275.03 | 275.03 | 275.03 | 275.03 | 390.0 |
| 2019-03-11 04:50:00 | SPY | ETF | 275.04 | 275.04 | 275.0 | 275.0 | 705.0 |
| 2019-03-11 04:55:00 | SPY | ETF | 274.98 | 274.98 | 274.98 | 274.98 | 303.0 |
| 2019-03-11 05:05:00 | SPY | ETF | 274.94 | 274.94 | 274.94 | 274.94 | 100.0 |
| 2019-03-11 05:10:00 | SPY | ETF | 274.94 | 274.94 | 274.94 | 274.94 | 110.0 |
| 2019-03-11 05:15:00 | SPY | ETF | 274.92 | 274.92 | 274.92 | 274.92 | 210.0 |
| 2019-03-11 05:20:00 | SPY | ETF | 275.04 | 275.04 | 275.04 | 275.04 | 1210.0 |
| 2019-03-11 05:25:00 | SPY | ETF | 275.09 | 275.15 | 275.09 | 275.15 | 3000.0 |
| 2019-03-11 05:35:00 | SPY | ETF | 275.15 | 275.15 | 275.15 | 275.15 | 805.0 |
| 2019-03-11 05:40:00 | SPY | ETF | 275.15 | 275.17 | 275.15 | 275.17 | 400.0 |
| 2019-03-11 05:50:00 | SPY | ETF | 275.15 | 275.2 | 275.14 | 275.2 | 3605.0 |
| 2019-03-11 05:55:00 | SPY | ETF | 275.25 | 275.25 | 275.25 | 275.25 | 550.0 |
| 2019-03-11 06:00:00 | SPY | ETF | 275.32 | 275.32 | 275.21 | 275.21 | 1600.0 |
| 2019-03-11 06:05:00 | SPY | ETF | 275.33 | 275.33 | 275.2 | 275.2 | 2180.0 |
| 2019-03-11 06:10:00 | SPY | ETF | 275.2 | 275.22 | 275.2 | 275.22 | 2550.0 |
| 2019-03-11 06:15:00 | SPY | ETF | 275.12 | 275.17 | 275.12 | 275.17 | 400.0 |
| 2019-03-11 06:25:00 | SPY | ETF | 275.24 | 275.24 | 275.24 | 275.24 | 100.0 |
| 2019-03-11 06:35:00 | SPY | ETF | 275.21 | 275.21 | 275.04 | 275.04 | 6425.0 |
| 2019-03-11 06:40:00 | SPY | ETF | 275.04 | 275.04 | 275.03 | 275.04 | 2368.0 |
| 2019-03-11 06:45:00 | SPY | ETF | 275.05 | 275.1 | 275.0 | 275.0 | 2500.0 |
| 2019-03-11 06:50:00 | SPY | ETF | 275.08 | 275.19 | 275.08 | 275.12 | 1820.0 |
| 2019-03-11 06:55:00 | SPY | ETF | 275.15 | 275.25 | 275.15 | 275.2 | 2070.0 |
| 2019-03-11 07:00:00 | SPY | ETF | 275.22 | 275.22 | 275.15 | 275.2 | 4330.0 |
| 2019-03-11 07:05:00 | SPY | ETF | 275.22 | 275.22 | 275.13 | 275.13 | 17130.0 |
| 2019-03-11 07:10:00 | SPY | ETF | 275.1 | 275.16 | 275.1 | 275.11 | 3513.0 |
| 2019-03-11 07:15:00 | SPY | ETF | 275.13 | 275.13 | 275.07 | 275.11 | 16854.0 |
| 2019-03-11 07:20:00 | SPY | ETF | 275.11 | 275.12 | 275.1 | 275.12 | 1934.0 |
| 2019-03-11 07:25:00 | SPY | ETF | 275.13 | 275.16 | 275.13 | 275.15 | 1903.0 |
| 2019-03-11 07:30:00 | SPY | ETF | 275.2 | 275.3 | 275.2 | 275.29 | 2155.0 |
| 2019-03-11 07:35:00 | SPY | ETF | 275.29 | 275.47 | 275.29 | 275.44 | 14063.0 |
| 2019-03-11 07:40:00 | SPY | ETF | 275.45 | 275.45 | 275.31 | 275.31 | 16285.0 |
| 2019-03-11 07:45:00 | SPY | ETF | 275.36 | 275.36 | 275.36 | 275.36 | 100.0 |
| 2019-03-11 07:50:00 | SPY | ETF | 275.32 | 275.4 | 275.32 | 275.39 | 4427.0 |
| 2019-03-11 07:55:00 | SPY | ETF | 275.38 | 275.38 | 275.29 | 275.29 | 7812.0 |
| 2019-03-11 08:00:00 | SPY | ETF | 275.22 | 275.5 | 275.01 | 275.22 | 28898.0 |
| 2019-03-11 08:05:00 | SPY | ETF | 275.21 | 275.23 | 275.19 | 275.19 | 3880.0 |
| 2019-03-11 08:10:00 | SPY | ETF | 275.19 | 275.24 | 275.18 | 275.22 | 19785.0 |
| 2019-03-11 08:15:00 | SPY | ETF | 275.22 | 275.23 | 275.16 | 275.2 | 24010.0 |
| 2019-03-11 08:20:00 | SPY | ETF | 275.19 | 275.19 | 275.14 | 275.14 | 14611.0 |
| 2019-03-11 08:25:00 | SPY | ETF | 275.16 | 275.28 | 275.14 | 275.15 | 19805.0 |
| 2019-03-11 08:30:00 | SPY | ETF | 275.17 | 275.43 | 275.17 | 275.3 | 83146.0 |
| 2019-03-11 08:35:00 | SPY | ETF | 275.32 | 275.62 | 275.32 | 275.57 | 67874.0 |
| 2019-03-11 08:40:00 | SPY | ETF | 275.55 | 275.62 | 275.51 | 275.62 | 41412.0 |
| 2019-03-11 08:45:00 | SPY | ETF | 275.6 | 275.7 | 275.58 | 275.58 | 32361.0 |
> showing 50 of 62,600 rows — these rows as CSV