PREVIEW / etf_5min / 2022-09-07
file: by_date/etf_5min/2022/2022-09-07.parquet size: 1.9 MB rows: 91,012
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-07 04:00:00 | SPY | ETF | 391.01 | 391.5 | 390.94 | 391.5 | 13340.0 |
| 2022-09-07 04:05:00 | SPY | ETF | 391.51 | 391.96 | 391.5 | 391.52 | 11723.0 |
| 2022-09-07 04:10:00 | SPY | ETF | 391.56 | 391.57 | 391.26 | 391.27 | 7620.0 |
| 2022-09-07 04:15:00 | SPY | ETF | 391.37 | 391.37 | 391.04 | 391.21 | 7303.0 |
| 2022-09-07 04:20:00 | SPY | ETF | 391.17 | 391.17 | 391.03 | 391.03 | 1000.0 |
| 2022-09-07 04:25:00 | SPY | ETF | 391.08 | 391.19 | 391.08 | 391.19 | 400.0 |
| 2022-09-07 04:30:00 | SPY | ETF | 391.13 | 391.24 | 391.12 | 391.24 | 1100.0 |
| 2022-09-07 04:35:00 | SPY | ETF | 391.22 | 391.22 | 391.11 | 391.11 | 3400.0 |
| 2022-09-07 04:40:00 | SPY | ETF | 390.9 | 391.13 | 390.88 | 391.13 | 3500.0 |
| 2022-09-07 04:45:00 | SPY | ETF | 391.2 | 391.3 | 391.19 | 391.3 | 2598.0 |
| 2022-09-07 04:50:00 | SPY | ETF | 391.26 | 391.66 | 391.2 | 391.6 | 3900.0 |
| 2022-09-07 04:55:00 | SPY | ETF | 391.56 | 391.68 | 391.56 | 391.63 | 798.0 |
| 2022-09-07 05:00:00 | SPY | ETF | 391.62 | 391.65 | 391.09 | 391.09 | 4100.0 |
| 2022-09-07 05:05:00 | SPY | ETF | 391.03 | 391.15 | 391.01 | 391.01 | 300.0 |
| 2022-09-07 05:10:00 | SPY | ETF | 391.11 | 391.11 | 391.11 | 391.11 | 100.0 |
| 2022-09-07 05:15:00 | SPY | ETF | 391.18 | 391.3 | 391.18 | 391.3 | 1190.0 |
| 2022-09-07 05:20:00 | SPY | ETF | 391.4 | 391.4 | 391.08 | 391.14 | 5890.0 |
| 2022-09-07 05:25:00 | SPY | ETF | 391.2 | 391.21 | 391.1 | 391.21 | 890.0 |
| 2022-09-07 05:30:00 | SPY | ETF | 391.2 | 391.2 | 391.09 | 391.2 | 1379.0 |
| 2022-09-07 05:35:00 | SPY | ETF | 391.25 | 391.37 | 391.0 | 391.0 | 1808.0 |
| 2022-09-07 05:40:00 | SPY | ETF | 391.0 | 391.26 | 391.0 | 391.26 | 6000.0 |
| 2022-09-07 05:45:00 | SPY | ETF | 391.33 | 391.52 | 391.25 | 391.45 | 15990.0 |
| 2022-09-07 05:50:00 | SPY | ETF | 391.42 | 391.44 | 391.36 | 391.36 | 80630.0 |
| 2022-09-07 05:55:00 | SPY | ETF | 391.45 | 391.51 | 391.45 | 391.51 | 24200.0 |
| 2022-09-07 06:00:00 | SPY | ETF | 391.6 | 391.65 | 391.36 | 391.36 | 22800.0 |
| 2022-09-07 06:05:00 | SPY | ETF | 391.3 | 391.52 | 391.3 | 391.45 | 999.0 |
| 2022-09-07 06:10:00 | SPY | ETF | 391.22 | 391.29 | 391.2 | 391.29 | 2500.0 |
| 2022-09-07 06:15:00 | SPY | ETF | 391.21 | 391.21 | 390.98 | 390.98 | 2700.0 |
| 2022-09-07 06:20:00 | SPY | ETF | 391.2 | 391.45 | 391.2 | 391.45 | 600.0 |
| 2022-09-07 06:25:00 | SPY | ETF | 391.41 | 391.5 | 391.41 | 391.46 | 5390.0 |
| 2022-09-07 06:30:00 | SPY | ETF | 391.42 | 391.42 | 391.32 | 391.4 | 1448.0 |
| 2022-09-07 06:35:00 | SPY | ETF | 391.27 | 391.6 | 391.26 | 391.6 | 1100.0 |
| 2022-09-07 06:40:00 | SPY | ETF | 391.4 | 391.4 | 391.33 | 391.34 | 1335.0 |
| 2022-09-07 06:45:00 | SPY | ETF | 391.44 | 391.44 | 391.03 | 391.17 | 4896.0 |
| 2022-09-07 06:50:00 | SPY | ETF | 391.24 | 391.4 | 391.24 | 391.4 | 650.0 |
| 2022-09-07 06:55:00 | SPY | ETF | 391.33 | 391.33 | 391.33 | 391.33 | 100.0 |
| 2022-09-07 07:00:00 | SPY | ETF | 391.3 | 391.3 | 391.19 | 391.26 | 11951.0 |
| 2022-09-07 07:05:00 | SPY | ETF | 391.17 | 391.4 | 391.14 | 391.14 | 10758.0 |
| 2022-09-07 07:10:00 | SPY | ETF | 391.11 | 391.34 | 391.11 | 391.34 | 6689.0 |
| 2022-09-07 07:15:00 | SPY | ETF | 391.34 | 391.39 | 391.2 | 391.34 | 21863.0 |
| 2022-09-07 07:20:00 | SPY | ETF | 391.27 | 391.49 | 391.27 | 391.49 | 17663.0 |
| 2022-09-07 07:25:00 | SPY | ETF | 391.51 | 391.53 | 391.45 | 391.47 | 10415.0 |
| 2022-09-07 07:30:00 | SPY | ETF | 391.47 | 391.47 | 391.2 | 391.3 | 11325.0 |
| 2022-09-07 07:35:00 | SPY | ETF | 391.29 | 391.41 | 390.07 | 390.07 | 65056.0 |
| 2022-09-07 07:40:00 | SPY | ETF | 390.08 | 390.65 | 389.93 | 390.65 | 76321.0 |
| 2022-09-07 07:45:00 | SPY | ETF | 390.61 | 390.61 | 390.28 | 390.42 | 32457.0 |
| 2022-09-07 07:50:00 | SPY | ETF | 390.4 | 390.58 | 390.2 | 390.58 | 21276.0 |
| 2022-09-07 07:55:00 | SPY | ETF | 390.61 | 390.7 | 390.41 | 390.44 | 60252.0 |
| 2022-09-07 08:00:00 | SPY | ETF | 391.29 | 391.51 | 389.0 | 390.58 | 110921.0 |
| 2022-09-07 08:05:00 | SPY | ETF | 390.53 | 390.53 | 389.55 | 389.92 | 77047.0 |
> showing 50 of 91,012 rows — these rows as CSV