PREVIEW / stock_5min / 2005-05-11
file: by_date/stock_5min/2005/2005-05-11.parquet size: 2.6 MB rows: 191,885 symbols: 1,974
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-05-11 05:25:00 | AAPL | Stock | 1.3 | 1.3 | 1.3 | 1.3 | 11200.0 |
| 2005-05-11 07:10:00 | AAPL | Stock | 1.2764 | 1.2764 | 1.2764 | 1.2764 | 2800.0 |
| 2005-05-11 07:25:00 | AAPL | Stock | 1.2729 | 1.2729 | 1.2714 | 1.2714 | 75600.0 |
| 2005-05-11 07:35:00 | AAPL | Stock | 1.2729 | 1.2729 | 1.2729 | 1.2729 | 123200.0 |
| 2005-05-11 07:40:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2732 | 1.2732 | 179200.0 |
| 2005-05-11 07:55:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 11200.0 |
| 2005-05-11 08:00:00 | AAPL | Stock | 1.2746 | 1.2804 | 1.2714 | 1.2789 | 3117380.0 |
| 2005-05-11 08:05:00 | AAPL | Stock | 1.2793 | 1.2821 | 1.2768 | 1.2768 | 944300.0 |
| 2005-05-11 08:10:00 | AAPL | Stock | 1.2757 | 1.2786 | 1.275 | 1.2768 | 405020.0 |
| 2005-05-11 08:15:00 | AAPL | Stock | 1.2768 | 1.2782 | 1.2768 | 1.2779 | 56000.0 |
| 2005-05-11 08:20:00 | AAPL | Stock | 1.2771 | 1.2771 | 1.2714 | 1.2736 | 711200.0 |
| 2005-05-11 08:25:00 | AAPL | Stock | 1.2739 | 1.275 | 1.2721 | 1.2732 | 116480.0 |
| 2005-05-11 08:30:00 | AAPL | Stock | 1.2718 | 1.2721 | 1.2714 | 1.2718 | 282240.0 |
| 2005-05-11 08:35:00 | AAPL | Stock | 1.2732 | 1.2771 | 1.2729 | 1.2768 | 387240.0 |
| 2005-05-11 08:40:00 | AAPL | Stock | 1.2768 | 1.2786 | 1.275 | 1.2786 | 367500.0 |
| 2005-05-11 08:45:00 | AAPL | Stock | 1.2775 | 1.2779 | 1.2768 | 1.2771 | 198324.0 |
| 2005-05-11 08:50:00 | AAPL | Stock | 1.2779 | 1.2786 | 1.2779 | 1.2779 | 168224.0 |
| 2005-05-11 08:55:00 | AAPL | Stock | 1.2786 | 1.2786 | 1.2686 | 1.2714 | 1477280.0 |
| 2005-05-11 09:00:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.265 | 1.2671 | 1225728.0 |
| 2005-05-11 09:05:00 | AAPL | Stock | 1.2668 | 1.2682 | 1.2657 | 1.2671 | 594216.0 |
| 2005-05-11 09:10:00 | AAPL | Stock | 1.2664 | 1.2671 | 1.2636 | 1.2639 | 1491700.0 |
| 2005-05-11 09:15:00 | AAPL | Stock | 1.2636 | 1.2643 | 1.2614 | 1.2625 | 923972.0 |
| 2005-05-11 09:20:00 | AAPL | Stock | 1.2625 | 1.2639 | 1.2607 | 1.2632 | 963200.0 |
| 2005-05-11 09:25:00 | AAPL | Stock | 1.2636 | 1.2639 | 1.2536 | 1.2589 | 3261020.0 |
| 2005-05-11 09:30:00 | AAPL | Stock | 1.2571 | 1.2675 | 1.2571 | 1.26 | 49373464.0 |
| 2005-05-11 09:35:00 | AAPL | Stock | 1.2604 | 1.2621 | 1.2493 | 1.2564 | 44496480.0 |
| 2005-05-11 09:40:00 | AAPL | Stock | 1.2564 | 1.2571 | 1.2511 | 1.2529 | 24126312.0 |
| 2005-05-11 09:45:00 | AAPL | Stock | 1.2525 | 1.2614 | 1.2525 | 1.2568 | 33062680.0 |
| 2005-05-11 09:50:00 | AAPL | Stock | 1.2568 | 1.2593 | 1.2546 | 1.2571 | 15136968.0 |
| 2005-05-11 09:55:00 | AAPL | Stock | 1.2571 | 1.2579 | 1.2554 | 1.2574 | 13160952.0 |
| 2005-05-11 10:00:00 | AAPL | Stock | 1.2575 | 1.2607 | 1.2543 | 1.2554 | 23811116.0 |
| 2005-05-11 10:05:00 | AAPL | Stock | 1.2554 | 1.2554 | 1.2321 | 1.2357 | 65983512.0 |
| 2005-05-11 10:10:00 | AAPL | Stock | 1.2357 | 1.2418 | 1.2336 | 1.2386 | 36828736.0 |
| 2005-05-11 10:15:00 | AAPL | Stock | 1.2386 | 1.2407 | 1.2364 | 1.2386 | 25408572.0 |
| 2005-05-11 10:20:00 | AAPL | Stock | 1.2386 | 1.2404 | 1.2279 | 1.2307 | 42455980.0 |
| 2005-05-11 10:25:00 | AAPL | Stock | 1.2307 | 1.2314 | 1.2175 | 1.2232 | 48168176.0 |
| 2005-05-11 10:30:00 | AAPL | Stock | 1.2229 | 1.2261 | 1.2025 | 1.2043 | 64711332.0 |
| 2005-05-11 10:35:00 | AAPL | Stock | 1.2043 | 1.2143 | 1.2029 | 1.2121 | 52825388.0 |
| 2005-05-11 10:40:00 | AAPL | Stock | 1.2118 | 1.2239 | 1.2079 | 1.2132 | 36250508.0 |
| 2005-05-11 10:45:00 | AAPL | Stock | 1.2132 | 1.2146 | 1.2061 | 1.2079 | 29276156.0 |
| 2005-05-11 10:50:00 | AAPL | Stock | 1.2079 | 1.21 | 1.1975 | 1.1982 | 37014488.0 |
| 2005-05-11 10:55:00 | AAPL | Stock | 1.1975 | 1.1996 | 1.1825 | 1.1914 | 87187548.0 |
| 2005-05-11 11:00:00 | AAPL | Stock | 1.1914 | 1.2 | 1.1896 | 1.1996 | 55352976.0 |
| 2005-05-11 11:05:00 | AAPL | Stock | 1.2 | 1.2018 | 1.1954 | 1.1975 | 43476748.0 |
| 2005-05-11 11:10:00 | AAPL | Stock | 1.1968 | 1.1989 | 1.1932 | 1.1989 | 31426388.0 |
| 2005-05-11 11:15:00 | AAPL | Stock | 1.1986 | 1.2029 | 1.1975 | 1.2018 | 32781028.0 |
| 2005-05-11 11:20:00 | AAPL | Stock | 1.2018 | 1.2025 | 1.1957 | 1.1986 | 22318016.0 |
| 2005-05-11 11:25:00 | AAPL | Stock | 1.1987 | 1.2121 | 1.1982 | 1.2114 | 35384832.0 |
| 2005-05-11 11:30:00 | AAPL | Stock | 1.2114 | 1.2168 | 1.2054 | 1.2136 | 53905656.0 |
| 2005-05-11 11:35:00 | AAPL | Stock | 1.2136 | 1.2154 | 1.2082 | 1.2104 | 28574224.0 |
> showing 50 of 191,885 rows — these rows as CSV