PREVIEW / stock_5min / 2008-05-22
file: by_date/stock_5min/2008/2008-05-22.parquet size: 4.4 MB rows: 318,285 symbols: 3,296
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-22 04:30:00 | AAPL | Stock | 6.3571 | 6.3571 | 6.3571 | 6.3571 | 2800.0 |
| 2008-05-22 04:35:00 | AAPL | Stock | 6.3564 | 6.3564 | 6.3564 | 6.3564 | 2800.0 |
| 2008-05-22 04:50:00 | AAPL | Stock | 6.3586 | 6.3586 | 6.3586 | 6.3586 | 5600.0 |
| 2008-05-22 06:55:00 | AAPL | Stock | 6.3668 | 6.37 | 6.3668 | 6.37 | 55300.0 |
| 2008-05-22 07:00:00 | AAPL | Stock | 6.3768 | 6.3893 | 6.3757 | 6.3757 | 52640.0 |
| 2008-05-22 07:05:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3929 | 6.3929 | 8400.0 |
| 2008-05-22 07:10:00 | AAPL | Stock | 6.3836 | 6.3836 | 6.3836 | 6.3836 | 2800.0 |
| 2008-05-22 07:15:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 32144.0 |
| 2008-05-22 07:20:00 | AAPL | Stock | 6.3818 | 6.3818 | 6.3818 | 6.3818 | 2800.0 |
| 2008-05-22 07:25:00 | AAPL | Stock | 6.3707 | 6.3875 | 6.3707 | 6.3875 | 25480.0 |
| 2008-05-22 07:30:00 | AAPL | Stock | 6.3911 | 6.4125 | 6.3911 | 6.3982 | 187600.0 |
| 2008-05-22 07:35:00 | AAPL | Stock | 6.3982 | 6.4018 | 6.3943 | 6.3982 | 106120.0 |
| 2008-05-22 07:40:00 | AAPL | Stock | 6.3982 | 6.4014 | 6.3982 | 6.3982 | 82936.0 |
| 2008-05-22 07:45:00 | AAPL | Stock | 6.3964 | 6.3964 | 6.3718 | 6.3896 | 72268.0 |
| 2008-05-22 07:50:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3821 | 6.3879 | 106400.0 |
| 2008-05-22 07:55:00 | AAPL | Stock | 6.3893 | 6.3896 | 6.3843 | 6.3843 | 64400.0 |
| 2008-05-22 08:00:00 | AAPL | Stock | 6.3886 | 6.4061 | 6.3871 | 6.4018 | 997668.0 |
| 2008-05-22 08:05:00 | AAPL | Stock | 6.4046 | 6.4089 | 6.3996 | 6.4014 | 458584.0 |
| 2008-05-22 08:10:00 | AAPL | Stock | 6.4014 | 6.405 | 6.3964 | 6.3982 | 409080.0 |
| 2008-05-22 08:15:00 | AAPL | Stock | 6.3982 | 6.3996 | 6.3871 | 6.3925 | 278768.0 |
| 2008-05-22 08:20:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3839 | 6.3861 | 173320.0 |
| 2008-05-22 08:25:00 | AAPL | Stock | 6.3864 | 6.3946 | 6.3857 | 6.3929 | 482076.0 |
| 2008-05-22 08:30:00 | AAPL | Stock | 6.3929 | 6.4046 | 6.3332 | 6.3332 | 1561392.0 |
| 2008-05-22 08:35:00 | AAPL | Stock | 6.3393 | 6.3818 | 6.3329 | 6.375 | 429436.0 |
| 2008-05-22 08:40:00 | AAPL | Stock | 6.3696 | 6.395 | 6.3696 | 6.395 | 311528.0 |
| 2008-05-22 08:45:00 | AAPL | Stock | 6.3982 | 6.4036 | 6.3929 | 6.3943 | 893508.0 |
| 2008-05-22 08:50:00 | AAPL | Stock | 6.3968 | 6.4043 | 6.3939 | 6.4043 | 169232.0 |
| 2008-05-22 08:55:00 | AAPL | Stock | 6.405 | 6.4125 | 6.405 | 6.4071 | 232400.0 |
| 2008-05-22 09:00:00 | AAPL | Stock | 6.4064 | 6.4186 | 6.4057 | 6.4179 | 354060.0 |
| 2008-05-22 09:05:00 | AAPL | Stock | 6.4193 | 6.4221 | 6.4089 | 6.4154 | 1156260.0 |
| 2008-05-22 09:10:00 | AAPL | Stock | 6.4143 | 6.4171 | 6.4125 | 6.4143 | 331968.0 |
| 2008-05-22 09:15:00 | AAPL | Stock | 6.4143 | 6.4179 | 6.4107 | 6.4139 | 264124.0 |
| 2008-05-22 09:20:00 | AAPL | Stock | 6.4118 | 6.4132 | 6.4079 | 6.4079 | 192108.0 |
| 2008-05-22 09:25:00 | AAPL | Stock | 6.4079 | 6.4089 | 6.3954 | 6.4036 | 425824.0 |
| 2008-05-22 09:30:00 | AAPL | Stock | 6.4032 | 6.4393 | 6.3886 | 6.4282 | 24600912.0 |
| 2008-05-22 09:35:00 | AAPL | Stock | 6.4282 | 6.4536 | 6.4136 | 6.4229 | 29323476.0 |
| 2008-05-22 09:40:00 | AAPL | Stock | 6.4229 | 6.4341 | 6.3821 | 6.385 | 25084752.0 |
| 2008-05-22 09:45:00 | AAPL | Stock | 6.385 | 6.3914 | 6.3571 | 6.3571 | 26764388.0 |
| 2008-05-22 09:50:00 | AAPL | Stock | 6.3571 | 6.4025 | 6.3529 | 6.3986 | 28215208.0 |
| 2008-05-22 09:55:00 | AAPL | Stock | 6.3975 | 6.4082 | 6.375 | 6.3757 | 12350968.0 |
| 2008-05-22 10:00:00 | AAPL | Stock | 6.3768 | 6.4286 | 6.3757 | 6.4186 | 20634320.0 |
| 2008-05-22 10:05:00 | AAPL | Stock | 6.4179 | 6.4239 | 6.3868 | 6.4221 | 14673204.0 |
| 2008-05-22 10:10:00 | AAPL | Stock | 6.4207 | 6.4439 | 6.4207 | 6.4243 | 16603608.0 |
| 2008-05-22 10:15:00 | AAPL | Stock | 6.4239 | 6.4393 | 6.4143 | 6.4379 | 12386332.0 |
| 2008-05-22 10:20:00 | AAPL | Stock | 6.4389 | 6.46 | 6.4318 | 6.4464 | 15140608.0 |
| 2008-05-22 10:25:00 | AAPL | Stock | 6.4464 | 6.4507 | 6.4286 | 6.44 | 12032048.0 |
| 2008-05-22 10:30:00 | AAPL | Stock | 6.44 | 6.4689 | 6.4393 | 6.4665 | 18744292.0 |
| 2008-05-22 10:35:00 | AAPL | Stock | 6.4661 | 6.4761 | 6.4561 | 6.4668 | 13029436.0 |
| 2008-05-22 10:40:00 | AAPL | Stock | 6.4639 | 6.4761 | 6.4364 | 6.4439 | 14751464.0 |
| 2008-05-22 10:45:00 | AAPL | Stock | 6.445 | 6.4546 | 6.4304 | 6.4336 | 10375484.0 |
> showing 50 of 318,285 rows — these rows as CSV