PREVIEW / stock_5min / 2007-07-19
file: by_date/stock_5min/2007/2007-07-19.parquet size: 4.0 MB rows: 294,937 symbols: 3,052
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-07-19 09:30:00 | AAPL | Stock | 5.0107 | 5.0179 | 4.9957 | 5.0007 | 34573672.0 |
| 2007-07-19 09:35:00 | AAPL | Stock | 5.0007 | 5.0089 | 4.9911 | 4.9961 | 21903000.0 |
| 2007-07-19 09:40:00 | AAPL | Stock | 4.995 | 5.0029 | 4.9875 | 4.9996 | 17219692.0 |
| 2007-07-19 09:45:00 | AAPL | Stock | 5.0004 | 5.0036 | 4.9957 | 4.9993 | 11135572.0 |
| 2007-07-19 09:50:00 | AAPL | Stock | 4.9996 | 5.01 | 4.9979 | 5.0082 | 17814832.0 |
| 2007-07-19 09:55:00 | AAPL | Stock | 5.0082 | 5.0086 | 5.0021 | 5.0068 | 10845100.0 |
| 2007-07-19 10:00:00 | AAPL | Stock | 5.0061 | 5.0068 | 4.9961 | 5.0 | 9665712.0 |
| 2007-07-19 10:05:00 | AAPL | Stock | 4.9999 | 5.0054 | 4.9979 | 5.0043 | 7823312.0 |
| 2007-07-19 10:10:00 | AAPL | Stock | 5.0043 | 5.0179 | 5.0004 | 5.0143 | 17550484.0 |
| 2007-07-19 10:15:00 | AAPL | Stock | 5.0142 | 5.0243 | 5.0096 | 5.0168 | 20523328.0 |
| 2007-07-19 10:20:00 | AAPL | Stock | 5.0164 | 5.0186 | 5.0079 | 5.0157 | 16210488.0 |
| 2007-07-19 10:25:00 | AAPL | Stock | 5.0157 | 5.0186 | 5.0118 | 5.0154 | 11370016.0 |
| 2007-07-19 10:30:00 | AAPL | Stock | 5.0161 | 5.0171 | 5.0036 | 5.005 | 14033040.0 |
| 2007-07-19 10:35:00 | AAPL | Stock | 5.005 | 5.0061 | 4.9946 | 5.0032 | 17304812.0 |
| 2007-07-19 10:40:00 | AAPL | Stock | 5.0029 | 5.0064 | 5.0018 | 5.0025 | 6539988.0 |
| 2007-07-19 10:45:00 | AAPL | Stock | 5.0025 | 5.0054 | 4.9993 | 5.0043 | 10465672.0 |
| 2007-07-19 10:50:00 | AAPL | Stock | 5.0043 | 5.0046 | 4.9996 | 5.0011 | 5418616.0 |
| 2007-07-19 10:55:00 | AAPL | Stock | 5.0014 | 5.0082 | 4.9989 | 5.005 | 13293000.0 |
| 2007-07-19 11:00:00 | AAPL | Stock | 5.0054 | 5.0179 | 5.005 | 5.015 | 11430972.0 |
| 2007-07-19 11:05:00 | AAPL | Stock | 5.0154 | 5.0214 | 5.0107 | 5.016 | 14017416.0 |
| 2007-07-19 11:10:00 | AAPL | Stock | 5.0161 | 5.02 | 5.0086 | 5.01 | 9404472.0 |
| 2007-07-19 11:15:00 | AAPL | Stock | 5.01 | 5.0136 | 5.0089 | 5.0125 | 5693436.0 |
| 2007-07-19 11:20:00 | AAPL | Stock | 5.0125 | 5.0268 | 5.0125 | 5.0225 | 14912632.0 |
| 2007-07-19 11:25:00 | AAPL | Stock | 5.0221 | 5.0289 | 5.0089 | 5.0096 | 18262692.0 |
| 2007-07-19 11:30:00 | AAPL | Stock | 5.0096 | 5.01 | 5.0036 | 5.0075 | 13888952.0 |
| 2007-07-19 11:35:00 | AAPL | Stock | 5.0074 | 5.0121 | 5.0054 | 5.0071 | 7993188.0 |
| 2007-07-19 11:40:00 | AAPL | Stock | 5.0071 | 5.0128 | 5.0032 | 5.0032 | 8476664.0 |
| 2007-07-19 11:45:00 | AAPL | Stock | 5.0036 | 5.01 | 5.0036 | 5.0096 | 4368868.0 |
| 2007-07-19 11:50:00 | AAPL | Stock | 5.01 | 5.0118 | 5.0071 | 5.0101 | 3234896.0 |
| 2007-07-19 11:55:00 | AAPL | Stock | 5.0103 | 5.0107 | 5.0054 | 5.0075 | 3719100.0 |
| 2007-07-19 12:00:00 | AAPL | Stock | 5.0071 | 5.0071 | 5.0018 | 5.0067 | 6590080.0 |
| 2007-07-19 12:05:00 | AAPL | Stock | 5.0064 | 5.0107 | 5.0054 | 5.0107 | 4190452.0 |
| 2007-07-19 12:10:00 | AAPL | Stock | 5.0105 | 5.0161 | 5.0104 | 5.0121 | 7053732.0 |
| 2007-07-19 12:15:00 | AAPL | Stock | 5.0125 | 5.0125 | 5.0093 | 5.0104 | 5850460.0 |
| 2007-07-19 12:20:00 | AAPL | Stock | 5.0107 | 5.0179 | 5.01 | 5.0171 | 6450304.0 |
| 2007-07-19 12:25:00 | AAPL | Stock | 5.0171 | 5.0204 | 5.0139 | 5.0146 | 6098428.0 |
| 2007-07-19 12:30:00 | AAPL | Stock | 5.015 | 5.0161 | 5.0129 | 5.0139 | 4776744.0 |
| 2007-07-19 12:35:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0117 | 5.0129 | 3550316.0 |
| 2007-07-19 12:40:00 | AAPL | Stock | 5.0129 | 5.0143 | 5.0118 | 5.0125 | 2950640.0 |
| 2007-07-19 12:45:00 | AAPL | Stock | 5.0125 | 5.0168 | 5.0107 | 5.0132 | 3951276.0 |
| 2007-07-19 12:50:00 | AAPL | Stock | 5.0132 | 5.0196 | 5.0129 | 5.0182 | 4594520.0 |
| 2007-07-19 12:55:00 | AAPL | Stock | 5.0174 | 5.0186 | 5.0125 | 5.0154 | 4087356.0 |
| 2007-07-19 13:00:00 | AAPL | Stock | 5.0157 | 5.0157 | 5.0121 | 5.0139 | 3426472.0 |
| 2007-07-19 13:05:00 | AAPL | Stock | 5.0139 | 5.0139 | 5.0071 | 5.0089 | 5130636.0 |
| 2007-07-19 13:10:00 | AAPL | Stock | 5.0089 | 5.0106 | 5.0061 | 5.0082 | 2985696.0 |
| 2007-07-19 13:15:00 | AAPL | Stock | 5.0082 | 5.0129 | 5.0064 | 5.0107 | 2570764.0 |
| 2007-07-19 13:20:00 | AAPL | Stock | 5.0107 | 5.0125 | 5.0082 | 5.0096 | 2572752.0 |
| 2007-07-19 13:25:00 | AAPL | Stock | 5.01 | 5.0139 | 5.0071 | 5.0136 | 3325308.0 |
| 2007-07-19 13:30:00 | AAPL | Stock | 5.0132 | 5.0139 | 5.0086 | 5.0093 | 2879072.0 |
| 2007-07-19 13:35:00 | AAPL | Stock | 5.01 | 5.0121 | 5.0093 | 5.0107 | 3926692.0 |
> showing 50 of 294,937 rows — these rows as CSV