PREVIEW / stock_30min / 2013-12-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-09.parquet
  size:    1.6 MB
  rows:    82,921
  symbols: 3,549

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-09 04:00:00	AAPL	Stock	20.0864	20.0864	20.0725	20.0725	44800.0
2013-12-09 04:30:00	AAPL	Stock	20.075	20.075	20.075	20.075	5600.0
2013-12-09 05:30:00	AAPL	Stock	20.0621	20.0621	20.0429	20.0429	29820.0
2013-12-09 06:00:00	AAPL	Stock	20.0679	20.0714	20.0679	20.0714	14000.0
2013-12-09 06:30:00	AAPL	Stock	20.0714	20.0771	20.0714	20.0757	32228.0
2013-12-09 07:00:00	AAPL	Stock	20.08	20.1071	20.0657	20.0832	156464.0
2013-12-09 07:30:00	AAPL	Stock	20.1061	20.1161	20.0914	20.1071	86800.0
2013-12-09 08:00:00	AAPL	Stock	20.0982	20.1107	20.0518	20.0829	1286488.0
2013-12-09 08:30:00	AAPL	Stock	20.0839	20.0957	20.0679	20.0725	580076.0
2013-12-09 09:00:00	AAPL	Stock	20.0775	20.0893	20.0186	20.0371	1117452.0
2013-12-09 09:30:00	AAPL	Stock	20.0321	20.2134	20.0321	20.1256	49705348.0
2013-12-09 10:00:00	AAPL	Stock	20.1339	20.19	20.1114	20.1479	21163632.0
2013-12-09 10:30:00	AAPL	Stock	20.1468	20.2521	20.1346	20.2482	25235084.0
2013-12-09 11:00:00	AAPL	Stock	20.2493	20.3196	20.2411	20.2821	23545144.0
2013-12-09 11:30:00	AAPL	Stock	20.2796	20.2968	20.2598	20.2889	23055816.0
2013-12-09 12:00:00	AAPL	Stock	20.2893	20.3354	20.2664	20.3243	20632304.0
2013-12-09 12:30:00	AAPL	Stock	20.3243	20.3286	20.2943	20.2979	9730196.0
2013-12-09 13:00:00	AAPL	Stock	20.2975	20.3411	20.2939	20.3339	8920828.0
2013-12-09 13:30:00	AAPL	Stock	20.3321	20.3421	20.3	20.305	8354220.0
2013-12-09 14:00:00	AAPL	Stock	20.3054	20.3121	20.2436	20.2664	12468680.0
2013-12-09 14:30:00	AAPL	Stock	20.2693	20.2946	20.2329	20.2504	11919824.0
2013-12-09 15:00:00	AAPL	Stock	20.2507	20.2729	20.2132	20.2214	11766440.0
2013-12-09 15:30:00	AAPL	Stock	20.2232	20.2546	20.2154	20.2357	19407304.0
2013-12-09 16:00:00	AAPL	Stock	20.2296	20.2361	20.2107	20.2232	14462280.0
2013-12-09 16:30:00	AAPL	Stock	20.2261	20.3412	20.2219	20.2264	488432.0
2013-12-09 17:00:00	AAPL	Stock	20.2236	20.2407	20.2236	20.2393	133616.0
2013-12-09 17:30:00	AAPL	Stock	20.2346	20.25	20.2296	20.2496	197288.0
2013-12-09 18:00:00	AAPL	Stock	20.2493	20.2586	20.2296	20.2586	167748.0
2013-12-09 18:30:00	AAPL	Stock	20.2589	20.2714	20.2518	20.2607	67760.0
2013-12-09 19:00:00	AAPL	Stock	20.2589	20.2607	20.25	20.2554	32340.0
2013-12-09 19:30:00	AAPL	Stock	20.2625	20.2679	20.2607	20.2661	104048.0
2013-12-09 04:00:00	MSFT	Stock	38.36	38.36	38.36	38.36	300.0
2013-12-09 05:00:00	MSFT	Stock	38.38	38.4	38.38	38.4	553.0
2013-12-09 06:00:00	MSFT	Stock	38.41	38.41	38.38	38.38	440.0
2013-12-09 07:00:00	MSFT	Stock	38.5	38.5	38.46	38.46	875.0
2013-12-09 07:30:00	MSFT	Stock	38.48	38.5	38.45	38.48	1786.0
2013-12-09 08:00:00	MSFT	Stock	38.46	38.46	38.41	38.42	13855.0
2013-12-09 08:30:00	MSFT	Stock	38.45	38.49	38.42	38.45	22642.0
2013-12-09 09:00:00	MSFT	Stock	38.46	38.55	38.42	38.55	16400.0
2013-12-09 09:30:00	MSFT	Stock	38.55	38.68	38.37	38.59	4344756.0
2013-12-09 10:00:00	MSFT	Stock	38.59	38.8	38.59	38.7	2258535.0
2013-12-09 10:30:00	MSFT	Stock	38.7	38.8	38.66	38.735	1839367.0
2013-12-09 11:00:00	MSFT	Stock	38.735	38.74	38.64	38.7	1529707.0
2013-12-09 11:30:00	MSFT	Stock	38.71	38.72	38.56	38.56	1012232.0
2013-12-09 12:00:00	MSFT	Stock	38.56	38.64	38.52	38.59	1287102.0
2013-12-09 12:30:00	MSFT	Stock	38.58	38.74	38.58	38.73	1047786.0
2013-12-09 13:00:00	MSFT	Stock	38.74	38.8	38.72	38.79	1247767.0
2013-12-09 13:30:00	MSFT	Stock	38.79	38.87	38.78	38.83	1097399.0
2013-12-09 14:00:00	MSFT	Stock	38.83	38.83	38.705	38.73	1815650.0
2013-12-09 14:30:00	MSFT	Stock	38.73	38.74	38.63	38.64	1585844.0

> showing 50 of 82,921 rows — these rows as CSV

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