PREVIEW / stock_30min / 2013-05-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-20.parquet
  size:    1.5 MB
  rows:    78,401
  symbols: 3,507

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-05-20 04:00:00	AAPL	Stock	15.4696	15.4696	15.4696	15.4696	2800.0
2013-05-20 05:30:00	AAPL	Stock	15.4857	15.4857	15.4857	15.4857	2800.0
2013-05-20 06:30:00	AAPL	Stock	15.51	15.5175	15.51	15.5154	8400.0
2013-05-20 07:00:00	AAPL	Stock	15.5154	15.5154	15.5021	15.5021	22680.0
2013-05-20 07:30:00	AAPL	Stock	15.4964	15.4964	15.4639	15.4639	48496.0
2013-05-20 08:00:00	AAPL	Stock	15.4643	15.5143	15.4286	15.4554	255612.0
2013-05-20 08:30:00	AAPL	Stock	15.4529	15.4643	15.4329	15.4464	250152.0
2013-05-20 09:00:00	AAPL	Stock	15.45	15.4571	15.4175	15.42	389844.0
2013-05-20 09:30:00	AAPL	Stock	15.4211	15.6896	15.3607	15.6767	64561980.0
2013-05-20 10:00:00	AAPL	Stock	15.6789	15.7936	15.6296	15.7911	49234444.0
2013-05-20 10:30:00	AAPL	Stock	15.7911	15.7942	15.7207	15.7682	29400840.0
2013-05-20 11:00:00	AAPL	Stock	15.7668	15.8921	15.7664	15.8336	41995240.0
2013-05-20 11:30:00	AAPL	Stock	15.8325	15.8661	15.7975	15.8468	23504152.0
2013-05-20 12:00:00	AAPL	Stock	15.8471	15.8471	15.7446	15.8073	22889860.0
2013-05-20 12:30:00	AAPL	Stock	15.8086	15.8121	15.7554	15.7986	13174224.0
2013-05-20 13:00:00	AAPL	Stock	15.7964	15.845	15.7321	15.7582	23137716.0
2013-05-20 13:30:00	AAPL	Stock	15.7575	15.8018	15.7393	15.7721	17342164.0
2013-05-20 14:00:00	AAPL	Stock	15.7721	15.8529	15.7454	15.8415	15843688.0
2013-05-20 14:30:00	AAPL	Stock	15.8414	15.8714	15.8061	15.8243	16019192.0
2013-05-20 15:00:00	AAPL	Stock	15.8236	15.8929	15.8146	15.8793	22415708.0
2013-05-20 15:30:00	AAPL	Stock	15.8782	15.9214	15.8054	15.8143	46532080.0
2013-05-20 16:00:00	AAPL	Stock	15.8125	15.8189	15.6739	15.8107	33457312.0
2013-05-20 16:30:00	AAPL	Stock	15.8107	15.8137	15.6672	15.8107	245868.0
2013-05-20 17:00:00	AAPL	Stock	15.8075	15.8075	15.4736	15.7364	1821540.0
2013-05-20 17:30:00	AAPL	Stock	15.7364	15.75	15.7064	15.7304	492128.0
2013-05-20 18:00:00	AAPL	Stock	15.7232	15.7279	15.7168	15.7211	152320.0
2013-05-20 18:30:00	AAPL	Stock	15.7171	15.7204	15.7086	15.7093	272328.0
2013-05-20 19:00:00	AAPL	Stock	15.7089	15.7139	15.7025	15.7118	141848.0
2013-05-20 19:30:00	AAPL	Stock	15.7057	15.7139	15.7007	15.7007	285320.0
2013-05-20 06:30:00	MSFT	Stock	34.9	34.9	34.9	34.9	250.0
2013-05-20 07:00:00	MSFT	Stock	34.89	34.89	34.85	34.85	335.0
2013-05-20 07:30:00	MSFT	Stock	34.81	34.81	34.79	34.79	2000.0
2013-05-20 08:00:00	MSFT	Stock	34.7	34.82	34.7	34.8	19980.0
2013-05-20 08:30:00	MSFT	Stock	34.8	34.8	34.67	34.68	21924.0
2013-05-20 09:00:00	MSFT	Stock	34.77	34.78	34.73	34.73	9912.0
2013-05-20 09:30:00	MSFT	Stock	34.73	34.87	34.68	34.742	5331130.0
2013-05-20 10:00:00	MSFT	Stock	34.74	34.98	34.74	34.895	4427180.0
2013-05-20 10:30:00	MSFT	Stock	34.893	34.95	34.82	34.89	2828365.0
2013-05-20 11:00:00	MSFT	Stock	34.89	34.94	34.87	34.94	2485438.0
2013-05-20 11:30:00	MSFT	Stock	34.93	34.97	34.91	34.963	2473743.0
2013-05-20 12:00:00	MSFT	Stock	34.97	34.97	34.93	34.94	1700460.0
2013-05-20 12:30:00	MSFT	Stock	34.945	34.97	34.89	34.905	2349276.0
2013-05-20 13:00:00	MSFT	Stock	34.905	34.92	34.82	34.86	2378693.0
2013-05-20 13:30:00	MSFT	Stock	34.85	34.91	34.83	34.89	2421461.0
2013-05-20 14:00:00	MSFT	Stock	34.899	34.92	34.87	34.9	2321636.0
2013-05-20 14:30:00	MSFT	Stock	34.9	35.03	34.9	35.03	4570337.0
2013-05-20 15:00:00	MSFT	Stock	35.03	35.055	34.94	34.95	2747714.0
2013-05-20 15:30:00	MSFT	Stock	34.955	35.095	34.87	35.09	9653283.0
2013-05-20 16:00:00	MSFT	Stock	35.09	35.14	34.919	35.06	3399919.0
2013-05-20 16:30:00	MSFT	Stock	34.96	35.09	34.96	35.07	33122.0

> showing 50 of 78,401 rows — these rows as CSV

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