PREVIEW / stock_1hour / 2016-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-03.parquet
  size:    1.0 MB
  rows:    48,279
  symbols: 3,302

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-03 04:00:00	AAPL	Stock	23.455	23.455	23.275	23.395	37484.0
2016-05-03 05:00:00	AAPL	Stock	23.35	23.35	23.2825	23.2825	11972.0
2016-05-03 06:00:00	AAPL	Stock	23.2775	23.295	23.27	23.28	17120.0
2016-05-03 07:00:00	AAPL	Stock	23.3	23.41	23.2875	23.4025	399692.0
2016-05-03 08:00:00	AAPL	Stock	23.3875	23.515	23.275	23.5	1518016.0
2016-05-03 09:00:00	AAPL	Stock	23.4975	23.6225	23.4375	23.5	36400696.0
2016-05-03 10:00:00	AAPL	Stock	23.5	23.57	23.42	23.4972	33737592.0
2016-05-03 11:00:00	AAPL	Stock	23.4975	23.72	23.4625	23.655	29199504.0
2016-05-03 12:00:00	AAPL	Stock	23.657	23.77	23.5925	23.765	23578972.0
2016-05-03 13:00:00	AAPL	Stock	23.765	23.935	23.74	23.8375	28408208.0
2016-05-03 14:00:00	AAPL	Stock	23.84	23.8625	23.7725	23.82	18204072.0
2016-05-03 15:00:00	AAPL	Stock	23.8225	23.8925	23.775	23.795	31429196.0
2016-05-03 16:00:00	AAPL	Stock	23.795	23.815	23.41	23.7825	8875368.0
2016-05-03 17:00:00	AAPL	Stock	23.7825	23.7875	23.75	23.785	138452.0
2016-05-03 18:00:00	AAPL	Stock	23.78	23.795	23.7675	23.7875	37668.0
2016-05-03 19:00:00	AAPL	Stock	23.7775	23.7925	23.775	23.79	62492.0
2016-05-03 06:00:00	MSFT	Stock	50.37	50.37	50.37	50.37	500.0
2016-05-03 07:00:00	MSFT	Stock	50.25	50.28	50.16	50.2	1802.0
2016-05-03 08:00:00	MSFT	Stock	50.29	50.34	50.16	50.34	24525.0
2016-05-03 09:00:00	MSFT	Stock	50.34	50.41	49.87	50.05	2806685.0
2016-05-03 10:00:00	MSFT	Stock	50.044	50.09	49.72	49.93	4014998.0
2016-05-03 11:00:00	MSFT	Stock	49.93	50.025	49.71	49.77	2787587.0
2016-05-03 12:00:00	MSFT	Stock	49.76	49.96	49.64	49.91	2478062.0
2016-05-03 13:00:00	MSFT	Stock	49.91	50.05	49.83	49.96	2521774.0
2016-05-03 14:00:00	MSFT	Stock	49.96	50.005	49.72	49.815	2691784.0
2016-05-03 15:00:00	MSFT	Stock	49.82	49.87	49.6	49.78	5240488.0
2016-05-03 16:00:00	MSFT	Stock	49.77	49.78	49.62	49.76	2164501.0
2016-05-03 17:00:00	MSFT	Stock	49.75	49.75	49.74	49.74	4251.0
2016-05-03 18:00:00	MSFT	Stock	49.78	49.78	49.78	49.78	550.0
2016-05-03 19:00:00	MSFT	Stock	49.78	49.82	49.78	49.82	1136.0
2016-05-03 08:00:00	NVDA	Stock	0.8975	0.8975	0.8835	0.8835	15000.0
2016-05-03 09:00:00	NVDA	Stock	0.8888	0.8935	0.883	0.885	32226800.0
2016-05-03 10:00:00	NVDA	Stock	0.885	0.8873	0.8815	0.8859	27667840.0
2016-05-03 11:00:00	NVDA	Stock	0.886	0.8905	0.885	0.887	27481720.0
2016-05-03 12:00:00	NVDA	Stock	0.8873	0.8894	0.885	0.8889	20669800.0
2016-05-03 13:00:00	NVDA	Stock	0.8889	0.8924	0.8884	0.8911	18478440.0
2016-05-03 14:00:00	NVDA	Stock	0.891	0.8915	0.8873	0.8898	23905000.0
2016-05-03 15:00:00	NVDA	Stock	0.89	0.8905	0.8863	0.8893	38202760.0
2016-05-03 16:00:00	NVDA	Stock	0.8893	0.9	0.8884	0.8905	6824720.0
2016-05-03 06:00:00	AMZN	Stock	34.0	34.0	33.94	33.94	10000.0
2016-05-03 07:00:00	AMZN	Stock	33.851	33.964	33.851	33.945	73940.0
2016-05-03 08:00:00	AMZN	Stock	33.96	34.0	33.9325	33.9875	240480.0
2016-05-03 09:00:00	AMZN	Stock	33.99	34.02	33.6415	33.7375	19533560.0
2016-05-03 10:00:00	AMZN	Stock	33.7375	33.8145	33.616	33.7264	16127640.0
2016-05-03 11:00:00	AMZN	Stock	33.725	33.9165	33.6865	33.7715	11479040.0
2016-05-03 12:00:00	AMZN	Stock	33.766	33.9538	33.745	33.9538	5001640.0
2016-05-03 13:00:00	AMZN	Stock	33.9478	33.9495	33.775	33.779	5199900.0
2016-05-03 14:00:00	AMZN	Stock	33.789	33.796	33.6195	33.6815	8354760.0
2016-05-03 15:00:00	AMZN	Stock	33.6845	33.725	33.5215	33.566	14622400.0
2016-05-03 16:00:00	AMZN	Stock	33.566	33.8867	33.55	33.5525	2403180.0

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

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