PREVIEW / stock_1hour / 2014-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-01.parquet
  size:    1.0 MB
  rows:    48,813
  symbols: 3,576

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-07-01 04:00:00	AAPL	Stock	23.345	23.345	23.275	23.2925	10408.0
2014-07-01 05:00:00	AAPL	Stock	23.3	23.3	23.3	23.3	632.0
2014-07-01 06:00:00	AAPL	Stock	23.3225	23.3625	23.3225	23.335	17460.0
2014-07-01 07:00:00	AAPL	Stock	23.335	23.35	23.325	23.3275	70088.0
2014-07-01 08:00:00	AAPL	Stock	23.3275	23.3825	23.2325	23.38	638480.0
2014-07-01 09:00:00	AAPL	Stock	23.38	23.445	23.2825	23.3875	25309540.0
2014-07-01 10:00:00	AAPL	Stock	23.3925	23.49	23.3625	23.4525	26147184.0
2014-07-01 11:00:00	AAPL	Stock	23.455	23.4875	23.3925	23.47	18140960.0
2014-07-01 12:00:00	AAPL	Stock	23.47	23.5	23.45	23.48	12093784.0
2014-07-01 13:00:00	AAPL	Stock	23.4788	23.5175	23.4525	23.465	15865176.0
2014-07-01 14:00:00	AAPL	Stock	23.467	23.4725	23.41	23.4325	14273196.0
2014-07-01 15:00:00	AAPL	Stock	23.4325	23.45	23.3775	23.38	21757956.0
2014-07-01 16:00:00	AAPL	Stock	23.38	23.435	23.1978	23.375	7511576.0
2014-07-01 17:00:00	AAPL	Stock	23.4455	23.4455	23.355	23.38	117416.0
2014-07-01 18:00:00	AAPL	Stock	23.3825	23.3875	23.37	23.375	70052.0
2014-07-01 19:00:00	AAPL	Stock	23.385	23.3975	23.37	23.395	115556.0
2014-07-01 08:00:00	MSFT	Stock	41.7	42.0	41.7	41.9	4424.0
2014-07-01 09:00:00	MSFT	Stock	41.89	42.07	41.69	41.91	5128760.0
2014-07-01 10:00:00	MSFT	Stock	41.92	42.09	41.9	42.09	3502409.0
2014-07-01 11:00:00	MSFT	Stock	42.09	42.15	42.025	42.05	2043890.0
2014-07-01 12:00:00	MSFT	Stock	42.05	42.09	41.97	42.04	1739521.0
2014-07-01 13:00:00	MSFT	Stock	42.04	42.09	42.0	42.02	2080686.0
2014-07-01 14:00:00	MSFT	Stock	42.02	42.05	41.88	41.89	2091596.0
2014-07-01 15:00:00	MSFT	Stock	41.895	41.92	41.81	41.86	6805450.0
2014-07-01 16:00:00	MSFT	Stock	41.87	41.942	41.638	41.79	2380249.0
2014-07-01 17:00:00	MSFT	Stock	41.926	41.926	41.77	41.77	1459.0
2014-07-01 18:00:00	MSFT	Stock	41.78	41.82	41.78	41.82	2377.0
2014-07-01 19:00:00	MSFT	Stock	41.81	41.85	41.81	41.85	1955.0
2014-07-01 09:00:00	NVDA	Stock	0.463	0.465	0.4615	0.463	27589240.0
2014-07-01 10:00:00	NVDA	Stock	0.463	0.4675	0.4628	0.467	46204520.0
2014-07-01 11:00:00	NVDA	Stock	0.4673	0.469	0.4668	0.4688	58047640.0
2014-07-01 12:00:00	NVDA	Stock	0.4688	0.4713	0.4686	0.4705	27823000.0
2014-07-01 13:00:00	NVDA	Stock	0.4705	0.4714	0.4701	0.4708	38036520.0
2014-07-01 14:00:00	NVDA	Stock	0.4708	0.4711	0.469	0.4695	46706400.0
2014-07-01 15:00:00	NVDA	Stock	0.4695	0.47	0.4675	0.4685	49621840.0
2014-07-01 16:00:00	NVDA	Stock	0.4688	0.469	0.4678	0.4678	10804160.0
2014-07-01 19:00:00	NVDA	Stock	0.4685	0.4685	0.4685	0.4685	6000.0
2014-07-01 08:00:00	AMZN	Stock	16.25	16.295	16.25	16.289	22120.0
2014-07-01 09:00:00	AMZN	Stock	16.2875	16.465	16.255	16.421	9753500.0
2014-07-01 10:00:00	AMZN	Stock	16.4165	16.55	16.413	16.5289	9849420.0
2014-07-01 11:00:00	AMZN	Stock	16.5265	16.5625	16.486	16.5225	5572720.0
2014-07-01 12:00:00	AMZN	Stock	16.5205	16.616	16.497	16.6045	5914260.0
2014-07-01 13:00:00	AMZN	Stock	16.601	16.6205	16.5395	16.5558	4861620.0
2014-07-01 14:00:00	AMZN	Stock	16.5595	16.6435	16.5595	16.6394	5677760.0
2014-07-01 15:00:00	AMZN	Stock	16.635	16.66	16.5875	16.6205	12020500.0
2014-07-01 16:00:00	AMZN	Stock	16.6195	16.624	16.5285	16.6115	525380.0
2014-07-01 18:00:00	AMZN	Stock	16.6125	16.6195	16.6125	16.6125	70400.0
2014-07-01 19:00:00	AMZN	Stock	16.655	16.655	16.6115	16.6115	16220.0
2014-07-01 08:00:00	GOOGL	Stock	29.2225	29.2925	29.2225	29.2925	13940.0
2014-07-01 09:00:00	GOOGL	Stock	29.2335	29.4125	29.2335	29.4115	3872200.0

> showing 50 of 48,813 rows — these rows as CSV

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