PREVIEW / stock_5min / 2009-11-06
file: by_date/stock_5min/2009/2009-11-06.parquet size: 4.5 MB rows: 310,995 symbols: 3,368
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-11-06 05:15:00 | AAPL | Stock | 6.9407 | 6.9407 | 6.9407 | 6.9407 | 5600.0 |
| 2009-11-06 05:25:00 | AAPL | Stock | 6.9629 | 6.9629 | 6.9514 | 6.9514 | 5600.0 |
| 2009-11-06 07:15:00 | AAPL | Stock | 6.9393 | 6.9504 | 6.9143 | 6.9504 | 8400.0 |
| 2009-11-06 07:25:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 2800.0 |
| 2009-11-06 07:30:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 2800.0 |
| 2009-11-06 07:40:00 | AAPL | Stock | 6.9414 | 6.9414 | 6.9411 | 6.9414 | 65408.0 |
| 2009-11-06 07:45:00 | AAPL | Stock | 6.9414 | 6.9464 | 6.9414 | 6.9461 | 28000.0 |
| 2009-11-06 07:55:00 | AAPL | Stock | 6.9461 | 6.9461 | 6.9461 | 6.9461 | 5600.0 |
| 2009-11-06 08:00:00 | AAPL | Stock | 6.9464 | 6.955 | 6.9454 | 6.9518 | 189952.0 |
| 2009-11-06 08:05:00 | AAPL | Stock | 6.9564 | 6.9589 | 6.9496 | 6.95 | 306404.0 |
| 2009-11-06 08:10:00 | AAPL | Stock | 6.9482 | 6.9571 | 6.9429 | 6.945 | 203924.0 |
| 2009-11-06 08:15:00 | AAPL | Stock | 6.9496 | 6.9589 | 6.9496 | 6.9571 | 79520.0 |
| 2009-11-06 08:20:00 | AAPL | Stock | 6.9571 | 6.9607 | 6.9557 | 6.9571 | 98644.0 |
| 2009-11-06 08:25:00 | AAPL | Stock | 6.9607 | 6.9621 | 6.9464 | 6.9464 | 364784.0 |
| 2009-11-06 08:30:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.8857 | 6.8893 | 1408316.0 |
| 2009-11-06 08:35:00 | AAPL | Stock | 6.8875 | 6.9029 | 6.8729 | 6.9018 | 592508.0 |
| 2009-11-06 08:40:00 | AAPL | Stock | 6.9032 | 6.9036 | 6.8864 | 6.8875 | 691768.0 |
| 2009-11-06 08:45:00 | AAPL | Stock | 6.8879 | 6.8896 | 6.8429 | 6.8432 | 1574972.0 |
| 2009-11-06 08:50:00 | AAPL | Stock | 6.8432 | 6.8571 | 6.8393 | 6.85 | 324632.0 |
| 2009-11-06 08:55:00 | AAPL | Stock | 6.8543 | 6.8693 | 6.8511 | 6.8632 | 260176.0 |
| 2009-11-06 09:00:00 | AAPL | Stock | 6.8632 | 6.8639 | 6.8518 | 6.8521 | 463036.0 |
| 2009-11-06 09:05:00 | AAPL | Stock | 6.8536 | 6.8571 | 6.8536 | 6.8568 | 68320.0 |
| 2009-11-06 09:10:00 | AAPL | Stock | 6.8571 | 6.935 | 6.8539 | 6.8604 | 2241960.0 |
| 2009-11-06 09:15:00 | AAPL | Stock | 6.8575 | 6.8604 | 6.8554 | 6.8571 | 319956.0 |
| 2009-11-06 09:20:00 | AAPL | Stock | 6.8571 | 6.8664 | 6.8554 | 6.8661 | 202412.0 |
| 2009-11-06 09:25:00 | AAPL | Stock | 6.8679 | 6.8832 | 6.8671 | 6.8821 | 372344.0 |
| 2009-11-06 09:30:00 | AAPL | Stock | 6.8804 | 6.9179 | 6.8714 | 6.9096 | 11626272.0 |
| 2009-11-06 09:35:00 | AAPL | Stock | 6.9079 | 6.9643 | 6.9061 | 6.9571 | 16931320.0 |
| 2009-11-06 09:40:00 | AAPL | Stock | 6.9564 | 6.9711 | 6.9429 | 6.9432 | 16087624.0 |
| 2009-11-06 09:45:00 | AAPL | Stock | 6.9443 | 6.9621 | 6.9343 | 6.9418 | 10838212.0 |
| 2009-11-06 09:50:00 | AAPL | Stock | 6.9414 | 6.9496 | 6.925 | 6.9393 | 9048480.0 |
| 2009-11-06 09:55:00 | AAPL | Stock | 6.9393 | 6.9564 | 6.9364 | 6.95 | 7315168.0 |
| 2009-11-06 10:00:00 | AAPL | Stock | 6.95 | 6.9582 | 6.9321 | 6.9343 | 7136640.0 |
| 2009-11-06 10:05:00 | AAPL | Stock | 6.9346 | 6.9464 | 6.9207 | 6.9252 | 6530132.0 |
| 2009-11-06 10:10:00 | AAPL | Stock | 6.925 | 6.9346 | 6.9164 | 6.9336 | 5683188.0 |
| 2009-11-06 10:15:00 | AAPL | Stock | 6.9332 | 6.9346 | 6.9196 | 6.9239 | 2829008.0 |
| 2009-11-06 10:20:00 | AAPL | Stock | 6.9232 | 6.9246 | 6.9125 | 6.9196 | 4179504.0 |
| 2009-11-06 10:25:00 | AAPL | Stock | 6.92 | 6.92 | 6.8969 | 6.8969 | 6653556.0 |
| 2009-11-06 10:30:00 | AAPL | Stock | 6.8975 | 6.9075 | 6.8839 | 6.9075 | 9484496.0 |
| 2009-11-06 10:35:00 | AAPL | Stock | 6.9071 | 6.9132 | 6.8964 | 6.9125 | 5691084.0 |
| 2009-11-06 10:40:00 | AAPL | Stock | 6.9111 | 6.9221 | 6.9004 | 6.9004 | 5090708.0 |
| 2009-11-06 10:45:00 | AAPL | Stock | 6.9025 | 6.9175 | 6.8982 | 6.9111 | 3890516.0 |
| 2009-11-06 10:50:00 | AAPL | Stock | 6.9116 | 6.9243 | 6.905 | 6.9232 | 3967320.0 |
| 2009-11-06 10:55:00 | AAPL | Stock | 6.9229 | 6.9286 | 6.9179 | 6.9267 | 2965732.0 |
| 2009-11-06 11:00:00 | AAPL | Stock | 6.9243 | 6.9279 | 6.9179 | 6.9254 | 3305792.0 |
| 2009-11-06 11:05:00 | AAPL | Stock | 6.9254 | 6.9449 | 6.9182 | 6.9429 | 5721072.0 |
| 2009-11-06 11:10:00 | AAPL | Stock | 6.9429 | 6.9432 | 6.9296 | 6.93 | 2958536.0 |
| 2009-11-06 11:15:00 | AAPL | Stock | 6.9341 | 6.9389 | 6.9271 | 6.9357 | 2235800.0 |
| 2009-11-06 11:20:00 | AAPL | Stock | 6.9361 | 6.9361 | 6.9207 | 6.9213 | 2560964.0 |
| 2009-11-06 11:25:00 | AAPL | Stock | 6.9214 | 6.9282 | 6.9172 | 6.9279 | 1908900.0 |
> showing 50 of 310,995 rows — these rows as CSV