PREVIEW / stock_30min / 2012-07-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-05.parquet
  size:    1.4 MB
  rows:    73,800
  symbols: 3,507

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-07-05 04:00:00	AAPL	Stock	21.3929	21.3929	21.3575	21.3575	14000.0
2012-07-05 04:30:00	AAPL	Stock	21.3732	21.3732	21.3571	21.3571	14000.0
2012-07-05 05:30:00	AAPL	Stock	21.3582	21.3582	21.3582	21.3582	2800.0
2012-07-05 06:30:00	AAPL	Stock	21.3839	21.3839	21.3839	21.3839	14000.0
2012-07-05 07:00:00	AAPL	Stock	21.3929	21.535	21.3929	21.5111	205324.0
2012-07-05 07:30:00	AAPL	Stock	21.5107	21.525	21.4268	21.4489	693252.0
2012-07-05 08:00:00	AAPL	Stock	21.4611	21.5268	21.4214	21.5071	2192288.0
2012-07-05 08:30:00	AAPL	Stock	21.5125	21.5196	21.475	21.495	2577596.0
2012-07-05 09:00:00	AAPL	Stock	21.4957	21.4964	21.4368	21.4368	1541064.0
2012-07-05 09:30:00	AAPL	Stock	21.4486	21.6714	21.4161	21.6146	95534964.0
2012-07-05 10:00:00	AAPL	Stock	21.6143	21.6346	21.5668	21.6183	34009808.0
2012-07-05 10:30:00	AAPL	Stock	21.6214	21.7987	21.6179	21.7875	56945084.0
2012-07-05 11:00:00	AAPL	Stock	21.7921	21.9357	21.7868	21.869	61055988.0
2012-07-05 11:30:00	AAPL	Stock	21.8666	21.8825	21.7789	21.8402	31276448.0
2012-07-05 12:00:00	AAPL	Stock	21.8379	21.8896	21.8321	21.8784	18317852.0
2012-07-05 12:30:00	AAPL	Stock	21.8761	21.8811	21.8268	21.8629	15661996.0
2012-07-05 13:00:00	AAPL	Stock	21.8646	21.9407	21.8472	21.9132	22965124.0
2012-07-05 13:30:00	AAPL	Stock	21.9146	21.9386	21.8796	21.9286	20950048.0
2012-07-05 14:00:00	AAPL	Stock	21.9314	21.9321	21.8961	21.9045	12717292.0
2012-07-05 14:30:00	AAPL	Stock	21.9059	21.9107	21.8093	21.825	23704100.0
2012-07-05 15:00:00	AAPL	Stock	21.8268	21.8779	21.8057	21.8471	24486952.0
2012-07-05 15:30:00	AAPL	Stock	21.845	21.8696	21.7768	21.7837	40009564.0
2012-07-05 16:00:00	AAPL	Stock	21.7779	21.8053	21.7248	21.7893	8103788.0
2012-07-05 16:30:00	AAPL	Stock	21.4075	21.8527	21.4075	21.7832	605360.0
2012-07-05 17:00:00	AAPL	Stock	21.7839	21.7839	21.7718	21.7718	453124.0
2012-07-05 17:30:00	AAPL	Stock	21.775	21.7929	21.7696	21.7929	69720.0
2012-07-05 18:00:00	AAPL	Stock	21.7911	21.7911	21.7861	21.7875	67564.0
2012-07-05 18:30:00	AAPL	Stock	21.7918	21.7932	21.7918	21.7932	40180.0
2012-07-05 19:00:00	AAPL	Stock	21.7929	21.7946	21.7857	21.7857	82908.0
2012-07-05 19:30:00	AAPL	Stock	21.7882	21.7893	21.7839	21.7889	197708.0
2012-07-05 05:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	200.0
2012-07-05 07:00:00	MSFT	Stock	30.71	30.75	30.71	30.75	1000.0
2012-07-05 07:30:00	MSFT	Stock	30.78	30.94	30.7	30.7	3270.0
2012-07-05 08:00:00	MSFT	Stock	30.7	30.8	30.7	30.76	8113.0
2012-07-05 08:30:00	MSFT	Stock	30.76	30.76	30.41	30.62	93885.0
2012-07-05 09:00:00	MSFT	Stock	30.64	30.64	30.54	30.59	17097.0
2012-07-05 09:30:00	MSFT	Stock	30.53	30.76	30.5	30.6	3939776.0
2012-07-05 10:00:00	MSFT	Stock	30.61	30.61	30.375	30.439	3025564.0
2012-07-05 10:30:00	MSFT	Stock	30.44	30.64	30.42	30.615	1710906.0
2012-07-05 11:00:00	MSFT	Stock	30.62	30.65	30.59	30.632	1483246.0
2012-07-05 11:30:00	MSFT	Stock	30.64	30.67	30.59	30.67	1355103.0
2012-07-05 12:00:00	MSFT	Stock	30.67	30.72	30.63	30.64	1230720.0
2012-07-05 12:30:00	MSFT	Stock	30.64	30.67	30.61	30.655	1158784.0
2012-07-05 13:00:00	MSFT	Stock	30.659	30.68	30.64	30.66	1015388.0
2012-07-05 13:30:00	MSFT	Stock	30.66	30.74	30.64	30.738	1655292.0
2012-07-05 14:00:00	MSFT	Stock	30.74	30.77	30.71	30.74	1420971.0
2012-07-05 14:30:00	MSFT	Stock	30.75	30.775	30.73	30.74	1689335.0
2012-07-05 15:00:00	MSFT	Stock	30.75	30.77	30.7	30.715	1786723.0
2012-07-05 15:30:00	MSFT	Stock	30.71	30.78	30.69	30.69	4685427.0
2012-07-05 16:00:00	MSFT	Stock	30.7	30.76	30.64	30.7	2076435.0

> showing 50 of 73,800 rows — these rows as CSV

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