PREVIEW / stock_30min / 2013-10-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-25.parquet
  size:    1.5 MB
  rows:    80,301
  symbols: 3,544

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-10-25 04:00:00	AAPL	Stock	19.0	19.01	18.9571	18.9571	47600.0
2013-10-25 04:30:00	AAPL	Stock	18.975	18.9821	18.9429	18.9821	46144.0
2013-10-25 05:00:00	AAPL	Stock	18.9943	19.0	18.9943	19.0	65520.0
2013-10-25 05:30:00	AAPL	Stock	18.9821	19.0207	18.9821	19.0	79884.0
2013-10-25 06:00:00	AAPL	Stock	19.0161	19.0246	18.9854	18.9854	100128.0
2013-10-25 06:30:00	AAPL	Stock	18.9854	19.0236	18.9854	19.0054	22540.0
2013-10-25 07:00:00	AAPL	Stock	19.0107	19.0711	19.0107	19.0357	534744.0
2013-10-25 07:30:00	AAPL	Stock	19.0221	19.0518	18.9929	19.0164	588504.0
2013-10-25 08:00:00	AAPL	Stock	19.0161	19.0625	18.9432	18.9679	1431976.0
2013-10-25 08:30:00	AAPL	Stock	18.9768	18.9993	18.9682	18.9936	462504.0
2013-10-25 09:00:00	AAPL	Stock	18.9982	19.0	18.9561	18.9696	1149260.0
2013-10-25 09:30:00	AAPL	Stock	18.9696	19.0439	18.9146	19.0006	57497244.0
2013-10-25 10:00:00	AAPL	Stock	19.0018	19.0268	18.9446	18.9799	25628540.0
2013-10-25 10:30:00	AAPL	Stock	18.9782	18.9829	18.9039	18.9082	21482580.0
2013-10-25 11:00:00	AAPL	Stock	18.9054	18.9496	18.8929	18.9136	21431368.0
2013-10-25 11:30:00	AAPL	Stock	18.9117	18.9329	18.8089	18.8539	27901664.0
2013-10-25 12:00:00	AAPL	Stock	18.8521	18.8571	18.7818	18.8268	19271392.0
2013-10-25 12:30:00	AAPL	Stock	18.8268	18.86	18.8079	18.8561	13270208.0
2013-10-25 13:00:00	AAPL	Stock	18.8575	18.9174	18.8368	18.9065	16643508.0
2013-10-25 13:30:00	AAPL	Stock	18.9075	18.9214	18.8832	18.9139	10898748.0
2013-10-25 14:00:00	AAPL	Stock	18.9139	18.9514	18.895	18.9157	16699088.0
2013-10-25 14:30:00	AAPL	Stock	18.9146	18.9167	18.852	18.8711	15453704.0
2013-10-25 15:00:00	AAPL	Stock	18.873	18.875	18.7846	18.7868	18976468.0
2013-10-25 15:30:00	AAPL	Stock	18.7886	18.8368	18.7539	18.789	45948980.0
2013-10-25 16:00:00	AAPL	Stock	18.7929	18.9968	18.7352	18.7743	10845548.0
2013-10-25 16:30:00	AAPL	Stock	18.775	18.8076	18.7571	18.765	1025332.0
2013-10-25 17:00:00	AAPL	Stock	18.7632	18.7668	18.7529	18.7554	205632.0
2013-10-25 17:30:00	AAPL	Stock	18.7582	18.7696	18.7582	18.7675	116844.0
2013-10-25 18:00:00	AAPL	Stock	18.7675	18.775	18.7607	18.7607	130172.0
2013-10-25 18:30:00	AAPL	Stock	18.7671	18.7679	18.7564	18.7675	36316.0
2013-10-25 19:00:00	AAPL	Stock	18.7625	18.7929	18.7564	18.7643	78260.0
2013-10-25 19:30:00	AAPL	Stock	18.7621	18.7671	18.7554	18.7554	133252.0
2013-10-25 04:00:00	MSFT	Stock	35.21	35.5	35.21	35.43	2140.0
2013-10-25 04:30:00	MSFT	Stock	35.35	35.35	35.22	35.22	5000.0
2013-10-25 05:30:00	MSFT	Stock	35.38	35.56	35.38	35.56	10250.0
2013-10-25 06:00:00	MSFT	Stock	35.52	35.52	35.49	35.5	6100.0
2013-10-25 06:30:00	MSFT	Stock	35.5	35.54	35.5	35.54	6110.0
2013-10-25 07:00:00	MSFT	Stock	35.6	36.17	35.6	35.8	239654.0
2013-10-25 07:30:00	MSFT	Stock	35.81	35.98	35.7	35.8	421101.0
2013-10-25 08:00:00	MSFT	Stock	35.76	36.1	35.55	35.73	936581.0
2013-10-25 08:30:00	MSFT	Stock	35.74	35.97	35.68	35.82	720902.0
2013-10-25 09:00:00	MSFT	Stock	35.83	35.94	35.71	35.87	2261734.0
2013-10-25 09:30:00	MSFT	Stock	35.88	36.19	35.69	36.12	28891492.0
2013-10-25 10:00:00	MSFT	Stock	36.12	36.29	35.88	35.925	15912881.0
2013-10-25 10:30:00	MSFT	Stock	35.93	36.02	35.86	35.875	8616150.0
2013-10-25 11:00:00	MSFT	Stock	35.879	35.92	35.63	35.744	7693198.0
2013-10-25 11:30:00	MSFT	Stock	35.743	35.84	35.553	35.603	5053636.0
2013-10-25 12:00:00	MSFT	Stock	35.603	35.71	35.47	35.59	4839867.0
2013-10-25 12:30:00	MSFT	Stock	35.593	35.65	35.56	35.61	2712292.0
2013-10-25 13:00:00	MSFT	Stock	35.61	35.85	35.6	35.79	4895480.0

> showing 50 of 80,301 rows — these rows as CSV

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