PREVIEW / stock_5min / 2010-12-23
file: by_date/stock_5min/2010/2010-12-23.parquet size: 4.6 MB rows: 316,565 symbols: 3,526
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-23 04:15:00 | AAPL | Stock | 11.6054 | 11.6054 | 11.6054 | 11.6054 | 2800.0 |
| 2010-12-23 06:15:00 | AAPL | Stock | 11.6411 | 11.6411 | 11.6411 | 11.6411 | 2800.0 |
| 2010-12-23 07:00:00 | AAPL | Stock | 11.625 | 11.625 | 11.625 | 11.625 | 2800.0 |
| 2010-12-23 07:15:00 | AAPL | Stock | 11.625 | 11.625 | 11.625 | 11.625 | 14000.0 |
| 2010-12-23 07:25:00 | AAPL | Stock | 11.6214 | 11.6214 | 11.6211 | 11.6211 | 8400.0 |
| 2010-12-23 07:30:00 | AAPL | Stock | 11.6161 | 11.6161 | 11.6036 | 11.6036 | 29400.0 |
| 2010-12-23 07:40:00 | AAPL | Stock | 11.6036 | 11.6036 | 11.6036 | 11.6036 | 2800.0 |
| 2010-12-23 07:45:00 | AAPL | Stock | 11.6064 | 11.6064 | 11.6018 | 11.6018 | 30800.0 |
| 2010-12-23 07:50:00 | AAPL | Stock | 11.6018 | 11.6018 | 11.6018 | 11.6018 | 5600.0 |
| 2010-12-23 07:55:00 | AAPL | Stock | 11.6018 | 11.6111 | 11.6018 | 11.6111 | 51884.0 |
| 2010-12-23 08:00:00 | AAPL | Stock | 11.6071 | 11.6071 | 11.6043 | 11.6043 | 22260.0 |
| 2010-12-23 08:05:00 | AAPL | Stock | 11.6046 | 11.6068 | 11.6014 | 11.6014 | 59360.0 |
| 2010-12-23 08:10:00 | AAPL | Stock | 11.6064 | 11.6089 | 11.6007 | 11.6018 | 115696.0 |
| 2010-12-23 08:15:00 | AAPL | Stock | 11.6071 | 11.6071 | 11.6018 | 11.6025 | 37800.0 |
| 2010-12-23 08:20:00 | AAPL | Stock | 11.6025 | 11.6025 | 11.6025 | 11.6025 | 2800.0 |
| 2010-12-23 08:25:00 | AAPL | Stock | 11.6018 | 11.61 | 11.6011 | 11.6071 | 55440.0 |
| 2010-12-23 08:30:00 | AAPL | Stock | 11.6107 | 11.6129 | 11.6011 | 11.6071 | 377160.0 |
| 2010-12-23 08:35:00 | AAPL | Stock | 11.6064 | 11.6071 | 11.6064 | 11.6071 | 23800.0 |
| 2010-12-23 08:40:00 | AAPL | Stock | 11.6071 | 11.6071 | 11.6064 | 11.6071 | 14000.0 |
| 2010-12-23 08:45:00 | AAPL | Stock | 11.6071 | 11.6079 | 11.6071 | 11.6071 | 25200.0 |
| 2010-12-23 08:50:00 | AAPL | Stock | 11.61 | 11.6107 | 11.6079 | 11.6107 | 28000.0 |
| 2010-12-23 08:55:00 | AAPL | Stock | 11.6071 | 11.6114 | 11.6068 | 11.6114 | 36400.0 |
| 2010-12-23 09:00:00 | AAPL | Stock | 11.6104 | 11.6104 | 11.6054 | 11.6054 | 72800.0 |
| 2010-12-23 09:05:00 | AAPL | Stock | 11.605 | 11.6075 | 11.605 | 11.6071 | 64316.0 |
| 2010-12-23 09:10:00 | AAPL | Stock | 11.6075 | 11.6107 | 11.6064 | 11.6096 | 159320.0 |
| 2010-12-23 09:15:00 | AAPL | Stock | 11.6107 | 11.6107 | 11.6089 | 11.6089 | 22400.0 |
| 2010-12-23 09:20:00 | AAPL | Stock | 11.6086 | 11.6086 | 11.6086 | 11.6086 | 8400.0 |
| 2010-12-23 09:25:00 | AAPL | Stock | 11.6071 | 11.6104 | 11.6043 | 11.6071 | 150304.0 |
| 2010-12-23 09:30:00 | AAPL | Stock | 11.6071 | 11.6125 | 11.5911 | 11.595 | 6029968.0 |
| 2010-12-23 09:35:00 | AAPL | Stock | 11.594 | 11.6054 | 11.5939 | 11.6039 | 6200348.0 |
| 2010-12-23 09:40:00 | AAPL | Stock | 11.6054 | 11.6096 | 11.5918 | 11.5936 | 4192776.0 |
| 2010-12-23 09:45:00 | AAPL | Stock | 11.5939 | 11.6036 | 11.5893 | 11.6032 | 3757936.0 |
| 2010-12-23 09:50:00 | AAPL | Stock | 11.6032 | 11.6032 | 11.5936 | 11.5946 | 3629780.0 |
| 2010-12-23 09:55:00 | AAPL | Stock | 11.5956 | 11.5982 | 11.5893 | 11.5907 | 3406060.0 |
| 2010-12-23 10:00:00 | AAPL | Stock | 11.5907 | 11.6004 | 11.5864 | 11.5911 | 3792348.0 |
| 2010-12-23 10:05:00 | AAPL | Stock | 11.59 | 11.5993 | 11.5864 | 11.5907 | 2984240.0 |
| 2010-12-23 10:10:00 | AAPL | Stock | 11.5914 | 11.5914 | 11.585 | 11.5864 | 2589132.0 |
| 2010-12-23 10:15:00 | AAPL | Stock | 11.5864 | 11.5879 | 11.5746 | 11.5754 | 4816028.0 |
| 2010-12-23 10:20:00 | AAPL | Stock | 11.5747 | 11.5771 | 11.5607 | 11.5647 | 7016380.0 |
| 2010-12-23 10:25:00 | AAPL | Stock | 11.5661 | 11.5693 | 11.5554 | 11.5607 | 4560360.0 |
| 2010-12-23 10:30:00 | AAPL | Stock | 11.5589 | 11.5668 | 11.5564 | 11.5593 | 2846396.0 |
| 2010-12-23 10:35:00 | AAPL | Stock | 11.5594 | 11.5679 | 11.5579 | 11.5614 | 5074776.0 |
| 2010-12-23 10:40:00 | AAPL | Stock | 11.5625 | 11.5643 | 11.5571 | 11.5582 | 2624524.0 |
| 2010-12-23 10:45:00 | AAPL | Stock | 11.5579 | 11.5604 | 11.5532 | 11.5536 | 3257352.0 |
| 2010-12-23 10:50:00 | AAPL | Stock | 11.5536 | 11.5604 | 11.5529 | 11.5557 | 2659944.0 |
| 2010-12-23 10:55:00 | AAPL | Stock | 11.5561 | 11.5629 | 11.5554 | 11.56 | 1406272.0 |
| 2010-12-23 11:00:00 | AAPL | Stock | 11.5618 | 11.5725 | 11.5607 | 11.5671 | 3046624.0 |
| 2010-12-23 11:05:00 | AAPL | Stock | 11.5691 | 11.5771 | 11.5681 | 11.575 | 3446688.0 |
| 2010-12-23 11:10:00 | AAPL | Stock | 11.5754 | 11.5786 | 11.575 | 11.5757 | 2507596.0 |
| 2010-12-23 11:15:00 | AAPL | Stock | 11.5757 | 11.5775 | 11.5714 | 11.5761 | 2457980.0 |
> showing 50 of 316,565 rows — these rows as CSV