PREVIEW / etf_5min / 2022-03-31
file: by_date/etf_5min/2022/2022-03-31.parquet size: 1.9 MB rows: 93,618
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-03-31 04:00:00 | SPY | ETF | 459.6 | 459.65 | 459.4 | 459.49 | 54171.0 |
| 2022-03-31 04:05:00 | SPY | ETF | 459.59 | 459.6 | 459.29 | 459.35 | 34442.0 |
| 2022-03-31 04:10:00 | SPY | ETF | 459.27 | 459.27 | 459.25 | 459.25 | 713.0 |
| 2022-03-31 04:15:00 | SPY | ETF | 459.23 | 459.24 | 459.06 | 459.13 | 933.0 |
| 2022-03-31 04:20:00 | SPY | ETF | 459.34 | 459.34 | 459.18 | 459.31 | 3127.0 |
| 2022-03-31 04:25:00 | SPY | ETF | 459.27 | 459.28 | 459.27 | 459.28 | 248.0 |
| 2022-03-31 04:30:00 | SPY | ETF | 459.31 | 459.31 | 459.06 | 459.14 | 3416.0 |
| 2022-03-31 04:35:00 | SPY | ETF | 459.2 | 459.23 | 459.01 | 459.11 | 2594.0 |
| 2022-03-31 04:40:00 | SPY | ETF | 459.1 | 459.1 | 459.08 | 459.08 | 200.0 |
| 2022-03-31 04:45:00 | SPY | ETF | 459.04 | 459.05 | 459.04 | 459.05 | 920.0 |
| 2022-03-31 04:50:00 | SPY | ETF | 459.05 | 459.28 | 459.05 | 459.28 | 1176.0 |
| 2022-03-31 04:55:00 | SPY | ETF | 459.32 | 459.44 | 459.32 | 459.38 | 6448.0 |
| 2022-03-31 05:00:00 | SPY | ETF | 459.35 | 459.4 | 459.35 | 459.35 | 1650.0 |
| 2022-03-31 05:05:00 | SPY | ETF | 459.17 | 459.22 | 459.05 | 459.05 | 1600.0 |
| 2022-03-31 05:10:00 | SPY | ETF | 459.1 | 459.14 | 459.1 | 459.14 | 600.0 |
| 2022-03-31 05:15:00 | SPY | ETF | 459.24 | 459.39 | 459.23 | 459.39 | 809.0 |
| 2022-03-31 05:20:00 | SPY | ETF | 459.35 | 459.35 | 459.35 | 459.35 | 100.0 |
| 2022-03-31 05:25:00 | SPY | ETF | 459.36 | 459.36 | 459.23 | 459.25 | 12669.0 |
| 2022-03-31 05:35:00 | SPY | ETF | 459.27 | 459.27 | 459.21 | 459.21 | 400.0 |
| 2022-03-31 05:40:00 | SPY | ETF | 459.39 | 459.39 | 459.39 | 459.39 | 200.0 |
| 2022-03-31 05:50:00 | SPY | ETF | 459.22 | 459.25 | 459.17 | 459.25 | 300.0 |
| 2022-03-31 05:55:00 | SPY | ETF | 459.3 | 459.3 | 459.25 | 459.28 | 2600.0 |
| 2022-03-31 06:00:00 | SPY | ETF | 459.1 | 459.1 | 459.07 | 459.1 | 2250.0 |
| 2022-03-31 06:05:00 | SPY | ETF | 459.16 | 459.24 | 459.12 | 459.12 | 1609.0 |
| 2022-03-31 06:10:00 | SPY | ETF | 459.18 | 459.18 | 459.16 | 459.16 | 1100.0 |
| 2022-03-31 06:15:00 | SPY | ETF | 459.14 | 459.14 | 458.91 | 458.91 | 2245.0 |
| 2022-03-31 06:20:00 | SPY | ETF | 458.9 | 458.93 | 458.83 | 458.88 | 2950.0 |
| 2022-03-31 06:25:00 | SPY | ETF | 459.13 | 459.26 | 459.13 | 459.23 | 1430.0 |
| 2022-03-31 06:30:00 | SPY | ETF | 459.2 | 459.23 | 459.17 | 459.17 | 300.0 |
| 2022-03-31 06:35:00 | SPY | ETF | 459.27 | 459.33 | 458.95 | 458.95 | 1650.0 |
| 2022-03-31 06:40:00 | SPY | ETF | 459.1 | 459.22 | 459.1 | 459.15 | 653.0 |
| 2022-03-31 06:45:00 | SPY | ETF | 459.1 | 459.2 | 459.1 | 459.1 | 1149.0 |
| 2022-03-31 06:50:00 | SPY | ETF | 459.07 | 459.16 | 459.06 | 459.16 | 1149.0 |
| 2022-03-31 06:55:00 | SPY | ETF | 459.07 | 459.07 | 458.8 | 458.82 | 5334.0 |
| 2022-03-31 07:00:00 | SPY | ETF | 458.87 | 458.96 | 458.8 | 458.82 | 11075.0 |
| 2022-03-31 07:05:00 | SPY | ETF | 458.91 | 458.91 | 458.68 | 458.84 | 5024.0 |
| 2022-03-31 07:10:00 | SPY | ETF | 458.71 | 458.75 | 458.5 | 458.56 | 9499.0 |
| 2022-03-31 07:15:00 | SPY | ETF | 458.56 | 458.6 | 458.5 | 458.5 | 2350.0 |
| 2022-03-31 07:20:00 | SPY | ETF | 458.46 | 458.53 | 458.34 | 458.36 | 8527.0 |
| 2022-03-31 07:25:00 | SPY | ETF | 458.34 | 458.34 | 458.08 | 458.08 | 8630.0 |
| 2022-03-31 07:30:00 | SPY | ETF | 458.17 | 458.33 | 458.1 | 458.24 | 5349.0 |
| 2022-03-31 07:35:00 | SPY | ETF | 458.22 | 458.43 | 458.18 | 458.39 | 9300.0 |
| 2022-03-31 07:40:00 | SPY | ETF | 458.42 | 458.63 | 458.33 | 458.62 | 16669.0 |
| 2022-03-31 07:45:00 | SPY | ETF | 458.6 | 458.77 | 458.6 | 458.77 | 4948.0 |
| 2022-03-31 07:50:00 | SPY | ETF | 458.75 | 458.75 | 458.6 | 458.62 | 9036.0 |
| 2022-03-31 07:55:00 | SPY | ETF | 458.56 | 458.849 | 458.56 | 458.849 | 3000.0 |
| 2022-03-31 08:00:00 | SPY | ETF | 458.35 | 459.98 | 458.18 | 458.71 | 44982.0 |
| 2022-03-31 08:05:00 | SPY | ETF | 458.78 | 458.97 | 458.76 | 458.91 | 56953.0 |
| 2022-03-31 08:10:00 | SPY | ETF | 458.88 | 458.89 | 458.84 | 458.87 | 33801.0 |
| 2022-03-31 08:15:00 | SPY | ETF | 458.8796 | 458.8796 | 458.7396 | 458.7396 | 21864.0 |
> showing 50 of 93,618 rows — these rows as CSV