PREVIEW / stock_1hour / 2016-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-22.parquet
  size:    1.0 MB
  rows:    48,407
  symbols: 3,257

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-08-22 04:00:00	AAPL	Stock	27.25	27.25	27.25	27.25	408.0
2016-08-22 05:00:00	AAPL	Stock	27.4125	27.4125	27.4125	27.4125	400.0
2016-08-22 06:00:00	AAPL	Stock	27.3875	27.3875	27.31	27.31	7300.0
2016-08-22 07:00:00	AAPL	Stock	27.3125	27.3475	27.2975	27.3475	17688.0
2016-08-22 08:00:00	AAPL	Stock	27.3375	27.35	27.2675	27.2725	130108.0
2016-08-22 09:00:00	AAPL	Stock	27.2725	27.2875	27.1575	27.19	13894840.0
2016-08-22 10:00:00	AAPL	Stock	27.1878	27.235	27.1238	27.1475	15956872.0
2016-08-22 11:00:00	AAPL	Stock	27.1462	27.16	26.9625	27.035	16857636.0
2016-08-22 12:00:00	AAPL	Stock	27.035	27.1538	26.995	27.1112	13402840.0
2016-08-22 13:00:00	AAPL	Stock	27.11	27.1175	27.0262	27.0902	7721480.0
2016-08-22 14:00:00	AAPL	Stock	27.0925	27.1175	27.045	27.0925	7016864.0
2016-08-22 15:00:00	AAPL	Stock	27.095	27.1562	27.0925	27.125	12313424.0
2016-08-22 16:00:00	AAPL	Stock	27.1275	27.14	27.084	27.125	6096452.0
2016-08-22 17:00:00	AAPL	Stock	27.125	27.13	27.1075	27.1125	38224.0
2016-08-22 18:00:00	AAPL	Stock	27.11	27.1125	27.09	27.0925	18312.0
2016-08-22 19:00:00	AAPL	Stock	27.0975	27.11	27.025	27.07	80028.0
2016-08-22 06:00:00	MSFT	Stock	57.63	57.63	57.63	57.63	200.0
2016-08-22 07:00:00	MSFT	Stock	57.62	57.62	57.62	57.62	200.0
2016-08-22 08:00:00	MSFT	Stock	57.5	57.61	57.5	57.61	667.0
2016-08-22 09:00:00	MSFT	Stock	57.51	57.6	57.26	57.42	1997925.0
2016-08-22 10:00:00	MSFT	Stock	57.43	57.75	57.36	57.653	1926224.0
2016-08-22 11:00:00	MSFT	Stock	57.65	57.7	57.38	57.47	1812623.0
2016-08-22 12:00:00	MSFT	Stock	57.46	57.66	57.405	57.575	1453969.0
2016-08-22 13:00:00	MSFT	Stock	57.57	57.67	57.4	57.589	1283503.0
2016-08-22 14:00:00	MSFT	Stock	57.59	57.63	57.45	57.535	1295127.0
2016-08-22 15:00:00	MSFT	Stock	57.53	57.68	57.53	57.66	2986193.0
2016-08-22 16:00:00	MSFT	Stock	57.66	57.68	57.58	57.67	1479883.0
2016-08-22 17:00:00	MSFT	Stock	57.69	57.7	57.69	57.7	1400.0
2016-08-22 19:00:00	MSFT	Stock	57.63	57.63	57.63	57.63	405.0
2016-08-22 04:00:00	NVDA	Stock	1.5565	1.5565	1.5565	1.5565	6800.0
2016-08-22 06:00:00	NVDA	Stock	1.5565	1.5565	1.5565	1.5565	12000.0
2016-08-22 07:00:00	NVDA	Stock	1.5575	1.5575	1.5575	1.5575	4000.0
2016-08-22 08:00:00	NVDA	Stock	1.5632	1.5632	1.5565	1.56	307880.0
2016-08-22 09:00:00	NVDA	Stock	1.5575	1.5613	1.5428	1.5595	37098320.0
2016-08-22 10:00:00	NVDA	Stock	1.5592	1.5653	1.5549	1.5625	42544080.0
2016-08-22 11:00:00	NVDA	Stock	1.5625	1.565	1.5523	1.5595	36488040.0
2016-08-22 12:00:00	NVDA	Stock	1.5598	1.5632	1.5565	1.5594	21133240.0
2016-08-22 13:00:00	NVDA	Stock	1.5595	1.5613	1.5545	1.5596	21348920.0
2016-08-22 14:00:00	NVDA	Stock	1.5598	1.5613	1.5568	1.5592	22914840.0
2016-08-22 15:00:00	NVDA	Stock	1.5593	1.5638	1.5593	1.563	41002280.0
2016-08-22 16:00:00	NVDA	Stock	1.5628	1.563	1.5608	1.5613	6810560.0
2016-08-22 17:00:00	NVDA	Stock	1.5608	1.5608	1.5595	1.5595	23200.0
2016-08-22 18:00:00	NVDA	Stock	1.5645	1.5645	1.5645	1.5645	10000.0
2016-08-22 19:00:00	NVDA	Stock	1.5645	1.5672	1.5645	1.5672	39400.0
2016-08-22 04:00:00	AMZN	Stock	37.925	37.925	37.925	37.925	2000.0
2016-08-22 05:00:00	AMZN	Stock	37.925	37.925	37.925	37.925	2000.0
2016-08-22 06:00:00	AMZN	Stock	37.875	37.875	37.875	37.875	3000.0
2016-08-22 08:00:00	AMZN	Stock	37.8375	37.84	37.811	37.811	43020.0
2016-08-22 09:00:00	AMZN	Stock	37.811	37.875	37.605	37.7675	6414780.0
2016-08-22 10:00:00	AMZN	Stock	37.767	37.9555	37.7425	37.918	5393100.0

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

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