PREVIEW / stock_5min / 2011-10-26

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-10-26.parquet
  size:    4.9 MB
  rows:    326,922
  symbols: 3,493

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-10-26 04:00:00	AAPL	Stock	14.2336	14.2336	14.2336	14.2336	2800.0
2011-10-26 04:05:00	AAPL	Stock	14.2857	14.3214	14.2857	14.3214	26684.0
2011-10-26 04:10:00	AAPL	Stock	14.2857	14.2857	14.2857	14.2857	2800.0
2011-10-26 04:15:00	AAPL	Stock	14.2857	14.2857	14.2857	14.2857	2800.0
2011-10-26 04:45:00	AAPL	Stock	14.2693	14.2693	14.2693	14.2693	2800.0
2011-10-26 04:50:00	AAPL	Stock	14.2718	14.2718	14.2643	14.2643	5600.0
2011-10-26 05:10:00	AAPL	Stock	14.2661	14.2661	14.2661	14.2661	5600.0
2011-10-26 05:25:00	AAPL	Stock	14.2532	14.2532	14.25	14.25	5600.0
2011-10-26 05:35:00	AAPL	Stock	14.25	14.25	14.25	14.25	2800.0
2011-10-26 06:30:00	AAPL	Stock	14.2786	14.2786	14.2786	14.2786	2800.0
2011-10-26 07:00:00	AAPL	Stock	14.2854	14.2854	14.2854	14.2854	5600.0
2011-10-26 07:05:00	AAPL	Stock	14.2857	14.2996	14.2714	14.2714	65716.0
2011-10-26 07:10:00	AAPL	Stock	14.2768	14.2786	14.2675	14.275	14000.0
2011-10-26 07:15:00	AAPL	Stock	14.2836	14.2836	14.2689	14.2793	58800.0
2011-10-26 07:20:00	AAPL	Stock	14.285	14.285	14.2768	14.2768	14000.0
2011-10-26 07:25:00	AAPL	Stock	14.2732	14.2732	14.2639	14.2639	19600.0
2011-10-26 07:30:00	AAPL	Stock	14.2782	14.2818	14.2779	14.2818	91924.0
2011-10-26 07:35:00	AAPL	Stock	14.2811	14.2811	14.2811	14.2811	7000.0
2011-10-26 07:50:00	AAPL	Stock	14.2679	14.28	14.2646	14.28	75320.0
2011-10-26 07:55:00	AAPL	Stock	14.2807	14.2875	14.2682	14.2786	195328.0
2011-10-26 08:00:00	AAPL	Stock	14.2746	14.2979	14.2579	14.2914	433468.0
2011-10-26 08:05:00	AAPL	Stock	14.2914	14.3132	14.2854	14.3107	179368.0
2011-10-26 08:10:00	AAPL	Stock	14.3043	14.3368	14.3036	14.3143	668024.0
2011-10-26 08:15:00	AAPL	Stock	14.3089	14.3161	14.2918	14.2918	79100.0
2011-10-26 08:20:00	AAPL	Stock	14.2921	14.3032	14.2921	14.3032	97720.0
2011-10-26 08:25:00	AAPL	Stock	14.3036	14.3214	14.3036	14.3182	200256.0
2011-10-26 08:30:00	AAPL	Stock	14.3164	14.3318	14.3071	14.3089	470512.0
2011-10-26 08:35:00	AAPL	Stock	14.3036	14.3093	14.2964	14.2975	59080.0
2011-10-26 08:40:00	AAPL	Stock	14.3	14.3036	14.2886	14.2893	209020.0
2011-10-26 08:45:00	AAPL	Stock	14.2889	14.3139	14.2886	14.3046	110880.0
2011-10-26 08:50:00	AAPL	Stock	14.3054	14.315	14.3029	14.3071	318080.0
2011-10-26 08:55:00	AAPL	Stock	14.3071	14.3257	14.3071	14.3186	259532.0
2011-10-26 09:00:00	AAPL	Stock	14.3229	14.3361	14.3179	14.3361	159320.0
2011-10-26 09:05:00	AAPL	Stock	14.3357	14.3375	14.3214	14.3214	357308.0
2011-10-26 09:10:00	AAPL	Stock	14.3218	14.3361	14.3211	14.3361	435848.0
2011-10-26 09:15:00	AAPL	Stock	14.3336	14.375	14.3336	14.375	849072.0
2011-10-26 09:20:00	AAPL	Stock	14.3779	14.3786	14.3489	14.3511	318304.0
2011-10-26 09:25:00	AAPL	Stock	14.3554	14.3625	14.3414	14.3564	146160.0
2011-10-26 09:30:00	AAPL	Stock	14.3557	14.3768	14.3286	14.3668	13060740.0
2011-10-26 09:35:00	AAPL	Stock	14.3701	14.3728	14.3254	14.3521	9951816.0
2011-10-26 09:40:00	AAPL	Stock	14.3518	14.3732	14.3257	14.3379	6750156.0
2011-10-26 09:45:00	AAPL	Stock	14.3371	14.3482	14.2979	14.3009	7956788.0
2011-10-26 09:50:00	AAPL	Stock	14.3021	14.3214	14.2786	14.3171	8628844.0
2011-10-26 09:55:00	AAPL	Stock	14.3206	14.3214	14.3014	14.3104	5089952.0
2011-10-26 10:00:00	AAPL	Stock	14.3143	14.3175	14.2857	14.3064	5787432.0
2011-10-26 10:05:00	AAPL	Stock	14.3054	14.3116	14.2643	14.2721	5759600.0
2011-10-26 10:10:00	AAPL	Stock	14.275	14.2811	14.2518	14.2571	5629736.0
2011-10-26 10:15:00	AAPL	Stock	14.2529	14.2661	14.23	14.2493	6787900.0
2011-10-26 10:20:00	AAPL	Stock	14.2473	14.2593	14.2071	14.2143	6080928.0
2011-10-26 10:25:00	AAPL	Stock	14.2146	14.2211	14.1846	14.2175	6509328.0

> showing 50 of 326,922 rows — these rows as CSV

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