PREVIEW / stock_5min / 2013-03-19
file: by_date/stock_5min/2013/2013-03-19.parquet size: 5.1 MB rows: 336,525 symbols: 3,468
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-03-19 04:05:00 | AAPL | Stock | 16.325 | 16.325 | 16.325 | 16.325 | 2800.0 |
| 2013-03-19 04:35:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3121 | 16.3121 | 5600.0 |
| 2013-03-19 04:40:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 2800.0 |
| 2013-03-19 04:45:00 | AAPL | Stock | 16.325 | 16.325 | 16.325 | 16.325 | 2800.0 |
| 2013-03-19 04:55:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 14000.0 |
| 2013-03-19 05:15:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 11200.0 |
| 2013-03-19 05:20:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 14000.0 |
| 2013-03-19 05:50:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 2800.0 |
| 2013-03-19 06:00:00 | AAPL | Stock | 16.3375 | 16.3375 | 16.3375 | 16.3375 | 2800.0 |
| 2013-03-19 06:10:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 2800.0 |
| 2013-03-19 06:20:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 14000.0 |
| 2013-03-19 06:25:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.2911 | 16.2911 | 11200.0 |
| 2013-03-19 06:30:00 | AAPL | Stock | 16.3125 | 16.3125 | 16.3125 | 16.3125 | 2800.0 |
| 2013-03-19 06:35:00 | AAPL | Stock | 16.3 | 16.3 | 16.3 | 16.3 | 5600.0 |
| 2013-03-19 06:45:00 | AAPL | Stock | 16.2861 | 16.3 | 16.2857 | 16.3 | 41440.0 |
| 2013-03-19 06:50:00 | AAPL | Stock | 16.3 | 16.3 | 16.3 | 16.3 | 2800.0 |
| 2013-03-19 06:55:00 | AAPL | Stock | 16.3 | 16.3 | 16.3 | 16.3 | 32200.0 |
| 2013-03-19 07:00:00 | AAPL | Stock | 16.3 | 16.3 | 16.2507 | 16.2661 | 119784.0 |
| 2013-03-19 07:05:00 | AAPL | Stock | 16.2675 | 16.2829 | 16.2675 | 16.2829 | 32872.0 |
| 2013-03-19 07:10:00 | AAPL | Stock | 16.2829 | 16.2857 | 16.2829 | 16.2857 | 23800.0 |
| 2013-03-19 07:15:00 | AAPL | Stock | 16.2857 | 16.2925 | 16.2857 | 16.2925 | 15680.0 |
| 2013-03-19 07:20:00 | AAPL | Stock | 16.3 | 16.3107 | 16.3 | 16.3032 | 28000.0 |
| 2013-03-19 07:25:00 | AAPL | Stock | 16.2932 | 16.3036 | 16.2914 | 16.3036 | 14000.0 |
| 2013-03-19 07:30:00 | AAPL | Stock | 16.3011 | 16.3011 | 16.2964 | 16.2964 | 8400.0 |
| 2013-03-19 07:35:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 4368.0 |
| 2013-03-19 07:40:00 | AAPL | Stock | 16.3107 | 16.3125 | 16.3107 | 16.3125 | 25200.0 |
| 2013-03-19 07:45:00 | AAPL | Stock | 16.3125 | 16.3182 | 16.3025 | 16.3025 | 47600.0 |
| 2013-03-19 07:50:00 | AAPL | Stock | 16.3057 | 16.3136 | 16.3057 | 16.3118 | 39200.0 |
| 2013-03-19 07:55:00 | AAPL | Stock | 16.3125 | 16.3261 | 16.3125 | 16.3204 | 82040.0 |
| 2013-03-19 08:00:00 | AAPL | Stock | 16.3 | 16.4068 | 16.2679 | 16.3904 | 1037820.0 |
| 2013-03-19 08:05:00 | AAPL | Stock | 16.3821 | 16.4143 | 16.3764 | 16.4143 | 412944.0 |
| 2013-03-19 08:10:00 | AAPL | Stock | 16.4121 | 16.4439 | 16.3939 | 16.4043 | 661892.0 |
| 2013-03-19 08:15:00 | AAPL | Stock | 16.4043 | 16.4111 | 16.4004 | 16.4071 | 194264.0 |
| 2013-03-19 08:20:00 | AAPL | Stock | 16.4096 | 16.4111 | 16.3839 | 16.3857 | 427560.0 |
| 2013-03-19 08:25:00 | AAPL | Stock | 16.3893 | 16.4125 | 16.3893 | 16.4114 | 110824.0 |
| 2013-03-19 08:30:00 | AAPL | Stock | 16.4021 | 16.4107 | 16.3929 | 16.3946 | 198884.0 |
| 2013-03-19 08:35:00 | AAPL | Stock | 16.4 | 16.4104 | 16.3929 | 16.3993 | 255108.0 |
| 2013-03-19 08:40:00 | AAPL | Stock | 16.4021 | 16.4179 | 16.3964 | 16.4121 | 253008.0 |
| 2013-03-19 08:45:00 | AAPL | Stock | 16.4175 | 16.4221 | 16.4054 | 16.4054 | 342216.0 |
| 2013-03-19 08:50:00 | AAPL | Stock | 16.4054 | 16.4157 | 16.4036 | 16.4157 | 174776.0 |
| 2013-03-19 08:55:00 | AAPL | Stock | 16.4129 | 16.4129 | 16.4018 | 16.4018 | 233800.0 |
| 2013-03-19 09:00:00 | AAPL | Stock | 16.4064 | 16.4064 | 16.3768 | 16.3818 | 439236.0 |
| 2013-03-19 09:05:00 | AAPL | Stock | 16.3818 | 16.3846 | 16.3768 | 16.3768 | 170100.0 |
| 2013-03-19 09:10:00 | AAPL | Stock | 16.3768 | 16.4 | 16.3768 | 16.3882 | 275660.0 |
| 2013-03-19 09:15:00 | AAPL | Stock | 16.3893 | 16.4018 | 16.3893 | 16.3943 | 222488.0 |
| 2013-03-19 09:20:00 | AAPL | Stock | 16.3986 | 16.3993 | 16.39 | 16.3929 | 289408.0 |
| 2013-03-19 09:25:00 | AAPL | Stock | 16.3961 | 16.4221 | 16.3932 | 16.41 | 1337588.0 |
| 2013-03-19 09:30:00 | AAPL | Stock | 16.4107 | 16.4632 | 16.3657 | 16.4014 | 31119872.0 |
| 2013-03-19 09:35:00 | AAPL | Stock | 16.4004 | 16.4464 | 16.3839 | 16.3843 | 19838896.0 |
| 2013-03-19 09:40:00 | AAPL | Stock | 16.385 | 16.4171 | 16.3393 | 16.3607 | 15901900.0 |
> showing 50 of 336,525 rows — these rows as CSV