PREVIEW / stock_5min / 2009-11-05
file: by_date/stock_5min/2009/2009-11-05.parquet size: 4.7 MB rows: 325,124 symbols: 3,399
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-05 04:35:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 2800.0 |
| 2009-11-05 06:00:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 2800.0 |
| 2009-11-05 06:50:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 4396.0 |
| 2009-11-05 07:40:00 | AAPL | Stock | 6.8339 | 6.8339 | 6.8229 | 6.8229 | 14000.0 |
| 2009-11-05 08:00:00 | AAPL | Stock | 6.8339 | 6.8632 | 6.8339 | 6.8632 | 194572.0 |
| 2009-11-05 08:05:00 | AAPL | Stock | 6.8575 | 6.8643 | 6.8564 | 6.8564 | 84336.0 |
| 2009-11-05 08:10:00 | AAPL | Stock | 6.8571 | 6.8607 | 6.8571 | 6.8571 | 91672.0 |
| 2009-11-05 08:15:00 | AAPL | Stock | 6.86 | 6.86 | 6.8571 | 6.8571 | 66780.0 |
| 2009-11-05 08:20:00 | AAPL | Stock | 6.8571 | 6.8604 | 6.8525 | 6.8589 | 68068.0 |
| 2009-11-05 08:25:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8461 | 6.85 | 40740.0 |
| 2009-11-05 08:30:00 | AAPL | Stock | 6.8464 | 6.8571 | 6.8464 | 6.8518 | 110236.0 |
| 2009-11-05 08:35:00 | AAPL | Stock | 6.8557 | 6.8639 | 6.8557 | 6.8632 | 133224.0 |
| 2009-11-05 08:40:00 | AAPL | Stock | 6.8621 | 6.875 | 6.8621 | 6.8693 | 348964.0 |
| 2009-11-05 08:45:00 | AAPL | Stock | 6.8679 | 6.8714 | 6.8661 | 6.8714 | 206276.0 |
| 2009-11-05 08:50:00 | AAPL | Stock | 6.8711 | 6.8714 | 6.8611 | 6.865 | 179228.0 |
| 2009-11-05 08:55:00 | AAPL | Stock | 6.8643 | 6.8661 | 6.8586 | 6.8596 | 79492.0 |
| 2009-11-05 09:00:00 | AAPL | Stock | 6.8596 | 6.8664 | 6.8575 | 6.8664 | 448560.0 |
| 2009-11-05 09:05:00 | AAPL | Stock | 6.8657 | 6.8686 | 6.8618 | 6.8671 | 125300.0 |
| 2009-11-05 09:10:00 | AAPL | Stock | 6.8661 | 6.8714 | 6.8146 | 6.8643 | 195356.0 |
| 2009-11-05 09:15:00 | AAPL | Stock | 6.8629 | 6.8643 | 6.8582 | 6.8582 | 84980.0 |
| 2009-11-05 09:20:00 | AAPL | Stock | 6.8593 | 6.8593 | 6.8518 | 6.8564 | 86240.0 |
| 2009-11-05 09:25:00 | AAPL | Stock | 6.8564 | 6.8839 | 6.8518 | 6.87 | 830760.0 |
| 2009-11-05 09:30:00 | AAPL | Stock | 6.8704 | 6.8896 | 6.8662 | 6.8829 | 15202740.0 |
| 2009-11-05 09:35:00 | AAPL | Stock | 6.8829 | 6.9054 | 6.8696 | 6.8811 | 11396840.0 |
| 2009-11-05 09:40:00 | AAPL | Stock | 6.8796 | 6.8811 | 6.8507 | 6.8607 | 9924488.0 |
| 2009-11-05 09:45:00 | AAPL | Stock | 6.8607 | 6.9054 | 6.8607 | 6.9004 | 11085116.0 |
| 2009-11-05 09:50:00 | AAPL | Stock | 6.9004 | 6.9071 | 6.8861 | 6.8968 | 10248196.0 |
| 2009-11-05 09:55:00 | AAPL | Stock | 6.895 | 6.9046 | 6.8871 | 6.9036 | 4854276.0 |
| 2009-11-05 10:00:00 | AAPL | Stock | 6.9039 | 6.9093 | 6.8943 | 6.9064 | 8875720.0 |
| 2009-11-05 10:05:00 | AAPL | Stock | 6.9046 | 6.9211 | 6.9004 | 6.9164 | 8532776.0 |
| 2009-11-05 10:10:00 | AAPL | Stock | 6.9186 | 6.9286 | 6.9114 | 6.92 | 6765052.0 |
| 2009-11-05 10:15:00 | AAPL | Stock | 6.9204 | 6.9243 | 6.9114 | 6.9211 | 5148080.0 |
| 2009-11-05 10:20:00 | AAPL | Stock | 6.9211 | 6.9454 | 6.9186 | 6.9432 | 9823520.0 |
| 2009-11-05 10:25:00 | AAPL | Stock | 6.9432 | 6.95 | 6.9382 | 6.94 | 10004680.0 |
| 2009-11-05 10:30:00 | AAPL | Stock | 6.9404 | 6.9482 | 6.9357 | 6.9443 | 5843684.0 |
| 2009-11-05 10:35:00 | AAPL | Stock | 6.9443 | 6.9643 | 6.94 | 6.9599 | 10063872.0 |
| 2009-11-05 10:40:00 | AAPL | Stock | 6.9596 | 6.9604 | 6.9489 | 6.9554 | 5467924.0 |
| 2009-11-05 10:45:00 | AAPL | Stock | 6.9543 | 6.9643 | 6.9486 | 6.949 | 7739368.0 |
| 2009-11-05 10:50:00 | AAPL | Stock | 6.9489 | 6.9518 | 6.9375 | 6.9464 | 5868828.0 |
| 2009-11-05 10:55:00 | AAPL | Stock | 6.9464 | 6.9546 | 6.9425 | 6.9457 | 3122196.0 |
| 2009-11-05 11:00:00 | AAPL | Stock | 6.9464 | 6.9536 | 6.9439 | 6.9489 | 3245172.0 |
| 2009-11-05 11:05:00 | AAPL | Stock | 6.9489 | 6.9525 | 6.9432 | 6.9476 | 2776452.0 |
| 2009-11-05 11:10:00 | AAPL | Stock | 6.9464 | 6.9529 | 6.9407 | 6.9521 | 3039960.0 |
| 2009-11-05 11:15:00 | AAPL | Stock | 6.9516 | 6.9532 | 6.9379 | 6.9397 | 3886484.0 |
| 2009-11-05 11:20:00 | AAPL | Stock | 6.9396 | 6.9464 | 6.93 | 6.9339 | 4412828.0 |
| 2009-11-05 11:25:00 | AAPL | Stock | 6.9338 | 6.9339 | 6.9221 | 6.9236 | 4999904.0 |
| 2009-11-05 11:30:00 | AAPL | Stock | 6.9254 | 6.9279 | 6.9211 | 6.925 | 3696896.0 |
| 2009-11-05 11:35:00 | AAPL | Stock | 6.9248 | 6.9354 | 6.9218 | 6.9339 | 2486008.0 |
| 2009-11-05 11:40:00 | AAPL | Stock | 6.9332 | 6.9379 | 6.9318 | 6.935 | 3806600.0 |
| 2009-11-05 11:45:00 | AAPL | Stock | 6.9343 | 6.9364 | 6.9182 | 6.92 | 3731280.0 |
> showing 50 of 325,124 rows — these rows as CSV