PREVIEW / etf_5min / 2022-05-25
file: by_date/etf_5min/2022/2022-05-25.parquet size: 2.0 MB rows: 95,456
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-05-25 04:00:00 | SPY | ETF | 394.62 | 394.62 | 394.04 | 394.15 | 6394.0 |
| 2022-05-25 04:05:00 | SPY | ETF | 394.25 | 394.25 | 393.47 | 393.47 | 30386.0 |
| 2022-05-25 04:10:00 | SPY | ETF | 393.37 | 393.69 | 393.37 | 393.67 | 5300.0 |
| 2022-05-25 04:15:00 | SPY | ETF | 393.61 | 393.61 | 393.35 | 393.55 | 3300.0 |
| 2022-05-25 04:20:00 | SPY | ETF | 393.65 | 393.73 | 393.6 | 393.72 | 1900.0 |
| 2022-05-25 04:25:00 | SPY | ETF | 393.73 | 393.73 | 393.73 | 393.73 | 100.0 |
| 2022-05-25 04:30:00 | SPY | ETF | 393.83 | 394.13 | 393.83 | 394.13 | 607.0 |
| 2022-05-25 04:35:00 | SPY | ETF | 394.28 | 394.31 | 394.28 | 394.31 | 615.0 |
| 2022-05-25 04:40:00 | SPY | ETF | 394.18 | 394.3 | 394.18 | 394.21 | 600.0 |
| 2022-05-25 04:45:00 | SPY | ETF | 394.17 | 394.19 | 394.16 | 394.19 | 3400.0 |
| 2022-05-25 04:50:00 | SPY | ETF | 394.22 | 394.36 | 394.22 | 394.31 | 1600.0 |
| 2022-05-25 04:55:00 | SPY | ETF | 394.31 | 394.31 | 393.79 | 393.8 | 4700.0 |
| 2022-05-25 05:00:00 | SPY | ETF | 393.69 | 393.69 | 393.41 | 393.41 | 902.0 |
| 2022-05-25 05:05:00 | SPY | ETF | 393.36 | 393.41 | 393.29 | 393.41 | 1000.0 |
| 2022-05-25 05:10:00 | SPY | ETF | 393.41 | 393.41 | 392.84 | 392.84 | 3998.0 |
| 2022-05-25 05:15:00 | SPY | ETF | 392.8 | 393.21 | 392.71 | 393.21 | 13749.0 |
| 2022-05-25 05:20:00 | SPY | ETF | 393.23 | 393.28 | 393.13 | 393.21 | 1975.0 |
| 2022-05-25 05:25:00 | SPY | ETF | 393.2 | 393.45 | 393.2 | 393.45 | 3567.0 |
| 2022-05-25 05:30:00 | SPY | ETF | 393.2 | 393.64 | 393.13 | 393.64 | 4794.0 |
| 2022-05-25 05:35:00 | SPY | ETF | 393.7 | 393.74 | 393.7 | 393.71 | 2400.0 |
| 2022-05-25 05:40:00 | SPY | ETF | 393.63 | 393.63 | 393.63 | 393.63 | 500.0 |
| 2022-05-25 05:45:00 | SPY | ETF | 393.73 | 393.77 | 393.73 | 393.77 | 400.0 |
| 2022-05-25 05:50:00 | SPY | ETF | 393.84 | 394.21 | 393.84 | 394.2 | 1295.0 |
| 2022-05-25 05:55:00 | SPY | ETF | 394.18 | 394.18 | 394.18 | 394.18 | 600.0 |
| 2022-05-25 06:00:00 | SPY | ETF | 394.09 | 394.31 | 394.09 | 394.31 | 6510.0 |
| 2022-05-25 06:05:00 | SPY | ETF | 394.3 | 394.35 | 394.27 | 394.3 | 1507.0 |
| 2022-05-25 06:10:00 | SPY | ETF | 394.41 | 394.41 | 394.08 | 394.08 | 2500.0 |
| 2022-05-25 06:15:00 | SPY | ETF | 394.03 | 394.03 | 393.97 | 394.0 | 750.0 |
| 2022-05-25 06:20:00 | SPY | ETF | 394.01 | 394.01 | 394.01 | 394.01 | 100.0 |
| 2022-05-25 06:25:00 | SPY | ETF | 394.3 | 394.41 | 394.2 | 394.3 | 9466.0 |
| 2022-05-25 06:30:00 | SPY | ETF | 393.98 | 393.98 | 393.96 | 393.96 | 1100.0 |
| 2022-05-25 06:35:00 | SPY | ETF | 393.75 | 393.75 | 393.63 | 393.63 | 1385.0 |
| 2022-05-25 06:40:00 | SPY | ETF | 393.75 | 394.0 | 393.7 | 393.94 | 10797.0 |
| 2022-05-25 06:45:00 | SPY | ETF | 393.33 | 393.4 | 393.1 | 393.13 | 2700.0 |
| 2022-05-25 06:50:00 | SPY | ETF | 393.06 | 393.19 | 392.91 | 393.1 | 16578.0 |
| 2022-05-25 06:55:00 | SPY | ETF | 393.06 | 393.13 | 392.95 | 392.99 | 20626.0 |
| 2022-05-25 07:00:00 | SPY | ETF | 393.01 | 393.32 | 392.9 | 393.24 | 14768.0 |
| 2022-05-25 07:05:00 | SPY | ETF | 393.24 | 393.41 | 393.22 | 393.26 | 5714.0 |
| 2022-05-25 07:10:00 | SPY | ETF | 393.22 | 393.22 | 392.71 | 392.83 | 18789.0 |
| 2022-05-25 07:15:00 | SPY | ETF | 392.88 | 392.95 | 392.51 | 392.65 | 22673.0 |
| 2022-05-25 07:20:00 | SPY | ETF | 392.69 | 392.72 | 392.2 | 392.2 | 78813.0 |
| 2022-05-25 07:25:00 | SPY | ETF | 392.19 | 392.2 | 391.62 | 392.2 | 42596.0 |
| 2022-05-25 07:30:00 | SPY | ETF | 392.13 | 392.38 | 391.78 | 391.92 | 73754.0 |
| 2022-05-25 07:35:00 | SPY | ETF | 391.84 | 392.0 | 391.56 | 391.9 | 87637.0 |
| 2022-05-25 07:40:00 | SPY | ETF | 391.89 | 391.89 | 391.45 | 391.53 | 84936.0 |
| 2022-05-25 07:45:00 | SPY | ETF | 391.53 | 391.88 | 391.39 | 391.81 | 34654.0 |
| 2022-05-25 07:50:00 | SPY | ETF | 391.83 | 392.23 | 391.8 | 392.2 | 22960.0 |
| 2022-05-25 07:55:00 | SPY | ETF | 392.16 | 392.52 | 391.97 | 392.07 | 22915.0 |
| 2022-05-25 08:00:00 | SPY | ETF | 393.11 | 396.54 | 391.37 | 391.97 | 79834.0 |
| 2022-05-25 08:05:00 | SPY | ETF | 392.03 | 392.04 | 391.6 | 391.6 | 69326.0 |
> showing 50 of 95,456 rows — these rows as CSV