PREVIEW / stock_5min / 2011-08-10
file: by_date/stock_5min/2011/2011-08-10.parquet size: 5.3 MB rows: 355,318 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-10 04:00:00 | AAPL | Stock | 13.4957 | 13.4986 | 13.4954 | 13.4986 | 8400.0 |
| 2011-08-10 04:05:00 | AAPL | Stock | 13.4725 | 13.4725 | 13.4643 | 13.4643 | 16800.0 |
| 2011-08-10 04:15:00 | AAPL | Stock | 13.4489 | 13.4489 | 13.4489 | 13.4489 | 2800.0 |
| 2011-08-10 04:25:00 | AAPL | Stock | 13.4375 | 13.4375 | 13.4375 | 13.4375 | 2800.0 |
| 2011-08-10 04:30:00 | AAPL | Stock | 13.4464 | 13.4818 | 13.4464 | 13.4818 | 5600.0 |
| 2011-08-10 04:35:00 | AAPL | Stock | 13.4521 | 13.4521 | 13.4464 | 13.4464 | 16800.0 |
| 2011-08-10 04:40:00 | AAPL | Stock | 13.4443 | 13.4454 | 13.4443 | 13.4446 | 22400.0 |
| 2011-08-10 04:45:00 | AAPL | Stock | 13.4643 | 13.4643 | 13.4643 | 13.4643 | 2800.0 |
| 2011-08-10 05:00:00 | AAPL | Stock | 13.4686 | 13.4821 | 13.4639 | 13.4821 | 30800.0 |
| 2011-08-10 05:05:00 | AAPL | Stock | 13.5057 | 13.5057 | 13.4786 | 13.4832 | 31920.0 |
| 2011-08-10 05:15:00 | AAPL | Stock | 13.4836 | 13.5 | 13.4836 | 13.5 | 34720.0 |
| 2011-08-10 05:20:00 | AAPL | Stock | 13.4893 | 13.5071 | 13.4893 | 13.5071 | 11200.0 |
| 2011-08-10 05:25:00 | AAPL | Stock | 13.5214 | 13.5214 | 13.5214 | 13.5214 | 11200.0 |
| 2011-08-10 05:30:00 | AAPL | Stock | 13.5211 | 13.5211 | 13.5211 | 13.5211 | 2800.0 |
| 2011-08-10 05:35:00 | AAPL | Stock | 13.5 | 13.5357 | 13.5 | 13.5357 | 5600.0 |
| 2011-08-10 05:55:00 | AAPL | Stock | 13.5143 | 13.5143 | 13.5143 | 13.5143 | 2800.0 |
| 2011-08-10 06:00:00 | AAPL | Stock | 13.4936 | 13.5007 | 13.4929 | 13.5007 | 24640.0 |
| 2011-08-10 06:05:00 | AAPL | Stock | 13.5 | 13.5 | 13.5 | 13.5 | 28000.0 |
| 2011-08-10 06:10:00 | AAPL | Stock | 13.4946 | 13.4996 | 13.4929 | 13.4996 | 14000.0 |
| 2011-08-10 06:20:00 | AAPL | Stock | 13.4825 | 13.4986 | 13.4818 | 13.4818 | 44744.0 |
| 2011-08-10 06:25:00 | AAPL | Stock | 13.4911 | 13.4993 | 13.4911 | 13.4993 | 9100.0 |
| 2011-08-10 06:30:00 | AAPL | Stock | 13.4996 | 13.4996 | 13.4996 | 13.4996 | 5600.0 |
| 2011-08-10 06:35:00 | AAPL | Stock | 13.4857 | 13.5 | 13.4857 | 13.5 | 11872.0 |
| 2011-08-10 06:45:00 | AAPL | Stock | 13.4996 | 13.4996 | 13.4996 | 13.4996 | 2800.0 |
| 2011-08-10 06:50:00 | AAPL | Stock | 13.4921 | 13.4921 | 13.4921 | 13.4921 | 5600.0 |
| 2011-08-10 06:55:00 | AAPL | Stock | 13.4979 | 13.4979 | 13.4554 | 13.4954 | 60340.0 |
| 2011-08-10 07:00:00 | AAPL | Stock | 13.4821 | 13.4911 | 13.4311 | 13.4343 | 188244.0 |
| 2011-08-10 07:05:00 | AAPL | Stock | 13.4329 | 13.4582 | 13.4089 | 13.4182 | 182644.0 |
| 2011-08-10 07:10:00 | AAPL | Stock | 13.4179 | 13.4257 | 13.4032 | 13.4107 | 48300.0 |
| 2011-08-10 07:15:00 | AAPL | Stock | 13.4254 | 13.4254 | 13.3929 | 13.3929 | 49280.0 |
| 2011-08-10 07:20:00 | AAPL | Stock | 13.3993 | 13.3993 | 13.3518 | 13.3568 | 190568.0 |
| 2011-08-10 07:25:00 | AAPL | Stock | 13.3564 | 13.3575 | 13.34 | 13.3457 | 100744.0 |
| 2011-08-10 07:30:00 | AAPL | Stock | 13.3446 | 13.3696 | 13.3375 | 13.3696 | 40600.0 |
| 2011-08-10 07:35:00 | AAPL | Stock | 13.3886 | 13.3929 | 13.3718 | 13.3929 | 141932.0 |
| 2011-08-10 07:40:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3043 | 13.3043 | 340816.0 |
| 2011-08-10 07:45:00 | AAPL | Stock | 13.3607 | 13.4004 | 13.3504 | 13.37 | 158480.0 |
| 2011-08-10 07:50:00 | AAPL | Stock | 13.375 | 13.3854 | 13.3682 | 13.3682 | 70000.0 |
| 2011-08-10 07:55:00 | AAPL | Stock | 13.3768 | 13.3768 | 13.3493 | 13.3493 | 64400.0 |
| 2011-08-10 08:00:00 | AAPL | Stock | 13.3607 | 13.3839 | 13.3071 | 13.3207 | 676368.0 |
| 2011-08-10 08:05:00 | AAPL | Stock | 13.3129 | 13.3321 | 13.3125 | 13.3271 | 307776.0 |
| 2011-08-10 08:10:00 | AAPL | Stock | 13.3279 | 13.355 | 13.3246 | 13.3496 | 282212.0 |
| 2011-08-10 08:15:00 | AAPL | Stock | 13.3457 | 13.35 | 13.2939 | 13.3 | 461860.0 |
| 2011-08-10 08:20:00 | AAPL | Stock | 13.2996 | 13.3036 | 13.2779 | 13.2825 | 814884.0 |
| 2011-08-10 08:25:00 | AAPL | Stock | 13.2814 | 13.2971 | 13.2768 | 13.28 | 786660.0 |
| 2011-08-10 08:30:00 | AAPL | Stock | 13.2818 | 13.2857 | 13.2579 | 13.275 | 576072.0 |
| 2011-08-10 08:35:00 | AAPL | Stock | 13.2682 | 13.2836 | 13.25 | 13.2511 | 405860.0 |
| 2011-08-10 08:40:00 | AAPL | Stock | 13.2514 | 13.2625 | 13.2236 | 13.2379 | 937664.0 |
| 2011-08-10 08:45:00 | AAPL | Stock | 13.2429 | 13.2596 | 13.2325 | 13.2414 | 564676.0 |
| 2011-08-10 08:50:00 | AAPL | Stock | 13.2375 | 13.2439 | 13.2068 | 13.2296 | 1068060.0 |
| 2011-08-10 08:55:00 | AAPL | Stock | 13.2382 | 13.2404 | 13.2054 | 13.2107 | 1068396.0 |
> showing 50 of 355,318 rows — these rows as CSV