PREVIEW / stock_1hour / 2015-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-01.parquet
  size:    1.1 MB
  rows:    49,917
  symbols: 3,487

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-07-01 04:00:00	AAPL	Stock	31.4975	31.57	31.4725	31.57	17160.0
2015-07-01 05:00:00	AAPL	Stock	31.5675	31.7	31.5675	31.685	21960.0
2015-07-01 06:00:00	AAPL	Stock	31.675	31.6875	31.605	31.675	76824.0
2015-07-01 07:00:00	AAPL	Stock	31.675	31.74	31.65	31.685	443464.0
2015-07-01 08:00:00	AAPL	Stock	31.3562	31.7375	31.3562	31.7075	663564.0
2015-07-01 09:00:00	AAPL	Stock	31.72	31.735	31.5825	31.6875	22106696.0
2015-07-01 10:00:00	AAPL	Stock	31.6888	31.7225	31.5775	31.6262	22040696.0
2015-07-01 11:00:00	AAPL	Stock	31.6275	31.6375	31.55	31.5625	12138128.0
2015-07-01 12:00:00	AAPL	Stock	31.5625	31.6025	31.5175	31.545	10045276.0
2015-07-01 13:00:00	AAPL	Stock	31.5448	31.6175	31.5025	31.5375	10223372.0
2015-07-01 14:00:00	AAPL	Stock	31.54	31.5725	31.4975	31.53	9902528.0
2015-07-01 15:00:00	AAPL	Stock	31.53	31.65	31.5285	31.645	16901248.0
2015-07-01 16:00:00	AAPL	Stock	31.65	31.68	31.6025	31.625	5757196.0
2015-07-01 17:00:00	AAPL	Stock	31.62	31.65	31.62	31.6375	78240.0
2015-07-01 18:00:00	AAPL	Stock	31.645	31.645	31.61	31.615	34492.0
2015-07-01 19:00:00	AAPL	Stock	31.625	31.6275	31.6025	31.6125	42168.0
2015-07-01 05:00:00	MSFT	Stock	44.49	44.62	44.49	44.62	300.0
2015-07-01 06:00:00	MSFT	Stock	44.56	44.56	44.49	44.55	2400.0
2015-07-01 07:00:00	MSFT	Stock	44.49	44.49	44.45	44.45	9857.0
2015-07-01 08:00:00	MSFT	Stock	44.15	44.49	44.15	44.47	34132.0
2015-07-01 09:00:00	MSFT	Stock	44.15	45.23	44.15	45.08	5232587.0
2015-07-01 10:00:00	MSFT	Stock	45.08	45.12	44.48	44.655	5894944.0
2015-07-01 11:00:00	MSFT	Stock	44.66	44.7	44.48	44.6	2727666.0
2015-07-01 12:00:00	MSFT	Stock	44.6	44.63	44.22	44.26	2679569.0
2015-07-01 13:00:00	MSFT	Stock	44.25	44.36	44.2	44.22	2304084.0
2015-07-01 14:00:00	MSFT	Stock	44.22	44.38	44.1	44.35	2529800.0
2015-07-01 15:00:00	MSFT	Stock	44.36	44.49	44.335	44.446	3931169.0
2015-07-01 16:00:00	MSFT	Stock	44.46	44.46	44.44	44.46	1708106.0
2015-07-01 17:00:00	MSFT	Stock	44.45	44.46	44.45	44.45	851.0
2015-07-01 18:00:00	MSFT	Stock	44.46	44.46	44.45	44.45	245.0
2015-07-01 19:00:00	MSFT	Stock	44.45	44.46	44.44	44.44	2984.0
2015-07-01 05:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	40000.0
2015-07-01 06:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	20000.0
2015-07-01 07:00:00	NVDA	Stock	0.514	0.514	0.514	0.514	8000.0
2015-07-01 08:00:00	NVDA	Stock	0.5028	0.5165	0.5028	0.5165	452640.0
2015-07-01 09:00:00	NVDA	Stock	0.517	0.5225	0.5138	0.5182	69178520.0
2015-07-01 10:00:00	NVDA	Stock	0.5185	0.519	0.5121	0.5122	32825880.0
2015-07-01 11:00:00	NVDA	Stock	0.5125	0.5136	0.511	0.5111	25989480.0
2015-07-01 12:00:00	NVDA	Stock	0.511	0.511	0.5072	0.5075	20885760.0
2015-07-01 13:00:00	NVDA	Stock	0.5075	0.509	0.5065	0.507	19396800.0
2015-07-01 14:00:00	NVDA	Stock	0.5071	0.5075	0.5055	0.507	41042160.0
2015-07-01 15:00:00	NVDA	Stock	0.507	0.5106	0.5065	0.51	76315320.0
2015-07-01 16:00:00	NVDA	Stock	0.51	0.5112	0.51	0.5112	11184320.0
2015-07-01 08:00:00	AMZN	Stock	21.9375	21.9375	21.67	21.888	31000.0
2015-07-01 09:00:00	AMZN	Stock	21.8875	22.0	21.8875	21.934	6347940.0
2015-07-01 10:00:00	AMZN	Stock	21.931	21.958	21.858	21.9465	4511300.0
2015-07-01 11:00:00	AMZN	Stock	21.948	21.9592	21.9015	21.93	4714100.0
2015-07-01 12:00:00	AMZN	Stock	21.9325	21.937	21.8365	21.8805	3518420.0
2015-07-01 13:00:00	AMZN	Stock	21.876	21.898	21.811	21.8122	4438600.0
2015-07-01 14:00:00	AMZN	Stock	21.818	21.8425	21.779	21.8078	2294060.0

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

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