PREVIEW / etf_5min / 2020-09-30
file: by_date/etf_5min/2020/2020-09-30.parquet size: 1.6 MB rows: 73,684
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-30 04:00:00 | SPY | ETF | 330.55 | 330.87 | 330.4 | 330.86 | 15503.0 |
| 2020-09-30 04:05:00 | SPY | ETF | 330.87 | 330.96 | 330.35 | 330.45 | 10525.0 |
| 2020-09-30 04:10:00 | SPY | ETF | 330.46 | 330.74 | 330.45 | 330.74 | 11554.0 |
| 2020-09-30 04:15:00 | SPY | ETF | 330.77 | 331.01 | 330.54 | 330.92 | 7022.0 |
| 2020-09-30 04:20:00 | SPY | ETF | 330.9 | 330.9 | 330.7 | 330.75 | 3996.0 |
| 2020-09-30 04:25:00 | SPY | ETF | 330.66 | 330.7 | 330.5 | 330.51 | 4581.0 |
| 2020-09-30 04:30:00 | SPY | ETF | 330.62 | 330.62 | 330.4 | 330.46 | 2102.0 |
| 2020-09-30 04:35:00 | SPY | ETF | 330.49 | 330.65 | 330.4 | 330.54 | 3285.0 |
| 2020-09-30 04:40:00 | SPY | ETF | 330.6 | 330.92 | 330.41 | 330.67 | 10669.0 |
| 2020-09-30 04:45:00 | SPY | ETF | 330.86 | 330.9 | 330.78 | 330.79 | 3743.0 |
| 2020-09-30 04:50:00 | SPY | ETF | 330.79 | 330.79 | 330.68 | 330.71 | 2102.0 |
| 2020-09-30 04:55:00 | SPY | ETF | 330.81 | 330.81 | 330.74 | 330.74 | 245.0 |
| 2020-09-30 05:00:00 | SPY | ETF | 330.81 | 330.81 | 330.53 | 330.69 | 5811.0 |
| 2020-09-30 05:05:00 | SPY | ETF | 330.56 | 330.56 | 330.56 | 330.56 | 501.0 |
| 2020-09-30 05:10:00 | SPY | ETF | 330.37 | 330.37 | 329.98 | 330.21 | 6115.0 |
| 2020-09-30 05:15:00 | SPY | ETF | 330.19 | 330.4 | 330.19 | 330.31 | 4759.0 |
| 2020-09-30 05:20:00 | SPY | ETF | 330.29 | 330.4 | 329.91 | 329.91 | 9862.0 |
| 2020-09-30 05:25:00 | SPY | ETF | 329.95 | 330.09 | 329.6 | 329.6 | 11378.0 |
| 2020-09-30 05:30:00 | SPY | ETF | 329.74 | 330.13 | 329.71 | 330.1 | 4426.0 |
| 2020-09-30 05:35:00 | SPY | ETF | 330.1 | 330.32 | 330.1 | 330.25 | 6378.0 |
| 2020-09-30 05:40:00 | SPY | ETF | 330.26 | 330.34 | 330.03 | 330.03 | 11137.0 |
| 2020-09-30 05:45:00 | SPY | ETF | 330.05 | 330.5 | 330.05 | 330.5 | 7998.0 |
| 2020-09-30 05:50:00 | SPY | ETF | 330.5 | 330.64 | 330.5 | 330.54 | 3651.0 |
| 2020-09-30 05:55:00 | SPY | ETF | 330.55 | 330.81 | 330.55 | 330.8 | 5321.0 |
| 2020-09-30 06:00:00 | SPY | ETF | 330.71 | 330.71 | 330.56 | 330.56 | 1581.0 |
| 2020-09-30 06:05:00 | SPY | ETF | 330.48 | 330.55 | 330.0 | 330.48 | 24065.0 |
| 2020-09-30 06:10:00 | SPY | ETF | 330.37 | 330.74 | 330.37 | 330.74 | 3700.0 |
| 2020-09-30 06:15:00 | SPY | ETF | 330.65 | 330.76 | 330.65 | 330.66 | 1621.0 |
| 2020-09-30 06:20:00 | SPY | ETF | 330.7 | 330.84 | 330.7 | 330.84 | 3842.0 |
| 2020-09-30 06:25:00 | SPY | ETF | 330.8 | 331.09 | 330.8 | 331.0 | 6661.0 |
| 2020-09-30 06:30:00 | SPY | ETF | 331.04 | 331.7 | 331.04 | 331.62 | 15419.0 |
| 2020-09-30 06:35:00 | SPY | ETF | 331.63 | 331.77 | 331.63 | 331.7 | 4538.0 |
| 2020-09-30 06:40:00 | SPY | ETF | 331.69 | 332.29 | 331.65 | 332.16 | 34277.0 |
| 2020-09-30 06:45:00 | SPY | ETF | 332.22 | 332.49 | 332.2 | 332.3 | 17631.0 |
| 2020-09-30 06:50:00 | SPY | ETF | 332.25 | 332.25 | 332.03 | 332.08 | 3626.0 |
| 2020-09-30 06:55:00 | SPY | ETF | 332.04 | 332.04 | 331.77 | 331.77 | 13202.0 |
| 2020-09-30 07:00:00 | SPY | ETF | 331.75 | 331.91 | 331.56 | 331.87 | 30939.0 |
| 2020-09-30 07:05:00 | SPY | ETF | 331.87 | 331.87 | 331.68 | 331.86 | 16176.0 |
| 2020-09-30 07:10:00 | SPY | ETF | 331.8 | 332.0 | 331.73 | 331.75 | 22986.0 |
| 2020-09-30 07:15:00 | SPY | ETF | 331.7 | 331.73 | 331.55 | 331.58 | 18304.0 |
| 2020-09-30 07:20:00 | SPY | ETF | 331.58 | 331.71 | 331.55 | 331.58 | 20911.0 |
| 2020-09-30 07:25:00 | SPY | ETF | 331.6 | 331.9 | 331.48 | 331.84 | 34006.0 |
| 2020-09-30 07:30:00 | SPY | ETF | 331.85 | 331.88 | 331.49 | 331.49 | 13102.0 |
| 2020-09-30 07:35:00 | SPY | ETF | 331.5 | 331.53 | 331.35 | 331.35 | 31677.0 |
| 2020-09-30 07:40:00 | SPY | ETF | 331.32 | 331.52 | 331.29 | 331.34 | 21002.0 |
| 2020-09-30 07:45:00 | SPY | ETF | 331.36 | 331.48 | 331.34 | 331.44 | 10392.0 |
| 2020-09-30 07:50:00 | SPY | ETF | 331.38 | 331.52 | 331.38 | 331.48 | 61790.0 |
| 2020-09-30 07:55:00 | SPY | ETF | 331.38 | 331.41 | 331.21 | 331.32 | 34701.0 |
| 2020-09-30 08:00:00 | SPY | ETF | 331.7401 | 332.18 | 330.0 | 331.25 | 56441.0 |
| 2020-09-30 08:05:00 | SPY | ETF | 331.25 | 331.25 | 331.04 | 331.17 | 54457.0 |
> showing 50 of 73,684 rows — these rows as CSV