PREVIEW / stock_1hour / 2011-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-29.parquet
  size:    988 KB
  rows:    46,328
  symbols: 3,550

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
2011-06-29 04:00:00	AAPL	Stock	12.0	12.0161	12.0	12.0	8400.0
2011-06-29 06:00:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	5600.0
2011-06-29 07:00:00	AAPL	Stock	12.0357	12.0554	12.0354	12.0357	487452.0
2011-06-29 08:00:00	AAPL	Stock	12.0336	12.0571	12.0179	12.0546	1902488.0
2011-06-29 09:00:00	AAPL	Stock	12.0532	12.0714	11.8932	11.925	65580760.0
2011-06-29 10:00:00	AAPL	Stock	11.9271	12.0078	11.8854	12.0046	77834204.0
2011-06-29 11:00:00	AAPL	Stock	12.0079	12.0111	11.9193	11.9339	44753772.0
2011-06-29 12:00:00	AAPL	Stock	11.935	11.9543	11.9198	11.9329	19917884.0
2011-06-29 13:00:00	AAPL	Stock	11.93	11.9557	11.9154	11.9393	25983860.0
2011-06-29 14:00:00	AAPL	Stock	11.9407	11.9464	11.8529	11.8912	52629472.0
2011-06-29 15:00:00	AAPL	Stock	11.8929	11.9375	11.8786	11.93	50832320.0
2011-06-29 16:00:00	AAPL	Stock	11.93	11.9514	11.9095	11.935	7127988.0
2011-06-29 17:00:00	AAPL	Stock	11.9357	11.9486	11.9306	11.9393	163996.0
2011-06-29 18:00:00	AAPL	Stock	11.93	11.9354	11.93	11.9354	55636.0
2011-06-29 19:00:00	AAPL	Stock	11.9332	11.9336	11.9286	11.9321	143920.0
2011-06-29 06:00:00	MSFT	Stock	25.86	25.86	25.86	25.86	500.0
2011-06-29 07:00:00	MSFT	Stock	25.89	25.89	25.79	25.8	19712.0
2011-06-29 08:00:00	MSFT	Stock	25.83	25.84	25.7	25.8	120596.0
2011-06-29 09:00:00	MSFT	Stock	25.83	25.83	25.4	25.46	8116754.0
2011-06-29 10:00:00	MSFT	Stock	25.455	25.65	25.36	25.645	7866223.0
2011-06-29 11:00:00	MSFT	Stock	25.65	25.7	25.585	25.68	5312323.0
2011-06-29 12:00:00	MSFT	Stock	25.68	25.7	25.56	25.58	6117761.0
2011-06-29 13:00:00	MSFT	Stock	25.58	25.62	25.54	25.56	6264247.0
2011-06-29 14:00:00	MSFT	Stock	25.56	25.65	25.55	25.62	7759487.0
2011-06-29 15:00:00	MSFT	Stock	25.619	25.7	25.57	25.62	13761399.0
2011-06-29 16:00:00	MSFT	Stock	25.63	25.851	25.57	25.66	9774605.0
2011-06-29 17:00:00	MSFT	Stock	25.65	25.71	25.602	25.62	12202.0
2011-06-29 18:00:00	MSFT	Stock	25.62	25.62	25.62	25.62	10744.0
2011-06-29 19:00:00	MSFT	Stock	25.69	25.7	25.65	25.65	1000.0
2011-06-29 08:00:00	NVDA	Stock	0.391	0.391	0.391	0.391	120000.0
2011-06-29 09:00:00	NVDA	Stock	0.391	0.3933	0.3795	0.38	92881960.0
2011-06-29 10:00:00	NVDA	Stock	0.38	0.3845	0.3765	0.3842	140621160.0
2011-06-29 11:00:00	NVDA	Stock	0.3842	0.394	0.3825	0.3938	179830120.0
2011-06-29 12:00:00	NVDA	Stock	0.3938	0.3953	0.392	0.3948	150785160.0
2011-06-29 13:00:00	NVDA	Stock	0.3945	0.3975	0.3942	0.3961	82820840.0
2011-06-29 14:00:00	NVDA	Stock	0.396	0.3965	0.3933	0.3948	144149320.0
2011-06-29 15:00:00	NVDA	Stock	0.3948	0.3955	0.3925	0.3933	135038720.0
2011-06-29 16:00:00	NVDA	Stock	0.3935	0.3962	0.3898	0.395	21691200.0
2011-06-29 17:00:00	NVDA	Stock	0.3958	0.3958	0.394	0.3942	625680.0
2011-06-29 18:00:00	NVDA	Stock	0.396	0.3962	0.396	0.396	64000.0
2011-06-29 19:00:00	NVDA	Stock	0.3958	0.3958	0.3958	0.3958	20000.0
2011-06-29 07:00:00	AMZN	Stock	10.193	10.193	10.15	10.15	31400.0
2011-06-29 08:00:00	AMZN	Stock	10.1525	10.168	10.145	10.1515	181220.0
2011-06-29 09:00:00	AMZN	Stock	10.1505	10.1505	10.0515	10.1085	8250920.0
2011-06-29 10:00:00	AMZN	Stock	10.1098	10.2995	10.075	10.235	23267120.0
2011-06-29 11:00:00	AMZN	Stock	10.236	10.3125	10.192	10.2105	13147520.0
2011-06-29 12:00:00	AMZN	Stock	10.2115	10.24	10.192	10.1955	4523500.0
2011-06-29 13:00:00	AMZN	Stock	10.1965	10.255	10.188	10.2176	8867820.0
2011-06-29 14:00:00	AMZN	Stock	10.2215	10.242	10.1085	10.1745	13086980.0
2011-06-29 15:00:00	AMZN	Stock	10.175	10.244	10.144	10.2105	17333120.0

> showing 50 of 46,328 rows — these rows as CSV

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