PREVIEW / stock_5min / 2007-10-12
file: by_date/stock_5min/2007/2007-10-12.parquet size: 4.1 MB rows: 298,982 symbols: 3,140
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-12 05:55:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 19600.0 |
| 2007-10-12 07:05:00 | AAPL | Stock | 5.7857 | 5.7929 | 5.7857 | 5.7929 | 8400.0 |
| 2007-10-12 07:10:00 | AAPL | Stock | 5.7936 | 5.7936 | 5.7929 | 5.7929 | 36400.0 |
| 2007-10-12 07:20:00 | AAPL | Stock | 5.8161 | 5.8161 | 5.7946 | 5.8043 | 64456.0 |
| 2007-10-12 07:25:00 | AAPL | Stock | 5.8046 | 5.8279 | 5.8046 | 5.8214 | 233828.0 |
| 2007-10-12 07:30:00 | AAPL | Stock | 5.825 | 5.8357 | 5.825 | 5.8286 | 103796.0 |
| 2007-10-12 07:35:00 | AAPL | Stock | 5.8357 | 5.8357 | 5.8214 | 5.8218 | 110656.0 |
| 2007-10-12 07:45:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8214 | 5.8214 | 25200.0 |
| 2007-10-12 07:50:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8161 | 5.8207 | 9520.0 |
| 2007-10-12 07:55:00 | AAPL | Stock | 5.8161 | 5.8161 | 5.8161 | 5.8161 | 28000.0 |
| 2007-10-12 08:00:00 | AAPL | Stock | 5.8146 | 5.8246 | 5.7946 | 5.8125 | 895580.0 |
| 2007-10-12 08:05:00 | AAPL | Stock | 5.8139 | 5.8214 | 5.8107 | 5.8214 | 422128.0 |
| 2007-10-12 08:10:00 | AAPL | Stock | 5.8179 | 5.8339 | 5.8143 | 5.8332 | 870184.0 |
| 2007-10-12 08:15:00 | AAPL | Stock | 5.8289 | 5.8336 | 5.8143 | 5.8143 | 1053388.0 |
| 2007-10-12 08:20:00 | AAPL | Stock | 5.8125 | 5.8161 | 5.7929 | 5.7946 | 783720.0 |
| 2007-10-12 08:25:00 | AAPL | Stock | 5.7968 | 5.82 | 5.7929 | 5.8143 | 598976.0 |
| 2007-10-12 08:30:00 | AAPL | Stock | 5.8143 | 5.8336 | 5.8143 | 5.8264 | 1476664.0 |
| 2007-10-12 08:35:00 | AAPL | Stock | 5.8264 | 5.8286 | 5.8211 | 5.8286 | 1187984.0 |
| 2007-10-12 08:40:00 | AAPL | Stock | 5.8321 | 5.8375 | 5.8271 | 5.8321 | 669396.0 |
| 2007-10-12 08:45:00 | AAPL | Stock | 5.8332 | 5.875 | 5.8321 | 5.8614 | 1472128.0 |
| 2007-10-12 08:50:00 | AAPL | Stock | 5.8614 | 5.8818 | 5.8614 | 5.875 | 1537032.0 |
| 2007-10-12 08:55:00 | AAPL | Stock | 5.875 | 5.8836 | 5.8639 | 5.8711 | 1350580.0 |
| 2007-10-12 09:00:00 | AAPL | Stock | 5.8714 | 5.8714 | 5.8518 | 5.8518 | 740796.0 |
| 2007-10-12 09:05:00 | AAPL | Stock | 5.8532 | 5.8636 | 5.8464 | 5.8611 | 1577968.0 |
| 2007-10-12 09:10:00 | AAPL | Stock | 5.8611 | 5.8643 | 5.8393 | 5.8464 | 1378272.0 |
| 2007-10-12 09:15:00 | AAPL | Stock | 5.8464 | 5.8464 | 5.8321 | 5.8321 | 1089256.0 |
| 2007-10-12 09:20:00 | AAPL | Stock | 5.8321 | 5.8429 | 5.8321 | 5.8407 | 1142176.0 |
| 2007-10-12 09:25:00 | AAPL | Stock | 5.8429 | 5.8429 | 5.8204 | 5.8225 | 1616748.0 |
| 2007-10-12 09:30:00 | AAPL | Stock | 5.8221 | 5.8339 | 5.7786 | 5.8032 | 40488336.0 |
| 2007-10-12 09:35:00 | AAPL | Stock | 5.8032 | 5.8632 | 5.8021 | 5.8498 | 33137496.0 |
| 2007-10-12 09:40:00 | AAPL | Stock | 5.85 | 5.8754 | 5.8393 | 5.8564 | 32093208.0 |
| 2007-10-12 09:45:00 | AAPL | Stock | 5.8568 | 5.8657 | 5.8379 | 5.8643 | 20123180.0 |
| 2007-10-12 09:50:00 | AAPL | Stock | 5.8643 | 5.8714 | 5.8482 | 5.86 | 19108012.0 |
| 2007-10-12 09:55:00 | AAPL | Stock | 5.8596 | 5.865 | 5.8457 | 5.8579 | 15314712.0 |
| 2007-10-12 10:00:00 | AAPL | Stock | 5.8586 | 5.8843 | 5.8414 | 5.8775 | 25166932.0 |
| 2007-10-12 10:05:00 | AAPL | Stock | 5.8775 | 5.9246 | 5.8768 | 5.9157 | 35808640.0 |
| 2007-10-12 10:10:00 | AAPL | Stock | 5.917 | 5.9243 | 5.9057 | 5.9107 | 19707380.0 |
| 2007-10-12 10:15:00 | AAPL | Stock | 5.9107 | 5.9443 | 5.905 | 5.9239 | 28885220.0 |
| 2007-10-12 10:20:00 | AAPL | Stock | 5.9246 | 5.9461 | 5.9161 | 5.9393 | 22717856.0 |
| 2007-10-12 10:25:00 | AAPL | Stock | 5.9393 | 5.9418 | 5.9236 | 5.9361 | 17288124.0 |
| 2007-10-12 10:30:00 | AAPL | Stock | 5.9354 | 5.9554 | 5.9346 | 5.9371 | 21019152.0 |
| 2007-10-12 10:35:00 | AAPL | Stock | 5.9375 | 5.9407 | 5.9189 | 5.9204 | 16507708.0 |
| 2007-10-12 10:40:00 | AAPL | Stock | 5.92 | 5.9275 | 5.9107 | 5.9217 | 17032960.0 |
| 2007-10-12 10:45:00 | AAPL | Stock | 5.9218 | 5.9425 | 5.9161 | 5.93 | 12640880.0 |
| 2007-10-12 10:50:00 | AAPL | Stock | 5.9306 | 5.9411 | 5.9221 | 5.9257 | 9960664.0 |
| 2007-10-12 10:55:00 | AAPL | Stock | 5.9261 | 5.9368 | 5.9218 | 5.9357 | 5400360.0 |
| 2007-10-12 11:00:00 | AAPL | Stock | 5.9357 | 5.9618 | 5.9339 | 5.9554 | 17469844.0 |
| 2007-10-12 11:05:00 | AAPL | Stock | 5.9561 | 5.9593 | 5.9393 | 5.9432 | 17089436.0 |
| 2007-10-12 11:10:00 | AAPL | Stock | 5.9434 | 5.9525 | 5.9339 | 5.9411 | 6876744.0 |
| 2007-10-12 11:15:00 | AAPL | Stock | 5.9411 | 5.9464 | 5.9232 | 5.9286 | 9860872.0 |
> showing 50 of 298,982 rows — these rows as CSV