PREVIEW / stock_5min / 2013-04-23
file: by_date/stock_5min/2013/2013-04-23.parquet size: 5.0 MB rows: 329,863 symbols: 3,477
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-04-23 04:15:00 | AAPL | Stock | 14.2643 | 14.2643 | 14.2643 | 14.2643 | 5600.0 |
| 2013-04-23 04:25:00 | AAPL | Stock | 14.2289 | 14.2289 | 14.2289 | 14.2289 | 6328.0 |
| 2013-04-23 04:35:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 14000.0 |
| 2013-04-23 04:40:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 47236.0 |
| 2013-04-23 04:45:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2375 | 14.2382 | 69944.0 |
| 2013-04-23 04:50:00 | AAPL | Stock | 14.2143 | 14.2175 | 14.2143 | 14.2175 | 16380.0 |
| 2013-04-23 04:55:00 | AAPL | Stock | 14.2282 | 14.2282 | 14.2282 | 14.2282 | 5376.0 |
| 2013-04-23 05:00:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 14000.0 |
| 2013-04-23 05:05:00 | AAPL | Stock | 14.2321 | 14.2386 | 14.2321 | 14.2386 | 16800.0 |
| 2013-04-23 05:10:00 | AAPL | Stock | 14.2429 | 14.2429 | 14.2429 | 14.2429 | 2800.0 |
| 2013-04-23 06:05:00 | AAPL | Stock | 14.2711 | 14.2711 | 14.2711 | 14.2711 | 2800.0 |
| 2013-04-23 06:30:00 | AAPL | Stock | 14.275 | 14.275 | 14.275 | 14.275 | 2800.0 |
| 2013-04-23 07:05:00 | AAPL | Stock | 14.2857 | 14.3086 | 14.2857 | 14.2943 | 38500.0 |
| 2013-04-23 07:10:00 | AAPL | Stock | 14.3118 | 14.3379 | 14.3118 | 14.3379 | 17976.0 |
| 2013-04-23 07:15:00 | AAPL | Stock | 14.3214 | 14.4107 | 14.3214 | 14.3871 | 201796.0 |
| 2013-04-23 07:20:00 | AAPL | Stock | 14.3804 | 14.3804 | 14.3571 | 14.3571 | 114240.0 |
| 2013-04-23 07:25:00 | AAPL | Stock | 14.3571 | 14.3661 | 14.3571 | 14.3625 | 29260.0 |
| 2013-04-23 07:30:00 | AAPL | Stock | 14.3571 | 14.4096 | 14.3564 | 14.4096 | 181468.0 |
| 2013-04-23 07:35:00 | AAPL | Stock | 14.3929 | 14.4018 | 14.3754 | 14.3929 | 131572.0 |
| 2013-04-23 07:40:00 | AAPL | Stock | 14.3957 | 14.4371 | 14.3957 | 14.43 | 413980.0 |
| 2013-04-23 07:45:00 | AAPL | Stock | 14.4289 | 14.4446 | 14.4114 | 14.4229 | 201460.0 |
| 2013-04-23 07:50:00 | AAPL | Stock | 14.4268 | 14.4286 | 14.405 | 14.4107 | 174888.0 |
| 2013-04-23 07:55:00 | AAPL | Stock | 14.4182 | 14.4196 | 14.405 | 14.405 | 29176.0 |
| 2013-04-23 08:00:00 | AAPL | Stock | 14.3943 | 14.4286 | 14.3218 | 14.3832 | 530740.0 |
| 2013-04-23 08:05:00 | AAPL | Stock | 14.3836 | 14.4071 | 14.3836 | 14.3939 | 99708.0 |
| 2013-04-23 08:10:00 | AAPL | Stock | 14.3946 | 14.3964 | 14.3839 | 14.3914 | 99540.0 |
| 2013-04-23 08:15:00 | AAPL | Stock | 14.3925 | 14.3925 | 14.3571 | 14.3575 | 280252.0 |
| 2013-04-23 08:20:00 | AAPL | Stock | 14.3643 | 14.3643 | 14.3457 | 14.3518 | 279440.0 |
| 2013-04-23 08:25:00 | AAPL | Stock | 14.3536 | 14.375 | 14.3471 | 14.375 | 199808.0 |
| 2013-04-23 08:30:00 | AAPL | Stock | 14.3689 | 14.4089 | 14.3571 | 14.3929 | 324352.0 |
| 2013-04-23 08:35:00 | AAPL | Stock | 14.3929 | 14.4107 | 14.39 | 14.4107 | 197540.0 |
| 2013-04-23 08:40:00 | AAPL | Stock | 14.4071 | 14.4107 | 14.3911 | 14.4 | 194320.0 |
| 2013-04-23 08:45:00 | AAPL | Stock | 14.4018 | 14.4018 | 14.3804 | 14.3929 | 124880.0 |
| 2013-04-23 08:50:00 | AAPL | Stock | 14.3846 | 14.3907 | 14.3775 | 14.3907 | 71400.0 |
| 2013-04-23 08:55:00 | AAPL | Stock | 14.3811 | 14.3929 | 14.3811 | 14.3886 | 58296.0 |
| 2013-04-23 09:00:00 | AAPL | Stock | 14.3843 | 14.3843 | 14.3643 | 14.3643 | 145628.0 |
| 2013-04-23 09:05:00 | AAPL | Stock | 14.3643 | 14.3643 | 14.3429 | 14.3571 | 233352.0 |
| 2013-04-23 09:10:00 | AAPL | Stock | 14.3571 | 14.3621 | 14.3414 | 14.3536 | 701652.0 |
| 2013-04-23 09:15:00 | AAPL | Stock | 14.3568 | 14.3786 | 14.3543 | 14.3786 | 894964.0 |
| 2013-04-23 09:20:00 | AAPL | Stock | 14.3732 | 14.4104 | 14.3732 | 14.3939 | 374360.0 |
| 2013-04-23 09:25:00 | AAPL | Stock | 14.4018 | 14.4357 | 14.3961 | 14.4275 | 1034516.0 |
| 2013-04-23 09:30:00 | AAPL | Stock | 14.4275 | 14.4732 | 14.3946 | 14.4093 | 22195432.0 |
| 2013-04-23 09:35:00 | AAPL | Stock | 14.4093 | 14.4418 | 14.3321 | 14.3468 | 14893088.0 |
| 2013-04-23 09:40:00 | AAPL | Stock | 14.3464 | 14.3568 | 14.2671 | 14.3013 | 17015376.0 |
| 2013-04-23 09:45:00 | AAPL | Stock | 14.3004 | 14.3125 | 14.2593 | 14.3075 | 9032380.0 |
| 2013-04-23 09:50:00 | AAPL | Stock | 14.3079 | 14.3443 | 14.2804 | 14.3136 | 7901404.0 |
| 2013-04-23 09:55:00 | AAPL | Stock | 14.315 | 14.3393 | 14.2993 | 14.3279 | 4656988.0 |
| 2013-04-23 10:00:00 | AAPL | Stock | 14.3246 | 14.3846 | 14.2971 | 14.3154 | 7624680.0 |
| 2013-04-23 10:05:00 | AAPL | Stock | 14.3189 | 14.3196 | 14.27 | 14.2982 | 6703648.0 |
| 2013-04-23 10:10:00 | AAPL | Stock | 14.2995 | 14.2996 | 14.2432 | 14.2857 | 7779352.0 |
> showing 50 of 329,863 rows — these rows as CSV