PREVIEW / etf_5min / 2022-09-06
file: by_date/etf_5min/2022/2022-09-06.parquet size: 1.9 MB rows: 94,023
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-06 04:00:00 | SPY | ETF | 394.83 | 394.97 | 394.04 | 394.71 | 4562.0 |
| 2022-09-06 04:05:00 | SPY | ETF | 394.52 | 394.6 | 394.27 | 394.34 | 3357.0 |
| 2022-09-06 04:10:00 | SPY | ETF | 394.25 | 394.25 | 393.93 | 394.14 | 6968.0 |
| 2022-09-06 04:15:00 | SPY | ETF | 394.0 | 394.1 | 393.9 | 394.1 | 3162.0 |
| 2022-09-06 04:20:00 | SPY | ETF | 394.2 | 394.26 | 394.0 | 394.0 | 7211.0 |
| 2022-09-06 04:30:00 | SPY | ETF | 394.18 | 394.18 | 394.18 | 394.18 | 100.0 |
| 2022-09-06 04:35:00 | SPY | ETF | 394.05 | 394.22 | 394.03 | 394.22 | 11190.0 |
| 2022-09-06 04:40:00 | SPY | ETF | 394.25 | 394.6 | 394.25 | 394.44 | 48325.0 |
| 2022-09-06 04:45:00 | SPY | ETF | 394.44 | 394.63 | 394.4 | 394.4 | 11850.0 |
| 2022-09-06 04:50:00 | SPY | ETF | 394.51 | 394.7 | 394.34 | 394.68 | 4350.0 |
| 2022-09-06 04:55:00 | SPY | ETF | 394.61 | 394.8 | 394.61 | 394.8 | 1199.0 |
| 2022-09-06 05:00:00 | SPY | ETF | 394.75 | 394.76 | 394.1 | 394.11 | 5408.0 |
| 2022-09-06 05:05:00 | SPY | ETF | 394.01 | 394.01 | 393.9 | 393.9 | 1900.0 |
| 2022-09-06 05:10:00 | SPY | ETF | 393.84 | 393.85 | 393.76 | 393.8 | 1093.0 |
| 2022-09-06 05:15:00 | SPY | ETF | 394.0 | 394.07 | 394.0 | 394.0 | 1300.0 |
| 2022-09-06 05:20:00 | SPY | ETF | 393.98 | 394.33 | 393.95 | 394.33 | 1411.0 |
| 2022-09-06 05:25:00 | SPY | ETF | 394.3 | 394.3 | 394.3 | 394.3 | 500.0 |
| 2022-09-06 05:30:00 | SPY | ETF | 394.46 | 394.5 | 394.46 | 394.5 | 200.0 |
| 2022-09-06 05:35:00 | SPY | ETF | 394.52 | 394.58 | 394.52 | 394.58 | 600.0 |
| 2022-09-06 05:40:00 | SPY | ETF | 394.67 | 394.67 | 394.44 | 394.44 | 400.0 |
| 2022-09-06 05:45:00 | SPY | ETF | 394.58 | 394.58 | 394.52 | 394.53 | 1000.0 |
| 2022-09-06 05:50:00 | SPY | ETF | 394.37 | 394.51 | 394.3 | 394.49 | 7465.0 |
| 2022-09-06 05:55:00 | SPY | ETF | 394.75 | 394.75 | 394.59 | 394.59 | 30000.0 |
| 2022-09-06 06:00:00 | SPY | ETF | 394.66 | 394.66 | 394.61 | 394.61 | 9963.0 |
| 2022-09-06 06:05:00 | SPY | ETF | 394.65 | 394.69 | 394.65 | 394.65 | 1100.0 |
| 2022-09-06 06:10:00 | SPY | ETF | 394.65 | 395.11 | 394.65 | 395.09 | 7950.0 |
| 2022-09-06 06:15:00 | SPY | ETF | 395.09 | 395.4 | 395.09 | 395.25 | 5554.0 |
| 2022-09-06 06:20:00 | SPY | ETF | 395.26 | 395.8 | 395.26 | 395.68 | 10076.0 |
| 2022-09-06 06:25:00 | SPY | ETF | 395.77 | 395.98 | 395.5 | 395.58 | 20650.0 |
| 2022-09-06 06:30:00 | SPY | ETF | 395.3 | 395.3 | 395.23 | 395.23 | 602.0 |
| 2022-09-06 06:35:00 | SPY | ETF | 395.33 | 395.33 | 395.17 | 395.17 | 1170.0 |
| 2022-09-06 06:40:00 | SPY | ETF | 395.22 | 395.29 | 395.06 | 395.29 | 7700.0 |
| 2022-09-06 06:45:00 | SPY | ETF | 395.16 | 395.26 | 395.1 | 395.1 | 11905.0 |
| 2022-09-06 06:50:00 | SPY | ETF | 395.03 | 395.03 | 394.86 | 394.86 | 4346.0 |
| 2022-09-06 06:55:00 | SPY | ETF | 394.87 | 395.03 | 394.85 | 394.92 | 13247.0 |
| 2022-09-06 07:00:00 | SPY | ETF | 394.92 | 395.0 | 394.86 | 394.97 | 24646.0 |
| 2022-09-06 07:05:00 | SPY | ETF | 394.9 | 395.0 | 394.7 | 395.0 | 95087.0 |
| 2022-09-06 07:10:00 | SPY | ETF | 395.05 | 395.08 | 394.93 | 394.94 | 28053.0 |
| 2022-09-06 07:15:00 | SPY | ETF | 394.93 | 394.95 | 394.83 | 394.91 | 11250.0 |
| 2022-09-06 07:20:00 | SPY | ETF | 394.97 | 394.97 | 394.43 | 394.53 | 8665.0 |
| 2022-09-06 07:25:00 | SPY | ETF | 394.47 | 394.73 | 394.47 | 394.63 | 12605.0 |
| 2022-09-06 07:30:00 | SPY | ETF | 394.53 | 394.66 | 394.37 | 394.5 | 14449.0 |
| 2022-09-06 07:35:00 | SPY | ETF | 394.5 | 394.5 | 394.07 | 394.09 | 13242.0 |
| 2022-09-06 07:40:00 | SPY | ETF | 394.01 | 394.2 | 393.89 | 394.19 | 43522.0 |
| 2022-09-06 07:45:00 | SPY | ETF | 394.22 | 394.25 | 393.95 | 394.07 | 14477.0 |
| 2022-09-06 07:50:00 | SPY | ETF | 394.0 | 394.32 | 393.87 | 394.32 | 14296.0 |
| 2022-09-06 07:55:00 | SPY | ETF | 394.31 | 394.67 | 394.31 | 394.66 | 30801.0 |
| 2022-09-06 08:00:00 | SPY | ETF | 394.95 | 395.8404 | 393.73 | 394.87 | 46465.0 |
| 2022-09-06 08:05:00 | SPY | ETF | 394.89 | 395.3 | 394.8 | 395.28 | 55565.0 |
| 2022-09-06 08:10:00 | SPY | ETF | 395.29 | 395.29 | 395.11 | 395.18 | 21296.0 |
> showing 50 of 94,023 rows — these rows as CSV