PREVIEW / etf_5min / 2022-04-05
file: by_date/etf_5min/2022/2022-04-05.parquet size: 2.0 MB rows: 94,385
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-04-05 04:00:00 | SPY | ETF | 457.3 | 457.3 | 457.11 | 457.11 | 847.0 |
| 2022-04-05 04:05:00 | SPY | ETF | 457.09 | 457.23 | 457.07 | 457.22 | 1100.0 |
| 2022-04-05 04:10:00 | SPY | ETF | 457.2 | 457.4 | 457.2 | 457.36 | 2043.0 |
| 2022-04-05 04:15:00 | SPY | ETF | 457.365 | 457.44 | 457.19 | 457.19 | 1916.0 |
| 2022-04-05 04:20:00 | SPY | ETF | 457.27 | 457.27 | 457.2 | 457.2 | 544.0 |
| 2022-04-05 04:25:00 | SPY | ETF | 457.17 | 457.17 | 457.0 | 457.0 | 2100.0 |
| 2022-04-05 04:30:00 | SPY | ETF | 456.96 | 456.98 | 456.85 | 456.94 | 1596.0 |
| 2022-04-05 04:35:00 | SPY | ETF | 456.98 | 457.05 | 456.98 | 457.0 | 1049.0 |
| 2022-04-05 04:40:00 | SPY | ETF | 457.04 | 457.06 | 457.04 | 457.04 | 1300.0 |
| 2022-04-05 04:45:00 | SPY | ETF | 457.01 | 457.01 | 456.92 | 456.92 | 400.0 |
| 2022-04-05 04:50:00 | SPY | ETF | 456.83 | 456.83 | 456.83 | 456.83 | 100.0 |
| 2022-04-05 04:55:00 | SPY | ETF | 456.8 | 456.8 | 456.55 | 456.63 | 900.0 |
| 2022-04-05 05:00:00 | SPY | ETF | 456.61 | 456.61 | 456.55 | 456.55 | 350.0 |
| 2022-04-05 05:05:00 | SPY | ETF | 456.73 | 456.75 | 456.66 | 456.75 | 1681.0 |
| 2022-04-05 05:20:00 | SPY | ETF | 456.58 | 456.58 | 456.47 | 456.47 | 499.0 |
| 2022-04-05 05:25:00 | SPY | ETF | 456.56 | 456.56 | 456.38 | 456.38 | 500.0 |
| 2022-04-05 05:30:00 | SPY | ETF | 456.47 | 456.47 | 456.41 | 456.45 | 1600.0 |
| 2022-04-05 05:35:00 | SPY | ETF | 456.47 | 456.47 | 456.14 | 456.14 | 1777.0 |
| 2022-04-05 05:40:00 | SPY | ETF | 456.02 | 456.14 | 456.02 | 456.14 | 988.0 |
| 2022-04-05 05:45:00 | SPY | ETF | 456.05 | 456.05 | 455.83 | 455.83 | 8094.0 |
| 2022-04-05 05:50:00 | SPY | ETF | 455.81 | 455.98 | 455.79 | 455.98 | 800.0 |
| 2022-04-05 05:55:00 | SPY | ETF | 455.97 | 455.97 | 455.85 | 455.85 | 1003.0 |
| 2022-04-05 06:00:00 | SPY | ETF | 455.84 | 456.06 | 455.84 | 456.06 | 1421.0 |
| 2022-04-05 06:05:00 | SPY | ETF | 456.0 | 456.1 | 455.61 | 455.61 | 4000.0 |
| 2022-04-05 06:10:00 | SPY | ETF | 455.63 | 455.66 | 455.53 | 455.53 | 6800.0 |
| 2022-04-05 06:15:00 | SPY | ETF | 455.63 | 455.75 | 455.63 | 455.7 | 648.0 |
| 2022-04-05 06:20:00 | SPY | ETF | 455.75 | 455.75 | 455.41 | 455.41 | 1073.0 |
| 2022-04-05 06:25:00 | SPY | ETF | 455.51 | 455.53 | 455.42 | 455.53 | 1300.0 |
| 2022-04-05 06:30:00 | SPY | ETF | 455.64 | 455.73 | 455.36 | 455.36 | 3526.0 |
| 2022-04-05 06:35:00 | SPY | ETF | 455.36 | 455.44 | 455.32 | 455.44 | 2504.0 |
| 2022-04-05 06:40:00 | SPY | ETF | 455.48 | 455.57 | 455.48 | 455.57 | 300.0 |
| 2022-04-05 06:45:00 | SPY | ETF | 455.51 | 455.63 | 455.43 | 455.63 | 5150.0 |
| 2022-04-05 06:50:00 | SPY | ETF | 455.58 | 455.79 | 455.58 | 455.76 | 2016.0 |
| 2022-04-05 06:55:00 | SPY | ETF | 455.71 | 455.79 | 455.71 | 455.79 | 267.0 |
| 2022-04-05 07:00:00 | SPY | ETF | 455.74 | 455.829 | 455.68 | 455.81 | 10451.0 |
| 2022-04-05 07:05:00 | SPY | ETF | 455.74 | 455.74 | 455.57 | 455.58 | 3582.0 |
| 2022-04-05 07:10:00 | SPY | ETF | 455.57 | 455.579 | 455.44 | 455.44 | 3817.0 |
| 2022-04-05 07:15:00 | SPY | ETF | 455.61 | 455.64 | 455.52 | 455.64 | 8290.0 |
| 2022-04-05 07:20:00 | SPY | ETF | 455.64 | 455.76 | 455.64 | 455.65 | 4850.0 |
| 2022-04-05 07:25:00 | SPY | ETF | 455.66 | 455.75 | 455.66 | 455.73 | 800.0 |
| 2022-04-05 07:30:00 | SPY | ETF | 455.83 | 455.86 | 455.75 | 455.81 | 9905.0 |
| 2022-04-05 07:35:00 | SPY | ETF | 455.8 | 455.91 | 455.8 | 455.86 | 6634.0 |
| 2022-04-05 07:40:00 | SPY | ETF | 456.0 | 456.12 | 455.94 | 456.11 | 6442.0 |
| 2022-04-05 07:45:00 | SPY | ETF | 456.1 | 456.13 | 456.06 | 456.11 | 30420.0 |
| 2022-04-05 07:50:00 | SPY | ETF | 456.11 | 456.11 | 455.95 | 455.99 | 15179.0 |
| 2022-04-05 07:55:00 | SPY | ETF | 456.02 | 456.02 | 456.0 | 456.0 | 500.0 |
| 2022-04-05 08:00:00 | SPY | ETF | 455.8 | 457.0 | 455.47 | 456.21 | 22126.0 |
| 2022-04-05 08:05:00 | SPY | ETF | 456.22 | 456.22 | 455.9501 | 456.0 | 5963.0 |
| 2022-04-05 08:10:00 | SPY | ETF | 456.0 | 456.07 | 455.94 | 455.94 | 6455.0 |
| 2022-04-05 08:15:00 | SPY | ETF | 455.92 | 455.92 | 455.74 | 455.9 | 8623.0 |
> showing 50 of 94,385 rows — these rows as CSV