PREVIEW / stock_5min / 2023-08-18
file: by_date/stock_5min/2023/2023-08-18.parquet size: 6.5 MB rows: 396,781 symbols: 1,444
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-18 04:00:00 | AAPL | Stock | 173.4 | 173.83 | 173.4 | 173.7 | 3432.0 |
| 2023-08-18 04:05:00 | AAPL | Stock | 173.7 | 173.8 | 173.7 | 173.72 | 1586.0 |
| 2023-08-18 04:10:00 | AAPL | Stock | 173.76 | 173.76 | 173.65 | 173.75 | 1386.0 |
| 2023-08-18 04:15:00 | AAPL | Stock | 173.75 | 173.78 | 173.55 | 173.55 | 2578.0 |
| 2023-08-18 04:20:00 | AAPL | Stock | 173.54 | 173.57 | 173.54 | 173.56 | 861.0 |
| 2023-08-18 04:25:00 | AAPL | Stock | 173.53 | 173.53 | 173.37 | 173.4 | 1712.0 |
| 2023-08-18 04:30:00 | AAPL | Stock | 173.4 | 173.56 | 173.4 | 173.5 | 2988.0 |
| 2023-08-18 04:35:00 | AAPL | Stock | 173.45 | 173.45 | 173.42 | 173.42 | 1079.0 |
| 2023-08-18 04:40:00 | AAPL | Stock | 173.49 | 173.49 | 173.43 | 173.43 | 619.0 |
| 2023-08-18 04:45:00 | AAPL | Stock | 173.43 | 173.43 | 173.43 | 173.43 | 229.0 |
| 2023-08-18 04:50:00 | AAPL | Stock | 173.42 | 173.42 | 173.42 | 173.42 | 100.0 |
| 2023-08-18 04:55:00 | AAPL | Stock | 173.43 | 173.55 | 173.43 | 173.5 | 620.0 |
| 2023-08-18 05:00:00 | AAPL | Stock | 173.55 | 173.62 | 173.55 | 173.62 | 468.0 |
| 2023-08-18 05:05:00 | AAPL | Stock | 173.57 | 173.57 | 173.35 | 173.36 | 2224.0 |
| 2023-08-18 05:10:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 142.0 |
| 2023-08-18 05:15:00 | AAPL | Stock | 173.3 | 173.3 | 173.27 | 173.27 | 234.0 |
| 2023-08-18 05:20:00 | AAPL | Stock | 173.26 | 173.26 | 173.19 | 173.22 | 737.0 |
| 2023-08-18 05:25:00 | AAPL | Stock | 173.24 | 173.24 | 173.19 | 173.19 | 1265.0 |
| 2023-08-18 05:30:00 | AAPL | Stock | 173.2 | 173.2 | 173.2 | 173.2 | 1049.0 |
| 2023-08-18 05:35:00 | AAPL | Stock | 173.2 | 173.29 | 173.03 | 173.29 | 4453.0 |
| 2023-08-18 05:40:00 | AAPL | Stock | 173.24 | 173.37 | 173.24 | 173.32 | 1381.0 |
| 2023-08-18 05:45:00 | AAPL | Stock | 173.11 | 173.11 | 173.1 | 173.1 | 679.0 |
| 2023-08-18 05:50:00 | AAPL | Stock | 173.16 | 173.24 | 173.12 | 173.15 | 802.0 |
| 2023-08-18 05:55:00 | AAPL | Stock | 173.16 | 173.16 | 173.16 | 173.16 | 142.0 |
| 2023-08-18 06:00:00 | AAPL | Stock | 173.16 | 173.16 | 173.14 | 173.14 | 500.0 |
| 2023-08-18 06:05:00 | AAPL | Stock | 173.16 | 173.27 | 173.14 | 173.19 | 6872.0 |
| 2023-08-18 06:10:00 | AAPL | Stock | 173.15 | 173.25 | 173.13 | 173.25 | 3177.0 |
| 2023-08-18 06:15:00 | AAPL | Stock | 173.28 | 173.28 | 173.14 | 173.14 | 1000.0 |
| 2023-08-18 06:20:00 | AAPL | Stock | 173.19 | 173.21 | 173.18 | 173.18 | 3405.0 |
| 2023-08-18 06:25:00 | AAPL | Stock | 173.14 | 173.14 | 173.11 | 173.11 | 300.0 |
| 2023-08-18 06:30:00 | AAPL | Stock | 173.1 | 173.12 | 173.03 | 173.03 | 1158.0 |
| 2023-08-18 06:35:00 | AAPL | Stock | 173.02 | 173.02 | 172.97 | 172.97 | 2727.0 |
| 2023-08-18 06:40:00 | AAPL | Stock | 172.95 | 172.97 | 172.93 | 172.97 | 1000.0 |
| 2023-08-18 06:45:00 | AAPL | Stock | 172.95 | 172.95 | 172.89 | 172.9 | 916.0 |
| 2023-08-18 06:50:00 | AAPL | Stock | 172.92 | 172.96 | 172.91 | 172.92 | 1500.0 |
| 2023-08-18 06:55:00 | AAPL | Stock | 172.95 | 173.03 | 172.95 | 173.03 | 1880.0 |
| 2023-08-18 07:00:00 | AAPL | Stock | 173.1 | 173.12 | 172.85 | 172.85 | 5983.0 |
| 2023-08-18 07:05:00 | AAPL | Stock | 172.82 | 172.84 | 172.69 | 172.7 | 9362.0 |
| 2023-08-18 07:10:00 | AAPL | Stock | 172.76 | 172.76 | 172.68 | 172.72 | 12327.0 |
| 2023-08-18 07:15:00 | AAPL | Stock | 172.68 | 172.71 | 172.53 | 172.53 | 6089.0 |
| 2023-08-18 07:20:00 | AAPL | Stock | 172.54 | 172.58 | 172.35 | 172.35 | 13188.0 |
| 2023-08-18 07:25:00 | AAPL | Stock | 172.34 | 172.34 | 172.11 | 172.11 | 14177.0 |
| 2023-08-18 07:30:00 | AAPL | Stock | 172.12 | 172.28 | 172.04 | 172.07 | 20865.0 |
| 2023-08-18 07:35:00 | AAPL | Stock | 172.09 | 172.1 | 171.96 | 171.99 | 28547.0 |
| 2023-08-18 07:40:00 | AAPL | Stock | 172.0 | 172.16 | 171.98 | 172.15 | 7571.0 |
| 2023-08-18 07:45:00 | AAPL | Stock | 172.21 | 172.22 | 172.13 | 172.17 | 11589.0 |
| 2023-08-18 07:50:00 | AAPL | Stock | 172.15 | 172.25 | 172.13 | 172.15 | 15151.0 |
| 2023-08-18 07:55:00 | AAPL | Stock | 172.17 | 172.4 | 172.17 | 172.36 | 20805.0 |
| 2023-08-18 08:00:00 | AAPL | Stock | 173.01 | 174.0 | 171.93 | 172.47 | 150875.0 |
| 2023-08-18 08:05:00 | AAPL | Stock | 172.47 | 172.49 | 172.3001 | 172.38 | 29976.0 |
> showing 50 of 396,781 rows — these rows as CSV