PREVIEW / stock_5min / 2011-09-01
file: by_date/stock_5min/2011/2011-09-01.parquet size: 4.8 MB rows: 326,835 symbols: 3,490
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-09-01 04:45:00 | AAPL | Stock | 13.7511 | 13.7511 | 13.7511 | 13.7511 | 2800.0 |
| 2011-09-01 07:00:00 | AAPL | Stock | 13.7454 | 13.7454 | 13.7454 | 13.7454 | 5600.0 |
| 2011-09-01 07:05:00 | AAPL | Stock | 13.7536 | 13.7536 | 13.7536 | 13.7536 | 2800.0 |
| 2011-09-01 07:10:00 | AAPL | Stock | 13.7414 | 13.7414 | 13.7414 | 13.7414 | 2800.0 |
| 2011-09-01 07:15:00 | AAPL | Stock | 13.7361 | 13.7364 | 13.7343 | 13.7343 | 8400.0 |
| 2011-09-01 07:25:00 | AAPL | Stock | 13.7404 | 13.7604 | 13.7404 | 13.7604 | 64400.0 |
| 2011-09-01 07:30:00 | AAPL | Stock | 13.7582 | 13.7664 | 13.7582 | 13.7664 | 8400.0 |
| 2011-09-01 07:35:00 | AAPL | Stock | 13.7561 | 13.7561 | 13.75 | 13.75 | 5600.0 |
| 2011-09-01 07:40:00 | AAPL | Stock | 13.75 | 13.75 | 13.75 | 13.75 | 8400.0 |
| 2011-09-01 07:45:00 | AAPL | Stock | 13.7571 | 13.7571 | 13.7536 | 13.7571 | 42000.0 |
| 2011-09-01 07:55:00 | AAPL | Stock | 13.7621 | 13.7621 | 13.7432 | 13.7471 | 33628.0 |
| 2011-09-01 08:00:00 | AAPL | Stock | 13.7532 | 13.7571 | 13.7354 | 13.7421 | 214368.0 |
| 2011-09-01 08:05:00 | AAPL | Stock | 13.7357 | 13.7357 | 13.7229 | 13.7279 | 107436.0 |
| 2011-09-01 08:10:00 | AAPL | Stock | 13.7321 | 13.7439 | 13.7282 | 13.7393 | 144592.0 |
| 2011-09-01 08:15:00 | AAPL | Stock | 13.745 | 13.7571 | 13.7339 | 13.7504 | 176568.0 |
| 2011-09-01 08:20:00 | AAPL | Stock | 13.7568 | 13.7679 | 13.7521 | 13.7671 | 211092.0 |
| 2011-09-01 08:25:00 | AAPL | Stock | 13.7611 | 13.7711 | 13.7589 | 13.7618 | 94696.0 |
| 2011-09-01 08:30:00 | AAPL | Stock | 13.76 | 13.7754 | 13.75 | 13.76 | 341880.0 |
| 2011-09-01 08:35:00 | AAPL | Stock | 13.7607 | 13.7607 | 13.7525 | 13.7543 | 87360.0 |
| 2011-09-01 08:40:00 | AAPL | Stock | 13.7614 | 13.7929 | 13.7564 | 13.7929 | 282072.0 |
| 2011-09-01 08:45:00 | AAPL | Stock | 13.7946 | 13.8036 | 13.7929 | 13.8004 | 193620.0 |
| 2011-09-01 08:50:00 | AAPL | Stock | 13.8 | 13.8114 | 13.7946 | 13.8071 | 317548.0 |
| 2011-09-01 08:55:00 | AAPL | Stock | 13.8096 | 13.8443 | 13.8096 | 13.8304 | 478520.0 |
| 2011-09-01 09:00:00 | AAPL | Stock | 13.83 | 13.8321 | 13.8179 | 13.8179 | 161476.0 |
| 2011-09-01 09:05:00 | AAPL | Stock | 13.7439 | 13.8232 | 13.7439 | 13.8193 | 159740.0 |
| 2011-09-01 09:10:00 | AAPL | Stock | 13.8171 | 13.8175 | 13.8075 | 13.8157 | 198072.0 |
| 2011-09-01 09:15:00 | AAPL | Stock | 13.8179 | 13.8196 | 13.8132 | 13.8168 | 132384.0 |
| 2011-09-01 09:20:00 | AAPL | Stock | 13.8171 | 13.8171 | 13.7821 | 13.7857 | 395920.0 |
| 2011-09-01 09:25:00 | AAPL | Stock | 13.7846 | 13.7954 | 13.7611 | 13.785 | 484876.0 |
| 2011-09-01 09:30:00 | AAPL | Stock | 13.7854 | 13.8164 | 13.7679 | 13.7757 | 11374020.0 |
| 2011-09-01 09:35:00 | AAPL | Stock | 13.7786 | 13.8125 | 13.7714 | 13.7839 | 7686644.0 |
| 2011-09-01 09:40:00 | AAPL | Stock | 13.7871 | 13.8018 | 13.7614 | 13.7721 | 7304444.0 |
| 2011-09-01 09:45:00 | AAPL | Stock | 13.7732 | 13.7846 | 13.7518 | 13.7575 | 7858312.0 |
| 2011-09-01 09:50:00 | AAPL | Stock | 13.7571 | 13.7618 | 13.7089 | 13.7196 | 7631288.0 |
| 2011-09-01 09:55:00 | AAPL | Stock | 13.7194 | 13.7616 | 13.7139 | 13.7507 | 5118652.0 |
| 2011-09-01 10:00:00 | AAPL | Stock | 13.7511 | 13.8336 | 13.7364 | 13.7929 | 18166540.0 |
| 2011-09-01 10:05:00 | AAPL | Stock | 13.7946 | 13.8039 | 13.765 | 13.7861 | 7768964.0 |
| 2011-09-01 10:10:00 | AAPL | Stock | 13.7875 | 13.7943 | 13.7554 | 13.7557 | 7305984.0 |
| 2011-09-01 10:15:00 | AAPL | Stock | 13.7573 | 13.7896 | 13.7536 | 13.7764 | 4576040.0 |
| 2011-09-01 10:20:00 | AAPL | Stock | 13.78 | 13.7929 | 13.7716 | 13.7843 | 3532340.0 |
| 2011-09-01 10:25:00 | AAPL | Stock | 13.7884 | 13.7989 | 13.7643 | 13.7739 | 3225264.0 |
| 2011-09-01 10:30:00 | AAPL | Stock | 13.7743 | 13.7764 | 13.7539 | 13.7627 | 4359432.0 |
| 2011-09-01 10:35:00 | AAPL | Stock | 13.7589 | 13.7593 | 13.7382 | 13.7462 | 7990528.0 |
| 2011-09-01 10:40:00 | AAPL | Stock | 13.7457 | 13.7639 | 13.7393 | 13.76 | 4038384.0 |
| 2011-09-01 10:45:00 | AAPL | Stock | 13.76 | 13.7607 | 13.7375 | 13.7404 | 5080432.0 |
| 2011-09-01 10:50:00 | AAPL | Stock | 13.7414 | 13.7607 | 13.7379 | 13.7471 | 3850812.0 |
| 2011-09-01 10:55:00 | AAPL | Stock | 13.75 | 13.7543 | 13.7393 | 13.7421 | 3817940.0 |
| 2011-09-01 11:00:00 | AAPL | Stock | 13.7439 | 13.7564 | 13.7357 | 13.7564 | 5930120.0 |
| 2011-09-01 11:05:00 | AAPL | Stock | 13.7564 | 13.7618 | 13.7318 | 13.7386 | 5582388.0 |
| 2011-09-01 11:10:00 | AAPL | Stock | 13.7346 | 13.7371 | 13.7182 | 13.7229 | 3694880.0 |
> showing 50 of 326,835 rows — these rows as CSV