PREVIEW / stock_5min / 2013-10-21

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-10-21.parquet
  size:    5.3 MB
  rows:    351,649
  symbols: 3,546

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-10-21 04:00:00	AAPL	Stock	18.2143	18.275	18.2143	18.275	37940.0
2013-10-21 04:05:00	AAPL	Stock	18.24	18.24	18.24	18.24	5600.0
2013-10-21 04:10:00	AAPL	Stock	18.24	18.2568	18.24	18.2482	50960.0
2013-10-21 04:35:00	AAPL	Stock	18.2479	18.25	18.2479	18.25	8400.0
2013-10-21 05:00:00	AAPL	Stock	18.25	18.25	18.25	18.25	2800.0
2013-10-21 05:05:00	AAPL	Stock	18.2571	18.2571	18.2571	18.2571	2800.0
2013-10-21 05:10:00	AAPL	Stock	18.2743	18.2879	18.2743	18.2879	8400.0
2013-10-21 05:15:00	AAPL	Stock	18.2868	18.29	18.2868	18.29	14000.0
2013-10-21 05:20:00	AAPL	Stock	18.3104	18.3164	18.3104	18.3164	46116.0
2013-10-21 05:25:00	AAPL	Stock	18.3036	18.3161	18.3036	18.3161	28000.0
2013-10-21 05:30:00	AAPL	Stock	18.3161	18.3211	18.2932	18.2932	44800.0
2013-10-21 05:35:00	AAPL	Stock	18.2964	18.2964	18.29	18.29	33600.0
2013-10-21 05:45:00	AAPL	Stock	18.2957	18.2964	18.2957	18.2964	19460.0
2013-10-21 06:00:00	AAPL	Stock	18.2957	18.2957	18.2957	18.2957	5600.0
2013-10-21 06:10:00	AAPL	Stock	18.2857	18.2875	18.2857	18.2864	29680.0
2013-10-21 06:15:00	AAPL	Stock	18.2896	18.2896	18.2896	18.2896	7840.0
2013-10-21 06:35:00	AAPL	Stock	18.3032	18.3036	18.3032	18.3036	13328.0
2013-10-21 06:40:00	AAPL	Stock	18.3	18.3036	18.3	18.3	18956.0
2013-10-21 06:45:00	AAPL	Stock	18.3	18.3	18.3	18.3	2800.0
2013-10-21 06:50:00	AAPL	Stock	18.2886	18.2982	18.2857	18.2875	45556.0
2013-10-21 06:55:00	AAPL	Stock	18.2857	18.2857	18.2821	18.2821	15400.0
2013-10-21 07:00:00	AAPL	Stock	18.2804	18.2804	18.2679	18.2714	136920.0
2013-10-21 07:05:00	AAPL	Stock	18.2696	18.2879	18.2589	18.285	44800.0
2013-10-21 07:10:00	AAPL	Stock	18.2771	18.285	18.2771	18.285	13636.0
2013-10-21 07:15:00	AAPL	Stock	18.2821	18.3	18.2821	18.3	316876.0
2013-10-21 07:20:00	AAPL	Stock	18.3	18.3018	18.2996	18.3	35784.0
2013-10-21 07:25:00	AAPL	Stock	18.2886	18.2921	18.2857	18.2921	75180.0
2013-10-21 07:30:00	AAPL	Stock	18.2896	18.3036	18.2875	18.3	68600.0
2013-10-21 07:35:00	AAPL	Stock	18.3029	18.3036	18.29	18.3	105056.0
2013-10-21 07:40:00	AAPL	Stock	18.2946	18.3036	18.2857	18.2943	102200.0
2013-10-21 07:45:00	AAPL	Stock	18.2857	18.2857	18.2796	18.2854	28140.0
2013-10-21 07:50:00	AAPL	Stock	18.2807	18.2857	18.2796	18.2857	36148.0
2013-10-21 07:55:00	AAPL	Stock	18.285	18.2857	18.285	18.2857	12600.0
2013-10-21 08:00:00	AAPL	Stock	18.2943	18.3036	18.2539	18.275	475888.0
2013-10-21 08:05:00	AAPL	Stock	18.2804	18.2821	18.2679	18.2804	85260.0
2013-10-21 08:10:00	AAPL	Stock	18.2818	18.2818	18.2679	18.2757	74536.0
2013-10-21 08:15:00	AAPL	Stock	18.2768	18.2821	18.2682	18.2818	155232.0
2013-10-21 08:20:00	AAPL	Stock	18.2786	18.3171	18.2786	18.3161	472388.0
2013-10-21 08:25:00	AAPL	Stock	18.3157	18.3354	18.3125	18.3214	525140.0
2013-10-21 08:30:00	AAPL	Stock	18.3211	18.3332	18.3146	18.3275	300720.0
2013-10-21 08:35:00	AAPL	Stock	18.3243	18.3325	18.3214	18.3304	80052.0
2013-10-21 08:40:00	AAPL	Stock	18.3257	18.3393	18.3214	18.3354	229656.0
2013-10-21 08:45:00	AAPL	Stock	18.3339	18.3339	18.3107	18.3129	175420.0
2013-10-21 08:50:00	AAPL	Stock	18.3129	18.32	18.2857	18.2936	251888.0
2013-10-21 08:55:00	AAPL	Stock	18.3004	18.3036	18.2936	18.3018	106008.0
2013-10-21 09:00:00	AAPL	Stock	18.3036	18.3121	18.2943	18.3036	85008.0
2013-10-21 09:05:00	AAPL	Stock	18.3036	18.3057	18.3	18.3032	135520.0
2013-10-21 09:10:00	AAPL	Stock	18.3018	18.3075	18.2975	18.3032	65240.0
2013-10-21 09:15:00	AAPL	Stock	18.3036	18.3196	18.3036	18.3071	112000.0
2013-10-21 09:20:00	AAPL	Stock	18.3057	18.3057	18.2929	18.2929	262584.0

> showing 50 of 351,649 rows — these rows as CSV

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