PREVIEW / stock_1hour / 2015-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-13.parquet
  size:    1.1 MB
  rows:    49,428
  symbols: 3,498

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
2015-07-13 04:00:00	AAPL	Stock	31.25	31.25	30.825	31.125	54792.0
2015-07-13 05:00:00	AAPL	Stock	31.1475	31.25	31.125	31.2	96844.0
2015-07-13 06:00:00	AAPL	Stock	31.2475	31.2475	31.1925	31.22	105036.0
2015-07-13 07:00:00	AAPL	Stock	31.225	31.2625	31.1925	31.2	323560.0
2015-07-13 08:00:00	AAPL	Stock	31.215	31.2575	31.1425	31.2325	1272128.0
2015-07-13 09:00:00	AAPL	Stock	31.2325	31.265	31.08	31.135	29431648.0
2015-07-13 10:00:00	AAPL	Stock	31.135	31.1975	31.115	31.14	18254900.0
2015-07-13 11:00:00	AAPL	Stock	31.14	31.31	31.135	31.3	17858160.0
2015-07-13 12:00:00	AAPL	Stock	31.295	31.3725	31.2925	31.325	12265832.0
2015-07-13 13:00:00	AAPL	Stock	31.325	31.4092	31.3202	31.3688	9938276.0
2015-07-13 14:00:00	AAPL	Stock	31.3688	31.4275	31.3575	31.4025	10624608.0
2015-07-13 15:00:00	AAPL	Stock	31.405	31.4388	31.3875	31.4125	19705256.0
2015-07-13 16:00:00	AAPL	Stock	31.41	31.45	31.1608	31.4	20046184.0
2015-07-13 17:00:00	AAPL	Stock	31.3875	31.43	31.3	31.4275	125912.0
2015-07-13 18:00:00	AAPL	Stock	31.42	31.4375	31.4075	31.4125	49836.0
2015-07-13 19:00:00	AAPL	Stock	31.415	31.4675	31.4125	31.4675	116732.0
2015-07-13 04:00:00	MSFT	Stock	44.61	44.61	44.61	44.61	175.0
2015-07-13 06:00:00	MSFT	Stock	44.94	44.94	44.94	44.94	100.0
2015-07-13 07:00:00	MSFT	Stock	44.88	44.93	44.88	44.93	250.0
2015-07-13 08:00:00	MSFT	Stock	44.86	44.86	44.85	44.85	950.0
2015-07-13 09:00:00	MSFT	Stock	44.85	45.53	44.8	45.49	3984808.0
2015-07-13 10:00:00	MSFT	Stock	45.49	45.61	45.38	45.51	4386784.0
2015-07-13 11:00:00	MSFT	Stock	45.505	45.55	45.36	45.55	2624496.0
2015-07-13 12:00:00	MSFT	Stock	45.54	45.56	45.43	45.475	2089486.0
2015-07-13 13:00:00	MSFT	Stock	45.48	45.56	45.43	45.496	1993762.0
2015-07-13 14:00:00	MSFT	Stock	45.495	45.59	45.46	45.57	2485428.0
2015-07-13 15:00:00	MSFT	Stock	45.58	45.62	45.51	45.53	4768295.0
2015-07-13 16:00:00	MSFT	Stock	45.54	45.59	45.52	45.59	1816624.0
2015-07-13 17:00:00	MSFT	Stock	45.59	45.59	45.537	45.54	182196.0
2015-07-13 18:00:00	MSFT	Stock	45.59	45.6	45.59	45.6	750.0
2015-07-13 19:00:00	MSFT	Stock	45.6	45.61	45.6	45.61	487.0
2015-07-13 09:00:00	NVDA	Stock	0.4985	0.4998	0.4936	0.4968	24982520.0
2015-07-13 10:00:00	NVDA	Stock	0.497	0.4985	0.4942	0.4942	20582640.0
2015-07-13 11:00:00	NVDA	Stock	0.4942	0.4965	0.4942	0.4952	20997360.0
2015-07-13 12:00:00	NVDA	Stock	0.4952	0.496	0.4948	0.4959	19902400.0
2015-07-13 13:00:00	NVDA	Stock	0.496	0.496	0.495	0.4958	9711920.0
2015-07-13 14:00:00	NVDA	Stock	0.496	0.4965	0.495	0.4965	16853280.0
2015-07-13 15:00:00	NVDA	Stock	0.4965	0.4975	0.496	0.497	72818320.0
2015-07-13 16:00:00	NVDA	Stock	0.4968	0.497	0.4965	0.497	2140600.0
2015-07-13 05:00:00	AMZN	Stock	22.34	22.4	22.34	22.4	10920.0
2015-07-13 06:00:00	AMZN	Stock	22.3525	22.3525	22.3525	22.3525	4000.0
2015-07-13 07:00:00	AMZN	Stock	22.3515	22.3515	22.308	22.3385	13460.0
2015-07-13 08:00:00	AMZN	Stock	22.311	22.374	22.275	22.32	71720.0
2015-07-13 09:00:00	AMZN	Stock	22.3675	22.8935	22.35	22.865	17375980.0
2015-07-13 10:00:00	AMZN	Stock	22.8645	22.875	22.65	22.727	14848960.0
2015-07-13 11:00:00	AMZN	Stock	22.7095	22.7325	22.6235	22.7082	6486300.0
2015-07-13 12:00:00	AMZN	Stock	22.6995	22.765	22.6645	22.727	3604500.0
2015-07-13 13:00:00	AMZN	Stock	22.722	22.8335	22.7155	22.783	5806500.0
2015-07-13 14:00:00	AMZN	Stock	22.7775	22.8235	22.7295	22.7915	5290740.0
2015-07-13 15:00:00	AMZN	Stock	22.787	22.825	22.7648	22.778	14613240.0

> showing 50 of 49,428 rows — these rows as CSV

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