PREVIEW / stock_5min / 2004-05-10
file: by_date/stock_5min/2004/2004-05-10.parquet size: 2.6 MB rows: 188,047 symbols: 1,779
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 |
|---|---|---|---|---|---|---|---|
| 2004-05-10 08:00:00 | AAPL | Stock | 0.4734 | 0.4734 | 0.4734 | 0.4734 | 25200.0 |
| 2004-05-10 08:15:00 | AAPL | Stock | 0.4688 | 0.4688 | 0.4688 | 0.4688 | 15960.0 |
| 2004-05-10 08:25:00 | AAPL | Stock | 0.4696 | 0.4696 | 0.4689 | 0.4689 | 39200.0 |
| 2004-05-10 08:30:00 | AAPL | Stock | 0.4698 | 0.4698 | 0.4688 | 0.4688 | 90440.0 |
| 2004-05-10 08:40:00 | AAPL | Stock | 0.4688 | 0.4688 | 0.4688 | 0.4688 | 16800.0 |
| 2004-05-10 09:00:00 | AAPL | Stock | 0.4689 | 0.4689 | 0.4689 | 0.4689 | 67200.0 |
| 2004-05-10 09:05:00 | AAPL | Stock | 0.4705 | 0.4705 | 0.4705 | 0.4705 | 28000.0 |
| 2004-05-10 09:10:00 | AAPL | Stock | 0.4761 | 0.4761 | 0.4761 | 0.4761 | 16800.0 |
| 2004-05-10 09:15:00 | AAPL | Stock | 0.4705 | 0.4705 | 0.4696 | 0.4696 | 145600.0 |
| 2004-05-10 09:20:00 | AAPL | Stock | 0.4691 | 0.4691 | 0.4691 | 0.4691 | 56000.0 |
| 2004-05-10 09:25:00 | AAPL | Stock | 0.4705 | 0.472 | 0.4698 | 0.4698 | 237720.0 |
| 2004-05-10 09:30:00 | AAPL | Stock | 0.4691 | 0.4697 | 0.465 | 0.4659 | 7537488.0 |
| 2004-05-10 09:35:00 | AAPL | Stock | 0.4655 | 0.4729 | 0.4655 | 0.4695 | 5471704.0 |
| 2004-05-10 09:40:00 | AAPL | Stock | 0.4695 | 0.4713 | 0.4688 | 0.4709 | 4196136.0 |
| 2004-05-10 09:45:00 | AAPL | Stock | 0.4711 | 0.4713 | 0.4677 | 0.4689 | 3144792.0 |
| 2004-05-10 09:50:00 | AAPL | Stock | 0.4688 | 0.4705 | 0.4679 | 0.468 | 2500232.0 |
| 2004-05-10 09:55:00 | AAPL | Stock | 0.468 | 0.4688 | 0.4652 | 0.467 | 2826936.0 |
| 2004-05-10 10:00:00 | AAPL | Stock | 0.467 | 0.4695 | 0.4661 | 0.4693 | 2758224.0 |
| 2004-05-10 10:05:00 | AAPL | Stock | 0.4688 | 0.4702 | 0.4679 | 0.468 | 2483880.0 |
| 2004-05-10 10:10:00 | AAPL | Stock | 0.4679 | 0.4686 | 0.4661 | 0.4668 | 3494008.0 |
| 2004-05-10 10:15:00 | AAPL | Stock | 0.4666 | 0.467 | 0.4654 | 0.4663 | 3734304.0 |
| 2004-05-10 10:20:00 | AAPL | Stock | 0.4663 | 0.467 | 0.4646 | 0.4648 | 3613904.0 |
| 2004-05-10 10:25:00 | AAPL | Stock | 0.4648 | 0.467 | 0.4646 | 0.4666 | 3430056.0 |
| 2004-05-10 10:30:00 | AAPL | Stock | 0.467 | 0.467 | 0.4661 | 0.4664 | 1771896.0 |
| 2004-05-10 10:35:00 | AAPL | Stock | 0.4664 | 0.467 | 0.4661 | 0.4661 | 2513560.0 |
| 2004-05-10 10:40:00 | AAPL | Stock | 0.4663 | 0.467 | 0.4661 | 0.467 | 1179864.0 |
| 2004-05-10 10:45:00 | AAPL | Stock | 0.4666 | 0.467 | 0.465 | 0.465 | 4018448.0 |
| 2004-05-10 10:50:00 | AAPL | Stock | 0.465 | 0.4661 | 0.4648 | 0.465 | 1644776.0 |
| 2004-05-10 10:55:00 | AAPL | Stock | 0.4648 | 0.4671 | 0.4648 | 0.4666 | 3618496.0 |
| 2004-05-10 11:00:00 | AAPL | Stock | 0.4666 | 0.467 | 0.4664 | 0.4664 | 1715840.0 |
| 2004-05-10 11:05:00 | AAPL | Stock | 0.4666 | 0.4668 | 0.4645 | 0.4646 | 2910824.0 |
| 2004-05-10 11:10:00 | AAPL | Stock | 0.4646 | 0.4659 | 0.4643 | 0.4648 | 2747360.0 |
| 2004-05-10 11:15:00 | AAPL | Stock | 0.4645 | 0.4661 | 0.4645 | 0.4661 | 2483152.0 |
| 2004-05-10 11:20:00 | AAPL | Stock | 0.4659 | 0.467 | 0.4654 | 0.4664 | 2855384.0 |
| 2004-05-10 11:25:00 | AAPL | Stock | 0.4666 | 0.4671 | 0.465 | 0.4655 | 1962352.0 |
| 2004-05-10 11:30:00 | AAPL | Stock | 0.4655 | 0.4655 | 0.4643 | 0.4652 | 1818824.0 |
| 2004-05-10 11:35:00 | AAPL | Stock | 0.465 | 0.4661 | 0.4643 | 0.4661 | 1316000.0 |
| 2004-05-10 11:40:00 | AAPL | Stock | 0.4661 | 0.4666 | 0.465 | 0.4664 | 1481200.0 |
| 2004-05-10 11:45:00 | AAPL | Stock | 0.4663 | 0.4668 | 0.4648 | 0.4665 | 1645336.0 |
| 2004-05-10 11:50:00 | AAPL | Stock | 0.4666 | 0.467 | 0.4666 | 0.4666 | 1002456.0 |
| 2004-05-10 11:55:00 | AAPL | Stock | 0.4666 | 0.4666 | 0.4652 | 0.4655 | 1307656.0 |
| 2004-05-10 12:00:00 | AAPL | Stock | 0.4655 | 0.4661 | 0.4652 | 0.4652 | 2273208.0 |
| 2004-05-10 12:05:00 | AAPL | Stock | 0.4652 | 0.4663 | 0.4652 | 0.4663 | 1845648.0 |
| 2004-05-10 12:10:00 | AAPL | Stock | 0.4661 | 0.467 | 0.4657 | 0.4657 | 774032.0 |
| 2004-05-10 12:15:00 | AAPL | Stock | 0.4659 | 0.4663 | 0.4654 | 0.4663 | 754040.0 |
| 2004-05-10 12:20:00 | AAPL | Stock | 0.4664 | 0.4664 | 0.4663 | 0.4664 | 687456.0 |
| 2004-05-10 12:25:00 | AAPL | Stock | 0.4664 | 0.4675 | 0.4657 | 0.4673 | 1012928.0 |
| 2004-05-10 12:30:00 | AAPL | Stock | 0.4673 | 0.4684 | 0.467 | 0.4675 | 1809024.0 |
| 2004-05-10 12:35:00 | AAPL | Stock | 0.4675 | 0.4679 | 0.4663 | 0.4671 | 2189936.0 |
| 2004-05-10 12:40:00 | AAPL | Stock | 0.467 | 0.4688 | 0.4668 | 0.4686 | 2676912.0 |
> showing 50 of 188,047 rows — these rows as CSV