PREVIEW / stock_30min / 2012-05-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-09.parquet
  size:    1.4 MB
  rows:    77,472
  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-09 04:00:00	AAPL	Stock	20.2179	20.2179	20.2143	20.2143	5600.0
2012-05-09 05:00:00	AAPL	Stock	20.2004	20.2004	20.1968	20.1968	22400.0
2012-05-09 05:30:00	AAPL	Stock	20.1968	20.1968	20.1968	20.1968	36400.0
2012-05-09 06:00:00	AAPL	Stock	20.1968	20.1968	20.1968	20.1968	14000.0
2012-05-09 06:30:00	AAPL	Stock	20.1968	20.2143	20.175	20.175	99400.0
2012-05-09 07:00:00	AAPL	Stock	20.2018	20.2018	20.1582	20.1757	231224.0
2012-05-09 07:30:00	AAPL	Stock	20.1604	20.2082	20.1486	20.1864	510496.0
2012-05-09 08:00:00	AAPL	Stock	20.1864	20.2	20.0821	20.1161	1870344.0
2012-05-09 08:30:00	AAPL	Stock	20.1204	20.13	20.0832	20.1071	670656.0
2012-05-09 09:00:00	AAPL	Stock	20.1011	20.1493	20.0929	20.1332	1208704.0
2012-05-09 09:30:00	AAPL	Stock	20.1332	20.2921	20.0504	20.2321	67368252.0
2012-05-09 10:00:00	AAPL	Stock	20.2332	20.2357	20.0304	20.0601	46501616.0
2012-05-09 10:30:00	AAPL	Stock	20.0607	20.2604	20.0597	20.2293	41343008.0
2012-05-09 11:00:00	AAPL	Stock	20.2301	20.3779	20.1961	20.3411	47701024.0
2012-05-09 11:30:00	AAPL	Stock	20.3414	20.4992	20.2754	20.4068	57231356.0
2012-05-09 12:00:00	AAPL	Stock	20.4121	20.4546	20.3571	20.3721	25439596.0
2012-05-09 12:30:00	AAPL	Stock	20.376	20.376	20.2906	20.3683	24736572.0
2012-05-09 13:00:00	AAPL	Stock	20.3683	20.4289	20.3125	20.3596	25517940.0
2012-05-09 13:30:00	AAPL	Stock	20.3643	20.4979	20.3606	20.4757	27593300.0
2012-05-09 14:00:00	AAPL	Stock	20.4761	20.4929	20.3979	20.4504	20335028.0
2012-05-09 14:30:00	AAPL	Stock	20.455	20.4554	20.3571	20.3571	14428232.0
2012-05-09 15:00:00	AAPL	Stock	20.3571	20.4036	20.3054	20.3479	22335096.0
2012-05-09 15:30:00	AAPL	Stock	20.3482	20.4286	20.3271	20.3304	34967856.0
2012-05-09 16:00:00	AAPL	Stock	20.3304	20.4028	20.2166	20.2166	13504540.0
2012-05-09 16:30:00	AAPL	Stock	20.3893	20.3893	20.3054	20.3143	548212.0
2012-05-09 17:00:00	AAPL	Stock	20.2921	20.3096	20.2193	20.2296	927976.0
2012-05-09 17:30:00	AAPL	Stock	20.2446	20.2571	20.2429	20.25	152544.0
2012-05-09 18:00:00	AAPL	Stock	20.2571	20.2714	20.2396	20.27	169148.0
2012-05-09 18:30:00	AAPL	Stock	20.2679	20.2836	20.2679	20.275	101920.0
2012-05-09 19:00:00	AAPL	Stock	20.28	20.2857	20.2761	20.2786	53704.0
2012-05-09 19:30:00	AAPL	Stock	20.2804	20.2857	20.2796	20.2832	109564.0
2012-05-09 06:30:00	MSFT	Stock	30.25	30.25	30.14	30.14	600.0
2012-05-09 07:00:00	MSFT	Stock	30.15	30.17	30.11	30.17	3865.0
2012-05-09 07:30:00	MSFT	Stock	30.24	30.25	30.24	30.25	1500.0
2012-05-09 08:00:00	MSFT	Stock	30.25	30.33	30.25	30.25	7417.0
2012-05-09 08:30:00	MSFT	Stock	30.19	30.19	30.1	30.15	3700.0
2012-05-09 09:00:00	MSFT	Stock	30.1	30.22	30.1	30.16	28227.0
2012-05-09 09:30:00	MSFT	Stock	30.17	30.44	30.1	30.44	4174230.0
2012-05-09 10:00:00	MSFT	Stock	30.44	30.48	30.19	30.21	6169011.0
2012-05-09 10:30:00	MSFT	Stock	30.21	30.44	30.2	30.39	2936748.0
2012-05-09 11:00:00	MSFT	Stock	30.385	30.67	30.35	30.61	4583775.0
2012-05-09 11:30:00	MSFT	Stock	30.61	30.71	30.59	30.635	2826845.0
2012-05-09 12:00:00	MSFT	Stock	30.63	30.64	30.55	30.575	1887798.0
2012-05-09 12:30:00	MSFT	Stock	30.575	30.625	30.53	30.6	1846690.0
2012-05-09 13:00:00	MSFT	Stock	30.61	30.66	30.525	30.58	2679402.0
2012-05-09 13:30:00	MSFT	Stock	30.58	30.74	30.56	30.645	2916616.0
2012-05-09 14:00:00	MSFT	Stock	30.65	30.74	30.59	30.71	2761114.0
2012-05-09 14:30:00	MSFT	Stock	30.7	30.78	30.68	30.72	3171801.0
2012-05-09 15:00:00	MSFT	Stock	30.71	30.77	30.67	30.73	3267363.0
2012-05-09 15:30:00	MSFT	Stock	30.72	30.83	30.68	30.76	7321202.0

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

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