PREVIEW / stock_30min / 2014-03-31

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-31.parquet
  size:    1.6 MB
  rows:    85,284
  symbols: 3,565

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
2014-03-31 04:30:00	AAPL	Stock	19.2586	19.2857	19.2586	19.2857	14000.0
2014-03-31 05:00:00	AAPL	Stock	19.2807	19.2857	19.2807	19.2857	5600.0
2014-03-31 07:00:00	AAPL	Stock	19.2875	19.2875	19.255	19.2714	55132.0
2014-03-31 07:30:00	AAPL	Stock	19.2811	19.2982	19.2768	19.2836	187544.0
2014-03-31 08:00:00	AAPL	Stock	19.2839	19.2893	19.2386	19.24	279468.0
2014-03-31 08:30:00	AAPL	Stock	19.2379	19.2857	19.2379	19.2857	524916.0
2014-03-31 09:00:00	AAPL	Stock	19.2857	19.3214	19.25	19.2704	814688.0
2014-03-31 09:30:00	AAPL	Stock	19.2711	19.3146	19.2	19.2604	25805528.0
2014-03-31 10:00:00	AAPL	Stock	19.2621	19.2804	19.2057	19.2221	12315100.0
2014-03-31 10:30:00	AAPL	Stock	19.2261	19.2439	19.2082	19.2189	6626144.0
2014-03-31 11:00:00	AAPL	Stock	19.2157	19.2232	19.1568	19.1649	9887864.0
2014-03-31 11:30:00	AAPL	Stock	19.1696	19.1868	19.1454	19.1821	7247716.0
2014-03-31 12:00:00	AAPL	Stock	19.1843	19.2346	19.1824	19.2125	6560596.0
2014-03-31 12:30:00	AAPL	Stock	19.2093	19.2175	19.1607	19.1764	4524828.0
2014-03-31 13:00:00	AAPL	Stock	19.1764	19.1786	19.1607	19.1644	3483480.0
2014-03-31 13:30:00	AAPL	Stock	19.1643	19.1708	19.1404	19.1486	6083588.0
2014-03-31 14:00:00	AAPL	Stock	19.1518	19.1854	19.1454	19.1661	3794056.0
2014-03-31 14:30:00	AAPL	Stock	19.1668	19.2168	19.1665	19.1936	8037064.0
2014-03-31 15:00:00	AAPL	Stock	19.1946	19.2296	19.1904	19.2221	6287540.0
2014-03-31 15:30:00	AAPL	Stock	19.2243	19.2321	19.1468	19.1689	19612964.0
2014-03-31 16:00:00	AAPL	Stock	19.1693	19.2064	19.1607	19.1852	16496452.0
2014-03-31 16:30:00	AAPL	Stock	19.1689	19.2109	19.1643	19.1714	231364.0
2014-03-31 17:00:00	AAPL	Stock	19.1786	19.1804	19.1696	19.1804	84644.0
2014-03-31 17:30:00	AAPL	Stock	19.1693	19.1821	19.1693	19.1775	25312.0
2014-03-31 18:00:00	AAPL	Stock	19.1754	19.1821	19.1718	19.1821	32200.0
2014-03-31 18:30:00	AAPL	Stock	19.175	19.175	19.1693	19.1743	1065092.0
2014-03-31 19:00:00	AAPL	Stock	19.1782	19.1786	19.1732	19.1786	37520.0
2014-03-31 19:30:00	AAPL	Stock	19.1779	19.1779	19.1107	19.1107	242760.0
2014-03-31 05:00:00	MSFT	Stock	40.62	40.62	40.62	40.62	100.0
2014-03-31 07:00:00	MSFT	Stock	40.56	40.56	40.41	40.41	500.0
2014-03-31 07:30:00	MSFT	Stock	40.44	40.5	40.38	40.38	5270.0
2014-03-31 08:00:00	MSFT	Stock	40.4	40.49	40.4	40.48	5111.0
2014-03-31 08:30:00	MSFT	Stock	40.48	40.59	40.48	40.59	6815.0
2014-03-31 09:00:00	MSFT	Stock	40.59	40.59	40.3	40.42	30103.0
2014-03-31 09:30:00	MSFT	Stock	40.41	41.22	40.4	41.21	5975257.0
2014-03-31 10:00:00	MSFT	Stock	41.2	41.34	41.01	41.08	4147157.0
2014-03-31 10:30:00	MSFT	Stock	41.08	41.24	41.05	41.19	2665461.0
2014-03-31 11:00:00	MSFT	Stock	41.18	41.185	41.05	41.14	1897245.0
2014-03-31 11:30:00	MSFT	Stock	41.14	41.47	41.13	41.345	4214711.0
2014-03-31 12:00:00	MSFT	Stock	41.345	41.369	41.24	41.27	1586661.0
2014-03-31 12:30:00	MSFT	Stock	41.278	41.37	41.27	41.361	1791601.0
2014-03-31 13:00:00	MSFT	Stock	41.365	41.49	41.31	41.487	2344379.0
2014-03-31 13:30:00	MSFT	Stock	41.485	41.5	41.33	41.37	2085165.0
2014-03-31 14:00:00	MSFT	Stock	41.36	41.42	41.33	41.39	1690989.0
2014-03-31 14:30:00	MSFT	Stock	41.395	41.47	41.37	41.38	1731039.0
2014-03-31 15:00:00	MSFT	Stock	41.38	41.4	41.25	41.32	2556391.0
2014-03-31 15:30:00	MSFT	Stock	41.32	41.33	40.96	41.0	8145771.0
2014-03-31 16:00:00	MSFT	Stock	41.005	41.45	40.95	40.988	4600090.0
2014-03-31 16:30:00	MSFT	Stock	40.998	41.298	40.998	41.0	16313.0
2014-03-31 17:00:00	MSFT	Stock	41.0	41.09	41.0	41.02	18723.0

> showing 50 of 85,284 rows — these rows as CSV

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