PREVIEW / stock_30min / 2012-11-29

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-29.parquet
  size:    1.4 MB
  rows:    75,047
  symbols: 3,489

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-11-29 04:00:00	AAPL	Stock	20.9321	20.9321	20.9314	20.9314	8400.0
2012-11-29 04:30:00	AAPL	Stock	20.9464	20.9464	20.9375	20.9375	33600.0
2012-11-29 05:00:00	AAPL	Stock	20.9464	20.95	20.9396	20.9396	29400.0
2012-11-29 05:30:00	AAPL	Stock	20.9314	20.9607	20.9314	20.9607	19600.0
2012-11-29 06:00:00	AAPL	Stock	20.9582	20.9582	20.9307	20.9307	8400.0
2012-11-29 06:30:00	AAPL	Stock	20.9464	20.9607	20.9339	20.9607	25200.0
2012-11-29 07:00:00	AAPL	Stock	20.96	20.9821	20.9243	20.9732	562548.0
2012-11-29 07:30:00	AAPL	Stock	20.9818	21.0368	20.9736	21.0286	899220.0
2012-11-29 08:00:00	AAPL	Stock	21.0268	21.0318	20.9693	20.9911	1535576.0
2012-11-29 08:30:00	AAPL	Stock	20.9829	21.0264	20.9786	21.0239	1822576.0
2012-11-29 09:00:00	AAPL	Stock	21.0229	21.0986	21.0089	21.0718	3254104.0
2012-11-29 09:30:00	AAPL	Stock	21.075	21.2232	21.0564	21.1129	86964192.0
2012-11-29 10:00:00	AAPL	Stock	21.1132	21.1682	20.9646	21.075	67789540.0
2012-11-29 10:30:00	AAPL	Stock	21.075	21.1732	21.0446	21.1371	41673576.0
2012-11-29 11:00:00	AAPL	Stock	21.1375	21.1518	21.0439	21.0632	28638820.0
2012-11-29 11:30:00	AAPL	Stock	21.0629	21.0764	20.9018	21.0218	55228488.0
2012-11-29 12:00:00	AAPL	Stock	21.0237	21.0964	20.95	21.0749	34829648.0
2012-11-29 12:30:00	AAPL	Stock	21.0768	21.0829	21.0	21.0296	18397988.0
2012-11-29 13:00:00	AAPL	Stock	21.0311	21.0689	20.9704	21.0639	20577200.0
2012-11-29 13:30:00	AAPL	Stock	21.0625	21.0786	21.0179	21.0421	16353344.0
2012-11-29 14:00:00	AAPL	Stock	21.04	21.0704	20.9879	21.0418	19697440.0
2012-11-29 14:30:00	AAPL	Stock	21.0425	21.1311	21.0311	21.0841	23869804.0
2012-11-29 15:00:00	AAPL	Stock	21.0839	21.1039	21.0289	21.0479	29785112.0
2012-11-29 15:30:00	AAPL	Stock	21.0429	21.0786	21.0114	21.0482	39469612.0
2012-11-29 16:00:00	AAPL	Stock	21.0345	21.0818	21.0345	21.0486	6084232.0
2012-11-29 16:30:00	AAPL	Stock	21.0507	21.0507	21.0286	21.0421	397040.0
2012-11-29 17:00:00	AAPL	Stock	21.0346	21.0346	20.9575	20.9679	430220.0
2012-11-29 17:30:00	AAPL	Stock	20.9646	20.9904	20.9646	20.9857	91840.0
2012-11-29 18:00:00	AAPL	Stock	20.9821	21.0071	20.97	21.0	334040.0
2012-11-29 18:30:00	AAPL	Stock	21.0004	21.0104	20.9529	20.9529	216804.0
2012-11-29 19:00:00	AAPL	Stock	20.9507	20.9786	20.9393	20.9429	234080.0
2012-11-29 19:30:00	AAPL	Stock	20.9479	20.9821	20.9479	20.9564	157556.0
2012-11-29 04:00:00	MSFT	Stock	27.54	27.54	27.54	27.54	150.0
2012-11-29 06:30:00	MSFT	Stock	27.6	27.6	27.55	27.55	2300.0
2012-11-29 07:00:00	MSFT	Stock	27.55	27.59	27.54	27.59	9300.0
2012-11-29 07:30:00	MSFT	Stock	27.59	27.59	27.56	27.58	2750.0
2012-11-29 08:00:00	MSFT	Stock	27.5	27.58	27.34	27.49	50815.0
2012-11-29 08:30:00	MSFT	Stock	27.49	27.49	27.34	27.35	39664.0
2012-11-29 09:00:00	MSFT	Stock	27.35	27.4	27.0	27.11	269230.0
2012-11-29 09:30:00	MSFT	Stock	27.11	27.36	27.11	27.26	5548234.0
2012-11-29 10:00:00	MSFT	Stock	27.26	27.31	27.19	27.25	5598052.0
2012-11-29 10:30:00	MSFT	Stock	27.25	27.32	27.2	27.295	4492009.0
2012-11-29 11:00:00	MSFT	Stock	27.29	27.292	27.14	27.17	8093498.0
2012-11-29 11:30:00	MSFT	Stock	27.166	27.17	27.04	27.065	7843647.0
2012-11-29 12:00:00	MSFT	Stock	27.07	27.1	26.97	27.07	5566283.0
2012-11-29 12:30:00	MSFT	Stock	27.07	27.11	27.03	27.05	2980508.0
2012-11-29 13:00:00	MSFT	Stock	27.05	27.07	27.0	27.03	2622757.0
2012-11-29 13:30:00	MSFT	Stock	27.03	27.07	27.0	27.036	3382160.0
2012-11-29 14:00:00	MSFT	Stock	27.03	27.04	26.93	26.975	3913156.0
2012-11-29 14:30:00	MSFT	Stock	26.98	27.0	26.935	26.95	3356601.0

> showing 50 of 75,047 rows — these rows as CSV

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