PREVIEW / stock_5min / 2012-04-23

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-23.parquet
  size:    4.9 MB
  rows:    335,179
  symbols: 3,525

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
2012-04-23 04:00:00	AAPL	Stock	20.4643	20.4643	20.3661	20.3661	36708.0
2012-04-23 04:05:00	AAPL	Stock	20.3664	20.3664	20.2857	20.2857	96572.0
2012-04-23 04:10:00	AAPL	Stock	20.3039	20.3046	20.3039	20.3046	12180.0
2012-04-23 04:20:00	AAPL	Stock	20.3568	20.3568	20.3568	20.3568	5600.0
2012-04-23 04:25:00	AAPL	Stock	20.3568	20.3568	20.3568	20.3568	14000.0
2012-04-23 04:30:00	AAPL	Stock	20.3532	20.3532	20.3532	20.3532	2800.0
2012-04-23 04:35:00	AAPL	Stock	20.3221	20.3221	20.3221	20.3221	2800.0
2012-04-23 04:45:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	8400.0
2012-04-23 05:05:00	AAPL	Stock	20.2904	20.2904	20.2868	20.2868	44240.0
2012-04-23 05:10:00	AAPL	Stock	20.2679	20.2786	20.2679	20.275	92484.0
2012-04-23 05:15:00	AAPL	Stock	20.275	20.275	20.2679	20.2679	50176.0
2012-04-23 05:20:00	AAPL	Stock	20.2168	20.2168	20.1861	20.1861	36008.0
2012-04-23 05:25:00	AAPL	Stock	20.2143	20.2143	20.1875	20.1875	19684.0
2012-04-23 05:30:00	AAPL	Stock	20.1964	20.2143	20.1821	20.2143	37520.0
2012-04-23 05:35:00	AAPL	Stock	20.2143	20.2318	20.2143	20.2143	34468.0
2012-04-23 05:45:00	AAPL	Stock	20.2136	20.2143	20.2136	20.2143	5600.0
2012-04-23 05:50:00	AAPL	Stock	20.2146	20.2146	20.2146	20.2146	14000.0
2012-04-23 05:55:00	AAPL	Stock	20.25	20.25	20.25	20.25	2800.0
2012-04-23 06:00:00	AAPL	Stock	20.2675	20.2675	20.2568	20.2568	19600.0
2012-04-23 06:10:00	AAPL	Stock	20.2411	20.2411	20.2411	20.2411	25760.0
2012-04-23 06:15:00	AAPL	Stock	20.2675	20.2679	20.2675	20.2679	35308.0
2012-04-23 06:30:00	AAPL	Stock	20.2232	20.2232	20.2143	20.2143	18760.0
2012-04-23 06:35:00	AAPL	Stock	20.2393	20.2393	20.2393	20.2393	5600.0
2012-04-23 06:45:00	AAPL	Stock	20.2482	20.2482	20.2482	20.2482	5600.0
2012-04-23 06:50:00	AAPL	Stock	20.2479	20.2482	20.2479	20.2482	26320.0
2012-04-23 06:55:00	AAPL	Stock	20.25	20.2639	20.25	20.2639	22400.0
2012-04-23 07:00:00	AAPL	Stock	20.2639	20.3204	20.2632	20.2861	323624.0
2012-04-23 07:05:00	AAPL	Stock	20.2868	20.2964	20.2536	20.2536	262192.0
2012-04-23 07:10:00	AAPL	Stock	20.2536	20.2746	20.2536	20.2746	8400.0
2012-04-23 07:15:00	AAPL	Stock	20.275	20.275	20.2679	20.2679	39200.0
2012-04-23 07:20:00	AAPL	Stock	20.2786	20.2896	20.2786	20.2896	50176.0
2012-04-23 07:25:00	AAPL	Stock	20.2943	20.3489	20.2943	20.3393	399056.0
2012-04-23 07:30:00	AAPL	Stock	20.3271	20.3386	20.3036	20.3036	108332.0
2012-04-23 07:35:00	AAPL	Stock	20.2914	20.2982	20.2857	20.2857	47264.0
2012-04-23 07:40:00	AAPL	Stock	20.2736	20.2846	20.2732	20.2789	67900.0
2012-04-23 07:45:00	AAPL	Stock	20.2768	20.2775	20.25	20.2768	329364.0
2012-04-23 07:50:00	AAPL	Stock	20.2768	20.2768	20.25	20.2679	61964.0
2012-04-23 07:55:00	AAPL	Stock	20.2686	20.2925	20.2679	20.2857	77224.0
2012-04-23 08:00:00	AAPL	Stock	20.2939	20.3429	20.2686	20.3007	675444.0
2012-04-23 08:05:00	AAPL	Stock	20.3	20.3125	20.2775	20.3032	679980.0
2012-04-23 08:10:00	AAPL	Stock	20.3046	20.3318	20.2904	20.3125	313768.0
2012-04-23 08:15:00	AAPL	Stock	20.3121	20.3214	20.2964	20.3011	394884.0
2012-04-23 08:20:00	AAPL	Stock	20.3086	20.3086	20.27	20.2893	763056.0
2012-04-23 08:25:00	AAPL	Stock	20.2907	20.3114	20.29	20.3068	246204.0
2012-04-23 08:30:00	AAPL	Stock	20.3068	20.3464	20.3068	20.3439	363412.0
2012-04-23 08:35:00	AAPL	Stock	20.3461	20.4107	20.3286	20.4107	678776.0
2012-04-23 08:40:00	AAPL	Stock	20.4046	20.4207	20.3875	20.4204	342328.0
2012-04-23 08:45:00	AAPL	Stock	20.4214	20.4414	20.4107	20.4375	694064.0
2012-04-23 08:50:00	AAPL	Stock	20.4404	20.4754	20.4286	20.4286	1475236.0
2012-04-23 08:55:00	AAPL	Stock	20.4286	20.4457	20.4143	20.4339	678860.0

> showing 50 of 335,179 rows — these rows as CSV

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