PREVIEW / stock_1hour / 2016-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-29.parquet
  size:    1.0 MB
  rows:    48,449
  symbols: 3,184

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-11-29 04:00:00	AAPL	Stock	27.8825	27.8825	27.875	27.875	2000.0
2016-11-29 05:00:00	AAPL	Stock	27.9	27.9	27.85	27.9	8080.0
2016-11-29 06:00:00	AAPL	Stock	27.85	27.85	27.8125	27.8375	40952.0
2016-11-29 07:00:00	AAPL	Stock	27.825	27.8375	27.65	27.725	157084.0
2016-11-29 08:00:00	AAPL	Stock	27.745	27.8025	27.665	27.7125	319376.0
2016-11-29 09:00:00	AAPL	Stock	27.7125	27.7625	27.5525	27.575	20633032.0
2016-11-29 10:00:00	AAPL	Stock	27.5775	27.7525	27.5175	27.7	19870204.0
2016-11-29 11:00:00	AAPL	Stock	27.7	28.0075	27.6975	28.0038	16950152.0
2016-11-29 12:00:00	AAPL	Stock	28.0038	28.005	27.9025	27.9425	8260828.0
2016-11-29 13:00:00	AAPL	Stock	27.9435	27.985	27.92	27.9675	6127660.0
2016-11-29 14:00:00	AAPL	Stock	27.9675	27.9775	27.885	27.8875	6792492.0
2016-11-29 15:00:00	AAPL	Stock	27.8882	27.8925	27.735	27.865	18289500.0
2016-11-29 16:00:00	AAPL	Stock	27.875	27.875	27.8325	27.865	8310016.0
2016-11-29 17:00:00	AAPL	Stock	27.8675	27.875	27.86	27.8625	34000.0
2016-11-29 18:00:00	AAPL	Stock	27.87	27.8725	27.86	27.8675	14172.0
2016-11-29 19:00:00	AAPL	Stock	27.86	27.8675	27.85	27.865	6772.0
2016-11-29 04:00:00	MSFT	Stock	60.68	60.68	60.68	60.68	100.0
2016-11-29 08:00:00	MSFT	Stock	60.87	60.87	60.55	60.75	515.0
2016-11-29 09:00:00	MSFT	Stock	60.69	60.83	60.52	60.57	1493474.0
2016-11-29 10:00:00	MSFT	Stock	60.57	60.92	60.53	60.91	1533804.0
2016-11-29 11:00:00	MSFT	Stock	60.92	61.29	60.82	61.29	5425827.0
2016-11-29 12:00:00	MSFT	Stock	61.29	61.37	61.16	61.3	2192096.0
2016-11-29 13:00:00	MSFT	Stock	61.3	61.41	61.29	61.37	1309162.0
2016-11-29 14:00:00	MSFT	Stock	61.38	61.405	61.3	61.3	1931749.0
2016-11-29 15:00:00	MSFT	Stock	61.3	61.32	61.03	61.11	3916106.0
2016-11-29 16:00:00	MSFT	Stock	61.09	61.09	61.0	61.0	3270911.0
2016-11-29 17:00:00	MSFT	Stock	61.09	61.09	61.08	61.08	4200.0
2016-11-29 18:00:00	MSFT	Stock	61.08	61.09	61.08	61.09	475.0
2016-11-29 19:00:00	MSFT	Stock	61.08	61.08	61.08	61.08	100.0
2016-11-29 07:00:00	NVDA	Stock	2.366	2.3668	2.3572	2.3655	80000.0
2016-11-29 08:00:00	NVDA	Stock	2.3582	2.3622	2.3538	2.3538	156800.0
2016-11-29 09:00:00	NVDA	Stock	2.3538	2.3538	2.3132	2.3278	50711720.0
2016-11-29 10:00:00	NVDA	Stock	2.3278	2.357	2.3273	2.3508	61276640.0
2016-11-29 11:00:00	NVDA	Stock	2.351	2.3575	2.3482	2.3564	38785920.0
2016-11-29 12:00:00	NVDA	Stock	2.3562	2.361	2.343	2.3445	39341360.0
2016-11-29 13:00:00	NVDA	Stock	2.3445	2.3512	2.3362	2.3455	38113840.0
2016-11-29 14:00:00	NVDA	Stock	2.3455	2.3484	2.3402	2.341	24517040.0
2016-11-29 15:00:00	NVDA	Stock	2.341	2.345	2.33	2.3313	64743600.0
2016-11-29 16:00:00	NVDA	Stock	2.3313	2.3368	2.3313	2.3368	28097800.0
2016-11-29 17:00:00	NVDA	Stock	2.3362	2.3362	2.3325	2.3328	63600.0
2016-11-29 18:00:00	NVDA	Stock	2.3325	2.34	2.3325	2.34	323600.0
2016-11-29 19:00:00	NVDA	Stock	2.3402	2.3473	2.3375	2.3473	12800.0
2016-11-29 05:00:00	AMZN	Stock	38.4525	38.4525	38.4525	38.4525	2000.0
2016-11-29 07:00:00	AMZN	Stock	38.532	38.55	38.5	38.5	74780.0
2016-11-29 08:00:00	AMZN	Stock	38.5	38.55	38.441	38.55	211940.0
2016-11-29 09:00:00	AMZN	Stock	38.54	38.55	38.155	38.2705	9390860.0
2016-11-29 10:00:00	AMZN	Stock	38.271	38.422	38.2685	38.3945	6321180.0
2016-11-29 11:00:00	AMZN	Stock	38.394	38.4198	38.182	38.352	6372300.0
2016-11-29 12:00:00	AMZN	Stock	38.357	38.4075	38.3128	38.3745	4093480.0
2016-11-29 13:00:00	AMZN	Stock	38.3795	38.4005	38.317	38.3725	3741000.0

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

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