PREVIEW / stock_5min / 2009-08-27
file: by_date/stock_5min/2009/2009-08-27.parquet size: 4.5 MB rows: 309,477 symbols: 3,356
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-08-27 06:45:00 | AAPL | Stock | 5.9993 | 5.9993 | 5.9993 | 5.9993 | 2800.0 |
| 2009-08-27 07:20:00 | AAPL | Stock | 5.9961 | 6.0007 | 5.9929 | 6.0007 | 25928.0 |
| 2009-08-27 07:25:00 | AAPL | Stock | 6.0036 | 6.0036 | 6.0036 | 6.0036 | 2800.0 |
| 2009-08-27 07:30:00 | AAPL | Stock | 6.0082 | 6.0082 | 6.0082 | 6.0082 | 2800.0 |
| 2009-08-27 07:35:00 | AAPL | Stock | 6.0071 | 6.0071 | 6.0071 | 6.0071 | 11200.0 |
| 2009-08-27 07:40:00 | AAPL | Stock | 6.0071 | 6.0125 | 6.0 | 6.0 | 57400.0 |
| 2009-08-27 07:45:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0004 | 6.0004 | 14000.0 |
| 2009-08-27 07:55:00 | AAPL | Stock | 6.0057 | 6.0057 | 6.0036 | 6.0036 | 23800.0 |
| 2009-08-27 08:00:00 | AAPL | Stock | 6.005 | 6.0089 | 6.0 | 6.005 | 155680.0 |
| 2009-08-27 08:05:00 | AAPL | Stock | 6.005 | 6.0243 | 6.005 | 6.0243 | 108108.0 |
| 2009-08-27 08:10:00 | AAPL | Stock | 6.0246 | 6.0264 | 6.02 | 6.0261 | 140000.0 |
| 2009-08-27 08:15:00 | AAPL | Stock | 6.0261 | 6.0268 | 6.0236 | 6.0236 | 104972.0 |
| 2009-08-27 08:20:00 | AAPL | Stock | 6.0264 | 6.0264 | 6.0232 | 6.0232 | 68600.0 |
| 2009-08-27 08:25:00 | AAPL | Stock | 6.0257 | 6.0268 | 6.0236 | 6.025 | 67648.0 |
| 2009-08-27 08:30:00 | AAPL | Stock | 6.0232 | 6.025 | 6.0182 | 6.0246 | 140784.0 |
| 2009-08-27 08:35:00 | AAPL | Stock | 6.0236 | 6.0261 | 6.02 | 6.025 | 93240.0 |
| 2009-08-27 08:40:00 | AAPL | Stock | 6.0261 | 6.0411 | 6.0261 | 6.0411 | 706944.0 |
| 2009-08-27 08:45:00 | AAPL | Stock | 6.0411 | 6.0411 | 6.0371 | 6.0411 | 114100.0 |
| 2009-08-27 08:50:00 | AAPL | Stock | 6.0375 | 6.0411 | 6.0357 | 6.0357 | 160664.0 |
| 2009-08-27 08:55:00 | AAPL | Stock | 6.0357 | 6.0371 | 6.0357 | 6.0371 | 84112.0 |
| 2009-08-27 09:00:00 | AAPL | Stock | 6.0375 | 6.0389 | 6.0357 | 6.0357 | 83188.0 |
| 2009-08-27 09:05:00 | AAPL | Stock | 6.0357 | 6.0368 | 6.0221 | 6.0268 | 209636.0 |
| 2009-08-27 09:10:00 | AAPL | Stock | 6.0268 | 6.0289 | 6.0207 | 6.0207 | 181272.0 |
| 2009-08-27 09:15:00 | AAPL | Stock | 6.0196 | 6.0243 | 6.0175 | 6.0182 | 92400.0 |
| 2009-08-27 09:20:00 | AAPL | Stock | 6.0182 | 6.0204 | 6.0132 | 6.0175 | 58324.0 |
| 2009-08-27 09:25:00 | AAPL | Stock | 6.0225 | 6.0268 | 6.0193 | 6.025 | 128072.0 |
| 2009-08-27 09:30:00 | AAPL | Stock | 6.0261 | 6.0286 | 5.9643 | 5.9654 | 10985324.0 |
| 2009-08-27 09:35:00 | AAPL | Stock | 5.9654 | 5.975 | 5.9507 | 5.9657 | 11439064.0 |
| 2009-08-27 09:40:00 | AAPL | Stock | 5.9654 | 5.9696 | 5.9464 | 5.9621 | 10601808.0 |
| 2009-08-27 09:45:00 | AAPL | Stock | 5.9616 | 5.9968 | 5.9489 | 5.9886 | 15527680.0 |
| 2009-08-27 09:50:00 | AAPL | Stock | 5.9886 | 5.9896 | 5.95 | 5.9542 | 11177236.0 |
| 2009-08-27 09:55:00 | AAPL | Stock | 5.9543 | 5.9582 | 5.9268 | 5.9289 | 10530016.0 |
| 2009-08-27 10:00:00 | AAPL | Stock | 5.9282 | 5.9282 | 5.8936 | 5.8946 | 15067472.0 |
| 2009-08-27 10:05:00 | AAPL | Stock | 5.8936 | 5.9071 | 5.8868 | 5.8986 | 11764060.0 |
| 2009-08-27 10:10:00 | AAPL | Stock | 5.8989 | 5.9204 | 5.8964 | 5.915 | 8871128.0 |
| 2009-08-27 10:15:00 | AAPL | Stock | 5.915 | 5.92 | 5.9064 | 5.9075 | 5325152.0 |
| 2009-08-27 10:20:00 | AAPL | Stock | 5.91 | 5.9136 | 5.9014 | 5.9129 | 6863080.0 |
| 2009-08-27 10:25:00 | AAPL | Stock | 5.9132 | 5.9136 | 5.9043 | 5.9118 | 4367160.0 |
| 2009-08-27 10:30:00 | AAPL | Stock | 5.9129 | 5.9207 | 5.9111 | 5.9158 | 4992064.0 |
| 2009-08-27 10:35:00 | AAPL | Stock | 5.9154 | 5.9168 | 5.8986 | 5.9043 | 7341376.0 |
| 2009-08-27 10:40:00 | AAPL | Stock | 5.9043 | 5.9104 | 5.8993 | 5.9079 | 4289432.0 |
| 2009-08-27 10:45:00 | AAPL | Stock | 5.9064 | 5.9082 | 5.9036 | 5.9064 | 2195984.0 |
| 2009-08-27 10:50:00 | AAPL | Stock | 5.9064 | 5.9096 | 5.9025 | 5.9079 | 2301376.0 |
| 2009-08-27 10:55:00 | AAPL | Stock | 5.9081 | 5.9125 | 5.905 | 5.9057 | 2774352.0 |
| 2009-08-27 11:00:00 | AAPL | Stock | 5.9054 | 5.9057 | 5.8971 | 5.9039 | 6230224.0 |
| 2009-08-27 11:05:00 | AAPL | Stock | 5.9036 | 5.9196 | 5.9032 | 5.9161 | 3519740.0 |
| 2009-08-27 11:10:00 | AAPL | Stock | 5.9163 | 5.9239 | 5.9139 | 5.9239 | 2873444.0 |
| 2009-08-27 11:15:00 | AAPL | Stock | 5.9238 | 5.9286 | 5.9175 | 5.9221 | 4392640.0 |
| 2009-08-27 11:20:00 | AAPL | Stock | 5.9221 | 5.9239 | 5.9179 | 5.9225 | 2637068.0 |
| 2009-08-27 11:25:00 | AAPL | Stock | 5.9225 | 5.9404 | 5.9225 | 5.9393 | 5169752.0 |
> showing 50 of 309,477 rows — these rows as CSV