PREVIEW / etf_5min / 2023-03-22
file: by_date/etf_5min/2023/2023-03-22.parquet size: 2.0 MB rows: 98,286
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-22 04:00:00 | SPY | ETF | 397.94 | 397.94 | 397.75 | 397.77 | 20069.0 |
| 2023-03-22 04:05:00 | SPY | ETF | 397.87 | 397.98 | 397.75 | 397.87 | 7218.0 |
| 2023-03-22 04:10:00 | SPY | ETF | 397.9 | 398.09 | 397.8 | 397.8 | 2975.0 |
| 2023-03-22 04:15:00 | SPY | ETF | 397.81 | 397.81 | 397.51 | 397.53 | 5156.0 |
| 2023-03-22 04:20:00 | SPY | ETF | 397.5 | 397.72 | 397.47 | 397.69 | 5034.0 |
| 2023-03-22 04:25:00 | SPY | ETF | 397.66 | 397.87 | 397.65 | 397.66 | 7307.0 |
| 2023-03-22 04:30:00 | SPY | ETF | 397.67 | 397.78 | 397.67 | 397.78 | 1400.0 |
| 2023-03-22 04:35:00 | SPY | ETF | 397.73 | 397.81 | 397.68 | 397.79 | 2649.0 |
| 2023-03-22 04:40:00 | SPY | ETF | 397.83 | 397.83 | 397.83 | 397.83 | 100.0 |
| 2023-03-22 04:45:00 | SPY | ETF | 397.96 | 398.19 | 397.9 | 398.18 | 2277.0 |
| 2023-03-22 04:50:00 | SPY | ETF | 398.15 | 398.15 | 397.95 | 397.95 | 2067.0 |
| 2023-03-22 04:55:00 | SPY | ETF | 397.87 | 397.96 | 397.85 | 397.85 | 900.0 |
| 2023-03-22 05:00:00 | SPY | ETF | 397.88 | 397.97 | 397.76 | 397.92 | 1530.0 |
| 2023-03-22 05:05:00 | SPY | ETF | 397.97 | 398.0 | 397.97 | 397.99 | 3100.0 |
| 2023-03-22 05:10:00 | SPY | ETF | 398.09 | 398.14 | 398.07 | 398.07 | 1750.0 |
| 2023-03-22 05:15:00 | SPY | ETF | 398.05 | 398.2 | 398.02 | 398.14 | 13795.0 |
| 2023-03-22 05:20:00 | SPY | ETF | 398.14 | 398.31 | 398.14 | 398.31 | 2200.0 |
| 2023-03-22 05:25:00 | SPY | ETF | 398.27 | 398.46 | 398.27 | 398.46 | 3250.0 |
| 2023-03-22 05:30:00 | SPY | ETF | 398.4 | 398.4 | 398.32 | 398.37 | 2500.0 |
| 2023-03-22 05:35:00 | SPY | ETF | 398.36 | 398.54 | 398.34 | 398.53 | 3163.0 |
| 2023-03-22 05:40:00 | SPY | ETF | 398.53 | 398.54 | 398.46 | 398.48 | 1200.0 |
| 2023-03-22 05:45:00 | SPY | ETF | 398.56 | 398.56 | 398.37 | 398.37 | 1100.0 |
| 2023-03-22 05:50:00 | SPY | ETF | 398.47 | 398.47 | 398.27 | 398.27 | 1845.0 |
| 2023-03-22 05:55:00 | SPY | ETF | 398.28 | 398.37 | 398.28 | 398.37 | 4400.0 |
| 2023-03-22 06:00:00 | SPY | ETF | 398.3 | 398.38 | 398.2 | 398.27 | 2491.0 |
| 2023-03-22 06:05:00 | SPY | ETF | 398.08 | 398.14 | 398.08 | 398.14 | 2296.0 |
| 2023-03-22 06:10:00 | SPY | ETF | 398.17 | 398.37 | 398.14 | 398.37 | 1837.0 |
| 2023-03-22 06:15:00 | SPY | ETF | 398.34 | 398.53 | 398.3 | 398.53 | 1878.0 |
| 2023-03-22 06:20:00 | SPY | ETF | 398.52 | 398.57 | 398.52 | 398.52 | 799.0 |
| 2023-03-22 06:25:00 | SPY | ETF | 398.41 | 398.51 | 398.41 | 398.48 | 1400.0 |
| 2023-03-22 06:30:00 | SPY | ETF | 398.37 | 398.49 | 398.35 | 398.46 | 3489.0 |
| 2023-03-22 06:35:00 | SPY | ETF | 398.43 | 398.5 | 398.43 | 398.48 | 1300.0 |
| 2023-03-22 06:40:00 | SPY | ETF | 398.34 | 398.34 | 398.34 | 398.34 | 120.0 |
| 2023-03-22 06:45:00 | SPY | ETF | 398.47 | 398.47 | 398.46 | 398.46 | 200.0 |
| 2023-03-22 06:50:00 | SPY | ETF | 398.79 | 399.06 | 398.75 | 398.93 | 11250.0 |
| 2023-03-22 06:55:00 | SPY | ETF | 398.9 | 398.92 | 398.83 | 398.92 | 2718.0 |
| 2023-03-22 07:00:00 | SPY | ETF | 398.9 | 399.1 | 398.86 | 399.08 | 5346.0 |
| 2023-03-22 07:05:00 | SPY | ETF | 399.02 | 399.07 | 398.92 | 399.03 | 2874.0 |
| 2023-03-22 07:10:00 | SPY | ETF | 399.07 | 399.11 | 399.06 | 399.1 | 4073.0 |
| 2023-03-22 07:15:00 | SPY | ETF | 399.05 | 399.34 | 399.05 | 399.32 | 6314.0 |
| 2023-03-22 07:20:00 | SPY | ETF | 399.27 | 399.34 | 399.27 | 399.28 | 22391.0 |
| 2023-03-22 07:25:00 | SPY | ETF | 399.25 | 399.25 | 399.11 | 399.11 | 2364.0 |
| 2023-03-22 07:30:00 | SPY | ETF | 399.07 | 399.1 | 399.0 | 399.04 | 3955.0 |
| 2023-03-22 07:35:00 | SPY | ETF | 399.01 | 399.02 | 398.94 | 399.02 | 9451.0 |
| 2023-03-22 07:40:00 | SPY | ETF | 399.02 | 399.02 | 398.85 | 398.89 | 18541.0 |
| 2023-03-22 07:45:00 | SPY | ETF | 398.82 | 398.86 | 398.63 | 398.63 | 15199.0 |
| 2023-03-22 07:50:00 | SPY | ETF | 398.62 | 398.67 | 398.52 | 398.62 | 11977.0 |
| 2023-03-22 07:55:00 | SPY | ETF | 398.65 | 398.76 | 398.65 | 398.67 | 8068.0 |
| 2023-03-22 08:00:00 | SPY | ETF | 398.86 | 399.32 | 397.78 | 398.75 | 49517.0 |
| 2023-03-22 08:05:00 | SPY | ETF | 398.79 | 398.81 | 398.67 | 398.75 | 8145.0 |
> showing 50 of 98,286 rows — these rows as CSV