PREVIEW / stock_5min / 2022-11-03
file: by_date/stock_5min/2022/2022-11-03.parquet size: 6.8 MB rows: 418,862 symbols: 2,107
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-11-03 04:00:00 | AAPL | Stock | 144.92 | 144.92 | 144.1 | 144.25 | 3898.0 |
| 2022-11-03 04:05:00 | AAPL | Stock | 144.25 | 144.58 | 144.24 | 144.58 | 2713.0 |
| 2022-11-03 04:10:00 | AAPL | Stock | 144.66 | 144.66 | 144.49 | 144.49 | 1542.0 |
| 2022-11-03 04:15:00 | AAPL | Stock | 144.55 | 144.6 | 144.53 | 144.53 | 1802.0 |
| 2022-11-03 04:20:00 | AAPL | Stock | 144.43 | 144.5 | 144.42 | 144.5 | 946.0 |
| 2022-11-03 04:25:00 | AAPL | Stock | 144.42 | 144.42 | 144.23 | 144.23 | 2879.0 |
| 2022-11-03 04:30:00 | AAPL | Stock | 144.21 | 144.36 | 144.21 | 144.22 | 7943.0 |
| 2022-11-03 04:35:00 | AAPL | Stock | 144.16 | 144.16 | 144.0 | 144.0 | 3777.0 |
| 2022-11-03 04:40:00 | AAPL | Stock | 144.02 | 144.15 | 144.02 | 144.04 | 2050.0 |
| 2022-11-03 04:45:00 | AAPL | Stock | 144.03 | 144.09 | 143.94 | 143.94 | 4817.0 |
| 2022-11-03 04:50:00 | AAPL | Stock | 143.95 | 144.0 | 143.82 | 143.82 | 5331.0 |
| 2022-11-03 04:55:00 | AAPL | Stock | 143.88 | 144.0 | 143.87 | 144.0 | 2111.0 |
| 2022-11-03 05:00:00 | AAPL | Stock | 144.05 | 144.15 | 144.05 | 144.14 | 15523.0 |
| 2022-11-03 05:05:00 | AAPL | Stock | 144.05 | 144.11 | 144.04 | 144.04 | 468.0 |
| 2022-11-03 05:10:00 | AAPL | Stock | 143.9 | 143.9 | 143.9 | 143.9 | 300.0 |
| 2022-11-03 05:15:00 | AAPL | Stock | 143.86 | 143.86 | 143.7 | 143.7 | 5696.0 |
| 2022-11-03 05:20:00 | AAPL | Stock | 143.85 | 143.85 | 143.82 | 143.82 | 740.0 |
| 2022-11-03 05:25:00 | AAPL | Stock | 143.9 | 144.05 | 143.9 | 144.05 | 912.0 |
| 2022-11-03 05:30:00 | AAPL | Stock | 143.95 | 144.05 | 143.94 | 144.0 | 1799.0 |
| 2022-11-03 05:35:00 | AAPL | Stock | 144.01 | 144.01 | 143.95 | 143.97 | 300.0 |
| 2022-11-03 05:40:00 | AAPL | Stock | 143.93 | 143.97 | 143.92 | 143.96 | 400.0 |
| 2022-11-03 05:45:00 | AAPL | Stock | 143.9 | 143.98 | 143.88 | 143.98 | 1220.0 |
| 2022-11-03 05:50:00 | AAPL | Stock | 143.89 | 143.89 | 143.8 | 143.8 | 501.0 |
| 2022-11-03 05:55:00 | AAPL | Stock | 143.9 | 143.99 | 143.9 | 143.99 | 524.0 |
| 2022-11-03 06:00:00 | AAPL | Stock | 143.99 | 144.13 | 143.99 | 144.0 | 2074.0 |
| 2022-11-03 06:05:00 | AAPL | Stock | 143.92 | 144.09 | 143.92 | 144.09 | 10934.0 |
| 2022-11-03 06:10:00 | AAPL | Stock | 144.2 | 144.2 | 144.11 | 144.11 | 1404.0 |
| 2022-11-03 06:15:00 | AAPL | Stock | 144.01 | 144.16 | 143.76 | 143.85 | 8530.0 |
| 2022-11-03 06:20:00 | AAPL | Stock | 143.85 | 144.07 | 143.8 | 143.94 | 2794.0 |
| 2022-11-03 06:25:00 | AAPL | Stock | 143.97 | 143.97 | 143.36 | 143.36 | 3719.0 |
| 2022-11-03 06:30:00 | AAPL | Stock | 143.47 | 143.55 | 143.47 | 143.47 | 1997.0 |
| 2022-11-03 06:35:00 | AAPL | Stock | 143.49 | 143.68 | 143.49 | 143.68 | 1334.0 |
| 2022-11-03 06:40:00 | AAPL | Stock | 143.52 | 143.52 | 143.32 | 143.32 | 1302.0 |
| 2022-11-03 06:45:00 | AAPL | Stock | 143.32 | 143.35 | 143.27 | 143.3 | 2194.0 |
| 2022-11-03 06:50:00 | AAPL | Stock | 143.3 | 143.65 | 143.27 | 143.58 | 3148.0 |
| 2022-11-03 06:55:00 | AAPL | Stock | 143.53 | 143.53 | 143.53 | 143.53 | 110.0 |
| 2022-11-03 07:00:00 | AAPL | Stock | 143.64 | 143.74 | 143.29 | 143.33 | 16694.0 |
| 2022-11-03 07:05:00 | AAPL | Stock | 143.37 | 143.39 | 143.22 | 143.22 | 4939.0 |
| 2022-11-03 07:10:00 | AAPL | Stock | 143.2 | 143.24 | 143.09 | 143.15 | 12076.0 |
| 2022-11-03 07:15:00 | AAPL | Stock | 143.18 | 143.23 | 143.18 | 143.19 | 6069.0 |
| 2022-11-03 07:20:00 | AAPL | Stock | 143.19 | 143.23 | 143.19 | 143.22 | 7243.0 |
| 2022-11-03 07:25:00 | AAPL | Stock | 143.2 | 143.26 | 143.19 | 143.22 | 6256.0 |
| 2022-11-03 07:30:00 | AAPL | Stock | 143.24 | 143.25 | 143.14 | 143.25 | 12437.0 |
| 2022-11-03 07:35:00 | AAPL | Stock | 143.17 | 143.17 | 142.88 | 142.89 | 13707.0 |
| 2022-11-03 07:40:00 | AAPL | Stock | 142.9 | 142.94 | 142.65 | 142.67 | 10886.0 |
| 2022-11-03 07:45:00 | AAPL | Stock | 142.7 | 142.74 | 142.59 | 142.63 | 18346.0 |
| 2022-11-03 07:50:00 | AAPL | Stock | 142.61 | 142.8 | 142.61 | 142.8 | 9210.0 |
| 2022-11-03 07:55:00 | AAPL | Stock | 142.76 | 142.81 | 142.75 | 142.75 | 5897.0 |
| 2022-11-03 08:00:00 | AAPL | Stock | 143.78 | 143.8015 | 142.57 | 142.7 | 85722.0 |
| 2022-11-03 08:05:00 | AAPL | Stock | 142.7 | 143.03 | 142.6699 | 142.88 | 24747.0 |
> showing 50 of 418,862 rows — these rows as CSV