PREVIEW / stock_5min / 2013-09-11
file: by_date/stock_5min/2013/2013-09-11.parquet size: 5.1 MB rows: 339,401 symbols: 3,519
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-09-11 04:00:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.3557 | 17.3557 | 44380.0 |
| 2013-09-11 04:10:00 | AAPL | Stock | 17.3564 | 17.3571 | 17.3557 | 17.3557 | 14000.0 |
| 2013-09-11 04:15:00 | AAPL | Stock | 17.375 | 17.3886 | 17.375 | 17.3886 | 6972.0 |
| 2013-09-11 04:20:00 | AAPL | Stock | 17.3754 | 17.3754 | 17.3454 | 17.3454 | 23632.0 |
| 2013-09-11 04:25:00 | AAPL | Stock | 17.3354 | 17.3354 | 17.3354 | 17.3354 | 3360.0 |
| 2013-09-11 04:30:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.2857 | 17.2857 | 49168.0 |
| 2013-09-11 04:35:00 | AAPL | Stock | 17.2886 | 17.2886 | 17.2886 | 17.2886 | 2800.0 |
| 2013-09-11 04:40:00 | AAPL | Stock | 17.2911 | 17.2911 | 17.2643 | 17.2643 | 44240.0 |
| 2013-09-11 04:45:00 | AAPL | Stock | 17.3079 | 17.3357 | 17.3079 | 17.3357 | 16800.0 |
| 2013-09-11 04:50:00 | AAPL | Stock | 17.3243 | 17.3243 | 17.2886 | 17.2886 | 31500.0 |
| 2013-09-11 04:55:00 | AAPL | Stock | 17.2929 | 17.3164 | 17.2814 | 17.3161 | 37324.0 |
| 2013-09-11 05:00:00 | AAPL | Stock | 17.315 | 17.3157 | 17.315 | 17.3157 | 5600.0 |
| 2013-09-11 05:05:00 | AAPL | Stock | 17.3157 | 17.3161 | 17.3036 | 17.3125 | 79800.0 |
| 2013-09-11 05:10:00 | AAPL | Stock | 17.3136 | 17.3214 | 17.2857 | 17.2857 | 78652.0 |
| 2013-09-11 05:15:00 | AAPL | Stock | 17.2896 | 17.2896 | 17.2896 | 17.2896 | 2800.0 |
| 2013-09-11 05:20:00 | AAPL | Stock | 17.2893 | 17.2989 | 17.2846 | 17.2964 | 36400.0 |
| 2013-09-11 05:25:00 | AAPL | Stock | 17.3086 | 17.3125 | 17.2861 | 17.2946 | 108500.0 |
| 2013-09-11 05:30:00 | AAPL | Stock | 17.3036 | 17.3125 | 17.3036 | 17.3125 | 5600.0 |
| 2013-09-11 05:35:00 | AAPL | Stock | 17.3204 | 17.3271 | 17.3036 | 17.3036 | 61236.0 |
| 2013-09-11 05:40:00 | AAPL | Stock | 17.3232 | 17.3232 | 17.3186 | 17.3186 | 22400.0 |
| 2013-09-11 05:45:00 | AAPL | Stock | 17.3182 | 17.325 | 17.3054 | 17.325 | 30772.0 |
| 2013-09-11 05:50:00 | AAPL | Stock | 17.3254 | 17.3421 | 17.3071 | 17.3421 | 68964.0 |
| 2013-09-11 05:55:00 | AAPL | Stock | 17.3111 | 17.3111 | 17.3111 | 17.3111 | 21392.0 |
| 2013-09-11 06:00:00 | AAPL | Stock | 17.3229 | 17.3471 | 17.3214 | 17.3404 | 82208.0 |
| 2013-09-11 06:05:00 | AAPL | Stock | 17.3218 | 17.3254 | 17.2793 | 17.2793 | 152880.0 |
| 2013-09-11 06:10:00 | AAPL | Stock | 17.2857 | 17.2857 | 17.2639 | 17.2796 | 34244.0 |
| 2013-09-11 06:15:00 | AAPL | Stock | 17.2679 | 17.2821 | 17.25 | 17.2821 | 120876.0 |
| 2013-09-11 06:20:00 | AAPL | Stock | 17.2643 | 17.2839 | 17.2454 | 17.2839 | 71932.0 |
| 2013-09-11 06:25:00 | AAPL | Stock | 17.25 | 17.2639 | 17.25 | 17.2639 | 34076.0 |
| 2013-09-11 06:30:00 | AAPL | Stock | 17.2589 | 17.2643 | 17.2589 | 17.2643 | 17920.0 |
| 2013-09-11 06:35:00 | AAPL | Stock | 17.2675 | 17.2675 | 17.2446 | 17.2446 | 14000.0 |
| 2013-09-11 06:40:00 | AAPL | Stock | 17.2579 | 17.2679 | 17.2496 | 17.25 | 218260.0 |
| 2013-09-11 06:45:00 | AAPL | Stock | 17.25 | 17.2579 | 17.1996 | 17.1996 | 175840.0 |
| 2013-09-11 06:50:00 | AAPL | Stock | 17.22 | 17.2343 | 17.2 | 17.2 | 145516.0 |
| 2013-09-11 06:55:00 | AAPL | Stock | 17.2 | 17.2136 | 17.2 | 17.2136 | 28000.0 |
| 2013-09-11 07:00:00 | AAPL | Stock | 17.2214 | 17.2496 | 17.2143 | 17.2143 | 279076.0 |
| 2013-09-11 07:05:00 | AAPL | Stock | 17.2143 | 17.2146 | 17.1696 | 17.1696 | 165788.0 |
| 2013-09-11 07:10:00 | AAPL | Stock | 17.1786 | 17.2036 | 17.1786 | 17.1861 | 473704.0 |
| 2013-09-11 07:15:00 | AAPL | Stock | 17.1964 | 17.1964 | 17.15 | 17.18 | 209272.0 |
| 2013-09-11 07:20:00 | AAPL | Stock | 17.18 | 17.1875 | 17.1521 | 17.1629 | 227864.0 |
| 2013-09-11 07:25:00 | AAPL | Stock | 17.1643 | 17.1786 | 17.0957 | 17.1036 | 873236.0 |
| 2013-09-11 07:30:00 | AAPL | Stock | 17.1036 | 17.1125 | 17.0179 | 17.0293 | 1390928.0 |
| 2013-09-11 07:35:00 | AAPL | Stock | 17.0361 | 17.0571 | 16.9993 | 17.0332 | 1258432.0 |
| 2013-09-11 07:40:00 | AAPL | Stock | 17.0232 | 17.0357 | 16.9661 | 16.9661 | 1107596.0 |
| 2013-09-11 07:45:00 | AAPL | Stock | 16.9657 | 17.0014 | 16.91 | 16.91 | 1500716.0 |
| 2013-09-11 07:50:00 | AAPL | Stock | 16.9154 | 16.9336 | 16.8857 | 16.9336 | 1844248.0 |
| 2013-09-11 07:55:00 | AAPL | Stock | 16.9254 | 16.9643 | 16.9214 | 16.9554 | 2029580.0 |
| 2013-09-11 08:00:00 | AAPL | Stock | 16.95 | 17.0536 | 16.8857 | 16.9643 | 4365592.0 |
| 2013-09-11 08:05:00 | AAPL | Stock | 16.9607 | 16.975 | 16.9382 | 16.9564 | 1034432.0 |
| 2013-09-11 08:10:00 | AAPL | Stock | 16.9625 | 16.9875 | 16.9464 | 16.9682 | 1430996.0 |
> showing 50 of 339,401 rows — these rows as CSV