PREVIEW / etf_5min / 2021-04-07
file: by_date/etf_5min/2021/2021-04-07.parquet size: 1.8 MB rows: 83,336
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-04-07 04:00:00 | SPY | ETF | 406.73 | 406.73 | 406.37 | 406.43 | 11231.0 |
| 2021-04-07 04:05:00 | SPY | ETF | 406.42 | 406.47 | 406.42 | 406.42 | 3850.0 |
| 2021-04-07 04:10:00 | SPY | ETF | 406.41 | 406.41 | 406.34 | 406.34 | 2200.0 |
| 2021-04-07 04:15:00 | SPY | ETF | 406.31 | 406.31 | 406.29 | 406.29 | 200.0 |
| 2021-04-07 04:20:00 | SPY | ETF | 406.37 | 406.38 | 406.16 | 406.16 | 925.0 |
| 2021-04-07 04:25:00 | SPY | ETF | 406.35 | 406.35 | 406.35 | 406.35 | 200.0 |
| 2021-04-07 04:35:00 | SPY | ETF | 406.38 | 406.38 | 406.38 | 406.38 | 125.0 |
| 2021-04-07 04:50:00 | SPY | ETF | 406.3 | 406.3 | 406.3 | 406.3 | 600.0 |
| 2021-04-07 04:55:00 | SPY | ETF | 406.34 | 406.34 | 406.26 | 406.26 | 2056.0 |
| 2021-04-07 05:00:00 | SPY | ETF | 406.37 | 406.37 | 406.37 | 406.37 | 200.0 |
| 2021-04-07 05:05:00 | SPY | ETF | 406.34 | 406.45 | 406.34 | 406.45 | 2774.0 |
| 2021-04-07 05:10:00 | SPY | ETF | 406.36 | 406.36 | 406.36 | 406.36 | 100.0 |
| 2021-04-07 05:15:00 | SPY | ETF | 406.26 | 406.26 | 406.04 | 406.06 | 2095.0 |
| 2021-04-07 05:20:00 | SPY | ETF | 406.06 | 406.14 | 406.06 | 406.14 | 300.0 |
| 2021-04-07 05:25:00 | SPY | ETF | 406.19 | 406.19 | 406.19 | 406.19 | 512.0 |
| 2021-04-07 05:30:00 | SPY | ETF | 406.03 | 406.03 | 406.0 | 406.0 | 200.0 |
| 2021-04-07 05:35:00 | SPY | ETF | 405.96 | 406.0 | 405.95 | 406.0 | 1700.0 |
| 2021-04-07 05:40:00 | SPY | ETF | 406.04 | 406.04 | 405.9 | 406.0 | 2490.0 |
| 2021-04-07 05:45:00 | SPY | ETF | 406.0 | 406.16 | 406.0 | 406.16 | 800.0 |
| 2021-04-07 05:50:00 | SPY | ETF | 406.08 | 406.08 | 406.08 | 406.08 | 100.0 |
| 2021-04-07 06:05:00 | SPY | ETF | 406.21 | 406.32 | 406.21 | 406.32 | 2700.0 |
| 2021-04-07 06:10:00 | SPY | ETF | 406.33 | 406.41 | 406.33 | 406.37 | 5000.0 |
| 2021-04-07 06:20:00 | SPY | ETF | 406.34 | 406.34 | 406.34 | 406.34 | 100.0 |
| 2021-04-07 06:25:00 | SPY | ETF | 406.29 | 406.29 | 406.29 | 406.29 | 200.0 |
| 2021-04-07 06:30:00 | SPY | ETF | 406.17 | 406.37 | 406.17 | 406.23 | 2300.0 |
| 2021-04-07 06:40:00 | SPY | ETF | 406.24 | 406.25 | 406.24 | 406.24 | 1000.0 |
| 2021-04-07 06:45:00 | SPY | ETF | 406.2 | 406.2 | 406.13 | 406.16 | 2000.0 |
| 2021-04-07 06:50:00 | SPY | ETF | 406.2 | 406.33 | 406.2 | 406.33 | 2007.0 |
| 2021-04-07 06:55:00 | SPY | ETF | 406.3 | 406.3 | 406.22 | 406.22 | 7500.0 |
| 2021-04-07 07:00:00 | SPY | ETF | 406.15 | 406.27 | 406.1 | 406.21 | 11825.0 |
| 2021-04-07 07:05:00 | SPY | ETF | 406.21 | 406.21 | 406.05 | 406.12 | 3647.0 |
| 2021-04-07 07:10:00 | SPY | ETF | 406.09 | 406.17 | 406.05 | 406.17 | 7304.0 |
| 2021-04-07 07:15:00 | SPY | ETF | 406.22 | 406.25 | 406.21 | 406.24 | 10380.0 |
| 2021-04-07 07:20:00 | SPY | ETF | 406.22 | 406.22 | 406.0 | 406.0 | 10088.0 |
| 2021-04-07 07:25:00 | SPY | ETF | 406.0 | 406.06 | 406.0 | 406.0 | 4588.0 |
| 2021-04-07 07:30:00 | SPY | ETF | 406.029 | 406.14 | 406.01 | 406.11 | 3400.0 |
| 2021-04-07 07:35:00 | SPY | ETF | 406.16 | 406.17 | 406.15 | 406.15 | 8976.0 |
| 2021-04-07 07:40:00 | SPY | ETF | 406.15 | 406.19 | 406.14 | 406.19 | 17421.0 |
| 2021-04-07 07:45:00 | SPY | ETF | 406.15 | 406.18 | 406.11 | 406.12 | 9049.0 |
| 2021-04-07 07:50:00 | SPY | ETF | 406.1 | 406.1 | 405.99 | 406.04 | 12558.0 |
| 2021-04-07 07:55:00 | SPY | ETF | 406.02 | 406.03 | 405.93 | 405.93 | 12502.0 |
| 2021-04-07 08:00:00 | SPY | ETF | 406.2401 | 406.3196 | 405.93 | 406.05 | 21458.0 |
| 2021-04-07 08:05:00 | SPY | ETF | 406.02 | 406.14 | 406.02 | 406.14 | 3601.0 |
| 2021-04-07 08:10:00 | SPY | ETF | 406.12 | 406.12 | 406.0 | 406.05 | 15641.0 |
| 2021-04-07 08:15:00 | SPY | ETF | 406.0 | 406.0 | 405.62 | 405.66 | 63193.0 |
| 2021-04-07 08:20:00 | SPY | ETF | 405.7 | 405.7 | 405.6 | 405.65 | 12201.0 |
| 2021-04-07 08:25:00 | SPY | ETF | 405.71 | 405.73 | 405.62 | 405.73 | 14926.0 |
| 2021-04-07 08:30:00 | SPY | ETF | 405.68 | 405.75 | 405.65 | 405.68 | 40039.0 |
| 2021-04-07 08:35:00 | SPY | ETF | 405.67 | 405.67 | 405.4 | 405.51 | 16696.0 |
| 2021-04-07 08:40:00 | SPY | ETF | 405.5 | 405.6 | 405.48 | 405.59 | 9815.0 |
> showing 50 of 83,336 rows — these rows as CSV