PREVIEW / etf_5min / 2022-01-04
file: by_date/etf_5min/2022/2022-01-04.parquet size: 2.0 MB rows: 96,496
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-01-04 04:00:00 | SPY | ETF | 478.49 | 478.54 | 478.43 | 478.48 | 1767.0 |
| 2022-01-04 04:05:00 | SPY | ETF | 478.54 | 478.55 | 478.53 | 478.53 | 600.0 |
| 2022-01-04 04:10:00 | SPY | ETF | 478.53 | 478.65 | 478.52 | 478.63 | 3231.0 |
| 2022-01-04 04:15:00 | SPY | ETF | 478.58 | 478.71 | 478.57 | 478.68 | 3399.0 |
| 2022-01-04 04:20:00 | SPY | ETF | 478.71 | 478.71 | 478.61 | 478.66 | 930.0 |
| 2022-01-04 04:25:00 | SPY | ETF | 478.63 | 478.66 | 478.63 | 478.66 | 524.0 |
| 2022-01-04 04:30:00 | SPY | ETF | 478.64 | 478.64 | 478.57 | 478.57 | 1990.0 |
| 2022-01-04 04:35:00 | SPY | ETF | 478.5 | 478.5 | 478.47 | 478.5 | 2742.0 |
| 2022-01-04 04:40:00 | SPY | ETF | 478.55 | 478.55 | 478.48 | 478.55 | 1000.0 |
| 2022-01-04 04:45:00 | SPY | ETF | 478.65 | 478.67 | 478.65 | 478.67 | 1600.0 |
| 2022-01-04 04:50:00 | SPY | ETF | 478.69 | 478.72 | 478.66 | 478.72 | 1038.0 |
| 2022-01-04 04:55:00 | SPY | ETF | 478.66 | 478.68 | 478.66 | 478.68 | 200.0 |
| 2022-01-04 05:00:00 | SPY | ETF | 478.81 | 478.91 | 478.81 | 478.86 | 1614.0 |
| 2022-01-04 05:05:00 | SPY | ETF | 478.88 | 479.05 | 478.85 | 479.04 | 1054.0 |
| 2022-01-04 05:10:00 | SPY | ETF | 479.03 | 479.34 | 479.03 | 479.29 | 2799.0 |
| 2022-01-04 05:15:00 | SPY | ETF | 479.19 | 479.23 | 479.16 | 479.19 | 1286.0 |
| 2022-01-04 05:20:00 | SPY | ETF | 479.34 | 479.5 | 479.32 | 479.5 | 10705.0 |
| 2022-01-04 05:25:00 | SPY | ETF | 479.47 | 479.47 | 479.45 | 479.45 | 400.0 |
| 2022-01-04 05:30:00 | SPY | ETF | 479.58 | 479.58 | 479.52 | 479.54 | 1701.0 |
| 2022-01-04 05:35:00 | SPY | ETF | 479.58 | 479.58 | 479.42 | 479.49 | 1502.0 |
| 2022-01-04 05:40:00 | SPY | ETF | 479.52 | 479.59 | 479.48 | 479.58 | 1310.0 |
| 2022-01-04 05:45:00 | SPY | ETF | 479.57 | 479.61 | 479.45 | 479.45 | 1561.0 |
| 2022-01-04 05:50:00 | SPY | ETF | 479.5 | 479.5 | 479.4 | 479.4 | 3785.0 |
| 2022-01-04 05:55:00 | SPY | ETF | 479.38 | 479.5 | 479.38 | 479.5 | 2606.0 |
| 2022-01-04 06:00:00 | SPY | ETF | 479.47 | 479.69 | 479.43 | 479.69 | 1100.0 |
| 2022-01-04 06:05:00 | SPY | ETF | 479.65 | 479.79 | 479.65 | 479.79 | 1791.0 |
| 2022-01-04 06:10:00 | SPY | ETF | 479.79 | 479.84 | 479.73 | 479.81 | 2548.0 |
| 2022-01-04 06:15:00 | SPY | ETF | 479.77 | 479.79 | 479.7 | 479.79 | 3761.0 |
| 2022-01-04 06:20:00 | SPY | ETF | 479.78 | 479.84 | 479.71 | 479.71 | 2505.0 |
| 2022-01-04 06:25:00 | SPY | ETF | 479.68 | 479.68 | 479.49 | 479.53 | 1004.0 |
| 2022-01-04 06:30:00 | SPY | ETF | 479.6 | 479.62 | 479.59 | 479.6 | 3380.0 |
| 2022-01-04 06:35:00 | SPY | ETF | 479.49 | 479.57 | 479.45 | 479.57 | 1265.0 |
| 2022-01-04 06:40:00 | SPY | ETF | 479.61 | 479.61 | 479.61 | 479.61 | 285.0 |
| 2022-01-04 06:45:00 | SPY | ETF | 479.56 | 479.56 | 479.56 | 479.56 | 204.0 |
| 2022-01-04 06:50:00 | SPY | ETF | 479.61 | 479.63 | 479.61 | 479.63 | 500.0 |
| 2022-01-04 06:55:00 | SPY | ETF | 479.58 | 479.59 | 479.41 | 479.41 | 720.0 |
| 2022-01-04 07:00:00 | SPY | ETF | 479.4 | 479.45 | 479.36 | 479.36 | 25848.0 |
| 2022-01-04 07:05:00 | SPY | ETF | 479.35 | 479.43 | 479.311 | 479.36 | 10091.0 |
| 2022-01-04 07:10:00 | SPY | ETF | 479.371 | 479.45 | 479.27 | 479.27 | 7098.0 |
| 2022-01-04 07:15:00 | SPY | ETF | 479.3 | 479.33 | 479.2 | 479.22 | 5914.0 |
| 2022-01-04 07:20:00 | SPY | ETF | 479.22 | 479.25 | 478.9 | 478.9 | 8865.0 |
| 2022-01-04 07:25:00 | SPY | ETF | 478.91 | 478.92 | 478.65 | 478.75 | 15291.0 |
| 2022-01-04 07:30:00 | SPY | ETF | 478.72 | 478.95 | 478.72 | 478.95 | 15991.0 |
| 2022-01-04 07:35:00 | SPY | ETF | 479.0 | 479.05 | 478.87 | 478.87 | 21038.0 |
| 2022-01-04 07:40:00 | SPY | ETF | 478.83 | 479.0 | 478.81 | 478.95 | 16239.0 |
| 2022-01-04 07:45:00 | SPY | ETF | 478.87 | 479.02 | 478.87 | 478.9 | 15959.0 |
| 2022-01-04 07:50:00 | SPY | ETF | 478.89 | 478.89 | 478.78 | 478.84 | 12373.0 |
| 2022-01-04 07:55:00 | SPY | ETF | 478.84 | 479.08 | 478.84 | 479.06 | 17507.0 |
| 2022-01-04 08:00:00 | SPY | ETF | 479.3601 | 479.7704 | 478.068 | 478.97 | 34438.0 |
| 2022-01-04 08:05:00 | SPY | ETF | 478.98 | 479.11 | 478.97 | 479.081 | 11481.0 |
> showing 50 of 96,496 rows — these rows as CSV