PREVIEW / stock_5min / 2013-04-10

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-10.parquet
  size:    5.1 MB
  rows:    337,807
  symbols: 3,502

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-04-10 04:00:00	AAPL	Stock	15.2893	15.2893	15.2893	15.2893	2800.0
2013-04-10 06:25:00	AAPL	Stock	15.3143	15.3143	15.3143	15.3143	5600.0
2013-04-10 07:00:00	AAPL	Stock	15.315	15.3286	15.315	15.3214	25200.0
2013-04-10 07:10:00	AAPL	Stock	15.3304	15.3304	15.3304	15.3304	2800.0
2013-04-10 07:20:00	AAPL	Stock	15.3214	15.3254	15.3214	15.3254	28000.0
2013-04-10 07:30:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	5600.0
2013-04-10 07:40:00	AAPL	Stock	15.3214	15.3214	15.3143	15.3143	18284.0
2013-04-10 07:45:00	AAPL	Stock	15.3093	15.3093	15.3086	15.3086	5600.0
2013-04-10 07:50:00	AAPL	Stock	15.2979	15.2979	15.27	15.27	60340.0
2013-04-10 07:55:00	AAPL	Stock	15.2843	15.2843	15.2832	15.2832	10780.0
2013-04-10 08:00:00	AAPL	Stock	15.2857	15.3214	15.2739	15.2964	92652.0
2013-04-10 08:05:00	AAPL	Stock	15.3	15.3261	15.3	15.3104	84700.0
2013-04-10 08:10:00	AAPL	Stock	15.3114	15.3132	15.3089	15.3089	19320.0
2013-04-10 08:15:00	AAPL	Stock	15.3036	15.3268	15.2143	15.3168	145740.0
2013-04-10 08:20:00	AAPL	Stock	15.32	15.3275	15.3125	15.3275	70560.0
2013-04-10 08:25:00	AAPL	Stock	15.3268	15.3293	15.3157	15.3196	105896.0
2013-04-10 08:30:00	AAPL	Stock	15.3193	15.3196	15.3039	15.3111	148120.0
2013-04-10 08:35:00	AAPL	Stock	15.3079	15.3079	15.2932	15.3061	125552.0
2013-04-10 08:40:00	AAPL	Stock	15.2982	15.2989	15.2929	15.2989	56000.0
2013-04-10 08:45:00	AAPL	Stock	15.2939	15.2939	15.2679	15.275	309624.0
2013-04-10 08:50:00	AAPL	Stock	15.2768	15.2889	15.2757	15.2829	212128.0
2013-04-10 08:55:00	AAPL	Stock	15.2825	15.2857	15.25	15.2507	466564.0
2013-04-10 09:00:00	AAPL	Stock	15.2568	15.2818	15.2568	15.2743	145180.0
2013-04-10 09:05:00	AAPL	Stock	15.2679	15.2857	15.2671	15.2857	142800.0
2013-04-10 09:10:00	AAPL	Stock	15.2846	15.2929	15.2679	15.2696	459004.0
2013-04-10 09:15:00	AAPL	Stock	15.2768	15.2911	15.2768	15.2911	120120.0
2013-04-10 09:20:00	AAPL	Stock	15.28	15.28	15.2643	15.2675	234556.0
2013-04-10 09:25:00	AAPL	Stock	15.2675	15.3071	15.2611	15.3021	719348.0
2013-04-10 09:30:00	AAPL	Stock	15.2893	15.3036	15.2146	15.2789	14353668.0
2013-04-10 09:35:00	AAPL	Stock	15.2786	15.3429	15.2779	15.3061	10954608.0
2013-04-10 09:40:00	AAPL	Stock	15.3057	15.3193	15.2643	15.2859	5389776.0
2013-04-10 09:45:00	AAPL	Stock	15.2846	15.2964	15.2389	15.2596	7379008.0
2013-04-10 09:50:00	AAPL	Stock	15.2582	15.2921	15.2436	15.2611	10066112.0
2013-04-10 09:55:00	AAPL	Stock	15.2579	15.2957	15.2579	15.2696	4224276.0
2013-04-10 10:00:00	AAPL	Stock	15.2646	15.2857	15.2418	15.2536	5362840.0
2013-04-10 10:05:00	AAPL	Stock	15.2539	15.3246	15.2518	15.3096	6732264.0
2013-04-10 10:10:00	AAPL	Stock	15.3139	15.3386	15.3032	15.3375	7225736.0
2013-04-10 10:15:00	AAPL	Stock	15.3371	15.4	15.3354	15.3896	15322104.0
2013-04-10 10:20:00	AAPL	Stock	15.3896	15.3957	15.3614	15.3832	8874684.0
2013-04-10 10:25:00	AAPL	Stock	15.3796	15.3818	15.3396	15.3546	4863824.0
2013-04-10 10:30:00	AAPL	Stock	15.3546	15.3882	15.3539	15.3782	4909100.0
2013-04-10 10:35:00	AAPL	Stock	15.3779	15.3868	15.3693	15.3832	4079432.0
2013-04-10 10:40:00	AAPL	Stock	15.3832	15.4464	15.3814	15.4411	11900364.0
2013-04-10 10:45:00	AAPL	Stock	15.443	15.4479	15.42	15.4257	5965148.0
2013-04-10 10:50:00	AAPL	Stock	15.4279	15.4314	15.3893	15.3955	6414660.0
2013-04-10 10:55:00	AAPL	Stock	15.3961	15.4264	15.3961	15.4246	3784116.0
2013-04-10 11:00:00	AAPL	Stock	15.4239	15.4267	15.4093	15.4214	2581992.0
2013-04-10 11:05:00	AAPL	Stock	15.4214	15.4464	15.4121	15.4375	7061600.0
2013-04-10 11:10:00	AAPL	Stock	15.4371	15.4411	15.4141	15.4263	3675616.0
2013-04-10 11:15:00	AAPL	Stock	15.4256	15.4464	15.4196	15.4331	4039700.0

> showing 50 of 337,807 rows — these rows as CSV

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