PREVIEW / stock_30min / 2012-03-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-28.parquet
  size:    1.4 MB
  rows:    74,819
  symbols: 3,524

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-28 04:00:00	AAPL	Stock	21.9657	22.0346	21.9657	22.0346	32200.0
2012-03-28 04:30:00	AAPL	Stock	22.0107	22.0107	21.9732	22.0	66500.0
2012-03-28 05:00:00	AAPL	Stock	21.9754	22.0054	21.9754	22.0054	22400.0
2012-03-28 05:30:00	AAPL	Stock	22.0	22.0036	21.9811	22.0036	34720.0
2012-03-28 06:00:00	AAPL	Stock	22.0014	22.005	22.0007	22.005	40040.0
2012-03-28 06:30:00	AAPL	Stock	22.0054	22.0125	22.0036	22.0125	124600.0
2012-03-28 07:00:00	AAPL	Stock	22.0089	22.0625	21.9929	22.0607	504308.0
2012-03-28 07:30:00	AAPL	Stock	22.0596	22.0736	22.0254	22.0411	636664.0
2012-03-28 08:00:00	AAPL	Stock	22.0479	22.0832	22.0321	22.065	3290560.0
2012-03-28 08:30:00	AAPL	Stock	22.0646	22.0768	22.0429	22.0446	2550996.0
2012-03-28 09:00:00	AAPL	Stock	22.0446	22.0911	22.0361	22.0893	2123436.0
2012-03-28 09:30:00	AAPL	Stock	22.085	22.1946	22.0557	22.1082	117692008.0
2012-03-28 10:00:00	AAPL	Stock	22.1104	22.1893	22.1025	22.1375	53866624.0
2012-03-28 10:30:00	AAPL	Stock	22.1354	22.1389	22.0146	22.0914	60767784.0
2012-03-28 11:00:00	AAPL	Stock	22.0914	22.1268	22.0479	22.0689	33946780.0
2012-03-28 11:30:00	AAPL	Stock	22.0692	22.0779	21.9536	22.0115	59605000.0
2012-03-28 12:00:00	AAPL	Stock	22.0121	22.0139	21.7968	21.9836	74727380.0
2012-03-28 12:30:00	AAPL	Stock	21.9846	21.9943	21.9382	21.9804	26727176.0
2012-03-28 13:00:00	AAPL	Stock	21.9796	22.0275	21.875	21.9407	34283732.0
2012-03-28 13:30:00	AAPL	Stock	21.9375	21.9818	21.8839	21.9779	20595008.0
2012-03-28 14:00:00	AAPL	Stock	21.9782	21.9821	21.9204	21.9368	23555840.0
2012-03-28 14:30:00	AAPL	Stock	21.9375	22.0521	21.9214	22.0481	29300600.0
2012-03-28 15:00:00	AAPL	Stock	22.0487	22.0796	22.0196	22.0314	36292788.0
2012-03-28 15:30:00	AAPL	Stock	22.035	22.0746	22.0161	22.0575	42950460.0
2012-03-28 16:00:00	AAPL	Stock	22.0579	22.0714	21.9354	22.0639	23780204.0
2012-03-28 16:30:00	AAPL	Stock	22.0625	22.0625	22.0231	22.0575	326872.0
2012-03-28 17:00:00	AAPL	Stock	22.0575	22.0589	22.0464	22.0536	107212.0
2012-03-28 17:30:00	AAPL	Stock	22.0536	22.0629	22.0536	22.0546	59808.0
2012-03-28 18:00:00	AAPL	Stock	22.0521	22.0607	22.0518	22.0579	61600.0
2012-03-28 18:30:00	AAPL	Stock	22.0582	22.0614	22.0564	22.0589	59472.0
2012-03-28 19:00:00	AAPL	Stock	22.0564	22.065	22.0564	22.0646	248780.0
2012-03-28 19:30:00	AAPL	Stock	22.0643	22.0643	22.0543	22.0543	360752.0
2012-03-28 04:00:00	MSFT	Stock	32.51	32.51	32.51	32.51	227.0
2012-03-28 07:30:00	MSFT	Stock	32.47	32.52	32.47	32.52	1820.0
2012-03-28 08:00:00	MSFT	Stock	32.53	32.55	32.47	32.5	5891.0
2012-03-28 08:30:00	MSFT	Stock	32.48	32.52	32.47	32.48	2204.0
2012-03-28 09:00:00	MSFT	Stock	32.48	32.55	32.48	32.54	64134.0
2012-03-28 09:30:00	MSFT	Stock	32.54	32.7	32.5	32.67	3249362.0
2012-03-28 10:00:00	MSFT	Stock	32.66	32.69	32.51	32.552	2332770.0
2012-03-28 10:30:00	MSFT	Stock	32.56	32.58	32.45	32.48	2962101.0
2012-03-28 11:00:00	MSFT	Stock	32.49	32.54	32.45	32.47	2397043.0
2012-03-28 11:30:00	MSFT	Stock	32.48	32.48	32.2	32.22	2872288.0
2012-03-28 12:00:00	MSFT	Stock	32.23	32.29	32.18	32.275	2211109.0
2012-03-28 12:30:00	MSFT	Stock	32.28	32.28	32.17	32.255	1628225.0
2012-03-28 13:00:00	MSFT	Stock	32.26	32.275	32.2	32.23	1156766.0
2012-03-28 13:30:00	MSFT	Stock	32.23	32.26	32.18	32.21	1538730.0
2012-03-28 14:00:00	MSFT	Stock	32.21	32.21	32.04	32.105	3215466.0
2012-03-28 14:30:00	MSFT	Stock	32.11	32.25	32.09	32.22	2026072.0
2012-03-28 15:00:00	MSFT	Stock	32.23	32.28	32.154	32.17	2465687.0
2012-03-28 15:30:00	MSFT	Stock	32.18	32.25	32.15	32.175	7421464.0

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

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