PREVIEW / stock_30min / 2014-06-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-06.parquet
  size:    1.6 MB
  rows:    81,899
  symbols: 3,540

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-06-06 04:00:00	AAPL	Stock	23.1714	23.1911	23.1629	23.1714	23520.0
2014-06-06 04:30:00	AAPL	Stock	23.1539	23.1793	23.1539	23.1786	43680.0
2014-06-06 05:00:00	AAPL	Stock	23.1746	23.1786	23.1643	23.1786	19600.0
2014-06-06 05:30:00	AAPL	Stock	23.1786	23.1786	23.1786	23.1786	2800.0
2014-06-06 06:00:00	AAPL	Stock	23.1896	23.1964	23.1721	23.1964	22988.0
2014-06-06 06:30:00	AAPL	Stock	23.185	23.185	23.1714	23.1714	37800.0
2014-06-06 07:00:00	AAPL	Stock	23.1779	23.1779	23.1371	23.1429	260036.0
2014-06-06 07:30:00	AAPL	Stock	23.1429	23.1643	23.1429	23.1611	277256.0
2014-06-06 08:00:00	AAPL	Stock	23.1554	23.1696	23.1089	23.1125	729372.0
2014-06-06 08:30:00	AAPL	Stock	23.1232	23.1743	23.1218	23.1707	987896.0
2014-06-06 09:00:00	AAPL	Stock	23.1711	23.2257	23.17	23.2218	1523984.0
2014-06-06 09:30:00	AAPL	Stock	23.2129	23.2318	23.0668	23.1379	46388720.0
2014-06-06 10:00:00	AAPL	Stock	23.1418	23.1443	23.0536	23.1393	19601064.0
2014-06-06 10:30:00	AAPL	Stock	23.1407	23.1586	23.1104	23.1225	14865032.0
2014-06-06 11:00:00	AAPL	Stock	23.1225	23.1507	23.1043	23.1471	11315752.0
2014-06-06 11:30:00	AAPL	Stock	23.1493	23.212	23.1471	23.2032	19822152.0
2014-06-06 12:00:00	AAPL	Stock	23.2043	23.2593	23.1971	23.2318	23438296.0
2014-06-06 12:30:00	AAPL	Stock	23.235	23.2439	23.1839	23.2046	11774448.0
2014-06-06 13:00:00	AAPL	Stock	23.2059	23.2071	23.0168	23.0879	27718964.0
2014-06-06 13:30:00	AAPL	Stock	23.0943	23.1139	23.0425	23.0607	14136640.0
2014-06-06 14:00:00	AAPL	Stock	23.0599	23.1729	23.0511	23.1421	14670180.0
2014-06-06 14:30:00	AAPL	Stock	23.1418	23.1829	23.1096	23.1575	13027924.0
2014-06-06 15:00:00	AAPL	Stock	23.1592	23.1607	23.1108	23.1357	13679596.0
2014-06-06 15:30:00	AAPL	Stock	23.1357	23.1404	23.0436	23.0561	39131456.0
2014-06-06 16:00:00	AAPL	Stock	23.0561	23.1554	23.0429	23.0432	15397452.0
2014-06-06 16:30:00	AAPL	Stock	23.0511	23.0639	23.0357	23.0639	356300.0
2014-06-06 17:00:00	AAPL	Stock	23.0625	23.0714	23.055	23.0657	261520.0
2014-06-06 17:30:00	AAPL	Stock	23.0625	23.0711	23.0571	23.0664	196504.0
2014-06-06 18:00:00	AAPL	Stock	23.0664	23.0714	23.0625	23.0714	78820.0
2014-06-06 18:30:00	AAPL	Stock	23.0714	23.0725	23.0643	23.0643	69244.0
2014-06-06 19:00:00	AAPL	Stock	23.0629	23.0629	23.0589	23.0607	52612.0
2014-06-06 19:30:00	AAPL	Stock	23.0696	23.0711	23.0536	23.0589	192920.0
2014-06-06 05:30:00	MSFT	Stock	41.24	41.24	41.24	41.24	300.0
2014-06-06 06:00:00	MSFT	Stock	41.2	41.2	41.2	41.2	500.0
2014-06-06 08:00:00	MSFT	Stock	41.2	41.25	41.2	41.25	1450.0
2014-06-06 08:30:00	MSFT	Stock	41.25	41.38	41.25	41.3	9741.0
2014-06-06 09:00:00	MSFT	Stock	41.29	41.59	41.28	41.48	105393.0
2014-06-06 09:30:00	MSFT	Stock	41.48	41.66	41.24	41.398	4295031.0
2014-06-06 10:00:00	MSFT	Stock	41.4	41.425	41.26	41.305	1736671.0
2014-06-06 10:30:00	MSFT	Stock	41.3	41.39	41.28	41.36	790732.0
2014-06-06 11:00:00	MSFT	Stock	41.36	41.43	41.3	41.405	1151033.0
2014-06-06 11:30:00	MSFT	Stock	41.4	41.46	41.36	41.376	930858.0
2014-06-06 12:00:00	MSFT	Stock	41.37	41.42	41.33	41.42	656931.0
2014-06-06 12:30:00	MSFT	Stock	41.42	41.48	41.41	41.44	690359.0
2014-06-06 13:00:00	MSFT	Stock	41.44	41.44	41.38	41.415	743097.0
2014-06-06 13:30:00	MSFT	Stock	41.415	41.45	41.31	41.45	845632.0
2014-06-06 14:00:00	MSFT	Stock	41.442	41.45	41.34	41.394	1159424.0
2014-06-06 14:30:00	MSFT	Stock	41.4	41.48	41.38	41.48	1064480.0
2014-06-06 15:00:00	MSFT	Stock	41.475	41.59	41.47	41.515	1418464.0
2014-06-06 15:30:00	MSFT	Stock	41.52	41.52	41.37	41.48	3846149.0

> showing 50 of 81,899 rows — these rows as CSV

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