PREVIEW / stock_5min / 2009-08-12
file: by_date/stock_5min/2009/2009-08-12.parquet size: 4.6 MB rows: 320,260 symbols: 3,373
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-12 06:10:00 | AAPL | Stock | 5.8093 | 5.8107 | 5.8093 | 5.8107 | 22400.0 |
| 2009-08-12 07:00:00 | AAPL | Stock | 5.8214 | 5.8282 | 5.8214 | 5.8282 | 7000.0 |
| 2009-08-12 08:00:00 | AAPL | Stock | 5.8189 | 5.8214 | 5.8071 | 5.8143 | 126980.0 |
| 2009-08-12 08:05:00 | AAPL | Stock | 5.8086 | 5.8086 | 5.8075 | 5.8082 | 15288.0 |
| 2009-08-12 08:10:00 | AAPL | Stock | 5.8082 | 5.8082 | 5.8079 | 5.8079 | 14000.0 |
| 2009-08-12 08:15:00 | AAPL | Stock | 5.8143 | 5.8204 | 5.8143 | 5.8204 | 14784.0 |
| 2009-08-12 08:20:00 | AAPL | Stock | 5.8204 | 5.8204 | 5.82 | 5.82 | 25564.0 |
| 2009-08-12 08:25:00 | AAPL | Stock | 5.8211 | 5.8214 | 5.8211 | 5.8214 | 15120.0 |
| 2009-08-12 08:30:00 | AAPL | Stock | 5.8107 | 5.8125 | 5.8071 | 5.8079 | 89124.0 |
| 2009-08-12 08:35:00 | AAPL | Stock | 5.8068 | 5.8079 | 5.8036 | 5.8054 | 210644.0 |
| 2009-08-12 08:40:00 | AAPL | Stock | 5.8043 | 5.8054 | 5.8043 | 5.8054 | 25200.0 |
| 2009-08-12 08:45:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8061 | 5.8061 | 8400.0 |
| 2009-08-12 08:50:00 | AAPL | Stock | 5.805 | 5.8054 | 5.8036 | 5.8036 | 66556.0 |
| 2009-08-12 08:55:00 | AAPL | Stock | 5.8011 | 5.8011 | 5.8 | 5.8 | 22400.0 |
| 2009-08-12 09:00:00 | AAPL | Stock | 5.7986 | 5.8018 | 5.7986 | 5.8018 | 51520.0 |
| 2009-08-12 09:05:00 | AAPL | Stock | 5.8032 | 5.8125 | 5.8032 | 5.8096 | 41076.0 |
| 2009-08-12 09:10:00 | AAPL | Stock | 5.8032 | 5.8032 | 5.8032 | 5.8032 | 5516.0 |
| 2009-08-12 09:20:00 | AAPL | Stock | 5.8121 | 5.8121 | 5.8079 | 5.8079 | 37548.0 |
| 2009-08-12 09:25:00 | AAPL | Stock | 5.8061 | 5.8064 | 5.8029 | 5.8029 | 50988.0 |
| 2009-08-12 09:30:00 | AAPL | Stock | 5.8054 | 5.8386 | 5.8021 | 5.8346 | 10440192.0 |
| 2009-08-12 09:35:00 | AAPL | Stock | 5.8343 | 5.85 | 5.8339 | 5.8379 | 10747016.0 |
| 2009-08-12 09:40:00 | AAPL | Stock | 5.8379 | 5.8493 | 5.8311 | 5.8489 | 5892936.0 |
| 2009-08-12 09:45:00 | AAPL | Stock | 5.8486 | 5.87 | 5.8486 | 5.8589 | 11150860.0 |
| 2009-08-12 09:50:00 | AAPL | Stock | 5.8582 | 5.8911 | 5.8518 | 5.8779 | 12846484.0 |
| 2009-08-12 09:55:00 | AAPL | Stock | 5.8782 | 5.895 | 5.875 | 5.8932 | 10692108.0 |
| 2009-08-12 10:00:00 | AAPL | Stock | 5.8936 | 5.9043 | 5.8911 | 5.9007 | 13816460.0 |
| 2009-08-12 10:05:00 | AAPL | Stock | 5.9007 | 5.9096 | 5.8911 | 5.8954 | 7713664.0 |
| 2009-08-12 10:10:00 | AAPL | Stock | 5.8957 | 5.8957 | 5.8868 | 5.8921 | 5241292.0 |
| 2009-08-12 10:15:00 | AAPL | Stock | 5.8921 | 5.9036 | 5.8921 | 5.8993 | 5322072.0 |
| 2009-08-12 10:20:00 | AAPL | Stock | 5.8996 | 5.9139 | 5.8939 | 5.9107 | 7384776.0 |
| 2009-08-12 10:25:00 | AAPL | Stock | 5.9104 | 5.9143 | 5.9007 | 5.9079 | 6144684.0 |
| 2009-08-12 10:30:00 | AAPL | Stock | 5.9064 | 5.9096 | 5.9004 | 5.9089 | 4948636.0 |
| 2009-08-12 10:35:00 | AAPL | Stock | 5.9086 | 5.91 | 5.8964 | 5.9008 | 4759160.0 |
| 2009-08-12 10:40:00 | AAPL | Stock | 5.9007 | 5.9089 | 5.8964 | 5.9085 | 3734752.0 |
| 2009-08-12 10:45:00 | AAPL | Stock | 5.9086 | 5.9121 | 5.9064 | 5.9082 | 4598104.0 |
| 2009-08-12 10:50:00 | AAPL | Stock | 5.9082 | 5.9121 | 5.9054 | 5.9096 | 3340848.0 |
| 2009-08-12 10:55:00 | AAPL | Stock | 5.9093 | 5.9171 | 5.904 | 5.9164 | 4481456.0 |
| 2009-08-12 11:00:00 | AAPL | Stock | 5.9164 | 5.9214 | 5.9136 | 5.9157 | 4351424.0 |
| 2009-08-12 11:05:00 | AAPL | Stock | 5.9157 | 5.9239 | 5.9107 | 5.9225 | 4990804.0 |
| 2009-08-12 11:10:00 | AAPL | Stock | 5.9218 | 5.9286 | 5.9204 | 5.9218 | 5617724.0 |
| 2009-08-12 11:15:00 | AAPL | Stock | 5.9218 | 5.9271 | 5.9211 | 5.9264 | 3986752.0 |
| 2009-08-12 11:20:00 | AAPL | Stock | 5.9261 | 5.9279 | 5.9186 | 5.9214 | 3855068.0 |
| 2009-08-12 11:25:00 | AAPL | Stock | 5.9214 | 5.925 | 5.9193 | 5.9239 | 2655548.0 |
| 2009-08-12 11:30:00 | AAPL | Stock | 5.9246 | 5.925 | 5.9211 | 5.9239 | 2558668.0 |
| 2009-08-12 11:35:00 | AAPL | Stock | 5.9225 | 5.9286 | 5.9218 | 5.9282 | 3900344.0 |
| 2009-08-12 11:40:00 | AAPL | Stock | 5.9282 | 5.93 | 5.9168 | 5.9182 | 4525836.0 |
| 2009-08-12 11:45:00 | AAPL | Stock | 5.9179 | 5.9207 | 5.9129 | 5.9182 | 4245556.0 |
| 2009-08-12 11:50:00 | AAPL | Stock | 5.9189 | 5.9225 | 5.9164 | 5.9171 | 2537556.0 |
| 2009-08-12 11:55:00 | AAPL | Stock | 5.9168 | 5.9186 | 5.9107 | 5.9157 | 3474380.0 |
| 2009-08-12 12:00:00 | AAPL | Stock | 5.9157 | 5.9232 | 5.9143 | 5.9211 | 2362528.0 |
> showing 50 of 320,260 rows — these rows as CSV