PREVIEW / stock_5min / 2002-09-12
file: by_date/stock_5min/2002/2002-09-12.parquet size: 1.7 MB rows: 120,746 symbols: 1,462
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-12 08:30:00 | AAPL | Stock | 0.2511 | 0.2511 | 0.2502 | 0.2502 | 21784.0 |
| 2002-09-12 09:30:00 | AAPL | Stock | 0.2538 | 0.2538 | 0.2529 | 0.2529 | 3980648.0 |
| 2002-09-12 09:35:00 | AAPL | Stock | 0.2529 | 0.2536 | 0.2527 | 0.2529 | 6950104.0 |
| 2002-09-12 09:40:00 | AAPL | Stock | 0.2529 | 0.2532 | 0.2529 | 0.2529 | 2654400.0 |
| 2002-09-12 09:45:00 | AAPL | Stock | 0.2529 | 0.2532 | 0.2521 | 0.2527 | 4042136.0 |
| 2002-09-12 09:50:00 | AAPL | Stock | 0.2529 | 0.2536 | 0.2529 | 0.2532 | 5000800.0 |
| 2002-09-12 09:55:00 | AAPL | Stock | 0.2532 | 0.2554 | 0.2532 | 0.2548 | 4928000.0 |
| 2002-09-12 10:00:00 | AAPL | Stock | 0.2548 | 0.2559 | 0.2545 | 0.2554 | 5499200.0 |
| 2002-09-12 10:05:00 | AAPL | Stock | 0.2553 | 0.2563 | 0.2552 | 0.2552 | 3460800.0 |
| 2002-09-12 10:10:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2539 | 0.2545 | 4480000.0 |
| 2002-09-12 10:15:00 | AAPL | Stock | 0.2545 | 0.2548 | 0.2545 | 0.2548 | 1344448.0 |
| 2002-09-12 10:20:00 | AAPL | Stock | 0.2548 | 0.255 | 0.2541 | 0.2548 | 2433704.0 |
| 2002-09-12 10:25:00 | AAPL | Stock | 0.2545 | 0.255 | 0.2541 | 0.2548 | 2752288.0 |
| 2002-09-12 10:30:00 | AAPL | Stock | 0.2546 | 0.2554 | 0.2545 | 0.2554 | 1498000.0 |
| 2002-09-12 10:35:00 | AAPL | Stock | 0.2554 | 0.2559 | 0.2552 | 0.2555 | 3427592.0 |
| 2002-09-12 10:40:00 | AAPL | Stock | 0.2555 | 0.2559 | 0.2532 | 0.2543 | 16200688.0 |
| 2002-09-12 10:45:00 | AAPL | Stock | 0.2545 | 0.255 | 0.2539 | 0.2545 | 3377304.0 |
| 2002-09-12 10:50:00 | AAPL | Stock | 0.2545 | 0.2552 | 0.2543 | 0.2546 | 3162656.0 |
| 2002-09-12 10:55:00 | AAPL | Stock | 0.2546 | 0.2552 | 0.2545 | 0.255 | 504000.0 |
| 2002-09-12 11:00:00 | AAPL | Stock | 0.255 | 0.2559 | 0.2546 | 0.2559 | 3914400.0 |
| 2002-09-12 11:05:00 | AAPL | Stock | 0.2559 | 0.2563 | 0.2554 | 0.2555 | 1149120.0 |
| 2002-09-12 11:10:00 | AAPL | Stock | 0.2555 | 0.2563 | 0.2554 | 0.2554 | 952000.0 |
| 2002-09-12 11:15:00 | AAPL | Stock | 0.2554 | 0.2557 | 0.2554 | 0.2555 | 1142400.0 |
| 2002-09-12 11:20:00 | AAPL | Stock | 0.2557 | 0.2559 | 0.2554 | 0.2554 | 1036000.0 |
| 2002-09-12 11:25:00 | AAPL | Stock | 0.2554 | 0.2561 | 0.2554 | 0.2554 | 686000.0 |
| 2002-09-12 11:30:00 | AAPL | Stock | 0.2554 | 0.2561 | 0.2554 | 0.2561 | 610400.0 |
| 2002-09-12 11:35:00 | AAPL | Stock | 0.2557 | 0.2559 | 0.2557 | 0.2557 | 77168.0 |
| 2002-09-12 11:40:00 | AAPL | Stock | 0.2557 | 0.2564 | 0.2557 | 0.2561 | 1818768.0 |
| 2002-09-12 11:45:00 | AAPL | Stock | 0.2564 | 0.2564 | 0.2557 | 0.2561 | 794752.0 |
| 2002-09-12 11:50:00 | AAPL | Stock | 0.2561 | 0.257 | 0.2561 | 0.2566 | 1360800.0 |
| 2002-09-12 11:55:00 | AAPL | Stock | 0.2566 | 0.2568 | 0.2561 | 0.2564 | 1794800.0 |
| 2002-09-12 12:00:00 | AAPL | Stock | 0.2564 | 0.2564 | 0.2554 | 0.2554 | 7282464.0 |
| 2002-09-12 12:05:00 | AAPL | Stock | 0.2554 | 0.2557 | 0.2554 | 0.2554 | 5250000.0 |
| 2002-09-12 12:10:00 | AAPL | Stock | 0.2554 | 0.2559 | 0.2554 | 0.2557 | 1282400.0 |
| 2002-09-12 12:15:00 | AAPL | Stock | 0.2555 | 0.2557 | 0.2554 | 0.2554 | 588000.0 |
| 2002-09-12 12:20:00 | AAPL | Stock | 0.2554 | 0.2555 | 0.255 | 0.255 | 856800.0 |
| 2002-09-12 12:25:00 | AAPL | Stock | 0.2554 | 0.2554 | 0.2548 | 0.2548 | 896000.0 |
| 2002-09-12 12:30:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2548 | 0.255 | 1876000.0 |
| 2002-09-12 12:35:00 | AAPL | Stock | 0.2553 | 0.2554 | 0.2548 | 0.2548 | 1967840.0 |
| 2002-09-12 12:40:00 | AAPL | Stock | 0.2548 | 0.2552 | 0.2548 | 0.2548 | 588000.0 |
| 2002-09-12 12:45:00 | AAPL | Stock | 0.255 | 0.2554 | 0.2539 | 0.2552 | 4513600.0 |
| 2002-09-12 12:50:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2552 | 0.2554 | 537600.0 |
| 2002-09-12 12:55:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2552 | 0.2552 | 532000.0 |
| 2002-09-12 13:00:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2552 | 0.2554 | 3169600.0 |
| 2002-09-12 13:05:00 | AAPL | Stock | 0.2554 | 0.2554 | 0.2545 | 0.255 | 1635200.0 |
| 2002-09-12 13:10:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.255 | 0.2552 | 1405600.0 |
| 2002-09-12 13:15:00 | AAPL | Stock | 0.2552 | 0.2561 | 0.255 | 0.2552 | 2524928.0 |
| 2002-09-12 13:20:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2545 | 0.2545 | 806400.0 |
| 2002-09-12 13:25:00 | AAPL | Stock | 0.2545 | 0.2545 | 0.2543 | 0.2545 | 677600.0 |
| 2002-09-12 13:30:00 | AAPL | Stock | 0.2543 | 0.2546 | 0.2543 | 0.2545 | 862400.0 |
> showing 50 of 120,746 rows — these rows as CSV