PREVIEW / stock_30min / 2010-08-16

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-16.parquet
  size:    1.3 MB
  rows:    74,065
  symbols: 3,482

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
2010-08-16 06:00:00	AAPL	Stock	8.8964	8.8964	8.8964	8.8964	2800.0
2010-08-16 06:30:00	AAPL	Stock	8.9107	8.9107	8.9107	8.9107	2800.0
2010-08-16 07:00:00	AAPL	Stock	8.9107	8.9107	8.8679	8.8821	19600.0
2010-08-16 07:30:00	AAPL	Stock	8.8711	8.8711	8.8486	8.8486	73136.0
2010-08-16 08:00:00	AAPL	Stock	8.8396	8.8629	8.8393	8.8564	298760.0
2010-08-16 08:30:00	AAPL	Stock	8.8464	8.8743	8.845	8.8643	607600.0
2010-08-16 09:00:00	AAPL	Stock	8.8639	8.8639	8.8254	8.8443	1258712.0
2010-08-16 09:30:00	AAPL	Stock	8.8439	8.9232	8.8214	8.8868	57910188.0
2010-08-16 10:00:00	AAPL	Stock	8.8864	8.905	8.8607	8.8893	35920276.0
2010-08-16 10:30:00	AAPL	Stock	8.8875	8.9196	8.875	8.9193	27734924.0
2010-08-16 11:00:00	AAPL	Stock	8.9193	8.9196	8.8792	8.8836	15807596.0
2010-08-16 11:30:00	AAPL	Stock	8.8846	8.9089	8.8836	8.9032	9054024.0
2010-08-16 12:00:00	AAPL	Stock	8.9032	8.9171	8.9	8.915	9861432.0
2010-08-16 12:30:00	AAPL	Stock	8.915	8.9289	8.8982	8.905	16946524.0
2010-08-16 13:00:00	AAPL	Stock	8.905	8.9101	8.8857	8.8889	9535708.0
2010-08-16 13:30:00	AAPL	Stock	8.89	8.8996	8.8757	8.8804	11184488.0
2010-08-16 14:00:00	AAPL	Stock	8.8804	8.8929	8.863	8.8743	14925652.0
2010-08-16 14:30:00	AAPL	Stock	8.874	8.8768	8.8354	8.8371	20413148.0
2010-08-16 15:00:00	AAPL	Stock	8.8371	8.8421	8.8079	8.8214	39641980.0
2010-08-16 15:30:00	AAPL	Stock	8.822	8.8564	8.8118	8.8454	37143932.0
2010-08-16 16:00:00	AAPL	Stock	8.8443	8.8702	8.8396	8.8571	8760696.0
2010-08-16 16:30:00	AAPL	Stock	8.8564	8.8571	8.8266	8.85	237384.0
2010-08-16 17:00:00	AAPL	Stock	8.9052	8.9052	8.8514	8.8557	92568.0
2010-08-16 17:30:00	AAPL	Stock	8.8554	8.8568	8.8536	8.8568	36456.0
2010-08-16 18:00:00	AAPL	Stock	8.8568	8.8629	8.8568	8.8629	151060.0
2010-08-16 18:30:00	AAPL	Stock	8.8575	8.8625	8.8443	8.8625	253064.0
2010-08-16 19:00:00	AAPL	Stock	8.8629	8.8629	8.8554	8.8554	51464.0
2010-08-16 19:30:00	AAPL	Stock	8.8554	8.8571	8.8496	8.85	252420.0
2010-08-16 07:30:00	MSFT	Stock	24.4	24.4	24.4	24.4	100.0
2010-08-16 08:00:00	MSFT	Stock	24.35	24.4	24.35	24.37	1000.0
2010-08-16 08:30:00	MSFT	Stock	24.42	24.47	24.42	24.45	4100.0
2010-08-16 09:00:00	MSFT	Stock	24.45	24.45	24.31	24.38	34489.0
2010-08-16 09:30:00	MSFT	Stock	24.36	24.53	24.3	24.38	4943300.0
2010-08-16 10:00:00	MSFT	Stock	24.37	24.54	24.37	24.5	3180659.0
2010-08-16 10:30:00	MSFT	Stock	24.5	24.55	24.42	24.46	2261538.0
2010-08-16 11:00:00	MSFT	Stock	24.46	24.49	24.38	24.46	2399271.0
2010-08-16 11:30:00	MSFT	Stock	24.46	24.56	24.45	24.55	1825635.0
2010-08-16 12:00:00	MSFT	Stock	24.55	24.58	24.52	24.58	1276375.0
2010-08-16 12:30:00	MSFT	Stock	24.58	24.61	24.54	24.57	1943806.0
2010-08-16 13:00:00	MSFT	Stock	24.565	24.61	24.55	24.6	1672500.0
2010-08-16 13:30:00	MSFT	Stock	24.6	24.61	24.56	24.57	1169620.0
2010-08-16 14:00:00	MSFT	Stock	24.57	24.6	24.5	24.538	1519353.0
2010-08-16 14:30:00	MSFT	Stock	24.53	24.54	24.46	24.48	3575289.0
2010-08-16 15:00:00	MSFT	Stock	24.48	24.51	24.43	24.5	2430251.0
2010-08-16 15:30:00	MSFT	Stock	24.5	24.58	24.48	24.5	3883076.0
2010-08-16 16:00:00	MSFT	Stock	24.5	24.584	24.44	24.55	8608800.0
2010-08-16 16:30:00	MSFT	Stock	24.55	24.57	24.504	24.504	14647.0
2010-08-16 17:00:00	MSFT	Stock	24.57	24.58	24.51	24.53	31374.0
2010-08-16 17:30:00	MSFT	Stock	24.53	24.53	24.52	24.53	3300.0
2010-08-16 18:00:00	MSFT	Stock	24.54	24.55	24.54	24.54	16080.0

> showing 50 of 74,065 rows — these rows as CSV

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