PREVIEW / etf_5min / 2021-03-11
file: by_date/etf_5min/2021/2021-03-11.parquet size: 1.9 MB rows: 90,109
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-03-11 04:00:00 | SPY | ETF | 392.0 | 392.47 | 391.52 | 392.22 | 11131.0 |
| 2021-03-11 04:05:00 | SPY | ETF | 392.22 | 392.34 | 392.21 | 392.34 | 4248.0 |
| 2021-03-11 04:10:00 | SPY | ETF | 392.32 | 392.48 | 392.31 | 392.48 | 12305.0 |
| 2021-03-11 04:15:00 | SPY | ETF | 392.49 | 392.64 | 392.39 | 392.64 | 12382.0 |
| 2021-03-11 04:20:00 | SPY | ETF | 392.59 | 392.61 | 392.54 | 392.54 | 850.0 |
| 2021-03-11 04:25:00 | SPY | ETF | 392.5 | 392.56 | 392.5 | 392.56 | 579.0 |
| 2021-03-11 04:30:00 | SPY | ETF | 392.27 | 392.27 | 392.27 | 392.27 | 200.0 |
| 2021-03-11 04:35:00 | SPY | ETF | 392.33 | 392.33 | 392.25 | 392.31 | 900.0 |
| 2021-03-11 04:40:00 | SPY | ETF | 392.39 | 392.39 | 392.39 | 392.39 | 400.0 |
| 2021-03-11 04:45:00 | SPY | ETF | 392.28 | 392.28 | 392.28 | 392.28 | 400.0 |
| 2021-03-11 04:50:00 | SPY | ETF | 392.27 | 392.44 | 392.27 | 392.44 | 1700.0 |
| 2021-03-11 04:55:00 | SPY | ETF | 392.3 | 392.3 | 392.25 | 392.25 | 800.0 |
| 2021-03-11 05:00:00 | SPY | ETF | 392.3 | 392.34 | 392.29 | 392.34 | 2000.0 |
| 2021-03-11 05:05:00 | SPY | ETF | 392.37 | 392.37 | 392.27 | 392.27 | 2798.0 |
| 2021-03-11 05:10:00 | SPY | ETF | 392.17 | 392.17 | 392.15 | 392.15 | 10000.0 |
| 2021-03-11 05:15:00 | SPY | ETF | 392.08 | 392.16 | 392.08 | 392.16 | 600.0 |
| 2021-03-11 05:20:00 | SPY | ETF | 392.21 | 392.21 | 392.1 | 392.2 | 1500.0 |
| 2021-03-11 05:25:00 | SPY | ETF | 392.21 | 392.27 | 392.2 | 392.25 | 3300.0 |
| 2021-03-11 05:30:00 | SPY | ETF | 392.19 | 392.23 | 392.15 | 392.23 | 1100.0 |
| 2021-03-11 05:35:00 | SPY | ETF | 392.2 | 392.25 | 392.15 | 392.25 | 900.0 |
| 2021-03-11 05:40:00 | SPY | ETF | 392.37 | 392.49 | 392.37 | 392.45 | 600.0 |
| 2021-03-11 05:45:00 | SPY | ETF | 392.21 | 392.49 | 392.2 | 392.49 | 10950.0 |
| 2021-03-11 05:50:00 | SPY | ETF | 392.61 | 392.67 | 392.59 | 392.59 | 2300.0 |
| 2021-03-11 05:55:00 | SPY | ETF | 392.5 | 392.57 | 392.49 | 392.52 | 500.0 |
| 2021-03-11 06:00:00 | SPY | ETF | 392.5 | 392.5 | 392.3 | 392.3 | 2300.0 |
| 2021-03-11 06:05:00 | SPY | ETF | 392.33 | 392.42 | 392.33 | 392.4 | 3199.0 |
| 2021-03-11 06:10:00 | SPY | ETF | 392.46 | 392.46 | 392.4 | 392.4 | 200.0 |
| 2021-03-11 06:15:00 | SPY | ETF | 392.38 | 392.38 | 392.32 | 392.37 | 2398.0 |
| 2021-03-11 06:20:00 | SPY | ETF | 392.39 | 392.39 | 392.2 | 392.2 | 6399.0 |
| 2021-03-11 06:25:00 | SPY | ETF | 392.12 | 392.13 | 392.05 | 392.09 | 800.0 |
| 2021-03-11 06:30:00 | SPY | ETF | 392.07 | 392.07 | 391.95 | 391.97 | 600.0 |
| 2021-03-11 06:35:00 | SPY | ETF | 392.07 | 392.26 | 392.0 | 392.21 | 6773.0 |
| 2021-03-11 06:40:00 | SPY | ETF | 392.23 | 392.23 | 392.11 | 392.15 | 4750.0 |
| 2021-03-11 06:45:00 | SPY | ETF | 392.15 | 392.28 | 392.13 | 392.26 | 962.0 |
| 2021-03-11 06:50:00 | SPY | ETF | 392.17 | 392.19 | 392.13 | 392.13 | 1226.0 |
| 2021-03-11 06:55:00 | SPY | ETF | 392.17 | 392.22 | 392.0 | 392.0 | 1850.0 |
| 2021-03-11 07:00:00 | SPY | ETF | 391.98 | 392.03 | 391.74 | 391.81 | 44279.0 |
| 2021-03-11 07:05:00 | SPY | ETF | 391.86 | 391.86 | 391.79 | 391.84 | 15037.0 |
| 2021-03-11 07:10:00 | SPY | ETF | 391.9 | 391.99 | 391.86 | 391.92 | 25878.0 |
| 2021-03-11 07:15:00 | SPY | ETF | 391.97 | 392.0 | 391.92 | 391.94 | 27809.0 |
| 2021-03-11 07:20:00 | SPY | ETF | 391.97 | 392.21 | 391.93 | 392.17 | 66771.0 |
| 2021-03-11 07:25:00 | SPY | ETF | 392.11 | 392.18 | 392.1 | 392.15 | 3607.0 |
| 2021-03-11 07:30:00 | SPY | ETF | 392.2 | 392.2 | 392.02 | 392.07 | 6419.0 |
| 2021-03-11 07:35:00 | SPY | ETF | 392.03 | 392.12 | 391.96 | 392.03 | 18226.0 |
| 2021-03-11 07:40:00 | SPY | ETF | 392.03 | 392.14 | 392.02 | 392.02 | 7426.0 |
| 2021-03-11 07:45:00 | SPY | ETF | 392.05 | 392.5 | 392.05 | 392.37 | 16028.0 |
| 2021-03-11 07:50:00 | SPY | ETF | 392.39 | 392.49 | 392.09 | 392.09 | 37077.0 |
| 2021-03-11 07:55:00 | SPY | ETF | 392.11 | 392.31 | 392.0 | 392.23 | 40567.0 |
| 2021-03-11 08:00:00 | SPY | ETF | 392.3804 | 392.46 | 391.71 | 392.31 | 50847.0 |
| 2021-03-11 08:05:00 | SPY | ETF | 392.3 | 392.41 | 392.2 | 392.2 | 13428.0 |
> showing 50 of 90,109 rows — these rows as CSV