PREVIEW / stock_5min / 2013-01-30
file: by_date/stock_5min/2013/2013-01-30.parquet size: 4.9 MB rows: 330,111 symbols: 3,474
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-01-30 04:15:00 | AAPL | Stock | 16.4332 | 16.4507 | 16.4332 | 16.4332 | 14000.0 |
| 2013-01-30 04:20:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4164 | 16.4164 | 19600.0 |
| 2013-01-30 04:25:00 | AAPL | Stock | 16.4164 | 16.4279 | 16.4164 | 16.4279 | 11200.0 |
| 2013-01-30 04:30:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 5600.0 |
| 2013-01-30 04:35:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 16800.0 |
| 2013-01-30 04:40:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 5600.0 |
| 2013-01-30 04:45:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 23800.0 |
| 2013-01-30 04:55:00 | AAPL | Stock | 16.4539 | 16.4539 | 16.4539 | 16.4539 | 2800.0 |
| 2013-01-30 05:10:00 | AAPL | Stock | 16.4461 | 16.4461 | 16.4282 | 16.4282 | 8400.0 |
| 2013-01-30 05:20:00 | AAPL | Stock | 16.4393 | 16.4393 | 16.4214 | 16.4214 | 29400.0 |
| 2013-01-30 05:30:00 | AAPL | Stock | 16.435 | 16.435 | 16.4304 | 16.4304 | 5600.0 |
| 2013-01-30 05:35:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 5600.0 |
| 2013-01-30 05:40:00 | AAPL | Stock | 16.4075 | 16.4075 | 16.4075 | 16.4075 | 15400.0 |
| 2013-01-30 05:45:00 | AAPL | Stock | 16.4075 | 16.4204 | 16.4075 | 16.4204 | 16800.0 |
| 2013-01-30 05:50:00 | AAPL | Stock | 16.4329 | 16.4329 | 16.4121 | 16.4121 | 5600.0 |
| 2013-01-30 06:00:00 | AAPL | Stock | 16.4154 | 16.4154 | 16.4154 | 16.4154 | 2800.0 |
| 2013-01-30 06:05:00 | AAPL | Stock | 16.4021 | 16.4021 | 16.4021 | 16.4021 | 5600.0 |
| 2013-01-30 06:15:00 | AAPL | Stock | 16.4036 | 16.4036 | 16.4021 | 16.4029 | 8400.0 |
| 2013-01-30 06:20:00 | AAPL | Stock | 16.4021 | 16.4021 | 16.3886 | 16.3886 | 9800.0 |
| 2013-01-30 06:25:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 5600.0 |
| 2013-01-30 06:30:00 | AAPL | Stock | 16.3857 | 16.3857 | 16.3736 | 16.375 | 30800.0 |
| 2013-01-30 06:35:00 | AAPL | Stock | 16.375 | 16.375 | 16.3732 | 16.3732 | 28000.0 |
| 2013-01-30 06:45:00 | AAPL | Stock | 16.3529 | 16.3529 | 16.3482 | 16.3482 | 5600.0 |
| 2013-01-30 06:50:00 | AAPL | Stock | 16.3393 | 16.3393 | 16.3393 | 16.3393 | 2800.0 |
| 2013-01-30 06:55:00 | AAPL | Stock | 16.3393 | 16.3393 | 16.3214 | 16.3232 | 16940.0 |
| 2013-01-30 07:00:00 | AAPL | Stock | 16.3232 | 16.3232 | 16.3036 | 16.3125 | 28000.0 |
| 2013-01-30 07:05:00 | AAPL | Stock | 16.3039 | 16.3336 | 16.3039 | 16.3214 | 50680.0 |
| 2013-01-30 07:10:00 | AAPL | Stock | 16.3286 | 16.3357 | 16.3286 | 16.3357 | 54124.0 |
| 2013-01-30 07:15:00 | AAPL | Stock | 16.3236 | 16.3236 | 16.3214 | 16.3214 | 12264.0 |
| 2013-01-30 07:20:00 | AAPL | Stock | 16.3246 | 16.3246 | 16.3036 | 16.3211 | 94136.0 |
| 2013-01-30 07:25:00 | AAPL | Stock | 16.3204 | 16.3214 | 16.3014 | 16.3125 | 25200.0 |
| 2013-01-30 07:30:00 | AAPL | Stock | 16.3107 | 16.3107 | 16.3039 | 16.3039 | 16800.0 |
| 2013-01-30 07:35:00 | AAPL | Stock | 16.3125 | 16.3139 | 16.3125 | 16.3139 | 8400.0 |
| 2013-01-30 07:45:00 | AAPL | Stock | 16.3093 | 16.3161 | 16.2975 | 16.2975 | 80164.0 |
| 2013-01-30 07:50:00 | AAPL | Stock | 16.2889 | 16.3164 | 16.2875 | 16.3164 | 51912.0 |
| 2013-01-30 07:55:00 | AAPL | Stock | 16.3107 | 16.3111 | 16.3036 | 16.3036 | 37520.0 |
| 2013-01-30 08:00:00 | AAPL | Stock | 16.3025 | 16.3571 | 16.295 | 16.3 | 612612.0 |
| 2013-01-30 08:05:00 | AAPL | Stock | 16.2964 | 16.3075 | 16.2679 | 16.2818 | 223244.0 |
| 2013-01-30 08:10:00 | AAPL | Stock | 16.2832 | 16.3025 | 16.2679 | 16.2714 | 236600.0 |
| 2013-01-30 08:15:00 | AAPL | Stock | 16.2786 | 16.2843 | 16.2596 | 16.2679 | 200564.0 |
| 2013-01-30 08:20:00 | AAPL | Stock | 16.2682 | 16.2736 | 16.2589 | 16.2689 | 141932.0 |
| 2013-01-30 08:25:00 | AAPL | Stock | 16.2682 | 16.2757 | 16.2614 | 16.2757 | 117600.0 |
| 2013-01-30 08:30:00 | AAPL | Stock | 16.2693 | 16.2696 | 16.1807 | 16.1807 | 934780.0 |
| 2013-01-30 08:35:00 | AAPL | Stock | 16.1871 | 16.25 | 16.1871 | 16.2214 | 571088.0 |
| 2013-01-30 08:40:00 | AAPL | Stock | 16.2232 | 16.2429 | 16.2221 | 16.2221 | 237356.0 |
| 2013-01-30 08:45:00 | AAPL | Stock | 16.2304 | 16.2314 | 16.2007 | 16.2143 | 213192.0 |
| 2013-01-30 08:50:00 | AAPL | Stock | 16.2079 | 16.2282 | 16.2079 | 16.215 | 190680.0 |
| 2013-01-30 08:55:00 | AAPL | Stock | 16.2086 | 16.2296 | 16.2086 | 16.2218 | 129360.0 |
| 2013-01-30 09:00:00 | AAPL | Stock | 16.2218 | 16.2218 | 16.2011 | 16.2168 | 324716.0 |
| 2013-01-30 09:05:00 | AAPL | Stock | 16.2132 | 16.2321 | 16.2132 | 16.2282 | 241108.0 |
> showing 50 of 330,111 rows — these rows as CSV