PREVIEW / stock_5min / 2024-09-18
file: by_date/stock_5min/2024/2024-09-18.parquet size: 6.6 MB rows: 395,089 symbols: 783
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-18 04:00:00 | AAPL | Stock | 216.2 | 216.2 | 215.73 | 215.81 | 4080.0 |
| 2024-09-18 04:05:00 | AAPL | Stock | 215.8 | 215.8 | 215.69 | 215.69 | 300.0 |
| 2024-09-18 04:10:00 | AAPL | Stock | 215.63 | 215.78 | 215.61 | 215.65 | 2403.0 |
| 2024-09-18 04:15:00 | AAPL | Stock | 215.7 | 215.7 | 215.7 | 215.7 | 1797.0 |
| 2024-09-18 04:20:00 | AAPL | Stock | 215.85 | 215.85 | 215.85 | 215.85 | 184.0 |
| 2024-09-18 04:25:00 | AAPL | Stock | 215.83 | 215.83 | 215.51 | 215.51 | 5578.0 |
| 2024-09-18 04:30:00 | AAPL | Stock | 215.53 | 215.53 | 215.53 | 215.53 | 100.0 |
| 2024-09-18 04:35:00 | AAPL | Stock | 215.6 | 215.64 | 215.5 | 215.5 | 1941.0 |
| 2024-09-18 04:40:00 | AAPL | Stock | 215.5 | 215.5 | 215.5 | 215.5 | 442.0 |
| 2024-09-18 04:45:00 | AAPL | Stock | 215.6 | 215.7 | 215.6 | 215.69 | 1949.0 |
| 2024-09-18 04:50:00 | AAPL | Stock | 215.72 | 215.77 | 215.72 | 215.77 | 2139.0 |
| 2024-09-18 04:55:00 | AAPL | Stock | 215.89 | 216.0 | 215.87 | 216.0 | 1606.0 |
| 2024-09-18 05:00:00 | AAPL | Stock | 216.12 | 216.12 | 216.12 | 216.12 | 200.0 |
| 2024-09-18 05:05:00 | AAPL | Stock | 216.2 | 216.2 | 216.2 | 216.2 | 300.0 |
| 2024-09-18 05:10:00 | AAPL | Stock | 216.14 | 216.14 | 216.14 | 216.14 | 100.0 |
| 2024-09-18 05:15:00 | AAPL | Stock | 216.06 | 216.06 | 216.06 | 216.06 | 100.0 |
| 2024-09-18 05:20:00 | AAPL | Stock | 215.9 | 215.9 | 215.9 | 215.9 | 100.0 |
| 2024-09-18 05:25:00 | AAPL | Stock | 215.99 | 216.0 | 215.94 | 215.94 | 1245.0 |
| 2024-09-18 05:30:00 | AAPL | Stock | 215.94 | 215.95 | 215.94 | 215.95 | 275.0 |
| 2024-09-18 05:35:00 | AAPL | Stock | 215.93 | 215.93 | 215.93 | 215.93 | 218.0 |
| 2024-09-18 05:40:00 | AAPL | Stock | 215.89 | 215.89 | 215.76 | 215.76 | 276.0 |
| 2024-09-18 05:45:00 | AAPL | Stock | 215.76 | 215.85 | 215.75 | 215.85 | 1717.0 |
| 2024-09-18 05:50:00 | AAPL | Stock | 215.89 | 215.89 | 215.81 | 215.81 | 1168.0 |
| 2024-09-18 05:55:00 | AAPL | Stock | 215.87 | 215.9 | 215.87 | 215.88 | 1099.0 |
| 2024-09-18 06:00:00 | AAPL | Stock | 215.97 | 215.97 | 215.94 | 215.94 | 356.0 |
| 2024-09-18 06:05:00 | AAPL | Stock | 215.97 | 216.0 | 215.97 | 216.0 | 663.0 |
| 2024-09-18 06:10:00 | AAPL | Stock | 216.0 | 216.15 | 215.99 | 216.15 | 33970.0 |
| 2024-09-18 06:15:00 | AAPL | Stock | 216.1 | 216.1 | 216.1 | 216.1 | 488.0 |
| 2024-09-18 06:20:00 | AAPL | Stock | 216.1 | 216.1 | 216.1 | 216.1 | 297.0 |
| 2024-09-18 06:25:00 | AAPL | Stock | 216.05 | 216.07 | 216.0 | 216.0 | 1707.0 |
| 2024-09-18 06:35:00 | AAPL | Stock | 216.15 | 216.2 | 216.15 | 216.2 | 2705.0 |
| 2024-09-18 06:40:00 | AAPL | Stock | 216.28 | 216.61 | 216.28 | 216.61 | 10459.0 |
| 2024-09-18 06:45:00 | AAPL | Stock | 216.62 | 216.8 | 216.51 | 216.51 | 5295.0 |
| 2024-09-18 06:50:00 | AAPL | Stock | 216.54 | 216.59 | 216.54 | 216.59 | 492.0 |
| 2024-09-18 06:55:00 | AAPL | Stock | 216.57 | 216.72 | 216.57 | 216.72 | 650.0 |
| 2024-09-18 07:00:00 | AAPL | Stock | 216.74 | 216.8 | 216.61 | 216.7 | 10545.0 |
| 2024-09-18 07:05:00 | AAPL | Stock | 216.7 | 217.1 | 216.7 | 217.03 | 14778.0 |
| 2024-09-18 07:10:00 | AAPL | Stock | 217.1 | 217.1 | 216.89 | 216.98 | 4550.0 |
| 2024-09-18 07:15:00 | AAPL | Stock | 216.85 | 216.88 | 216.85 | 216.88 | 755.0 |
| 2024-09-18 07:20:00 | AAPL | Stock | 216.9 | 216.9 | 216.72 | 216.72 | 518.0 |
| 2024-09-18 07:25:00 | AAPL | Stock | 216.72 | 216.74 | 216.7 | 216.71 | 2044.0 |
| 2024-09-18 07:30:00 | AAPL | Stock | 216.7 | 216.7 | 216.58 | 216.58 | 521.0 |
| 2024-09-18 07:35:00 | AAPL | Stock | 216.5 | 216.55 | 216.34 | 216.55 | 4390.0 |
| 2024-09-18 07:40:00 | AAPL | Stock | 216.55 | 216.55 | 216.36 | 216.36 | 1671.0 |
| 2024-09-18 07:45:00 | AAPL | Stock | 216.4 | 216.52 | 216.3 | 216.4 | 9360.0 |
| 2024-09-18 07:50:00 | AAPL | Stock | 216.44 | 216.44 | 216.44 | 216.44 | 498.0 |
| 2024-09-18 07:55:00 | AAPL | Stock | 216.4 | 216.49 | 216.4 | 216.49 | 540.0 |
| 2024-09-18 08:00:00 | AAPL | Stock | 217.0 | 217.1 | 216.0 | 216.5 | 23961.0 |
| 2024-09-18 08:05:00 | AAPL | Stock | 216.51 | 216.54 | 216.3126 | 216.37 | 7823.0 |
| 2024-09-18 08:10:00 | AAPL | Stock | 216.3 | 216.32 | 216.2729 | 216.3 | 3935.0 |
> showing 50 of 395,089 rows — these rows as CSV