PREVIEW / stock_5min / 2022-03-07
file: by_date/stock_5min/2022/2022-03-07.parquet size: 7.8 MB rows: 482,226 symbols: 2,566
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-03-07 04:00:00 | AAPL | Stock | 161.78 | 161.78 | 160.13 | 160.32 | 17434.0 |
| 2022-03-07 04:05:00 | AAPL | Stock | 160.35 | 160.8 | 160.35 | 160.7 | 8454.0 |
| 2022-03-07 04:10:00 | AAPL | Stock | 160.71 | 160.77 | 160.55 | 160.72 | 2847.0 |
| 2022-03-07 04:15:00 | AAPL | Stock | 160.7 | 160.7 | 160.37 | 160.53 | 6160.0 |
| 2022-03-07 04:20:00 | AAPL | Stock | 160.51 | 160.75 | 160.51 | 160.7 | 11065.0 |
| 2022-03-07 04:25:00 | AAPL | Stock | 160.69 | 160.72 | 160.58 | 160.65 | 4561.0 |
| 2022-03-07 04:30:00 | AAPL | Stock | 160.64 | 160.64 | 160.25 | 160.31 | 3013.0 |
| 2022-03-07 04:35:00 | AAPL | Stock | 160.32 | 160.45 | 160.3 | 160.33 | 4824.0 |
| 2022-03-07 04:40:00 | AAPL | Stock | 160.27 | 160.27 | 160.0 | 160.11 | 15015.0 |
| 2022-03-07 04:45:00 | AAPL | Stock | 160.19 | 160.19 | 159.71 | 159.81 | 8980.0 |
| 2022-03-07 04:50:00 | AAPL | Stock | 159.75 | 160.0 | 159.75 | 160.0 | 800.0 |
| 2022-03-07 04:55:00 | AAPL | Stock | 160.05 | 160.11 | 160.05 | 160.09 | 1618.0 |
| 2022-03-07 05:00:00 | AAPL | Stock | 160.09 | 160.09 | 159.88 | 160.08 | 2210.0 |
| 2022-03-07 05:05:00 | AAPL | Stock | 160.08 | 160.13 | 159.91 | 160.12 | 13317.0 |
| 2022-03-07 05:10:00 | AAPL | Stock | 160.13 | 160.24 | 160.13 | 160.24 | 1774.0 |
| 2022-03-07 05:15:00 | AAPL | Stock | 160.45 | 160.45 | 160.2 | 160.25 | 2420.0 |
| 2022-03-07 05:20:00 | AAPL | Stock | 160.25 | 160.32 | 160.16 | 160.32 | 1147.0 |
| 2022-03-07 05:25:00 | AAPL | Stock | 160.35 | 160.35 | 160.35 | 160.35 | 778.0 |
| 2022-03-07 05:30:00 | AAPL | Stock | 160.29 | 160.29 | 160.0 | 160.15 | 1774.0 |
| 2022-03-07 05:35:00 | AAPL | Stock | 160.13 | 160.13 | 160.07 | 160.08 | 1477.0 |
| 2022-03-07 05:40:00 | AAPL | Stock | 160.05 | 160.1 | 160.05 | 160.05 | 3170.0 |
| 2022-03-07 05:45:00 | AAPL | Stock | 160.1 | 160.21 | 160.1 | 160.21 | 2196.0 |
| 2022-03-07 05:50:00 | AAPL | Stock | 160.27 | 160.28 | 160.27 | 160.28 | 230.0 |
| 2022-03-07 05:55:00 | AAPL | Stock | 160.28 | 160.35 | 160.0 | 160.0 | 766.0 |
| 2022-03-07 06:00:00 | AAPL | Stock | 160.0 | 160.0 | 159.95 | 159.95 | 633.0 |
| 2022-03-07 06:05:00 | AAPL | Stock | 159.75 | 159.9 | 159.6 | 159.78 | 4709.0 |
| 2022-03-07 06:10:00 | AAPL | Stock | 159.99 | 160.0 | 159.99 | 160.0 | 1200.0 |
| 2022-03-07 06:15:00 | AAPL | Stock | 159.69 | 159.98 | 159.69 | 159.98 | 743.0 |
| 2022-03-07 06:20:00 | AAPL | Stock | 160.03 | 160.15 | 160.03 | 160.15 | 706.0 |
| 2022-03-07 06:25:00 | AAPL | Stock | 160.24 | 160.4 | 160.24 | 160.25 | 3144.0 |
| 2022-03-07 06:30:00 | AAPL | Stock | 160.25 | 160.45 | 160.25 | 160.43 | 3049.0 |
| 2022-03-07 06:35:00 | AAPL | Stock | 160.4 | 160.4 | 160.39 | 160.39 | 1298.0 |
| 2022-03-07 06:40:00 | AAPL | Stock | 160.38 | 160.46 | 160.38 | 160.45 | 999.0 |
| 2022-03-07 06:45:00 | AAPL | Stock | 160.33 | 160.45 | 160.33 | 160.45 | 923.0 |
| 2022-03-07 06:50:00 | AAPL | Stock | 160.45 | 160.63 | 160.45 | 160.63 | 768.0 |
| 2022-03-07 06:55:00 | AAPL | Stock | 160.7 | 160.8 | 160.7 | 160.74 | 2871.0 |
| 2022-03-07 07:00:00 | AAPL | Stock | 160.85 | 161.8 | 160.67 | 161.75 | 42464.0 |
| 2022-03-07 07:05:00 | AAPL | Stock | 161.75 | 161.9 | 161.57 | 161.68 | 19149.0 |
| 2022-03-07 07:10:00 | AAPL | Stock | 161.74 | 162.0 | 161.71 | 161.85 | 11209.0 |
| 2022-03-07 07:15:00 | AAPL | Stock | 161.85 | 162.12 | 161.8 | 162.1 | 9583.0 |
| 2022-03-07 07:20:00 | AAPL | Stock | 162.1 | 162.24 | 162.09 | 162.16 | 12212.0 |
| 2022-03-07 07:25:00 | AAPL | Stock | 162.16 | 162.21 | 161.96 | 162.21 | 4200.0 |
| 2022-03-07 07:30:00 | AAPL | Stock | 162.15 | 162.3 | 162.07 | 162.15 | 12106.0 |
| 2022-03-07 07:35:00 | AAPL | Stock | 162.05 | 162.17 | 162.03 | 162.17 | 3506.0 |
| 2022-03-07 07:40:00 | AAPL | Stock | 162.18 | 162.24 | 161.92 | 162.04 | 7104.0 |
| 2022-03-07 07:45:00 | AAPL | Stock | 162.06 | 162.14 | 162.01 | 162.02 | 19544.0 |
| 2022-03-07 07:50:00 | AAPL | Stock | 162.08 | 162.12 | 162.0 | 162.12 | 3127.0 |
| 2022-03-07 07:55:00 | AAPL | Stock | 162.11 | 162.19 | 161.86 | 161.86 | 12216.0 |
| 2022-03-07 08:00:00 | AAPL | Stock | 162.01 | 162.763 | 161.05 | 161.95 | 188408.0 |
| 2022-03-07 08:05:00 | AAPL | Stock | 161.9 | 162.0 | 161.9 | 161.98 | 10369.0 |
> showing 50 of 482,226 rows — these rows as CSV