PREVIEW / stock_5min / 2009-03-18
file: by_date/stock_5min/2009/2009-03-18.parquet size: 4.5 MB rows: 308,390 symbols: 3,338
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-03-18 05:30:00 | AAPL | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 5600.0 |
| 2009-03-18 06:55:00 | AAPL | Stock | 3.5525 | 3.5525 | 3.5525 | 3.5525 | 5600.0 |
| 2009-03-18 07:30:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5493 | 3.5493 | 5600.0 |
| 2009-03-18 07:35:00 | AAPL | Stock | 3.5486 | 3.5486 | 3.5486 | 3.5486 | 5040.0 |
| 2009-03-18 07:40:00 | AAPL | Stock | 3.5604 | 3.5625 | 3.5604 | 3.5625 | 7756.0 |
| 2009-03-18 08:00:00 | AAPL | Stock | 3.545 | 3.545 | 3.5268 | 3.5286 | 186900.0 |
| 2009-03-18 08:05:00 | AAPL | Stock | 3.5286 | 3.5357 | 3.5286 | 3.5357 | 21420.0 |
| 2009-03-18 08:10:00 | AAPL | Stock | 3.5286 | 3.5357 | 3.5286 | 3.5357 | 70980.0 |
| 2009-03-18 08:15:00 | AAPL | Stock | 3.5339 | 3.5425 | 3.5296 | 3.5357 | 55720.0 |
| 2009-03-18 08:20:00 | AAPL | Stock | 3.5364 | 3.5379 | 3.5357 | 3.5357 | 22400.0 |
| 2009-03-18 08:25:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5329 | 3.5329 | 86520.0 |
| 2009-03-18 08:30:00 | AAPL | Stock | 3.5339 | 3.5339 | 3.5311 | 3.5311 | 99288.0 |
| 2009-03-18 08:35:00 | AAPL | Stock | 3.5321 | 3.5436 | 3.5321 | 3.5339 | 40236.0 |
| 2009-03-18 08:40:00 | AAPL | Stock | 3.5357 | 3.5393 | 3.5357 | 3.5393 | 14000.0 |
| 2009-03-18 08:45:00 | AAPL | Stock | 3.5357 | 3.5479 | 3.5357 | 3.5479 | 46200.0 |
| 2009-03-18 08:50:00 | AAPL | Stock | 3.5482 | 3.5707 | 3.5482 | 3.5557 | 460656.0 |
| 2009-03-18 08:55:00 | AAPL | Stock | 3.5575 | 3.5864 | 3.5571 | 3.5786 | 1826216.0 |
| 2009-03-18 09:00:00 | AAPL | Stock | 3.5757 | 3.5804 | 3.565 | 3.5661 | 287056.0 |
| 2009-03-18 09:05:00 | AAPL | Stock | 3.5679 | 3.5696 | 3.5607 | 3.5625 | 262640.0 |
| 2009-03-18 09:10:00 | AAPL | Stock | 3.5625 | 3.5625 | 3.555 | 3.5604 | 190540.0 |
| 2009-03-18 09:15:00 | AAPL | Stock | 3.5604 | 3.5625 | 3.5571 | 3.5571 | 111860.0 |
| 2009-03-18 09:20:00 | AAPL | Stock | 3.5554 | 3.5714 | 3.5536 | 3.5711 | 252280.0 |
| 2009-03-18 09:25:00 | AAPL | Stock | 3.5711 | 3.5771 | 3.5632 | 3.5632 | 859264.0 |
| 2009-03-18 09:30:00 | AAPL | Stock | 3.5679 | 3.5986 | 3.5668 | 3.5954 | 31647028.0 |
| 2009-03-18 09:35:00 | AAPL | Stock | 3.595 | 3.6239 | 3.5925 | 3.6214 | 27963796.0 |
| 2009-03-18 09:40:00 | AAPL | Stock | 3.6214 | 3.6543 | 3.6143 | 3.64 | 30128000.0 |
| 2009-03-18 09:45:00 | AAPL | Stock | 3.6404 | 3.6471 | 3.625 | 3.6296 | 19253780.0 |
| 2009-03-18 09:50:00 | AAPL | Stock | 3.6296 | 3.6354 | 3.6107 | 3.6161 | 18730180.0 |
| 2009-03-18 09:55:00 | AAPL | Stock | 3.6161 | 3.6286 | 3.6071 | 3.6279 | 17213364.0 |
| 2009-03-18 10:00:00 | AAPL | Stock | 3.6275 | 3.6343 | 3.6214 | 3.6289 | 11135740.0 |
| 2009-03-18 10:05:00 | AAPL | Stock | 3.6289 | 3.6389 | 3.6086 | 3.6089 | 13049344.0 |
| 2009-03-18 10:10:00 | AAPL | Stock | 3.6107 | 3.6129 | 3.5936 | 3.6029 | 21326312.0 |
| 2009-03-18 10:15:00 | AAPL | Stock | 3.6027 | 3.6036 | 3.5854 | 3.595 | 12930680.0 |
| 2009-03-18 10:20:00 | AAPL | Stock | 3.5954 | 3.5996 | 3.5882 | 3.5979 | 8387064.0 |
| 2009-03-18 10:25:00 | AAPL | Stock | 3.5979 | 3.5989 | 3.5853 | 3.5889 | 7779128.0 |
| 2009-03-18 10:30:00 | AAPL | Stock | 3.5875 | 3.5982 | 3.5832 | 3.5868 | 8227072.0 |
| 2009-03-18 10:35:00 | AAPL | Stock | 3.5861 | 3.5875 | 3.5793 | 3.5836 | 7835296.0 |
| 2009-03-18 10:40:00 | AAPL | Stock | 3.5839 | 3.585 | 3.575 | 3.5829 | 6935208.0 |
| 2009-03-18 10:45:00 | AAPL | Stock | 3.5836 | 3.5893 | 3.5818 | 3.5864 | 7035308.0 |
| 2009-03-18 10:50:00 | AAPL | Stock | 3.5864 | 3.5882 | 3.5614 | 3.5721 | 12699260.0 |
| 2009-03-18 10:55:00 | AAPL | Stock | 3.5718 | 3.5829 | 3.5675 | 3.5825 | 9130436.0 |
| 2009-03-18 11:00:00 | AAPL | Stock | 3.5829 | 3.5864 | 3.5804 | 3.586 | 7159348.0 |
| 2009-03-18 11:05:00 | AAPL | Stock | 3.5861 | 3.5996 | 3.5818 | 3.5825 | 9036384.0 |
| 2009-03-18 11:10:00 | AAPL | Stock | 3.5821 | 3.585 | 3.5775 | 3.58 | 3350816.0 |
| 2009-03-18 11:15:00 | AAPL | Stock | 3.58 | 3.5811 | 3.5718 | 3.5732 | 6599936.0 |
| 2009-03-18 11:20:00 | AAPL | Stock | 3.5725 | 3.5821 | 3.5718 | 3.5743 | 6771856.0 |
| 2009-03-18 11:25:00 | AAPL | Stock | 3.575 | 3.5836 | 3.5732 | 3.581 | 6041896.0 |
| 2009-03-18 11:30:00 | AAPL | Stock | 3.5811 | 3.5904 | 3.5804 | 3.5804 | 4005288.0 |
| 2009-03-18 11:35:00 | AAPL | Stock | 3.5805 | 3.5854 | 3.5714 | 3.5746 | 4518528.0 |
| 2009-03-18 11:40:00 | AAPL | Stock | 3.575 | 3.5804 | 3.5743 | 3.5796 | 3157644.0 |
> showing 50 of 308,390 rows — these rows as CSV