PREVIEW / stock_5min / 2011-06-21

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-21.parquet
  size:    4.9 MB
  rows:    337,348
  symbols: 3,560

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-21 04:00:00	AAPL	Stock	11.2679	11.2679	11.2679	11.2679	11200.0
2011-06-21 04:10:00	AAPL	Stock	11.2907	11.2907	11.2907	11.2907	2800.0
2011-06-21 04:35:00	AAPL	Stock	11.2907	11.2907	11.2907	11.2907	2800.0
2011-06-21 04:45:00	AAPL	Stock	11.2875	11.2875	11.2875	11.2875	2800.0
2011-06-21 05:45:00	AAPL	Stock	11.2789	11.2789	11.2789	11.2789	2800.0
2011-06-21 06:00:00	AAPL	Stock	11.2586	11.2586	11.2586	11.2586	2800.0
2011-06-21 06:15:00	AAPL	Stock	11.265	11.2679	11.2589	11.2679	19600.0
2011-06-21 06:20:00	AAPL	Stock	11.275	11.275	11.275	11.275	2800.0
2011-06-21 06:35:00	AAPL	Stock	11.2739	11.2739	11.2739	11.2739	2800.0
2011-06-21 06:40:00	AAPL	Stock	11.2818	11.2818	11.265	11.265	30800.0
2011-06-21 06:45:00	AAPL	Stock	11.2661	11.2661	11.2661	11.2661	2800.0
2011-06-21 06:50:00	AAPL	Stock	11.28	11.28	11.28	11.28	5600.0
2011-06-21 07:00:00	AAPL	Stock	11.285	11.2957	11.285	11.2957	11200.0
2011-06-21 07:05:00	AAPL	Stock	11.2932	11.3214	11.2932	11.3214	53424.0
2011-06-21 07:10:00	AAPL	Stock	11.3143	11.3146	11.3075	11.3143	40964.0
2011-06-21 07:15:00	AAPL	Stock	11.3143	11.3143	11.3143	11.3143	41356.0
2011-06-21 07:20:00	AAPL	Stock	11.3211	11.3214	11.3082	11.3214	30800.0
2011-06-21 07:25:00	AAPL	Stock	11.3254	11.3304	11.3254	11.3304	18200.0
2011-06-21 07:30:00	AAPL	Stock	11.3361	11.3393	11.3325	11.3375	30800.0
2011-06-21 07:35:00	AAPL	Stock	11.3375	11.3446	11.3339	11.3446	97552.0
2011-06-21 07:40:00	AAPL	Stock	11.3482	11.3693	11.3482	11.3661	215852.0
2011-06-21 07:45:00	AAPL	Stock	11.3661	11.3668	11.3396	11.3396	191772.0
2011-06-21 07:50:00	AAPL	Stock	11.3429	11.3539	11.3425	11.3496	83496.0
2011-06-21 07:55:00	AAPL	Stock	11.3496	11.3496	11.3482	11.3493	11200.0
2011-06-21 08:00:00	AAPL	Stock	11.3464	11.3525	11.3214	11.3357	276836.0
2011-06-21 08:05:00	AAPL	Stock	11.3339	11.3446	11.3339	11.3432	89908.0
2011-06-21 08:10:00	AAPL	Stock	11.3393	11.35	11.3393	11.3457	419720.0
2011-06-21 08:15:00	AAPL	Stock	11.3457	11.3489	11.3429	11.3429	59864.0
2011-06-21 08:20:00	AAPL	Stock	11.3429	11.3489	11.2614	11.3389	139664.0
2011-06-21 08:25:00	AAPL	Stock	11.3389	11.3482	11.3389	11.3446	86856.0
2011-06-21 08:30:00	AAPL	Stock	11.3411	11.3411	11.3332	11.3393	49112.0
2011-06-21 08:35:00	AAPL	Stock	11.3393	11.3443	11.3321	11.3357	95900.0
2011-06-21 08:40:00	AAPL	Stock	11.3357	11.3357	11.3104	11.3179	451416.0
2011-06-21 08:45:00	AAPL	Stock	11.3143	11.325	11.3143	11.3214	201096.0
2011-06-21 08:50:00	AAPL	Stock	11.3225	11.3282	11.3218	11.325	76776.0
2011-06-21 08:55:00	AAPL	Stock	11.325	11.3375	11.325	11.3375	174916.0
2011-06-21 09:00:00	AAPL	Stock	11.3375	11.3379	11.3318	11.3364	113512.0
2011-06-21 09:05:00	AAPL	Stock	11.3336	11.3336	11.3214	11.3275	145236.0
2011-06-21 09:10:00	AAPL	Stock	11.3239	11.3279	11.3189	11.325	161140.0
2011-06-21 09:15:00	AAPL	Stock	11.325	11.325	11.3107	11.3107	146496.0
2011-06-21 09:20:00	AAPL	Stock	11.305	11.3089	11.2979	11.3089	192472.0
2011-06-21 09:25:00	AAPL	Stock	11.3089	11.3164	11.3054	11.3129	269052.0
2011-06-21 09:30:00	AAPL	Stock	11.3129	11.3636	11.2671	11.2732	27451144.0
2011-06-21 09:35:00	AAPL	Stock	11.2754	11.3129	11.2686	11.2886	12384204.0
2011-06-21 09:40:00	AAPL	Stock	11.2864	11.3379	11.2571	11.3143	15783292.0
2011-06-21 09:45:00	AAPL	Stock	11.3179	11.3343	11.3	11.3079	10001544.0
2011-06-21 09:50:00	AAPL	Stock	11.3064	11.3979	11.3036	11.3931	16624664.0
2011-06-21 09:55:00	AAPL	Stock	11.3907	11.4057	11.3811	11.3856	9986452.0
2011-06-21 10:00:00	AAPL	Stock	11.3854	11.4346	11.3799	11.4266	14893760.0
2011-06-21 10:05:00	AAPL	Stock	11.4268	11.4586	11.4214	11.4586	12179860.0

> showing 50 of 337,348 rows — these rows as CSV

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