PREVIEW / stock_1hour / 2016-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-16.parquet
  size:    1.0 MB
  rows:    48,208
  symbols: 3,304

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
2016-05-16 05:00:00	AAPL	Stock	22.6725	22.6725	22.6725	22.6725	2600.0
2016-05-16 06:00:00	AAPL	Stock	22.6625	22.6625	22.655	22.655	3600.0
2016-05-16 07:00:00	AAPL	Stock	22.655	23.28	22.64	23.055	2627032.0
2016-05-16 08:00:00	AAPL	Stock	23.0425	23.125	22.65	23.0175	2613644.0
2016-05-16 09:00:00	AAPL	Stock	23.0175	23.2375	22.9125	23.175	42532524.0
2016-05-16 10:00:00	AAPL	Stock	23.1772	23.4375	23.165	23.3925	44628728.0
2016-05-16 11:00:00	AAPL	Stock	23.395	23.4675	23.285	23.4375	27251880.0
2016-05-16 12:00:00	AAPL	Stock	23.4375	23.475	23.355	23.41	17428816.0
2016-05-16 13:00:00	AAPL	Stock	23.41	23.5	23.39	23.4925	17068336.0
2016-05-16 14:00:00	AAPL	Stock	23.495	23.58	23.4825	23.5238	25104604.0
2016-05-16 15:00:00	AAPL	Stock	23.525	23.5975	23.46	23.4675	31814880.0
2016-05-16 16:00:00	AAPL	Stock	23.47	23.5665	23.3815	23.475	15465308.0
2016-05-16 17:00:00	AAPL	Stock	23.48	23.4825	23.47	23.48	91764.0
2016-05-16 18:00:00	AAPL	Stock	23.4875	23.495	23.47	23.485	78784.0
2016-05-16 19:00:00	AAPL	Stock	23.485	23.4975	23.4775	23.4875	61100.0
2016-05-16 08:00:00	MSFT	Stock	51.15	51.15	51.03	51.03	4029.0
2016-05-16 09:00:00	MSFT	Stock	51.09	51.26	50.75	51.19	1900795.0
2016-05-16 10:00:00	MSFT	Stock	51.2	51.36	51.0	51.34	1857127.0
2016-05-16 11:00:00	MSFT	Stock	51.34	51.62	51.34	51.572	1926282.0
2016-05-16 12:00:00	MSFT	Stock	51.58	51.62	51.5	51.59	1185322.0
2016-05-16 13:00:00	MSFT	Stock	51.6	51.76	51.565	51.685	1511666.0
2016-05-16 14:00:00	MSFT	Stock	51.69	51.95	51.69	51.89	2087879.0
2016-05-16 15:00:00	MSFT	Stock	51.9	51.96	51.8	51.83	4050621.0
2016-05-16 16:00:00	MSFT	Stock	51.83	51.83	51.176	51.83	3902341.0
2016-05-16 17:00:00	MSFT	Stock	51.83	51.87	51.82	51.82	2100.0
2016-05-16 18:00:00	MSFT	Stock	51.82	51.82	51.82	51.82	5000.0
2016-05-16 19:00:00	MSFT	Stock	51.83	51.83	51.83	51.83	1000.0
2016-05-16 07:00:00	NVDA	Stock	1.0252	1.0252	1.0248	1.025	18000.0
2016-05-16 08:00:00	NVDA	Stock	1.0228	1.025	1.0172	1.02	905160.0
2016-05-16 09:00:00	NVDA	Stock	1.02	1.034	1.0135	1.0338	97097840.0
2016-05-16 10:00:00	NVDA	Stock	1.0338	1.0515	1.0319	1.0505	234472680.0
2016-05-16 11:00:00	NVDA	Stock	1.0504	1.062	1.0478	1.0558	101462680.0
2016-05-16 12:00:00	NVDA	Stock	1.056	1.0632	1.0555	1.0568	84840880.0
2016-05-16 13:00:00	NVDA	Stock	1.057	1.0632	1.0563	1.0604	59962480.0
2016-05-16 14:00:00	NVDA	Stock	1.0602	1.0698	1.0598	1.0672	156074320.0
2016-05-16 15:00:00	NVDA	Stock	1.067	1.07	1.0528	1.0548	206998400.0
2016-05-16 16:00:00	NVDA	Stock	1.0548	1.057	1.0521	1.0538	5034520.0
2016-05-16 17:00:00	NVDA	Stock	1.0563	1.0563	1.056	1.056	242480.0
2016-05-16 18:00:00	NVDA	Stock	1.0558	1.0582	1.0558	1.0575	150440.0
2016-05-16 19:00:00	NVDA	Stock	1.0575	1.0588	1.057	1.0588	256000.0
2016-05-16 04:00:00	AMZN	Stock	35.5	35.5	35.5	35.5	4000.0
2016-05-16 06:00:00	AMZN	Stock	35.55	35.55	35.5	35.5	12100.0
2016-05-16 07:00:00	AMZN	Stock	35.6	35.75	35.599	35.7305	82760.0
2016-05-16 08:00:00	AMZN	Stock	35.7305	35.775	35.556	35.645	376120.0
2016-05-16 09:00:00	AMZN	Stock	35.6375	35.6605	35.1585	35.295	18616420.0
2016-05-16 10:00:00	AMZN	Stock	35.295	35.3	35.014	35.052	26083460.0
2016-05-16 11:00:00	AMZN	Stock	35.064	35.3625	35.0576	35.323	18246420.0
2016-05-16 12:00:00	AMZN	Stock	35.313	35.4885	35.2735	35.4745	9777560.0
2016-05-16 13:00:00	AMZN	Stock	35.475	35.5545	35.433	35.449	7751360.0
2016-05-16 14:00:00	AMZN	Stock	35.45	35.6625	35.4465	35.6185	9899000.0

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

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