PREVIEW / stock_5min / 2010-01-27
file: by_date/stock_5min/2010/2010-01-27.parquet size: 4.7 MB rows: 321,230 symbols: 3,435
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-27 04:15:00 | AAPL | Stock | 7.3961 | 7.3961 | 7.3961 | 7.3961 | 14000.0 |
| 2010-01-27 04:20:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3954 | 7.3964 | 19600.0 |
| 2010-01-27 04:25:00 | AAPL | Stock | 7.3964 | 7.4054 | 7.3964 | 7.4054 | 5600.0 |
| 2010-01-27 05:25:00 | AAPL | Stock | 7.4132 | 7.4132 | 7.4132 | 7.4132 | 6160.0 |
| 2010-01-27 05:30:00 | AAPL | Stock | 7.4246 | 7.425 | 7.4246 | 7.425 | 28000.0 |
| 2010-01-27 05:35:00 | AAPL | Stock | 7.425 | 7.425 | 7.4204 | 7.4204 | 12992.0 |
| 2010-01-27 05:40:00 | AAPL | Stock | 7.4193 | 7.4193 | 7.4193 | 7.4193 | 8400.0 |
| 2010-01-27 05:55:00 | AAPL | Stock | 7.4157 | 7.4264 | 7.4157 | 7.4264 | 8400.0 |
| 2010-01-27 06:00:00 | AAPL | Stock | 7.4246 | 7.425 | 7.4246 | 7.425 | 8400.0 |
| 2010-01-27 06:05:00 | AAPL | Stock | 7.4189 | 7.4189 | 7.4189 | 7.4189 | 2800.0 |
| 2010-01-27 06:10:00 | AAPL | Stock | 7.425 | 7.425 | 7.425 | 7.425 | 12208.0 |
| 2010-01-27 06:15:00 | AAPL | Stock | 7.4268 | 7.4375 | 7.4268 | 7.4375 | 18200.0 |
| 2010-01-27 06:40:00 | AAPL | Stock | 7.4289 | 7.4421 | 7.4286 | 7.4421 | 56952.0 |
| 2010-01-27 06:45:00 | AAPL | Stock | 7.4421 | 7.4464 | 7.4421 | 7.4464 | 25984.0 |
| 2010-01-27 06:50:00 | AAPL | Stock | 7.4404 | 7.4404 | 7.4321 | 7.4321 | 19600.0 |
| 2010-01-27 07:00:00 | AAPL | Stock | 7.42 | 7.4321 | 7.4146 | 7.4286 | 39200.0 |
| 2010-01-27 07:05:00 | AAPL | Stock | 7.4286 | 7.4339 | 7.4286 | 7.4339 | 123508.0 |
| 2010-01-27 07:10:00 | AAPL | Stock | 7.4339 | 7.4386 | 7.4321 | 7.4321 | 102564.0 |
| 2010-01-27 07:15:00 | AAPL | Stock | 7.4293 | 7.4321 | 7.425 | 7.4286 | 164724.0 |
| 2010-01-27 07:20:00 | AAPL | Stock | 7.4268 | 7.4354 | 7.4204 | 7.4318 | 120540.0 |
| 2010-01-27 07:25:00 | AAPL | Stock | 7.4289 | 7.4289 | 7.4107 | 7.4107 | 209188.0 |
| 2010-01-27 07:30:00 | AAPL | Stock | 7.4089 | 7.4243 | 7.3786 | 7.3893 | 744100.0 |
| 2010-01-27 07:35:00 | AAPL | Stock | 7.3893 | 7.3939 | 7.3818 | 7.3929 | 181300.0 |
| 2010-01-27 07:40:00 | AAPL | Stock | 7.3932 | 7.4018 | 7.3929 | 7.4018 | 8400.0 |
| 2010-01-27 07:45:00 | AAPL | Stock | 7.4 | 7.4018 | 7.3929 | 7.3979 | 274932.0 |
| 2010-01-27 07:50:00 | AAPL | Stock | 7.3964 | 7.4071 | 7.3964 | 7.4071 | 58324.0 |
| 2010-01-27 07:55:00 | AAPL | Stock | 7.4061 | 7.4107 | 7.4036 | 7.4036 | 114240.0 |
| 2010-01-27 08:00:00 | AAPL | Stock | 7.4021 | 7.4089 | 7.355 | 7.3661 | 1947512.0 |
| 2010-01-27 08:05:00 | AAPL | Stock | 7.368 | 7.3907 | 7.368 | 7.3907 | 318892.0 |
| 2010-01-27 08:10:00 | AAPL | Stock | 7.3904 | 7.3907 | 7.3832 | 7.3907 | 189532.0 |
| 2010-01-27 08:15:00 | AAPL | Stock | 7.3907 | 7.4054 | 7.3907 | 7.4014 | 989268.0 |
| 2010-01-27 08:20:00 | AAPL | Stock | 7.4011 | 7.4054 | 7.3871 | 7.3871 | 572236.0 |
| 2010-01-27 08:25:00 | AAPL | Stock | 7.3846 | 7.3904 | 7.3732 | 7.3832 | 752976.0 |
| 2010-01-27 08:30:00 | AAPL | Stock | 7.3857 | 7.3879 | 7.3679 | 7.3843 | 507780.0 |
| 2010-01-27 08:35:00 | AAPL | Stock | 7.3839 | 7.3879 | 7.3757 | 7.3839 | 654612.0 |
| 2010-01-27 08:40:00 | AAPL | Stock | 7.3836 | 7.3871 | 7.3786 | 7.3811 | 289632.0 |
| 2010-01-27 08:45:00 | AAPL | Stock | 7.3807 | 7.3814 | 7.3679 | 7.375 | 622692.0 |
| 2010-01-27 08:50:00 | AAPL | Stock | 7.3725 | 7.3807 | 7.3725 | 7.38 | 393148.0 |
| 2010-01-27 08:55:00 | AAPL | Stock | 7.3807 | 7.3829 | 7.3743 | 7.3768 | 328888.0 |
| 2010-01-27 09:00:00 | AAPL | Stock | 7.3764 | 7.3789 | 7.3554 | 7.3643 | 1069740.0 |
| 2010-01-27 09:05:00 | AAPL | Stock | 7.3655 | 7.3675 | 7.3364 | 7.3536 | 945336.0 |
| 2010-01-27 09:10:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3304 | 7.3321 | 1243424.0 |
| 2010-01-27 09:15:00 | AAPL | Stock | 7.3336 | 7.3493 | 7.3279 | 7.3486 | 893536.0 |
| 2010-01-27 09:20:00 | AAPL | Stock | 7.3486 | 7.3546 | 7.3429 | 7.3539 | 790972.0 |
| 2010-01-27 09:25:00 | AAPL | Stock | 7.3539 | 7.3896 | 7.3536 | 7.3886 | 1654240.0 |
| 2010-01-27 09:30:00 | AAPL | Stock | 7.3868 | 7.3896 | 7.2968 | 7.3364 | 33566540.0 |
| 2010-01-27 09:35:00 | AAPL | Stock | 7.3364 | 7.3393 | 7.2768 | 7.3175 | 33259044.0 |
| 2010-01-27 09:40:00 | AAPL | Stock | 7.3175 | 7.35 | 7.2971 | 7.3482 | 19573596.0 |
| 2010-01-27 09:45:00 | AAPL | Stock | 7.3464 | 7.4011 | 7.345 | 7.3715 | 27229104.0 |
| 2010-01-27 09:50:00 | AAPL | Stock | 7.3725 | 7.375 | 7.3479 | 7.3564 | 16076480.0 |
> showing 50 of 321,230 rows — these rows as CSV