PREVIEW / stock_1min / 2008-01-23
file: by_date/stock_1min/2008/2008-01-23.parquet size: 14.7 MB rows: 1,143,027 symbols: 2,662
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-01-23 04:15:00 | AAPL | Stock | 5.0121 | 5.0121 | 5.0104 | 5.0104 | 11816.0 |
| 2008-01-23 04:32:00 | AAPL | Stock | 4.9964 | 4.9964 | 4.9964 | 4.9964 | 8400.0 |
| 2008-01-23 05:07:00 | AAPL | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 5600.0 |
| 2008-01-23 05:09:00 | AAPL | Stock | 5.0154 | 5.0189 | 5.0154 | 5.0189 | 8400.0 |
| 2008-01-23 05:12:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0196 | 5.0196 | 2800.0 |
| 2008-01-23 05:13:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0196 | 5.0196 | 16800.0 |
| 2008-01-23 05:15:00 | AAPL | Stock | 5.0264 | 5.0264 | 5.0264 | 5.0264 | 3360.0 |
| 2008-01-23 05:18:00 | AAPL | Stock | 5.0196 | 5.0214 | 5.0196 | 5.0196 | 28560.0 |
| 2008-01-23 05:22:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0196 | 5.0196 | 28000.0 |
| 2008-01-23 05:56:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0143 | 5.0143 | 5600.0 |
| 2008-01-23 05:57:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0143 | 5.0143 | 2800.0 |
| 2008-01-23 06:12:00 | AAPL | Stock | 4.9929 | 4.9929 | 4.9911 | 4.9911 | 14000.0 |
| 2008-01-23 06:13:00 | AAPL | Stock | 4.9911 | 4.9911 | 4.9896 | 4.9896 | 5600.0 |
| 2008-01-23 06:14:00 | AAPL | Stock | 4.9896 | 4.9896 | 4.9896 | 4.9896 | 11200.0 |
| 2008-01-23 06:15:00 | AAPL | Stock | 4.9896 | 4.9904 | 4.9825 | 4.9825 | 14000.0 |
| 2008-01-23 06:17:00 | AAPL | Stock | 4.9682 | 4.9682 | 4.9646 | 4.9646 | 67564.0 |
| 2008-01-23 06:18:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9643 | 4.9643 | 25200.0 |
| 2008-01-23 06:20:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9643 | 4.9643 | 5600.0 |
| 2008-01-23 06:21:00 | AAPL | Stock | 4.9739 | 4.9739 | 4.9739 | 4.9739 | 5600.0 |
| 2008-01-23 06:29:00 | AAPL | Stock | 4.9657 | 4.9657 | 4.9646 | 4.9646 | 56000.0 |
| 2008-01-23 06:32:00 | AAPL | Stock | 4.9714 | 4.9714 | 4.9714 | 4.9714 | 2800.0 |
| 2008-01-23 06:33:00 | AAPL | Stock | 4.9714 | 4.9714 | 4.9714 | 4.9714 | 5600.0 |
| 2008-01-23 06:34:00 | AAPL | Stock | 4.9646 | 4.9646 | 4.9646 | 4.9646 | 16800.0 |
| 2008-01-23 06:35:00 | AAPL | Stock | 4.955 | 4.955 | 4.955 | 4.955 | 16800.0 |
| 2008-01-23 06:44:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9643 | 4.9643 | 128800.0 |
| 2008-01-23 06:46:00 | AAPL | Stock | 4.9643 | 4.9761 | 4.9643 | 4.9761 | 112000.0 |
| 2008-01-23 06:50:00 | AAPL | Stock | 4.9679 | 4.9682 | 4.9679 | 4.9682 | 8400.0 |
| 2008-01-23 06:59:00 | AAPL | Stock | 4.9818 | 4.9818 | 4.9818 | 4.9818 | 8400.0 |
| 2008-01-23 07:00:00 | AAPL | Stock | 4.9818 | 4.9821 | 4.9818 | 4.9821 | 84000.0 |
| 2008-01-23 07:02:00 | AAPL | Stock | 4.9704 | 4.9704 | 4.9696 | 4.9696 | 70000.0 |
| 2008-01-23 07:03:00 | AAPL | Stock | 4.9686 | 4.9686 | 4.9643 | 4.9643 | 236040.0 |
| 2008-01-23 07:04:00 | AAPL | Stock | 4.9643 | 4.9696 | 4.9643 | 4.9664 | 19600.0 |
| 2008-01-23 07:06:00 | AAPL | Stock | 4.9661 | 4.9661 | 4.9643 | 4.9643 | 89712.0 |
| 2008-01-23 07:07:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9643 | 4.9643 | 2800.0 |
| 2008-01-23 07:08:00 | AAPL | Stock | 4.9714 | 4.9768 | 4.9714 | 4.9768 | 5600.0 |
| 2008-01-23 07:09:00 | AAPL | Stock | 4.9796 | 4.9814 | 4.9796 | 4.9814 | 25200.0 |
| 2008-01-23 07:17:00 | AAPL | Stock | 4.9857 | 4.9857 | 4.9839 | 4.9839 | 5600.0 |
| 2008-01-23 07:18:00 | AAPL | Stock | 4.9839 | 4.9975 | 4.9839 | 4.9975 | 22400.0 |
| 2008-01-23 07:19:00 | AAPL | Stock | 4.9975 | 5.0007 | 4.9939 | 4.9993 | 91840.0 |
| 2008-01-23 07:20:00 | AAPL | Stock | 4.9979 | 5.0196 | 4.9979 | 5.0196 | 84560.0 |
| 2008-01-23 07:21:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0125 | 5.0168 | 49140.0 |
| 2008-01-23 07:22:00 | AAPL | Stock | 5.0021 | 5.0157 | 5.0021 | 5.0157 | 19600.0 |
| 2008-01-23 07:23:00 | AAPL | Stock | 5.0157 | 5.0157 | 5.0157 | 5.0157 | 2800.0 |
| 2008-01-23 07:24:00 | AAPL | Stock | 5.0061 | 5.0179 | 5.0061 | 5.0179 | 58800.0 |
| 2008-01-23 07:25:00 | AAPL | Stock | 5.0179 | 5.0268 | 5.0179 | 5.0182 | 25200.0 |
| 2008-01-23 07:26:00 | AAPL | Stock | 5.0182 | 5.025 | 5.0179 | 5.025 | 30800.0 |
| 2008-01-23 07:27:00 | AAPL | Stock | 5.0261 | 5.0261 | 5.0261 | 5.0261 | 28000.0 |
| 2008-01-23 07:28:00 | AAPL | Stock | 5.0257 | 5.0371 | 5.025 | 5.0371 | 81200.0 |
| 2008-01-23 07:29:00 | AAPL | Stock | 5.0364 | 5.0393 | 5.0357 | 5.0357 | 84560.0 |
| 2008-01-23 07:30:00 | AAPL | Stock | 5.0364 | 5.0429 | 5.0357 | 5.0429 | 109620.0 |
> showing 50 of 1,143,027 rows — these rows as CSV