PREVIEW / etf_5min / 2022-12-07
file: by_date/etf_5min/2022/2022-12-07.parquet size: 2.0 MB rows: 98,592
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-12-07 04:00:00 | SPY | ETF | 395.0 | 395.0 | 394.3 | 394.34 | 2659.0 |
| 2022-12-07 04:05:00 | SPY | ETF | 394.35 | 394.37 | 394.18 | 394.18 | 1720.0 |
| 2022-12-07 04:10:00 | SPY | ETF | 394.26 | 394.43 | 394.26 | 394.35 | 25102.0 |
| 2022-12-07 04:15:00 | SPY | ETF | 394.34 | 394.45 | 394.27 | 394.34 | 10400.0 |
| 2022-12-07 04:20:00 | SPY | ETF | 394.24 | 394.24 | 393.94 | 393.94 | 2100.0 |
| 2022-12-07 04:25:00 | SPY | ETF | 394.0 | 394.0 | 393.91 | 393.91 | 1100.0 |
| 2022-12-07 04:30:00 | SPY | ETF | 393.87 | 393.94 | 393.69 | 393.69 | 2841.0 |
| 2022-12-07 04:35:00 | SPY | ETF | 393.6 | 393.6 | 393.4 | 393.45 | 6350.0 |
| 2022-12-07 04:40:00 | SPY | ETF | 393.51 | 393.51 | 393.15 | 393.23 | 8875.0 |
| 2022-12-07 04:45:00 | SPY | ETF | 393.08 | 393.21 | 393.02 | 393.1 | 1500.0 |
| 2022-12-07 04:50:00 | SPY | ETF | 393.09 | 393.3 | 393.09 | 393.19 | 6197.0 |
| 2022-12-07 04:55:00 | SPY | ETF | 393.2 | 393.34 | 393.19 | 393.24 | 5200.0 |
| 2022-12-07 05:00:00 | SPY | ETF | 393.32 | 393.4 | 393.32 | 393.36 | 1699.0 |
| 2022-12-07 05:05:00 | SPY | ETF | 393.3 | 393.3 | 393.26 | 393.26 | 1000.0 |
| 2022-12-07 05:10:00 | SPY | ETF | 393.16 | 393.31 | 393.16 | 393.3 | 1000.0 |
| 2022-12-07 05:15:00 | SPY | ETF | 393.32 | 393.42 | 393.32 | 393.42 | 400.0 |
| 2022-12-07 05:20:00 | SPY | ETF | 393.25 | 393.25 | 393.0 | 393.02 | 2750.0 |
| 2022-12-07 05:25:00 | SPY | ETF | 392.99 | 392.99 | 392.9 | 392.9 | 3182.0 |
| 2022-12-07 05:30:00 | SPY | ETF | 392.91 | 392.91 | 392.77 | 392.8 | 3343.0 |
| 2022-12-07 05:35:00 | SPY | ETF | 392.8 | 392.97 | 392.8 | 392.95 | 5148.0 |
| 2022-12-07 05:40:00 | SPY | ETF | 392.84 | 392.94 | 392.84 | 392.94 | 10254.0 |
| 2022-12-07 05:45:00 | SPY | ETF | 393.0 | 393.08 | 393.0 | 393.08 | 12088.0 |
| 2022-12-07 05:50:00 | SPY | ETF | 393.12 | 393.12 | 392.96 | 392.96 | 200.0 |
| 2022-12-07 05:55:00 | SPY | ETF | 393.0 | 393.2 | 393.0 | 393.2 | 876.0 |
| 2022-12-07 06:00:00 | SPY | ETF | 393.37 | 393.46 | 393.25 | 393.46 | 1000.0 |
| 2022-12-07 06:05:00 | SPY | ETF | 393.46 | 393.52 | 393.39 | 393.43 | 12208.0 |
| 2022-12-07 06:10:00 | SPY | ETF | 393.4 | 393.4 | 393.25 | 393.25 | 15564.0 |
| 2022-12-07 06:15:00 | SPY | ETF | 393.3 | 393.35 | 393.16 | 393.16 | 5325.0 |
| 2022-12-07 06:20:00 | SPY | ETF | 393.07 | 393.07 | 393.04 | 393.04 | 220.0 |
| 2022-12-07 06:25:00 | SPY | ETF | 393.01 | 393.24 | 392.97 | 392.97 | 3877.0 |
| 2022-12-07 06:30:00 | SPY | ETF | 392.95 | 393.09 | 392.95 | 393.09 | 2071.0 |
| 2022-12-07 06:35:00 | SPY | ETF | 393.14 | 393.3 | 393.14 | 393.27 | 1167.0 |
| 2022-12-07 06:40:00 | SPY | ETF | 393.25 | 393.28 | 392.52 | 392.52 | 6724.0 |
| 2022-12-07 06:45:00 | SPY | ETF | 392.46 | 392.5 | 392.26 | 392.42 | 16096.0 |
| 2022-12-07 06:50:00 | SPY | ETF | 392.39 | 392.51 | 392.29 | 392.51 | 3504.0 |
| 2022-12-07 06:55:00 | SPY | ETF | 392.51 | 392.51 | 392.44 | 392.5 | 1900.0 |
| 2022-12-07 07:00:00 | SPY | ETF | 392.55 | 392.76 | 392.5 | 392.76 | 20368.0 |
| 2022-12-07 07:05:00 | SPY | ETF | 392.71 | 392.71 | 392.39 | 392.39 | 7775.0 |
| 2022-12-07 07:10:00 | SPY | ETF | 392.33 | 392.33 | 392.23 | 392.29 | 22044.0 |
| 2022-12-07 07:15:00 | SPY | ETF | 392.25 | 392.3 | 392.13 | 392.26 | 17515.0 |
| 2022-12-07 07:20:00 | SPY | ETF | 392.1 | 392.1 | 391.22 | 391.36 | 52343.0 |
| 2022-12-07 07:25:00 | SPY | ETF | 391.34 | 391.45 | 391.11 | 391.34 | 54242.0 |
| 2022-12-07 07:30:00 | SPY | ETF | 391.33 | 391.4 | 391.26 | 391.26 | 23602.0 |
| 2022-12-07 07:35:00 | SPY | ETF | 391.22 | 391.35 | 390.99 | 391.28 | 37231.0 |
| 2022-12-07 07:40:00 | SPY | ETF | 391.29 | 391.3 | 391.2 | 391.27 | 56390.0 |
| 2022-12-07 07:45:00 | SPY | ETF | 391.26 | 391.53 | 391.25 | 391.5 | 32783.0 |
| 2022-12-07 07:50:00 | SPY | ETF | 391.5 | 391.59 | 391.35 | 391.4 | 24982.0 |
| 2022-12-07 07:55:00 | SPY | ETF | 391.41 | 391.62 | 391.4 | 391.5 | 32010.0 |
| 2022-12-07 08:00:00 | SPY | ETF | 392.3475 | 394.5096 | 391.07 | 391.71 | 87048.0 |
| 2022-12-07 08:05:00 | SPY | ETF | 391.71 | 391.87 | 391.65 | 391.86 | 15275.0 |
> showing 50 of 98,592 rows — these rows as CSV