PREVIEW / stock_5min / 2024-03-22
file: by_date/stock_5min/2024/2024-03-22.parquet size: 6.6 MB rows: 395,966 symbols: 1,052
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-22 04:00:00 | AAPL | Stock | 171.68 | 171.7 | 171.46 | 171.61 | 7062.0 |
| 2024-03-22 04:05:00 | AAPL | Stock | 171.51 | 171.51 | 171.35 | 171.35 | 1860.0 |
| 2024-03-22 04:10:00 | AAPL | Stock | 171.31 | 171.33 | 171.15 | 171.26 | 3773.0 |
| 2024-03-22 04:15:00 | AAPL | Stock | 171.3 | 171.44 | 171.3 | 171.44 | 1155.0 |
| 2024-03-22 04:25:00 | AAPL | Stock | 171.46 | 171.53 | 171.46 | 171.53 | 987.0 |
| 2024-03-22 04:30:00 | AAPL | Stock | 171.7 | 171.74 | 171.7 | 171.74 | 505.0 |
| 2024-03-22 04:35:00 | AAPL | Stock | 171.7 | 171.7 | 171.69 | 171.69 | 566.0 |
| 2024-03-22 04:40:00 | AAPL | Stock | 171.7 | 171.7 | 171.59 | 171.59 | 610.0 |
| 2024-03-22 04:45:00 | AAPL | Stock | 171.58 | 171.58 | 171.56 | 171.56 | 266.0 |
| 2024-03-22 04:50:00 | AAPL | Stock | 171.5 | 171.5 | 171.4 | 171.5 | 1060.0 |
| 2024-03-22 04:55:00 | AAPL | Stock | 171.54 | 171.63 | 171.52 | 171.63 | 1537.0 |
| 2024-03-22 05:05:00 | AAPL | Stock | 171.63 | 171.68 | 171.63 | 171.68 | 373.0 |
| 2024-03-22 05:10:00 | AAPL | Stock | 171.74 | 171.75 | 171.74 | 171.75 | 1997.0 |
| 2024-03-22 05:15:00 | AAPL | Stock | 171.74 | 171.8 | 171.74 | 171.75 | 1975.0 |
| 2024-03-22 05:20:00 | AAPL | Stock | 171.69 | 171.78 | 171.67 | 171.78 | 2230.0 |
| 2024-03-22 05:25:00 | AAPL | Stock | 171.77 | 171.79 | 171.73 | 171.73 | 2461.0 |
| 2024-03-22 05:30:00 | AAPL | Stock | 171.78 | 171.79 | 171.78 | 171.79 | 481.0 |
| 2024-03-22 05:35:00 | AAPL | Stock | 171.79 | 171.8 | 171.77 | 171.8 | 1290.0 |
| 2024-03-22 05:40:00 | AAPL | Stock | 171.77 | 171.77 | 171.7 | 171.7 | 1748.0 |
| 2024-03-22 05:45:00 | AAPL | Stock | 171.79 | 171.79 | 171.74 | 171.74 | 480.0 |
| 2024-03-22 05:50:00 | AAPL | Stock | 171.77 | 171.79 | 171.75 | 171.75 | 550.0 |
| 2024-03-22 05:55:00 | AAPL | Stock | 171.75 | 171.78 | 171.7 | 171.74 | 4759.0 |
| 2024-03-22 06:05:00 | AAPL | Stock | 171.82 | 171.84 | 171.8 | 171.8 | 2125.0 |
| 2024-03-22 06:10:00 | AAPL | Stock | 171.8 | 171.8 | 171.74 | 171.77 | 4118.0 |
| 2024-03-22 06:15:00 | AAPL | Stock | 171.7 | 171.73 | 171.69 | 171.73 | 1025.0 |
| 2024-03-22 06:20:00 | AAPL | Stock | 171.75 | 171.78 | 171.73 | 171.74 | 1166.0 |
| 2024-03-22 06:25:00 | AAPL | Stock | 171.72 | 171.72 | 171.72 | 171.72 | 746.0 |
| 2024-03-22 06:30:00 | AAPL | Stock | 171.73 | 171.73 | 171.72 | 171.72 | 312.0 |
| 2024-03-22 06:35:00 | AAPL | Stock | 171.71 | 171.72 | 171.66 | 171.66 | 740.0 |
| 2024-03-22 06:40:00 | AAPL | Stock | 171.73 | 171.73 | 171.73 | 171.73 | 100.0 |
| 2024-03-22 06:45:00 | AAPL | Stock | 171.74 | 171.74 | 171.69 | 171.69 | 881.0 |
| 2024-03-22 06:50:00 | AAPL | Stock | 171.69 | 171.69 | 171.62 | 171.62 | 838.0 |
| 2024-03-22 06:55:00 | AAPL | Stock | 171.5 | 171.5 | 171.4 | 171.45 | 1682.0 |
| 2024-03-22 07:00:00 | AAPL | Stock | 171.5 | 171.66 | 171.44 | 171.49 | 3336.0 |
| 2024-03-22 07:05:00 | AAPL | Stock | 171.49 | 171.6 | 171.49 | 171.6 | 1128.0 |
| 2024-03-22 07:10:00 | AAPL | Stock | 171.63 | 171.69 | 171.63 | 171.67 | 3855.0 |
| 2024-03-22 07:15:00 | AAPL | Stock | 171.68 | 171.75 | 171.67 | 171.67 | 5163.0 |
| 2024-03-22 07:20:00 | AAPL | Stock | 171.65 | 171.66 | 171.6 | 171.6 | 2257.0 |
| 2024-03-22 07:25:00 | AAPL | Stock | 171.56 | 171.56 | 171.42 | 171.46 | 1699.0 |
| 2024-03-22 07:30:00 | AAPL | Stock | 171.42 | 171.55 | 171.42 | 171.55 | 2029.0 |
| 2024-03-22 07:35:00 | AAPL | Stock | 171.59 | 171.59 | 171.59 | 171.59 | 100.0 |
| 2024-03-22 07:40:00 | AAPL | Stock | 171.56 | 171.56 | 171.42 | 171.42 | 5754.0 |
| 2024-03-22 07:45:00 | AAPL | Stock | 171.42 | 171.42 | 171.2 | 171.2 | 10406.0 |
| 2024-03-22 07:50:00 | AAPL | Stock | 171.12 | 171.14 | 171.02 | 171.09 | 9507.0 |
| 2024-03-22 07:55:00 | AAPL | Stock | 171.19 | 171.19 | 171.05 | 171.05 | 8172.0 |
| 2024-03-22 08:00:00 | AAPL | Stock | 171.66 | 171.75 | 170.96 | 171.5 | 139813.0 |
| 2024-03-22 08:05:00 | AAPL | Stock | 171.43 | 171.43 | 171.01 | 171.18 | 12215.0 |
| 2024-03-22 08:10:00 | AAPL | Stock | 171.23 | 171.36 | 171.21 | 171.31 | 15993.0 |
| 2024-03-22 08:15:00 | AAPL | Stock | 171.2601 | 171.5 | 171.24 | 171.5 | 26046.0 |
| 2024-03-22 08:20:00 | AAPL | Stock | 171.55 | 171.59 | 171.3003 | 171.44 | 18917.0 |
> showing 50 of 395,966 rows — these rows as CSV