PREVIEW / stock_1hour / 2012-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-14.parquet
  size:    951 KB
  rows:    45,023
  symbols: 3,533

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
2012-03-14 04:00:00	AAPL	Stock	20.3371	20.4607	20.3371	20.4325	187852.0
2012-03-14 05:00:00	AAPL	Stock	20.4604	20.5357	20.4604	20.4821	388836.0
2012-03-14 06:00:00	AAPL	Stock	20.4821	20.5536	20.4821	20.5432	449064.0
2012-03-14 07:00:00	AAPL	Stock	20.5464	20.5675	20.4436	20.4629	3228036.0
2012-03-14 08:00:00	AAPL	Stock	20.4643	20.6332	20.45	20.62	12424776.0
2012-03-14 09:00:00	AAPL	Stock	20.6204	20.8518	20.5743	20.7589	209867896.0
2012-03-14 10:00:00	AAPL	Stock	20.7593	20.8561	20.7046	20.7964	154733628.0
2012-03-14 11:00:00	AAPL	Stock	20.7964	20.8296	20.6996	20.81	117261004.0
2012-03-14 12:00:00	AAPL	Stock	20.8107	20.9532	20.7629	20.935	102476696.0
2012-03-14 13:00:00	AAPL	Stock	20.9382	21.24	20.8439	20.8925	302601348.0
2012-03-14 14:00:00	AAPL	Stock	20.8896	20.9574	20.55	20.8864	253709932.0
2012-03-14 15:00:00	AAPL	Stock	20.8882	21.0889	20.7968	21.0564	209384084.0
2012-03-14 16:00:00	AAPL	Stock	21.0547	21.1418	20.6582	21.0914	22561028.0
2012-03-14 17:00:00	AAPL	Stock	21.0925	21.0989	21.0396	21.0536	1608936.0
2012-03-14 18:00:00	AAPL	Stock	21.0536	21.0982	21.0486	21.0939	999488.0
2012-03-14 19:00:00	AAPL	Stock	21.0914	21.1679	21.09	21.1661	2289476.0
2012-03-14 07:00:00	MSFT	Stock	32.61	32.61	32.6	32.6	1186.0
2012-03-14 08:00:00	MSFT	Stock	32.59	32.67	32.57	32.57	17209.0
2012-03-14 09:00:00	MSFT	Stock	32.62	32.64	32.49	32.58	4496697.0
2012-03-14 10:00:00	MSFT	Stock	32.57	32.88	32.55	32.8	6796266.0
2012-03-14 11:00:00	MSFT	Stock	32.8	32.84	32.71	32.808	5075214.0
2012-03-14 12:00:00	MSFT	Stock	32.807	32.85	32.75	32.75	3940976.0
2012-03-14 13:00:00	MSFT	Stock	32.753	32.8	32.62	32.68	4647426.0
2012-03-14 14:00:00	MSFT	Stock	32.687	32.74	32.6	32.73	4541769.0
2012-03-14 15:00:00	MSFT	Stock	32.72	32.79	32.67	32.775	6391017.0
2012-03-14 16:00:00	MSFT	Stock	32.78	32.79	32.55	32.73	5645368.0
2012-03-14 17:00:00	MSFT	Stock	32.77	32.77	32.6	32.71	7398.0
2012-03-14 18:00:00	MSFT	Stock	32.7	32.7	32.7	32.7	200.0
2012-03-14 19:00:00	MSFT	Stock	32.7	32.7	32.7	32.7	860.0
2012-03-14 08:00:00	NVDA	Stock	0.37	0.371	0.37	0.371	116000.0
2012-03-14 09:00:00	NVDA	Stock	0.3708	0.3708	0.3668	0.367	98422040.0
2012-03-14 10:00:00	NVDA	Stock	0.3672	0.3675	0.3638	0.365	91246280.0
2012-03-14 11:00:00	NVDA	Stock	0.3652	0.3652	0.3636	0.3638	78667760.0
2012-03-14 12:00:00	NVDA	Stock	0.364	0.365	0.3632	0.3632	68185920.0
2012-03-14 13:00:00	NVDA	Stock	0.3632	0.364	0.36	0.3614	92071960.0
2012-03-14 14:00:00	NVDA	Stock	0.3615	0.3619	0.3582	0.3595	116837840.0
2012-03-14 15:00:00	NVDA	Stock	0.3595	0.3598	0.358	0.359	150358720.0
2012-03-14 16:00:00	NVDA	Stock	0.359	0.3698	0.358	0.358	34729800.0
2012-03-14 17:00:00	NVDA	Stock	0.359	0.359	0.3582	0.3582	401440.0
2012-03-14 18:00:00	NVDA	Stock	0.3582	0.3608	0.3582	0.3608	180000.0
2012-03-14 19:00:00	NVDA	Stock	0.3602	0.3602	0.3602	0.3602	12000.0
2012-03-14 05:00:00	AMZN	Stock	9.2095	9.2095	9.2095	9.2095	2000.0
2012-03-14 07:00:00	AMZN	Stock	9.2065	9.2345	9.2065	9.2345	4000.0
2012-03-14 08:00:00	AMZN	Stock	9.2035	9.2035	9.175	9.175	84540.0
2012-03-14 09:00:00	AMZN	Stock	9.1938	9.216	9.115	9.1855	13542840.0
2012-03-14 10:00:00	AMZN	Stock	9.1855	9.209	9.133	9.1508	12078400.0
2012-03-14 11:00:00	AMZN	Stock	9.1498	9.152	9.08	9.1025	8289540.0
2012-03-14 12:00:00	AMZN	Stock	9.1025	9.127	9.082	9.1155	6956360.0
2012-03-14 13:00:00	AMZN	Stock	9.1146	9.132	9.0905	9.0995	7576140.0
2012-03-14 14:00:00	AMZN	Stock	9.0945	9.116	9.06	9.0795	7871640.0

> showing 50 of 45,023 rows — these rows as CSV

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