PREVIEW / stock_5min / 2008-09-22
file: by_date/stock_5min/2008/2008-09-22.parquet size: 4.5 MB rows: 319,796 symbols: 3,363
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-22 07:05:00 | AAPL | Stock | 5.0 | 5.0 | 4.9943 | 4.9943 | 107716.0 |
| 2008-09-22 07:15:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9679 | 4.9679 | 42000.0 |
| 2008-09-22 07:35:00 | AAPL | Stock | 4.9679 | 4.9679 | 4.9679 | 4.9679 | 5600.0 |
| 2008-09-22 07:40:00 | AAPL | Stock | 4.9732 | 4.9732 | 4.9607 | 4.9711 | 287532.0 |
| 2008-09-22 07:45:00 | AAPL | Stock | 4.9586 | 4.9586 | 4.9568 | 4.9568 | 33600.0 |
| 2008-09-22 07:50:00 | AAPL | Stock | 4.9571 | 4.9571 | 4.9571 | 4.9571 | 53200.0 |
| 2008-09-22 08:00:00 | AAPL | Stock | 4.9679 | 4.9696 | 4.9571 | 4.9575 | 283164.0 |
| 2008-09-22 08:05:00 | AAPL | Stock | 4.9571 | 4.9693 | 4.9571 | 4.9636 | 379960.0 |
| 2008-09-22 08:10:00 | AAPL | Stock | 4.9589 | 4.9654 | 4.9589 | 4.9643 | 218120.0 |
| 2008-09-22 08:15:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9511 | 4.9521 | 123872.0 |
| 2008-09-22 08:20:00 | AAPL | Stock | 4.9554 | 4.9729 | 4.955 | 4.9689 | 401408.0 |
| 2008-09-22 08:25:00 | AAPL | Stock | 4.9679 | 4.9761 | 4.9643 | 4.9761 | 189056.0 |
| 2008-09-22 08:30:00 | AAPL | Stock | 4.9729 | 4.9875 | 4.9729 | 4.9857 | 126000.0 |
| 2008-09-22 08:35:00 | AAPL | Stock | 4.985 | 5.0 | 4.9775 | 4.9957 | 334180.0 |
| 2008-09-22 08:40:00 | AAPL | Stock | 4.9921 | 5.0 | 4.9879 | 5.0 | 408520.0 |
| 2008-09-22 08:45:00 | AAPL | Stock | 4.9943 | 5.0068 | 4.9936 | 4.9964 | 262304.0 |
| 2008-09-22 08:50:00 | AAPL | Stock | 5.0 | 5.0 | 4.9846 | 4.9893 | 435260.0 |
| 2008-09-22 08:55:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.9804 | 4.9818 | 143360.0 |
| 2008-09-22 09:00:00 | AAPL | Stock | 4.9818 | 5.0093 | 4.9818 | 5.0079 | 401604.0 |
| 2008-09-22 09:05:00 | AAPL | Stock | 5.0079 | 5.0268 | 5.005 | 5.025 | 421764.0 |
| 2008-09-22 09:10:00 | AAPL | Stock | 5.0179 | 5.0268 | 5.0143 | 5.0196 | 440440.0 |
| 2008-09-22 09:15:00 | AAPL | Stock | 5.0111 | 5.0143 | 5.0043 | 5.0143 | 211400.0 |
| 2008-09-22 09:20:00 | AAPL | Stock | 5.0093 | 5.0093 | 4.9896 | 4.9982 | 165060.0 |
| 2008-09-22 09:25:00 | AAPL | Stock | 4.9982 | 5.0 | 4.9779 | 4.9932 | 311080.0 |
| 2008-09-22 09:30:00 | AAPL | Stock | 4.9979 | 5.0089 | 4.9604 | 4.9843 | 23345644.0 |
| 2008-09-22 09:35:00 | AAPL | Stock | 4.9839 | 4.9911 | 4.9571 | 4.9614 | 20878424.0 |
| 2008-09-22 09:40:00 | AAPL | Stock | 4.9614 | 4.9664 | 4.9186 | 4.9421 | 20325284.0 |
| 2008-09-22 09:45:00 | AAPL | Stock | 4.9375 | 4.9632 | 4.9179 | 4.9596 | 17156468.0 |
| 2008-09-22 09:50:00 | AAPL | Stock | 4.9596 | 4.9607 | 4.9154 | 4.929 | 15222340.0 |
| 2008-09-22 09:55:00 | AAPL | Stock | 4.9289 | 4.9489 | 4.9193 | 4.9475 | 12208896.0 |
| 2008-09-22 10:00:00 | AAPL | Stock | 4.9464 | 4.9514 | 4.9168 | 4.9407 | 14641200.0 |
| 2008-09-22 10:05:00 | AAPL | Stock | 4.9407 | 4.9664 | 4.9329 | 4.9432 | 15881796.0 |
| 2008-09-22 10:10:00 | AAPL | Stock | 4.9429 | 4.9521 | 4.9211 | 4.9257 | 9096584.0 |
| 2008-09-22 10:15:00 | AAPL | Stock | 4.925 | 4.9368 | 4.9129 | 4.9196 | 9880500.0 |
| 2008-09-22 10:20:00 | AAPL | Stock | 4.9193 | 4.9304 | 4.9107 | 4.9211 | 8202292.0 |
| 2008-09-22 10:25:00 | AAPL | Stock | 4.9211 | 4.9354 | 4.9046 | 4.9325 | 11599420.0 |
| 2008-09-22 10:30:00 | AAPL | Stock | 4.9329 | 4.9471 | 4.9243 | 4.9429 | 12335540.0 |
| 2008-09-22 10:35:00 | AAPL | Stock | 4.9429 | 4.9461 | 4.9254 | 4.9321 | 10137092.0 |
| 2008-09-22 10:40:00 | AAPL | Stock | 4.9325 | 4.9504 | 4.9314 | 4.9389 | 8347024.0 |
| 2008-09-22 10:45:00 | AAPL | Stock | 4.9393 | 4.9564 | 4.9346 | 4.9489 | 7188524.0 |
| 2008-09-22 10:50:00 | AAPL | Stock | 4.9493 | 4.9643 | 4.9471 | 4.9536 | 9889152.0 |
| 2008-09-22 10:55:00 | AAPL | Stock | 4.9539 | 4.9779 | 4.9525 | 4.9657 | 12341280.0 |
| 2008-09-22 11:00:00 | AAPL | Stock | 4.9657 | 4.975 | 4.9557 | 4.9557 | 9404052.0 |
| 2008-09-22 11:05:00 | AAPL | Stock | 4.9554 | 4.9632 | 4.9186 | 4.9454 | 8468152.0 |
| 2008-09-22 11:10:00 | AAPL | Stock | 4.9464 | 4.9493 | 4.9296 | 4.9314 | 7902524.0 |
| 2008-09-22 11:15:00 | AAPL | Stock | 4.9314 | 4.9443 | 4.9261 | 4.9314 | 8506232.0 |
| 2008-09-22 11:20:00 | AAPL | Stock | 4.9319 | 4.9319 | 4.9089 | 4.9125 | 11077304.0 |
| 2008-09-22 11:25:00 | AAPL | Stock | 4.9125 | 4.9271 | 4.9114 | 4.9194 | 6229496.0 |
| 2008-09-22 11:30:00 | AAPL | Stock | 4.9168 | 4.9204 | 4.8857 | 4.8857 | 11736116.0 |
| 2008-09-22 11:35:00 | AAPL | Stock | 4.8854 | 4.8954 | 4.8671 | 4.8911 | 15637804.0 |
> showing 50 of 319,796 rows — these rows as CSV