PREVIEW / stock_5min / 2011-03-07
file: by_date/stock_5min/2011/2011-03-07.parquet size: 5.0 MB rows: 336,140 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-07 07:00:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8929 | 12.8929 | 2800.0 |
| 2011-03-07 07:05:00 | AAPL | Stock | 12.8979 | 12.9025 | 12.8786 | 12.8964 | 18200.0 |
| 2011-03-07 07:10:00 | AAPL | Stock | 12.9146 | 12.9146 | 12.9146 | 12.9146 | 2800.0 |
| 2011-03-07 07:15:00 | AAPL | Stock | 12.9204 | 12.9214 | 12.9204 | 12.9214 | 28000.0 |
| 2011-03-07 07:20:00 | AAPL | Stock | 12.9214 | 12.9286 | 12.9107 | 12.9107 | 56000.0 |
| 2011-03-07 07:25:00 | AAPL | Stock | 12.9225 | 12.9236 | 12.9225 | 12.9232 | 19600.0 |
| 2011-03-07 07:30:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.8932 | 12.8964 | 51520.0 |
| 2011-03-07 07:35:00 | AAPL | Stock | 12.8932 | 12.8982 | 12.8929 | 12.8982 | 74200.0 |
| 2011-03-07 07:40:00 | AAPL | Stock | 12.8946 | 12.9007 | 12.8893 | 12.8893 | 39060.0 |
| 2011-03-07 07:45:00 | AAPL | Stock | 12.8893 | 12.8893 | 12.8679 | 12.8696 | 85596.0 |
| 2011-03-07 07:50:00 | AAPL | Stock | 12.87 | 12.87 | 12.8607 | 12.8607 | 74172.0 |
| 2011-03-07 07:55:00 | AAPL | Stock | 12.8607 | 12.8743 | 12.8461 | 12.8482 | 130900.0 |
| 2011-03-07 08:00:00 | AAPL | Stock | 12.8468 | 12.8571 | 12.8304 | 12.8411 | 870968.0 |
| 2011-03-07 08:05:00 | AAPL | Stock | 12.8411 | 12.8411 | 12.8304 | 12.8304 | 205688.0 |
| 2011-03-07 08:10:00 | AAPL | Stock | 12.8304 | 12.8393 | 12.8279 | 12.8393 | 163772.0 |
| 2011-03-07 08:15:00 | AAPL | Stock | 12.8429 | 12.8489 | 12.8429 | 12.8429 | 42000.0 |
| 2011-03-07 08:20:00 | AAPL | Stock | 12.8393 | 12.8393 | 12.8368 | 12.8368 | 32872.0 |
| 2011-03-07 08:25:00 | AAPL | Stock | 12.8321 | 12.8446 | 12.8321 | 12.8446 | 49168.0 |
| 2011-03-07 08:30:00 | AAPL | Stock | 12.8429 | 12.8571 | 12.8429 | 12.8464 | 37492.0 |
| 2011-03-07 08:35:00 | AAPL | Stock | 12.8454 | 12.8461 | 12.8454 | 12.8461 | 11200.0 |
| 2011-03-07 08:40:00 | AAPL | Stock | 12.8482 | 12.8571 | 12.8482 | 12.8532 | 133140.0 |
| 2011-03-07 08:45:00 | AAPL | Stock | 12.8564 | 12.8568 | 12.8518 | 12.8554 | 23240.0 |
| 2011-03-07 08:50:00 | AAPL | Stock | 12.8564 | 12.8639 | 12.8564 | 12.8614 | 82180.0 |
| 2011-03-07 08:55:00 | AAPL | Stock | 12.86 | 12.8739 | 12.8557 | 12.8696 | 164360.0 |
| 2011-03-07 09:00:00 | AAPL | Stock | 12.8696 | 12.8718 | 12.8568 | 12.8571 | 133616.0 |
| 2011-03-07 09:05:00 | AAPL | Stock | 12.8575 | 12.8689 | 12.8571 | 12.8618 | 145096.0 |
| 2011-03-07 09:10:00 | AAPL | Stock | 12.8643 | 12.8643 | 12.8518 | 12.8561 | 213724.0 |
| 2011-03-07 09:15:00 | AAPL | Stock | 12.8564 | 12.8607 | 12.8543 | 12.8607 | 112924.0 |
| 2011-03-07 09:20:00 | AAPL | Stock | 12.8579 | 12.87 | 12.8579 | 12.8696 | 163324.0 |
| 2011-03-07 09:25:00 | AAPL | Stock | 12.8689 | 12.9071 | 12.86 | 12.9064 | 1264620.0 |
| 2011-03-07 09:30:00 | AAPL | Stock | 12.9064 | 12.9168 | 12.8654 | 12.87 | 17811836.0 |
| 2011-03-07 09:35:00 | AAPL | Stock | 12.87 | 12.8889 | 12.8679 | 12.8786 | 7646772.0 |
| 2011-03-07 09:40:00 | AAPL | Stock | 12.8803 | 12.881 | 12.8261 | 12.8272 | 11097156.0 |
| 2011-03-07 09:45:00 | AAPL | Stock | 12.8301 | 12.8364 | 12.7918 | 12.8214 | 15013096.0 |
| 2011-03-07 09:50:00 | AAPL | Stock | 12.8225 | 12.8336 | 12.8039 | 12.8082 | 8372924.0 |
| 2011-03-07 09:55:00 | AAPL | Stock | 12.8079 | 12.845 | 12.8079 | 12.8325 | 6211576.0 |
| 2011-03-07 10:00:00 | AAPL | Stock | 12.8325 | 12.8464 | 12.8232 | 12.8275 | 4842460.0 |
| 2011-03-07 10:05:00 | AAPL | Stock | 12.83 | 12.8321 | 12.8057 | 12.8077 | 5529468.0 |
| 2011-03-07 10:10:00 | AAPL | Stock | 12.8075 | 12.8123 | 12.7968 | 12.8114 | 6301568.0 |
| 2011-03-07 10:15:00 | AAPL | Stock | 12.8102 | 12.8179 | 12.8007 | 12.8046 | 3391752.0 |
| 2011-03-07 10:20:00 | AAPL | Stock | 12.8071 | 12.8243 | 12.8018 | 12.8204 | 3955784.0 |
| 2011-03-07 10:25:00 | AAPL | Stock | 12.8196 | 12.8239 | 12.8061 | 12.8179 | 3137764.0 |
| 2011-03-07 10:30:00 | AAPL | Stock | 12.8179 | 12.8193 | 12.7932 | 12.8082 | 5235328.0 |
| 2011-03-07 10:35:00 | AAPL | Stock | 12.8077 | 12.81 | 12.7693 | 12.7711 | 7401044.0 |
| 2011-03-07 10:40:00 | AAPL | Stock | 12.7714 | 12.7857 | 12.7129 | 12.7146 | 14558376.0 |
| 2011-03-07 10:45:00 | AAPL | Stock | 12.7143 | 12.7271 | 12.7046 | 12.7257 | 9649416.0 |
| 2011-03-07 10:50:00 | AAPL | Stock | 12.7268 | 12.7411 | 12.7111 | 12.7136 | 9796556.0 |
| 2011-03-07 10:55:00 | AAPL | Stock | 12.7117 | 12.7511 | 12.7089 | 12.7306 | 5760076.0 |
| 2011-03-07 11:00:00 | AAPL | Stock | 12.7325 | 12.7329 | 12.6832 | 12.7025 | 12458488.0 |
| 2011-03-07 11:05:00 | AAPL | Stock | 12.6989 | 12.705 | 12.6671 | 12.7004 | 10871364.0 |
> showing 50 of 336,140 rows — these rows as CSV