PREVIEW / stock_30min / 2012-02-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-23.parquet
  size:    1.4 MB
  rows:    77,539
  symbols: 3,525

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-02-23 04:00:00	AAPL	Stock	18.3929	18.4054	18.3929	18.4054	39200.0
2012-02-23 04:30:00	AAPL	Stock	18.3904	18.3904	18.3596	18.3821	52920.0
2012-02-23 05:00:00	AAPL	Stock	18.375	18.3786	18.3575	18.3575	44800.0
2012-02-23 05:30:00	AAPL	Stock	18.375	18.375	18.3407	18.3571	65520.0
2012-02-23 06:00:00	AAPL	Stock	18.3679	18.3707	18.3571	18.3679	111160.0
2012-02-23 07:00:00	AAPL	Stock	18.3736	18.3839	18.3571	18.3714	313096.0
2012-02-23 07:30:00	AAPL	Stock	18.3714	18.4171	18.3714	18.4061	679392.0
2012-02-23 08:00:00	AAPL	Stock	18.4	18.4282	18.38	18.4246	2543436.0
2012-02-23 08:30:00	AAPL	Stock	18.425	18.4257	18.3979	18.4014	1436988.0
2012-02-23 09:00:00	AAPL	Stock	18.4029	18.4175	18.3754	18.4014	1720684.0
2012-02-23 09:30:00	AAPL	Stock	18.3982	18.4364	18.3268	18.3875	66774932.0
2012-02-23 10:00:00	AAPL	Stock	18.3875	18.4	18.3361	18.365	40134472.0
2012-02-23 10:30:00	AAPL	Stock	18.3661	18.4046	18.3507	18.3857	25107964.0
2012-02-23 11:00:00	AAPL	Stock	18.3871	18.4511	18.3761	18.4489	34922776.0
2012-02-23 11:30:00	AAPL	Stock	18.45	18.4939	18.4111	18.4196	37584232.0
2012-02-23 12:00:00	AAPL	Stock	18.4179	18.4618	18.3625	18.3889	29853964.0
2012-02-23 12:30:00	AAPL	Stock	18.3911	18.3979	18.2643	18.3193	47590368.0
2012-02-23 13:00:00	AAPL	Stock	18.3199	18.3904	18.2979	18.335	35673484.0
2012-02-23 13:30:00	AAPL	Stock	18.3286	18.3595	18.1964	18.3068	72554160.0
2012-02-23 14:00:00	AAPL	Stock	18.3087	18.3479	18.2729	18.3339	33002116.0
2012-02-23 14:30:00	AAPL	Stock	18.3346	18.4494	18.3254	18.4036	44292276.0
2012-02-23 15:00:00	AAPL	Stock	18.4036	18.4732	18.3911	18.4511	33058004.0
2012-02-23 15:30:00	AAPL	Stock	18.452	18.4661	18.4129	18.4397	41733300.0
2012-02-23 16:00:00	AAPL	Stock	18.4425	18.4579	18.3754	18.4546	8806280.0
2012-02-23 16:30:00	AAPL	Stock	18.4529	18.4625	18.4389	18.46	616588.0
2012-02-23 17:00:00	AAPL	Stock	18.4561	18.4561	18.4307	18.4321	420560.0
2012-02-23 17:30:00	AAPL	Stock	18.4329	18.4425	18.4179	18.4425	377468.0
2012-02-23 18:00:00	AAPL	Stock	18.4425	18.4536	18.4425	18.4536	247016.0
2012-02-23 18:30:00	AAPL	Stock	18.4536	18.4604	18.45	18.4571	233660.0
2012-02-23 19:00:00	AAPL	Stock	18.4521	18.4571	18.4507	18.4521	80304.0
2012-02-23 19:30:00	AAPL	Stock	18.4554	18.46	18.4532	18.4557	138040.0
2012-02-23 07:30:00	MSFT	Stock	31.23	31.23	31.17	31.22	510.0
2012-02-23 08:00:00	MSFT	Stock	31.2	31.21	31.18	31.2	5200.0
2012-02-23 08:30:00	MSFT	Stock	31.24	31.4	31.24	31.37	42645.0
2012-02-23 09:00:00	MSFT	Stock	31.36	31.37	31.19	31.22	66159.0
2012-02-23 09:30:00	MSFT	Stock	31.22	31.26	31.0	31.22	5226663.0
2012-02-23 10:00:00	MSFT	Stock	31.22	31.39	31.21	31.35	3371790.0
2012-02-23 10:30:00	MSFT	Stock	31.356	31.495	31.3	31.475	3960447.0
2012-02-23 11:00:00	MSFT	Stock	31.48	31.59	31.46	31.51	2890188.0
2012-02-23 11:30:00	MSFT	Stock	31.515	31.54	31.435	31.46	1424267.0
2012-02-23 12:00:00	MSFT	Stock	31.47	31.49	31.37	31.45	2105086.0
2012-02-23 12:30:00	MSFT	Stock	31.45	31.49	31.39	31.395	1582117.0
2012-02-23 13:00:00	MSFT	Stock	31.4	31.4	31.35	31.365	808254.0
2012-02-23 13:30:00	MSFT	Stock	31.365	31.4	31.31	31.37	1682623.0
2012-02-23 14:00:00	MSFT	Stock	31.37	31.39	31.3	31.325	1708286.0
2012-02-23 14:30:00	MSFT	Stock	31.32	31.36	31.28	31.32	1445080.0
2012-02-23 15:00:00	MSFT	Stock	31.32	31.46	31.3	31.383	2022607.0
2012-02-23 15:30:00	MSFT	Stock	31.39	31.425	31.35	31.375	3541728.0
2012-02-23 16:00:00	MSFT	Stock	31.37	31.45	31.337	31.37	1677338.0
2012-02-23 16:30:00	MSFT	Stock	31.37	31.44	31.37	31.38	46427.0

> showing 50 of 77,539 rows — these rows as CSV

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