PREVIEW / stock_5min / 2009-06-18
file: by_date/stock_5min/2009/2009-06-18.parquet size: 4.5 MB rows: 310,378 symbols: 3,341
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-18 07:25:00 | AAPL | Stock | 4.8454 | 4.8454 | 4.8454 | 4.8454 | 8400.0 |
| 2009-06-18 07:40:00 | AAPL | Stock | 4.8404 | 4.8404 | 4.8404 | 4.8404 | 14000.0 |
| 2009-06-18 07:45:00 | AAPL | Stock | 4.8368 | 4.8368 | 4.8368 | 4.8368 | 2800.0 |
| 2009-06-18 07:55:00 | AAPL | Stock | 4.8389 | 4.8389 | 4.8389 | 4.8389 | 28000.0 |
| 2009-06-18 08:00:00 | AAPL | Stock | 4.8393 | 4.8393 | 4.8296 | 4.8339 | 38388.0 |
| 2009-06-18 08:05:00 | AAPL | Stock | 4.8364 | 4.8364 | 4.8364 | 4.8364 | 23212.0 |
| 2009-06-18 08:10:00 | AAPL | Stock | 4.8339 | 4.8375 | 4.8339 | 4.8375 | 25200.0 |
| 2009-06-18 08:15:00 | AAPL | Stock | 4.8375 | 4.8375 | 4.8375 | 4.8375 | 5600.0 |
| 2009-06-18 08:20:00 | AAPL | Stock | 4.8321 | 4.8321 | 4.8321 | 4.8321 | 13776.0 |
| 2009-06-18 08:25:00 | AAPL | Stock | 4.8368 | 4.8368 | 4.8368 | 4.8368 | 2800.0 |
| 2009-06-18 08:30:00 | AAPL | Stock | 4.8375 | 4.8425 | 4.8375 | 4.8425 | 134148.0 |
| 2009-06-18 08:35:00 | AAPL | Stock | 4.8482 | 4.8571 | 4.8464 | 4.8571 | 54488.0 |
| 2009-06-18 08:40:00 | AAPL | Stock | 4.8568 | 4.86 | 4.8482 | 4.8582 | 96460.0 |
| 2009-06-18 08:45:00 | AAPL | Stock | 4.8582 | 4.8607 | 4.855 | 4.8607 | 84140.0 |
| 2009-06-18 08:50:00 | AAPL | Stock | 4.8611 | 4.865 | 4.8571 | 4.8643 | 112224.0 |
| 2009-06-18 08:55:00 | AAPL | Stock | 4.8596 | 4.8661 | 4.8596 | 4.8661 | 40740.0 |
| 2009-06-18 09:00:00 | AAPL | Stock | 4.8639 | 4.8643 | 4.8614 | 4.8614 | 56000.0 |
| 2009-06-18 09:05:00 | AAPL | Stock | 4.8614 | 4.8625 | 4.8614 | 4.8614 | 30296.0 |
| 2009-06-18 09:10:00 | AAPL | Stock | 4.8614 | 4.8643 | 4.8607 | 4.8643 | 93660.0 |
| 2009-06-18 09:15:00 | AAPL | Stock | 4.8639 | 4.8707 | 4.8639 | 4.8668 | 161280.0 |
| 2009-06-18 09:20:00 | AAPL | Stock | 4.8696 | 4.8729 | 4.8661 | 4.8707 | 138040.0 |
| 2009-06-18 09:25:00 | AAPL | Stock | 4.8679 | 4.8714 | 4.8564 | 4.8596 | 596260.0 |
| 2009-06-18 09:30:00 | AAPL | Stock | 4.8593 | 4.8707 | 4.8425 | 4.8518 | 15386280.0 |
| 2009-06-18 09:35:00 | AAPL | Stock | 4.8521 | 4.8654 | 4.8432 | 4.8514 | 14923580.0 |
| 2009-06-18 09:40:00 | AAPL | Stock | 4.8514 | 4.9007 | 4.8511 | 4.8986 | 20812288.0 |
| 2009-06-18 09:45:00 | AAPL | Stock | 4.8986 | 4.9196 | 4.8893 | 4.9118 | 18701172.0 |
| 2009-06-18 09:50:00 | AAPL | Stock | 4.9118 | 4.925 | 4.9018 | 4.9211 | 14406924.0 |
| 2009-06-18 09:55:00 | AAPL | Stock | 4.9211 | 4.9286 | 4.9075 | 4.9211 | 12213376.0 |
| 2009-06-18 10:00:00 | AAPL | Stock | 4.9211 | 4.9275 | 4.9136 | 4.9157 | 10243576.0 |
| 2009-06-18 10:05:00 | AAPL | Stock | 4.9161 | 4.9164 | 4.9015 | 4.9079 | 8064560.0 |
| 2009-06-18 10:10:00 | AAPL | Stock | 4.9086 | 4.9196 | 4.9007 | 4.9021 | 7160356.0 |
| 2009-06-18 10:15:00 | AAPL | Stock | 4.9025 | 4.9157 | 4.9018 | 4.9079 | 4901736.0 |
| 2009-06-18 10:20:00 | AAPL | Stock | 4.9089 | 4.9164 | 4.9057 | 4.9062 | 3321080.0 |
| 2009-06-18 10:25:00 | AAPL | Stock | 4.9061 | 4.9107 | 4.8971 | 4.8971 | 5551644.0 |
| 2009-06-18 10:30:00 | AAPL | Stock | 4.8975 | 4.9018 | 4.8861 | 4.8989 | 8042132.0 |
| 2009-06-18 10:35:00 | AAPL | Stock | 4.8989 | 4.9014 | 4.8879 | 4.8893 | 3794476.0 |
| 2009-06-18 10:40:00 | AAPL | Stock | 4.8893 | 4.8943 | 4.8829 | 4.8864 | 6087368.0 |
| 2009-06-18 10:45:00 | AAPL | Stock | 4.8861 | 4.8929 | 4.8836 | 4.8871 | 3979472.0 |
| 2009-06-18 10:50:00 | AAPL | Stock | 4.8875 | 4.897 | 4.8861 | 4.8935 | 4534180.0 |
| 2009-06-18 10:55:00 | AAPL | Stock | 4.8929 | 4.9086 | 4.8929 | 4.9047 | 4279436.0 |
| 2009-06-18 11:00:00 | AAPL | Stock | 4.9061 | 4.9107 | 4.9004 | 4.9107 | 4999680.0 |
| 2009-06-18 11:05:00 | AAPL | Stock | 4.9107 | 4.9111 | 4.9021 | 4.9039 | 2685116.0 |
| 2009-06-18 11:10:00 | AAPL | Stock | 4.9036 | 4.9046 | 4.8993 | 4.9029 | 2281720.0 |
| 2009-06-18 11:15:00 | AAPL | Stock | 4.9029 | 4.9132 | 4.9004 | 4.9107 | 3595508.0 |
| 2009-06-18 11:20:00 | AAPL | Stock | 4.9118 | 4.9125 | 4.9068 | 4.9096 | 2864260.0 |
| 2009-06-18 11:25:00 | AAPL | Stock | 4.9107 | 4.9121 | 4.9043 | 4.9061 | 2140824.0 |
| 2009-06-18 11:30:00 | AAPL | Stock | 4.9054 | 4.9068 | 4.9 | 4.9 | 2433088.0 |
| 2009-06-18 11:35:00 | AAPL | Stock | 4.9 | 4.9054 | 4.8957 | 4.9011 | 3827012.0 |
| 2009-06-18 11:40:00 | AAPL | Stock | 4.9007 | 4.9011 | 4.8961 | 4.8975 | 1968540.0 |
| 2009-06-18 11:45:00 | AAPL | Stock | 4.8979 | 4.9007 | 4.8893 | 4.8935 | 3325308.0 |
> showing 50 of 310,378 rows — these rows as CSV