PREVIEW / stock_5min / 2005-01-18
file: by_date/stock_5min/2005/2005-01-18.parquet size: 2.7 MB rows: 194,879 symbols: 1,917
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-18 08:00:00 | AAPL | Stock | 1.2554 | 1.2554 | 1.2554 | 1.2554 | 60480.0 |
| 2005-01-18 08:10:00 | AAPL | Stock | 1.2554 | 1.2554 | 1.2536 | 1.2536 | 123200.0 |
| 2005-01-18 08:15:00 | AAPL | Stock | 1.2536 | 1.2536 | 1.252 | 1.252 | 62160.0 |
| 2005-01-18 08:20:00 | AAPL | Stock | 1.252 | 1.252 | 1.252 | 1.252 | 44800.0 |
| 2005-01-18 08:25:00 | AAPL | Stock | 1.2516 | 1.2516 | 1.2516 | 1.2516 | 28000.0 |
| 2005-01-18 08:30:00 | AAPL | Stock | 1.2514 | 1.2514 | 1.2514 | 1.2514 | 5600.0 |
| 2005-01-18 08:35:00 | AAPL | Stock | 1.2509 | 1.2509 | 1.2473 | 1.2493 | 415800.0 |
| 2005-01-18 08:40:00 | AAPL | Stock | 1.2482 | 1.2482 | 1.2482 | 1.2482 | 5600.0 |
| 2005-01-18 08:45:00 | AAPL | Stock | 1.2477 | 1.2477 | 1.2459 | 1.2459 | 86800.0 |
| 2005-01-18 08:50:00 | AAPL | Stock | 1.2459 | 1.247 | 1.2457 | 1.2464 | 78400.0 |
| 2005-01-18 08:55:00 | AAPL | Stock | 1.2486 | 1.2486 | 1.2486 | 1.2486 | 56000.0 |
| 2005-01-18 09:00:00 | AAPL | Stock | 1.2486 | 1.2486 | 1.2464 | 1.2464 | 187600.0 |
| 2005-01-18 09:05:00 | AAPL | Stock | 1.2491 | 1.2491 | 1.2464 | 1.2464 | 308000.0 |
| 2005-01-18 09:10:00 | AAPL | Stock | 1.2473 | 1.2486 | 1.2473 | 1.2486 | 50400.0 |
| 2005-01-18 09:15:00 | AAPL | Stock | 1.2473 | 1.25 | 1.2473 | 1.2482 | 313600.0 |
| 2005-01-18 09:20:00 | AAPL | Stock | 1.247 | 1.2482 | 1.2455 | 1.2455 | 435400.0 |
| 2005-01-18 09:25:00 | AAPL | Stock | 1.248 | 1.2489 | 1.2429 | 1.2452 | 3159576.0 |
| 2005-01-18 09:30:00 | AAPL | Stock | 1.2454 | 1.2532 | 1.2427 | 1.2482 | 54115768.0 |
| 2005-01-18 09:35:00 | AAPL | Stock | 1.2482 | 1.2505 | 1.2411 | 1.2418 | 33311264.0 |
| 2005-01-18 09:40:00 | AAPL | Stock | 1.2416 | 1.2495 | 1.2395 | 1.2473 | 25195688.0 |
| 2005-01-18 09:45:00 | AAPL | Stock | 1.2473 | 1.25 | 1.2457 | 1.2479 | 16413936.0 |
| 2005-01-18 09:50:00 | AAPL | Stock | 1.2479 | 1.2498 | 1.2384 | 1.2393 | 36623552.0 |
| 2005-01-18 09:55:00 | AAPL | Stock | 1.2395 | 1.2416 | 1.237 | 1.2375 | 36604400.0 |
| 2005-01-18 10:00:00 | AAPL | Stock | 1.2373 | 1.2455 | 1.2359 | 1.2441 | 34470464.0 |
| 2005-01-18 10:05:00 | AAPL | Stock | 1.2441 | 1.2468 | 1.2429 | 1.2443 | 19802832.0 |
| 2005-01-18 10:10:00 | AAPL | Stock | 1.2443 | 1.2468 | 1.242 | 1.2448 | 19642112.0 |
| 2005-01-18 10:15:00 | AAPL | Stock | 1.245 | 1.2473 | 1.2434 | 1.2473 | 8859256.0 |
| 2005-01-18 10:20:00 | AAPL | Stock | 1.2473 | 1.2498 | 1.2452 | 1.2498 | 23837520.0 |
| 2005-01-18 10:25:00 | AAPL | Stock | 1.2496 | 1.2554 | 1.2477 | 1.2546 | 45310888.0 |
| 2005-01-18 10:30:00 | AAPL | Stock | 1.2548 | 1.255 | 1.2491 | 1.252 | 27317808.0 |
| 2005-01-18 10:35:00 | AAPL | Stock | 1.2518 | 1.2575 | 1.2511 | 1.2523 | 31063536.0 |
| 2005-01-18 10:40:00 | AAPL | Stock | 1.2525 | 1.2613 | 1.2525 | 1.2566 | 27605704.0 |
| 2005-01-18 10:45:00 | AAPL | Stock | 1.2561 | 1.2564 | 1.2521 | 1.253 | 9950528.0 |
| 2005-01-18 10:50:00 | AAPL | Stock | 1.2534 | 1.2563 | 1.253 | 1.2545 | 11971792.0 |
| 2005-01-18 10:55:00 | AAPL | Stock | 1.2546 | 1.2584 | 1.2541 | 1.2577 | 9232608.0 |
| 2005-01-18 11:00:00 | AAPL | Stock | 1.2579 | 1.2582 | 1.2554 | 1.2564 | 10412304.0 |
| 2005-01-18 11:05:00 | AAPL | Stock | 1.2561 | 1.2563 | 1.2484 | 1.2495 | 18534264.0 |
| 2005-01-18 11:10:00 | AAPL | Stock | 1.2495 | 1.2505 | 1.2468 | 1.2496 | 12250504.0 |
| 2005-01-18 11:15:00 | AAPL | Stock | 1.2504 | 1.2513 | 1.2488 | 1.25 | 7907816.0 |
| 2005-01-18 11:20:00 | AAPL | Stock | 1.2498 | 1.2511 | 1.2493 | 1.2495 | 7333424.0 |
| 2005-01-18 11:25:00 | AAPL | Stock | 1.2493 | 1.2504 | 1.2479 | 1.2484 | 7794864.0 |
| 2005-01-18 11:30:00 | AAPL | Stock | 1.2491 | 1.2527 | 1.2484 | 1.2525 | 9735376.0 |
| 2005-01-18 11:35:00 | AAPL | Stock | 1.2525 | 1.2545 | 1.2504 | 1.2531 | 7439712.0 |
| 2005-01-18 11:40:00 | AAPL | Stock | 1.253 | 1.2554 | 1.252 | 1.252 | 5526080.0 |
| 2005-01-18 11:45:00 | AAPL | Stock | 1.252 | 1.2563 | 1.25 | 1.2563 | 7035560.0 |
| 2005-01-18 11:50:00 | AAPL | Stock | 1.2559 | 1.2573 | 1.2534 | 1.2555 | 7986048.0 |
| 2005-01-18 11:55:00 | AAPL | Stock | 1.2557 | 1.2561 | 1.2536 | 1.2545 | 4875472.0 |
| 2005-01-18 12:00:00 | AAPL | Stock | 1.2545 | 1.2571 | 1.2545 | 1.2561 | 5726112.0 |
| 2005-01-18 12:05:00 | AAPL | Stock | 1.2561 | 1.2568 | 1.2548 | 1.2563 | 3130064.0 |
| 2005-01-18 12:10:00 | AAPL | Stock | 1.2557 | 1.2575 | 1.255 | 1.2561 | 9439136.0 |
> showing 50 of 194,879 rows — these rows as CSV