PREVIEW / etf_5min / 2022-10-06
file: by_date/etf_5min/2022/2022-10-06.parquet size: 1.9 MB rows: 94,678
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-10-06 04:00:00 | SPY | ETF | 377.06 | 377.48 | 376.7 | 377.0 | 8509.0 |
| 2022-10-06 04:05:00 | SPY | ETF | 376.89 | 377.41 | 376.89 | 376.92 | 8459.0 |
| 2022-10-06 04:10:00 | SPY | ETF | 376.8 | 376.85 | 376.26 | 376.33 | 10129.0 |
| 2022-10-06 04:15:00 | SPY | ETF | 376.47 | 376.65 | 376.35 | 376.35 | 1600.0 |
| 2022-10-06 04:20:00 | SPY | ETF | 376.47 | 376.47 | 375.77 | 375.77 | 4503.0 |
| 2022-10-06 04:25:00 | SPY | ETF | 375.74 | 375.9 | 375.74 | 375.8 | 4750.0 |
| 2022-10-06 04:30:00 | SPY | ETF | 376.03 | 376.03 | 375.87 | 375.91 | 3400.0 |
| 2022-10-06 04:35:00 | SPY | ETF | 376.15 | 376.19 | 375.98 | 375.98 | 2150.0 |
| 2022-10-06 04:40:00 | SPY | ETF | 375.88 | 375.92 | 375.43 | 375.43 | 5340.0 |
| 2022-10-06 04:45:00 | SPY | ETF | 375.44 | 375.74 | 375.43 | 375.66 | 1173.0 |
| 2022-10-06 04:50:00 | SPY | ETF | 375.43 | 375.75 | 375.43 | 375.75 | 1800.0 |
| 2022-10-06 04:55:00 | SPY | ETF | 375.7 | 375.7 | 375.5 | 375.5 | 13125.0 |
| 2022-10-06 05:00:00 | SPY | ETF | 375.54 | 375.68 | 375.14 | 375.34 | 11279.0 |
| 2022-10-06 05:05:00 | SPY | ETF | 375.37 | 375.79 | 375.37 | 375.74 | 1476.0 |
| 2022-10-06 05:10:00 | SPY | ETF | 375.75 | 375.75 | 375.5 | 375.5 | 4375.0 |
| 2022-10-06 05:15:00 | SPY | ETF | 375.38 | 375.4 | 375.26 | 375.4 | 580.0 |
| 2022-10-06 05:20:00 | SPY | ETF | 375.48 | 375.48 | 375.48 | 375.48 | 100.0 |
| 2022-10-06 05:25:00 | SPY | ETF | 375.46 | 375.55 | 375.42 | 375.55 | 1696.0 |
| 2022-10-06 05:30:00 | SPY | ETF | 375.5 | 375.53 | 375.45 | 375.5 | 640.0 |
| 2022-10-06 05:35:00 | SPY | ETF | 375.43 | 375.43 | 375.2 | 375.27 | 3870.0 |
| 2022-10-06 05:40:00 | SPY | ETF | 375.2 | 375.3 | 375.2 | 375.22 | 1600.0 |
| 2022-10-06 05:45:00 | SPY | ETF | 375.16 | 375.16 | 374.9 | 375.04 | 13739.0 |
| 2022-10-06 05:50:00 | SPY | ETF | 375.01 | 375.03 | 374.78 | 374.87 | 4150.0 |
| 2022-10-06 05:55:00 | SPY | ETF | 374.83 | 374.83 | 374.5 | 374.5 | 19753.0 |
| 2022-10-06 06:00:00 | SPY | ETF | 374.55 | 374.55 | 374.32 | 374.39 | 15936.0 |
| 2022-10-06 06:05:00 | SPY | ETF | 374.5 | 374.5 | 374.0 | 374.0 | 8215.0 |
| 2022-10-06 06:10:00 | SPY | ETF | 374.04 | 374.49 | 374.04 | 374.44 | 4925.0 |
| 2022-10-06 06:15:00 | SPY | ETF | 374.39 | 374.55 | 374.29 | 374.31 | 3310.0 |
| 2022-10-06 06:20:00 | SPY | ETF | 374.45 | 374.54 | 374.37 | 374.43 | 2009.0 |
| 2022-10-06 06:25:00 | SPY | ETF | 374.46 | 374.46 | 374.05 | 374.32 | 6011.0 |
| 2022-10-06 06:30:00 | SPY | ETF | 374.26 | 374.44 | 374.25 | 374.44 | 1950.0 |
| 2022-10-06 06:35:00 | SPY | ETF | 374.68 | 374.68 | 374.4 | 374.4 | 2225.0 |
| 2022-10-06 06:40:00 | SPY | ETF | 374.46 | 374.53 | 374.25 | 374.43 | 13006.0 |
| 2022-10-06 06:45:00 | SPY | ETF | 374.33 | 374.4 | 374.23 | 374.4 | 8175.0 |
| 2022-10-06 06:50:00 | SPY | ETF | 374.31 | 374.33 | 374.31 | 374.33 | 200.0 |
| 2022-10-06 06:55:00 | SPY | ETF | 374.4 | 374.4 | 374.26 | 374.4 | 6875.0 |
| 2022-10-06 07:00:00 | SPY | ETF | 374.45 | 375.24 | 374.45 | 375.24 | 85555.0 |
| 2022-10-06 07:05:00 | SPY | ETF | 375.17 | 375.25 | 375.05 | 375.15 | 34820.0 |
| 2022-10-06 07:10:00 | SPY | ETF | 375.07 | 375.15 | 374.9 | 374.94 | 37847.0 |
| 2022-10-06 07:15:00 | SPY | ETF | 374.95 | 375.23 | 374.85 | 374.99 | 37635.0 |
| 2022-10-06 07:20:00 | SPY | ETF | 375.0 | 375.19 | 374.85 | 374.86 | 7949.0 |
| 2022-10-06 07:25:00 | SPY | ETF | 374.85 | 374.95 | 374.75 | 374.89 | 14141.0 |
| 2022-10-06 07:30:00 | SPY | ETF | 374.89 | 375.49 | 374.89 | 375.41 | 28563.0 |
| 2022-10-06 07:35:00 | SPY | ETF | 375.4 | 375.44 | 375.29 | 375.39 | 21305.0 |
| 2022-10-06 07:40:00 | SPY | ETF | 375.41 | 375.41 | 375.15 | 375.21 | 8500.0 |
| 2022-10-06 07:45:00 | SPY | ETF | 375.18 | 375.22 | 375.06 | 375.19 | 7177.0 |
| 2022-10-06 07:50:00 | SPY | ETF | 375.14 | 375.25 | 375.01 | 375.07 | 9635.0 |
| 2022-10-06 07:55:00 | SPY | ETF | 375.1 | 375.25 | 375.1 | 375.17 | 11340.0 |
| 2022-10-06 08:00:00 | SPY | ETF | 375.13 | 379.4 | 374.0596 | 375.13 | 117479.0 |
| 2022-10-06 08:05:00 | SPY | ETF | 375.11 | 375.11 | 374.6 | 374.77 | 40121.0 |
> showing 50 of 94,678 rows — these rows as CSV