PREVIEW / stock_5min / 2012-03-08
file: by_date/stock_5min/2012/2012-03-08.parquet size: 4.8 MB rows: 323,837 symbols: 3,509
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-08 04:00:00 | AAPL | Stock | 19.0064 | 19.0275 | 19.0064 | 19.0275 | 14000.0 |
| 2012-03-08 04:10:00 | AAPL | Stock | 19.0143 | 19.0507 | 19.0143 | 19.0507 | 24500.0 |
| 2012-03-08 04:15:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0536 | 19.0536 | 10220.0 |
| 2012-03-08 04:20:00 | AAPL | Stock | 19.0554 | 19.0554 | 19.0554 | 19.0554 | 14000.0 |
| 2012-03-08 04:25:00 | AAPL | Stock | 19.0482 | 19.0482 | 19.0482 | 19.0482 | 16744.0 |
| 2012-03-08 04:30:00 | AAPL | Stock | 19.0482 | 19.0536 | 19.0482 | 19.0536 | 14000.0 |
| 2012-03-08 04:35:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-03-08 04:45:00 | AAPL | Stock | 19.075 | 19.075 | 19.075 | 19.075 | 2800.0 |
| 2012-03-08 04:55:00 | AAPL | Stock | 19.0696 | 19.0696 | 19.0696 | 19.0696 | 2800.0 |
| 2012-03-08 05:05:00 | AAPL | Stock | 19.0507 | 19.0507 | 19.0507 | 19.0507 | 28000.0 |
| 2012-03-08 05:10:00 | AAPL | Stock | 19.0536 | 19.0607 | 19.0536 | 19.0607 | 22400.0 |
| 2012-03-08 05:15:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0607 | 19.0607 | 2800.0 |
| 2012-03-08 05:25:00 | AAPL | Stock | 19.0593 | 19.0593 | 19.0593 | 19.0593 | 14000.0 |
| 2012-03-08 05:40:00 | AAPL | Stock | 19.0464 | 19.0464 | 19.0464 | 19.0464 | 12516.0 |
| 2012-03-08 05:45:00 | AAPL | Stock | 19.0464 | 19.0464 | 19.0464 | 19.0464 | 8400.0 |
| 2012-03-08 05:50:00 | AAPL | Stock | 19.0357 | 19.0429 | 19.0357 | 19.0357 | 29484.0 |
| 2012-03-08 05:55:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2012-03-08 06:00:00 | AAPL | Stock | 19.0464 | 19.0464 | 19.0464 | 19.0464 | 25060.0 |
| 2012-03-08 06:10:00 | AAPL | Stock | 19.0314 | 19.0314 | 19.0143 | 19.0143 | 23800.0 |
| 2012-03-08 06:15:00 | AAPL | Stock | 19.0214 | 19.0393 | 19.0214 | 19.0393 | 26460.0 |
| 2012-03-08 06:20:00 | AAPL | Stock | 19.0393 | 19.0393 | 19.0393 | 19.0393 | 5600.0 |
| 2012-03-08 06:25:00 | AAPL | Stock | 19.0393 | 19.0411 | 19.0393 | 19.0411 | 14000.0 |
| 2012-03-08 06:30:00 | AAPL | Stock | 19.0393 | 19.0393 | 19.0393 | 19.0393 | 19740.0 |
| 2012-03-08 06:35:00 | AAPL | Stock | 19.0393 | 19.0411 | 19.0393 | 19.0411 | 8400.0 |
| 2012-03-08 06:45:00 | AAPL | Stock | 19.0429 | 19.0429 | 19.0429 | 19.0429 | 2800.0 |
| 2012-03-08 06:50:00 | AAPL | Stock | 19.0486 | 19.05 | 19.0432 | 19.05 | 53200.0 |
| 2012-03-08 06:55:00 | AAPL | Stock | 19.0589 | 19.0589 | 19.0589 | 19.0589 | 2800.0 |
| 2012-03-08 07:00:00 | AAPL | Stock | 19.0639 | 19.0714 | 19.0536 | 19.0714 | 147000.0 |
| 2012-03-08 07:05:00 | AAPL | Stock | 19.0682 | 19.0814 | 19.0682 | 19.0804 | 19600.0 |
| 2012-03-08 07:10:00 | AAPL | Stock | 19.0721 | 19.0893 | 19.0679 | 19.0686 | 208040.0 |
| 2012-03-08 07:15:00 | AAPL | Stock | 19.0686 | 19.0961 | 19.0686 | 19.0804 | 119252.0 |
| 2012-03-08 07:20:00 | AAPL | Stock | 19.0807 | 19.0807 | 19.0714 | 19.08 | 141736.0 |
| 2012-03-08 07:25:00 | AAPL | Stock | 19.0714 | 19.0804 | 19.0714 | 19.0804 | 105364.0 |
| 2012-03-08 07:30:00 | AAPL | Stock | 19.0732 | 19.0743 | 19.0536 | 19.0536 | 231140.0 |
| 2012-03-08 07:35:00 | AAPL | Stock | 19.0571 | 19.0625 | 19.0543 | 19.0625 | 30800.0 |
| 2012-03-08 07:40:00 | AAPL | Stock | 19.0625 | 19.0661 | 19.0625 | 19.0661 | 14000.0 |
| 2012-03-08 07:45:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0536 | 19.0536 | 113680.0 |
| 2012-03-08 07:50:00 | AAPL | Stock | 19.0429 | 19.0521 | 19.0393 | 19.04 | 68740.0 |
| 2012-03-08 07:55:00 | AAPL | Stock | 19.0489 | 19.0618 | 19.0464 | 19.0618 | 67508.0 |
| 2012-03-08 08:00:00 | AAPL | Stock | 19.0614 | 19.0846 | 19.0093 | 19.0654 | 1048096.0 |
| 2012-03-08 08:05:00 | AAPL | Stock | 19.0632 | 19.0879 | 19.0632 | 19.0846 | 492492.0 |
| 2012-03-08 08:10:00 | AAPL | Stock | 19.0879 | 19.1086 | 19.0789 | 19.1086 | 831096.0 |
| 2012-03-08 08:15:00 | AAPL | Stock | 19.1032 | 19.1075 | 19.0718 | 19.0775 | 450464.0 |
| 2012-03-08 08:20:00 | AAPL | Stock | 19.0821 | 19.0829 | 19.075 | 19.075 | 147700.0 |
| 2012-03-08 08:25:00 | AAPL | Stock | 19.0793 | 19.0829 | 19.0643 | 19.0643 | 301504.0 |
| 2012-03-08 08:30:00 | AAPL | Stock | 19.0636 | 19.0707 | 19.0464 | 19.0616 | 434028.0 |
| 2012-03-08 08:35:00 | AAPL | Stock | 19.0571 | 19.0714 | 19.0536 | 19.0711 | 257488.0 |
| 2012-03-08 08:40:00 | AAPL | Stock | 19.0711 | 19.0714 | 19.0554 | 19.0554 | 228088.0 |
| 2012-03-08 08:45:00 | AAPL | Stock | 19.06 | 19.0604 | 19.0429 | 19.0464 | 203952.0 |
| 2012-03-08 08:50:00 | AAPL | Stock | 19.0554 | 19.0625 | 19.0425 | 19.0443 | 217644.0 |
> showing 50 of 323,837 rows — these rows as CSV