PREVIEW / stock_5min / 2007-02-09
file: by_date/stock_5min/2007/2007-02-09.parquet size: 3.4 MB rows: 242,962 symbols: 2,504
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-02-09 06:00:00 | AAPL | Stock | 3.0646 | 3.0646 | 3.0646 | 3.0646 | 14000.0 |
| 2007-02-09 06:30:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0625 | 3.0625 | 11200.0 |
| 2007-02-09 06:35:00 | AAPL | Stock | 3.0632 | 3.0636 | 3.0632 | 3.0632 | 14000.0 |
| 2007-02-09 06:45:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.075 | 3.075 | 5600.0 |
| 2007-02-09 07:10:00 | AAPL | Stock | 3.0754 | 3.0754 | 3.0668 | 3.0675 | 35000.0 |
| 2007-02-09 07:15:00 | AAPL | Stock | 3.0675 | 3.0675 | 3.0636 | 3.0636 | 36400.0 |
| 2007-02-09 07:25:00 | AAPL | Stock | 3.0668 | 3.0668 | 3.0668 | 3.0668 | 5600.0 |
| 2007-02-09 07:35:00 | AAPL | Stock | 3.0621 | 3.0632 | 3.0621 | 3.0632 | 5600.0 |
| 2007-02-09 07:40:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 56000.0 |
| 2007-02-09 07:55:00 | AAPL | Stock | 3.0618 | 3.0618 | 3.0607 | 3.0607 | 84000.0 |
| 2007-02-09 08:00:00 | AAPL | Stock | 3.0693 | 3.0707 | 3.0568 | 3.0575 | 751576.0 |
| 2007-02-09 08:05:00 | AAPL | Stock | 3.0564 | 3.0596 | 3.0536 | 3.0596 | 835968.0 |
| 2007-02-09 08:10:00 | AAPL | Stock | 3.0596 | 3.0604 | 3.0554 | 3.0589 | 199248.0 |
| 2007-02-09 08:15:00 | AAPL | Stock | 3.0593 | 3.0607 | 3.0593 | 3.0604 | 353164.0 |
| 2007-02-09 08:20:00 | AAPL | Stock | 3.0604 | 3.0607 | 3.0596 | 3.0607 | 346052.0 |
| 2007-02-09 08:25:00 | AAPL | Stock | 3.0589 | 3.0607 | 3.0589 | 3.0589 | 124600.0 |
| 2007-02-09 08:30:00 | AAPL | Stock | 3.0604 | 3.0607 | 3.0589 | 3.0607 | 312256.0 |
| 2007-02-09 08:35:00 | AAPL | Stock | 3.0607 | 3.0614 | 3.0604 | 3.0604 | 530992.0 |
| 2007-02-09 08:40:00 | AAPL | Stock | 3.0604 | 3.0607 | 3.0604 | 3.0607 | 29400.0 |
| 2007-02-09 08:45:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0593 | 3.06 | 61180.0 |
| 2007-02-09 08:50:00 | AAPL | Stock | 3.06 | 3.0607 | 3.0579 | 3.0607 | 202860.0 |
| 2007-02-09 08:55:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0589 | 3.0607 | 214200.0 |
| 2007-02-09 09:00:00 | AAPL | Stock | 3.0621 | 3.0625 | 3.0621 | 3.0621 | 46760.0 |
| 2007-02-09 09:05:00 | AAPL | Stock | 3.0621 | 3.0679 | 3.0621 | 3.0671 | 361872.0 |
| 2007-02-09 09:10:00 | AAPL | Stock | 3.0646 | 3.0646 | 3.0604 | 3.0607 | 155092.0 |
| 2007-02-09 09:15:00 | AAPL | Stock | 3.0589 | 3.0779 | 3.0589 | 3.0607 | 305088.0 |
| 2007-02-09 09:20:00 | AAPL | Stock | 3.0589 | 3.0671 | 3.0589 | 3.0671 | 203700.0 |
| 2007-02-09 09:25:00 | AAPL | Stock | 3.0643 | 3.0679 | 3.0643 | 3.0679 | 551488.0 |
| 2007-02-09 09:30:00 | AAPL | Stock | 3.0671 | 3.0714 | 3.0625 | 3.0696 | 16651964.0 |
| 2007-02-09 09:35:00 | AAPL | Stock | 3.07 | 3.0786 | 3.0689 | 3.0757 | 15073744.0 |
| 2007-02-09 09:40:00 | AAPL | Stock | 3.0757 | 3.0764 | 3.0604 | 3.0618 | 14028392.0 |
| 2007-02-09 09:45:00 | AAPL | Stock | 3.0621 | 3.0628 | 3.0514 | 3.0514 | 17698100.0 |
| 2007-02-09 09:50:00 | AAPL | Stock | 3.0514 | 3.0607 | 3.0475 | 3.0574 | 16831780.0 |
| 2007-02-09 09:55:00 | AAPL | Stock | 3.0571 | 3.0572 | 3.0475 | 3.05 | 10266396.0 |
| 2007-02-09 10:00:00 | AAPL | Stock | 3.0493 | 3.05 | 3.04 | 3.0414 | 21760368.0 |
| 2007-02-09 10:05:00 | AAPL | Stock | 3.0414 | 3.0514 | 3.0411 | 3.0471 | 12616128.0 |
| 2007-02-09 10:10:00 | AAPL | Stock | 3.0468 | 3.0521 | 3.0464 | 3.0518 | 8187760.0 |
| 2007-02-09 10:15:00 | AAPL | Stock | 3.0518 | 3.0554 | 3.045 | 3.0468 | 10746568.0 |
| 2007-02-09 10:20:00 | AAPL | Stock | 3.0468 | 3.0507 | 3.0464 | 3.0475 | 6956124.0 |
| 2007-02-09 10:25:00 | AAPL | Stock | 3.0475 | 3.0496 | 3.0396 | 3.04 | 18177572.0 |
| 2007-02-09 10:30:00 | AAPL | Stock | 3.0396 | 3.0407 | 3.0268 | 3.0275 | 28518308.0 |
| 2007-02-09 10:35:00 | AAPL | Stock | 3.0275 | 3.0314 | 3.0221 | 3.0257 | 21623504.0 |
| 2007-02-09 10:40:00 | AAPL | Stock | 3.0257 | 3.0321 | 3.0239 | 3.0321 | 14468720.0 |
| 2007-02-09 10:45:00 | AAPL | Stock | 3.0318 | 3.0332 | 3.0279 | 3.0296 | 9096640.0 |
| 2007-02-09 10:50:00 | AAPL | Stock | 3.0296 | 3.03 | 3.0118 | 3.015 | 22670928.0 |
| 2007-02-09 10:55:00 | AAPL | Stock | 3.015 | 3.0189 | 3.0111 | 3.0154 | 14467320.0 |
| 2007-02-09 11:00:00 | AAPL | Stock | 3.0154 | 3.0214 | 3.015 | 3.0182 | 9016308.0 |
| 2007-02-09 11:05:00 | AAPL | Stock | 3.0179 | 3.0275 | 3.0168 | 3.0261 | 10489836.0 |
| 2007-02-09 11:10:00 | AAPL | Stock | 3.0261 | 3.03 | 3.0246 | 3.0275 | 11394656.0 |
| 2007-02-09 11:15:00 | AAPL | Stock | 3.0271 | 3.0275 | 3.0164 | 3.0182 | 9940028.0 |
> showing 50 of 242,962 rows — these rows as CSV