PREVIEW / stock_5min / 2008-09-15
file: by_date/stock_5min/2008/2008-09-15.parquet size: 4.5 MB rows: 318,995 symbols: 3,337
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-09-15 04:15:00 | AAPL | Stock | 5.25 | 5.25 | 5.1786 | 5.1786 | 7000.0 |
| 2008-09-15 04:25:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 5600.0 |
| 2008-09-15 04:40:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 2800.0 |
| 2008-09-15 05:25:00 | AAPL | Stock | 5.1104 | 5.1104 | 5.1071 | 5.1071 | 44800.0 |
| 2008-09-15 05:30:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1107 | 5.1107 | 12880.0 |
| 2008-09-15 06:25:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 2800.0 |
| 2008-09-15 06:30:00 | AAPL | Stock | 5.1071 | 5.1429 | 5.1071 | 5.1429 | 77280.0 |
| 2008-09-15 06:35:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 16800.0 |
| 2008-09-15 06:40:00 | AAPL | Stock | 5.125 | 5.125 | 5.125 | 5.125 | 8400.0 |
| 2008-09-15 07:00:00 | AAPL | Stock | 5.1075 | 5.1096 | 5.1075 | 5.1075 | 40460.0 |
| 2008-09-15 07:05:00 | AAPL | Stock | 5.1089 | 5.1089 | 5.1089 | 5.1089 | 4900.0 |
| 2008-09-15 07:10:00 | AAPL | Stock | 5.1075 | 5.1075 | 5.1075 | 5.1075 | 8400.0 |
| 2008-09-15 07:15:00 | AAPL | Stock | 5.1075 | 5.1161 | 5.1071 | 5.1089 | 276724.0 |
| 2008-09-15 07:20:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1161 | 5.1161 | 16800.0 |
| 2008-09-15 07:25:00 | AAPL | Stock | 5.1107 | 5.1143 | 5.0982 | 5.0982 | 61600.0 |
| 2008-09-15 07:30:00 | AAPL | Stock | 5.0946 | 5.0946 | 5.0714 | 5.0714 | 247520.0 |
| 2008-09-15 07:35:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0714 | 5.0811 | 308308.0 |
| 2008-09-15 07:40:00 | AAPL | Stock | 5.0846 | 5.0964 | 5.0846 | 5.0964 | 31976.0 |
| 2008-09-15 07:45:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.0714 | 5.0914 | 204288.0 |
| 2008-09-15 07:50:00 | AAPL | Stock | 5.0925 | 5.1071 | 5.0714 | 5.0921 | 238840.0 |
| 2008-09-15 07:55:00 | AAPL | Stock | 5.0943 | 5.0943 | 5.0921 | 5.0929 | 103600.0 |
| 2008-09-15 08:00:00 | AAPL | Stock | 5.0921 | 5.1036 | 5.0046 | 5.0536 | 1118488.0 |
| 2008-09-15 08:05:00 | AAPL | Stock | 5.0604 | 5.0621 | 5.0179 | 5.0296 | 854252.0 |
| 2008-09-15 08:10:00 | AAPL | Stock | 5.0354 | 5.0625 | 5.0289 | 5.0625 | 718536.0 |
| 2008-09-15 08:15:00 | AAPL | Stock | 5.0625 | 5.1018 | 5.0625 | 5.0889 | 561120.0 |
| 2008-09-15 08:20:00 | AAPL | Stock | 5.0839 | 5.0839 | 5.0618 | 5.0661 | 533120.0 |
| 2008-09-15 08:25:00 | AAPL | Stock | 5.0661 | 5.075 | 5.0643 | 5.0714 | 736316.0 |
| 2008-09-15 08:30:00 | AAPL | Stock | 5.0714 | 5.0946 | 5.0689 | 5.0929 | 163772.0 |
| 2008-09-15 08:35:00 | AAPL | Stock | 5.0929 | 5.1018 | 5.0911 | 5.0911 | 495320.0 |
| 2008-09-15 08:40:00 | AAPL | Stock | 5.0996 | 5.1186 | 5.0968 | 5.1018 | 699664.0 |
| 2008-09-15 08:45:00 | AAPL | Stock | 5.1018 | 5.1179 | 5.1 | 5.1179 | 170716.0 |
| 2008-09-15 08:50:00 | AAPL | Stock | 5.11 | 5.1143 | 5.11 | 5.1139 | 108920.0 |
| 2008-09-15 08:55:00 | AAPL | Stock | 5.1139 | 5.1143 | 5.1 | 5.1004 | 239876.0 |
| 2008-09-15 09:00:00 | AAPL | Stock | 5.1029 | 5.1032 | 5.0714 | 5.0846 | 610204.0 |
| 2008-09-15 09:05:00 | AAPL | Stock | 5.0821 | 5.0843 | 5.0804 | 5.0804 | 183232.0 |
| 2008-09-15 09:10:00 | AAPL | Stock | 5.0789 | 5.0868 | 5.0786 | 5.0818 | 399112.0 |
| 2008-09-15 09:15:00 | AAPL | Stock | 5.0818 | 5.0839 | 5.0786 | 5.0825 | 488992.0 |
| 2008-09-15 09:20:00 | AAPL | Stock | 5.0836 | 5.0875 | 5.0789 | 5.0789 | 523096.0 |
| 2008-09-15 09:25:00 | AAPL | Stock | 5.0854 | 5.0954 | 5.0714 | 5.0732 | 1422792.0 |
| 2008-09-15 09:30:00 | AAPL | Stock | 5.0725 | 5.1311 | 5.0589 | 5.1282 | 36964424.0 |
| 2008-09-15 09:35:00 | AAPL | Stock | 5.1268 | 5.1486 | 5.1006 | 5.1311 | 24467940.0 |
| 2008-09-15 09:40:00 | AAPL | Stock | 5.1304 | 5.1964 | 5.1229 | 5.1839 | 23502192.0 |
| 2008-09-15 09:45:00 | AAPL | Stock | 5.1839 | 5.2225 | 5.1811 | 5.1939 | 21184100.0 |
| 2008-09-15 09:50:00 | AAPL | Stock | 5.1932 | 5.2011 | 5.1607 | 5.1764 | 16255680.0 |
| 2008-09-15 09:55:00 | AAPL | Stock | 5.1761 | 5.2011 | 5.165 | 5.185 | 12951148.0 |
| 2008-09-15 10:00:00 | AAPL | Stock | 5.1846 | 5.2382 | 5.1729 | 5.2146 | 15989736.0 |
| 2008-09-15 10:05:00 | AAPL | Stock | 5.2146 | 5.23 | 5.1975 | 5.2146 | 10723552.0 |
| 2008-09-15 10:10:00 | AAPL | Stock | 5.2146 | 5.2393 | 5.1879 | 5.1921 | 13722548.0 |
| 2008-09-15 10:15:00 | AAPL | Stock | 5.1929 | 5.2143 | 5.1843 | 5.2068 | 9731456.0 |
| 2008-09-15 10:20:00 | AAPL | Stock | 5.2071 | 5.2282 | 5.195 | 5.2 | 9627716.0 |
> showing 50 of 318,995 rows — these rows as CSV