PREVIEW / stock_30min / 2012-05-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-11.parquet
  size:    1.4 MB
  rows:    74,771
  symbols: 3,518

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-11 04:30:00	AAPL	Stock	20.3093	20.3093	20.3	20.3093	16800.0
2012-05-11 05:00:00	AAPL	Stock	20.3093	20.3093	20.3093	20.3093	5600.0
2012-05-11 06:00:00	AAPL	Stock	20.2857	20.3304	20.2857	20.3304	83580.0
2012-05-11 06:30:00	AAPL	Stock	20.3214	20.3214	20.2407	20.2721	45360.0
2012-05-11 07:00:00	AAPL	Stock	20.2786	20.2786	20.2321	20.2429	304948.0
2012-05-11 07:30:00	AAPL	Stock	20.2464	20.2954	20.2411	20.2786	935340.0
2012-05-11 08:00:00	AAPL	Stock	20.2786	20.2864	20.1964	20.2143	1255884.0
2012-05-11 08:30:00	AAPL	Stock	20.2143	20.2146	20.0536	20.1211	7016072.0
2012-05-11 09:00:00	AAPL	Stock	20.1239	20.1825	20.0804	20.1825	5404448.0
2012-05-11 09:30:00	AAPL	Stock	20.1825	20.3186	20.1554	20.2436	67434220.0
2012-05-11 10:00:00	AAPL	Stock	20.2479	20.4029	20.2407	20.3564	43923712.0
2012-05-11 10:30:00	AAPL	Stock	20.3568	20.5168	20.3546	20.4236	53052244.0
2012-05-11 11:00:00	AAPL	Stock	20.4241	20.4425	20.3771	20.4054	27418384.0
2012-05-11 11:30:00	AAPL	Stock	20.4099	20.4396	20.33	20.3675	20423032.0
2012-05-11 12:00:00	AAPL	Stock	20.3607	20.3671	20.2904	20.333	19479740.0
2012-05-11 12:30:00	AAPL	Stock	20.3339	20.3711	20.2936	20.31	19875324.0
2012-05-11 13:00:00	AAPL	Stock	20.3089	20.3479	20.2682	20.3354	21124796.0
2012-05-11 13:30:00	AAPL	Stock	20.3354	20.3661	20.3082	20.3392	12352228.0
2012-05-11 14:00:00	AAPL	Stock	20.3389	20.365	20.2982	20.3386	12219844.0
2012-05-11 14:30:00	AAPL	Stock	20.3389	20.3457	20.2918	20.3093	14353444.0
2012-05-11 15:00:00	AAPL	Stock	20.3096	20.3243	20.2768	20.2818	17241336.0
2012-05-11 15:30:00	AAPL	Stock	20.2786	20.2875	20.2129	20.2396	42444136.0
2012-05-11 16:00:00	AAPL	Stock	20.2396	20.3649	20.2318	20.2454	8265152.0
2012-05-11 16:30:00	AAPL	Stock	20.2454	20.2785	20.2321	20.2321	477316.0
2012-05-11 17:00:00	AAPL	Stock	20.2396	20.2429	20.2221	20.2411	127652.0
2012-05-11 17:30:00	AAPL	Stock	20.2418	20.2418	20.2007	20.2079	475132.0
2012-05-11 18:00:00	AAPL	Stock	20.2121	20.2268	20.2121	20.225	81788.0
2012-05-11 18:30:00	AAPL	Stock	20.2236	20.225	20.2182	20.2182	89320.0
2012-05-11 19:00:00	AAPL	Stock	20.2207	20.2214	20.2071	20.2071	112644.0
2012-05-11 19:30:00	AAPL	Stock	20.2107	20.2107	20.1925	20.2029	169624.0
2012-05-11 07:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	490.0
2012-05-11 08:00:00	MSFT	Stock	30.67	30.7	30.65	30.65	3200.0
2012-05-11 08:30:00	MSFT	Stock	30.58	30.58	30.54	30.56	900.0
2012-05-11 09:00:00	MSFT	Stock	30.57	30.74	30.57	30.69	45680.0
2012-05-11 09:30:00	MSFT	Stock	30.69	31.13	30.69	31.1	5207477.0
2012-05-11 10:00:00	MSFT	Stock	31.11	31.54	31.1	31.45	6863624.0
2012-05-11 10:30:00	MSFT	Stock	31.46	31.49	31.34	31.38	3576745.0
2012-05-11 11:00:00	MSFT	Stock	31.38	31.4	31.29	31.36	3927203.0
2012-05-11 11:30:00	MSFT	Stock	31.37	31.41	31.32	31.34	2105632.0
2012-05-11 12:00:00	MSFT	Stock	31.34	31.35	31.29	31.305	1161754.0
2012-05-11 12:30:00	MSFT	Stock	31.31	31.35	31.3	31.32	1208940.0
2012-05-11 13:00:00	MSFT	Stock	31.328	31.38	31.28	31.365	2921583.0
2012-05-11 13:30:00	MSFT	Stock	31.36	31.43	31.34	31.37	1656665.0
2012-05-11 14:00:00	MSFT	Stock	31.375	31.4	31.291	31.35	1808871.0
2012-05-11 14:30:00	MSFT	Stock	31.34	31.345	31.28	31.31	2463026.0
2012-05-11 15:00:00	MSFT	Stock	31.31	31.34	31.27	31.315	2477432.0
2012-05-11 15:30:00	MSFT	Stock	31.315	31.32	31.16	31.17	4857512.0
2012-05-11 16:00:00	MSFT	Stock	31.17	31.342	31.12	31.17	2363419.0
2012-05-11 16:30:00	MSFT	Stock	31.304	31.304	31.16	31.16	43434.0
2012-05-11 17:00:00	MSFT	Stock	31.21	31.27	31.21	31.27	1345.0

> showing 50 of 74,771 rows — these rows as CSV

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