PREVIEW / stock_5min / 2010-05-05
file: by_date/stock_5min/2010/2010-05-05.parquet size: 5.2 MB rows: 351,626 symbols: 3,481
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-05 04:15:00 | AAPL | Stock | 9.1536 | 9.1679 | 9.1536 | 9.1679 | 8400.0 |
| 2010-05-05 04:35:00 | AAPL | Stock | 9.1671 | 9.1671 | 9.1671 | 9.1671 | 2800.0 |
| 2010-05-05 04:40:00 | AAPL | Stock | 9.1675 | 9.1675 | 9.1393 | 9.1393 | 11200.0 |
| 2010-05-05 05:00:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 3724.0 |
| 2010-05-05 05:10:00 | AAPL | Stock | 9.175 | 9.175 | 9.175 | 9.175 | 11200.0 |
| 2010-05-05 05:40:00 | AAPL | Stock | 9.2057 | 9.2057 | 9.2057 | 9.2057 | 16800.0 |
| 2010-05-05 05:50:00 | AAPL | Stock | 9.2057 | 9.2168 | 9.2057 | 9.2168 | 81228.0 |
| 2010-05-05 05:55:00 | AAPL | Stock | 9.2057 | 9.2057 | 9.2057 | 9.2057 | 17920.0 |
| 2010-05-05 06:25:00 | AAPL | Stock | 9.2007 | 9.2007 | 9.2007 | 9.2007 | 2800.0 |
| 2010-05-05 06:30:00 | AAPL | Stock | 9.2032 | 9.2032 | 9.2032 | 9.2032 | 23520.0 |
| 2010-05-05 06:35:00 | AAPL | Stock | 9.2032 | 9.2032 | 9.2032 | 9.2032 | 4200.0 |
| 2010-05-05 07:00:00 | AAPL | Stock | 9.1929 | 9.1929 | 9.1929 | 9.1929 | 22624.0 |
| 2010-05-05 07:05:00 | AAPL | Stock | 9.1929 | 9.1929 | 9.1818 | 9.1821 | 19600.0 |
| 2010-05-05 07:10:00 | AAPL | Stock | 9.1821 | 9.1821 | 9.1821 | 9.1821 | 2800.0 |
| 2010-05-05 07:20:00 | AAPL | Stock | 9.2089 | 9.2089 | 9.1918 | 9.1918 | 7000.0 |
| 2010-05-05 07:25:00 | AAPL | Stock | 9.1918 | 9.1918 | 9.1914 | 9.1918 | 28000.0 |
| 2010-05-05 07:30:00 | AAPL | Stock | 9.1875 | 9.1961 | 9.1875 | 9.1961 | 36400.0 |
| 2010-05-05 07:35:00 | AAPL | Stock | 9.1871 | 9.1871 | 9.1868 | 9.1868 | 5600.0 |
| 2010-05-05 07:40:00 | AAPL | Stock | 9.1875 | 9.1875 | 9.1875 | 9.1875 | 20300.0 |
| 2010-05-05 07:45:00 | AAPL | Stock | 9.1818 | 9.1996 | 9.1786 | 9.1996 | 54040.0 |
| 2010-05-05 07:50:00 | AAPL | Stock | 9.1964 | 9.1986 | 9.1964 | 9.1964 | 14000.0 |
| 2010-05-05 07:55:00 | AAPL | Stock | 9.1964 | 9.1971 | 9.1929 | 9.1929 | 151200.0 |
| 2010-05-05 08:00:00 | AAPL | Stock | 9.1911 | 9.1989 | 9.1839 | 9.1929 | 286832.0 |
| 2010-05-05 08:05:00 | AAPL | Stock | 9.1939 | 9.1989 | 9.1911 | 9.1964 | 133560.0 |
| 2010-05-05 08:10:00 | AAPL | Stock | 9.1954 | 9.2 | 9.1896 | 9.1925 | 81200.0 |
| 2010-05-05 08:15:00 | AAPL | Stock | 9.1889 | 9.1929 | 9.1771 | 9.1771 | 326172.0 |
| 2010-05-05 08:20:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1479 | 9.1607 | 636524.0 |
| 2010-05-05 08:25:00 | AAPL | Stock | 9.1604 | 9.1604 | 9.1125 | 9.125 | 1174460.0 |
| 2010-05-05 08:30:00 | AAPL | Stock | 9.125 | 9.1339 | 9.1121 | 9.1254 | 529732.0 |
| 2010-05-05 08:35:00 | AAPL | Stock | 9.1268 | 9.1275 | 9.1025 | 9.1089 | 817936.0 |
| 2010-05-05 08:40:00 | AAPL | Stock | 9.1096 | 9.1289 | 9.1043 | 9.125 | 677908.0 |
| 2010-05-05 08:45:00 | AAPL | Stock | 9.1254 | 9.1254 | 9.0929 | 9.0964 | 737604.0 |
| 2010-05-05 08:50:00 | AAPL | Stock | 9.0964 | 9.103 | 9.0604 | 9.07 | 1052436.0 |
| 2010-05-05 08:55:00 | AAPL | Stock | 9.0689 | 9.0814 | 9.0593 | 9.0696 | 903840.0 |
| 2010-05-05 09:00:00 | AAPL | Stock | 9.0679 | 9.0679 | 9.0393 | 9.0529 | 1182104.0 |
| 2010-05-05 09:05:00 | AAPL | Stock | 9.0529 | 9.07 | 9.0457 | 9.06 | 1685488.0 |
| 2010-05-05 09:10:00 | AAPL | Stock | 9.0571 | 9.065 | 9.0446 | 9.0482 | 837032.0 |
| 2010-05-05 09:15:00 | AAPL | Stock | 9.0464 | 9.0493 | 9.0325 | 9.0411 | 1260784.0 |
| 2010-05-05 09:20:00 | AAPL | Stock | 9.0386 | 9.0532 | 9.0314 | 9.0393 | 987028.0 |
| 2010-05-05 09:25:00 | AAPL | Stock | 9.0414 | 9.0536 | 9.0321 | 9.0321 | 1453508.0 |
| 2010-05-05 09:30:00 | AAPL | Stock | 9.0361 | 9.0389 | 8.8832 | 8.96 | 81156600.0 |
| 2010-05-05 09:35:00 | AAPL | Stock | 8.9632 | 8.9886 | 8.9475 | 8.9746 | 32610564.0 |
| 2010-05-05 09:40:00 | AAPL | Stock | 8.9729 | 9.0139 | 8.9682 | 8.9939 | 23907828.0 |
| 2010-05-05 09:45:00 | AAPL | Stock | 8.9932 | 8.9968 | 8.9575 | 8.9832 | 17793468.0 |
| 2010-05-05 09:50:00 | AAPL | Stock | 8.9811 | 8.9839 | 8.9371 | 8.9793 | 18035556.0 |
| 2010-05-05 09:55:00 | AAPL | Stock | 8.9775 | 9.0179 | 8.9218 | 8.9807 | 30261672.0 |
| 2010-05-05 10:00:00 | AAPL | Stock | 8.9807 | 8.9943 | 8.9518 | 8.9821 | 22114260.0 |
| 2010-05-05 10:05:00 | AAPL | Stock | 8.9832 | 9.0093 | 8.9518 | 8.9878 | 21423612.0 |
| 2010-05-05 10:10:00 | AAPL | Stock | 8.9896 | 9.025 | 8.9646 | 8.9979 | 19363428.0 |
| 2010-05-05 10:15:00 | AAPL | Stock | 8.9996 | 9.0464 | 8.9854 | 9.0429 | 26408312.0 |
> showing 50 of 351,626 rows — these rows as CSV