PREVIEW / etf_5min / 2022-01-12
file: by_date/etf_5min/2022/2022-01-12.parquet size: 1.9 MB rows: 95,048
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-12 04:00:00 | SPY | ETF | 469.0 | 469.4 | 468.91 | 469.38 | 3530.0 |
| 2022-01-12 04:05:00 | SPY | ETF | 469.59 | 469.64 | 469.53 | 469.53 | 1138.0 |
| 2022-01-12 04:10:00 | SPY | ETF | 469.59 | 469.59 | 469.36 | 469.37 | 6257.0 |
| 2022-01-12 04:15:00 | SPY | ETF | 469.36 | 469.49 | 469.36 | 469.44 | 916.0 |
| 2022-01-12 04:20:00 | SPY | ETF | 469.53 | 469.9 | 469.53 | 469.9 | 2043.0 |
| 2022-01-12 04:25:00 | SPY | ETF | 469.94 | 470.11 | 469.94 | 470.01 | 5084.0 |
| 2022-01-12 04:30:00 | SPY | ETF | 470.18 | 470.24 | 469.93 | 469.93 | 947.0 |
| 2022-01-12 04:35:00 | SPY | ETF | 469.98 | 469.98 | 469.76 | 469.76 | 625.0 |
| 2022-01-12 04:40:00 | SPY | ETF | 469.84 | 469.97 | 469.84 | 469.97 | 839.0 |
| 2022-01-12 04:45:00 | SPY | ETF | 469.96 | 470.14 | 469.96 | 470.14 | 1160.0 |
| 2022-01-12 04:50:00 | SPY | ETF | 470.14 | 470.3 | 470.11 | 470.3 | 1357.0 |
| 2022-01-12 04:55:00 | SPY | ETF | 470.31 | 470.36 | 470.19 | 470.31 | 960.0 |
| 2022-01-12 05:00:00 | SPY | ETF | 470.4 | 470.4 | 470.34 | 470.34 | 620.0 |
| 2022-01-12 05:05:00 | SPY | ETF | 470.21 | 470.21 | 470.0 | 470.09 | 4468.0 |
| 2022-01-12 05:10:00 | SPY | ETF | 469.93 | 470.12 | 469.93 | 470.12 | 3610.0 |
| 2022-01-12 05:15:00 | SPY | ETF | 470.26 | 470.26 | 470.07 | 470.07 | 548.0 |
| 2022-01-12 05:20:00 | SPY | ETF | 470.06 | 470.32 | 470.02 | 470.31 | 11142.0 |
| 2022-01-12 05:25:00 | SPY | ETF | 470.36 | 470.36 | 470.19 | 470.19 | 889.0 |
| 2022-01-12 05:30:00 | SPY | ETF | 470.25 | 470.26 | 469.92 | 469.92 | 1898.0 |
| 2022-01-12 05:35:00 | SPY | ETF | 469.96 | 470.09 | 469.96 | 470.09 | 600.0 |
| 2022-01-12 05:40:00 | SPY | ETF | 470.09 | 470.15 | 470.09 | 470.14 | 542.0 |
| 2022-01-12 05:45:00 | SPY | ETF | 470.2 | 470.4 | 470.2 | 470.37 | 2150.0 |
| 2022-01-12 05:50:00 | SPY | ETF | 470.47 | 470.49 | 470.37 | 470.37 | 1376.0 |
| 2022-01-12 05:55:00 | SPY | ETF | 470.42 | 470.42 | 470.42 | 470.42 | 107.0 |
| 2022-01-12 06:00:00 | SPY | ETF | 470.55 | 470.65 | 470.55 | 470.56 | 1480.0 |
| 2022-01-12 06:05:00 | SPY | ETF | 470.5 | 470.5 | 470.48 | 470.48 | 200.0 |
| 2022-01-12 06:10:00 | SPY | ETF | 470.32 | 470.36 | 470.3 | 470.35 | 901.0 |
| 2022-01-12 06:15:00 | SPY | ETF | 470.44 | 470.47 | 470.31 | 470.31 | 5200.0 |
| 2022-01-12 06:20:00 | SPY | ETF | 470.3 | 470.37 | 470.3 | 470.37 | 1248.0 |
| 2022-01-12 06:25:00 | SPY | ETF | 470.49 | 470.49 | 470.29 | 470.29 | 2726.0 |
| 2022-01-12 06:30:00 | SPY | ETF | 470.33 | 470.39 | 470.33 | 470.39 | 300.0 |
| 2022-01-12 06:35:00 | SPY | ETF | 470.39 | 470.45 | 470.3 | 470.41 | 1345.0 |
| 2022-01-12 06:40:00 | SPY | ETF | 470.28 | 470.28 | 470.28 | 470.28 | 109.0 |
| 2022-01-12 06:45:00 | SPY | ETF | 470.3 | 470.56 | 470.3 | 470.56 | 1820.0 |
| 2022-01-12 06:50:00 | SPY | ETF | 470.5 | 470.5 | 470.39 | 470.39 | 4366.0 |
| 2022-01-12 06:55:00 | SPY | ETF | 470.38 | 470.38 | 470.17 | 470.17 | 4448.0 |
| 2022-01-12 07:00:00 | SPY | ETF | 470.12 | 470.28 | 470.0 | 470.28 | 8472.0 |
| 2022-01-12 07:05:00 | SPY | ETF | 470.25 | 470.26 | 469.9 | 469.9 | 12229.0 |
| 2022-01-12 07:10:00 | SPY | ETF | 469.96 | 470.0 | 469.87 | 469.9 | 6210.0 |
| 2022-01-12 07:15:00 | SPY | ETF | 469.97 | 470.05 | 469.87 | 469.87 | 4645.0 |
| 2022-01-12 07:20:00 | SPY | ETF | 469.92 | 470.14 | 469.89 | 470.14 | 4196.0 |
| 2022-01-12 07:25:00 | SPY | ETF | 470.14 | 470.2 | 470.11 | 470.12 | 4117.0 |
| 2022-01-12 07:30:00 | SPY | ETF | 470.16 | 470.41 | 470.16 | 470.39 | 2878.0 |
| 2022-01-12 07:35:00 | SPY | ETF | 470.39 | 470.57 | 470.36 | 470.39 | 5323.0 |
| 2022-01-12 07:40:00 | SPY | ETF | 470.4 | 470.43 | 470.29 | 470.29 | 6829.0 |
| 2022-01-12 07:45:00 | SPY | ETF | 470.28 | 470.29 | 470.11 | 470.12 | 3884.0 |
| 2022-01-12 07:50:00 | SPY | ETF | 470.19 | 470.19 | 469.99 | 470.17 | 8290.0 |
| 2022-01-12 07:55:00 | SPY | ETF | 470.2 | 470.27 | 470.18 | 470.18 | 6709.0 |
| 2022-01-12 08:00:00 | SPY | ETF | 470.06 | 470.7 | 469.13 | 470.43 | 58053.0 |
| 2022-01-12 08:05:00 | SPY | ETF | 470.44 | 470.54 | 470.13 | 470.19 | 27130.0 |
> showing 50 of 95,048 rows — these rows as CSV