PREVIEW / etf_5min / 2022-08-26
file: by_date/etf_5min/2022/2022-08-26.parquet size: 1.9 MB rows: 92,625
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-08-26 04:00:00 | SPY | ETF | 419.1 | 419.1 | 418.08 | 418.14 | 12945.0 |
| 2022-08-26 04:05:00 | SPY | ETF | 418.14 | 418.21 | 418.13 | 418.13 | 997.0 |
| 2022-08-26 04:10:00 | SPY | ETF | 418.12 | 418.22 | 418.06 | 418.21 | 2306.0 |
| 2022-08-26 04:15:00 | SPY | ETF | 418.1 | 418.14 | 418.09 | 418.14 | 750.0 |
| 2022-08-26 04:20:00 | SPY | ETF | 418.12 | 418.12 | 418.08 | 418.12 | 1500.0 |
| 2022-08-26 04:25:00 | SPY | ETF | 418.04 | 418.04 | 418.04 | 418.04 | 165.0 |
| 2022-08-26 04:30:00 | SPY | ETF | 418.01 | 418.31 | 417.86 | 418.31 | 18344.0 |
| 2022-08-26 04:35:00 | SPY | ETF | 418.39 | 418.45 | 418.36 | 418.38 | 5300.0 |
| 2022-08-26 04:40:00 | SPY | ETF | 418.38 | 418.45 | 418.38 | 418.45 | 7353.0 |
| 2022-08-26 04:45:00 | SPY | ETF | 418.45 | 418.48 | 418.45 | 418.48 | 1500.0 |
| 2022-08-26 04:50:00 | SPY | ETF | 418.56 | 418.56 | 418.27 | 418.27 | 8619.0 |
| 2022-08-26 04:55:00 | SPY | ETF | 418.28 | 418.28 | 418.21 | 418.22 | 714.0 |
| 2022-08-26 05:00:00 | SPY | ETF | 418.13 | 418.14 | 418.12 | 418.12 | 1400.0 |
| 2022-08-26 05:05:00 | SPY | ETF | 418.09 | 418.09 | 418.09 | 418.09 | 400.0 |
| 2022-08-26 05:10:00 | SPY | ETF | 418.12 | 418.15 | 418.12 | 418.14 | 800.0 |
| 2022-08-26 05:15:00 | SPY | ETF | 418.31 | 418.31 | 418.15 | 418.15 | 400.0 |
| 2022-08-26 05:20:00 | SPY | ETF | 418.0 | 418.0 | 417.87 | 417.96 | 1418.0 |
| 2022-08-26 05:25:00 | SPY | ETF | 418.12 | 418.19 | 417.99 | 418.02 | 7500.0 |
| 2022-08-26 05:30:00 | SPY | ETF | 417.92 | 417.92 | 417.81 | 417.86 | 1760.0 |
| 2022-08-26 05:35:00 | SPY | ETF | 418.02 | 418.02 | 418.02 | 418.02 | 100.0 |
| 2022-08-26 05:40:00 | SPY | ETF | 418.02 | 418.07 | 418.01 | 418.07 | 5244.0 |
| 2022-08-26 05:45:00 | SPY | ETF | 418.0 | 418.0 | 417.75 | 417.75 | 3490.0 |
| 2022-08-26 05:50:00 | SPY | ETF | 417.75 | 417.79 | 417.71 | 417.74 | 4915.0 |
| 2022-08-26 05:55:00 | SPY | ETF | 417.7 | 417.86 | 417.7 | 417.86 | 6566.0 |
| 2022-08-26 06:00:00 | SPY | ETF | 417.86 | 417.92 | 417.86 | 417.9 | 900.0 |
| 2022-08-26 06:05:00 | SPY | ETF | 417.8 | 417.9 | 417.8 | 417.83 | 1710.0 |
| 2022-08-26 06:10:00 | SPY | ETF | 417.76 | 417.76 | 417.75 | 417.76 | 23926.0 |
| 2022-08-26 06:15:00 | SPY | ETF | 417.84 | 417.9 | 417.83 | 417.9 | 3500.0 |
| 2022-08-26 06:20:00 | SPY | ETF | 417.86 | 418.13 | 417.84 | 418.09 | 6150.0 |
| 2022-08-26 06:25:00 | SPY | ETF | 418.07 | 418.09 | 418.02 | 418.02 | 2890.0 |
| 2022-08-26 06:30:00 | SPY | ETF | 418.02 | 418.02 | 417.74 | 417.74 | 5450.0 |
| 2022-08-26 06:35:00 | SPY | ETF | 417.7 | 417.83 | 417.62 | 417.78 | 8275.0 |
| 2022-08-26 06:40:00 | SPY | ETF | 417.71 | 417.8 | 417.6 | 417.65 | 51106.0 |
| 2022-08-26 06:45:00 | SPY | ETF | 417.65 | 417.65 | 417.59 | 417.65 | 56683.0 |
| 2022-08-26 06:50:00 | SPY | ETF | 417.8 | 417.8 | 417.64 | 417.66 | 2000.0 |
| 2022-08-26 06:55:00 | SPY | ETF | 417.65 | 417.75 | 417.62 | 417.75 | 1807.0 |
| 2022-08-26 07:00:00 | SPY | ETF | 417.84 | 417.9 | 417.53 | 417.6 | 23253.0 |
| 2022-08-26 07:05:00 | SPY | ETF | 417.54 | 417.58 | 417.39 | 417.56 | 15932.0 |
| 2022-08-26 07:10:00 | SPY | ETF | 417.56 | 417.75 | 417.56 | 417.75 | 8063.0 |
| 2022-08-26 07:15:00 | SPY | ETF | 417.75 | 417.82 | 417.72 | 417.82 | 6449.0 |
| 2022-08-26 07:20:00 | SPY | ETF | 417.8 | 417.86 | 417.76 | 417.8 | 5223.0 |
| 2022-08-26 07:25:00 | SPY | ETF | 417.75 | 417.89 | 417.74 | 417.83 | 7830.0 |
| 2022-08-26 07:30:00 | SPY | ETF | 417.74 | 418.03 | 417.72 | 418.0 | 9730.0 |
| 2022-08-26 07:35:00 | SPY | ETF | 418.02 | 418.18 | 418.0 | 418.18 | 4809.0 |
| 2022-08-26 07:40:00 | SPY | ETF | 418.2 | 418.26 | 418.1 | 418.26 | 11735.0 |
| 2022-08-26 07:45:00 | SPY | ETF | 418.15 | 418.34 | 418.15 | 418.34 | 4997.0 |
| 2022-08-26 07:50:00 | SPY | ETF | 418.32 | 418.45 | 418.27 | 418.45 | 7070.0 |
| 2022-08-26 07:55:00 | SPY | ETF | 418.52 | 418.52 | 418.24 | 418.32 | 6623.0 |
| 2022-08-26 08:00:00 | SPY | ETF | 417.67 | 418.82 | 417.46 | 418.2 | 61772.0 |
| 2022-08-26 08:05:00 | SPY | ETF | 418.21 | 418.35 | 418.2 | 418.3 | 9898.0 |
> showing 50 of 92,625 rows — these rows as CSV