PREVIEW / stock_30min / 2012-05-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-10.parquet
  size:    1.4 MB
  rows:    75,924
  symbols: 3,524

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-05-10 04:00:00	AAPL	Stock	20.3571	20.3571	20.2821	20.2821	87500.0
2012-05-10 04:30:00	AAPL	Stock	20.2857	20.2893	20.2857	20.2893	16744.0
2012-05-10 05:00:00	AAPL	Stock	20.2771	20.2771	20.2643	20.2643	29092.0
2012-05-10 05:30:00	AAPL	Stock	20.2643	20.2643	20.2643	20.2643	7336.0
2012-05-10 06:00:00	AAPL	Stock	20.2643	20.2643	20.2643	20.2643	2800.0
2012-05-10 06:30:00	AAPL	Stock	20.2857	20.3725	20.2857	20.3725	74452.0
2012-05-10 07:00:00	AAPL	Stock	20.3739	20.4107	20.3739	20.4057	111608.0
2012-05-10 07:30:00	AAPL	Stock	20.4089	20.5357	20.4089	20.4964	412356.0
2012-05-10 08:00:00	AAPL	Stock	20.4911	20.5246	20.4186	20.5132	1444716.0
2012-05-10 08:30:00	AAPL	Stock	20.5168	20.5318	20.4879	20.5054	1602496.0
2012-05-10 09:00:00	AAPL	Stock	20.5039	20.5425	20.4911	20.5357	2636284.0
2012-05-10 09:30:00	AAPL	Stock	20.5354	20.5671	20.4232	20.4957	67836328.0
2012-05-10 10:00:00	AAPL	Stock	20.4961	20.5321	20.3929	20.4004	40355280.0
2012-05-10 10:30:00	AAPL	Stock	20.4053	20.4804	20.3846	20.4442	27500956.0
2012-05-10 11:00:00	AAPL	Stock	20.4396	20.4804	20.4111	20.4707	17430084.0
2012-05-10 11:30:00	AAPL	Stock	20.4671	20.4796	20.4218	20.445	14294812.0
2012-05-10 12:00:00	AAPL	Stock	20.4454	20.4668	20.3964	20.4568	17977400.0
2012-05-10 12:30:00	AAPL	Stock	20.4554	20.4992	20.4446	20.4968	16975728.0
2012-05-10 13:00:00	AAPL	Stock	20.4959	20.5096	20.455	20.4768	16072392.0
2012-05-10 13:30:00	AAPL	Stock	20.4828	20.5	20.4196	20.4411	12531260.0
2012-05-10 14:00:00	AAPL	Stock	20.4407	20.4643	20.4304	20.456	10710812.0
2012-05-10 14:30:00	AAPL	Stock	20.4568	20.4579	20.4029	20.4089	11330872.0
2012-05-10 15:00:00	AAPL	Stock	20.4089	20.4389	20.3946	20.42	13907236.0
2012-05-10 15:30:00	AAPL	Stock	20.4246	20.4254	20.3015	20.3743	42760032.0
2012-05-10 16:00:00	AAPL	Stock	20.3757	20.4606	20.3618	20.4107	12314988.0
2012-05-10 16:30:00	AAPL	Stock	20.4071	20.4177	20.3436	20.3571	835940.0
2012-05-10 17:00:00	AAPL	Stock	20.3279	20.3486	20.2857	20.2893	660828.0
2012-05-10 17:30:00	AAPL	Stock	20.2782	20.3032	20.25	20.2679	286216.0
2012-05-10 18:00:00	AAPL	Stock	20.2582	20.2696	20.2411	20.2461	242704.0
2012-05-10 18:30:00	AAPL	Stock	20.25	20.2821	20.25	20.2679	211736.0
2012-05-10 19:00:00	AAPL	Stock	20.2704	20.2714	20.2357	20.255	243628.0
2012-05-10 19:30:00	AAPL	Stock	20.2543	20.2632	20.2504	20.2536	82264.0
2012-05-10 07:00:00	MSFT	Stock	30.74	30.75	30.74	30.75	1400.0
2012-05-10 07:30:00	MSFT	Stock	30.76	30.97	30.76	30.97	450.0
2012-05-10 08:00:00	MSFT	Stock	30.7	30.81	30.7	30.8	8437.0
2012-05-10 08:30:00	MSFT	Stock	30.8	30.9	30.8	30.85	8402.0
2012-05-10 09:00:00	MSFT	Stock	30.85	30.93	30.83	30.86	27182.0
2012-05-10 09:30:00	MSFT	Stock	30.87	31.02	30.63	30.71	6955495.0
2012-05-10 10:00:00	MSFT	Stock	30.706	30.8	30.47	30.51	4134288.0
2012-05-10 10:30:00	MSFT	Stock	30.51	30.68	30.5	30.63	3096486.0
2012-05-10 11:00:00	MSFT	Stock	30.62	30.69	30.58	30.678	2192874.0
2012-05-10 11:30:00	MSFT	Stock	30.67	30.71	30.5	30.53	2025010.0
2012-05-10 12:00:00	MSFT	Stock	30.53	30.57	30.45	30.55	2405502.0
2012-05-10 12:30:00	MSFT	Stock	30.555	30.695	30.55	30.695	1410706.0
2012-05-10 13:00:00	MSFT	Stock	30.7	30.77	30.67	30.71	2096807.0
2012-05-10 13:30:00	MSFT	Stock	30.715	30.76	30.59	30.59	1463779.0
2012-05-10 14:00:00	MSFT	Stock	30.595	30.84	30.59	30.84	3954466.0
2012-05-10 14:30:00	MSFT	Stock	30.835	30.84	30.71	30.82	2640638.0
2012-05-10 15:00:00	MSFT	Stock	30.812	30.83	30.71	30.823	2748589.0
2012-05-10 15:30:00	MSFT	Stock	30.82	30.85	30.67	30.74	5437274.0

> showing 50 of 75,924 rows — these rows as CSV

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