PREVIEW / stock_5min / 2011-05-03
file: by_date/stock_5min/2011/2011-05-03.parquet size: 5.0 MB rows: 338,522 symbols: 3,560
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-05-03 04:00:00 | AAPL | Stock | 12.3493 | 12.3507 | 12.3493 | 12.3507 | 5600.0 |
| 2011-05-03 04:40:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 04:50:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 5600.0 |
| 2011-05-03 05:35:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 5600.0 |
| 2011-05-03 06:00:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 8400.0 |
| 2011-05-03 06:10:00 | AAPL | Stock | 12.3404 | 12.3404 | 12.3404 | 12.3404 | 2800.0 |
| 2011-05-03 06:35:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 5600.0 |
| 2011-05-03 06:40:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 06:45:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 06:50:00 | AAPL | Stock | 12.3254 | 12.3254 | 12.3254 | 12.3254 | 2800.0 |
| 2011-05-03 06:55:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 13160.0 |
| 2011-05-03 07:00:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-05-03 07:05:00 | AAPL | Stock | 12.3311 | 12.3311 | 12.3311 | 12.3311 | 5600.0 |
| 2011-05-03 07:15:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 2800.0 |
| 2011-05-03 07:20:00 | AAPL | Stock | 12.3396 | 12.3396 | 12.3379 | 12.3393 | 28000.0 |
| 2011-05-03 07:40:00 | AAPL | Stock | 12.3393 | 12.3443 | 12.3393 | 12.3443 | 8400.0 |
| 2011-05-03 07:50:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3411 | 12.3411 | 9800.0 |
| 2011-05-03 07:55:00 | AAPL | Stock | 12.3496 | 12.35 | 12.3411 | 12.3411 | 20132.0 |
| 2011-05-03 08:00:00 | AAPL | Stock | 12.35 | 12.3904 | 12.35 | 12.3821 | 321664.0 |
| 2011-05-03 08:05:00 | AAPL | Stock | 12.3857 | 12.4104 | 12.3754 | 12.3839 | 208768.0 |
| 2011-05-03 08:10:00 | AAPL | Stock | 12.3946 | 12.4029 | 12.3911 | 12.3964 | 84532.0 |
| 2011-05-03 08:15:00 | AAPL | Stock | 12.3946 | 12.4029 | 12.3929 | 12.3929 | 92288.0 |
| 2011-05-03 08:20:00 | AAPL | Stock | 12.3964 | 12.4018 | 12.3964 | 12.3989 | 54180.0 |
| 2011-05-03 08:25:00 | AAPL | Stock | 12.3964 | 12.4 | 12.3964 | 12.3964 | 70812.0 |
| 2011-05-03 08:30:00 | AAPL | Stock | 12.3964 | 12.4 | 12.3843 | 12.3843 | 174720.0 |
| 2011-05-03 08:35:00 | AAPL | Stock | 12.3875 | 12.3875 | 12.3875 | 12.3875 | 5600.0 |
| 2011-05-03 08:40:00 | AAPL | Stock | 12.3875 | 12.3911 | 12.3868 | 12.3875 | 58800.0 |
| 2011-05-03 08:45:00 | AAPL | Stock | 12.3875 | 12.39 | 12.3875 | 12.39 | 14000.0 |
| 2011-05-03 08:50:00 | AAPL | Stock | 12.3896 | 12.39 | 12.3875 | 12.3886 | 50400.0 |
| 2011-05-03 08:55:00 | AAPL | Stock | 12.3889 | 12.3946 | 12.3889 | 12.3946 | 252532.0 |
| 2011-05-03 09:00:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3821 | 12.3821 | 50400.0 |
| 2011-05-03 09:05:00 | AAPL | Stock | 12.3832 | 12.3911 | 12.3811 | 12.3836 | 64848.0 |
| 2011-05-03 09:10:00 | AAPL | Stock | 12.3886 | 12.3929 | 12.3864 | 12.3918 | 50064.0 |
| 2011-05-03 09:15:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3864 | 12.3864 | 17136.0 |
| 2011-05-03 09:20:00 | AAPL | Stock | 12.3889 | 12.3893 | 12.3864 | 12.3889 | 79940.0 |
| 2011-05-03 09:25:00 | AAPL | Stock | 12.3889 | 12.4282 | 12.3879 | 12.4282 | 652064.0 |
| 2011-05-03 09:30:00 | AAPL | Stock | 12.4282 | 12.4571 | 12.4021 | 12.4539 | 15491868.0 |
| 2011-05-03 09:35:00 | AAPL | Stock | 12.4504 | 12.4846 | 12.45 | 12.4825 | 11926460.0 |
| 2011-05-03 09:40:00 | AAPL | Stock | 12.4821 | 12.4857 | 12.4507 | 12.4643 | 10245424.0 |
| 2011-05-03 09:45:00 | AAPL | Stock | 12.4621 | 12.475 | 12.4457 | 12.4746 | 8217468.0 |
| 2011-05-03 09:50:00 | AAPL | Stock | 12.4746 | 12.4839 | 12.465 | 12.4802 | 8414224.0 |
| 2011-05-03 09:55:00 | AAPL | Stock | 12.4804 | 12.4961 | 12.4775 | 12.4796 | 9830884.0 |
| 2011-05-03 10:00:00 | AAPL | Stock | 12.4818 | 12.4939 | 12.47 | 12.4718 | 5743164.0 |
| 2011-05-03 10:05:00 | AAPL | Stock | 12.4729 | 12.4832 | 12.451 | 12.4557 | 5871320.0 |
| 2011-05-03 10:10:00 | AAPL | Stock | 12.4568 | 12.4643 | 12.4479 | 12.463 | 4805332.0 |
| 2011-05-03 10:15:00 | AAPL | Stock | 12.4639 | 12.4746 | 12.4507 | 12.4521 | 3616956.0 |
| 2011-05-03 10:20:00 | AAPL | Stock | 12.4521 | 12.4568 | 12.4368 | 12.4461 | 5661460.0 |
| 2011-05-03 10:25:00 | AAPL | Stock | 12.4457 | 12.4511 | 12.4343 | 12.435 | 3244220.0 |
| 2011-05-03 10:30:00 | AAPL | Stock | 12.4358 | 12.4418 | 12.4218 | 12.4339 | 5976600.0 |
| 2011-05-03 10:35:00 | AAPL | Stock | 12.4307 | 12.4346 | 12.4064 | 12.4089 | 5640236.0 |
> showing 50 of 338,522 rows — these rows as CSV