PREVIEW / etf_5min / 2022-09-01
file: by_date/etf_5min/2022/2022-09-01.parquet size: 2.0 MB rows: 97,276
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-09-01 04:00:00 | SPY | ETF | 392.79 | 392.82 | 392.0 | 392.77 | 2834.0 |
| 2022-09-01 04:05:00 | SPY | ETF | 392.84 | 393.0 | 392.64 | 392.64 | 1940.0 |
| 2022-09-01 04:10:00 | SPY | ETF | 392.51 | 392.92 | 392.39 | 392.92 | 2394.0 |
| 2022-09-01 04:15:00 | SPY | ETF | 392.81 | 392.81 | 392.63 | 392.63 | 893.0 |
| 2022-09-01 04:20:00 | SPY | ETF | 392.61 | 392.65 | 392.4 | 392.4 | 4136.0 |
| 2022-09-01 04:25:00 | SPY | ETF | 392.4 | 392.45 | 392.24 | 392.24 | 4382.0 |
| 2022-09-01 04:30:00 | SPY | ETF | 392.22 | 392.3 | 392.0 | 392.01 | 6400.0 |
| 2022-09-01 04:35:00 | SPY | ETF | 392.04 | 392.22 | 392.0 | 392.22 | 4070.0 |
| 2022-09-01 04:40:00 | SPY | ETF | 392.18 | 392.35 | 392.18 | 392.2 | 1950.0 |
| 2022-09-01 04:45:00 | SPY | ETF | 392.0 | 392.0 | 391.98 | 391.99 | 462.0 |
| 2022-09-01 04:50:00 | SPY | ETF | 392.02 | 392.06 | 391.84 | 391.84 | 2795.0 |
| 2022-09-01 04:55:00 | SPY | ETF | 392.1 | 392.11 | 392.09 | 392.11 | 500.0 |
| 2022-09-01 05:00:00 | SPY | ETF | 392.25 | 392.49 | 392.25 | 392.49 | 2555.0 |
| 2022-09-01 05:05:00 | SPY | ETF | 392.36 | 392.56 | 392.36 | 392.38 | 1539.0 |
| 2022-09-01 05:10:00 | SPY | ETF | 392.18 | 392.21 | 392.18 | 392.21 | 1700.0 |
| 2022-09-01 05:15:00 | SPY | ETF | 392.09 | 392.1 | 392.01 | 392.01 | 680.0 |
| 2022-09-01 05:20:00 | SPY | ETF | 392.01 | 392.01 | 391.82 | 391.82 | 2500.0 |
| 2022-09-01 05:25:00 | SPY | ETF | 392.03 | 392.07 | 391.94 | 392.06 | 3000.0 |
| 2022-09-01 05:30:00 | SPY | ETF | 392.29 | 392.37 | 392.11 | 392.11 | 1948.0 |
| 2022-09-01 05:35:00 | SPY | ETF | 391.93 | 392.39 | 391.93 | 392.39 | 2526.0 |
| 2022-09-01 05:40:00 | SPY | ETF | 392.39 | 392.64 | 392.39 | 392.64 | 5753.0 |
| 2022-09-01 05:45:00 | SPY | ETF | 392.68 | 392.83 | 392.68 | 392.76 | 5525.0 |
| 2022-09-01 05:50:00 | SPY | ETF | 392.8 | 392.96 | 392.8 | 392.89 | 2453.0 |
| 2022-09-01 05:55:00 | SPY | ETF | 392.94 | 392.94 | 392.61 | 392.61 | 3304.0 |
| 2022-09-01 06:00:00 | SPY | ETF | 392.61 | 392.71 | 392.61 | 392.62 | 899.0 |
| 2022-09-01 06:05:00 | SPY | ETF | 392.62 | 392.67 | 392.62 | 392.67 | 700.0 |
| 2022-09-01 06:10:00 | SPY | ETF | 392.69 | 392.69 | 392.66 | 392.67 | 300.0 |
| 2022-09-01 06:15:00 | SPY | ETF | 392.42 | 392.42 | 392.42 | 392.42 | 100.0 |
| 2022-09-01 06:20:00 | SPY | ETF | 392.51 | 392.58 | 392.39 | 392.42 | 4654.0 |
| 2022-09-01 06:25:00 | SPY | ETF | 392.41 | 392.41 | 392.41 | 392.41 | 296.0 |
| 2022-09-01 06:30:00 | SPY | ETF | 392.53 | 392.68 | 392.37 | 392.4 | 3970.0 |
| 2022-09-01 06:35:00 | SPY | ETF | 392.4 | 392.4 | 392.39 | 392.39 | 3400.0 |
| 2022-09-01 06:40:00 | SPY | ETF | 392.3 | 392.36 | 392.28 | 392.34 | 1900.0 |
| 2022-09-01 06:45:00 | SPY | ETF | 392.37 | 392.55 | 392.34 | 392.34 | 5750.0 |
| 2022-09-01 06:50:00 | SPY | ETF | 392.45 | 392.45 | 392.28 | 392.4 | 600.0 |
| 2022-09-01 06:55:00 | SPY | ETF | 392.65 | 392.82 | 392.64 | 392.7 | 4850.0 |
| 2022-09-01 07:00:00 | SPY | ETF | 392.58 | 392.84 | 392.58 | 392.8 | 22854.0 |
| 2022-09-01 07:05:00 | SPY | ETF | 392.81 | 393.01 | 392.7 | 392.89 | 49669.0 |
| 2022-09-01 07:10:00 | SPY | ETF | 392.9 | 393.26 | 392.78 | 393.17 | 50417.0 |
| 2022-09-01 07:15:00 | SPY | ETF | 393.18 | 393.47 | 393.07 | 393.42 | 21070.0 |
| 2022-09-01 07:20:00 | SPY | ETF | 393.47 | 393.54 | 393.32 | 393.49 | 24386.0 |
| 2022-09-01 07:25:00 | SPY | ETF | 393.58 | 393.64 | 393.37 | 393.46 | 22933.0 |
| 2022-09-01 07:30:00 | SPY | ETF | 393.36 | 393.95 | 393.29 | 393.9 | 27506.0 |
| 2022-09-01 07:35:00 | SPY | ETF | 393.85 | 393.99 | 393.805 | 393.82 | 38159.0 |
| 2022-09-01 07:40:00 | SPY | ETF | 393.84 | 394.29 | 393.81 | 394.28 | 33934.0 |
| 2022-09-01 07:45:00 | SPY | ETF | 394.34 | 394.5 | 394.0 | 394.08 | 108393.0 |
| 2022-09-01 07:50:00 | SPY | ETF | 394.04 | 394.04 | 393.8 | 393.93 | 17218.0 |
| 2022-09-01 07:55:00 | SPY | ETF | 393.97 | 394.25 | 393.85 | 393.85 | 30353.0 |
| 2022-09-01 08:00:00 | SPY | ETF | 393.9 | 394.48 | 391.81 | 393.84 | 102607.0 |
| 2022-09-01 08:05:00 | SPY | ETF | 393.84 | 394.04 | 393.84 | 393.86 | 7895.0 |
> showing 50 of 97,276 rows — these rows as CSV