PREVIEW / stock_5min / 2008-07-07
file: by_date/stock_5min/2008/2008-07-07.parquet size: 4.7 MB rows: 328,413 symbols: 3,343
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-07 05:15:00 | AAPL | Stock | 6.1136 | 6.1136 | 6.1136 | 6.1136 | 2800.0 |
| 2008-07-07 06:55:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 24724.0 |
| 2008-07-07 07:00:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 2800.0 |
| 2008-07-07 07:05:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 44800.0 |
| 2008-07-07 07:10:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1057 | 6.1057 | 22400.0 |
| 2008-07-07 07:15:00 | AAPL | Stock | 6.1071 | 6.1164 | 6.1071 | 6.1164 | 28000.0 |
| 2008-07-07 07:20:00 | AAPL | Stock | 6.1164 | 6.125 | 6.1164 | 6.125 | 76720.0 |
| 2008-07-07 07:25:00 | AAPL | Stock | 6.1243 | 6.1261 | 6.1243 | 6.1261 | 43820.0 |
| 2008-07-07 07:40:00 | AAPL | Stock | 6.1071 | 6.1079 | 6.1071 | 6.1071 | 140000.0 |
| 2008-07-07 07:45:00 | AAPL | Stock | 6.125 | 6.125 | 6.125 | 6.125 | 5600.0 |
| 2008-07-07 07:50:00 | AAPL | Stock | 6.1296 | 6.1296 | 6.125 | 6.1286 | 8400.0 |
| 2008-07-07 07:55:00 | AAPL | Stock | 6.1296 | 6.15 | 6.125 | 6.1357 | 122080.0 |
| 2008-07-07 08:00:00 | AAPL | Stock | 6.1361 | 6.1361 | 6.1246 | 6.1321 | 261688.0 |
| 2008-07-07 08:05:00 | AAPL | Stock | 6.1357 | 6.1429 | 6.1357 | 6.1429 | 280784.0 |
| 2008-07-07 08:10:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1364 | 6.1429 | 177940.0 |
| 2008-07-07 08:15:00 | AAPL | Stock | 6.1429 | 6.1504 | 6.1414 | 6.1446 | 452620.0 |
| 2008-07-07 08:20:00 | AAPL | Stock | 6.1471 | 6.1782 | 6.1471 | 6.175 | 433020.0 |
| 2008-07-07 08:25:00 | AAPL | Stock | 6.175 | 6.1796 | 6.1725 | 6.1757 | 391692.0 |
| 2008-07-07 08:30:00 | AAPL | Stock | 6.1736 | 6.1739 | 6.1607 | 6.1636 | 307552.0 |
| 2008-07-07 08:35:00 | AAPL | Stock | 6.1668 | 6.1786 | 6.1636 | 6.1786 | 385672.0 |
| 2008-07-07 08:40:00 | AAPL | Stock | 6.1743 | 6.1743 | 6.1529 | 6.1593 | 163100.0 |
| 2008-07-07 08:45:00 | AAPL | Stock | 6.1611 | 6.1721 | 6.1571 | 6.1721 | 149660.0 |
| 2008-07-07 08:50:00 | AAPL | Stock | 6.1586 | 6.1696 | 6.1586 | 6.1686 | 154000.0 |
| 2008-07-07 08:55:00 | AAPL | Stock | 6.1643 | 6.1707 | 6.1607 | 6.1707 | 160720.0 |
| 2008-07-07 09:00:00 | AAPL | Stock | 6.1679 | 6.1696 | 6.165 | 6.1675 | 151620.0 |
| 2008-07-07 09:05:00 | AAPL | Stock | 6.1675 | 6.1707 | 6.1639 | 6.1696 | 166040.0 |
| 2008-07-07 09:10:00 | AAPL | Stock | 6.1696 | 6.1768 | 6.1629 | 6.1632 | 460684.0 |
| 2008-07-07 09:15:00 | AAPL | Stock | 6.1625 | 6.1882 | 6.1625 | 6.1882 | 1029728.0 |
| 2008-07-07 09:20:00 | AAPL | Stock | 6.1875 | 6.1964 | 6.1875 | 6.1893 | 653296.0 |
| 2008-07-07 09:25:00 | AAPL | Stock | 6.1889 | 6.1904 | 6.1754 | 6.1754 | 383656.0 |
| 2008-07-07 09:30:00 | AAPL | Stock | 6.1796 | 6.2161 | 6.1718 | 6.2157 | 18839632.0 |
| 2008-07-07 09:35:00 | AAPL | Stock | 6.2154 | 6.2454 | 6.2071 | 6.2275 | 23457168.0 |
| 2008-07-07 09:40:00 | AAPL | Stock | 6.2261 | 6.2568 | 6.2254 | 6.2479 | 20651596.0 |
| 2008-07-07 09:45:00 | AAPL | Stock | 6.2461 | 6.3118 | 6.2354 | 6.2486 | 18668552.0 |
| 2008-07-07 09:50:00 | AAPL | Stock | 6.2496 | 6.3261 | 6.2396 | 6.2643 | 12295668.0 |
| 2008-07-07 09:55:00 | AAPL | Stock | 6.2654 | 6.2782 | 6.2546 | 6.2775 | 13110160.0 |
| 2008-07-07 10:00:00 | AAPL | Stock | 6.2771 | 6.2857 | 6.2504 | 6.2507 | 13892816.0 |
| 2008-07-07 10:05:00 | AAPL | Stock | 6.2507 | 6.2632 | 6.2471 | 6.2564 | 10531948.0 |
| 2008-07-07 10:10:00 | AAPL | Stock | 6.2561 | 6.2711 | 6.2518 | 6.2611 | 11018168.0 |
| 2008-07-07 10:15:00 | AAPL | Stock | 6.2614 | 6.2643 | 6.2432 | 6.2489 | 11078312.0 |
| 2008-07-07 10:20:00 | AAPL | Stock | 6.2496 | 6.2693 | 6.2468 | 6.2691 | 10204124.0 |
| 2008-07-07 10:25:00 | AAPL | Stock | 6.2693 | 6.2839 | 6.2575 | 6.2729 | 10629108.0 |
| 2008-07-07 10:30:00 | AAPL | Stock | 6.2739 | 6.2889 | 6.2718 | 6.2768 | 11146744.0 |
| 2008-07-07 10:35:00 | AAPL | Stock | 6.2761 | 6.3057 | 6.2711 | 6.2986 | 13616176.0 |
| 2008-07-07 10:40:00 | AAPL | Stock | 6.2982 | 6.3054 | 6.2921 | 6.2982 | 9518432.0 |
| 2008-07-07 10:45:00 | AAPL | Stock | 6.2971 | 6.3132 | 6.2971 | 6.2971 | 11863012.0 |
| 2008-07-07 10:50:00 | AAPL | Stock | 6.2975 | 6.3036 | 6.2921 | 6.2979 | 5741820.0 |
| 2008-07-07 10:55:00 | AAPL | Stock | 6.2986 | 6.2986 | 6.2736 | 6.2871 | 10473316.0 |
| 2008-07-07 11:00:00 | AAPL | Stock | 6.2864 | 6.3025 | 6.2775 | 6.2977 | 7438900.0 |
| 2008-07-07 11:05:00 | AAPL | Stock | 6.2968 | 6.2971 | 6.2707 | 6.2804 | 8503404.0 |
> showing 50 of 328,413 rows — these rows as CSV