PREVIEW / etf_5min / 2020-05-11
file: by_date/etf_5min/2020/2020-05-11.parquet size: 1.6 MB rows: 74,813
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-05-11 04:00:00 | SPY | ETF | 293.83 | 294.34 | 293.83 | 293.96 | 4927.0 |
| 2020-05-11 04:05:00 | SPY | ETF | 294.01 | 294.04 | 293.92 | 293.92 | 7420.0 |
| 2020-05-11 04:10:00 | SPY | ETF | 293.95 | 293.98 | 293.59 | 293.6 | 3675.0 |
| 2020-05-11 04:15:00 | SPY | ETF | 293.6 | 293.69 | 293.57 | 293.67 | 6945.0 |
| 2020-05-11 04:20:00 | SPY | ETF | 293.68 | 293.76 | 293.55 | 293.55 | 4252.0 |
| 2020-05-11 04:25:00 | SPY | ETF | 293.52 | 293.55 | 293.45 | 293.5 | 2562.0 |
| 2020-05-11 04:30:00 | SPY | ETF | 293.42 | 293.5 | 293.33 | 293.4 | 9606.0 |
| 2020-05-11 04:35:00 | SPY | ETF | 293.36 | 293.36 | 293.05 | 293.19 | 9834.0 |
| 2020-05-11 04:40:00 | SPY | ETF | 293.22 | 293.25 | 292.87 | 292.87 | 10931.0 |
| 2020-05-11 04:45:00 | SPY | ETF | 292.83 | 292.83 | 292.5 | 292.5 | 9303.0 |
| 2020-05-11 04:50:00 | SPY | ETF | 292.54 | 292.72 | 292.54 | 292.68 | 5620.0 |
| 2020-05-11 04:55:00 | SPY | ETF | 292.63 | 292.8 | 292.63 | 292.8 | 4713.0 |
| 2020-05-11 05:00:00 | SPY | ETF | 292.71 | 292.71 | 292.26 | 292.29 | 12530.0 |
| 2020-05-11 05:05:00 | SPY | ETF | 292.26 | 292.44 | 292.26 | 292.44 | 5770.0 |
| 2020-05-11 05:10:00 | SPY | ETF | 292.25 | 292.27 | 291.99 | 292.05 | 12531.0 |
| 2020-05-11 05:15:00 | SPY | ETF | 292.0 | 292.22 | 291.96 | 292.22 | 69543.0 |
| 2020-05-11 05:20:00 | SPY | ETF | 292.22 | 292.37 | 292.19 | 292.23 | 23686.0 |
| 2020-05-11 05:25:00 | SPY | ETF | 291.99 | 291.99 | 291.82 | 291.82 | 9046.0 |
| 2020-05-11 05:30:00 | SPY | ETF | 291.76 | 291.97 | 291.75 | 291.85 | 5770.0 |
| 2020-05-11 05:35:00 | SPY | ETF | 291.86 | 292.05 | 291.86 | 291.94 | 4901.0 |
| 2020-05-11 05:40:00 | SPY | ETF | 291.84 | 292.06 | 291.81 | 292.06 | 9955.0 |
| 2020-05-11 05:45:00 | SPY | ETF | 292.09 | 292.3 | 292.09 | 292.29 | 5131.0 |
| 2020-05-11 05:50:00 | SPY | ETF | 292.33 | 292.33 | 292.17 | 292.17 | 6157.0 |
| 2020-05-11 05:55:00 | SPY | ETF | 292.36 | 292.36 | 292.1 | 292.1 | 6096.0 |
| 2020-05-11 06:00:00 | SPY | ETF | 292.09 | 292.12 | 292.04 | 292.12 | 5041.0 |
| 2020-05-11 06:05:00 | SPY | ETF | 292.11 | 292.28 | 292.11 | 292.12 | 19960.0 |
| 2020-05-11 06:10:00 | SPY | ETF | 292.18 | 292.2 | 291.9 | 291.9 | 60618.0 |
| 2020-05-11 06:15:00 | SPY | ETF | 291.9 | 291.9 | 291.17 | 291.17 | 49680.0 |
| 2020-05-11 06:20:00 | SPY | ETF | 291.15 | 291.33 | 291.15 | 291.28 | 43611.0 |
| 2020-05-11 06:25:00 | SPY | ETF | 291.2 | 291.35 | 291.19 | 291.25 | 13105.0 |
| 2020-05-11 06:30:00 | SPY | ETF | 291.19 | 291.38 | 291.02 | 291.35 | 9300.0 |
| 2020-05-11 06:35:00 | SPY | ETF | 291.33 | 291.5 | 291.33 | 291.37 | 66515.0 |
| 2020-05-11 06:40:00 | SPY | ETF | 291.42 | 291.54 | 291.4 | 291.54 | 2995.0 |
| 2020-05-11 06:45:00 | SPY | ETF | 291.56 | 291.61 | 291.32 | 291.32 | 5590.0 |
| 2020-05-11 06:50:00 | SPY | ETF | 291.3 | 291.3 | 291.05 | 291.05 | 29575.0 |
| 2020-05-11 06:55:00 | SPY | ETF | 291.05 | 291.29 | 291.0 | 291.29 | 13619.0 |
| 2020-05-11 07:00:00 | SPY | ETF | 291.33 | 291.54 | 291.2 | 291.28 | 107697.0 |
| 2020-05-11 07:05:00 | SPY | ETF | 291.3 | 291.45 | 291.2 | 291.2 | 17418.0 |
| 2020-05-11 07:10:00 | SPY | ETF | 291.19 | 291.38 | 291.13 | 291.36 | 15622.0 |
| 2020-05-11 07:15:00 | SPY | ETF | 291.38 | 291.4 | 291.23 | 291.23 | 24386.0 |
| 2020-05-11 07:20:00 | SPY | ETF | 291.22 | 291.22 | 290.78 | 291.11 | 143312.0 |
| 2020-05-11 07:25:00 | SPY | ETF | 291.1 | 291.25 | 291.1 | 291.25 | 57148.0 |
| 2020-05-11 07:30:00 | SPY | ETF | 291.25 | 291.29 | 291.1 | 291.1 | 32360.0 |
| 2020-05-11 07:35:00 | SPY | ETF | 291.1 | 291.1 | 290.83 | 290.85 | 127076.0 |
| 2020-05-11 07:40:00 | SPY | ETF | 290.81 | 290.9 | 290.51 | 290.51 | 57167.0 |
| 2020-05-11 07:45:00 | SPY | ETF | 290.52 | 290.66 | 290.36 | 290.36 | 79371.0 |
| 2020-05-11 07:50:00 | SPY | ETF | 290.36 | 290.52 | 290.27 | 290.39 | 83668.0 |
| 2020-05-11 07:55:00 | SPY | ETF | 290.38 | 290.5 | 289.89 | 290.06 | 79188.0 |
| 2020-05-11 08:00:00 | SPY | ETF | 291.27 | 294.8 | 289.85 | 290.04 | 251852.0 |
| 2020-05-11 08:05:00 | SPY | ETF | 290.07 | 290.2 | 289.66 | 289.97 | 126796.0 |
> showing 50 of 74,813 rows — these rows as CSV