PREVIEW / stock_5min / 2009-05-29
file: by_date/stock_5min/2009/2009-05-29.parquet size: 4.8 MB rows: 330,730 symbols: 3,375
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-05-29 06:40:00 | AAPL | Stock | 4.8782 | 4.8782 | 4.8782 | 4.8782 | 2800.0 |
| 2009-05-29 07:20:00 | AAPL | Stock | 4.8743 | 4.8743 | 4.8743 | 4.8743 | 2800.0 |
| 2009-05-29 07:25:00 | AAPL | Stock | 4.8743 | 4.8746 | 4.8743 | 4.8746 | 19880.0 |
| 2009-05-29 07:40:00 | AAPL | Stock | 4.875 | 4.875 | 4.8729 | 4.875 | 29960.0 |
| 2009-05-29 08:00:00 | AAPL | Stock | 4.8525 | 4.8661 | 4.8482 | 4.8643 | 174580.0 |
| 2009-05-29 08:05:00 | AAPL | Stock | 4.8661 | 4.8679 | 4.8571 | 4.865 | 95004.0 |
| 2009-05-29 08:10:00 | AAPL | Stock | 4.8661 | 4.8671 | 4.8614 | 4.8614 | 69076.0 |
| 2009-05-29 08:15:00 | AAPL | Stock | 4.8614 | 4.8679 | 4.8571 | 4.8604 | 280700.0 |
| 2009-05-29 08:20:00 | AAPL | Stock | 4.8582 | 4.8582 | 4.8529 | 4.8536 | 137200.0 |
| 2009-05-29 08:25:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8536 | 4.8536 | 20972.0 |
| 2009-05-29 08:30:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8461 | 4.8489 | 100800.0 |
| 2009-05-29 08:35:00 | AAPL | Stock | 4.8475 | 4.8539 | 4.8461 | 4.8496 | 127624.0 |
| 2009-05-29 08:40:00 | AAPL | Stock | 4.8493 | 4.85 | 4.8464 | 4.85 | 58800.0 |
| 2009-05-29 08:45:00 | AAPL | Stock | 4.8504 | 4.8525 | 4.8482 | 4.8514 | 28000.0 |
| 2009-05-29 08:50:00 | AAPL | Stock | 4.8507 | 4.8514 | 4.8507 | 4.8511 | 8400.0 |
| 2009-05-29 08:55:00 | AAPL | Stock | 4.8514 | 4.8525 | 4.8414 | 4.8414 | 201264.0 |
| 2009-05-29 09:00:00 | AAPL | Stock | 4.8446 | 4.85 | 4.8432 | 4.8446 | 39200.0 |
| 2009-05-29 09:05:00 | AAPL | Stock | 4.8464 | 4.8482 | 4.8429 | 4.8464 | 80500.0 |
| 2009-05-29 09:10:00 | AAPL | Stock | 4.8482 | 4.8571 | 4.8482 | 4.8568 | 212660.0 |
| 2009-05-29 09:15:00 | AAPL | Stock | 4.8568 | 4.8582 | 4.8543 | 4.8543 | 506912.0 |
| 2009-05-29 09:20:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.85 | 4.85 | 90776.0 |
| 2009-05-29 09:25:00 | AAPL | Stock | 4.85 | 4.8532 | 4.8286 | 4.8336 | 455140.0 |
| 2009-05-29 09:30:00 | AAPL | Stock | 4.8343 | 4.8375 | 4.7896 | 4.7918 | 17590776.0 |
| 2009-05-29 09:35:00 | AAPL | Stock | 4.7918 | 4.8179 | 4.7832 | 4.8139 | 16559340.0 |
| 2009-05-29 09:40:00 | AAPL | Stock | 4.8125 | 4.8343 | 4.8125 | 4.8289 | 19520088.0 |
| 2009-05-29 09:45:00 | AAPL | Stock | 4.8279 | 4.8289 | 4.8075 | 4.8118 | 10463628.0 |
| 2009-05-29 09:50:00 | AAPL | Stock | 4.8114 | 4.8146 | 4.7961 | 4.8043 | 10198748.0 |
| 2009-05-29 09:55:00 | AAPL | Stock | 4.8039 | 4.8168 | 4.7989 | 4.8125 | 7310520.0 |
| 2009-05-29 10:00:00 | AAPL | Stock | 4.8125 | 4.8175 | 4.8 | 4.8 | 5499228.0 |
| 2009-05-29 10:05:00 | AAPL | Stock | 4.8 | 4.8175 | 4.8 | 4.8116 | 4067336.0 |
| 2009-05-29 10:10:00 | AAPL | Stock | 4.8117 | 4.8214 | 4.8117 | 4.8207 | 5945884.0 |
| 2009-05-29 10:15:00 | AAPL | Stock | 4.8214 | 4.8239 | 4.8189 | 4.8193 | 8034264.0 |
| 2009-05-29 10:20:00 | AAPL | Stock | 4.8196 | 4.8236 | 4.8189 | 4.8214 | 4168080.0 |
| 2009-05-29 10:25:00 | AAPL | Stock | 4.8215 | 4.8293 | 4.82 | 4.8279 | 7693504.0 |
| 2009-05-29 10:30:00 | AAPL | Stock | 4.8275 | 4.8293 | 4.8246 | 4.8268 | 5959884.0 |
| 2009-05-29 10:35:00 | AAPL | Stock | 4.8271 | 4.8368 | 4.8232 | 4.8361 | 8006544.0 |
| 2009-05-29 10:40:00 | AAPL | Stock | 4.8361 | 4.8411 | 4.8286 | 4.8321 | 11123308.0 |
| 2009-05-29 10:45:00 | AAPL | Stock | 4.8321 | 4.8329 | 4.8246 | 4.8282 | 7857444.0 |
| 2009-05-29 10:50:00 | AAPL | Stock | 4.8278 | 4.8364 | 4.8257 | 4.8357 | 5394592.0 |
| 2009-05-29 10:55:00 | AAPL | Stock | 4.8357 | 4.8368 | 4.8286 | 4.8296 | 3128104.0 |
| 2009-05-29 11:00:00 | AAPL | Stock | 4.8296 | 4.8343 | 4.8146 | 4.8171 | 5895456.0 |
| 2009-05-29 11:05:00 | AAPL | Stock | 4.8171 | 4.8175 | 4.8043 | 4.8079 | 4686108.0 |
| 2009-05-29 11:10:00 | AAPL | Stock | 4.8075 | 4.812 | 4.7971 | 4.8118 | 6361264.0 |
| 2009-05-29 11:15:00 | AAPL | Stock | 4.8118 | 4.8129 | 4.8036 | 4.8036 | 3709664.0 |
| 2009-05-29 11:20:00 | AAPL | Stock | 4.8036 | 4.8139 | 4.8021 | 4.8068 | 3950884.0 |
| 2009-05-29 11:25:00 | AAPL | Stock | 4.8068 | 4.8136 | 4.8 | 4.8004 | 4490360.0 |
| 2009-05-29 11:30:00 | AAPL | Stock | 4.8 | 4.8043 | 4.7964 | 4.7964 | 4578840.0 |
| 2009-05-29 11:35:00 | AAPL | Stock | 4.7964 | 4.7971 | 4.7893 | 4.7896 | 5910688.0 |
| 2009-05-29 11:40:00 | AAPL | Stock | 4.7896 | 4.7936 | 4.7804 | 4.7925 | 8184540.0 |
| 2009-05-29 11:45:00 | AAPL | Stock | 4.7927 | 4.7946 | 4.7889 | 4.7904 | 2348276.0 |
> showing 50 of 330,730 rows — these rows as CSV