PREVIEW / etf_5min / 2022-11-17
file: by_date/etf_5min/2022/2022-11-17.parquet size: 2.0 MB rows: 97,508
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-11-17 04:00:00 | SPY | ETF | 396.27 | 396.41 | 396.09 | 396.09 | 5495.0 |
| 2022-11-17 04:05:00 | SPY | ETF | 396.2 | 396.2 | 395.79 | 395.97 | 5100.0 |
| 2022-11-17 04:10:00 | SPY | ETF | 395.97 | 396.01 | 395.94 | 395.94 | 20600.0 |
| 2022-11-17 04:15:00 | SPY | ETF | 395.93 | 396.09 | 395.93 | 396.04 | 1179.0 |
| 2022-11-17 04:20:00 | SPY | ETF | 396.13 | 396.13 | 395.98 | 395.98 | 300.0 |
| 2022-11-17 04:25:00 | SPY | ETF | 396.08 | 396.11 | 395.99 | 396.01 | 1485.0 |
| 2022-11-17 04:30:00 | SPY | ETF | 395.91 | 395.91 | 395.34 | 395.34 | 11477.0 |
| 2022-11-17 04:35:00 | SPY | ETF | 395.32 | 395.32 | 394.94 | 395.11 | 37109.0 |
| 2022-11-17 04:40:00 | SPY | ETF | 395.16 | 395.23 | 395.15 | 395.15 | 500.0 |
| 2022-11-17 04:45:00 | SPY | ETF | 395.16 | 395.23 | 395.1 | 395.1 | 3600.0 |
| 2022-11-17 04:50:00 | SPY | ETF | 394.85 | 394.85 | 394.49 | 394.85 | 3100.0 |
| 2022-11-17 04:55:00 | SPY | ETF | 394.81 | 394.82 | 394.65 | 394.77 | 11300.0 |
| 2022-11-17 05:00:00 | SPY | ETF | 394.9 | 395.1 | 394.88 | 394.91 | 1361.0 |
| 2022-11-17 05:05:00 | SPY | ETF | 395.0 | 395.0 | 395.0 | 395.0 | 100.0 |
| 2022-11-17 05:10:00 | SPY | ETF | 394.71 | 394.92 | 394.71 | 394.92 | 954.0 |
| 2022-11-17 05:15:00 | SPY | ETF | 395.0 | 395.14 | 395.0 | 395.14 | 5600.0 |
| 2022-11-17 05:20:00 | SPY | ETF | 395.1 | 395.17 | 395.1 | 395.17 | 760.0 |
| 2022-11-17 05:25:00 | SPY | ETF | 395.31 | 395.45 | 395.31 | 395.38 | 4200.0 |
| 2022-11-17 05:30:00 | SPY | ETF | 395.39 | 395.39 | 395.0 | 395.0 | 4580.0 |
| 2022-11-17 05:35:00 | SPY | ETF | 394.95 | 395.01 | 394.8 | 395.01 | 5400.0 |
| 2022-11-17 05:40:00 | SPY | ETF | 394.92 | 394.92 | 394.92 | 394.92 | 100.0 |
| 2022-11-17 05:45:00 | SPY | ETF | 394.75 | 394.75 | 394.3 | 394.36 | 17498.0 |
| 2022-11-17 05:50:00 | SPY | ETF | 394.3 | 394.3 | 393.49 | 393.49 | 8282.0 |
| 2022-11-17 05:55:00 | SPY | ETF | 393.46 | 393.48 | 393.35 | 393.35 | 5281.0 |
| 2022-11-17 06:00:00 | SPY | ETF | 393.26 | 393.69 | 393.25 | 393.56 | 18920.0 |
| 2022-11-17 06:05:00 | SPY | ETF | 393.64 | 393.76 | 393.64 | 393.76 | 4304.0 |
| 2022-11-17 06:10:00 | SPY | ETF | 393.71 | 393.71 | 393.35 | 393.35 | 3300.0 |
| 2022-11-17 06:15:00 | SPY | ETF | 393.3 | 393.5 | 393.3 | 393.4 | 2650.0 |
| 2022-11-17 06:20:00 | SPY | ETF | 393.43 | 393.43 | 392.99 | 393.05 | 4837.0 |
| 2022-11-17 06:25:00 | SPY | ETF | 393.13 | 393.14 | 392.88 | 392.95 | 23517.0 |
| 2022-11-17 06:30:00 | SPY | ETF | 393.02 | 393.22 | 393.02 | 393.1 | 9975.0 |
| 2022-11-17 06:35:00 | SPY | ETF | 393.19 | 393.2 | 392.38 | 392.61 | 13385.0 |
| 2022-11-17 06:40:00 | SPY | ETF | 392.5 | 392.66 | 392.33 | 392.65 | 8863.0 |
| 2022-11-17 06:45:00 | SPY | ETF | 392.7 | 393.0 | 392.7 | 392.93 | 15237.0 |
| 2022-11-17 06:50:00 | SPY | ETF | 393.0 | 393.36 | 393.0 | 393.17 | 23213.0 |
| 2022-11-17 06:55:00 | SPY | ETF | 393.23 | 393.33 | 393.06 | 393.33 | 6575.0 |
| 2022-11-17 07:00:00 | SPY | ETF | 393.38 | 393.53 | 393.07 | 393.07 | 34388.0 |
| 2022-11-17 07:05:00 | SPY | ETF | 393.06 | 393.07 | 392.8 | 393.0 | 20852.0 |
| 2022-11-17 07:10:00 | SPY | ETF | 393.05 | 393.05 | 392.84 | 392.85 | 40905.0 |
| 2022-11-17 07:15:00 | SPY | ETF | 392.98 | 393.2 | 392.94 | 392.94 | 48581.0 |
| 2022-11-17 07:20:00 | SPY | ETF | 393.0 | 393.0 | 392.68 | 392.9 | 23209.0 |
| 2022-11-17 07:25:00 | SPY | ETF | 392.86 | 393.35 | 392.83 | 392.87 | 27311.0 |
| 2022-11-17 07:30:00 | SPY | ETF | 392.97 | 393.0 | 392.6 | 392.6 | 33194.0 |
| 2022-11-17 07:35:00 | SPY | ETF | 392.55 | 392.7 | 392.31 | 392.31 | 31495.0 |
| 2022-11-17 07:40:00 | SPY | ETF | 392.31 | 392.53 | 392.13 | 392.23 | 22768.0 |
| 2022-11-17 07:45:00 | SPY | ETF | 392.19 | 392.2 | 391.98 | 392.12 | 17590.0 |
| 2022-11-17 07:50:00 | SPY | ETF | 392.12 | 392.35 | 392.05 | 392.28 | 46900.0 |
| 2022-11-17 07:55:00 | SPY | ETF | 392.25 | 392.32 | 392.0 | 392.17 | 18905.0 |
| 2022-11-17 08:00:00 | SPY | ETF | 393.47 | 397.12 | 391.4 | 391.4 | 229531.0 |
| 2022-11-17 08:05:00 | SPY | ETF | 391.4 | 391.43 | 391.01 | 391.04 | 143132.0 |
> showing 50 of 97,508 rows — these rows as CSV