PREVIEW / stock_30min / 2013-07-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-19.parquet
  size:    1.5 MB
  rows:    77,325
  symbols: 3,476

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-07-19 05:00:00	AAPL	Stock	15.3514	15.3514	15.3514	15.3514	11200.0
2013-07-19 05:30:00	AAPL	Stock	15.3568	15.3568	15.3568	15.3568	2800.0
2013-07-19 06:30:00	AAPL	Stock	15.3857	15.3961	15.3857	15.3961	5600.0
2013-07-19 07:00:00	AAPL	Stock	15.3839	15.4004	15.3839	15.4004	30100.0
2013-07-19 08:00:00	AAPL	Stock	15.4086	15.4561	15.3839	15.4286	338688.0
2013-07-19 08:30:00	AAPL	Stock	15.4425	15.4732	15.44	15.4643	446852.0
2013-07-19 09:00:00	AAPL	Stock	15.4536	15.5218	15.4446	15.4764	1843716.0
2013-07-19 09:30:00	AAPL	Stock	15.4679	15.4993	15.2839	15.3411	57933204.0
2013-07-19 10:00:00	AAPL	Stock	15.3414	15.3414	15.2357	15.2509	33711244.0
2013-07-19 10:30:00	AAPL	Stock	15.2454	15.3107	15.1979	15.2168	24224480.0
2013-07-19 11:00:00	AAPL	Stock	15.2171	15.2929	15.2143	15.2629	18918340.0
2013-07-19 11:30:00	AAPL	Stock	15.2626	15.2632	15.2186	15.2318	14991928.0
2013-07-19 12:00:00	AAPL	Stock	15.2336	15.2546	15.205	15.2357	10742060.0
2013-07-19 12:30:00	AAPL	Stock	15.2364	15.2434	15.2071	15.2321	9342928.0
2013-07-19 13:00:00	AAPL	Stock	15.2321	15.2564	15.2289	15.2443	7547120.0
2013-07-19 13:30:00	AAPL	Stock	15.2439	15.275	15.2364	15.2639	6225268.0
2013-07-19 14:00:00	AAPL	Stock	15.2639	15.2839	15.2475	15.2527	9430652.0
2013-07-19 14:30:00	AAPL	Stock	15.2529	15.2536	15.21	15.2196	8355872.0
2013-07-19 15:00:00	AAPL	Stock	15.2211	15.2279	15.1564	15.1564	17031084.0
2013-07-19 15:30:00	AAPL	Stock	15.1586	15.1921	15.1554	15.1771	33534732.0
2013-07-19 16:00:00	AAPL	Stock	15.1786	15.1818	15.1754	15.1786	9925692.0
2013-07-19 16:30:00	AAPL	Stock	15.1786	15.18	15.1782	15.18	380856.0
2013-07-19 17:00:00	AAPL	Stock	15.1786	15.1804	15.1768	15.1804	255164.0
2013-07-19 17:30:00	AAPL	Stock	15.1804	15.2107	15.1796	15.1939	138600.0
2013-07-19 18:00:00	AAPL	Stock	15.1993	15.1993	15.1911	15.1964	34496.0
2013-07-19 18:30:00	AAPL	Stock	15.19	15.19	15.1875	15.1893	23912.0
2013-07-19 19:00:00	AAPL	Stock	15.1946	15.1946	15.1875	15.1875	9940.0
2013-07-19 19:30:00	AAPL	Stock	15.1893	15.1893	15.1821	15.1875	11200.0
2013-07-19 04:00:00	MSFT	Stock	33.3	33.3	33.21	33.21	1358.0
2013-07-19 04:30:00	MSFT	Stock	33.21	33.21	33.21	33.21	200.0
2013-07-19 05:00:00	MSFT	Stock	33.18	33.18	33.18	33.18	351.0
2013-07-19 05:30:00	MSFT	Stock	33.16	33.16	33.11	33.16	2903.0
2013-07-19 06:30:00	MSFT	Stock	33.08	33.18	32.86	33.0	136988.0
2013-07-19 07:00:00	MSFT	Stock	33.1	33.2	32.96	33.01	457215.0
2013-07-19 07:30:00	MSFT	Stock	33.0	33.01	32.8	32.86	895000.0
2013-07-19 08:00:00	MSFT	Stock	33.02	33.1	32.75	32.78	2022695.0
2013-07-19 08:30:00	MSFT	Stock	32.76	32.85	32.51	32.55	4412891.0
2013-07-19 09:00:00	MSFT	Stock	32.55	32.65	32.37	32.4	3739198.0
2013-07-19 09:30:00	MSFT	Stock	32.4	32.41	31.91	32.36	51622317.0
2013-07-19 10:00:00	MSFT	Stock	32.36	32.67	32.14	32.2	25843066.0
2013-07-19 10:30:00	MSFT	Stock	32.2	32.22	31.97	31.995	17710205.0
2013-07-19 11:00:00	MSFT	Stock	31.995	32.065	31.71	31.83	16127865.0
2013-07-19 11:30:00	MSFT	Stock	31.835	31.91	31.36	31.58	19799955.0
2013-07-19 12:00:00	MSFT	Stock	31.59	31.69	31.48	31.6	10061901.0
2013-07-19 12:30:00	MSFT	Stock	31.6	31.66	31.4	31.62	8623451.0
2013-07-19 13:00:00	MSFT	Stock	31.62	31.625	31.15	31.179	10969854.0
2013-07-19 13:30:00	MSFT	Stock	31.175	31.36	31.1	31.29	9296506.0
2013-07-19 14:00:00	MSFT	Stock	31.288	31.35	31.15	31.205	7877984.0
2013-07-19 14:30:00	MSFT	Stock	31.205	31.21	31.02	31.11	11665128.0
2013-07-19 15:00:00	MSFT	Stock	31.12	31.37	31.1	31.35	15276815.0

> showing 50 of 77,325 rows — these rows as CSV

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