PREVIEW / stock_1hour / 2016-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-07.parquet
  size:    1.1 MB
  rows:    49,499
  symbols: 3,264

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-09-07 04:00:00	AAPL	Stock	26.9875	26.995	26.9875	26.995	3200.0
2016-09-07 05:00:00	AAPL	Stock	26.995	27.0525	26.995	27.0475	6400.0
2016-09-07 06:00:00	AAPL	Stock	27.0325	27.07	27.02	27.0675	49200.0
2016-09-07 07:00:00	AAPL	Stock	27.0675	27.0675	26.975	26.9775	157580.0
2016-09-07 08:00:00	AAPL	Stock	27.0625	27.0625	26.95	26.97	330380.0
2016-09-07 09:00:00	AAPL	Stock	26.97	27.0	26.8725	26.8825	14255648.0
2016-09-07 10:00:00	AAPL	Stock	26.885	26.953	26.8275	26.831	15033340.0
2016-09-07 11:00:00	AAPL	Stock	26.8302	26.89	26.82	26.8385	10869676.0
2016-09-07 12:00:00	AAPL	Stock	26.84	26.855	26.7675	26.8525	12179540.0
2016-09-07 13:00:00	AAPL	Stock	26.8512	26.94	26.8062	26.8898	22640148.0
2016-09-07 14:00:00	AAPL	Stock	26.8898	26.91	26.78	26.8075	19136760.0
2016-09-07 15:00:00	AAPL	Stock	26.8052	27.19	26.805	27.0925	56964336.0
2016-09-07 16:00:00	AAPL	Stock	27.09	27.1025	26.8505	27.095	5569704.0
2016-09-07 17:00:00	AAPL	Stock	27.0875	27.1025	27.085	27.0875	189172.0
2016-09-07 18:00:00	AAPL	Stock	27.0875	27.09	27.075	27.0775	82484.0
2016-09-07 19:00:00	AAPL	Stock	27.075	27.075	27.0375	27.0375	141012.0
2016-09-07 05:00:00	MSFT	Stock	57.63	57.65	57.63	57.65	250.0
2016-09-07 07:00:00	MSFT	Stock	57.62	57.62	57.62	57.62	500.0
2016-09-07 08:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	410.0
2016-09-07 09:00:00	MSFT	Stock	57.62	57.65	57.405	57.585	1828379.0
2016-09-07 10:00:00	MSFT	Stock	57.58	57.84	57.53	57.62	3101755.0
2016-09-07 11:00:00	MSFT	Stock	57.62	57.678	57.53	57.57	1538268.0
2016-09-07 12:00:00	MSFT	Stock	57.57	57.62	57.5	57.575	1383218.0
2016-09-07 13:00:00	MSFT	Stock	57.58	57.64	57.56	57.586	1170297.0
2016-09-07 14:00:00	MSFT	Stock	57.58	57.65	57.55	57.57	1439413.0
2016-09-07 15:00:00	MSFT	Stock	57.56	57.65	57.505	57.65	4197748.0
2016-09-07 16:00:00	MSFT	Stock	57.66	57.66	57.58	57.66	1797103.0
2016-09-07 17:00:00	MSFT	Stock	57.64	57.64	57.58	57.58	2200.0
2016-09-07 19:00:00	MSFT	Stock	57.62	57.62	57.59	57.59	500.0
2016-09-07 07:00:00	NVDA	Stock	1.5775	1.5775	1.5775	1.5775	5000.0
2016-09-07 08:00:00	NVDA	Stock	1.57	1.5762	1.57	1.5743	64000.0
2016-09-07 09:00:00	NVDA	Stock	1.5743	1.5807	1.5663	1.5672	38636600.0
2016-09-07 10:00:00	NVDA	Stock	1.5675	1.5695	1.5533	1.5565	45095600.0
2016-09-07 11:00:00	NVDA	Stock	1.5564	1.5575	1.5538	1.556	27036920.0
2016-09-07 12:00:00	NVDA	Stock	1.556	1.5561	1.5458	1.5488	43176040.0
2016-09-07 13:00:00	NVDA	Stock	1.5489	1.5523	1.548	1.549	21873720.0
2016-09-07 14:00:00	NVDA	Stock	1.5491	1.5555	1.5485	1.5548	54969760.0
2016-09-07 15:00:00	NVDA	Stock	1.555	1.5575	1.5538	1.555	60188600.0
2016-09-07 16:00:00	NVDA	Stock	1.5548	1.5548	1.5538	1.5538	1339760.0
2016-09-07 18:00:00	NVDA	Stock	1.5538	1.5575	1.5525	1.5563	225000.0
2016-09-07 19:00:00	NVDA	Stock	1.5563	1.5583	1.5552	1.5583	69880.0
2016-09-07 04:00:00	AMZN	Stock	39.48	39.48	39.48	39.48	2000.0
2016-09-07 05:00:00	AMZN	Stock	39.545	39.55	39.545	39.55	41700.0
2016-09-07 07:00:00	AMZN	Stock	39.5	39.5005	39.4965	39.4965	52580.0
2016-09-07 08:00:00	AMZN	Stock	39.55	39.55	39.37	39.4445	189780.0
2016-09-07 09:00:00	AMZN	Stock	39.472	39.5395	39.326	39.3785	9500320.0
2016-09-07 10:00:00	AMZN	Stock	39.387	39.456	39.2775	39.2798	8145280.0
2016-09-07 11:00:00	AMZN	Stock	39.2725	39.34	39.224	39.332	6570460.0
2016-09-07 12:00:00	AMZN	Stock	39.3281	39.359	39.2335	39.267	2643900.0
2016-09-07 13:00:00	AMZN	Stock	39.2645	39.3145	39.2461	39.291	2572780.0

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

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