PREVIEW / stock_5min / 2009-03-16
file: by_date/stock_5min/2009/2009-03-16.parquet size: 4.4 MB rows: 305,516 symbols: 3,329
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-16 05:55:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 25200.0 |
| 2009-03-16 06:00:00 | AAPL | Stock | 3.4768 | 3.4821 | 3.4768 | 3.4821 | 50400.0 |
| 2009-03-16 07:20:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 5600.0 |
| 2009-03-16 07:25:00 | AAPL | Stock | 3.4779 | 3.4779 | 3.4779 | 3.4779 | 2800.0 |
| 2009-03-16 07:40:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 2800.0 |
| 2009-03-16 07:50:00 | AAPL | Stock | 3.4904 | 3.4904 | 3.4904 | 3.4904 | 2800.0 |
| 2009-03-16 08:00:00 | AAPL | Stock | 3.4836 | 3.4904 | 3.4804 | 3.4821 | 103180.0 |
| 2009-03-16 08:05:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4796 | 3.4804 | 19600.0 |
| 2009-03-16 08:10:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4757 | 3.48 | 39900.0 |
| 2009-03-16 08:15:00 | AAPL | Stock | 3.4757 | 3.4757 | 3.4675 | 3.4675 | 44240.0 |
| 2009-03-16 08:20:00 | AAPL | Stock | 3.4679 | 3.47 | 3.465 | 3.465 | 19600.0 |
| 2009-03-16 08:25:00 | AAPL | Stock | 3.4654 | 3.4661 | 3.4589 | 3.4589 | 72492.0 |
| 2009-03-16 08:30:00 | AAPL | Stock | 3.4625 | 3.4646 | 3.4571 | 3.4646 | 141876.0 |
| 2009-03-16 08:35:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4571 | 3.4643 | 109760.0 |
| 2009-03-16 08:40:00 | AAPL | Stock | 3.4661 | 3.4661 | 3.4614 | 3.4643 | 98840.0 |
| 2009-03-16 08:45:00 | AAPL | Stock | 3.4679 | 3.4682 | 3.4643 | 3.4661 | 58800.0 |
| 2009-03-16 08:50:00 | AAPL | Stock | 3.4671 | 3.4671 | 3.4643 | 3.4643 | 40880.0 |
| 2009-03-16 08:55:00 | AAPL | Stock | 3.4661 | 3.4661 | 3.4589 | 3.4589 | 169540.0 |
| 2009-03-16 09:00:00 | AAPL | Stock | 3.4593 | 3.4593 | 3.4536 | 3.455 | 130508.0 |
| 2009-03-16 09:05:00 | AAPL | Stock | 3.4554 | 3.4557 | 3.4507 | 3.4536 | 372400.0 |
| 2009-03-16 09:10:00 | AAPL | Stock | 3.455 | 3.4625 | 3.455 | 3.4625 | 100632.0 |
| 2009-03-16 09:15:00 | AAPL | Stock | 3.4604 | 3.4604 | 3.4604 | 3.4604 | 2800.0 |
| 2009-03-16 09:20:00 | AAPL | Stock | 3.4629 | 3.4643 | 3.4579 | 3.4604 | 168056.0 |
| 2009-03-16 09:25:00 | AAPL | Stock | 3.4575 | 3.4575 | 3.4343 | 3.4446 | 563500.0 |
| 2009-03-16 09:30:00 | AAPL | Stock | 3.4475 | 3.4589 | 3.42 | 3.4286 | 15447068.0 |
| 2009-03-16 09:35:00 | AAPL | Stock | 3.4296 | 3.4375 | 3.4071 | 3.4225 | 13601672.0 |
| 2009-03-16 09:40:00 | AAPL | Stock | 3.4229 | 3.44 | 3.4196 | 3.4281 | 12938268.0 |
| 2009-03-16 09:45:00 | AAPL | Stock | 3.4282 | 3.4339 | 3.4189 | 3.4265 | 9660448.0 |
| 2009-03-16 09:50:00 | AAPL | Stock | 3.4268 | 3.4411 | 3.4146 | 3.4214 | 14279216.0 |
| 2009-03-16 09:55:00 | AAPL | Stock | 3.4214 | 3.425 | 3.3957 | 3.4114 | 15188432.0 |
| 2009-03-16 10:00:00 | AAPL | Stock | 3.4104 | 3.4211 | 3.4032 | 3.4118 | 7673820.0 |
| 2009-03-16 10:05:00 | AAPL | Stock | 3.4114 | 3.4121 | 3.3975 | 3.4007 | 6690040.0 |
| 2009-03-16 10:10:00 | AAPL | Stock | 3.401 | 3.4029 | 3.3936 | 3.3946 | 8545180.0 |
| 2009-03-16 10:15:00 | AAPL | Stock | 3.3946 | 3.3971 | 3.3868 | 3.3882 | 13402648.0 |
| 2009-03-16 10:20:00 | AAPL | Stock | 3.3886 | 3.3907 | 3.375 | 3.3795 | 12576676.0 |
| 2009-03-16 10:25:00 | AAPL | Stock | 3.3796 | 3.3871 | 3.3693 | 3.3761 | 8012844.0 |
| 2009-03-16 10:30:00 | AAPL | Stock | 3.3764 | 3.3946 | 3.3725 | 3.3942 | 10373832.0 |
| 2009-03-16 10:35:00 | AAPL | Stock | 3.3939 | 3.3975 | 3.3836 | 3.3886 | 8550752.0 |
| 2009-03-16 10:40:00 | AAPL | Stock | 3.3886 | 3.3896 | 3.3725 | 3.375 | 6463380.0 |
| 2009-03-16 10:45:00 | AAPL | Stock | 3.3761 | 3.3768 | 3.3714 | 3.3746 | 6251420.0 |
| 2009-03-16 10:50:00 | AAPL | Stock | 3.3743 | 3.3764 | 3.3636 | 3.3682 | 8521492.0 |
| 2009-03-16 10:55:00 | AAPL | Stock | 3.3686 | 3.3779 | 3.3661 | 3.3668 | 5872328.0 |
| 2009-03-16 11:00:00 | AAPL | Stock | 3.3671 | 3.3779 | 3.3657 | 3.3768 | 5395348.0 |
| 2009-03-16 11:05:00 | AAPL | Stock | 3.3764 | 3.3893 | 3.3764 | 3.3843 | 6747720.0 |
| 2009-03-16 11:10:00 | AAPL | Stock | 3.3839 | 3.3868 | 3.3771 | 3.3832 | 3327156.0 |
| 2009-03-16 11:15:00 | AAPL | Stock | 3.3833 | 3.3879 | 3.3814 | 3.3861 | 4377632.0 |
| 2009-03-16 11:20:00 | AAPL | Stock | 3.3861 | 3.4036 | 3.3814 | 3.4036 | 10481464.0 |
| 2009-03-16 11:25:00 | AAPL | Stock | 3.4032 | 3.42 | 3.4029 | 3.4143 | 11771172.0 |
| 2009-03-16 11:30:00 | AAPL | Stock | 3.4143 | 3.4179 | 3.4118 | 3.415 | 4435928.0 |
| 2009-03-16 11:35:00 | AAPL | Stock | 3.415 | 3.4196 | 3.4107 | 3.4161 | 6143592.0 |
> showing 50 of 305,516 rows — these rows as CSV