PREVIEW / stock_5min / 2005-01-20
file: by_date/stock_5min/2005/2005-01-20.parquet size: 2.6 MB rows: 192,739 symbols: 1,899
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-20 08:00:00 | AAPL | Stock | 1.2366 | 1.2377 | 1.2366 | 1.2366 | 64960.0 |
| 2005-01-20 08:05:00 | AAPL | Stock | 1.2393 | 1.2402 | 1.2393 | 1.2393 | 52080.0 |
| 2005-01-20 08:10:00 | AAPL | Stock | 1.237 | 1.2388 | 1.2366 | 1.2375 | 179200.0 |
| 2005-01-20 08:20:00 | AAPL | Stock | 1.2393 | 1.2418 | 1.2368 | 1.2375 | 971544.0 |
| 2005-01-20 08:25:00 | AAPL | Stock | 1.2393 | 1.2411 | 1.2375 | 1.2375 | 112000.0 |
| 2005-01-20 08:30:00 | AAPL | Stock | 1.2393 | 1.2393 | 1.2377 | 1.2393 | 295456.0 |
| 2005-01-20 08:35:00 | AAPL | Stock | 1.2411 | 1.2429 | 1.2409 | 1.2429 | 392504.0 |
| 2005-01-20 08:40:00 | AAPL | Stock | 1.2429 | 1.2438 | 1.2429 | 1.2438 | 218400.0 |
| 2005-01-20 08:45:00 | AAPL | Stock | 1.2432 | 1.2438 | 1.2411 | 1.2411 | 504000.0 |
| 2005-01-20 08:50:00 | AAPL | Stock | 1.2409 | 1.2438 | 1.2409 | 1.2438 | 58800.0 |
| 2005-01-20 08:55:00 | AAPL | Stock | 1.2411 | 1.2429 | 1.2411 | 1.242 | 319200.0 |
| 2005-01-20 09:00:00 | AAPL | Stock | 1.242 | 1.2421 | 1.2409 | 1.2409 | 28000.0 |
| 2005-01-20 09:05:00 | AAPL | Stock | 1.24 | 1.2429 | 1.24 | 1.24 | 221200.0 |
| 2005-01-20 09:10:00 | AAPL | Stock | 1.24 | 1.2402 | 1.2395 | 1.2402 | 179200.0 |
| 2005-01-20 09:15:00 | AAPL | Stock | 1.2409 | 1.2409 | 1.2395 | 1.2395 | 67200.0 |
| 2005-01-20 09:20:00 | AAPL | Stock | 1.2409 | 1.2436 | 1.2409 | 1.2436 | 106400.0 |
| 2005-01-20 09:25:00 | AAPL | Stock | 1.2455 | 1.2455 | 1.242 | 1.2432 | 743400.0 |
| 2005-01-20 09:30:00 | AAPL | Stock | 1.2438 | 1.2527 | 1.2413 | 1.2455 | 32855200.0 |
| 2005-01-20 09:35:00 | AAPL | Stock | 1.245 | 1.2489 | 1.2405 | 1.2461 | 16372608.0 |
| 2005-01-20 09:40:00 | AAPL | Stock | 1.2461 | 1.2496 | 1.2459 | 1.2464 | 15787632.0 |
| 2005-01-20 09:45:00 | AAPL | Stock | 1.2464 | 1.2536 | 1.2464 | 1.2514 | 16060632.0 |
| 2005-01-20 09:50:00 | AAPL | Stock | 1.2518 | 1.2525 | 1.2452 | 1.2455 | 22388688.0 |
| 2005-01-20 09:55:00 | AAPL | Stock | 1.2455 | 1.2502 | 1.243 | 1.2482 | 13099184.0 |
| 2005-01-20 10:00:00 | AAPL | Stock | 1.248 | 1.2532 | 1.2475 | 1.253 | 19422592.0 |
| 2005-01-20 10:05:00 | AAPL | Stock | 1.253 | 1.2596 | 1.2527 | 1.257 | 24400096.0 |
| 2005-01-20 10:10:00 | AAPL | Stock | 1.2571 | 1.2607 | 1.2555 | 1.2575 | 23779784.0 |
| 2005-01-20 10:15:00 | AAPL | Stock | 1.2577 | 1.2582 | 1.2545 | 1.2571 | 11182920.0 |
| 2005-01-20 10:20:00 | AAPL | Stock | 1.2571 | 1.2596 | 1.2564 | 1.2595 | 7996296.0 |
| 2005-01-20 10:25:00 | AAPL | Stock | 1.2595 | 1.2598 | 1.2507 | 1.2552 | 14665224.0 |
| 2005-01-20 10:30:00 | AAPL | Stock | 1.2552 | 1.2564 | 1.2545 | 1.2548 | 17684688.0 |
| 2005-01-20 10:35:00 | AAPL | Stock | 1.2548 | 1.2568 | 1.2527 | 1.2566 | 6995408.0 |
| 2005-01-20 10:40:00 | AAPL | Stock | 1.2566 | 1.2579 | 1.2559 | 1.2571 | 4040064.0 |
| 2005-01-20 10:45:00 | AAPL | Stock | 1.2573 | 1.2586 | 1.257 | 1.2571 | 3380104.0 |
| 2005-01-20 10:50:00 | AAPL | Stock | 1.2571 | 1.2589 | 1.2571 | 1.2586 | 4566072.0 |
| 2005-01-20 10:55:00 | AAPL | Stock | 1.2586 | 1.2605 | 1.2571 | 1.2596 | 13709976.0 |
| 2005-01-20 11:00:00 | AAPL | Stock | 1.2595 | 1.2623 | 1.2588 | 1.2618 | 11806592.0 |
| 2005-01-20 11:05:00 | AAPL | Stock | 1.2618 | 1.265 | 1.2611 | 1.2625 | 20835752.0 |
| 2005-01-20 11:10:00 | AAPL | Stock | 1.2623 | 1.2625 | 1.2589 | 1.2616 | 11598832.0 |
| 2005-01-20 11:15:00 | AAPL | Stock | 1.2616 | 1.2638 | 1.2611 | 1.2638 | 5906768.0 |
| 2005-01-20 11:20:00 | AAPL | Stock | 1.2638 | 1.2657 | 1.2638 | 1.2657 | 11111072.0 |
| 2005-01-20 11:25:00 | AAPL | Stock | 1.2655 | 1.2679 | 1.265 | 1.2675 | 18209128.0 |
| 2005-01-20 11:30:00 | AAPL | Stock | 1.2679 | 1.2695 | 1.2636 | 1.2654 | 14384328.0 |
| 2005-01-20 11:35:00 | AAPL | Stock | 1.2655 | 1.2677 | 1.2571 | 1.2648 | 15598856.0 |
| 2005-01-20 11:40:00 | AAPL | Stock | 1.2648 | 1.2688 | 1.2648 | 1.2673 | 7095424.0 |
| 2005-01-20 11:45:00 | AAPL | Stock | 1.2675 | 1.2713 | 1.2668 | 1.2704 | 13656832.0 |
| 2005-01-20 11:50:00 | AAPL | Stock | 1.2704 | 1.2723 | 1.2684 | 1.2713 | 19714296.0 |
| 2005-01-20 11:55:00 | AAPL | Stock | 1.2711 | 1.2727 | 1.2688 | 1.2691 | 15625176.0 |
| 2005-01-20 12:00:00 | AAPL | Stock | 1.2686 | 1.2691 | 1.2568 | 1.2638 | 20376664.0 |
| 2005-01-20 12:05:00 | AAPL | Stock | 1.2638 | 1.2645 | 1.2607 | 1.2618 | 11365816.0 |
| 2005-01-20 12:10:00 | AAPL | Stock | 1.2618 | 1.2648 | 1.2607 | 1.2646 | 7998256.0 |
> showing 50 of 192,739 rows — these rows as CSV