PREVIEW / stock_5min / 2011-06-20

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-20.parquet
  size:    4.9 MB
  rows:    333,935
  symbols: 3,549

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
2011-06-20 04:00:00	AAPL	Stock	11.5	11.5	11.5	11.5	2800.0
2011-06-20 04:25:00	AAPL	Stock	11.35	11.35	11.35	11.35	5600.0
2011-06-20 04:30:00	AAPL	Stock	11.3954	11.3954	11.3954	11.3954	2800.0
2011-06-20 04:35:00	AAPL	Stock	11.3529	11.3529	11.3529	11.3529	2996.0
2011-06-20 05:05:00	AAPL	Stock	11.4	11.4	11.4	11.4	2800.0
2011-06-20 06:15:00	AAPL	Stock	11.3875	11.3875	11.3875	11.3875	2800.0
2011-06-20 06:50:00	AAPL	Stock	11.4104	11.4104	11.4104	11.4104	5600.0
2011-06-20 07:00:00	AAPL	Stock	11.3932	11.3932	11.3757	11.3768	52920.0
2011-06-20 07:05:00	AAPL	Stock	11.38	11.3846	11.3757	11.3814	34020.0
2011-06-20 07:10:00	AAPL	Stock	11.3918	11.3918	11.3771	11.3786	61600.0
2011-06-20 07:15:00	AAPL	Stock	11.3771	11.3771	11.3771	11.3771	2800.0
2011-06-20 07:20:00	AAPL	Stock	11.3771	11.3771	11.3764	11.3764	5600.0
2011-06-20 07:25:00	AAPL	Stock	11.3771	11.385	11.3771	11.385	11200.0
2011-06-20 07:30:00	AAPL	Stock	11.3779	11.3779	11.3757	11.3775	66696.0
2011-06-20 07:35:00	AAPL	Stock	11.3761	11.3775	11.3757	11.3775	15400.0
2011-06-20 07:40:00	AAPL	Stock	11.3757	11.3768	11.3657	11.3657	146636.0
2011-06-20 07:45:00	AAPL	Stock	11.365	11.3661	11.3429	11.3564	145656.0
2011-06-20 07:50:00	AAPL	Stock	11.3536	11.3536	11.34	11.34	70336.0
2011-06-20 07:55:00	AAPL	Stock	11.34	11.3511	11.3393	11.3464	102088.0
2011-06-20 08:00:00	AAPL	Stock	11.3511	11.3571	11.3396	11.3518	259980.0
2011-06-20 08:05:00	AAPL	Stock	11.3457	11.3571	11.3457	11.3496	213080.0
2011-06-20 08:10:00	AAPL	Stock	11.3446	11.3446	11.2929	11.2964	507360.0
2011-06-20 08:15:00	AAPL	Stock	11.2971	11.3036	11.2911	11.2968	470372.0
2011-06-20 08:20:00	AAPL	Stock	11.3	11.3161	11.3	11.3018	127344.0
2011-06-20 08:25:00	AAPL	Stock	11.3025	11.3186	11.3018	11.3186	339892.0
2011-06-20 08:30:00	AAPL	Stock	11.3161	11.3504	11.3071	11.3486	488628.0
2011-06-20 08:35:00	AAPL	Stock	11.3464	11.3482	11.3321	11.3407	317800.0
2011-06-20 08:40:00	AAPL	Stock	11.3429	11.3464	11.3396	11.3446	175532.0
2011-06-20 08:45:00	AAPL	Stock	11.3436	11.35	11.3357	11.3357	133616.0
2011-06-20 08:50:00	AAPL	Stock	11.3357	11.3364	11.3286	11.3286	279524.0
2011-06-20 08:55:00	AAPL	Stock	11.3289	11.3357	11.3286	11.3343	152040.0
2011-06-20 09:00:00	AAPL	Stock	11.3339	11.3393	11.33	11.3389	141260.0
2011-06-20 09:05:00	AAPL	Stock	11.3393	11.3539	11.3357	11.3536	176428.0
2011-06-20 09:10:00	AAPL	Stock	11.3561	11.3571	11.3418	11.3482	375928.0
2011-06-20 09:15:00	AAPL	Stock	11.3464	11.3464	11.3325	11.3375	28000.0
2011-06-20 09:20:00	AAPL	Stock	11.3314	11.3564	11.3314	11.3557	369012.0
2011-06-20 09:25:00	AAPL	Stock	11.3468	11.3546	11.3268	11.3364	776440.0
2011-06-20 09:30:00	AAPL	Stock	11.3325	11.3364	11.2321	11.2502	38901380.0
2011-06-20 09:35:00	AAPL	Stock	11.2521	11.2814	11.2436	11.2614	17364228.0
2011-06-20 09:40:00	AAPL	Stock	11.2605	11.3143	11.2586	11.2971	18511640.0
2011-06-20 09:45:00	AAPL	Stock	11.2966	11.3218	11.2807	11.3211	10692752.0
2011-06-20 09:50:00	AAPL	Stock	11.3193	11.3321	11.3004	11.3009	10536456.0
2011-06-20 09:55:00	AAPL	Stock	11.3043	11.3211	11.2764	11.2789	7760116.0
2011-06-20 10:00:00	AAPL	Stock	11.2796	11.2911	11.2643	11.2746	9243752.0
2011-06-20 10:05:00	AAPL	Stock	11.2754	11.2805	11.2082	11.2236	15875328.0
2011-06-20 10:10:00	AAPL	Stock	11.2259	11.2304	11.1536	11.1557	22244516.0
2011-06-20 10:15:00	AAPL	Stock	11.1554	11.1686	11.0893	11.1518	32108384.0
2011-06-20 10:20:00	AAPL	Stock	11.1525	11.1714	11.1321	11.1532	18888940.0
2011-06-20 10:25:00	AAPL	Stock	11.1543	11.1854	11.129	11.1813	15594096.0
2011-06-20 10:30:00	AAPL	Stock	11.1828	11.2211	11.1814	11.2043	17479392.0

> showing 50 of 333,935 rows — these rows as CSV

> unlock the full archive -- $79 one-time