PREVIEW / stock_30min / 2012-08-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-07.parquet
  size:    1.4 MB
  rows:    76,810
  symbols: 3,496

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-08-07 04:00:00	AAPL	Stock	22.3029	22.3246	22.3029	22.3246	8400.0
2012-08-07 04:30:00	AAPL	Stock	22.3214	22.3214	22.3125	22.3125	21784.0
2012-08-07 05:00:00	AAPL	Stock	22.3071	22.3071	22.3	22.3	10416.0
2012-08-07 06:00:00	AAPL	Stock	22.2857	22.2857	22.2857	22.2857	9800.0
2012-08-07 06:30:00	AAPL	Stock	22.2946	22.2946	22.2946	22.2946	5600.0
2012-08-07 07:00:00	AAPL	Stock	22.2786	22.3125	22.2786	22.2875	267512.0
2012-08-07 07:30:00	AAPL	Stock	22.2875	22.3089	22.2625	22.2639	218652.0
2012-08-07 08:00:00	AAPL	Stock	22.2786	22.3125	22.2718	22.3064	1239000.0
2012-08-07 08:30:00	AAPL	Stock	22.3021	22.3214	22.2957	22.2996	1137220.0
2012-08-07 09:00:00	AAPL	Stock	22.2961	22.3079	22.2257	22.2429	1708728.0
2012-08-07 09:30:00	AAPL	Stock	22.2296	22.3214	22.0729	22.1913	67427388.0
2012-08-07 10:00:00	AAPL	Stock	22.1914	22.2768	22.1811	22.22	36630776.0
2012-08-07 10:30:00	AAPL	Stock	22.2193	22.2236	22.1304	22.1657	19018216.0
2012-08-07 11:00:00	AAPL	Stock	22.1661	22.2018	22.125	22.1911	13710116.0
2012-08-07 11:30:00	AAPL	Stock	22.1932	22.2746	22.1814	22.2611	19756632.0
2012-08-07 12:00:00	AAPL	Stock	22.2607	22.2982	22.2464	22.2854	15311240.0
2012-08-07 12:30:00	AAPL	Stock	22.2843	22.3125	22.2411	22.25	16585968.0
2012-08-07 13:00:00	AAPL	Stock	22.2472	22.2661	22.2204	22.2529	10157308.0
2012-08-07 13:30:00	AAPL	Stock	22.2498	22.2536	22.2032	22.2089	8301104.0
2012-08-07 14:00:00	AAPL	Stock	22.2111	22.2357	22.1882	22.1929	8031744.0
2012-08-07 14:30:00	AAPL	Stock	22.1907	22.23	22.1907	22.2104	6486900.0
2012-08-07 15:00:00	AAPL	Stock	22.2089	22.2157	22.1671	22.1746	14537768.0
2012-08-07 15:30:00	AAPL	Stock	22.1746	22.1899	22.1325	22.1775	31601220.0
2012-08-07 16:00:00	AAPL	Stock	22.1825	22.1907	22.1679	22.1786	6041560.0
2012-08-07 16:30:00	AAPL	Stock	22.1686	22.1825	22.1668	22.1668	273084.0
2012-08-07 17:00:00	AAPL	Stock	22.1757	22.1764	22.1607	22.1611	74368.0
2012-08-07 17:30:00	AAPL	Stock	22.1607	22.1643	22.1543	22.1571	141512.0
2012-08-07 18:00:00	AAPL	Stock	22.1571	22.1714	22.1571	22.1643	46200.0
2012-08-07 18:30:00	AAPL	Stock	22.1714	22.1714	22.1714	22.1714	2800.0
2012-08-07 19:00:00	AAPL	Stock	22.1707	22.1707	22.1693	22.1693	11200.0
2012-08-07 19:30:00	AAPL	Stock	22.1679	22.1679	22.1607	22.1607	57064.0
2012-08-07 05:30:00	MSFT	Stock	30.0	30.0	30.0	30.0	160.0
2012-08-07 07:30:00	MSFT	Stock	29.89	29.89	29.89	29.89	1000.0
2012-08-07 08:00:00	MSFT	Stock	29.98	30.05	29.98	30.0	3500.0
2012-08-07 08:30:00	MSFT	Stock	30.01	30.04	29.95	30.04	53350.0
2012-08-07 09:00:00	MSFT	Stock	30.04	30.08	30.0	30.08	17200.0
2012-08-07 09:30:00	MSFT	Stock	30.07	30.15	29.87	30.02	3550676.0
2012-08-07 10:00:00	MSFT	Stock	30.02	30.265	30.01	30.24	2752386.0
2012-08-07 10:30:00	MSFT	Stock	30.241	30.26	30.21	30.22	1753315.0
2012-08-07 11:00:00	MSFT	Stock	30.228	30.25	30.18	30.23	1707412.0
2012-08-07 11:30:00	MSFT	Stock	30.23	30.325	30.23	30.31	1934005.0
2012-08-07 12:00:00	MSFT	Stock	30.3	30.31	30.26	30.28	1720016.0
2012-08-07 12:30:00	MSFT	Stock	30.29	30.34	30.28	30.319	1309570.0
2012-08-07 13:00:00	MSFT	Stock	30.31	30.33	30.26	30.32	1228768.0
2012-08-07 13:30:00	MSFT	Stock	30.32	30.34	30.29	30.32	1453011.0
2012-08-07 14:00:00	MSFT	Stock	30.32	30.32	30.28	30.295	972988.0
2012-08-07 14:30:00	MSFT	Stock	30.294	30.35	30.29	30.32	1175385.0
2012-08-07 15:00:00	MSFT	Stock	30.32	30.33	30.282	30.305	2057962.0
2012-08-07 15:30:00	MSFT	Stock	30.29	30.31	30.2	30.25	4248047.0
2012-08-07 16:00:00	MSFT	Stock	30.26	30.316	30.2	30.26	1746058.0

> showing 50 of 76,810 rows — these rows as CSV

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