PREVIEW / etf_5min / 2021-01-28
file: by_date/etf_5min/2021/2021-01-28.parquet size: 1.9 MB rows: 87,470
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 |
|---|---|---|---|---|---|---|---|
| 2021-01-28 04:00:00 | SPY | ETF | 370.6 | 371.2 | 370.56 | 371.2 | 35230.0 |
| 2021-01-28 04:05:00 | SPY | ETF | 371.16 | 371.26 | 371.0 | 371.0 | 3155.0 |
| 2021-01-28 04:10:00 | SPY | ETF | 370.6 | 370.73 | 370.48 | 370.7 | 13800.0 |
| 2021-01-28 04:15:00 | SPY | ETF | 371.13 | 371.13 | 371.02 | 371.1 | 1700.0 |
| 2021-01-28 04:20:00 | SPY | ETF | 370.81 | 370.81 | 370.35 | 370.35 | 3898.0 |
| 2021-01-28 04:25:00 | SPY | ETF | 370.65 | 370.79 | 370.34 | 370.68 | 12770.0 |
| 2021-01-28 04:30:00 | SPY | ETF | 370.71 | 370.88 | 370.71 | 370.88 | 2400.0 |
| 2021-01-28 04:35:00 | SPY | ETF | 370.37 | 370.5 | 370.32 | 370.5 | 6500.0 |
| 2021-01-28 04:40:00 | SPY | ETF | 370.5 | 371.3 | 370.5 | 371.2 | 4100.0 |
| 2021-01-28 04:45:00 | SPY | ETF | 371.28 | 371.59 | 371.28 | 371.5 | 4360.0 |
| 2021-01-28 04:50:00 | SPY | ETF | 371.59 | 371.86 | 371.59 | 371.86 | 26050.0 |
| 2021-01-28 04:55:00 | SPY | ETF | 371.88 | 371.88 | 371.58 | 371.58 | 13600.0 |
| 2021-01-28 05:00:00 | SPY | ETF | 371.35 | 371.35 | 371.33 | 371.33 | 2300.0 |
| 2021-01-28 05:05:00 | SPY | ETF | 371.43 | 371.9 | 371.43 | 371.7 | 7400.0 |
| 2021-01-28 05:10:00 | SPY | ETF | 371.7 | 371.91 | 371.7 | 371.9 | 9846.0 |
| 2021-01-28 05:15:00 | SPY | ETF | 371.93 | 372.6 | 371.86 | 372.6 | 1822.0 |
| 2021-01-28 05:20:00 | SPY | ETF | 372.71 | 372.86 | 372.54 | 372.75 | 31735.0 |
| 2021-01-28 05:25:00 | SPY | ETF | 372.81 | 372.9 | 372.73 | 372.73 | 13397.0 |
| 2021-01-28 05:30:00 | SPY | ETF | 372.73 | 373.07 | 372.68 | 373.07 | 5500.0 |
| 2021-01-28 05:35:00 | SPY | ETF | 373.1 | 373.1 | 372.6 | 372.84 | 9950.0 |
| 2021-01-28 05:40:00 | SPY | ETF | 372.88 | 373.11 | 372.8 | 373.11 | 2619.0 |
| 2021-01-28 05:45:00 | SPY | ETF | 373.03 | 373.03 | 372.67 | 372.67 | 4833.0 |
| 2021-01-28 05:50:00 | SPY | ETF | 372.7 | 372.97 | 372.62 | 372.62 | 4000.0 |
| 2021-01-28 05:55:00 | SPY | ETF | 372.52 | 372.82 | 372.5 | 372.56 | 32665.0 |
| 2021-01-28 06:00:00 | SPY | ETF | 372.46 | 372.62 | 372.25 | 372.27 | 30830.0 |
| 2021-01-28 06:05:00 | SPY | ETF | 372.24 | 372.75 | 372.24 | 372.75 | 1160.0 |
| 2021-01-28 06:10:00 | SPY | ETF | 372.77 | 373.33 | 372.77 | 373.23 | 18400.0 |
| 2021-01-28 06:15:00 | SPY | ETF | 373.2 | 373.91 | 373.1 | 373.91 | 42139.0 |
| 2021-01-28 06:20:00 | SPY | ETF | 373.98 | 374.0 | 373.69 | 373.7 | 107646.0 |
| 2021-01-28 06:25:00 | SPY | ETF | 373.53 | 373.65 | 373.27 | 373.43 | 13671.0 |
| 2021-01-28 06:30:00 | SPY | ETF | 373.41 | 373.63 | 373.4 | 373.52 | 10351.0 |
| 2021-01-28 06:35:00 | SPY | ETF | 373.37 | 373.46 | 373.27 | 373.32 | 1175.0 |
| 2021-01-28 06:40:00 | SPY | ETF | 373.27 | 373.3 | 373.1 | 373.1 | 34769.0 |
| 2021-01-28 06:45:00 | SPY | ETF | 373.22 | 373.58 | 373.22 | 373.42 | 4600.0 |
| 2021-01-28 06:50:00 | SPY | ETF | 373.37 | 373.68 | 373.37 | 373.6 | 9200.0 |
| 2021-01-28 06:55:00 | SPY | ETF | 373.4 | 373.75 | 373.19 | 373.28 | 7130.0 |
| 2021-01-28 07:00:00 | SPY | ETF | 373.3 | 373.51 | 373.16 | 373.48 | 8623.0 |
| 2021-01-28 07:05:00 | SPY | ETF | 373.49 | 374.04 | 373.49 | 373.78 | 117074.0 |
| 2021-01-28 07:10:00 | SPY | ETF | 373.74 | 374.25 | 373.7 | 374.15 | 89248.0 |
| 2021-01-28 07:15:00 | SPY | ETF | 374.08 | 374.5 | 374.08 | 374.5 | 43525.0 |
| 2021-01-28 07:20:00 | SPY | ETF | 374.459 | 374.459 | 373.9 | 373.9 | 45440.0 |
| 2021-01-28 07:25:00 | SPY | ETF | 373.84 | 374.14 | 373.79 | 374.09 | 31302.0 |
| 2021-01-28 07:30:00 | SPY | ETF | 374.05 | 374.05 | 373.75 | 373.88 | 6595.0 |
| 2021-01-28 07:35:00 | SPY | ETF | 373.79 | 374.11 | 373.78 | 374.04 | 16625.0 |
| 2021-01-28 07:40:00 | SPY | ETF | 373.87 | 373.96 | 373.57 | 373.58 | 47687.0 |
| 2021-01-28 07:45:00 | SPY | ETF | 373.6 | 373.91 | 373.4 | 373.85 | 33779.0 |
| 2021-01-28 07:50:00 | SPY | ETF | 373.9 | 373.94 | 373.65 | 373.65 | 27242.0 |
| 2021-01-28 07:55:00 | SPY | ETF | 373.75 | 373.92 | 373.66 | 373.75 | 11678.0 |
| 2021-01-28 08:00:00 | SPY | ETF | 373.66 | 374.4596 | 370.88 | 372.8699 | 97847.0 |
| 2021-01-28 08:05:00 | SPY | ETF | 372.85 | 374.44 | 372.74 | 373.26 | 98580.0 |
> showing 50 of 87,470 rows — these rows as CSV