PREVIEW / etf_5min / 2020-01-08
file: by_date/etf_5min/2020/2020-01-08.parquet size: 1.7 MB rows: 70,129
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-01-08 04:00:00 | SPY | ETF | 322.08 | 322.31 | 322.03 | 322.23 | 27808.0 |
| 2020-01-08 04:05:00 | SPY | ETF | 322.23 | 322.38 | 322.23 | 322.35 | 3570.0 |
| 2020-01-08 04:10:00 | SPY | ETF | 322.28 | 322.44 | 322.25 | 322.35 | 9305.0 |
| 2020-01-08 04:15:00 | SPY | ETF | 322.29 | 322.32 | 322.17 | 322.24 | 3084.0 |
| 2020-01-08 04:20:00 | SPY | ETF | 322.16 | 322.25 | 322.16 | 322.25 | 2179.0 |
| 2020-01-08 04:25:00 | SPY | ETF | 322.23 | 322.23 | 322.1 | 322.1 | 1168.0 |
| 2020-01-08 04:30:00 | SPY | ETF | 322.06 | 322.13 | 322.05 | 322.05 | 4884.0 |
| 2020-01-08 04:35:00 | SPY | ETF | 322.05 | 322.13 | 322.05 | 322.1 | 8620.0 |
| 2020-01-08 04:40:00 | SPY | ETF | 322.18 | 322.18 | 322.13 | 322.18 | 3029.0 |
| 2020-01-08 04:45:00 | SPY | ETF | 322.05 | 322.05 | 322.05 | 322.05 | 120.0 |
| 2020-01-08 04:50:00 | SPY | ETF | 322.08 | 322.26 | 322.08 | 322.26 | 852.0 |
| 2020-01-08 04:55:00 | SPY | ETF | 322.3 | 322.44 | 322.3 | 322.42 | 7802.0 |
| 2020-01-08 05:00:00 | SPY | ETF | 322.3 | 322.3 | 322.2 | 322.2 | 2038.0 |
| 2020-01-08 05:05:00 | SPY | ETF | 322.2 | 322.26 | 322.2 | 322.25 | 2915.0 |
| 2020-01-08 05:10:00 | SPY | ETF | 322.27 | 322.28 | 322.27 | 322.28 | 1178.0 |
| 2020-01-08 05:15:00 | SPY | ETF | 322.25 | 322.73 | 322.25 | 322.73 | 10456.0 |
| 2020-01-08 05:20:00 | SPY | ETF | 322.74 | 322.81 | 322.69 | 322.69 | 10966.0 |
| 2020-01-08 05:25:00 | SPY | ETF | 322.71 | 322.73 | 322.54 | 322.57 | 6660.0 |
| 2020-01-08 05:30:00 | SPY | ETF | 322.66 | 322.77 | 322.66 | 322.77 | 1341.0 |
| 2020-01-08 05:35:00 | SPY | ETF | 322.78 | 322.79 | 322.65 | 322.75 | 8290.0 |
| 2020-01-08 05:40:00 | SPY | ETF | 322.67 | 322.75 | 322.66 | 322.75 | 24339.0 |
| 2020-01-08 05:45:00 | SPY | ETF | 322.81 | 322.91 | 322.72 | 322.81 | 6385.0 |
| 2020-01-08 05:50:00 | SPY | ETF | 322.79 | 322.85 | 322.78 | 322.83 | 9359.0 |
| 2020-01-08 05:55:00 | SPY | ETF | 322.94 | 323.33 | 322.94 | 323.21 | 15894.0 |
| 2020-01-08 06:00:00 | SPY | ETF | 323.26 | 323.3 | 323.2 | 323.29 | 4815.0 |
| 2020-01-08 06:05:00 | SPY | ETF | 323.25 | 323.25 | 323.03 | 323.03 | 9228.0 |
| 2020-01-08 06:10:00 | SPY | ETF | 323.04 | 323.09 | 323.0 | 323.0 | 4285.0 |
| 2020-01-08 06:15:00 | SPY | ETF | 323.09 | 323.18 | 323.03 | 323.13 | 11394.0 |
| 2020-01-08 06:20:00 | SPY | ETF | 323.2 | 323.39 | 323.2 | 323.22 | 23288.0 |
| 2020-01-08 06:25:00 | SPY | ETF | 323.2 | 323.65 | 323.2 | 323.56 | 15661.0 |
| 2020-01-08 06:30:00 | SPY | ETF | 323.55 | 323.59 | 323.45 | 323.55 | 7762.0 |
| 2020-01-08 06:35:00 | SPY | ETF | 323.55 | 323.64 | 323.41 | 323.41 | 29505.0 |
| 2020-01-08 06:40:00 | SPY | ETF | 323.37 | 323.47 | 323.37 | 323.47 | 26005.0 |
| 2020-01-08 06:45:00 | SPY | ETF | 323.42 | 323.5 | 323.41 | 323.46 | 74715.0 |
| 2020-01-08 06:50:00 | SPY | ETF | 323.47 | 323.5 | 323.28 | 323.35 | 51207.0 |
| 2020-01-08 06:55:00 | SPY | ETF | 323.4 | 323.41 | 323.07 | 323.12 | 57590.0 |
| 2020-01-08 07:00:00 | SPY | ETF | 323.09 | 323.23 | 323.051 | 323.12 | 66773.0 |
| 2020-01-08 07:05:00 | SPY | ETF | 323.12 | 323.34 | 323.06 | 323.16 | 72589.0 |
| 2020-01-08 07:10:00 | SPY | ETF | 323.17 | 323.22 | 323.07 | 323.14 | 16418.0 |
| 2020-01-08 07:15:00 | SPY | ETF | 323.13 | 323.13 | 323.05 | 323.1 | 43099.0 |
| 2020-01-08 07:20:00 | SPY | ETF | 323.09 | 323.16 | 323.03 | 323.06 | 21135.0 |
| 2020-01-08 07:25:00 | SPY | ETF | 323.06 | 323.1 | 323.01 | 323.03 | 48251.0 |
| 2020-01-08 07:30:00 | SPY | ETF | 323.04 | 323.07 | 322.91 | 323.06 | 53118.0 |
| 2020-01-08 07:35:00 | SPY | ETF | 323.05 | 323.1 | 323.02 | 323.1 | 45591.0 |
| 2020-01-08 07:40:00 | SPY | ETF | 323.07 | 323.2 | 323.07 | 323.15 | 9939.0 |
| 2020-01-08 07:45:00 | SPY | ETF | 323.13 | 323.26 | 323.13 | 323.21 | 123742.0 |
| 2020-01-08 07:50:00 | SPY | ETF | 323.2 | 323.37 | 323.19 | 323.28 | 40684.0 |
| 2020-01-08 07:55:00 | SPY | ETF | 323.35 | 323.46 | 323.28 | 323.35 | 51910.0 |
| 2020-01-08 08:00:00 | SPY | ETF | 323.31 | 323.3801 | 320.89 | 323.25 | 400862.0 |
| 2020-01-08 08:05:00 | SPY | ETF | 323.27 | 323.3 | 323.2 | 323.22 | 16414.0 |
> showing 50 of 70,129 rows — these rows as CSV