PREVIEW / etf_5min / 2020-06-12
file: by_date/etf_5min/2020/2020-06-12.parquet size: 1.7 MB rows: 79,307
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-06-12 04:00:00 | SPY | ETF | 304.43 | 305.0 | 304.43 | 305.0 | 48474.0 |
| 2020-06-12 04:05:00 | SPY | ETF | 305.0 | 305.52 | 305.0 | 305.32 | 27083.0 |
| 2020-06-12 04:10:00 | SPY | ETF | 305.36 | 305.52 | 305.2 | 305.27 | 30827.0 |
| 2020-06-12 04:15:00 | SPY | ETF | 305.12 | 305.86 | 305.12 | 305.77 | 20864.0 |
| 2020-06-12 04:20:00 | SPY | ETF | 305.75 | 306.0 | 305.61 | 305.66 | 19741.0 |
| 2020-06-12 04:25:00 | SPY | ETF | 305.87 | 306.04 | 305.83 | 305.9 | 16610.0 |
| 2020-06-12 04:30:00 | SPY | ETF | 305.9 | 306.04 | 305.83 | 306.0 | 34375.0 |
| 2020-06-12 04:35:00 | SPY | ETF | 306.06 | 306.35 | 305.98 | 306.35 | 8203.0 |
| 2020-06-12 04:40:00 | SPY | ETF | 306.32 | 306.6 | 306.31 | 306.51 | 26211.0 |
| 2020-06-12 04:45:00 | SPY | ETF | 306.56 | 307.0 | 306.56 | 306.98 | 42783.0 |
| 2020-06-12 04:50:00 | SPY | ETF | 306.97 | 307.09 | 306.54 | 306.54 | 30235.0 |
| 2020-06-12 04:55:00 | SPY | ETF | 306.65 | 306.97 | 306.58 | 306.72 | 70748.0 |
| 2020-06-12 05:00:00 | SPY | ETF | 306.81 | 306.81 | 306.4 | 306.63 | 71402.0 |
| 2020-06-12 05:05:00 | SPY | ETF | 306.61 | 306.8 | 306.53 | 306.74 | 63683.0 |
| 2020-06-12 05:10:00 | SPY | ETF | 306.74 | 306.91 | 306.49 | 306.87 | 81931.0 |
| 2020-06-12 05:15:00 | SPY | ETF | 306.86 | 306.98 | 306.8 | 306.88 | 34470.0 |
| 2020-06-12 05:20:00 | SPY | ETF | 306.88 | 307.05 | 306.77 | 306.86 | 42832.0 |
| 2020-06-12 05:25:00 | SPY | ETF | 306.86 | 307.0 | 306.65 | 306.87 | 42499.0 |
| 2020-06-12 05:30:00 | SPY | ETF | 306.87 | 306.91 | 306.52 | 306.65 | 59065.0 |
| 2020-06-12 05:35:00 | SPY | ETF | 306.62 | 306.68 | 306.44 | 306.66 | 96985.0 |
| 2020-06-12 05:40:00 | SPY | ETF | 306.9 | 306.92 | 306.73 | 306.76 | 25320.0 |
| 2020-06-12 05:45:00 | SPY | ETF | 306.92 | 307.05 | 306.48 | 307.02 | 25173.0 |
| 2020-06-12 05:50:00 | SPY | ETF | 307.02 | 307.22 | 306.96 | 307.1 | 78198.0 |
| 2020-06-12 05:55:00 | SPY | ETF | 307.1 | 307.39 | 307.06 | 307.32 | 76591.0 |
| 2020-06-12 06:00:00 | SPY | ETF | 307.26 | 307.4 | 307.02 | 307.34 | 37811.0 |
| 2020-06-12 06:05:00 | SPY | ETF | 307.41 | 307.6 | 307.0 | 307.1 | 31811.0 |
| 2020-06-12 06:10:00 | SPY | ETF | 307.12 | 307.52 | 307.12 | 307.45 | 17345.0 |
| 2020-06-12 06:15:00 | SPY | ETF | 307.43 | 307.6 | 307.2 | 307.2 | 33959.0 |
| 2020-06-12 06:20:00 | SPY | ETF | 307.23 | 307.36 | 307.07 | 307.22 | 41309.0 |
| 2020-06-12 06:25:00 | SPY | ETF | 307.26 | 307.4 | 307.03 | 307.03 | 23887.0 |
| 2020-06-12 06:30:00 | SPY | ETF | 307.02 | 307.07 | 306.35 | 306.48 | 73136.0 |
| 2020-06-12 06:35:00 | SPY | ETF | 306.5 | 306.73 | 306.35 | 306.5 | 66941.0 |
| 2020-06-12 06:40:00 | SPY | ETF | 306.35 | 306.54 | 306.28 | 306.37 | 33809.0 |
| 2020-06-12 06:45:00 | SPY | ETF | 306.39 | 306.4 | 305.9 | 306.25 | 66005.0 |
| 2020-06-12 06:50:00 | SPY | ETF | 306.2 | 306.47 | 306.19 | 306.41 | 68492.0 |
| 2020-06-12 06:55:00 | SPY | ETF | 306.45 | 306.88 | 306.41 | 306.61 | 53157.0 |
| 2020-06-12 07:00:00 | SPY | ETF | 306.61 | 307.09 | 306.6 | 306.96 | 117674.0 |
| 2020-06-12 07:05:00 | SPY | ETF | 306.97 | 307.15 | 306.94 | 307.06 | 62658.0 |
| 2020-06-12 07:10:00 | SPY | ETF | 307.01 | 307.35 | 306.8 | 307.0 | 64710.0 |
| 2020-06-12 07:15:00 | SPY | ETF | 307.0 | 307.42 | 307.0 | 307.04 | 61979.0 |
| 2020-06-12 07:20:00 | SPY | ETF | 307.06 | 307.09 | 306.65 | 306.85 | 55894.0 |
| 2020-06-12 07:25:00 | SPY | ETF | 306.86 | 307.29 | 306.66 | 306.94 | 101936.0 |
| 2020-06-12 07:30:00 | SPY | ETF | 306.98 | 307.05 | 306.75 | 306.9 | 58083.0 |
| 2020-06-12 07:35:00 | SPY | ETF | 306.88 | 306.93 | 306.17 | 306.32 | 78868.0 |
| 2020-06-12 07:40:00 | SPY | ETF | 306.4 | 306.7 | 306.16 | 306.261 | 138995.0 |
| 2020-06-12 07:45:00 | SPY | ETF | 306.34 | 306.64 | 306.19 | 306.29 | 84477.0 |
| 2020-06-12 07:50:00 | SPY | ETF | 306.32 | 306.71 | 306.22 | 306.57 | 87236.0 |
| 2020-06-12 07:55:00 | SPY | ETF | 306.6 | 306.78 | 306.1 | 306.1 | 153935.0 |
| 2020-06-12 08:00:00 | SPY | ETF | 306.08 | 307.54 | 303.0 | 306.3 | 410379.0 |
| 2020-06-12 08:05:00 | SPY | ETF | 306.31 | 306.31 | 305.66 | 305.73 | 86715.0 |
> showing 50 of 79,307 rows — these rows as CSV