PREVIEW / stock_5min / 2010-03-16
file: by_date/stock_5min/2010/2010-03-16.parquet size: 4.7 MB rows: 321,803 symbols: 3,476
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-03-16 04:25:00 | AAPL | Stock | 7.98 | 7.98 | 7.98 | 7.98 | 3416.0 |
| 2010-03-16 05:45:00 | AAPL | Stock | 7.99 | 7.99 | 7.99 | 7.99 | 15120.0 |
| 2010-03-16 06:55:00 | AAPL | Stock | 8.0279 | 8.0304 | 8.0279 | 8.0304 | 54964.0 |
| 2010-03-16 07:00:00 | AAPL | Stock | 8.03 | 8.03 | 8.03 | 8.03 | 4760.0 |
| 2010-03-16 07:05:00 | AAPL | Stock | 8.0282 | 8.0282 | 8.0282 | 8.0282 | 28000.0 |
| 2010-03-16 07:20:00 | AAPL | Stock | 8.0268 | 8.0321 | 8.0268 | 8.0321 | 95788.0 |
| 2010-03-16 07:40:00 | AAPL | Stock | 8.0336 | 8.0336 | 8.0336 | 8.0336 | 8400.0 |
| 2010-03-16 07:45:00 | AAPL | Stock | 8.0336 | 8.0336 | 8.0314 | 8.0314 | 33600.0 |
| 2010-03-16 07:50:00 | AAPL | Stock | 8.0332 | 8.0354 | 8.0332 | 8.0354 | 33600.0 |
| 2010-03-16 07:55:00 | AAPL | Stock | 8.0389 | 8.0389 | 8.0389 | 8.0389 | 5600.0 |
| 2010-03-16 08:00:00 | AAPL | Stock | 8.0325 | 8.0357 | 8.0179 | 8.0179 | 457464.0 |
| 2010-03-16 08:05:00 | AAPL | Stock | 8.0089 | 8.0171 | 8.0021 | 8.0125 | 94220.0 |
| 2010-03-16 08:10:00 | AAPL | Stock | 8.0139 | 8.0143 | 7.9979 | 7.9979 | 271348.0 |
| 2010-03-16 08:15:00 | AAPL | Stock | 7.9979 | 8.007 | 7.9964 | 8.0 | 151004.0 |
| 2010-03-16 08:20:00 | AAPL | Stock | 8.0 | 8.0 | 7.9932 | 7.995 | 250600.0 |
| 2010-03-16 08:25:00 | AAPL | Stock | 7.9989 | 7.9989 | 7.9861 | 7.9936 | 115920.0 |
| 2010-03-16 08:30:00 | AAPL | Stock | 7.9914 | 8.0061 | 7.9896 | 7.9911 | 228480.0 |
| 2010-03-16 08:35:00 | AAPL | Stock | 7.9929 | 7.9929 | 7.9857 | 7.9879 | 133196.0 |
| 2010-03-16 08:40:00 | AAPL | Stock | 7.9925 | 7.9961 | 7.9921 | 7.9929 | 33908.0 |
| 2010-03-16 08:45:00 | AAPL | Stock | 7.99 | 7.9929 | 7.99 | 7.9911 | 44800.0 |
| 2010-03-16 08:50:00 | AAPL | Stock | 7.9932 | 7.9932 | 7.9929 | 7.9929 | 23800.0 |
| 2010-03-16 08:55:00 | AAPL | Stock | 7.9936 | 7.9936 | 7.9896 | 7.9929 | 151508.0 |
| 2010-03-16 09:00:00 | AAPL | Stock | 7.9929 | 7.9929 | 7.9886 | 7.9921 | 47600.0 |
| 2010-03-16 09:05:00 | AAPL | Stock | 7.9921 | 8.0 | 7.9921 | 8.0 | 143192.0 |
| 2010-03-16 09:10:00 | AAPL | Stock | 7.9993 | 8.0036 | 7.9993 | 8.0036 | 237440.0 |
| 2010-03-16 09:15:00 | AAPL | Stock | 8.0036 | 8.0046 | 8.0025 | 8.0036 | 74060.0 |
| 2010-03-16 09:20:00 | AAPL | Stock | 8.0011 | 8.0011 | 7.9918 | 7.9954 | 249060.0 |
| 2010-03-16 09:25:00 | AAPL | Stock | 7.9957 | 8.0071 | 7.9957 | 8.0071 | 95060.0 |
| 2010-03-16 09:30:00 | AAPL | Stock | 8.0064 | 8.0171 | 7.9864 | 7.9993 | 11722060.0 |
| 2010-03-16 09:35:00 | AAPL | Stock | 7.9979 | 8.0004 | 7.9768 | 7.9896 | 10065384.0 |
| 2010-03-16 09:40:00 | AAPL | Stock | 7.9896 | 8.01 | 7.9889 | 8.0086 | 8649732.0 |
| 2010-03-16 09:45:00 | AAPL | Stock | 8.0082 | 8.0089 | 7.9921 | 7.9929 | 6495720.0 |
| 2010-03-16 09:50:00 | AAPL | Stock | 7.9929 | 7.9961 | 7.9811 | 7.9904 | 6624296.0 |
| 2010-03-16 09:55:00 | AAPL | Stock | 7.99 | 7.9925 | 7.9732 | 7.9874 | 6588596.0 |
| 2010-03-16 10:00:00 | AAPL | Stock | 7.9871 | 7.9907 | 7.9757 | 7.9775 | 4617228.0 |
| 2010-03-16 10:05:00 | AAPL | Stock | 7.9761 | 7.9961 | 7.9739 | 7.9921 | 6311536.0 |
| 2010-03-16 10:10:00 | AAPL | Stock | 7.9921 | 7.9946 | 7.97 | 7.9729 | 6853840.0 |
| 2010-03-16 10:15:00 | AAPL | Stock | 7.9718 | 7.9739 | 7.9536 | 7.955 | 9286508.0 |
| 2010-03-16 10:20:00 | AAPL | Stock | 7.9546 | 7.9632 | 7.9468 | 7.9632 | 7283696.0 |
| 2010-03-16 10:25:00 | AAPL | Stock | 7.9632 | 7.9825 | 7.9626 | 7.9746 | 7393484.0 |
| 2010-03-16 10:30:00 | AAPL | Stock | 7.9746 | 7.9839 | 7.9739 | 7.9757 | 3542588.0 |
| 2010-03-16 10:35:00 | AAPL | Stock | 7.975 | 7.9821 | 7.9679 | 7.9771 | 4476752.0 |
| 2010-03-16 10:40:00 | AAPL | Stock | 7.9771 | 7.9811 | 7.9707 | 7.978 | 2315852.0 |
| 2010-03-16 10:45:00 | AAPL | Stock | 7.9775 | 7.9925 | 7.9775 | 7.9839 | 4472916.0 |
| 2010-03-16 10:50:00 | AAPL | Stock | 7.9843 | 7.9946 | 7.9836 | 7.9914 | 2916732.0 |
| 2010-03-16 10:55:00 | AAPL | Stock | 7.9911 | 8.0118 | 7.9879 | 8.0114 | 8812468.0 |
| 2010-03-16 11:00:00 | AAPL | Stock | 8.0114 | 8.0143 | 7.9979 | 8.0029 | 5725496.0 |
| 2010-03-16 11:05:00 | AAPL | Stock | 8.0018 | 8.0095 | 8.0018 | 8.0058 | 4319084.0 |
| 2010-03-16 11:10:00 | AAPL | Stock | 8.0061 | 8.0136 | 8.005 | 8.0071 | 3421516.0 |
| 2010-03-16 11:15:00 | AAPL | Stock | 8.0071 | 8.0232 | 8.0064 | 8.0232 | 3850280.0 |
> showing 50 of 321,803 rows — these rows as CSV