PREVIEW / stock_5min / 2013-02-19
file: by_date/stock_5min/2013/2013-02-19.parquet size: 5.1 MB rows: 337,748 symbols: 3,487
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-19 04:00:00 | AAPL | Stock | 16.4589 | 16.4589 | 16.4589 | 16.4589 | 5600.0 |
| 2013-02-19 04:40:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 11200.0 |
| 2013-02-19 05:00:00 | AAPL | Stock | 16.5071 | 16.5179 | 16.5 | 16.5 | 29400.0 |
| 2013-02-19 05:30:00 | AAPL | Stock | 16.5 | 16.5 | 16.5 | 16.5 | 13020.0 |
| 2013-02-19 06:00:00 | AAPL | Stock | 16.5071 | 16.5071 | 16.5071 | 16.5071 | 14280.0 |
| 2013-02-19 06:25:00 | AAPL | Stock | 16.5179 | 16.5354 | 16.5179 | 16.5354 | 13860.0 |
| 2013-02-19 06:35:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 5600.0 |
| 2013-02-19 06:40:00 | AAPL | Stock | 16.5111 | 16.5111 | 16.5089 | 16.5089 | 5600.0 |
| 2013-02-19 07:00:00 | AAPL | Stock | 16.5089 | 16.5196 | 16.5029 | 16.5029 | 73388.0 |
| 2013-02-19 07:05:00 | AAPL | Stock | 16.5064 | 16.5179 | 16.5064 | 16.5179 | 14756.0 |
| 2013-02-19 07:10:00 | AAPL | Stock | 16.5268 | 16.5464 | 16.5268 | 16.5464 | 33600.0 |
| 2013-02-19 07:15:00 | AAPL | Stock | 16.5368 | 16.5464 | 16.5368 | 16.5429 | 11200.0 |
| 2013-02-19 07:20:00 | AAPL | Stock | 16.5357 | 16.5357 | 16.5268 | 16.53 | 26292.0 |
| 2013-02-19 07:25:00 | AAPL | Stock | 16.5179 | 16.53 | 16.5179 | 16.53 | 30800.0 |
| 2013-02-19 07:30:00 | AAPL | Stock | 16.5304 | 16.5304 | 16.5179 | 16.5179 | 11200.0 |
| 2013-02-19 07:35:00 | AAPL | Stock | 16.5304 | 16.5621 | 16.5304 | 16.5621 | 199780.0 |
| 2013-02-19 07:40:00 | AAPL | Stock | 16.5618 | 16.5625 | 16.5375 | 16.5375 | 31472.0 |
| 2013-02-19 07:45:00 | AAPL | Stock | 16.5464 | 16.5464 | 16.5464 | 16.5464 | 2800.0 |
| 2013-02-19 07:50:00 | AAPL | Stock | 16.5432 | 16.5432 | 16.5357 | 16.5407 | 106260.0 |
| 2013-02-19 07:55:00 | AAPL | Stock | 16.5407 | 16.5532 | 16.5371 | 16.5532 | 56000.0 |
| 2013-02-19 08:00:00 | AAPL | Stock | 16.5493 | 16.5625 | 16.5 | 16.5182 | 337344.0 |
| 2013-02-19 08:05:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5021 | 16.5125 | 63840.0 |
| 2013-02-19 08:10:00 | AAPL | Stock | 16.5121 | 16.5125 | 16.4893 | 16.4893 | 201432.0 |
| 2013-02-19 08:15:00 | AAPL | Stock | 16.5 | 16.5 | 16.4832 | 16.4911 | 51520.0 |
| 2013-02-19 08:20:00 | AAPL | Stock | 16.4911 | 16.4996 | 16.4871 | 16.4996 | 62748.0 |
| 2013-02-19 08:25:00 | AAPL | Stock | 16.5 | 16.5 | 16.4968 | 16.4968 | 64904.0 |
| 2013-02-19 08:30:00 | AAPL | Stock | 16.5 | 16.5089 | 16.4954 | 16.4954 | 146300.0 |
| 2013-02-19 08:35:00 | AAPL | Stock | 16.5 | 16.5268 | 16.4989 | 16.5179 | 221704.0 |
| 2013-02-19 08:40:00 | AAPL | Stock | 16.5107 | 16.5164 | 16.4946 | 16.4946 | 274400.0 |
| 2013-02-19 08:45:00 | AAPL | Stock | 16.5 | 16.5161 | 16.5 | 16.5107 | 128240.0 |
| 2013-02-19 08:50:00 | AAPL | Stock | 16.5125 | 16.5164 | 16.5054 | 16.5054 | 58800.0 |
| 2013-02-19 08:55:00 | AAPL | Stock | 16.5129 | 16.5354 | 16.5043 | 16.5339 | 187208.0 |
| 2013-02-19 09:00:00 | AAPL | Stock | 16.5186 | 16.525 | 16.5154 | 16.5157 | 119672.0 |
| 2013-02-19 09:05:00 | AAPL | Stock | 16.5086 | 16.5164 | 16.5039 | 16.5111 | 106036.0 |
| 2013-02-19 09:10:00 | AAPL | Stock | 16.5107 | 16.515 | 16.4375 | 16.5054 | 430164.0 |
| 2013-02-19 09:15:00 | AAPL | Stock | 16.5068 | 16.5071 | 16.4929 | 16.4929 | 170100.0 |
| 2013-02-19 09:20:00 | AAPL | Stock | 16.4939 | 16.4964 | 16.4871 | 16.4964 | 22848.0 |
| 2013-02-19 09:25:00 | AAPL | Stock | 16.4911 | 16.4957 | 16.465 | 16.4675 | 261492.0 |
| 2013-02-19 09:30:00 | AAPL | Stock | 16.4679 | 16.5261 | 16.4325 | 16.4743 | 18420360.0 |
| 2013-02-19 09:35:00 | AAPL | Stock | 16.4746 | 16.4864 | 16.3929 | 16.3929 | 13256992.0 |
| 2013-02-19 09:40:00 | AAPL | Stock | 16.3932 | 16.4054 | 16.3482 | 16.3713 | 13953352.0 |
| 2013-02-19 09:45:00 | AAPL | Stock | 16.3654 | 16.4429 | 16.3514 | 16.4225 | 11142124.0 |
| 2013-02-19 09:50:00 | AAPL | Stock | 16.4164 | 16.425 | 16.3714 | 16.38 | 6952764.0 |
| 2013-02-19 09:55:00 | AAPL | Stock | 16.375 | 16.4143 | 16.3611 | 16.3707 | 5144916.0 |
| 2013-02-19 10:00:00 | AAPL | Stock | 16.3696 | 16.3768 | 16.2946 | 16.3079 | 12875744.0 |
| 2013-02-19 10:05:00 | AAPL | Stock | 16.31 | 16.3154 | 16.2322 | 16.2446 | 15949360.0 |
| 2013-02-19 10:10:00 | AAPL | Stock | 16.2454 | 16.2718 | 16.2318 | 16.2607 | 11203696.0 |
| 2013-02-19 10:15:00 | AAPL | Stock | 16.2576 | 16.2989 | 16.2511 | 16.2804 | 6741756.0 |
| 2013-02-19 10:20:00 | AAPL | Stock | 16.2796 | 16.2975 | 16.265 | 16.2821 | 3731252.0 |
| 2013-02-19 10:25:00 | AAPL | Stock | 16.2834 | 16.3154 | 16.2804 | 16.3046 | 5306028.0 |
> showing 50 of 337,748 rows — these rows as CSV