PREVIEW / etf_5min / 2020-09-17
file: by_date/etf_5min/2020/2020-09-17.parquet size: 1.6 MB rows: 72,646
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-17 04:00:00 | SPY | ETF | 334.42 | 334.7 | 334.42 | 334.45 | 26211.0 |
| 2020-09-17 04:05:00 | SPY | ETF | 334.55 | 334.79 | 334.55 | 334.78 | 12497.0 |
| 2020-09-17 04:10:00 | SPY | ETF | 335.0 | 335.03 | 334.51 | 334.51 | 20247.0 |
| 2020-09-17 04:15:00 | SPY | ETF | 334.52 | 334.78 | 334.52 | 334.71 | 22098.0 |
| 2020-09-17 04:20:00 | SPY | ETF | 334.95 | 335.32 | 334.95 | 335.16 | 8705.0 |
| 2020-09-17 04:25:00 | SPY | ETF | 335.21 | 335.44 | 335.21 | 335.44 | 2822.0 |
| 2020-09-17 04:30:00 | SPY | ETF | 335.52 | 335.59 | 335.21 | 335.21 | 5303.0 |
| 2020-09-17 04:35:00 | SPY | ETF | 335.09 | 335.09 | 335.0 | 335.0 | 5936.0 |
| 2020-09-17 04:40:00 | SPY | ETF | 335.09 | 335.36 | 335.09 | 335.36 | 3455.0 |
| 2020-09-17 04:45:00 | SPY | ETF | 335.21 | 335.21 | 334.94 | 334.94 | 6283.0 |
| 2020-09-17 04:50:00 | SPY | ETF | 335.01 | 335.2 | 335.01 | 335.2 | 2817.0 |
| 2020-09-17 04:55:00 | SPY | ETF | 335.24 | 335.39 | 335.24 | 335.3 | 5479.0 |
| 2020-09-17 05:00:00 | SPY | ETF | 335.42 | 335.54 | 335.42 | 335.54 | 3546.0 |
| 2020-09-17 05:05:00 | SPY | ETF | 335.21 | 335.34 | 335.18 | 335.19 | 4652.0 |
| 2020-09-17 05:10:00 | SPY | ETF | 335.06 | 335.45 | 335.0 | 335.34 | 5208.0 |
| 2020-09-17 05:15:00 | SPY | ETF | 335.23 | 335.26 | 335.15 | 335.16 | 3486.0 |
| 2020-09-17 05:20:00 | SPY | ETF | 335.38 | 335.6 | 335.38 | 335.6 | 2656.0 |
| 2020-09-17 05:25:00 | SPY | ETF | 335.43 | 335.43 | 335.24 | 335.24 | 3311.0 |
| 2020-09-17 05:30:00 | SPY | ETF | 335.2 | 335.4 | 335.2 | 335.34 | 4464.0 |
| 2020-09-17 05:35:00 | SPY | ETF | 335.39 | 335.44 | 335.32 | 335.44 | 1640.0 |
| 2020-09-17 05:40:00 | SPY | ETF | 335.44 | 335.72 | 335.44 | 335.57 | 11112.0 |
| 2020-09-17 05:45:00 | SPY | ETF | 335.73 | 335.8 | 335.62 | 335.62 | 3845.0 |
| 2020-09-17 05:50:00 | SPY | ETF | 335.61 | 335.65 | 335.5 | 335.65 | 4780.0 |
| 2020-09-17 05:55:00 | SPY | ETF | 335.57 | 335.8 | 335.57 | 335.79 | 3700.0 |
| 2020-09-17 06:00:00 | SPY | ETF | 335.65 | 335.65 | 335.62 | 335.62 | 420.0 |
| 2020-09-17 06:05:00 | SPY | ETF | 335.49 | 335.7 | 335.49 | 335.6 | 16247.0 |
| 2020-09-17 06:10:00 | SPY | ETF | 335.45 | 335.48 | 335.25 | 335.42 | 16929.0 |
| 2020-09-17 06:15:00 | SPY | ETF | 335.35 | 335.37 | 335.25 | 335.29 | 6373.0 |
| 2020-09-17 06:20:00 | SPY | ETF | 335.4 | 335.46 | 335.39 | 335.46 | 2351.0 |
| 2020-09-17 06:25:00 | SPY | ETF | 335.56 | 335.56 | 335.53 | 335.53 | 4101.0 |
| 2020-09-17 06:30:00 | SPY | ETF | 335.6 | 335.86 | 335.6 | 335.75 | 2511.0 |
| 2020-09-17 06:35:00 | SPY | ETF | 335.68 | 335.68 | 335.65 | 335.65 | 308.0 |
| 2020-09-17 06:40:00 | SPY | ETF | 335.66 | 335.68 | 335.56 | 335.56 | 2729.0 |
| 2020-09-17 06:45:00 | SPY | ETF | 335.51 | 335.51 | 335.18 | 335.2 | 14722.0 |
| 2020-09-17 06:50:00 | SPY | ETF | 335.27 | 335.37 | 335.25 | 335.28 | 10034.0 |
| 2020-09-17 06:55:00 | SPY | ETF | 335.32 | 335.32 | 334.74 | 334.8 | 14643.0 |
| 2020-09-17 07:00:00 | SPY | ETF | 334.84 | 334.98 | 334.58 | 334.939 | 48123.0 |
| 2020-09-17 07:05:00 | SPY | ETF | 334.95 | 335.1 | 334.84 | 335.1 | 26551.0 |
| 2020-09-17 07:10:00 | SPY | ETF | 335.19 | 335.279 | 335.15 | 335.27 | 27778.0 |
| 2020-09-17 07:15:00 | SPY | ETF | 335.3 | 335.64 | 335.3 | 335.41 | 51045.0 |
| 2020-09-17 07:20:00 | SPY | ETF | 335.42 | 335.48 | 335.12 | 335.27 | 22230.0 |
| 2020-09-17 07:25:00 | SPY | ETF | 335.22 | 335.46 | 335.08 | 335.2 | 27520.0 |
| 2020-09-17 07:30:00 | SPY | ETF | 335.24 | 335.4 | 335.24 | 335.27 | 6578.0 |
| 2020-09-17 07:35:00 | SPY | ETF | 335.4 | 335.43 | 335.09 | 335.2 | 24914.0 |
| 2020-09-17 07:40:00 | SPY | ETF | 335.15 | 335.35 | 334.98 | 335.03 | 50908.0 |
| 2020-09-17 07:45:00 | SPY | ETF | 334.95 | 335.1 | 334.74 | 334.84 | 39502.0 |
| 2020-09-17 07:50:00 | SPY | ETF | 334.8 | 335.14 | 334.77 | 334.85 | 20255.0 |
| 2020-09-17 07:55:00 | SPY | ETF | 334.85 | 334.85 | 334.6 | 334.64 | 39025.0 |
| 2020-09-17 08:00:00 | SPY | ETF | 334.8301 | 336.64 | 333.5 | 334.3 | 100500.0 |
| 2020-09-17 08:05:00 | SPY | ETF | 334.3 | 334.32 | 333.88 | 333.95 | 100189.0 |
> showing 50 of 72,646 rows — these rows as CSV