PREVIEW / stock_5min / 2008-03-28
file: by_date/stock_5min/2008/2008-03-28.parquet size: 4.2 MB rows: 306,962 symbols: 3,280
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-28 04:20:00 | AAPL | Stock | 5.0393 | 5.0393 | 5.0393 | 5.0393 | 5600.0 |
| 2008-03-28 04:45:00 | AAPL | Stock | 5.0393 | 5.0393 | 5.0393 | 5.0393 | 5600.0 |
| 2008-03-28 05:25:00 | AAPL | Stock | 5.0761 | 5.0761 | 5.0761 | 5.0761 | 14000.0 |
| 2008-03-28 06:00:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0818 | 5.0818 | 2800.0 |
| 2008-03-28 06:05:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0818 | 5.0818 | 2800.0 |
| 2008-03-28 06:25:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 14000.0 |
| 2008-03-28 06:35:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 5600.0 |
| 2008-03-28 06:55:00 | AAPL | Stock | 5.0671 | 5.0671 | 5.0393 | 5.0411 | 88760.0 |
| 2008-03-28 07:00:00 | AAPL | Stock | 5.08 | 5.08 | 5.08 | 5.08 | 5600.0 |
| 2008-03-28 07:15:00 | AAPL | Stock | 5.0711 | 5.0782 | 5.0711 | 5.0782 | 138040.0 |
| 2008-03-28 07:25:00 | AAPL | Stock | 5.075 | 5.075 | 5.075 | 5.075 | 19600.0 |
| 2008-03-28 07:30:00 | AAPL | Stock | 5.0893 | 5.09 | 5.0893 | 5.09 | 25396.0 |
| 2008-03-28 07:35:00 | AAPL | Stock | 5.0911 | 5.0911 | 5.0882 | 5.0886 | 39200.0 |
| 2008-03-28 07:45:00 | AAPL | Stock | 5.0814 | 5.0814 | 5.0814 | 5.0814 | 2800.0 |
| 2008-03-28 07:50:00 | AAPL | Stock | 5.0893 | 5.0964 | 5.0893 | 5.0964 | 27524.0 |
| 2008-03-28 07:55:00 | AAPL | Stock | 5.0814 | 5.0821 | 5.0607 | 5.0807 | 55580.0 |
| 2008-03-28 08:00:00 | AAPL | Stock | 5.0821 | 5.0871 | 5.0643 | 5.0643 | 461272.0 |
| 2008-03-28 08:05:00 | AAPL | Stock | 5.0643 | 5.0714 | 5.0643 | 5.0714 | 131628.0 |
| 2008-03-28 08:10:00 | AAPL | Stock | 5.0714 | 5.0732 | 5.0661 | 5.0671 | 135716.0 |
| 2008-03-28 08:15:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0661 | 5.0714 | 128100.0 |
| 2008-03-28 08:20:00 | AAPL | Stock | 5.0711 | 5.0746 | 5.07 | 5.0746 | 144200.0 |
| 2008-03-28 08:25:00 | AAPL | Stock | 5.0736 | 5.0739 | 5.0679 | 5.0679 | 331128.0 |
| 2008-03-28 08:30:00 | AAPL | Stock | 5.0718 | 5.0893 | 5.0668 | 5.0714 | 1356208.0 |
| 2008-03-28 08:35:00 | AAPL | Stock | 5.0711 | 5.0721 | 5.0679 | 5.0689 | 495964.0 |
| 2008-03-28 08:40:00 | AAPL | Stock | 5.0707 | 5.0714 | 5.0664 | 5.0682 | 378196.0 |
| 2008-03-28 08:45:00 | AAPL | Stock | 5.0664 | 5.0689 | 5.0643 | 5.0682 | 191100.0 |
| 2008-03-28 08:50:00 | AAPL | Stock | 5.0661 | 5.0689 | 5.0614 | 5.0668 | 240884.0 |
| 2008-03-28 08:55:00 | AAPL | Stock | 5.0679 | 5.0721 | 5.0668 | 5.0668 | 428092.0 |
| 2008-03-28 09:00:00 | AAPL | Stock | 5.0661 | 5.0661 | 5.0575 | 5.0575 | 194740.0 |
| 2008-03-28 09:05:00 | AAPL | Stock | 5.0575 | 5.0604 | 5.0539 | 5.0579 | 158200.0 |
| 2008-03-28 09:10:00 | AAPL | Stock | 5.0579 | 5.0621 | 5.0482 | 5.0618 | 590352.0 |
| 2008-03-28 09:15:00 | AAPL | Stock | 5.0557 | 5.0618 | 5.0536 | 5.0564 | 222600.0 |
| 2008-03-28 09:20:00 | AAPL | Stock | 5.055 | 5.0571 | 5.055 | 5.0571 | 669200.0 |
| 2008-03-28 09:25:00 | AAPL | Stock | 5.0571 | 5.0646 | 5.0564 | 5.0639 | 837200.0 |
| 2008-03-28 09:30:00 | AAPL | Stock | 5.0643 | 5.1064 | 5.0571 | 5.0996 | 27886460.0 |
| 2008-03-28 09:35:00 | AAPL | Stock | 5.0989 | 5.1129 | 5.0914 | 5.1018 | 22978564.0 |
| 2008-03-28 09:40:00 | AAPL | Stock | 5.1021 | 5.1029 | 5.0786 | 5.0982 | 18036676.0 |
| 2008-03-28 09:45:00 | AAPL | Stock | 5.0982 | 5.1 | 5.0839 | 5.0946 | 19040896.0 |
| 2008-03-28 09:50:00 | AAPL | Stock | 5.0947 | 5.1068 | 5.0921 | 5.1057 | 21019040.0 |
| 2008-03-28 09:55:00 | AAPL | Stock | 5.1057 | 5.125 | 5.1054 | 5.1157 | 22951040.0 |
| 2008-03-28 10:00:00 | AAPL | Stock | 5.1154 | 5.1374 | 5.1102 | 5.1304 | 19047532.0 |
| 2008-03-28 10:05:00 | AAPL | Stock | 5.1311 | 5.1421 | 5.1289 | 5.1361 | 12740896.0 |
| 2008-03-28 10:10:00 | AAPL | Stock | 5.1361 | 5.1386 | 5.1196 | 5.1254 | 12862724.0 |
| 2008-03-28 10:15:00 | AAPL | Stock | 5.1246 | 5.1257 | 5.1089 | 5.1174 | 11124848.0 |
| 2008-03-28 10:20:00 | AAPL | Stock | 5.1175 | 5.1257 | 5.1121 | 5.1248 | 12231044.0 |
| 2008-03-28 10:25:00 | AAPL | Stock | 5.1257 | 5.1304 | 5.1157 | 5.1246 | 9744840.0 |
| 2008-03-28 10:30:00 | AAPL | Stock | 5.1243 | 5.1375 | 5.1211 | 5.1301 | 8452472.0 |
| 2008-03-28 10:35:00 | AAPL | Stock | 5.1314 | 5.1354 | 5.1107 | 5.1111 | 10930696.0 |
| 2008-03-28 10:40:00 | AAPL | Stock | 5.1111 | 5.1143 | 5.0993 | 5.1018 | 15596252.0 |
| 2008-03-28 10:45:00 | AAPL | Stock | 5.1025 | 5.1214 | 5.0989 | 5.1168 | 10737776.0 |
> showing 50 of 306,962 rows — these rows as CSV