PREVIEW / stock_5min / 2013-05-31
file: by_date/stock_5min/2013/2013-05-31.parquet size: 5.3 MB rows: 348,349 symbols: 3,519
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-31 04:05:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 14000.0 |
| 2013-05-31 04:55:00 | AAPL | Stock | 16.0282 | 16.0282 | 16.0282 | 16.0282 | 13720.0 |
| 2013-05-31 05:20:00 | AAPL | Stock | 16.0289 | 16.0289 | 16.0289 | 16.0289 | 2800.0 |
| 2013-05-31 05:40:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 2800.0 |
| 2013-05-31 05:50:00 | AAPL | Stock | 16.0268 | 16.0268 | 16.0268 | 16.0268 | 14000.0 |
| 2013-05-31 06:00:00 | AAPL | Stock | 16.0268 | 16.0268 | 16.0268 | 16.0268 | 2800.0 |
| 2013-05-31 06:15:00 | AAPL | Stock | 16.0286 | 16.0286 | 16.0286 | 16.0286 | 5600.0 |
| 2013-05-31 06:20:00 | AAPL | Stock | 16.0286 | 16.0286 | 16.0286 | 16.0286 | 11200.0 |
| 2013-05-31 06:35:00 | AAPL | Stock | 16.0357 | 16.0504 | 16.0357 | 16.0504 | 5600.0 |
| 2013-05-31 06:40:00 | AAPL | Stock | 16.0361 | 16.0361 | 16.0361 | 16.0361 | 2800.0 |
| 2013-05-31 06:55:00 | AAPL | Stock | 16.0286 | 16.0307 | 16.0286 | 16.0286 | 8400.0 |
| 2013-05-31 07:00:00 | AAPL | Stock | 16.0357 | 16.0714 | 16.0357 | 16.0625 | 35000.0 |
| 2013-05-31 07:05:00 | AAPL | Stock | 16.0696 | 16.0932 | 16.0696 | 16.0714 | 55300.0 |
| 2013-05-31 07:15:00 | AAPL | Stock | 16.0621 | 16.0621 | 16.0621 | 16.0621 | 2800.0 |
| 2013-05-31 07:20:00 | AAPL | Stock | 16.0714 | 16.0714 | 16.0714 | 16.0714 | 2800.0 |
| 2013-05-31 07:25:00 | AAPL | Stock | 16.0721 | 16.1064 | 16.0696 | 16.0964 | 60312.0 |
| 2013-05-31 07:30:00 | AAPL | Stock | 16.1054 | 16.1054 | 16.0964 | 16.0964 | 28000.0 |
| 2013-05-31 07:35:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 2800.0 |
| 2013-05-31 07:40:00 | AAPL | Stock | 16.0732 | 16.0732 | 16.0639 | 16.0696 | 25200.0 |
| 2013-05-31 07:45:00 | AAPL | Stock | 16.0889 | 16.0889 | 16.0889 | 16.0889 | 3640.0 |
| 2013-05-31 07:50:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0829 | 16.0829 | 14000.0 |
| 2013-05-31 07:55:00 | AAPL | Stock | 16.0757 | 16.0757 | 16.0668 | 16.0668 | 19600.0 |
| 2013-05-31 08:00:00 | AAPL | Stock | 16.0789 | 16.1429 | 16.0289 | 16.0746 | 449904.0 |
| 2013-05-31 08:05:00 | AAPL | Stock | 16.0739 | 16.0786 | 16.0586 | 16.0782 | 92960.0 |
| 2013-05-31 08:10:00 | AAPL | Stock | 16.0589 | 16.0757 | 16.0589 | 16.0757 | 25088.0 |
| 2013-05-31 08:15:00 | AAPL | Stock | 16.0786 | 16.0864 | 16.0764 | 16.0825 | 31248.0 |
| 2013-05-31 08:20:00 | AAPL | Stock | 16.0889 | 16.0979 | 16.0579 | 16.0579 | 193284.0 |
| 2013-05-31 08:25:00 | AAPL | Stock | 16.0696 | 16.0707 | 16.0593 | 16.0707 | 88340.0 |
| 2013-05-31 08:30:00 | AAPL | Stock | 16.0607 | 16.075 | 16.0482 | 16.0586 | 320264.0 |
| 2013-05-31 08:35:00 | AAPL | Stock | 16.0582 | 16.1 | 16.0571 | 16.0754 | 399056.0 |
| 2013-05-31 08:40:00 | AAPL | Stock | 16.0893 | 16.1032 | 16.0893 | 16.1032 | 77700.0 |
| 2013-05-31 08:45:00 | AAPL | Stock | 16.1032 | 16.1246 | 16.1014 | 16.1018 | 187600.0 |
| 2013-05-31 08:50:00 | AAPL | Stock | 16.1068 | 16.1136 | 16.1036 | 16.1086 | 93660.0 |
| 2013-05-31 08:55:00 | AAPL | Stock | 16.1061 | 16.1143 | 16.1021 | 16.1143 | 115444.0 |
| 2013-05-31 09:00:00 | AAPL | Stock | 16.1143 | 16.1229 | 16.1096 | 16.1096 | 129332.0 |
| 2013-05-31 09:05:00 | AAPL | Stock | 16.1146 | 16.1196 | 16.1096 | 16.1136 | 322028.0 |
| 2013-05-31 09:10:00 | AAPL | Stock | 16.1193 | 16.1425 | 16.1193 | 16.1254 | 273868.0 |
| 2013-05-31 09:15:00 | AAPL | Stock | 16.1304 | 16.1664 | 16.1293 | 16.1507 | 659036.0 |
| 2013-05-31 09:20:00 | AAPL | Stock | 16.1539 | 16.1586 | 16.1471 | 16.1546 | 108192.0 |
| 2013-05-31 09:25:00 | AAPL | Stock | 16.1532 | 16.1671 | 16.1489 | 16.1611 | 543844.0 |
| 2013-05-31 09:30:00 | AAPL | Stock | 16.1607 | 16.2418 | 16.1589 | 16.2375 | 18363016.0 |
| 2013-05-31 09:35:00 | AAPL | Stock | 16.2354 | 16.2496 | 16.2064 | 16.2289 | 11454212.0 |
| 2013-05-31 09:40:00 | AAPL | Stock | 16.2279 | 16.2332 | 16.1907 | 16.2204 | 8645532.0 |
| 2013-05-31 09:45:00 | AAPL | Stock | 16.2246 | 16.2475 | 16.2032 | 16.2446 | 7441140.0 |
| 2013-05-31 09:50:00 | AAPL | Stock | 16.2421 | 16.2961 | 16.2418 | 16.2761 | 14940492.0 |
| 2013-05-31 09:55:00 | AAPL | Stock | 16.2716 | 16.2809 | 16.2425 | 16.2564 | 6112596.0 |
| 2013-05-31 10:00:00 | AAPL | Stock | 16.2579 | 16.3011 | 16.2579 | 16.2884 | 8203804.0 |
| 2013-05-31 10:05:00 | AAPL | Stock | 16.2895 | 16.2943 | 16.2532 | 16.2661 | 7235144.0 |
| 2013-05-31 10:10:00 | AAPL | Stock | 16.2654 | 16.2764 | 16.2404 | 16.2539 | 5933872.0 |
| 2013-05-31 10:15:00 | AAPL | Stock | 16.25 | 16.2589 | 16.235 | 16.2483 | 6341244.0 |
> showing 50 of 348,349 rows — these rows as CSV