PREVIEW / stock_30min / 2013-06-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-21.parquet
  size:    1.6 MB
  rows:    83,366
  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
2013-06-21 05:30:00	AAPL	Stock	14.9707	14.9707	14.9675	14.9675	16800.0
2013-06-21 06:30:00	AAPL	Stock	14.9714	14.9718	14.9714	14.9714	22372.0
2013-06-21 07:00:00	AAPL	Stock	14.9643	14.9796	14.9436	14.9643	110180.0
2013-06-21 07:30:00	AAPL	Stock	14.9604	14.9889	14.9518	14.9789	154784.0
2013-06-21 08:00:00	AAPL	Stock	14.9918	14.9946	14.8536	14.95	1035468.0
2013-06-21 08:30:00	AAPL	Stock	14.9464	14.9589	14.88	14.9286	1161832.0
2013-06-21 09:00:00	AAPL	Stock	14.93	15.0	14.9207	14.9468	2447676.0
2013-06-21 09:30:00	AAPL	Stock	14.9464	15.0	14.7773	14.7793	115233468.0
2013-06-21 10:00:00	AAPL	Stock	14.7857	14.83	14.7261	14.7354	36562120.0
2013-06-21 10:30:00	AAPL	Stock	14.7354	14.7439	14.6554	14.6882	35153832.0
2013-06-21 11:00:00	AAPL	Stock	14.6857	14.6896	14.5907	14.6175	39437328.0
2013-06-21 11:30:00	AAPL	Stock	14.6168	14.6329	14.575	14.6164	35701904.0
2013-06-21 12:00:00	AAPL	Stock	14.6179	14.7071	14.6157	14.6564	28717192.0
2013-06-21 12:30:00	AAPL	Stock	14.6514	14.7546	14.6489	14.7404	26026728.0
2013-06-21 13:00:00	AAPL	Stock	14.7425	14.7736	14.7032	14.7125	19754756.0
2013-06-21 13:30:00	AAPL	Stock	14.7143	14.7625	14.6518	14.6611	16684472.0
2013-06-21 14:00:00	AAPL	Stock	14.6575	14.7096	14.6429	14.7057	17426808.0
2013-06-21 14:30:00	AAPL	Stock	14.7043	14.7293	14.6739	14.7218	15200248.0
2013-06-21 15:00:00	AAPL	Stock	14.7218	14.7629	14.6954	14.7189	21418936.0
2013-06-21 15:30:00	AAPL	Stock	14.7207	14.7768	14.7011	14.7743	40835480.0
2013-06-21 16:00:00	AAPL	Stock	14.7743	14.8916	14.6143	14.7741	18871160.0
2013-06-21 16:30:00	AAPL	Stock	14.7745	14.7746	14.629	14.7589	2728768.0
2013-06-21 17:00:00	AAPL	Stock	14.7554	14.7679	14.6656	14.7446	2961056.0
2013-06-21 17:30:00	AAPL	Stock	14.7339	14.7414	14.725	14.7321	288400.0
2013-06-21 18:00:00	AAPL	Stock	14.7321	14.7339	14.7321	14.7321	21280.0
2013-06-21 18:30:00	AAPL	Stock	14.7743	14.7743	14.7268	14.7268	46312.0
2013-06-21 19:00:00	AAPL	Stock	14.7321	14.7421	14.7321	14.74	21000.0
2013-06-21 19:30:00	AAPL	Stock	14.7321	14.75	14.7321	14.75	57232.0
2013-06-21 04:30:00	MSFT	Stock	33.54	33.54	33.49	33.49	200.0
2013-06-21 05:30:00	MSFT	Stock	33.59	33.59	33.59	33.59	100.0
2013-06-21 07:00:00	MSFT	Stock	33.65	33.68	33.65	33.68	600.0
2013-06-21 07:30:00	MSFT	Stock	33.68	33.68	33.65	33.65	2350.0
2013-06-21 08:00:00	MSFT	Stock	33.67	33.68	33.51	33.54	13975.0
2013-06-21 08:30:00	MSFT	Stock	33.57	33.64	33.5	33.64	28010.0
2013-06-21 09:00:00	MSFT	Stock	33.64	33.73	33.6	33.63	58374.0
2013-06-21 09:30:00	MSFT	Stock	33.66	33.73	33.21	33.25	28591797.0
2013-06-21 10:00:00	MSFT	Stock	33.245	33.33	33.05	33.23	4974535.0
2013-06-21 10:30:00	MSFT	Stock	33.24	33.36	33.19	33.315	4278729.0
2013-06-21 11:00:00	MSFT	Stock	33.318	33.38	33.175	33.3	3202742.0
2013-06-21 11:30:00	MSFT	Stock	33.29	33.29	33.13	33.26	2941425.0
2013-06-21 12:00:00	MSFT	Stock	33.26	33.32	33.12	33.12	2587201.0
2013-06-21 12:30:00	MSFT	Stock	33.12	33.46	33.06	33.459	2289341.0
2013-06-21 13:00:00	MSFT	Stock	33.45	33.51	33.35	33.395	1875637.0
2013-06-21 13:30:00	MSFT	Stock	33.395	33.45	33.22	33.25	2129273.0
2013-06-21 14:00:00	MSFT	Stock	33.255	33.28	33.12	33.21	3191017.0
2013-06-21 14:30:00	MSFT	Stock	33.21	33.29	33.16	33.29	3461220.0
2013-06-21 15:00:00	MSFT	Stock	33.29	33.45	33.25	33.385	3342471.0
2013-06-21 15:30:00	MSFT	Stock	33.39	33.41	33.22	33.25	9082705.0
2013-06-21 16:00:00	MSFT	Stock	33.25	33.503	33.2	33.23	10434921.0
2013-06-21 16:30:00	MSFT	Stock	33.24	33.69	33.17	33.24	575816.0

> showing 50 of 83,366 rows — these rows as CSV

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