PREVIEW / stock_30min / 2013-12-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-13.parquet
  size:    1.6 MB
  rows:    81,247
  symbols: 3,530

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-12-13 05:00:00	AAPL	Stock	20.0946	20.0946	20.0586	20.0586	5600.0
2013-12-13 05:30:00	AAPL	Stock	20.0536	20.0611	20.02	20.0611	8400.0
2013-12-13 06:00:00	AAPL	Stock	20.0625	20.075	20.0518	20.0518	12600.0
2013-12-13 06:30:00	AAPL	Stock	20.0696	20.1418	20.0696	20.1418	75600.0
2013-12-13 07:00:00	AAPL	Stock	20.1371	20.1661	20.1082	20.1518	307944.0
2013-12-13 07:30:00	AAPL	Stock	20.1636	20.1821	20.1429	20.1429	493668.0
2013-12-13 08:00:00	AAPL	Stock	20.1429	20.1643	20.0193	20.1179	646520.0
2013-12-13 08:30:00	AAPL	Stock	20.1207	20.125	20.0804	20.1036	822976.0
2013-12-13 09:00:00	AAPL	Stock	20.0929	20.1157	20.0818	20.0839	1671432.0
2013-12-13 09:30:00	AAPL	Stock	20.0843	20.1029	19.8357	19.8398	53991924.0
2013-12-13 10:00:00	AAPL	Stock	19.837	19.9104	19.7796	19.8625	42181188.0
2013-12-13 10:30:00	AAPL	Stock	19.8611	19.8934	19.8257	19.8329	19315156.0
2013-12-13 11:00:00	AAPL	Stock	19.8329	19.8629	19.8018	19.8414	15827728.0
2013-12-13 11:30:00	AAPL	Stock	19.8411	19.8568	19.7886	19.8214	17290140.0
2013-12-13 12:00:00	AAPL	Stock	19.8243	19.8489	19.8064	19.8304	12475596.0
2013-12-13 12:30:00	AAPL	Stock	19.8279	19.8371	19.8054	19.8282	9012556.0
2013-12-13 13:00:00	AAPL	Stock	19.8311	19.8582	19.8275	19.8575	7315476.0
2013-12-13 13:30:00	AAPL	Stock	19.8571	19.8571	19.8173	19.8214	9133320.0
2013-12-13 14:00:00	AAPL	Stock	19.8214	19.8407	19.8018	19.8127	11464264.0
2013-12-13 14:30:00	AAPL	Stock	19.8134	19.8289	19.8039	19.8214	9185596.0
2013-12-13 15:00:00	AAPL	Stock	19.8221	19.8332	19.7982	19.8036	12165776.0
2013-12-13 15:30:00	AAPL	Stock	19.8036	19.8136	19.7739	19.8032	31237164.0
2013-12-13 16:00:00	AAPL	Stock	19.8036	19.8762	19.79	19.7964	20215272.0
2013-12-13 16:30:00	AAPL	Stock	19.8011	19.8233	19.8004	19.8093	297444.0
2013-12-13 17:00:00	AAPL	Stock	19.8121	19.8213	19.8075	19.8168	78204.0
2013-12-13 17:30:00	AAPL	Stock	19.8143	19.8204	19.8011	19.8204	137536.0
2013-12-13 18:00:00	AAPL	Stock	19.8189	19.8246	19.8189	19.8232	88480.0
2013-12-13 18:30:00	AAPL	Stock	19.8232	19.825	19.8189	19.8196	263116.0
2013-12-13 19:00:00	AAPL	Stock	19.8193	19.825	19.8189	19.825	101248.0
2013-12-13 19:30:00	AAPL	Stock	19.83	19.8321	19.8168	19.825	132048.0
2013-12-13 06:30:00	MSFT	Stock	37.24	37.24	37.24	37.24	100.0
2013-12-13 07:00:00	MSFT	Stock	37.5	37.5	37.29	37.29	3500.0
2013-12-13 07:30:00	MSFT	Stock	37.33	37.45	37.33	37.45	4600.0
2013-12-13 08:00:00	MSFT	Stock	37.38	37.48	37.25	37.3	266168.0
2013-12-13 08:30:00	MSFT	Stock	37.29	37.32	37.23	37.32	13900.0
2013-12-13 09:00:00	MSFT	Stock	37.32	37.65	37.27	37.44	241968.0
2013-12-13 09:30:00	MSFT	Stock	37.42	37.45	36.75	36.84	6096490.0
2013-12-13 10:00:00	MSFT	Stock	36.84	36.95	36.76	36.77	2809257.0
2013-12-13 10:30:00	MSFT	Stock	36.774	36.9	36.769	36.87	1898298.0
2013-12-13 11:00:00	MSFT	Stock	36.87	36.98	36.84	36.92	1777756.0
2013-12-13 11:30:00	MSFT	Stock	36.92	36.925	36.795	36.83	1628117.0
2013-12-13 12:00:00	MSFT	Stock	36.83	36.86	36.76	36.794	1451399.0
2013-12-13 12:30:00	MSFT	Stock	36.8	36.81	36.65	36.785	1786255.0
2013-12-13 13:00:00	MSFT	Stock	36.785	36.86	36.78	36.815	1247723.0
2013-12-13 13:30:00	MSFT	Stock	36.82	36.84	36.76	36.77	1264963.0
2013-12-13 14:00:00	MSFT	Stock	36.77	36.78	36.62	36.635	3211621.0
2013-12-13 14:30:00	MSFT	Stock	36.63	36.74	36.63	36.74	1738563.0
2013-12-13 15:00:00	MSFT	Stock	36.735	36.83	36.72	36.82	2058727.0
2013-12-13 15:30:00	MSFT	Stock	36.82	36.825	36.64	36.69	5556115.0
2013-12-13 16:00:00	MSFT	Stock	36.69	36.85	36.689	36.8	2291781.0

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

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