PREVIEW / stock_5min / 2011-08-26

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-08-26.parquet
  size:    4.8 MB
  rows:    324,258
  symbols: 3,499

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-08-26 04:40:00	AAPL	Stock	13.3882	13.3882	13.3882	13.3882	2800.0
2011-08-26 05:30:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	5600.0
2011-08-26 06:15:00	AAPL	Stock	13.3321	13.3321	13.3321	13.3321	6300.0
2011-08-26 06:25:00	AAPL	Stock	13.3286	13.3286	13.3286	13.3286	2800.0
2011-08-26 06:35:00	AAPL	Stock	13.3286	13.3286	13.3286	13.3286	53200.0
2011-08-26 06:45:00	AAPL	Stock	13.3236	13.3236	13.3236	13.3236	2800.0
2011-08-26 06:50:00	AAPL	Stock	13.3214	13.3214	13.3214	13.3214	8400.0
2011-08-26 06:55:00	AAPL	Stock	13.3214	13.3557	13.3214	13.3539	28560.0
2011-08-26 07:00:00	AAPL	Stock	13.3571	13.3746	13.3571	13.3661	28000.0
2011-08-26 07:05:00	AAPL	Stock	13.3654	13.3686	13.3654	13.3686	12684.0
2011-08-26 07:10:00	AAPL	Stock	13.3614	13.3614	13.3314	13.3454	42000.0
2011-08-26 07:15:00	AAPL	Stock	13.3464	13.3482	13.3214	13.335	94332.0
2011-08-26 07:20:00	AAPL	Stock	13.3043	13.3207	13.3043	13.3071	69300.0
2011-08-26 07:25:00	AAPL	Stock	13.2957	13.3114	13.2782	13.3114	42868.0
2011-08-26 07:30:00	AAPL	Stock	13.3043	13.3043	13.2936	13.2936	8400.0
2011-08-26 07:35:00	AAPL	Stock	13.2821	13.2936	13.275	13.2857	77224.0
2011-08-26 07:40:00	AAPL	Stock	13.2839	13.2857	13.2839	13.2857	8400.0
2011-08-26 07:45:00	AAPL	Stock	13.2914	13.3039	13.2914	13.3039	8400.0
2011-08-26 07:50:00	AAPL	Stock	13.3036	13.3071	13.2932	13.2932	33600.0
2011-08-26 07:55:00	AAPL	Stock	13.2982	13.3071	13.2936	13.2975	18200.0
2011-08-26 08:00:00	AAPL	Stock	13.3154	13.3175	13.2857	13.2979	132272.0
2011-08-26 08:05:00	AAPL	Stock	13.3018	13.3036	13.2821	13.2868	140896.0
2011-08-26 08:10:00	AAPL	Stock	13.2857	13.2857	13.2746	13.2857	126112.0
2011-08-26 08:15:00	AAPL	Stock	13.2857	13.2857	13.2854	13.2857	22400.0
2011-08-26 08:20:00	AAPL	Stock	13.2814	13.3	13.2807	13.2929	96600.0
2011-08-26 08:25:00	AAPL	Stock	13.2929	13.2993	13.2804	13.2993	179732.0
2011-08-26 08:30:00	AAPL	Stock	13.2864	13.3214	13.2793	13.2929	241164.0
2011-08-26 08:35:00	AAPL	Stock	13.2932	13.3	13.2743	13.2857	285992.0
2011-08-26 08:40:00	AAPL	Stock	13.2857	13.2857	13.2607	13.2696	228760.0
2011-08-26 08:45:00	AAPL	Stock	13.27	13.2768	13.2321	13.2421	302120.0
2011-08-26 08:50:00	AAPL	Stock	13.2457	13.2507	13.2336	13.2461	344400.0
2011-08-26 08:55:00	AAPL	Stock	13.2418	13.2568	13.2364	13.2568	167720.0
2011-08-26 09:00:00	AAPL	Stock	13.2571	13.275	13.2543	13.2586	263200.0
2011-08-26 09:05:00	AAPL	Stock	13.2629	13.2829	13.2621	13.2689	324016.0
2011-08-26 09:10:00	AAPL	Stock	13.2764	13.3	13.2764	13.3	304276.0
2011-08-26 09:15:00	AAPL	Stock	13.2996	13.3	13.2718	13.2718	58800.0
2011-08-26 09:20:00	AAPL	Stock	13.2721	13.275	13.2507	13.2707	209048.0
2011-08-26 09:25:00	AAPL	Stock	13.275	13.2786	13.2507	13.2679	465836.0
2011-08-26 09:30:00	AAPL	Stock	13.2561	13.3689	13.2429	13.3539	14066864.0
2011-08-26 09:35:00	AAPL	Stock	13.3482	13.3643	13.2679	13.2682	11984616.0
2011-08-26 09:40:00	AAPL	Stock	13.2679	13.3036	13.2547	13.2864	7750820.0
2011-08-26 09:45:00	AAPL	Stock	13.2862	13.3057	13.2614	13.2975	6363420.0
2011-08-26 09:50:00	AAPL	Stock	13.2968	13.3036	13.2711	13.2768	5219956.0
2011-08-26 09:55:00	AAPL	Stock	13.2754	13.31	13.2704	13.2943	4541432.0
2011-08-26 10:00:00	AAPL	Stock	13.2968	13.3536	13.2543	13.3346	17194016.0
2011-08-26 10:05:00	AAPL	Stock	13.3371	13.3371	13.2507	13.3243	12740308.0
2011-08-26 10:10:00	AAPL	Stock	13.3225	13.3293	13.275	13.3021	8886976.0
2011-08-26 10:15:00	AAPL	Stock	13.3075	13.3854	13.2993	13.3782	15413412.0
2011-08-26 10:20:00	AAPL	Stock	13.3785	13.4596	13.3675	13.4511	20883716.0
2011-08-26 10:25:00	AAPL	Stock	13.4515	13.535	13.4514	13.4904	26188008.0

> showing 50 of 324,258 rows — these rows as CSV

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