PREVIEW / stock_5min / 2012-04-04

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-04.parquet
  size:    4.9 MB
  rows:    331,388
  symbols: 3,510

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-04 04:00:00	AAPL	Stock	22.3929	22.3929	22.3929	22.3929	5600.0
2012-04-04 04:10:00	AAPL	Stock	22.3732	22.3732	22.3732	22.3732	11200.0
2012-04-04 05:05:00	AAPL	Stock	22.3239	22.3571	22.3239	22.3571	25200.0
2012-04-04 05:15:00	AAPL	Stock	22.3393	22.3393	22.3393	22.3393	2800.0
2012-04-04 05:25:00	AAPL	Stock	22.3393	22.3393	22.3236	22.3236	16436.0
2012-04-04 05:30:00	AAPL	Stock	22.3239	22.3286	22.3214	22.3214	36904.0
2012-04-04 05:35:00	AAPL	Stock	22.3232	22.3232	22.3232	22.3232	5600.0
2012-04-04 05:40:00	AAPL	Stock	22.3214	22.3214	22.3214	22.3214	2800.0
2012-04-04 05:45:00	AAPL	Stock	22.3375	22.3411	22.3375	22.3411	21000.0
2012-04-04 05:50:00	AAPL	Stock	22.3411	22.3411	22.3411	22.3411	2800.0
2012-04-04 06:00:00	AAPL	Stock	22.3304	22.3304	22.3304	22.3304	11256.0
2012-04-04 06:10:00	AAPL	Stock	22.325	22.325	22.305	22.305	8400.0
2012-04-04 06:25:00	AAPL	Stock	22.3054	22.3054	22.3032	22.3032	5600.0
2012-04-04 06:30:00	AAPL	Stock	22.3036	22.3036	22.3036	22.3036	5600.0
2012-04-04 06:35:00	AAPL	Stock	22.3179	22.3214	22.3179	22.3214	44800.0
2012-04-04 06:40:00	AAPL	Stock	22.3214	22.3321	22.3214	22.3321	19600.0
2012-04-04 06:45:00	AAPL	Stock	22.3304	22.3304	22.3304	22.3304	2800.0
2012-04-04 06:50:00	AAPL	Stock	22.3214	22.3214	22.3214	22.3214	7000.0
2012-04-04 06:55:00	AAPL	Stock	22.3179	22.3179	22.3036	22.3036	19600.0
2012-04-04 07:00:00	AAPL	Stock	22.3107	22.3214	22.2857	22.2929	126280.0
2012-04-04 07:05:00	AAPL	Stock	22.2943	22.3018	22.2714	22.3018	92960.0
2012-04-04 07:10:00	AAPL	Stock	22.3036	22.3125	22.2857	22.2857	71764.0
2012-04-04 07:15:00	AAPL	Stock	22.2732	22.2857	22.2732	22.2857	16968.0
2012-04-04 07:20:00	AAPL	Stock	22.2786	22.2786	22.255	22.2571	67480.0
2012-04-04 07:25:00	AAPL	Stock	22.2607	22.2796	22.2607	22.2768	141456.0
2012-04-04 07:30:00	AAPL	Stock	22.2793	22.2857	22.2679	22.275	109480.0
2012-04-04 07:35:00	AAPL	Stock	22.2782	22.2814	22.275	22.2814	80164.0
2012-04-04 07:40:00	AAPL	Stock	22.2768	22.2982	22.2768	22.2946	83020.0
2012-04-04 07:45:00	AAPL	Stock	22.2943	22.3068	22.2943	22.3	161000.0
2012-04-04 07:50:00	AAPL	Stock	22.3032	22.3214	22.3032	22.3036	344960.0
2012-04-04 07:55:00	AAPL	Stock	22.3086	22.3143	22.3036	22.3036	102564.0
2012-04-04 08:00:00	AAPL	Stock	22.3121	22.3193	22.2786	22.3164	561372.0
2012-04-04 08:05:00	AAPL	Stock	22.3157	22.3354	22.3132	22.3307	483084.0
2012-04-04 08:10:00	AAPL	Stock	22.335	22.3464	22.3104	22.3182	600824.0
2012-04-04 08:15:00	AAPL	Stock	22.3125	22.3268	22.2932	22.3025	717024.0
2012-04-04 08:20:00	AAPL	Stock	22.2946	22.3207	22.2786	22.2821	684264.0
2012-04-04 08:25:00	AAPL	Stock	22.2836	22.2954	22.2696	22.2718	429940.0
2012-04-04 08:30:00	AAPL	Stock	22.275	22.2925	22.2718	22.2925	172396.0
2012-04-04 08:35:00	AAPL	Stock	22.2925	22.3004	22.2504	22.2507	437612.0
2012-04-04 08:40:00	AAPL	Stock	22.2504	22.2621	22.2357	22.2607	703556.0
2012-04-04 08:45:00	AAPL	Stock	22.2618	22.2804	22.2607	22.275	159628.0
2012-04-04 08:50:00	AAPL	Stock	22.2786	22.2918	22.2729	22.2821	306684.0
2012-04-04 08:55:00	AAPL	Stock	22.2836	22.3036	22.2836	22.2857	945000.0
2012-04-04 09:00:00	AAPL	Stock	22.2814	22.2911	22.275	22.2857	187432.0
2012-04-04 09:05:00	AAPL	Stock	22.285	22.2904	22.2786	22.2793	208936.0
2012-04-04 09:10:00	AAPL	Stock	22.2786	22.2893	22.2775	22.2889	193284.0
2012-04-04 09:15:00	AAPL	Stock	22.2889	22.2911	22.2679	22.2768	438424.0
2012-04-04 09:20:00	AAPL	Stock	22.2786	22.2811	22.2679	22.2775	268492.0
2012-04-04 09:25:00	AAPL	Stock	22.2793	22.3079	22.27	22.3071	1400868.0
2012-04-04 09:30:00	AAPL	Stock	22.3025	22.3168	22.2004	22.2689	31952200.0

> showing 50 of 331,388 rows — these rows as CSV

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