PREVIEW / etf_5min / 2021-10-13
file: by_date/etf_5min/2021/2021-10-13.parquet size: 1.7 MB rows: 82,231
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-13 04:00:00 | SPY | ETF | 433.52 | 433.75 | 433.52 | 433.65 | 7896.0 |
| 2021-10-13 04:05:00 | SPY | ETF | 433.62 | 433.62 | 433.62 | 433.62 | 200.0 |
| 2021-10-13 04:10:00 | SPY | ETF | 433.68 | 433.68 | 433.68 | 433.68 | 200.0 |
| 2021-10-13 04:15:00 | SPY | ETF | 433.6 | 434.16 | 433.55 | 434.14 | 3048.0 |
| 2021-10-13 04:20:00 | SPY | ETF | 434.11 | 434.25 | 434.01 | 434.25 | 2600.0 |
| 2021-10-13 04:25:00 | SPY | ETF | 434.36 | 434.36 | 434.26 | 434.26 | 1100.0 |
| 2021-10-13 04:30:00 | SPY | ETF | 434.25 | 434.26 | 434.2 | 434.21 | 1641.0 |
| 2021-10-13 04:40:00 | SPY | ETF | 434.25 | 434.58 | 434.25 | 434.58 | 3300.0 |
| 2021-10-13 04:45:00 | SPY | ETF | 434.51 | 434.79 | 434.51 | 434.77 | 3449.0 |
| 2021-10-13 04:50:00 | SPY | ETF | 434.88 | 434.99 | 434.75 | 434.75 | 7353.0 |
| 2021-10-13 04:55:00 | SPY | ETF | 434.75 | 434.77 | 434.62 | 434.62 | 1270.0 |
| 2021-10-13 05:00:00 | SPY | ETF | 434.55 | 434.55 | 434.45 | 434.45 | 2100.0 |
| 2021-10-13 05:05:00 | SPY | ETF | 434.4 | 434.48 | 434.36 | 434.36 | 700.0 |
| 2021-10-13 05:10:00 | SPY | ETF | 434.38 | 434.57 | 434.38 | 434.55 | 1601.0 |
| 2021-10-13 05:15:00 | SPY | ETF | 434.59 | 434.59 | 434.57 | 434.59 | 945.0 |
| 2021-10-13 05:20:00 | SPY | ETF | 434.6 | 434.6 | 434.6 | 434.6 | 200.0 |
| 2021-10-13 05:25:00 | SPY | ETF | 434.47 | 434.47 | 434.45 | 434.45 | 12999.0 |
| 2021-10-13 05:30:00 | SPY | ETF | 434.63 | 434.64 | 434.63 | 434.64 | 2550.0 |
| 2021-10-13 05:35:00 | SPY | ETF | 434.67 | 434.67 | 434.67 | 434.67 | 100.0 |
| 2021-10-13 05:40:00 | SPY | ETF | 434.7 | 434.7 | 434.6 | 434.6 | 400.0 |
| 2021-10-13 05:45:00 | SPY | ETF | 434.62 | 434.72 | 434.62 | 434.7 | 12900.0 |
| 2021-10-13 05:50:00 | SPY | ETF | 434.6 | 434.72 | 434.6 | 434.68 | 3320.0 |
| 2021-10-13 05:55:00 | SPY | ETF | 434.71 | 434.71 | 434.55 | 434.55 | 1200.0 |
| 2021-10-13 06:00:00 | SPY | ETF | 434.71 | 434.73 | 434.53 | 434.53 | 1500.0 |
| 2021-10-13 06:05:00 | SPY | ETF | 434.54 | 434.59 | 434.53 | 434.59 | 700.0 |
| 2021-10-13 06:10:00 | SPY | ETF | 434.59 | 434.59 | 434.56 | 434.58 | 300.0 |
| 2021-10-13 06:15:00 | SPY | ETF | 434.8 | 434.96 | 434.77 | 434.96 | 3600.0 |
| 2021-10-13 06:20:00 | SPY | ETF | 434.83 | 434.84 | 434.5 | 434.53 | 2099.0 |
| 2021-10-13 06:25:00 | SPY | ETF | 434.64 | 434.64 | 434.55 | 434.55 | 730.0 |
| 2021-10-13 06:30:00 | SPY | ETF | 434.52 | 434.65 | 434.5 | 434.5 | 10492.0 |
| 2021-10-13 06:35:00 | SPY | ETF | 434.49 | 434.49 | 434.23 | 434.29 | 3582.0 |
| 2021-10-13 06:40:00 | SPY | ETF | 434.31 | 434.31 | 434.3 | 434.3 | 1125.0 |
| 2021-10-13 06:45:00 | SPY | ETF | 434.34 | 434.39 | 434.29 | 434.29 | 3384.0 |
| 2021-10-13 06:50:00 | SPY | ETF | 434.33 | 434.45 | 434.33 | 434.4 | 10983.0 |
| 2021-10-13 06:55:00 | SPY | ETF | 434.43 | 434.43 | 434.2 | 434.2 | 1095.0 |
| 2021-10-13 07:00:00 | SPY | ETF | 434.28 | 434.3 | 434.18 | 434.3 | 9563.0 |
| 2021-10-13 07:05:00 | SPY | ETF | 434.25 | 434.25 | 434.01 | 434.01 | 22705.0 |
| 2021-10-13 07:10:00 | SPY | ETF | 434.02 | 434.12 | 433.93 | 434.1 | 8056.0 |
| 2021-10-13 07:15:00 | SPY | ETF | 434.08 | 434.42 | 434.08 | 434.33 | 17294.0 |
| 2021-10-13 07:20:00 | SPY | ETF | 434.33 | 434.38 | 434.29 | 434.32 | 56941.0 |
| 2021-10-13 07:25:00 | SPY | ETF | 434.31 | 434.52 | 434.31 | 434.52 | 81301.0 |
| 2021-10-13 07:30:00 | SPY | ETF | 434.56 | 434.61 | 434.5 | 434.53 | 28129.0 |
| 2021-10-13 07:35:00 | SPY | ETF | 434.58 | 434.65 | 434.36 | 434.44 | 46477.0 |
| 2021-10-13 07:40:00 | SPY | ETF | 434.41 | 434.44 | 434.39 | 434.43 | 8431.0 |
| 2021-10-13 07:45:00 | SPY | ETF | 434.43 | 434.45 | 434.43 | 434.43 | 4116.0 |
| 2021-10-13 07:50:00 | SPY | ETF | 434.44 | 434.65 | 434.4 | 434.65 | 6418.0 |
| 2021-10-13 07:55:00 | SPY | ETF | 434.65 | 434.74 | 434.49 | 434.51 | 35776.0 |
| 2021-10-13 08:00:00 | SPY | ETF | 434.53 | 434.83 | 433.92 | 434.78 | 38787.0 |
| 2021-10-13 08:05:00 | SPY | ETF | 434.78 | 434.78 | 434.56 | 434.57 | 25967.0 |
| 2021-10-13 08:10:00 | SPY | ETF | 434.56 | 434.72 | 433.2 | 434.7 | 80416.0 |
> showing 50 of 82,231 rows — these rows as CSV