PREVIEW / etf_5min / 2022-05-10
file: by_date/etf_5min/2022/2022-05-10.parquet size: 2.2 MB rows: 105,928
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-05-10 04:00:00 | SPY | ETF | 400.73 | 401.33 | 400.73 | 401.05 | 5945.0 |
| 2022-05-10 04:05:00 | SPY | ETF | 401.07 | 401.73 | 400.95 | 401.73 | 14873.0 |
| 2022-05-10 04:10:00 | SPY | ETF | 401.75 | 401.88 | 401.4 | 401.4 | 24669.0 |
| 2022-05-10 04:15:00 | SPY | ETF | 401.5 | 401.98 | 401.5 | 401.97 | 1200.0 |
| 2022-05-10 04:20:00 | SPY | ETF | 402.0 | 402.39 | 402.0 | 402.38 | 5750.0 |
| 2022-05-10 04:25:00 | SPY | ETF | 402.25 | 402.51 | 402.2 | 402.51 | 2003.0 |
| 2022-05-10 04:30:00 | SPY | ETF | 402.52 | 402.7 | 402.52 | 402.65 | 1350.0 |
| 2022-05-10 04:35:00 | SPY | ETF | 402.68 | 402.68 | 402.6 | 402.6 | 1494.0 |
| 2022-05-10 04:40:00 | SPY | ETF | 402.5 | 402.5 | 402.35 | 402.4 | 1092.0 |
| 2022-05-10 04:45:00 | SPY | ETF | 402.48 | 402.7 | 402.47 | 402.6 | 1522.0 |
| 2022-05-10 04:50:00 | SPY | ETF | 402.62 | 402.62 | 402.4 | 402.4 | 1500.0 |
| 2022-05-10 04:55:00 | SPY | ETF | 402.31 | 402.58 | 402.31 | 402.58 | 1961.0 |
| 2022-05-10 05:00:00 | SPY | ETF | 402.6 | 402.7 | 402.43 | 402.47 | 3401.0 |
| 2022-05-10 05:05:00 | SPY | ETF | 402.51 | 402.75 | 402.51 | 402.75 | 5358.0 |
| 2022-05-10 05:10:00 | SPY | ETF | 402.9 | 402.99 | 402.8 | 402.99 | 16726.0 |
| 2022-05-10 05:15:00 | SPY | ETF | 402.9 | 402.93 | 402.6 | 402.6 | 4406.0 |
| 2022-05-10 05:20:00 | SPY | ETF | 402.6 | 402.6 | 402.5 | 402.6 | 3250.0 |
| 2022-05-10 05:25:00 | SPY | ETF | 402.53 | 402.55 | 402.41 | 402.46 | 4829.0 |
| 2022-05-10 05:30:00 | SPY | ETF | 402.5 | 402.68 | 402.5 | 402.62 | 3893.0 |
| 2022-05-10 05:35:00 | SPY | ETF | 402.59 | 402.86 | 402.5 | 402.86 | 5560.0 |
| 2022-05-10 05:40:00 | SPY | ETF | 402.76 | 402.89 | 402.58 | 402.58 | 1305.0 |
| 2022-05-10 05:45:00 | SPY | ETF | 402.52 | 402.52 | 402.31 | 402.39 | 1200.0 |
| 2022-05-10 05:50:00 | SPY | ETF | 402.29 | 402.43 | 401.8 | 401.81 | 27262.0 |
| 2022-05-10 05:55:00 | SPY | ETF | 401.83 | 401.83 | 401.35 | 401.48 | 15888.0 |
| 2022-05-10 06:00:00 | SPY | ETF | 401.69 | 401.69 | 401.33 | 401.4 | 1400.0 |
| 2022-05-10 06:05:00 | SPY | ETF | 401.7 | 401.9 | 401.7 | 401.8 | 2300.0 |
| 2022-05-10 06:10:00 | SPY | ETF | 401.64 | 401.7 | 401.48 | 401.53 | 1572.0 |
| 2022-05-10 06:15:00 | SPY | ETF | 401.58 | 401.69 | 401.3 | 401.31 | 16994.0 |
| 2022-05-10 06:20:00 | SPY | ETF | 401.79 | 402.13 | 401.79 | 401.95 | 13900.0 |
| 2022-05-10 06:25:00 | SPY | ETF | 402.0 | 402.01 | 401.79 | 401.98 | 11499.0 |
| 2022-05-10 06:30:00 | SPY | ETF | 401.91 | 402.38 | 401.91 | 402.35 | 2000.0 |
| 2022-05-10 06:35:00 | SPY | ETF | 402.32 | 402.39 | 402.26 | 402.27 | 8900.0 |
| 2022-05-10 06:40:00 | SPY | ETF | 402.27 | 402.4 | 402.2 | 402.28 | 26494.0 |
| 2022-05-10 06:45:00 | SPY | ETF | 402.26 | 402.31 | 401.66 | 401.72 | 15968.0 |
| 2022-05-10 06:50:00 | SPY | ETF | 401.74 | 401.85 | 401.36 | 401.39 | 8810.0 |
| 2022-05-10 06:55:00 | SPY | ETF | 401.55 | 401.55 | 401.27 | 401.28 | 22937.0 |
| 2022-05-10 07:00:00 | SPY | ETF | 401.21 | 401.46 | 400.87 | 400.87 | 24139.0 |
| 2022-05-10 07:05:00 | SPY | ETF | 400.9 | 401.18 | 400.71 | 401.18 | 13441.0 |
| 2022-05-10 07:10:00 | SPY | ETF | 401.14 | 401.18 | 400.96 | 401.02 | 7144.0 |
| 2022-05-10 07:15:00 | SPY | ETF | 401.02 | 401.02 | 400.48 | 400.48 | 37889.0 |
| 2022-05-10 07:20:00 | SPY | ETF | 400.43 | 400.55 | 400.17 | 400.5 | 27897.0 |
| 2022-05-10 07:25:00 | SPY | ETF | 400.3 | 400.7 | 400.25 | 400.7 | 21313.0 |
| 2022-05-10 07:30:00 | SPY | ETF | 400.6 | 401.14 | 400.5 | 401.14 | 66590.0 |
| 2022-05-10 07:35:00 | SPY | ETF | 401.1 | 401.18 | 401.05 | 401.16 | 45038.0 |
| 2022-05-10 07:40:00 | SPY | ETF | 401.12 | 401.15 | 400.58 | 400.58 | 18296.0 |
| 2022-05-10 07:45:00 | SPY | ETF | 400.61 | 401.23 | 400.59 | 401.19 | 25081.0 |
| 2022-05-10 07:50:00 | SPY | ETF | 401.23 | 401.25 | 400.56 | 400.56 | 104750.0 |
| 2022-05-10 07:55:00 | SPY | ETF | 400.55 | 401.25 | 400.53 | 401.2 | 39242.0 |
| 2022-05-10 08:00:00 | SPY | ETF | 401.23 | 402.77 | 400.17 | 401.48 | 96097.0 |
| 2022-05-10 08:05:00 | SPY | ETF | 396.9549 | 401.98 | 396.9549 | 401.73 | 483354.0 |
> showing 50 of 105,928 rows — these rows as CSV