PREVIEW / stock_1hour / 2011-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-14.parquet
  size:    935 KB
  rows:    43,921
  symbols: 3,518

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-07-14 04:00:00	AAPL	Stock	12.7857	12.7907	12.7857	12.7893	16520.0
2011-07-14 05:00:00	AAPL	Stock	12.7761	12.7761	12.7321	12.7321	14000.0
2011-07-14 06:00:00	AAPL	Stock	12.7707	12.8371	12.7707	12.8214	203700.0
2011-07-14 07:00:00	AAPL	Stock	12.8221	12.9093	12.8114	12.9	1826552.0
2011-07-14 08:00:00	AAPL	Stock	12.9054	12.9446	12.8857	12.9404	4713884.0
2011-07-14 09:00:00	AAPL	Stock	12.9364	12.9425	12.8286	12.8921	75221328.0
2011-07-14 10:00:00	AAPL	Stock	12.8929	12.91	12.8218	12.8225	68718076.0
2011-07-14 11:00:00	AAPL	Stock	12.8218	12.8439	12.8071	12.8268	42077616.0
2011-07-14 12:00:00	AAPL	Stock	12.8271	12.8275	12.7507	12.7679	45633924.0
2011-07-14 13:00:00	AAPL	Stock	12.7679	12.8286	12.7264	12.825	61039580.0
2011-07-14 14:00:00	AAPL	Stock	12.8259	12.8343	12.7789	12.7889	40198704.0
2011-07-14 15:00:00	AAPL	Stock	12.7889	12.8261	12.7446	12.7825	67142964.0
2011-07-14 16:00:00	AAPL	Stock	12.7807	12.8904	12.7686	12.8518	12654096.0
2011-07-14 17:00:00	AAPL	Stock	12.8536	12.8893	12.7775	12.8893	2268112.0
2011-07-14 18:00:00	AAPL	Stock	12.8911	12.9018	12.7775	12.8911	719880.0
2011-07-14 19:00:00	AAPL	Stock	12.8893	12.8982	12.8718	12.875	500640.0
2011-07-14 06:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	500.0
2011-07-14 07:00:00	MSFT	Stock	26.61	26.68	26.56	26.58	3600.0
2011-07-14 08:00:00	MSFT	Stock	26.68	26.69	26.59	26.69	19978.0
2011-07-14 09:00:00	MSFT	Stock	26.69	27.0	26.57	26.99	7078391.0
2011-07-14 10:00:00	MSFT	Stock	26.99	27.01	26.61	26.64	11443428.0
2011-07-14 11:00:00	MSFT	Stock	26.64	26.72	26.59	26.665	4133045.0
2011-07-14 12:00:00	MSFT	Stock	26.67	26.67	26.49	26.5	3620588.0
2011-07-14 13:00:00	MSFT	Stock	26.5	26.57	26.36	26.57	6532255.0
2011-07-14 14:00:00	MSFT	Stock	26.57	26.6	26.43	26.461	4052733.0
2011-07-14 15:00:00	MSFT	Stock	26.465	26.57	26.38	26.47	7570872.0
2011-07-14 16:00:00	MSFT	Stock	26.48	26.71	26.467	26.56	1371359.0
2011-07-14 17:00:00	MSFT	Stock	26.658	26.658	26.47	26.57	39175.0
2011-07-14 18:00:00	MSFT	Stock	26.57	26.59	26.47	26.59	14545.0
2011-07-14 19:00:00	MSFT	Stock	26.59	26.6	26.55	26.55	3427.0
2011-07-14 09:00:00	NVDA	Stock	0.368	0.3703	0.364	0.3692	128085120.0
2011-07-14 10:00:00	NVDA	Stock	0.3695	0.3695	0.3635	0.3635	142110280.0
2011-07-14 11:00:00	NVDA	Stock	0.3635	0.3645	0.3582	0.359	118752840.0
2011-07-14 12:00:00	NVDA	Stock	0.3589	0.3595	0.3542	0.3548	111535160.0
2011-07-14 13:00:00	NVDA	Stock	0.3548	0.3572	0.3502	0.3534	242415280.0
2011-07-14 14:00:00	NVDA	Stock	0.3535	0.3558	0.3518	0.3526	115342600.0
2011-07-14 15:00:00	NVDA	Stock	0.3528	0.353	0.3508	0.3518	208521640.0
2011-07-14 16:00:00	NVDA	Stock	0.3515	0.3578	0.3515	0.3548	6852960.0
2011-07-14 17:00:00	NVDA	Stock	0.3519	0.3538	0.3519	0.3538	115040.0
2011-07-14 18:00:00	NVDA	Stock	0.3538	0.3548	0.3538	0.354	44000.0
2011-07-14 19:00:00	NVDA	Stock	0.354	0.3548	0.3538	0.3548	102000.0
2011-07-14 05:00:00	AMZN	Stock	10.6685	10.6685	10.6685	10.6685	2000.0
2011-07-14 07:00:00	AMZN	Stock	10.654	10.654	10.6535	10.6535	4000.0
2011-07-14 08:00:00	AMZN	Stock	10.7025	10.705	10.6655	10.705	54600.0
2011-07-14 09:00:00	AMZN	Stock	10.705	10.724	10.625	10.6975	9419200.0
2011-07-14 10:00:00	AMZN	Stock	10.698	10.7955	10.6435	10.6435	18226860.0
2011-07-14 11:00:00	AMZN	Stock	10.647	10.6805	10.614	10.6555	6997860.0
2011-07-14 12:00:00	AMZN	Stock	10.6555	10.6555	10.532	10.534	9594140.0
2011-07-14 13:00:00	AMZN	Stock	10.534	10.585	10.4715	10.5605	10028680.0
2011-07-14 14:00:00	AMZN	Stock	10.563	10.6005	10.5085	10.5225	6286380.0

> showing 50 of 43,921 rows — these rows as CSV

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