PREVIEW / stock_30min / 2012-12-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-13.parquet
  size:    1.4 MB
  rows:    75,398
  symbols: 3,507

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-12-13 04:00:00	AAPL	Stock	19.2682	19.2739	19.2682	19.2739	5600.0
2012-12-13 04:30:00	AAPL	Stock	19.2346	19.2346	19.2346	19.2346	2800.0
2012-12-13 05:00:00	AAPL	Stock	19.2146	19.2146	19.1993	19.1993	5600.0
2012-12-13 05:30:00	AAPL	Stock	19.1964	19.1964	19.1929	19.1964	49560.0
2012-12-13 06:00:00	AAPL	Stock	19.1964	19.1964	19.1786	19.1821	52640.0
2012-12-13 06:30:00	AAPL	Stock	19.1607	19.1607	19.1429	19.1607	53452.0
2012-12-13 07:00:00	AAPL	Stock	19.1464	19.2143	19.1464	19.21	227052.0
2012-12-13 07:30:00	AAPL	Stock	19.2054	19.2057	19.15	19.1586	232932.0
2012-12-13 08:00:00	AAPL	Stock	19.1614	19.2143	19.0357	19.0893	2144912.0
2012-12-13 08:30:00	AAPL	Stock	19.0929	19.1243	18.8857	18.9193	9189152.0
2012-12-13 09:00:00	AAPL	Stock	18.9282	18.9946	18.9132	18.9661	4119472.0
2012-12-13 09:30:00	AAPL	Stock	18.9682	19.1357	18.9036	18.9489	105508760.0
2012-12-13 10:00:00	AAPL	Stock	18.9545	19.2014	18.9104	19.1521	64634976.0
2012-12-13 10:30:00	AAPL	Stock	19.1439	19.1725	19.0	19.05	37020900.0
2012-12-13 11:00:00	AAPL	Stock	19.0518	19.0836	18.9821	19.0311	31297532.0
2012-12-13 11:30:00	AAPL	Stock	19.0339	19.0932	18.9925	19.0264	25615464.0
2012-12-13 12:00:00	AAPL	Stock	19.024	19.0521	18.9286	18.93	26563432.0
2012-12-13 12:30:00	AAPL	Stock	18.9286	18.9764	18.8746	18.8746	37210852.0
2012-12-13 13:00:00	AAPL	Stock	18.875	18.9446	18.8532	18.8971	37304092.0
2012-12-13 13:30:00	AAPL	Stock	18.8961	18.8993	18.8286	18.8904	28096068.0
2012-12-13 14:00:00	AAPL	Stock	18.8912	18.8921	18.7786	18.8118	37955568.0
2012-12-13 14:30:00	AAPL	Stock	18.8186	18.9036	18.8046	18.8507	32252276.0
2012-12-13 15:00:00	AAPL	Stock	18.8464	18.8814	18.8075	18.8386	23051560.0
2012-12-13 15:30:00	AAPL	Stock	18.8371	18.9382	18.825	18.9143	66405976.0
2012-12-13 16:00:00	AAPL	Stock	18.9251	19.2306	18.8818	18.8929	31950492.0
2012-12-13 16:30:00	AAPL	Stock	18.8875	19.0179	18.8425	18.8714	2064188.0
2012-12-13 17:00:00	AAPL	Stock	18.8714	18.8714	18.8304	18.8661	457996.0
2012-12-13 17:30:00	AAPL	Stock	18.8554	18.8571	18.8304	18.8482	329532.0
2012-12-13 18:00:00	AAPL	Stock	18.8429	18.8689	18.8429	18.8661	215656.0
2012-12-13 18:30:00	AAPL	Stock	18.8643	18.9	18.8518	18.8664	290668.0
2012-12-13 19:00:00	AAPL	Stock	18.8664	18.8746	18.8582	18.8582	61908.0
2012-12-13 19:30:00	AAPL	Stock	18.8536	18.8607	18.825	18.8257	262864.0
2012-12-13 05:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	196.0
2012-12-13 08:00:00	MSFT	Stock	27.26	27.26	27.19	27.26	2575.0
2012-12-13 08:30:00	MSFT	Stock	27.26	27.26	27.19	27.24	17089.0
2012-12-13 09:00:00	MSFT	Stock	27.25	27.37	27.2	27.28	59028.0
2012-12-13 09:30:00	MSFT	Stock	27.33	27.52	27.22	27.36	4747289.0
2012-12-13 10:00:00	MSFT	Stock	27.36	27.46	27.3	27.431	2963222.0
2012-12-13 10:30:00	MSFT	Stock	27.43	27.44	27.36	27.41	1862613.0
2012-12-13 11:00:00	MSFT	Stock	27.405	27.41	27.18	27.22	2511613.0
2012-12-13 11:30:00	MSFT	Stock	27.22	27.236	27.075	27.14	2962604.0
2012-12-13 12:00:00	MSFT	Stock	27.14	27.15	27.04	27.06	3383220.0
2012-12-13 12:30:00	MSFT	Stock	27.06	27.07	27.01	27.02	2818525.0
2012-12-13 13:00:00	MSFT	Stock	27.02	27.09	26.98	27.07	3146320.0
2012-12-13 13:30:00	MSFT	Stock	27.06	27.07	26.98	27.03	2745565.0
2012-12-13 14:00:00	MSFT	Stock	27.03	27.04	26.95	27.04	1824516.0
2012-12-13 14:30:00	MSFT	Stock	27.03	27.08	26.99	27.08	1918830.0
2012-12-13 15:00:00	MSFT	Stock	27.075	27.08	27.01	27.05	4678260.0
2012-12-13 15:30:00	MSFT	Stock	27.05	27.2	27.04	27.11	5958514.0
2012-12-13 16:00:00	MSFT	Stock	27.1	27.224	27.1	27.14	1895423.0

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

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