PREVIEW / stock_1hour / 2015-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-09.parquet
  size:    1.0 MB
  rows:    47,667
  symbols: 3,405

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-10-09 04:00:00	AAPL	Stock	27.35	27.35	27.35	27.35	1532.0
2015-10-09 05:00:00	AAPL	Stock	27.395	27.4475	27.395	27.425	6000.0
2015-10-09 06:00:00	AAPL	Stock	27.4175	27.46	27.4125	27.46	6100.0
2015-10-09 07:00:00	AAPL	Stock	27.4475	27.5175	27.425	27.47	94580.0
2015-10-09 08:00:00	AAPL	Stock	27.4675	27.5075	27.4375	27.485	465372.0
2015-10-09 09:00:00	AAPL	Stock	27.4825	27.635	27.3725	27.5825	28643928.0
2015-10-09 10:00:00	AAPL	Stock	27.5848	27.9862	27.565	27.9712	46600488.0
2015-10-09 11:00:00	AAPL	Stock	27.9662	27.995	27.8092	27.9175	23670216.0
2015-10-09 12:00:00	AAPL	Stock	27.9175	27.9225	27.8075	27.8828	13703556.0
2015-10-09 13:00:00	AAPL	Stock	27.8825	28.005	27.85	27.8725	24243928.0
2015-10-09 14:00:00	AAPL	Stock	27.8725	28.0175	27.8675	27.9875	18179492.0
2015-10-09 15:00:00	AAPL	Stock	27.985	28.07	27.9225	28.03	30743532.0
2015-10-09 16:00:00	AAPL	Stock	28.03	28.065	27.8	28.01	7618308.0
2015-10-09 17:00:00	AAPL	Stock	28.0125	28.0125	28.0025	28.005	57940.0
2015-10-09 18:00:00	AAPL	Stock	28.0	28.02	27.9925	27.9925	62732.0
2015-10-09 19:00:00	AAPL	Stock	28.0	28.0125	28.0	28.0	60876.0
2015-10-09 05:00:00	MSFT	Stock	47.49	47.49	47.49	47.49	100.0
2015-10-09 06:00:00	MSFT	Stock	47.49	47.49	47.49	47.49	700.0
2015-10-09 07:00:00	MSFT	Stock	47.37	47.5	47.37	47.5	1657.0
2015-10-09 08:00:00	MSFT	Stock	47.55	47.59	47.47	47.5	8744.0
2015-10-09 09:00:00	MSFT	Stock	47.52	47.54	47.021	47.03	3133035.0
2015-10-09 10:00:00	MSFT	Stock	47.03	47.455	47.025	47.34	2940735.0
2015-10-09 11:00:00	MSFT	Stock	47.34	47.34	46.97	47.1	2930775.0
2015-10-09 12:00:00	MSFT	Stock	47.092	47.195	46.99	47.14	1773209.0
2015-10-09 13:00:00	MSFT	Stock	47.14	47.18	46.92	47.06	1661924.0
2015-10-09 14:00:00	MSFT	Stock	47.07	47.29	47.05	47.29	2137345.0
2015-10-09 15:00:00	MSFT	Stock	47.295	47.39	47.1	47.11	7489899.0
2015-10-09 16:00:00	MSFT	Stock	47.11	47.11	47.02	47.02	5112171.0
2015-10-09 17:00:00	MSFT	Stock	47.02	47.02	46.92	46.97	7600.0
2015-10-09 18:00:00	MSFT	Stock	47.02	47.02	46.97	46.97	1200.0
2015-10-09 19:00:00	MSFT	Stock	47.0	47.0	46.94	46.94	1820.0
2015-10-09 07:00:00	NVDA	Stock	0.655	0.655	0.655	0.655	5000.0
2015-10-09 08:00:00	NVDA	Stock	0.6748	0.6748	0.655	0.655	43000.0
2015-10-09 09:00:00	NVDA	Stock	0.6528	0.6555	0.6482	0.6538	20669560.0
2015-10-09 10:00:00	NVDA	Stock	0.6538	0.6562	0.6498	0.6562	39215200.0
2015-10-09 11:00:00	NVDA	Stock	0.6561	0.657	0.6538	0.656	48312560.0
2015-10-09 12:00:00	NVDA	Stock	0.6558	0.6565	0.6548	0.6555	25442440.0
2015-10-09 13:00:00	NVDA	Stock	0.6555	0.656	0.6395	0.6455	120841160.0
2015-10-09 14:00:00	NVDA	Stock	0.6452	0.649	0.6452	0.647	22239720.0
2015-10-09 15:00:00	NVDA	Stock	0.6471	0.6518	0.6445	0.6518	118770880.0
2015-10-09 16:00:00	NVDA	Stock	0.6513	0.6528	0.6503	0.6503	1198840.0
2015-10-09 05:00:00	AMZN	Stock	26.6	26.6	26.6	26.6	6000.0
2015-10-09 06:00:00	AMZN	Stock	26.6315	26.6315	26.6315	26.6315	2000.0
2015-10-09 07:00:00	AMZN	Stock	26.6	26.6985	26.6	26.633	37780.0
2015-10-09 08:00:00	AMZN	Stock	26.649	26.722	26.625	26.675	169660.0
2015-10-09 09:00:00	AMZN	Stock	26.67	26.7605	26.5135	26.7388	9083340.0
2015-10-09 10:00:00	AMZN	Stock	26.7245	27.007	26.5652	26.96	12782100.0
2015-10-09 11:00:00	AMZN	Stock	26.9533	27.0895	26.8445	26.9588	8251700.0
2015-10-09 12:00:00	AMZN	Stock	26.9665	27.032	26.8515	26.9125	5200280.0
2015-10-09 13:00:00	AMZN	Stock	26.916	26.955	26.8205	26.8515	4502240.0

> showing 50 of 47,667 rows — these rows as CSV

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