PREVIEW / stock_5min / 2010-02-25
file: by_date/stock_5min/2010/2010-02-25.parquet size: 4.6 MB rows: 318,026 symbols: 3,439
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-02-25 04:25:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2010-02-25 04:55:00 | AAPL | Stock | 7.1361 | 7.1361 | 7.1361 | 7.1361 | 2800.0 |
| 2010-02-25 06:40:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1339 | 7.1339 | 5600.0 |
| 2010-02-25 07:05:00 | AAPL | Stock | 7.1346 | 7.1346 | 7.1346 | 7.1346 | 14000.0 |
| 2010-02-25 07:20:00 | AAPL | Stock | 7.1364 | 7.1364 | 7.1329 | 7.1329 | 10640.0 |
| 2010-02-25 07:35:00 | AAPL | Stock | 7.1271 | 7.1286 | 7.1271 | 7.1271 | 17360.0 |
| 2010-02-25 07:40:00 | AAPL | Stock | 7.1275 | 7.1275 | 7.1254 | 7.1254 | 9968.0 |
| 2010-02-25 07:50:00 | AAPL | Stock | 7.1246 | 7.1246 | 7.1246 | 7.1246 | 2800.0 |
| 2010-02-25 07:55:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 5600.0 |
| 2010-02-25 08:00:00 | AAPL | Stock | 7.125 | 7.1304 | 7.1182 | 7.1257 | 153244.0 |
| 2010-02-25 08:05:00 | AAPL | Stock | 7.1261 | 7.1261 | 7.125 | 7.1257 | 48580.0 |
| 2010-02-25 08:10:00 | AAPL | Stock | 7.1268 | 7.1361 | 7.1257 | 7.13 | 74200.0 |
| 2010-02-25 08:15:00 | AAPL | Stock | 7.135 | 7.1364 | 7.13 | 7.1304 | 39340.0 |
| 2010-02-25 08:20:00 | AAPL | Stock | 7.1296 | 7.1296 | 7.1257 | 7.1286 | 149296.0 |
| 2010-02-25 08:25:00 | AAPL | Stock | 7.1282 | 7.1314 | 7.1218 | 7.1296 | 397320.0 |
| 2010-02-25 08:30:00 | AAPL | Stock | 7.1271 | 7.1307 | 7.1071 | 7.1096 | 534436.0 |
| 2010-02-25 08:35:00 | AAPL | Stock | 7.1107 | 7.1143 | 7.1039 | 7.1071 | 270424.0 |
| 2010-02-25 08:40:00 | AAPL | Stock | 7.1064 | 7.1064 | 7.1 | 7.1 | 334264.0 |
| 2010-02-25 08:45:00 | AAPL | Stock | 7.0996 | 7.1043 | 7.0996 | 7.1036 | 234304.0 |
| 2010-02-25 08:50:00 | AAPL | Stock | 7.1018 | 7.1036 | 7.1018 | 7.1021 | 68740.0 |
| 2010-02-25 08:55:00 | AAPL | Stock | 7.1029 | 7.1054 | 7.1007 | 7.1036 | 145432.0 |
| 2010-02-25 09:00:00 | AAPL | Stock | 7.105 | 7.105 | 7.0911 | 7.0929 | 272104.0 |
| 2010-02-25 09:05:00 | AAPL | Stock | 7.0932 | 7.1036 | 7.0911 | 7.0914 | 840420.0 |
| 2010-02-25 09:10:00 | AAPL | Stock | 7.0921 | 7.0975 | 7.0839 | 7.09 | 341572.0 |
| 2010-02-25 09:15:00 | AAPL | Stock | 7.0896 | 7.0896 | 7.0757 | 7.0818 | 337400.0 |
| 2010-02-25 09:20:00 | AAPL | Stock | 7.0825 | 7.0854 | 7.0718 | 7.0732 | 539140.0 |
| 2010-02-25 09:25:00 | AAPL | Stock | 7.0718 | 7.0732 | 7.0464 | 7.0486 | 1506092.0 |
| 2010-02-25 09:30:00 | AAPL | Stock | 7.0486 | 7.0607 | 7.0318 | 7.0489 | 25618068.0 |
| 2010-02-25 09:35:00 | AAPL | Stock | 7.0486 | 7.0768 | 7.0339 | 7.0761 | 16876888.0 |
| 2010-02-25 09:40:00 | AAPL | Stock | 7.0761 | 7.0766 | 7.0568 | 7.0591 | 8784104.0 |
| 2010-02-25 09:45:00 | AAPL | Stock | 7.0582 | 7.0582 | 7.0386 | 7.0486 | 11167716.0 |
| 2010-02-25 09:50:00 | AAPL | Stock | 7.0493 | 7.0711 | 7.0493 | 7.0693 | 10346308.0 |
| 2010-02-25 09:55:00 | AAPL | Stock | 7.0693 | 7.0714 | 7.0546 | 7.0611 | 7536032.0 |
| 2010-02-25 10:00:00 | AAPL | Stock | 7.0614 | 7.0632 | 7.0471 | 7.056 | 6522236.0 |
| 2010-02-25 10:05:00 | AAPL | Stock | 7.0556 | 7.0671 | 7.0554 | 7.06 | 7027608.0 |
| 2010-02-25 10:10:00 | AAPL | Stock | 7.0607 | 7.0789 | 7.0557 | 7.0693 | 12563348.0 |
| 2010-02-25 10:15:00 | AAPL | Stock | 7.0693 | 7.0839 | 7.0646 | 7.0761 | 9189096.0 |
| 2010-02-25 10:20:00 | AAPL | Stock | 7.0761 | 7.0893 | 7.0721 | 7.0732 | 7491904.0 |
| 2010-02-25 10:25:00 | AAPL | Stock | 7.0732 | 7.0736 | 7.0536 | 7.0679 | 9115176.0 |
| 2010-02-25 10:30:00 | AAPL | Stock | 7.0686 | 7.0714 | 7.0579 | 7.0686 | 5099024.0 |
| 2010-02-25 10:35:00 | AAPL | Stock | 7.0686 | 7.0707 | 7.0539 | 7.0564 | 5928160.0 |
| 2010-02-25 10:40:00 | AAPL | Stock | 7.0557 | 7.0593 | 7.0496 | 7.0543 | 7522452.0 |
| 2010-02-25 10:45:00 | AAPL | Stock | 7.0554 | 7.0661 | 7.05 | 7.0646 | 5128872.0 |
| 2010-02-25 10:50:00 | AAPL | Stock | 7.0645 | 7.0711 | 7.0611 | 7.0679 | 3898524.0 |
| 2010-02-25 10:55:00 | AAPL | Stock | 7.0679 | 7.0761 | 7.0607 | 7.0628 | 4152988.0 |
| 2010-02-25 11:00:00 | AAPL | Stock | 7.0614 | 7.0682 | 7.0571 | 7.0625 | 2779112.0 |
| 2010-02-25 11:05:00 | AAPL | Stock | 7.0632 | 7.0793 | 7.0618 | 7.0792 | 4152792.0 |
| 2010-02-25 11:10:00 | AAPL | Stock | 7.0793 | 7.0804 | 7.07 | 7.0711 | 3648708.0 |
| 2010-02-25 11:15:00 | AAPL | Stock | 7.0704 | 7.0721 | 7.0643 | 7.0646 | 2921492.0 |
| 2010-02-25 11:20:00 | AAPL | Stock | 7.0654 | 7.0654 | 7.0571 | 7.0636 | 4525612.0 |
> showing 50 of 318,026 rows — these rows as CSV