PREVIEW / etf_5min / 2022-10-24
file: by_date/etf_5min/2022/2022-10-24.parquet size: 2.0 MB rows: 97,989
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-10-24 04:00:00 | SPY | ETF | 373.95 | 374.45 | 372.59 | 373.15 | 20362.0 |
| 2022-10-24 04:05:00 | SPY | ETF | 373.1 | 373.17 | 372.79 | 373.17 | 20929.0 |
| 2022-10-24 04:10:00 | SPY | ETF | 373.05 | 373.2 | 372.6 | 372.94 | 16366.0 |
| 2022-10-24 04:15:00 | SPY | ETF | 372.95 | 373.13 | 372.26 | 372.27 | 11705.0 |
| 2022-10-24 04:20:00 | SPY | ETF | 372.33 | 372.37 | 371.88 | 371.96 | 17962.0 |
| 2022-10-24 04:25:00 | SPY | ETF | 371.82 | 372.15 | 371.72 | 371.9 | 22193.0 |
| 2022-10-24 04:30:00 | SPY | ETF | 371.79 | 372.1 | 371.67 | 372.1 | 28758.0 |
| 2022-10-24 04:35:00 | SPY | ETF | 371.99 | 372.28 | 371.87 | 372.0 | 4500.0 |
| 2022-10-24 04:40:00 | SPY | ETF | 372.06 | 372.22 | 371.63 | 371.97 | 20452.0 |
| 2022-10-24 04:45:00 | SPY | ETF | 372.28 | 372.47 | 372.28 | 372.47 | 1725.0 |
| 2022-10-24 04:50:00 | SPY | ETF | 372.51 | 372.8 | 372.42 | 372.79 | 4568.0 |
| 2022-10-24 04:55:00 | SPY | ETF | 372.95 | 373.24 | 372.8 | 372.85 | 12883.0 |
| 2022-10-24 05:00:00 | SPY | ETF | 372.86 | 372.86 | 372.71 | 372.82 | 829.0 |
| 2022-10-24 05:05:00 | SPY | ETF | 372.92 | 373.08 | 372.82 | 373.01 | 2205.0 |
| 2022-10-24 05:10:00 | SPY | ETF | 373.14 | 373.16 | 372.76 | 372.76 | 8725.0 |
| 2022-10-24 05:15:00 | SPY | ETF | 372.64 | 372.64 | 372.26 | 372.26 | 2815.0 |
| 2022-10-24 05:20:00 | SPY | ETF | 372.36 | 372.41 | 372.36 | 372.41 | 261.0 |
| 2022-10-24 05:25:00 | SPY | ETF | 372.51 | 372.51 | 372.3 | 372.3 | 1570.0 |
| 2022-10-24 05:30:00 | SPY | ETF | 372.3 | 372.89 | 372.2 | 372.85 | 4400.0 |
| 2022-10-24 05:35:00 | SPY | ETF | 372.6 | 373.02 | 372.6 | 372.91 | 2180.0 |
| 2022-10-24 05:40:00 | SPY | ETF | 372.92 | 373.28 | 372.92 | 373.28 | 10018.0 |
| 2022-10-24 05:45:00 | SPY | ETF | 373.3 | 373.69 | 373.3 | 373.69 | 2808.0 |
| 2022-10-24 05:50:00 | SPY | ETF | 373.57 | 374.49 | 373.57 | 374.29 | 18027.0 |
| 2022-10-24 05:55:00 | SPY | ETF | 374.37 | 374.69 | 374.3 | 374.61 | 38226.0 |
| 2022-10-24 06:00:00 | SPY | ETF | 374.51 | 375.0 | 374.4 | 374.45 | 42177.0 |
| 2022-10-24 06:05:00 | SPY | ETF | 374.36 | 374.45 | 374.02 | 374.12 | 3995.0 |
| 2022-10-24 06:10:00 | SPY | ETF | 374.07 | 374.58 | 374.07 | 374.42 | 2195.0 |
| 2022-10-24 06:15:00 | SPY | ETF | 374.52 | 375.31 | 374.52 | 375.29 | 15087.0 |
| 2022-10-24 06:20:00 | SPY | ETF | 375.36 | 375.56 | 375.15 | 375.32 | 8500.0 |
| 2022-10-24 06:25:00 | SPY | ETF | 375.45 | 375.58 | 375.14 | 375.28 | 14025.0 |
| 2022-10-24 06:30:00 | SPY | ETF | 375.27 | 375.76 | 375.27 | 375.4 | 12220.0 |
| 2022-10-24 06:35:00 | SPY | ETF | 375.41 | 375.58 | 375.3 | 375.4 | 4025.0 |
| 2022-10-24 06:40:00 | SPY | ETF | 375.35 | 375.45 | 374.96 | 375.0 | 18250.0 |
| 2022-10-24 06:45:00 | SPY | ETF | 374.91 | 375.0 | 374.85 | 375.0 | 4453.0 |
| 2022-10-24 06:50:00 | SPY | ETF | 374.98 | 375.49 | 374.98 | 375.35 | 14964.0 |
| 2022-10-24 06:55:00 | SPY | ETF | 375.32 | 376.01 | 375.32 | 376.0 | 13654.0 |
| 2022-10-24 07:00:00 | SPY | ETF | 375.99 | 376.16 | 375.79 | 376.09 | 31614.0 |
| 2022-10-24 07:05:00 | SPY | ETF | 376.18 | 376.19 | 375.35 | 375.35 | 25809.0 |
| 2022-10-24 07:10:00 | SPY | ETF | 375.37 | 375.66 | 375.26 | 375.59 | 18011.0 |
| 2022-10-24 07:15:00 | SPY | ETF | 375.54 | 375.92 | 375.4 | 375.86 | 26189.0 |
| 2022-10-24 07:20:00 | SPY | ETF | 375.78 | 376.03 | 375.6 | 376.0 | 41859.0 |
| 2022-10-24 07:25:00 | SPY | ETF | 375.9 | 376.5 | 375.8 | 376.36 | 43902.0 |
| 2022-10-24 07:30:00 | SPY | ETF | 376.35 | 377.22 | 376.21 | 377.05 | 109641.0 |
| 2022-10-24 07:35:00 | SPY | ETF | 377.05 | 377.23 | 376.9 | 376.95 | 54983.0 |
| 2022-10-24 07:40:00 | SPY | ETF | 376.95 | 377.45 | 376.81 | 377.35 | 29196.0 |
| 2022-10-24 07:45:00 | SPY | ETF | 377.45 | 378.11 | 377.3 | 377.66 | 134331.0 |
| 2022-10-24 07:50:00 | SPY | ETF | 377.6 | 377.61 | 377.05 | 377.1 | 93355.0 |
| 2022-10-24 07:55:00 | SPY | ETF | 377.17 | 377.53 | 377.09 | 377.11 | 34345.0 |
| 2022-10-24 08:00:00 | SPY | ETF | 375.94 | 378.08 | 371.6896 | 376.91 | 186359.0 |
| 2022-10-24 08:05:00 | SPY | ETF | 376.95 | 377.37 | 376.93 | 377.08 | 42452.0 |
> showing 50 of 97,989 rows — these rows as CSV