PREVIEW / etf_5min / 2020-02-25
file: by_date/etf_5min/2020/2020-02-25.parquet size: 1.9 MB rows: 81,207
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-02-25 04:00:00 | SPY | ETF | 324.2 | 324.57 | 324.2 | 324.5 | 7812.0 |
| 2020-02-25 04:05:00 | SPY | ETF | 324.26 | 324.26 | 323.99 | 323.99 | 7292.0 |
| 2020-02-25 04:10:00 | SPY | ETF | 323.89 | 323.9 | 323.43 | 323.62 | 24276.0 |
| 2020-02-25 04:15:00 | SPY | ETF | 323.61 | 323.72 | 323.5 | 323.62 | 4915.0 |
| 2020-02-25 04:20:00 | SPY | ETF | 323.62 | 323.63 | 323.45 | 323.45 | 17833.0 |
| 2020-02-25 04:25:00 | SPY | ETF | 323.38 | 323.69 | 323.35 | 323.68 | 5088.0 |
| 2020-02-25 04:30:00 | SPY | ETF | 323.52 | 323.77 | 323.44 | 323.77 | 558.0 |
| 2020-02-25 04:35:00 | SPY | ETF | 323.58 | 323.65 | 323.54 | 323.65 | 1451.0 |
| 2020-02-25 04:40:00 | SPY | ETF | 323.53 | 323.69 | 323.53 | 323.69 | 600.0 |
| 2020-02-25 04:45:00 | SPY | ETF | 323.75 | 323.75 | 323.7 | 323.7 | 1101.0 |
| 2020-02-25 04:50:00 | SPY | ETF | 323.61 | 323.61 | 323.4 | 323.55 | 9901.0 |
| 2020-02-25 04:55:00 | SPY | ETF | 323.44 | 323.45 | 323.33 | 323.33 | 2201.0 |
| 2020-02-25 05:00:00 | SPY | ETF | 323.35 | 323.55 | 323.35 | 323.55 | 2085.0 |
| 2020-02-25 05:05:00 | SPY | ETF | 323.44 | 323.45 | 323.3 | 323.3 | 2478.0 |
| 2020-02-25 05:10:00 | SPY | ETF | 323.34 | 323.41 | 323.12 | 323.12 | 7796.0 |
| 2020-02-25 05:15:00 | SPY | ETF | 323.2 | 323.2 | 323.05 | 323.05 | 2699.0 |
| 2020-02-25 05:20:00 | SPY | ETF | 323.0 | 323.22 | 323.0 | 323.0 | 6623.0 |
| 2020-02-25 05:25:00 | SPY | ETF | 322.97 | 323.04 | 322.82 | 322.88 | 12154.0 |
| 2020-02-25 05:30:00 | SPY | ETF | 322.8 | 322.85 | 322.6 | 322.77 | 7893.0 |
| 2020-02-25 05:35:00 | SPY | ETF | 322.71 | 322.98 | 322.68 | 322.68 | 7306.0 |
| 2020-02-25 05:40:00 | SPY | ETF | 322.59 | 322.69 | 322.38 | 322.39 | 16035.0 |
| 2020-02-25 05:45:00 | SPY | ETF | 322.38 | 322.56 | 321.92 | 322.56 | 34985.0 |
| 2020-02-25 05:50:00 | SPY | ETF | 322.42 | 322.59 | 322.39 | 322.44 | 7050.0 |
| 2020-02-25 05:55:00 | SPY | ETF | 322.65 | 323.01 | 322.65 | 322.85 | 15172.0 |
| 2020-02-25 06:00:00 | SPY | ETF | 322.69 | 322.69 | 322.46 | 322.6 | 5934.0 |
| 2020-02-25 06:05:00 | SPY | ETF | 322.68 | 322.68 | 322.41 | 322.62 | 11475.0 |
| 2020-02-25 06:10:00 | SPY | ETF | 322.66 | 322.86 | 322.66 | 322.86 | 5801.0 |
| 2020-02-25 06:15:00 | SPY | ETF | 322.84 | 322.9 | 322.41 | 322.48 | 4543.0 |
| 2020-02-25 06:20:00 | SPY | ETF | 322.48 | 322.63 | 322.44 | 322.62 | 2351.0 |
| 2020-02-25 06:25:00 | SPY | ETF | 322.52 | 322.9 | 322.44 | 322.9 | 9190.0 |
| 2020-02-25 06:30:00 | SPY | ETF | 322.9 | 323.3 | 322.77 | 323.29 | 28305.0 |
| 2020-02-25 06:35:00 | SPY | ETF | 323.34 | 323.75 | 323.32 | 323.65 | 91460.0 |
| 2020-02-25 06:40:00 | SPY | ETF | 323.68 | 323.68 | 323.32 | 323.44 | 12740.0 |
| 2020-02-25 06:45:00 | SPY | ETF | 323.35 | 323.52 | 323.21 | 323.44 | 36252.0 |
| 2020-02-25 06:50:00 | SPY | ETF | 323.44 | 323.65 | 323.42 | 323.46 | 7959.0 |
| 2020-02-25 06:55:00 | SPY | ETF | 323.4 | 323.43 | 323.17 | 323.23 | 7228.0 |
| 2020-02-25 07:00:00 | SPY | ETF | 323.23 | 323.49 | 323.18 | 323.49 | 20311.0 |
| 2020-02-25 07:05:00 | SPY | ETF | 323.51 | 323.63 | 323.2 | 323.2 | 19314.0 |
| 2020-02-25 07:10:00 | SPY | ETF | 323.17 | 323.17 | 322.8 | 322.91 | 81896.0 |
| 2020-02-25 07:15:00 | SPY | ETF | 322.92 | 323.21 | 322.91 | 323.16 | 43562.0 |
| 2020-02-25 07:20:00 | SPY | ETF | 323.12 | 323.9 | 323.12 | 323.47 | 80320.0 |
| 2020-02-25 07:25:00 | SPY | ETF | 323.58 | 323.75 | 323.44 | 323.46 | 77325.0 |
| 2020-02-25 07:30:00 | SPY | ETF | 323.42 | 323.64 | 323.3 | 323.62 | 36426.0 |
| 2020-02-25 07:35:00 | SPY | ETF | 323.6 | 324.0 | 323.6 | 323.97 | 55273.0 |
| 2020-02-25 07:40:00 | SPY | ETF | 323.95 | 323.95 | 323.69 | 323.92 | 35133.0 |
| 2020-02-25 07:45:00 | SPY | ETF | 323.9 | 324.27 | 323.9 | 324.2 | 59256.0 |
| 2020-02-25 07:50:00 | SPY | ETF | 324.24 | 324.34 | 323.99 | 324.34 | 30408.0 |
| 2020-02-25 07:55:00 | SPY | ETF | 324.3 | 324.3 | 324.08 | 324.18 | 26930.0 |
| 2020-02-25 08:00:00 | SPY | ETF | 324.19 | 325.53 | 322.8 | 324.47 | 172046.0 |
| 2020-02-25 08:05:00 | SPY | ETF | 323.84 | 324.14 | 322.42 | 324.14 | 104425.0 |
> showing 50 of 81,207 rows — these rows as CSV