PREVIEW / stock_5min / 2007-10-24
file: by_date/stock_5min/2007/2007-10-24.parquet size: 4.3 MB rows: 312,130 symbols: 3,164
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-10-24 05:10:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 14000.0 |
| 2007-10-24 05:40:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 2800.0 |
| 2007-10-24 05:50:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5954 | 6.5982 | 39200.0 |
| 2007-10-24 06:00:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 10640.0 |
| 2007-10-24 06:10:00 | AAPL | Stock | 6.5961 | 6.5982 | 6.5961 | 6.5964 | 73864.0 |
| 2007-10-24 06:20:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 7560.0 |
| 2007-10-24 06:25:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 2800.0 |
| 2007-10-24 06:30:00 | AAPL | Stock | 6.5825 | 6.5825 | 6.5825 | 6.5825 | 5600.0 |
| 2007-10-24 06:45:00 | AAPL | Stock | 6.5961 | 6.5964 | 6.5961 | 6.5964 | 61376.0 |
| 2007-10-24 06:50:00 | AAPL | Stock | 6.5854 | 6.5854 | 6.5854 | 6.5854 | 8400.0 |
| 2007-10-24 07:00:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 5600.0 |
| 2007-10-24 07:05:00 | AAPL | Stock | 6.6004 | 6.6004 | 6.5786 | 6.5807 | 64400.0 |
| 2007-10-24 07:10:00 | AAPL | Stock | 6.5786 | 6.5786 | 6.5757 | 6.5771 | 32620.0 |
| 2007-10-24 07:15:00 | AAPL | Stock | 6.5743 | 6.5771 | 6.5743 | 6.5771 | 7000.0 |
| 2007-10-24 07:20:00 | AAPL | Stock | 6.5746 | 6.5746 | 6.5739 | 6.5739 | 48580.0 |
| 2007-10-24 07:25:00 | AAPL | Stock | 6.5729 | 6.5768 | 6.5721 | 6.5768 | 24416.0 |
| 2007-10-24 07:30:00 | AAPL | Stock | 6.5807 | 6.5821 | 6.5807 | 6.5821 | 24276.0 |
| 2007-10-24 07:35:00 | AAPL | Stock | 6.5768 | 6.5821 | 6.5768 | 6.5821 | 37184.0 |
| 2007-10-24 07:40:00 | AAPL | Stock | 6.5721 | 6.5821 | 6.5721 | 6.5821 | 16800.0 |
| 2007-10-24 07:45:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 11956.0 |
| 2007-10-24 07:50:00 | AAPL | Stock | 6.5821 | 6.5907 | 6.5821 | 6.5821 | 116760.0 |
| 2007-10-24 07:55:00 | AAPL | Stock | 6.5857 | 6.5857 | 6.5857 | 6.5857 | 2800.0 |
| 2007-10-24 08:00:00 | AAPL | Stock | 6.5893 | 6.5893 | 6.5714 | 6.5839 | 503860.0 |
| 2007-10-24 08:05:00 | AAPL | Stock | 6.5821 | 6.5839 | 6.5764 | 6.5764 | 129304.0 |
| 2007-10-24 08:10:00 | AAPL | Stock | 6.5764 | 6.5857 | 6.575 | 6.5786 | 632072.0 |
| 2007-10-24 08:15:00 | AAPL | Stock | 6.5786 | 6.5821 | 6.5786 | 6.5804 | 157752.0 |
| 2007-10-24 08:20:00 | AAPL | Stock | 6.5821 | 6.5921 | 6.5714 | 6.5921 | 559776.0 |
| 2007-10-24 08:25:00 | AAPL | Stock | 6.5907 | 6.6486 | 6.5804 | 6.6486 | 425432.0 |
| 2007-10-24 08:30:00 | AAPL | Stock | 6.5893 | 6.5893 | 6.5714 | 6.5857 | 252448.0 |
| 2007-10-24 08:35:00 | AAPL | Stock | 6.5889 | 6.5893 | 6.5821 | 6.5843 | 145068.0 |
| 2007-10-24 08:40:00 | AAPL | Stock | 6.5857 | 6.5864 | 6.5843 | 6.5864 | 107884.0 |
| 2007-10-24 08:45:00 | AAPL | Stock | 6.5871 | 6.6054 | 6.5871 | 6.6054 | 430780.0 |
| 2007-10-24 08:50:00 | AAPL | Stock | 6.6064 | 6.6129 | 6.6 | 6.6129 | 926184.0 |
| 2007-10-24 08:55:00 | AAPL | Stock | 6.6129 | 6.6143 | 6.6107 | 6.6125 | 567504.0 |
| 2007-10-24 09:00:00 | AAPL | Stock | 6.6129 | 6.6232 | 6.6129 | 6.6232 | 517944.0 |
| 2007-10-24 09:05:00 | AAPL | Stock | 6.6232 | 6.6396 | 6.6229 | 6.6393 | 2975840.0 |
| 2007-10-24 09:10:00 | AAPL | Stock | 6.6389 | 6.6471 | 6.6314 | 6.6339 | 1548288.0 |
| 2007-10-24 09:15:00 | AAPL | Stock | 6.6339 | 6.6357 | 6.6336 | 6.6346 | 289016.0 |
| 2007-10-24 09:20:00 | AAPL | Stock | 6.6357 | 6.6464 | 6.6357 | 6.6446 | 788704.0 |
| 2007-10-24 09:25:00 | AAPL | Stock | 6.6429 | 6.6454 | 6.6329 | 6.6357 | 1577548.0 |
| 2007-10-24 09:30:00 | AAPL | Stock | 6.6357 | 6.6475 | 6.5914 | 6.6111 | 36823388.0 |
| 2007-10-24 09:35:00 | AAPL | Stock | 6.6104 | 6.6229 | 6.5971 | 6.6061 | 22072344.0 |
| 2007-10-24 09:40:00 | AAPL | Stock | 6.6061 | 6.6332 | 6.5986 | 6.6279 | 18768484.0 |
| 2007-10-24 09:45:00 | AAPL | Stock | 6.6282 | 6.6607 | 6.6268 | 6.6564 | 25847752.0 |
| 2007-10-24 09:50:00 | AAPL | Stock | 6.6564 | 6.6861 | 6.655 | 6.6707 | 28901096.0 |
| 2007-10-24 09:55:00 | AAPL | Stock | 6.6707 | 6.6714 | 6.6554 | 6.6575 | 19211472.0 |
| 2007-10-24 10:00:00 | AAPL | Stock | 6.6575 | 6.6589 | 6.6071 | 6.6371 | 27108200.0 |
| 2007-10-24 10:05:00 | AAPL | Stock | 6.6371 | 6.6529 | 6.6279 | 6.6468 | 14869960.0 |
| 2007-10-24 10:10:00 | AAPL | Stock | 6.6468 | 6.6493 | 6.5929 | 6.625 | 20443556.0 |
| 2007-10-24 10:15:00 | AAPL | Stock | 6.6236 | 6.6246 | 6.6086 | 6.6196 | 11061400.0 |
> showing 50 of 312,130 rows — these rows as CSV