PREVIEW / stock_5min / 2007-11-09
file: by_date/stock_5min/2007/2007-11-09.parquet size: 4.4 MB rows: 319,858 symbols: 3,183
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-11-09 04:00:00 | AAPL | Stock | 6.4371 | 6.4371 | 6.4371 | 6.4371 | 2800.0 |
| 2007-11-09 04:15:00 | AAPL | Stock | 6.415 | 6.4482 | 6.4132 | 6.4429 | 30800.0 |
| 2007-11-09 04:20:00 | AAPL | Stock | 6.4418 | 6.4418 | 6.4393 | 6.4393 | 14000.0 |
| 2007-11-09 04:25:00 | AAPL | Stock | 6.4136 | 6.4136 | 6.4107 | 6.4107 | 66444.0 |
| 2007-11-09 04:30:00 | AAPL | Stock | 6.4032 | 6.4057 | 6.4032 | 6.4036 | 70560.0 |
| 2007-11-09 04:40:00 | AAPL | Stock | 6.4014 | 6.4014 | 6.4 | 6.4 | 47600.0 |
| 2007-11-09 04:45:00 | AAPL | Stock | 6.3996 | 6.4114 | 6.3996 | 6.4114 | 28196.0 |
| 2007-11-09 05:00:00 | AAPL | Stock | 6.4079 | 6.4079 | 6.4 | 6.4 | 22400.0 |
| 2007-11-09 05:05:00 | AAPL | Stock | 6.3843 | 6.3843 | 6.3825 | 6.3825 | 8400.0 |
| 2007-11-09 05:10:00 | AAPL | Stock | 6.3971 | 6.3971 | 6.3971 | 6.3971 | 2800.0 |
| 2007-11-09 05:15:00 | AAPL | Stock | 6.3882 | 6.3964 | 6.375 | 6.375 | 28000.0 |
| 2007-11-09 05:20:00 | AAPL | Stock | 6.3839 | 6.3839 | 6.375 | 6.375 | 8400.0 |
| 2007-11-09 05:25:00 | AAPL | Stock | 6.365 | 6.365 | 6.3607 | 6.3607 | 11200.0 |
| 2007-11-09 05:30:00 | AAPL | Stock | 6.3696 | 6.3696 | 6.3696 | 6.3696 | 2800.0 |
| 2007-11-09 05:40:00 | AAPL | Stock | 6.3604 | 6.3604 | 6.3604 | 6.3604 | 2800.0 |
| 2007-11-09 05:45:00 | AAPL | Stock | 6.345 | 6.345 | 6.3393 | 6.3393 | 44800.0 |
| 2007-11-09 05:50:00 | AAPL | Stock | 6.3293 | 6.3293 | 6.3293 | 6.3293 | 2800.0 |
| 2007-11-09 05:55:00 | AAPL | Stock | 6.3293 | 6.3304 | 6.3293 | 6.3304 | 33600.0 |
| 2007-11-09 06:00:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 11228.0 |
| 2007-11-09 06:10:00 | AAPL | Stock | 6.3443 | 6.3482 | 6.3443 | 6.3482 | 36736.0 |
| 2007-11-09 06:20:00 | AAPL | Stock | 6.3321 | 6.3321 | 6.3243 | 6.3243 | 42000.0 |
| 2007-11-09 06:25:00 | AAPL | Stock | 6.3286 | 6.3486 | 6.3286 | 6.3486 | 19600.0 |
| 2007-11-09 06:30:00 | AAPL | Stock | 6.3532 | 6.3532 | 6.3532 | 6.3532 | 28000.0 |
| 2007-11-09 06:40:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 14000.0 |
| 2007-11-09 06:50:00 | AAPL | Stock | 6.3304 | 6.3304 | 6.3071 | 6.3071 | 56000.0 |
| 2007-11-09 06:55:00 | AAPL | Stock | 6.3039 | 6.3039 | 6.3039 | 6.3039 | 5600.0 |
| 2007-11-09 07:00:00 | AAPL | Stock | 6.3125 | 6.3125 | 6.2575 | 6.2611 | 212800.0 |
| 2007-11-09 07:05:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 28000.0 |
| 2007-11-09 07:10:00 | AAPL | Stock | 6.2679 | 6.3161 | 6.2679 | 6.3161 | 41720.0 |
| 2007-11-09 07:15:00 | AAPL | Stock | 6.2946 | 6.2946 | 6.2679 | 6.2679 | 33656.0 |
| 2007-11-09 07:20:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 28000.0 |
| 2007-11-09 07:25:00 | AAPL | Stock | 6.275 | 6.2821 | 6.275 | 6.2821 | 58800.0 |
| 2007-11-09 07:30:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2754 | 6.2754 | 30800.0 |
| 2007-11-09 07:35:00 | AAPL | Stock | 6.275 | 6.2768 | 6.275 | 6.2768 | 7224.0 |
| 2007-11-09 07:40:00 | AAPL | Stock | 6.275 | 6.275 | 6.2614 | 6.2714 | 426972.0 |
| 2007-11-09 07:45:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2593 | 6.2607 | 95200.0 |
| 2007-11-09 07:50:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2489 | 6.2489 | 35840.0 |
| 2007-11-09 07:55:00 | AAPL | Stock | 6.2582 | 6.2607 | 6.2393 | 6.2607 | 48244.0 |
| 2007-11-09 08:00:00 | AAPL | Stock | 6.2536 | 6.26 | 6.1964 | 6.2096 | 1621648.0 |
| 2007-11-09 08:05:00 | AAPL | Stock | 6.2132 | 6.2286 | 6.1821 | 6.2018 | 765072.0 |
| 2007-11-09 08:10:00 | AAPL | Stock | 6.205 | 6.2089 | 6.1661 | 6.1786 | 628908.0 |
| 2007-11-09 08:15:00 | AAPL | Stock | 6.1875 | 6.1875 | 6.1707 | 6.1754 | 716772.0 |
| 2007-11-09 08:20:00 | AAPL | Stock | 6.1682 | 6.175 | 6.1607 | 6.1725 | 692860.0 |
| 2007-11-09 08:25:00 | AAPL | Stock | 6.17 | 6.1868 | 6.1679 | 6.1854 | 1489040.0 |
| 2007-11-09 08:30:00 | AAPL | Stock | 6.1832 | 6.1857 | 6.1168 | 6.1246 | 1534036.0 |
| 2007-11-09 08:35:00 | AAPL | Stock | 6.1246 | 6.1514 | 6.1204 | 6.1407 | 1118600.0 |
| 2007-11-09 08:40:00 | AAPL | Stock | 6.1407 | 6.1429 | 6.125 | 6.1329 | 982744.0 |
| 2007-11-09 08:45:00 | AAPL | Stock | 6.1321 | 6.1429 | 6.0893 | 6.1379 | 1225980.0 |
| 2007-11-09 08:50:00 | AAPL | Stock | 6.1425 | 6.1429 | 6.1214 | 6.1332 | 537096.0 |
| 2007-11-09 08:55:00 | AAPL | Stock | 6.1321 | 6.1614 | 6.1214 | 6.1571 | 659960.0 |
> showing 50 of 319,858 rows — these rows as CSV