PREVIEW / etf_5min / 2024-01-05
file: by_date/etf_5min/2024/2024-01-05.parquet size: 2.2 MB rows: 107,501
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-05 04:00:00 | SPY | ETF | 466.86 | 467.28 | 466.65 | 466.65 | 3828.0 |
| 2024-01-05 04:05:00 | SPY | ETF | 466.46 | 466.5 | 466.35 | 466.44 | 4409.0 |
| 2024-01-05 04:10:00 | SPY | ETF | 466.57 | 466.58 | 466.5 | 466.58 | 1052.0 |
| 2024-01-05 04:15:00 | SPY | ETF | 466.55 | 466.69 | 466.55 | 466.69 | 500.0 |
| 2024-01-05 04:20:00 | SPY | ETF | 466.84 | 466.93 | 466.84 | 466.93 | 634.0 |
| 2024-01-05 04:25:00 | SPY | ETF | 466.85 | 466.85 | 466.82 | 466.82 | 380.0 |
| 2024-01-05 04:30:00 | SPY | ETF | 466.8 | 466.8 | 466.8 | 466.8 | 400.0 |
| 2024-01-05 04:35:00 | SPY | ETF | 466.66 | 466.66 | 466.4 | 466.4 | 685.0 |
| 2024-01-05 04:40:00 | SPY | ETF | 466.45 | 466.45 | 466.28 | 466.28 | 1400.0 |
| 2024-01-05 04:45:00 | SPY | ETF | 466.35 | 466.4 | 466.35 | 466.4 | 500.0 |
| 2024-01-05 04:55:00 | SPY | ETF | 466.3 | 466.3 | 466.3 | 466.3 | 400.0 |
| 2024-01-05 05:00:00 | SPY | ETF | 466.34 | 466.385 | 466.33 | 466.385 | 1200.0 |
| 2024-01-05 05:05:00 | SPY | ETF | 466.455 | 466.48 | 466.3 | 466.3 | 800.0 |
| 2024-01-05 05:10:00 | SPY | ETF | 466.48 | 466.48 | 466.48 | 466.48 | 1200.0 |
| 2024-01-05 05:15:00 | SPY | ETF | 466.45 | 466.46 | 466.45 | 466.46 | 600.0 |
| 2024-01-05 05:20:00 | SPY | ETF | 466.35 | 466.38 | 466.34 | 466.34 | 407.0 |
| 2024-01-05 05:25:00 | SPY | ETF | 466.25 | 466.27 | 466.19 | 466.19 | 2024.0 |
| 2024-01-05 05:30:00 | SPY | ETF | 466.22 | 466.23 | 466.19 | 466.19 | 1601.0 |
| 2024-01-05 05:35:00 | SPY | ETF | 466.2 | 466.2 | 466.17 | 466.17 | 295.0 |
| 2024-01-05 05:40:00 | SPY | ETF | 466.19 | 466.2 | 466.18 | 466.19 | 693.0 |
| 2024-01-05 05:45:00 | SPY | ETF | 466.06 | 466.06 | 466.06 | 466.06 | 850.0 |
| 2024-01-05 05:50:00 | SPY | ETF | 466.0 | 466.19 | 465.88 | 466.19 | 1750.0 |
| 2024-01-05 05:55:00 | SPY | ETF | 466.18 | 466.18 | 466.18 | 466.18 | 100.0 |
| 2024-01-05 06:00:00 | SPY | ETF | 466.32 | 466.4 | 466.32 | 466.4 | 1293.0 |
| 2024-01-05 06:05:00 | SPY | ETF | 466.42 | 466.43 | 466.41 | 466.43 | 700.0 |
| 2024-01-05 06:10:00 | SPY | ETF | 466.39 | 466.39 | 466.25 | 466.25 | 1498.0 |
| 2024-01-05 06:15:00 | SPY | ETF | 466.27 | 466.27 | 466.27 | 466.27 | 200.0 |
| 2024-01-05 06:25:00 | SPY | ETF | 466.05 | 466.05 | 465.88 | 465.88 | 2333.0 |
| 2024-01-05 06:30:00 | SPY | ETF | 465.89 | 465.9 | 465.72 | 465.76 | 1992.0 |
| 2024-01-05 06:35:00 | SPY | ETF | 465.71 | 465.75 | 465.65 | 465.75 | 2342.0 |
| 2024-01-05 06:40:00 | SPY | ETF | 465.84 | 465.85 | 465.78 | 465.83 | 5975.0 |
| 2024-01-05 06:45:00 | SPY | ETF | 465.86 | 466.03 | 465.86 | 466.03 | 1100.0 |
| 2024-01-05 06:50:00 | SPY | ETF | 465.94 | 466.0 | 465.94 | 466.0 | 1100.0 |
| 2024-01-05 06:55:00 | SPY | ETF | 466.07 | 466.17 | 466.07 | 466.17 | 1200.0 |
| 2024-01-05 07:00:00 | SPY | ETF | 466.22 | 466.3 | 466.205 | 466.24 | 29274.0 |
| 2024-01-05 07:05:00 | SPY | ETF | 466.16 | 466.16 | 466.0 | 466.03 | 3034.0 |
| 2024-01-05 07:10:00 | SPY | ETF | 466.03 | 466.28 | 466.03 | 466.25 | 9041.0 |
| 2024-01-05 07:15:00 | SPY | ETF | 466.22 | 466.33 | 466.2 | 466.31 | 7808.0 |
| 2024-01-05 07:20:00 | SPY | ETF | 466.29 | 466.35 | 466.16 | 466.35 | 18412.0 |
| 2024-01-05 07:25:00 | SPY | ETF | 466.35 | 466.4 | 466.31 | 466.39 | 12611.0 |
| 2024-01-05 07:30:00 | SPY | ETF | 466.4 | 466.43 | 466.36 | 466.36 | 2461.0 |
| 2024-01-05 07:35:00 | SPY | ETF | 466.37 | 466.5 | 466.32 | 466.35 | 10360.0 |
| 2024-01-05 07:40:00 | SPY | ETF | 466.34 | 466.4 | 466.3 | 466.34 | 10300.0 |
| 2024-01-05 07:45:00 | SPY | ETF | 466.37 | 466.4 | 466.24 | 466.24 | 6110.0 |
| 2024-01-05 07:50:00 | SPY | ETF | 466.16 | 466.19 | 465.91 | 466.07 | 28398.0 |
| 2024-01-05 07:55:00 | SPY | ETF | 466.13 | 466.13 | 466.08 | 466.11 | 5700.0 |
| 2024-01-05 08:00:00 | SPY | ETF | 466.2191 | 467.52 | 465.6904 | 465.83 | 56471.0 |
| 2024-01-05 08:05:00 | SPY | ETF | 465.9 | 466.0183 | 465.83 | 465.91 | 32052.0 |
| 2024-01-05 08:10:00 | SPY | ETF | 466.0 | 466.27 | 465.99 | 466.27 | 43485.0 |
| 2024-01-05 08:15:00 | SPY | ETF | 466.27 | 466.8 | 466.27 | 466.8 | 68587.0 |
> showing 50 of 107,501 rows — these rows as CSV