PREVIEW / stock_30min / 2013-12-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-05.parquet
  size:    1.5 MB
  rows:    80,915
  symbols: 3,533

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-12-05 04:00:00	AAPL	Stock	20.1821	20.56	20.1821	20.5268	168700.0
2013-12-05 04:30:00	AAPL	Stock	20.5457	20.5714	20.5321	20.5321	128940.0
2013-12-05 05:00:00	AAPL	Stock	20.5321	20.5321	20.4643	20.4643	227220.0
2013-12-05 05:30:00	AAPL	Stock	20.4857	20.4857	20.4643	20.4718	122976.0
2013-12-05 06:00:00	AAPL	Stock	20.4757	20.54	20.4757	20.5179	532000.0
2013-12-05 06:30:00	AAPL	Stock	20.52	20.5332	20.4464	20.4589	443604.0
2013-12-05 07:00:00	AAPL	Stock	20.4554	20.6207	20.4482	20.5661	2083984.0
2013-12-05 07:30:00	AAPL	Stock	20.5661	20.5757	20.4289	20.4614	2511852.0
2013-12-05 08:00:00	AAPL	Stock	20.4604	20.5786	20.1607	20.46	8214668.0
2013-12-05 08:30:00	AAPL	Stock	20.4589	20.5107	20.4386	20.4504	5037368.0
2013-12-05 09:00:00	AAPL	Stock	20.455	20.4889	20.4411	20.4586	3838296.0
2013-12-05 09:30:00	AAPL	Stock	20.4518	20.5406	20.3482	20.3925	115971744.0
2013-12-05 10:00:00	AAPL	Stock	20.3929	20.4279	20.3057	20.3889	55483344.0
2013-12-05 10:30:00	AAPL	Stock	20.3889	20.4464	20.3639	20.4297	24558352.0
2013-12-05 11:00:00	AAPL	Stock	20.4321	20.4486	20.4006	20.4307	18246060.0
2013-12-05 11:30:00	AAPL	Stock	20.4321	20.4425	20.38	20.4196	15281504.0
2013-12-05 12:00:00	AAPL	Stock	20.4179	20.4482	20.4107	20.4311	18513208.0
2013-12-05 12:30:00	AAPL	Stock	20.4304	20.4439	20.4018	20.4032	12020988.0
2013-12-05 13:00:00	AAPL	Stock	20.4046	20.4225	20.3968	20.4011	8360408.0
2013-12-05 13:30:00	AAPL	Stock	20.4011	20.4354	20.4011	20.4239	14272636.0
2013-12-05 14:00:00	AAPL	Stock	20.4221	20.4375	20.3171	20.3536	24368848.0
2013-12-05 14:30:00	AAPL	Stock	20.3568	20.3625	20.2354	20.2386	24178924.0
2013-12-05 15:00:00	AAPL	Stock	20.2375	20.3289	20.2289	20.3175	23697548.0
2013-12-05 15:30:00	AAPL	Stock	20.3179	20.3621	20.2804	20.2893	33095356.0
2013-12-05 16:00:00	AAPL	Stock	20.2846	20.4336	20.1475	20.2846	26730480.0
2013-12-05 16:30:00	AAPL	Stock	20.2864	20.2964	20.2857	20.2861	104860.0
2013-12-05 17:00:00	AAPL	Stock	20.2893	20.2896	20.2464	20.2464	582456.0
2013-12-05 17:30:00	AAPL	Stock	20.2393	20.25	20.2321	20.2443	392784.0
2013-12-05 18:00:00	AAPL	Stock	20.2421	20.25	20.2364	20.245	98924.0
2013-12-05 18:30:00	AAPL	Stock	20.2464	20.2536	20.2396	20.2504	60060.0
2013-12-05 19:00:00	AAPL	Stock	20.2507	20.2507	20.2354	20.2361	191044.0
2013-12-05 19:30:00	AAPL	Stock	20.2375	20.2536	20.2357	20.2429	353192.0
2013-12-05 07:00:00	MSFT	Stock	38.94	38.94	38.89	38.89	300.0
2013-12-05 07:30:00	MSFT	Stock	38.96	38.96	38.92	38.95	819.0
2013-12-05 08:00:00	MSFT	Stock	38.95	38.96	38.93	38.94	4425.0
2013-12-05 08:30:00	MSFT	Stock	38.94	38.95	38.63	38.67	17225.0
2013-12-05 09:00:00	MSFT	Stock	38.77	38.93	38.77	38.88	55320.0
2013-12-05 09:30:00	MSFT	Stock	38.85	38.875	38.59	38.6	4661567.0
2013-12-05 10:00:00	MSFT	Stock	38.6	38.695	37.73	37.735	18869566.0
2013-12-05 10:30:00	MSFT	Stock	37.735	38.14	37.52	37.77	18833891.0
2013-12-05 11:00:00	MSFT	Stock	37.77	37.83	37.32	37.46	14851033.0
2013-12-05 11:30:00	MSFT	Stock	37.46	37.5	37.18	37.389	10111827.0
2013-12-05 12:00:00	MSFT	Stock	37.39	37.7	37.38	37.5	10983557.0
2013-12-05 12:30:00	MSFT	Stock	37.5	37.92	37.43	37.83	9655989.0
2013-12-05 13:00:00	MSFT	Stock	37.83	37.93	37.75	37.83	2951978.0
2013-12-05 13:30:00	MSFT	Stock	37.83	37.95	37.77	37.833	2416918.0
2013-12-05 14:00:00	MSFT	Stock	37.84	37.89	37.78	37.835	2170338.0
2013-12-05 14:30:00	MSFT	Stock	37.833	37.93	37.79	37.91	2910481.0
2013-12-05 15:00:00	MSFT	Stock	37.91	37.92	37.8	37.88	2626416.0
2013-12-05 15:30:00	MSFT	Stock	37.88	38.02	37.85	38.01	6282048.0

> showing 50 of 80,915 rows — these rows as CSV

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