PREVIEW / stock_30min / 2012-03-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-14.parquet
  size:    1.4 MB
  rows:    77,188
  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
2012-03-14 04:00:00	AAPL	Stock	20.3371	20.3929	20.3371	20.3825	105000.0
2012-03-14 04:30:00	AAPL	Stock	20.3825	20.4607	20.3825	20.4325	82852.0
2012-03-14 05:00:00	AAPL	Stock	20.4604	20.5357	20.4604	20.5107	170464.0
2012-03-14 05:30:00	AAPL	Stock	20.5107	20.5143	20.4821	20.4821	218372.0
2012-03-14 06:00:00	AAPL	Stock	20.4821	20.5	20.4821	20.5	170520.0
2012-03-14 06:30:00	AAPL	Stock	20.5089	20.5536	20.5071	20.5432	278544.0
2012-03-14 07:00:00	AAPL	Stock	20.5464	20.5675	20.4979	20.4982	1077020.0
2012-03-14 07:30:00	AAPL	Stock	20.5004	20.5086	20.4436	20.4629	2151016.0
2012-03-14 08:00:00	AAPL	Stock	20.4643	20.5889	20.45	20.5721	5573680.0
2012-03-14 08:30:00	AAPL	Stock	20.58	20.6332	20.5536	20.62	6851096.0
2012-03-14 09:00:00	AAPL	Stock	20.6204	20.6875	20.6075	20.6496	9112180.0
2012-03-14 09:30:00	AAPL	Stock	20.6468	20.8518	20.5743	20.7589	200755716.0
2012-03-14 10:00:00	AAPL	Stock	20.7593	20.8136	20.7046	20.7532	82031180.0
2012-03-14 10:30:00	AAPL	Stock	20.7521	20.8561	20.7429	20.7964	72702448.0
2012-03-14 11:00:00	AAPL	Stock	20.7964	20.8296	20.7414	20.8157	56729960.0
2012-03-14 11:30:00	AAPL	Stock	20.8157	20.8175	20.6996	20.81	60531044.0
2012-03-14 12:00:00	AAPL	Stock	20.8107	20.8318	20.7629	20.8036	37872856.0
2012-03-14 12:30:00	AAPL	Stock	20.8036	20.9532	20.7893	20.935	64603840.0
2012-03-14 13:00:00	AAPL	Stock	20.9382	21.24	20.8836	21.1964	144030012.0
2012-03-14 13:30:00	AAPL	Stock	21.2079	21.2229	20.8439	20.8925	158571336.0
2012-03-14 14:00:00	AAPL	Stock	20.8896	20.9574	20.55	20.8646	163497684.0
2012-03-14 14:30:00	AAPL	Stock	20.8646	20.9375	20.7946	20.8864	90212248.0
2012-03-14 15:00:00	AAPL	Stock	20.8882	21.0214	20.7968	21.015	86875488.0
2012-03-14 15:30:00	AAPL	Stock	21.0189	21.0889	20.9682	21.0564	122508596.0
2012-03-14 16:00:00	AAPL	Stock	21.0547	21.1418	20.6582	21.1264	21172732.0
2012-03-14 16:30:00	AAPL	Stock	21.1232	21.1268	21.0182	21.0914	1388296.0
2012-03-14 17:00:00	AAPL	Stock	21.0925	21.0989	21.0564	21.08	815500.0
2012-03-14 17:30:00	AAPL	Stock	21.075	21.085	21.0396	21.0536	793436.0
2012-03-14 18:00:00	AAPL	Stock	21.0536	21.0854	21.0486	21.0793	417732.0
2012-03-14 18:30:00	AAPL	Stock	21.0829	21.0982	21.0714	21.0939	581756.0
2012-03-14 19:00:00	AAPL	Stock	21.0914	21.1425	21.09	21.1411	961352.0
2012-03-14 19:30:00	AAPL	Stock	21.1386	21.1679	21.1214	21.1661	1328124.0
2012-03-14 07:30:00	MSFT	Stock	32.61	32.61	32.6	32.6	1186.0
2012-03-14 08:00:00	MSFT	Stock	32.59	32.67	32.57	32.59	6839.0
2012-03-14 08:30:00	MSFT	Stock	32.58	32.6	32.57	32.57	10370.0
2012-03-14 09:00:00	MSFT	Stock	32.62	32.64	32.5	32.53	24189.0
2012-03-14 09:30:00	MSFT	Stock	32.53	32.6	32.49	32.58	4472508.0
2012-03-14 10:00:00	MSFT	Stock	32.57	32.67	32.55	32.623	3395878.0
2012-03-14 10:30:00	MSFT	Stock	32.627	32.88	32.62	32.8	3400388.0
2012-03-14 11:00:00	MSFT	Stock	32.8	32.82	32.71	32.8	3030065.0
2012-03-14 11:30:00	MSFT	Stock	32.8	32.84	32.76	32.808	2045149.0
2012-03-14 12:00:00	MSFT	Stock	32.807	32.85	32.75	32.79	2077653.0
2012-03-14 12:30:00	MSFT	Stock	32.78	32.83	32.75	32.75	1863323.0
2012-03-14 13:00:00	MSFT	Stock	32.753	32.8	32.73	32.73	1964670.0
2012-03-14 13:30:00	MSFT	Stock	32.73	32.73	32.62	32.68	2682756.0
2012-03-14 14:00:00	MSFT	Stock	32.687	32.72	32.64	32.657	2322944.0
2012-03-14 14:30:00	MSFT	Stock	32.66	32.74	32.6	32.73	2218825.0
2012-03-14 15:00:00	MSFT	Stock	32.72	32.79	32.67	32.78	2070808.0
2012-03-14 15:30:00	MSFT	Stock	32.785	32.79	32.67	32.775	4320209.0
2012-03-14 16:00:00	MSFT	Stock	32.78	32.79	32.657	32.705	5602345.0

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

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