PREVIEW / stock_5min / 2010-10-05
file: by_date/stock_5min/2010/2010-10-05.parquet size: 4.9 MB rows: 332,572 symbols: 3,499
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-10-05 04:00:00 | AAPL | Stock | 10.0 | 10.0 | 10.0 | 10.0 | 2800.0 |
| 2010-10-05 04:10:00 | AAPL | Stock | 10.0714 | 10.0714 | 10.0714 | 10.0714 | 4256.0 |
| 2010-10-05 04:40:00 | AAPL | Stock | 10.0643 | 10.0643 | 10.0643 | 10.0643 | 2800.0 |
| 2010-10-05 07:15:00 | AAPL | Stock | 10.0021 | 10.0107 | 10.0021 | 10.0107 | 5600.0 |
| 2010-10-05 07:20:00 | AAPL | Stock | 10.0107 | 10.0107 | 10.0107 | 10.0107 | 2800.0 |
| 2010-10-05 07:25:00 | AAPL | Stock | 10.0179 | 10.0318 | 10.0179 | 10.0318 | 5600.0 |
| 2010-10-05 07:30:00 | AAPL | Stock | 10.0096 | 10.0254 | 10.0096 | 10.0254 | 8400.0 |
| 2010-10-05 07:40:00 | AAPL | Stock | 10.0204 | 10.0204 | 10.0118 | 10.0118 | 16520.0 |
| 2010-10-05 07:45:00 | AAPL | Stock | 10.0143 | 10.0179 | 10.0143 | 10.0179 | 5600.0 |
| 2010-10-05 07:50:00 | AAPL | Stock | 10.0146 | 10.0146 | 10.0146 | 10.0146 | 2800.0 |
| 2010-10-05 07:55:00 | AAPL | Stock | 10.0125 | 10.0125 | 10.0125 | 10.0125 | 2800.0 |
| 2010-10-05 08:00:00 | AAPL | Stock | 10.0071 | 10.0161 | 10.0057 | 10.0089 | 263480.0 |
| 2010-10-05 08:05:00 | AAPL | Stock | 10.0118 | 10.0286 | 10.0118 | 10.0286 | 184520.0 |
| 2010-10-05 08:10:00 | AAPL | Stock | 10.0261 | 10.0321 | 10.0261 | 10.0286 | 152628.0 |
| 2010-10-05 08:15:00 | AAPL | Stock | 10.0286 | 10.0304 | 10.0268 | 10.0304 | 76944.0 |
| 2010-10-05 08:20:00 | AAPL | Stock | 10.0307 | 10.0432 | 10.0286 | 10.0404 | 237076.0 |
| 2010-10-05 08:25:00 | AAPL | Stock | 10.0411 | 10.05 | 10.0375 | 10.0464 | 357840.0 |
| 2010-10-05 08:30:00 | AAPL | Stock | 10.0457 | 10.0464 | 10.0371 | 10.0418 | 161112.0 |
| 2010-10-05 08:35:00 | AAPL | Stock | 10.04 | 10.0411 | 10.0379 | 10.0404 | 94892.0 |
| 2010-10-05 08:40:00 | AAPL | Stock | 10.0382 | 10.0468 | 10.0357 | 10.0454 | 496188.0 |
| 2010-10-05 08:45:00 | AAPL | Stock | 10.0457 | 10.06 | 10.0454 | 10.0568 | 289380.0 |
| 2010-10-05 08:50:00 | AAPL | Stock | 10.0554 | 10.0593 | 10.0489 | 10.0593 | 211764.0 |
| 2010-10-05 08:55:00 | AAPL | Stock | 10.0593 | 10.0618 | 10.0464 | 10.0536 | 359212.0 |
| 2010-10-05 09:00:00 | AAPL | Stock | 10.0564 | 10.0596 | 10.0536 | 10.0557 | 179144.0 |
| 2010-10-05 09:05:00 | AAPL | Stock | 10.0596 | 10.0625 | 10.0543 | 10.0618 | 304780.0 |
| 2010-10-05 09:10:00 | AAPL | Stock | 9.9514 | 10.0625 | 9.9514 | 10.0589 | 368116.0 |
| 2010-10-05 09:15:00 | AAPL | Stock | 10.0579 | 10.0593 | 10.0546 | 10.0568 | 121128.0 |
| 2010-10-05 09:20:00 | AAPL | Stock | 10.0568 | 10.0611 | 10.0561 | 10.0596 | 254940.0 |
| 2010-10-05 09:25:00 | AAPL | Stock | 10.0604 | 10.0714 | 10.0529 | 10.0707 | 736120.0 |
| 2010-10-05 09:30:00 | AAPL | Stock | 10.07 | 10.1496 | 10.065 | 10.1468 | 28814324.0 |
| 2010-10-05 09:35:00 | AAPL | Stock | 10.1439 | 10.1625 | 10.1329 | 10.1489 | 19363904.0 |
| 2010-10-05 09:40:00 | AAPL | Stock | 10.1489 | 10.1607 | 10.1361 | 10.1589 | 18915344.0 |
| 2010-10-05 09:45:00 | AAPL | Stock | 10.1604 | 10.1743 | 10.1536 | 10.1679 | 13706588.0 |
| 2010-10-05 09:50:00 | AAPL | Stock | 10.1671 | 10.1889 | 10.1643 | 10.1757 | 11379116.0 |
| 2010-10-05 09:55:00 | AAPL | Stock | 10.175 | 10.1893 | 10.1671 | 10.1839 | 11143888.0 |
| 2010-10-05 10:00:00 | AAPL | Stock | 10.1857 | 10.2336 | 10.1689 | 10.2129 | 23132368.0 |
| 2010-10-05 10:05:00 | AAPL | Stock | 10.2146 | 10.2164 | 10.1979 | 10.205 | 11801300.0 |
| 2010-10-05 10:10:00 | AAPL | Stock | 10.2055 | 10.2175 | 10.2029 | 10.2104 | 6948452.0 |
| 2010-10-05 10:15:00 | AAPL | Stock | 10.2107 | 10.2186 | 10.2 | 10.21 | 7640472.0 |
| 2010-10-05 10:20:00 | AAPL | Stock | 10.2104 | 10.2196 | 10.1786 | 10.1869 | 12633012.0 |
| 2010-10-05 10:25:00 | AAPL | Stock | 10.1871 | 10.2143 | 10.1864 | 10.2143 | 8561952.0 |
| 2010-10-05 10:30:00 | AAPL | Stock | 10.2139 | 10.2264 | 10.2139 | 10.2182 | 8924272.0 |
| 2010-10-05 10:35:00 | AAPL | Stock | 10.2189 | 10.2357 | 10.215 | 10.2239 | 9060100.0 |
| 2010-10-05 10:40:00 | AAPL | Stock | 10.2239 | 10.2375 | 10.2218 | 10.2329 | 4656400.0 |
| 2010-10-05 10:45:00 | AAPL | Stock | 10.235 | 10.2375 | 10.2246 | 10.2339 | 4974256.0 |
| 2010-10-05 10:50:00 | AAPL | Stock | 10.2346 | 10.2371 | 10.2286 | 10.2318 | 3467716.0 |
| 2010-10-05 10:55:00 | AAPL | Stock | 10.2329 | 10.2336 | 10.2082 | 10.2082 | 7190428.0 |
| 2010-10-05 11:00:00 | AAPL | Stock | 10.2104 | 10.2179 | 10.2082 | 10.211 | 4845624.0 |
| 2010-10-05 11:05:00 | AAPL | Stock | 10.2125 | 10.22 | 10.2118 | 10.2175 | 3595200.0 |
| 2010-10-05 11:10:00 | AAPL | Stock | 10.2164 | 10.2179 | 10.2036 | 10.2086 | 3424120.0 |
> showing 50 of 332,572 rows — these rows as CSV