PREVIEW / stock_5min / 2007-09-10
file: by_date/stock_5min/2007/2007-09-10.parquet size: 4.1 MB rows: 297,040 symbols: 3,124
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-10 09:30:00 | AAPL | Stock | 4.8927 | 4.8932 | 4.8536 | 4.8557 | 55891332.0 |
| 2007-09-10 09:35:00 | AAPL | Stock | 4.8557 | 4.8611 | 4.8375 | 4.8457 | 44775332.0 |
| 2007-09-10 09:40:00 | AAPL | Stock | 4.8468 | 4.8571 | 4.8329 | 4.8479 | 27530888.0 |
| 2007-09-10 09:45:00 | AAPL | Stock | 4.8479 | 4.8547 | 4.8361 | 4.8518 | 33147324.0 |
| 2007-09-10 09:50:00 | AAPL | Stock | 4.8521 | 4.8607 | 4.8264 | 4.8271 | 33613776.0 |
| 2007-09-10 09:55:00 | AAPL | Stock | 4.8271 | 4.8324 | 4.8111 | 4.8118 | 29222228.0 |
| 2007-09-10 10:00:00 | AAPL | Stock | 4.8118 | 4.8204 | 4.7893 | 4.7943 | 33447848.0 |
| 2007-09-10 10:05:00 | AAPL | Stock | 4.7939 | 4.8229 | 4.7925 | 4.8118 | 29487332.0 |
| 2007-09-10 10:10:00 | AAPL | Stock | 4.8114 | 4.8161 | 4.7911 | 4.8032 | 19655888.0 |
| 2007-09-10 10:15:00 | AAPL | Stock | 4.8029 | 4.8132 | 4.7839 | 4.8079 | 21824208.0 |
| 2007-09-10 10:20:00 | AAPL | Stock | 4.8082 | 4.8332 | 4.8071 | 4.8311 | 25095196.0 |
| 2007-09-10 10:25:00 | AAPL | Stock | 4.8321 | 4.8339 | 4.8089 | 4.8121 | 20721680.0 |
| 2007-09-10 10:30:00 | AAPL | Stock | 4.8118 | 4.8204 | 4.8036 | 4.8196 | 17111024.0 |
| 2007-09-10 10:35:00 | AAPL | Stock | 4.8182 | 4.8254 | 4.805 | 4.818 | 17193680.0 |
| 2007-09-10 10:40:00 | AAPL | Stock | 4.8196 | 4.8329 | 4.8082 | 4.8143 | 17732260.0 |
| 2007-09-10 10:45:00 | AAPL | Stock | 4.8157 | 4.8214 | 4.8054 | 4.8136 | 13475000.0 |
| 2007-09-10 10:50:00 | AAPL | Stock | 4.8139 | 4.8179 | 4.7996 | 4.8021 | 16486316.0 |
| 2007-09-10 10:55:00 | AAPL | Stock | 4.8032 | 4.8229 | 4.7989 | 4.82 | 14005376.0 |
| 2007-09-10 11:00:00 | AAPL | Stock | 4.8207 | 4.8282 | 4.8161 | 4.8257 | 12472208.0 |
| 2007-09-10 11:05:00 | AAPL | Stock | 4.8261 | 4.8314 | 4.8125 | 4.8136 | 16516612.0 |
| 2007-09-10 11:10:00 | AAPL | Stock | 4.8129 | 4.8175 | 4.795 | 4.7982 | 21930440.0 |
| 2007-09-10 11:15:00 | AAPL | Stock | 4.7986 | 4.8089 | 4.7961 | 4.8007 | 15252216.0 |
| 2007-09-10 11:20:00 | AAPL | Stock | 4.8007 | 4.8093 | 4.7983 | 4.8043 | 12607364.0 |
| 2007-09-10 11:25:00 | AAPL | Stock | 4.8043 | 4.8082 | 4.8 | 4.8039 | 9214744.0 |
| 2007-09-10 11:30:00 | AAPL | Stock | 4.805 | 4.8057 | 4.7911 | 4.8 | 13291712.0 |
| 2007-09-10 11:35:00 | AAPL | Stock | 4.7982 | 4.8157 | 4.7932 | 4.8136 | 15833076.0 |
| 2007-09-10 11:40:00 | AAPL | Stock | 4.8136 | 4.8186 | 4.8096 | 4.8147 | 14069748.0 |
| 2007-09-10 11:45:00 | AAPL | Stock | 4.8143 | 4.8204 | 4.8101 | 4.8189 | 9939692.0 |
| 2007-09-10 11:50:00 | AAPL | Stock | 4.8186 | 4.8246 | 4.815 | 4.8189 | 8754256.0 |
| 2007-09-10 11:55:00 | AAPL | Stock | 4.8193 | 4.8264 | 4.8171 | 4.8261 | 9759092.0 |
| 2007-09-10 12:00:00 | AAPL | Stock | 4.8257 | 4.8371 | 4.825 | 4.8364 | 15150884.0 |
| 2007-09-10 12:05:00 | AAPL | Stock | 4.8364 | 4.8371 | 4.8284 | 4.8311 | 10669596.0 |
| 2007-09-10 12:10:00 | AAPL | Stock | 4.8307 | 4.8314 | 4.7957 | 4.8261 | 10193260.0 |
| 2007-09-10 12:15:00 | AAPL | Stock | 4.8261 | 4.8304 | 4.8218 | 4.8257 | 5547388.0 |
| 2007-09-10 12:20:00 | AAPL | Stock | 4.8257 | 4.8514 | 4.8256 | 4.8496 | 13865180.0 |
| 2007-09-10 12:25:00 | AAPL | Stock | 4.8489 | 4.8536 | 4.8441 | 4.8454 | 10655736.0 |
| 2007-09-10 12:30:00 | AAPL | Stock | 4.8461 | 4.8496 | 4.8396 | 4.8436 | 8863568.0 |
| 2007-09-10 12:35:00 | AAPL | Stock | 4.8429 | 4.8457 | 4.8307 | 4.8317 | 8778476.0 |
| 2007-09-10 12:40:00 | AAPL | Stock | 4.8318 | 4.8321 | 4.8186 | 4.8211 | 9753156.0 |
| 2007-09-10 12:45:00 | AAPL | Stock | 4.8211 | 4.8239 | 4.8161 | 4.82 | 8487724.0 |
| 2007-09-10 12:50:00 | AAPL | Stock | 4.8207 | 4.8225 | 4.8125 | 4.8182 | 9325148.0 |
| 2007-09-10 12:55:00 | AAPL | Stock | 4.8182 | 4.8257 | 4.8157 | 4.8175 | 9167200.0 |
| 2007-09-10 13:00:00 | AAPL | Stock | 4.8168 | 4.82 | 4.8129 | 4.8132 | 9269904.0 |
| 2007-09-10 13:05:00 | AAPL | Stock | 4.8136 | 4.8156 | 4.806 | 4.8132 | 9998408.0 |
| 2007-09-10 13:10:00 | AAPL | Stock | 4.8136 | 4.8279 | 4.81 | 4.8264 | 9685816.0 |
| 2007-09-10 13:15:00 | AAPL | Stock | 4.8268 | 4.8339 | 4.8239 | 4.8331 | 10244500.0 |
| 2007-09-10 13:20:00 | AAPL | Stock | 4.8325 | 4.8339 | 4.8268 | 4.8271 | 9028068.0 |
| 2007-09-10 13:25:00 | AAPL | Stock | 4.8271 | 4.8364 | 4.8257 | 4.8357 | 7662704.0 |
| 2007-09-10 13:30:00 | AAPL | Stock | 4.8357 | 4.8457 | 4.8336 | 4.8446 | 10388616.0 |
| 2007-09-10 13:35:00 | AAPL | Stock | 4.8443 | 4.8454 | 4.8354 | 4.8361 | 8588804.0 |
> showing 50 of 297,040 rows — these rows as CSV