PREVIEW / etf_5min / 2022-05-24
file: by_date/etf_5min/2022/2022-05-24.parquet size: 2.0 MB rows: 97,437
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-24 04:00:00 | SPY | ETF | 392.38 | 392.38 | 391.61 | 391.65 | 18492.0 |
| 2022-05-24 04:05:00 | SPY | ETF | 391.64 | 391.96 | 391.64 | 391.96 | 1304.0 |
| 2022-05-24 04:10:00 | SPY | ETF | 391.93 | 392.17 | 391.78 | 392.07 | 2150.0 |
| 2022-05-24 04:15:00 | SPY | ETF | 392.02 | 392.02 | 391.63 | 391.9 | 2050.0 |
| 2022-05-24 04:20:00 | SPY | ETF | 391.7 | 392.0 | 391.57 | 392.0 | 3250.0 |
| 2022-05-24 04:25:00 | SPY | ETF | 392.03 | 392.03 | 391.8 | 391.96 | 8461.0 |
| 2022-05-24 04:30:00 | SPY | ETF | 392.08 | 392.08 | 392.08 | 392.08 | 100.0 |
| 2022-05-24 04:35:00 | SPY | ETF | 391.78 | 391.83 | 391.68 | 391.83 | 1987.0 |
| 2022-05-24 04:40:00 | SPY | ETF | 391.92 | 391.92 | 391.64 | 391.71 | 1000.0 |
| 2022-05-24 04:45:00 | SPY | ETF | 391.75 | 391.86 | 391.68 | 391.68 | 2293.0 |
| 2022-05-24 04:50:00 | SPY | ETF | 391.5 | 391.59 | 390.81 | 390.94 | 12921.0 |
| 2022-05-24 04:55:00 | SPY | ETF | 391.11 | 391.11 | 390.91 | 390.91 | 2274.0 |
| 2022-05-24 05:00:00 | SPY | ETF | 391.03 | 391.29 | 391.03 | 391.08 | 5975.0 |
| 2022-05-24 05:05:00 | SPY | ETF | 391.08 | 391.13 | 390.99 | 391.1 | 4583.0 |
| 2022-05-24 05:10:00 | SPY | ETF | 391.04 | 391.41 | 391.0 | 391.41 | 1562.0 |
| 2022-05-24 05:15:00 | SPY | ETF | 391.38 | 391.44 | 391.18 | 391.18 | 3889.0 |
| 2022-05-24 05:20:00 | SPY | ETF | 391.3 | 391.35 | 391.25 | 391.25 | 7049.0 |
| 2022-05-24 05:25:00 | SPY | ETF | 391.37 | 391.6 | 391.37 | 391.56 | 1102.0 |
| 2022-05-24 05:30:00 | SPY | ETF | 391.51 | 391.51 | 391.51 | 391.51 | 200.0 |
| 2022-05-24 05:35:00 | SPY | ETF | 391.6 | 391.77 | 391.6 | 391.7 | 2607.0 |
| 2022-05-24 05:40:00 | SPY | ETF | 391.67 | 391.67 | 391.66 | 391.66 | 1300.0 |
| 2022-05-24 05:45:00 | SPY | ETF | 391.85 | 392.0 | 391.8 | 392.0 | 4952.0 |
| 2022-05-24 05:50:00 | SPY | ETF | 392.04 | 392.17 | 391.99 | 391.99 | 3600.0 |
| 2022-05-24 05:55:00 | SPY | ETF | 392.3 | 392.4 | 392.22 | 392.22 | 900.0 |
| 2022-05-24 06:00:00 | SPY | ETF | 392.2 | 392.21 | 392.0 | 392.0 | 4440.0 |
| 2022-05-24 06:05:00 | SPY | ETF | 391.98 | 392.36 | 391.98 | 392.36 | 2400.0 |
| 2022-05-24 06:10:00 | SPY | ETF | 392.48 | 392.48 | 392.36 | 392.36 | 1400.0 |
| 2022-05-24 06:15:00 | SPY | ETF | 392.37 | 392.75 | 392.37 | 392.7 | 5962.0 |
| 2022-05-24 06:20:00 | SPY | ETF | 392.82 | 392.95 | 392.7 | 392.7 | 3100.0 |
| 2022-05-24 06:25:00 | SPY | ETF | 392.72 | 392.74 | 392.5 | 392.74 | 2077.0 |
| 2022-05-24 06:30:00 | SPY | ETF | 392.91 | 392.91 | 392.82 | 392.82 | 609.0 |
| 2022-05-24 06:35:00 | SPY | ETF | 392.6 | 392.6 | 392.49 | 392.58 | 3899.0 |
| 2022-05-24 06:40:00 | SPY | ETF | 392.52 | 392.6 | 392.45 | 392.46 | 899.0 |
| 2022-05-24 06:45:00 | SPY | ETF | 392.54 | 392.62 | 392.41 | 392.42 | 3000.0 |
| 2022-05-24 06:50:00 | SPY | ETF | 392.43 | 392.53 | 392.37 | 392.38 | 32444.0 |
| 2022-05-24 06:55:00 | SPY | ETF | 392.5 | 392.61 | 392.42 | 392.45 | 2518.0 |
| 2022-05-24 07:00:00 | SPY | ETF | 392.48 | 392.93 | 392.48 | 392.82 | 21422.0 |
| 2022-05-24 07:05:00 | SPY | ETF | 392.81 | 393.54 | 392.81 | 393.54 | 40330.0 |
| 2022-05-24 07:10:00 | SPY | ETF | 393.49 | 393.49 | 393.2 | 393.3 | 27793.0 |
| 2022-05-24 07:15:00 | SPY | ETF | 393.22 | 393.47 | 393.11 | 393.43 | 8091.0 |
| 2022-05-24 07:20:00 | SPY | ETF | 393.43 | 393.44 | 393.1 | 393.1 | 8595.0 |
| 2022-05-24 07:25:00 | SPY | ETF | 393.11 | 393.39 | 393.1 | 393.31 | 12413.0 |
| 2022-05-24 07:30:00 | SPY | ETF | 393.36 | 393.55 | 393.32 | 393.47 | 35510.0 |
| 2022-05-24 07:35:00 | SPY | ETF | 393.45 | 393.54 | 392.71 | 392.84 | 31048.0 |
| 2022-05-24 07:40:00 | SPY | ETF | 392.83 | 393.15 | 392.67 | 393.08 | 19912.0 |
| 2022-05-24 07:45:00 | SPY | ETF | 393.05 | 393.06 | 392.8 | 392.86 | 13531.0 |
| 2022-05-24 07:50:00 | SPY | ETF | 392.89 | 392.89 | 392.54 | 392.62 | 39602.0 |
| 2022-05-24 07:55:00 | SPY | ETF | 392.62 | 392.62 | 392.4 | 392.58 | 21410.0 |
| 2022-05-24 08:00:00 | SPY | ETF | 392.85 | 393.95 | 391.08 | 392.77 | 125080.0 |
| 2022-05-24 08:05:00 | SPY | ETF | 392.75 | 392.77 | 391.99 | 392.08 | 88420.0 |
> showing 50 of 97,437 rows — these rows as CSV