PREVIEW / etf_5min / 2020-12-31
file: by_date/etf_5min/2020/2020-12-31.parquet size: 1.7 MB rows: 78,345
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-12-31 04:00:00 | SPY | ETF | 371.36 | 371.53 | 371.33 | 371.46 | 2346.0 |
| 2020-12-31 04:05:00 | SPY | ETF | 371.41 | 371.41 | 371.37 | 371.41 | 3805.0 |
| 2020-12-31 04:10:00 | SPY | ETF | 371.2 | 371.31 | 371.2 | 371.31 | 332.0 |
| 2020-12-31 04:15:00 | SPY | ETF | 371.23 | 371.28 | 371.23 | 371.28 | 420.0 |
| 2020-12-31 04:20:00 | SPY | ETF | 371.28 | 371.28 | 371.2 | 371.2 | 460.0 |
| 2020-12-31 04:25:00 | SPY | ETF | 371.18 | 371.29 | 371.18 | 371.2 | 1906.0 |
| 2020-12-31 04:30:00 | SPY | ETF | 371.16 | 371.26 | 371.0 | 371.23 | 2693.0 |
| 2020-12-31 04:35:00 | SPY | ETF | 371.23 | 371.23 | 371.23 | 371.23 | 100.0 |
| 2020-12-31 04:45:00 | SPY | ETF | 371.18 | 371.19 | 371.18 | 371.19 | 618.0 |
| 2020-12-31 04:50:00 | SPY | ETF | 371.19 | 371.26 | 371.19 | 371.26 | 800.0 |
| 2020-12-31 05:00:00 | SPY | ETF | 371.26 | 371.26 | 371.25 | 371.25 | 2770.0 |
| 2020-12-31 05:05:00 | SPY | ETF | 371.2 | 371.29 | 371.2 | 371.29 | 400.0 |
| 2020-12-31 05:10:00 | SPY | ETF | 371.27 | 371.29 | 371.26 | 371.27 | 3602.0 |
| 2020-12-31 05:15:00 | SPY | ETF | 371.37 | 371.37 | 371.37 | 371.37 | 200.0 |
| 2020-12-31 05:20:00 | SPY | ETF | 371.4 | 371.4 | 371.4 | 371.4 | 150.0 |
| 2020-12-31 05:25:00 | SPY | ETF | 371.37 | 371.4 | 371.37 | 371.4 | 2100.0 |
| 2020-12-31 05:30:00 | SPY | ETF | 371.39 | 371.49 | 371.39 | 371.49 | 1201.0 |
| 2020-12-31 05:35:00 | SPY | ETF | 371.51 | 371.53 | 371.5 | 371.53 | 420.0 |
| 2020-12-31 05:40:00 | SPY | ETF | 371.57 | 371.59 | 371.57 | 371.59 | 200.0 |
| 2020-12-31 05:45:00 | SPY | ETF | 371.59 | 371.59 | 371.59 | 371.59 | 1949.0 |
| 2020-12-31 05:50:00 | SPY | ETF | 371.69 | 371.95 | 371.69 | 371.95 | 1755.0 |
| 2020-12-31 05:55:00 | SPY | ETF | 371.89 | 371.91 | 371.88 | 371.88 | 1601.0 |
| 2020-12-31 06:00:00 | SPY | ETF | 371.89 | 371.89 | 371.81 | 371.81 | 1200.0 |
| 2020-12-31 06:10:00 | SPY | ETF | 371.79 | 371.79 | 371.79 | 371.79 | 530.0 |
| 2020-12-31 06:15:00 | SPY | ETF | 371.99 | 371.99 | 371.99 | 371.99 | 300.0 |
| 2020-12-31 06:20:00 | SPY | ETF | 371.99 | 372.15 | 371.99 | 372.15 | 1095.0 |
| 2020-12-31 06:25:00 | SPY | ETF | 372.17 | 372.17 | 372.17 | 372.17 | 100.0 |
| 2020-12-31 06:30:00 | SPY | ETF | 372.17 | 372.2 | 372.17 | 372.2 | 570.0 |
| 2020-12-31 06:35:00 | SPY | ETF | 372.25 | 372.33 | 372.21 | 372.28 | 13615.0 |
| 2020-12-31 06:40:00 | SPY | ETF | 372.3 | 372.33 | 372.3 | 372.31 | 2500.0 |
| 2020-12-31 06:45:00 | SPY | ETF | 372.3 | 372.3 | 372.3 | 372.3 | 200.0 |
| 2020-12-31 06:50:00 | SPY | ETF | 372.3 | 372.3 | 372.18 | 372.18 | 330.0 |
| 2020-12-31 07:00:00 | SPY | ETF | 372.1 | 372.22 | 372.1 | 372.2 | 1022.0 |
| 2020-12-31 07:05:00 | SPY | ETF | 372.15 | 372.15 | 372.11 | 372.15 | 13905.0 |
| 2020-12-31 07:10:00 | SPY | ETF | 372.15 | 372.18 | 372.15 | 372.18 | 1199.0 |
| 2020-12-31 07:15:00 | SPY | ETF | 372.18 | 372.25 | 372.18 | 372.25 | 491.0 |
| 2020-12-31 07:20:00 | SPY | ETF | 372.23 | 372.26 | 372.19 | 372.19 | 3468.0 |
| 2020-12-31 07:25:00 | SPY | ETF | 372.19 | 372.23 | 371.8 | 371.99 | 10723.0 |
| 2020-12-31 07:30:00 | SPY | ETF | 371.8 | 371.8 | 371.7 | 371.7 | 1727.0 |
| 2020-12-31 07:35:00 | SPY | ETF | 371.83 | 371.83 | 371.73 | 371.8 | 3696.0 |
| 2020-12-31 07:40:00 | SPY | ETF | 371.8 | 371.87 | 371.8 | 371.8 | 1420.0 |
| 2020-12-31 07:45:00 | SPY | ETF | 371.84 | 371.84 | 371.82 | 371.82 | 6783.0 |
| 2020-12-31 07:50:00 | SPY | ETF | 371.77 | 371.77 | 371.76 | 371.77 | 13734.0 |
| 2020-12-31 07:55:00 | SPY | ETF | 371.74 | 371.8 | 371.74 | 371.78 | 51233.0 |
| 2020-12-31 08:00:00 | SPY | ETF | 371.76 | 372.2996 | 371.39 | 371.79 | 18345.0 |
| 2020-12-31 08:05:00 | SPY | ETF | 371.76 | 371.78 | 371.58 | 371.65 | 9653.0 |
| 2020-12-31 08:10:00 | SPY | ETF | 371.64 | 371.69 | 371.53 | 371.53 | 33177.0 |
| 2020-12-31 08:15:00 | SPY | ETF | 371.53 | 371.58 | 371.52 | 371.54 | 8617.0 |
| 2020-12-31 08:20:00 | SPY | ETF | 371.55 | 371.56 | 371.45 | 371.53 | 4986.0 |
| 2020-12-31 08:25:00 | SPY | ETF | 371.54 | 371.59 | 371.54 | 371.59 | 18776.0 |
> showing 50 of 78,345 rows — these rows as CSV