PREVIEW / stock_1hour / 2015-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-04.parquet
  size:    1.0 MB
  rows:    48,654
  symbols: 3,402

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-12-04 04:00:00	AAPL	Stock	28.885	28.9875	28.885	28.9225	23160.0
2015-12-04 05:00:00	AAPL	Stock	28.92	28.98	28.92	28.9425	13268.0
2015-12-04 06:00:00	AAPL	Stock	28.9375	28.9375	28.905	28.93	5304.0
2015-12-04 07:00:00	AAPL	Stock	28.935	28.935	28.8925	28.9	29112.0
2015-12-04 08:00:00	AAPL	Stock	28.89	28.9375	28.805	28.8625	447084.0
2015-12-04 09:00:00	AAPL	Stock	28.8625	29.3675	28.7525	29.355	32925312.0
2015-12-04 10:00:00	AAPL	Stock	29.3575	29.62	29.315	29.6162	51529532.0
2015-12-04 11:00:00	AAPL	Stock	29.6162	29.625	29.4675	29.5538	23916288.0
2015-12-04 12:00:00	AAPL	Stock	29.5525	29.7062	29.5	29.6495	19500748.0
2015-12-04 13:00:00	AAPL	Stock	29.655	29.7355	29.6375	29.7338	17547848.0
2015-12-04 14:00:00	AAPL	Stock	29.7338	29.7875	29.705	29.7775	19523156.0
2015-12-04 15:00:00	AAPL	Stock	29.78	29.8125	29.7075	29.75	31193464.0
2015-12-04 16:00:00	AAPL	Stock	29.7575	29.7725	29.472	29.75	16386072.0
2015-12-04 17:00:00	AAPL	Stock	29.745	29.7725	29.7425	29.7725	119240.0
2015-12-04 18:00:00	AAPL	Stock	29.7725	29.775	29.755	29.7625	37400.0
2015-12-04 19:00:00	AAPL	Stock	29.7625	29.7675	29.76	29.7625	19744.0
2015-12-04 04:00:00	MSFT	Stock	54.6	54.6	54.6	54.6	900.0
2015-12-04 05:00:00	MSFT	Stock	54.51	54.51	54.43	54.43	1450.0
2015-12-04 06:00:00	MSFT	Stock	54.45	54.45	54.4	54.4	900.0
2015-12-04 07:00:00	MSFT	Stock	54.48	54.48	54.4	54.4	1308.0
2015-12-04 08:00:00	MSFT	Stock	54.33	54.48	54.3	54.4	15468.0
2015-12-04 09:00:00	MSFT	Stock	54.4	55.02	54.1	54.92	4608818.0
2015-12-04 10:00:00	MSFT	Stock	54.93	55.27	54.725	55.25	4955012.0
2015-12-04 11:00:00	MSFT	Stock	55.245	55.36	55.1	55.3	3476849.0
2015-12-04 12:00:00	MSFT	Stock	55.3	55.63	55.24	55.56	3866717.0
2015-12-04 13:00:00	MSFT	Stock	55.56	55.87	55.5	55.82	4200149.0
2015-12-04 14:00:00	MSFT	Stock	55.82	56.18	55.79	56.16	6445796.0
2015-12-04 15:00:00	MSFT	Stock	56.15	56.23	55.79	55.9	8388140.0
2015-12-04 16:00:00	MSFT	Stock	55.91	55.91	55.543	55.88	4238184.0
2015-12-04 17:00:00	MSFT	Stock	55.88	55.88	55.88	55.88	350.0
2015-12-04 18:00:00	MSFT	Stock	55.9	55.9	55.87	55.87	1900.0
2015-12-04 19:00:00	MSFT	Stock	55.85	55.85	55.82	55.82	6510.0
2015-12-04 08:00:00	NVDA	Stock	0.813	0.813	0.813	0.813	4000.0
2015-12-04 09:00:00	NVDA	Stock	0.8125	0.8348	0.8108	0.83	44027240.0
2015-12-04 10:00:00	NVDA	Stock	0.8301	0.839	0.8259	0.8382	99201200.0
2015-12-04 11:00:00	NVDA	Stock	0.8382	0.8395	0.8302	0.8305	35886040.0
2015-12-04 12:00:00	NVDA	Stock	0.8305	0.839	0.8278	0.8385	43384360.0
2015-12-04 13:00:00	NVDA	Stock	0.8388	0.8391	0.8346	0.8365	23661200.0
2015-12-04 14:00:00	NVDA	Stock	0.8368	0.8443	0.8358	0.8435	55346160.0
2015-12-04 15:00:00	NVDA	Stock	0.8438	0.8452	0.8405	0.8435	123129080.0
2015-12-04 16:00:00	NVDA	Stock	0.8438	0.8438	0.8378	0.8438	13341880.0
2015-12-04 18:00:00	NVDA	Stock	0.8458	0.8458	0.8458	0.8458	7000.0
2015-12-04 19:00:00	NVDA	Stock	0.8455	0.8472	0.8455	0.8462	63000.0
2015-12-04 04:00:00	AMZN	Stock	33.4	33.558	33.4	33.537	12000.0
2015-12-04 05:00:00	AMZN	Stock	33.525	33.525	33.525	33.525	2740.0
2015-12-04 06:00:00	AMZN	Stock	33.543	33.543	33.5155	33.5155	6000.0
2015-12-04 07:00:00	AMZN	Stock	33.5	33.5	33.45	33.4505	53940.0
2015-12-04 08:00:00	AMZN	Stock	33.4615	33.5855	33.415	33.465	385860.0
2015-12-04 09:00:00	AMZN	Stock	33.476	33.5	33.07	33.229	13099180.0
2015-12-04 10:00:00	AMZN	Stock	33.2236	33.6875	33.1305	33.6595	16499120.0

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

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