PREVIEW / stock_5min / 2003-03-31
file: by_date/stock_5min/2003/2003-03-31.parquet size: 1.9 MB rows: 140,588 symbols: 1,559
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-31 08:40:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2571 | 0.2571 | 140000.0 |
| 2003-03-31 08:50:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2571 | 0.2571 | 16800.0 |
| 2003-03-31 09:20:00 | AAPL | Stock | 0.2564 | 0.257 | 0.2563 | 0.257 | 1066800.0 |
| 2003-03-31 09:25:00 | AAPL | Stock | 0.2564 | 0.2571 | 0.2554 | 0.2571 | 1684480.0 |
| 2003-03-31 09:30:00 | AAPL | Stock | 0.2566 | 0.2573 | 0.2554 | 0.2566 | 6505408.0 |
| 2003-03-31 09:35:00 | AAPL | Stock | 0.2563 | 0.2568 | 0.2556 | 0.2559 | 2390808.0 |
| 2003-03-31 09:40:00 | AAPL | Stock | 0.2557 | 0.2565 | 0.2555 | 0.2561 | 2467920.0 |
| 2003-03-31 09:45:00 | AAPL | Stock | 0.2561 | 0.2563 | 0.2554 | 0.2555 | 1709680.0 |
| 2003-03-31 09:50:00 | AAPL | Stock | 0.2557 | 0.2563 | 0.2555 | 0.2563 | 2335592.0 |
| 2003-03-31 09:55:00 | AAPL | Stock | 0.2561 | 0.2563 | 0.2554 | 0.2555 | 3615864.0 |
| 2003-03-31 10:00:00 | AAPL | Stock | 0.2555 | 0.2557 | 0.255 | 0.2552 | 6246464.0 |
| 2003-03-31 10:05:00 | AAPL | Stock | 0.2551 | 0.2555 | 0.2546 | 0.2552 | 5075000.0 |
| 2003-03-31 10:10:00 | AAPL | Stock | 0.2552 | 0.2561 | 0.2545 | 0.2552 | 7098784.0 |
| 2003-03-31 10:15:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2545 | 0.2548 | 3138408.0 |
| 2003-03-31 10:20:00 | AAPL | Stock | 0.2546 | 0.2548 | 0.2543 | 0.2548 | 8050952.0 |
| 2003-03-31 10:25:00 | AAPL | Stock | 0.2548 | 0.2557 | 0.2543 | 0.2545 | 4638760.0 |
| 2003-03-31 10:30:00 | AAPL | Stock | 0.2545 | 0.255 | 0.2539 | 0.2546 | 6151264.0 |
| 2003-03-31 10:35:00 | AAPL | Stock | 0.2546 | 0.2548 | 0.2541 | 0.2541 | 4905600.0 |
| 2003-03-31 10:40:00 | AAPL | Stock | 0.2541 | 0.2543 | 0.2538 | 0.2538 | 4825128.0 |
| 2003-03-31 10:45:00 | AAPL | Stock | 0.2545 | 0.2545 | 0.2534 | 0.2538 | 9612232.0 |
| 2003-03-31 10:50:00 | AAPL | Stock | 0.2538 | 0.2539 | 0.253 | 0.2534 | 2615200.0 |
| 2003-03-31 10:55:00 | AAPL | Stock | 0.2536 | 0.2538 | 0.2529 | 0.2532 | 3571288.0 |
| 2003-03-31 11:00:00 | AAPL | Stock | 0.253 | 0.2538 | 0.253 | 0.253 | 2355360.0 |
| 2003-03-31 11:05:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.253 | 0.2532 | 344400.0 |
| 2003-03-31 11:10:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.2529 | 0.2529 | 1702400.0 |
| 2003-03-31 11:15:00 | AAPL | Stock | 0.2529 | 0.253 | 0.2525 | 0.2529 | 3201352.0 |
| 2003-03-31 11:20:00 | AAPL | Stock | 0.2529 | 0.253 | 0.2527 | 0.2527 | 2553600.0 |
| 2003-03-31 11:25:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2523 | 0.2523 | 2410240.0 |
| 2003-03-31 11:30:00 | AAPL | Stock | 0.2524 | 0.2528 | 0.2523 | 0.2527 | 2067296.0 |
| 2003-03-31 11:35:00 | AAPL | Stock | 0.2527 | 0.2529 | 0.2527 | 0.2529 | 985600.0 |
| 2003-03-31 11:40:00 | AAPL | Stock | 0.2529 | 0.2534 | 0.2529 | 0.2534 | 1871968.0 |
| 2003-03-31 11:45:00 | AAPL | Stock | 0.2536 | 0.2539 | 0.253 | 0.2534 | 2093280.0 |
| 2003-03-31 11:50:00 | AAPL | Stock | 0.2534 | 0.2539 | 0.253 | 0.2534 | 3169600.0 |
| 2003-03-31 11:55:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2532 | 0.2534 | 476000.0 |
| 2003-03-31 12:00:00 | AAPL | Stock | 0.2532 | 0.2539 | 0.253 | 0.2532 | 1477840.0 |
| 2003-03-31 12:05:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2532 | 0.2534 | 371616.0 |
| 2003-03-31 12:10:00 | AAPL | Stock | 0.2534 | 0.2536 | 0.2534 | 0.2536 | 1029728.0 |
| 2003-03-31 12:15:00 | AAPL | Stock | 0.2534 | 0.2538 | 0.2534 | 0.2534 | 1822184.0 |
| 2003-03-31 12:20:00 | AAPL | Stock | 0.2534 | 0.2538 | 0.2534 | 0.2538 | 313600.0 |
| 2003-03-31 12:25:00 | AAPL | Stock | 0.2536 | 0.2538 | 0.2534 | 0.2536 | 1284360.0 |
| 2003-03-31 12:30:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2521 | 0.2523 | 2658600.0 |
| 2003-03-31 12:35:00 | AAPL | Stock | 0.2523 | 0.2525 | 0.252 | 0.2521 | 1292760.0 |
| 2003-03-31 12:40:00 | AAPL | Stock | 0.252 | 0.2527 | 0.252 | 0.2527 | 1170512.0 |
| 2003-03-31 12:45:00 | AAPL | Stock | 0.2525 | 0.2529 | 0.2525 | 0.2527 | 571200.0 |
| 2003-03-31 12:50:00 | AAPL | Stock | 0.2527 | 0.2529 | 0.2525 | 0.2529 | 935200.0 |
| 2003-03-31 12:55:00 | AAPL | Stock | 0.253 | 0.253 | 0.2519 | 0.252 | 1856064.0 |
| 2003-03-31 13:00:00 | AAPL | Stock | 0.252 | 0.2523 | 0.2518 | 0.2521 | 1086400.0 |
| 2003-03-31 13:05:00 | AAPL | Stock | 0.2523 | 0.2525 | 0.2521 | 0.2523 | 1429008.0 |
| 2003-03-31 13:10:00 | AAPL | Stock | 0.2525 | 0.2527 | 0.2523 | 0.2525 | 599200.0 |
| 2003-03-31 13:15:00 | AAPL | Stock | 0.2525 | 0.2527 | 0.2518 | 0.2518 | 2553040.0 |
> showing 50 of 140,588 rows — these rows as CSV