PREVIEW / stock_30min / 2012-11-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-19.parquet
  size:    1.4 MB
  rows:    75,503
  symbols: 3,477

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-19 04:00:00	AAPL	Stock	18.9375	19.1071	18.9375	19.0714	194152.0
2012-11-19 04:30:00	AAPL	Stock	19.0643	19.0786	19.0625	19.0768	33824.0
2012-11-19 05:00:00	AAPL	Stock	19.0893	19.1018	19.0861	19.0964	77840.0
2012-11-19 05:30:00	AAPL	Stock	19.1018	19.1075	19.0714	19.0714	297920.0
2012-11-19 06:00:00	AAPL	Stock	19.0786	19.0893	19.0786	19.0786	63252.0
2012-11-19 06:30:00	AAPL	Stock	19.0786	19.1071	19.0714	19.0996	448000.0
2012-11-19 07:00:00	AAPL	Stock	19.0996	19.1314	19.0804	19.0804	701260.0
2012-11-19 07:30:00	AAPL	Stock	19.0818	19.0871	19.0375	19.0818	885584.0
2012-11-19 08:00:00	AAPL	Stock	19.0736	19.2004	19.0629	19.1754	3687516.0
2012-11-19 08:30:00	AAPL	Stock	19.1729	19.1932	19.1429	19.1664	2813412.0
2012-11-19 09:00:00	AAPL	Stock	19.1657	19.4282	19.1539	19.3111	7357056.0
2012-11-19 09:30:00	AAPL	Stock	19.3107	19.6311	19.2814	19.6182	166369560.0
2012-11-19 10:00:00	AAPL	Stock	19.6196	19.6429	19.5314	19.5636	71333920.0
2012-11-19 10:30:00	AAPL	Stock	19.5679	19.7767	19.5393	19.7429	73847788.0
2012-11-19 11:00:00	AAPL	Stock	19.7418	19.8154	19.7054	19.7629	52217424.0
2012-11-19 11:30:00	AAPL	Stock	19.7632	19.8214	19.7411	19.7961	32489464.0
2012-11-19 12:00:00	AAPL	Stock	19.8	19.9868	19.7889	19.965	62110692.0
2012-11-19 12:30:00	AAPL	Stock	19.9678	19.9804	19.9207	19.9596	31327492.0
2012-11-19 13:00:00	AAPL	Stock	19.9596	19.9825	19.8371	19.8689	34184024.0
2012-11-19 13:30:00	AAPL	Stock	19.8639	19.9507	19.8571	19.9418	20995996.0
2012-11-19 14:00:00	AAPL	Stock	19.9396	20.0	19.9264	19.9718	28808892.0
2012-11-19 14:30:00	AAPL	Stock	19.9718	20.0929	19.9219	20.0716	49982828.0
2012-11-19 15:00:00	AAPL	Stock	20.0725	20.1379	20.0286	20.1079	42166348.0
2012-11-19 15:30:00	AAPL	Stock	20.1104	20.2679	20.0982	20.2118	91256872.0
2012-11-19 16:00:00	AAPL	Stock	20.2261	20.234	19.5357	20.1911	21555968.0
2012-11-19 16:30:00	AAPL	Stock	20.1857	20.23	19.4301	20.2229	1067976.0
2012-11-19 17:00:00	AAPL	Stock	20.2214	20.2246	20.1871	20.1946	1093540.0
2012-11-19 17:30:00	AAPL	Stock	20.1929	20.2018	20.1875	20.1993	343504.0
2012-11-19 18:00:00	AAPL	Stock	20.1932	20.2	20.1911	20.1911	198968.0
2012-11-19 18:30:00	AAPL	Stock	20.1964	20.2	20.1879	20.1893	157192.0
2012-11-19 19:00:00	AAPL	Stock	20.1907	20.1921	20.1786	20.1846	336224.0
2012-11-19 19:30:00	AAPL	Stock	20.1825	20.1889	20.1793	20.1889	257152.0
2012-11-19 07:30:00	MSFT	Stock	26.64	26.75	26.6	26.75	9300.0
2012-11-19 08:00:00	MSFT	Stock	26.73	26.78	26.66	26.7	42009.0
2012-11-19 08:30:00	MSFT	Stock	26.72	26.76	26.7	26.76	167857.0
2012-11-19 09:00:00	MSFT	Stock	26.72	26.81	26.7	26.8	81334.0
2012-11-19 09:30:00	MSFT	Stock	26.8	26.8	26.57	26.57	8388118.0
2012-11-19 10:00:00	MSFT	Stock	26.575	26.64	26.47	26.63	7390647.0
2012-11-19 10:30:00	MSFT	Stock	26.625	26.71	26.57	26.66	4465277.0
2012-11-19 11:00:00	MSFT	Stock	26.67	26.728	26.62	26.695	3144365.0
2012-11-19 11:30:00	MSFT	Stock	26.7	26.72	26.67	26.675	2100253.0
2012-11-19 12:00:00	MSFT	Stock	26.674	26.75	26.67	26.726	3024830.0
2012-11-19 12:30:00	MSFT	Stock	26.72	26.78	26.72	26.77	1982371.0
2012-11-19 13:00:00	MSFT	Stock	26.77	26.78	26.65	26.72	2288255.0
2012-11-19 13:30:00	MSFT	Stock	26.72	26.73	26.61	26.66	2042792.0
2012-11-19 14:00:00	MSFT	Stock	26.67	26.68	26.63	26.655	2001905.0
2012-11-19 14:30:00	MSFT	Stock	26.655	26.67	26.61	26.633	2280920.0
2012-11-19 15:00:00	MSFT	Stock	26.635	26.69	26.59	26.685	2990608.0
2012-11-19 15:30:00	MSFT	Stock	26.69	26.76	26.64	26.74	8296338.0
2012-11-19 16:00:00	MSFT	Stock	26.72	26.78	26.514	26.75	5909757.0

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

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