PREVIEW / stock_30min / 2014-05-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-30.parquet
  size:    1.6 MB
  rows:    81,411
  symbols: 3,560

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-05-30 04:00:00	AAPL	Stock	22.7571	22.7679	22.7571	22.7679	13440.0
2014-05-30 04:30:00	AAPL	Stock	22.7682	22.7682	22.7682	22.7682	2800.0
2014-05-30 05:00:00	AAPL	Stock	22.7768	22.7768	22.7546	22.7546	8400.0
2014-05-30 05:30:00	AAPL	Stock	22.75	22.75	22.74	22.7457	47600.0
2014-05-30 06:00:00	AAPL	Stock	22.7411	22.7607	22.7411	22.7607	8400.0
2014-05-30 06:30:00	AAPL	Stock	22.7607	22.8196	22.7607	22.8054	519456.0
2014-05-30 07:00:00	AAPL	Stock	22.8	22.8379	22.7768	22.7768	458976.0
2014-05-30 07:30:00	AAPL	Stock	22.7796	22.7796	22.7214	22.7432	203140.0
2014-05-30 08:00:00	AAPL	Stock	22.75	22.8214	22.7218	22.7829	1118936.0
2014-05-30 08:30:00	AAPL	Stock	22.7789	22.7925	22.7429	22.7486	908684.0
2014-05-30 09:00:00	AAPL	Stock	22.7486	22.785	22.7486	22.785	1061116.0
2014-05-30 09:30:00	AAPL	Stock	22.785	22.8154	22.6875	22.7557	57534988.0
2014-05-30 10:00:00	AAPL	Stock	22.7557	22.8543	22.7443	22.8475	30310896.0
2014-05-30 10:30:00	AAPL	Stock	22.8464	22.9568	22.8414	22.9339	37302048.0
2014-05-30 11:00:00	AAPL	Stock	22.9357	23.0061	22.9268	22.9321	30610552.0
2014-05-30 11:30:00	AAPL	Stock	22.9336	22.9904	22.9293	22.9561	14727496.0
2014-05-30 12:00:00	AAPL	Stock	22.9593	22.9786	22.8779	22.8882	19158832.0
2014-05-30 12:30:00	AAPL	Stock	22.8858	22.8904	22.6217	22.6989	51120916.0
2014-05-30 13:00:00	AAPL	Stock	22.6964	22.7125	22.5204	22.6118	39267844.0
2014-05-30 13:30:00	AAPL	Stock	22.6118	22.6136	22.4607	22.5969	34145384.0
2014-05-30 14:00:00	AAPL	Stock	22.5994	22.6689	22.5255	22.6461	22894872.0
2014-05-30 14:30:00	AAPL	Stock	22.6461	22.6848	22.6011	22.6175	18242504.0
2014-05-30 15:00:00	AAPL	Stock	22.6184	22.6575	22.5446	22.5579	18319728.0
2014-05-30 15:30:00	AAPL	Stock	22.5596	22.6804	22.5539	22.6071	38988320.0
2014-05-30 16:00:00	AAPL	Stock	22.6068	22.8979	22.5814	22.5911	20206620.0
2014-05-30 16:30:00	AAPL	Stock	22.5882	22.9554	22.5879	22.59	1078532.0
2014-05-30 17:00:00	AAPL	Stock	22.5911	22.616	22.59	22.59	902048.0
2014-05-30 17:30:00	AAPL	Stock	22.5907	22.6064	22.5907	22.6061	123060.0
2014-05-30 18:00:00	AAPL	Stock	22.6004	22.6064	22.5982	22.5982	57456.0
2014-05-30 18:30:00	AAPL	Stock	22.6046	22.6154	22.6046	22.6125	93408.0
2014-05-30 19:00:00	AAPL	Stock	22.6146	22.6186	22.6107	22.6182	45416.0
2014-05-30 19:30:00	AAPL	Stock	22.6189	22.625	22.6161	22.625	65128.0
2014-05-30 07:00:00	MSFT	Stock	40.32	40.32	40.32	40.32	400.0
2014-05-30 07:30:00	MSFT	Stock	40.32	40.35	40.32	40.35	350.0
2014-05-30 08:00:00	MSFT	Stock	40.32	40.34	40.25	40.32	3600.0
2014-05-30 08:30:00	MSFT	Stock	40.29	40.32	40.29	40.32	12737.0
2014-05-30 09:00:00	MSFT	Stock	40.32	40.54	40.3	40.45	41371.0
2014-05-30 09:30:00	MSFT	Stock	40.45	40.49	40.25	40.45	3018587.0
2014-05-30 10:00:00	MSFT	Stock	40.45	40.69	40.43	40.673	2717248.0
2014-05-30 10:30:00	MSFT	Stock	40.67	40.94	40.67	40.74	4098992.0
2014-05-30 11:00:00	MSFT	Stock	40.74	40.78	40.63	40.63	1789848.0
2014-05-30 11:30:00	MSFT	Stock	40.62	40.81	40.6	40.67	1595714.0
2014-05-30 12:00:00	MSFT	Stock	40.665	40.8	40.655	40.68	1193769.0
2014-05-30 12:30:00	MSFT	Stock	40.68	40.76	40.63	40.71	1463847.0
2014-05-30 13:00:00	MSFT	Stock	40.71	40.777	40.675	40.762	861396.0
2014-05-30 13:30:00	MSFT	Stock	40.77	40.82	40.74	40.81	844138.0
2014-05-30 14:00:00	MSFT	Stock	40.805	40.88	40.73	40.83	1203894.0
2014-05-30 14:30:00	MSFT	Stock	40.824	40.85	40.79	40.8	1064401.0
2014-05-30 15:00:00	MSFT	Stock	40.805	40.84	40.78	40.84	1316344.0
2014-05-30 15:30:00	MSFT	Stock	40.835	40.97	40.82	40.93	6047406.0

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

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