PREVIEW / stock_5min / 2024-09-13
file: by_date/stock_5min/2024/2024-09-13.parquet size: 6.5 MB rows: 399,076 symbols: 860
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-09-13 04:00:00 | AAPL | Stock | 222.7 | 222.7 | 222.68 | 222.68 | 200.0 |
| 2024-09-13 04:05:00 | AAPL | Stock | 222.8 | 222.8 | 222.8 | 222.8 | 200.0 |
| 2024-09-13 04:15:00 | AAPL | Stock | 222.96 | 222.98 | 222.96 | 222.97 | 500.0 |
| 2024-09-13 04:20:00 | AAPL | Stock | 222.97 | 223.0 | 222.95 | 223.0 | 2928.0 |
| 2024-09-13 04:25:00 | AAPL | Stock | 222.9 | 222.92 | 222.9 | 222.9 | 500.0 |
| 2024-09-13 04:30:00 | AAPL | Stock | 222.9 | 222.9 | 222.9 | 222.9 | 100.0 |
| 2024-09-13 04:45:00 | AAPL | Stock | 222.98 | 223.08 | 222.98 | 223.08 | 1707.0 |
| 2024-09-13 04:50:00 | AAPL | Stock | 223.0 | 223.0 | 222.92 | 222.92 | 200.0 |
| 2024-09-13 04:55:00 | AAPL | Stock | 222.9 | 222.95 | 222.9 | 222.95 | 529.0 |
| 2024-09-13 05:05:00 | AAPL | Stock | 223.0 | 223.09 | 223.0 | 223.09 | 1100.0 |
| 2024-09-13 05:10:00 | AAPL | Stock | 223.05 | 223.05 | 223.05 | 223.05 | 133.0 |
| 2024-09-13 05:20:00 | AAPL | Stock | 223.06 | 223.1 | 223.06 | 223.1 | 2521.0 |
| 2024-09-13 05:30:00 | AAPL | Stock | 223.24 | 223.31 | 223.24 | 223.31 | 300.0 |
| 2024-09-13 05:40:00 | AAPL | Stock | 223.26 | 223.26 | 223.26 | 223.26 | 413.0 |
| 2024-09-13 05:50:00 | AAPL | Stock | 223.22 | 223.22 | 223.22 | 223.22 | 100.0 |
| 2024-09-13 06:00:00 | AAPL | Stock | 223.17 | 223.17 | 223.13 | 223.17 | 636.0 |
| 2024-09-13 06:05:00 | AAPL | Stock | 223.13 | 223.2 | 223.13 | 223.2 | 856.0 |
| 2024-09-13 06:10:00 | AAPL | Stock | 223.16 | 223.2 | 223.16 | 223.2 | 494.0 |
| 2024-09-13 06:15:00 | AAPL | Stock | 223.19 | 223.2 | 223.19 | 223.2 | 220.0 |
| 2024-09-13 06:20:00 | AAPL | Stock | 223.14 | 223.46 | 223.14 | 223.45 | 3204.0 |
| 2024-09-13 06:35:00 | AAPL | Stock | 223.34 | 223.4 | 223.34 | 223.4 | 4745.0 |
| 2024-09-13 06:40:00 | AAPL | Stock | 223.4 | 223.42 | 223.4 | 223.42 | 2495.0 |
| 2024-09-13 06:45:00 | AAPL | Stock | 223.42 | 223.42 | 223.42 | 223.42 | 178.0 |
| 2024-09-13 06:50:00 | AAPL | Stock | 223.43 | 223.45 | 223.43 | 223.45 | 239.0 |
| 2024-09-13 06:55:00 | AAPL | Stock | 223.41 | 223.41 | 223.41 | 223.41 | 382.0 |
| 2024-09-13 07:00:00 | AAPL | Stock | 223.46 | 223.49 | 223.31 | 223.31 | 3215.0 |
| 2024-09-13 07:05:00 | AAPL | Stock | 223.37 | 223.37 | 223.25 | 223.25 | 725.0 |
| 2024-09-13 07:10:00 | AAPL | Stock | 223.32 | 223.32 | 223.14 | 223.25 | 1815.0 |
| 2024-09-13 07:20:00 | AAPL | Stock | 223.28 | 223.32 | 223.28 | 223.32 | 560.0 |
| 2024-09-13 07:25:00 | AAPL | Stock | 223.36 | 223.4 | 223.36 | 223.4 | 444.0 |
| 2024-09-13 07:30:00 | AAPL | Stock | 223.5 | 223.5 | 223.4 | 223.4 | 1591.0 |
| 2024-09-13 07:35:00 | AAPL | Stock | 223.35 | 223.78 | 223.31 | 223.5 | 6152.0 |
| 2024-09-13 07:40:00 | AAPL | Stock | 223.55 | 223.62 | 223.55 | 223.6 | 677.0 |
| 2024-09-13 07:45:00 | AAPL | Stock | 223.61 | 224.0 | 223.61 | 223.75 | 9172.0 |
| 2024-09-13 07:50:00 | AAPL | Stock | 223.78 | 224.05 | 223.75 | 224.05 | 4891.0 |
| 2024-09-13 07:55:00 | AAPL | Stock | 224.02 | 224.05 | 223.88 | 224.05 | 3245.0 |
| 2024-09-13 08:00:00 | AAPL | Stock | 223.49 | 224.1455 | 222.97 | 224.145 | 27439.0 |
| 2024-09-13 08:05:00 | AAPL | Stock | 224.1 | 224.1 | 223.89 | 223.89 | 3567.0 |
| 2024-09-13 08:10:00 | AAPL | Stock | 223.89 | 223.9 | 223.85 | 223.9 | 1150.0 |
| 2024-09-13 08:15:00 | AAPL | Stock | 223.86 | 224.05 | 223.86 | 224.03 | 9121.0 |
| 2024-09-13 08:20:00 | AAPL | Stock | 224.01 | 224.01 | 223.9001 | 223.9001 | 3701.0 |
| 2024-09-13 08:25:00 | AAPL | Stock | 223.9802 | 224.059 | 223.9 | 224.05 | 10737.0 |
| 2024-09-13 08:30:00 | AAPL | Stock | 224.05 | 224.15 | 224.0 | 224.15 | 9349.0 |
| 2024-09-13 08:35:00 | AAPL | Stock | 224.1895 | 224.42 | 224.0701 | 224.15 | 11696.0 |
| 2024-09-13 08:40:00 | AAPL | Stock | 224.21 | 224.43 | 224.06 | 224.43 | 16545.0 |
| 2024-09-13 08:45:00 | AAPL | Stock | 224.45 | 224.59 | 224.39 | 224.5 | 12096.0 |
| 2024-09-13 08:50:00 | AAPL | Stock | 224.48 | 224.51 | 224.38 | 224.5 | 13360.0 |
| 2024-09-13 08:55:00 | AAPL | Stock | 224.5 | 224.51 | 224.45 | 224.48 | 21355.0 |
| 2024-09-13 09:00:00 | AAPL | Stock | 224.45 | 224.47 | 224.0313 | 224.0313 | 10659.0 |
| 2024-09-13 09:05:00 | AAPL | Stock | 224.1495 | 224.23 | 224.05 | 224.23 | 8627.0 |
> showing 50 of 399,076 rows — these rows as CSV