PREVIEW / stock_1hour / 2015-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-07.parquet
  size:    1.0 MB
  rows:    47,904
  symbols: 3,465

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-08-07 04:00:00	AAPL	Stock	28.7875	28.7875	28.7875	28.7875	9292.0
2015-08-07 05:00:00	AAPL	Stock	28.82	28.82	28.775	28.775	5868.0
2015-08-07 06:00:00	AAPL	Stock	28.7725	28.775	28.7125	28.75	16724.0
2015-08-07 07:00:00	AAPL	Stock	28.725	28.7375	28.7075	28.7125	60092.0
2015-08-07 08:00:00	AAPL	Stock	28.7125	28.7825	28.685	28.7575	577888.0
2015-08-07 09:00:00	AAPL	Stock	28.7825	29.045	28.625	29.025	30830540.0
2015-08-07 10:00:00	AAPL	Stock	29.025	29.0625	28.78	28.8125	27928196.0
2015-08-07 11:00:00	AAPL	Stock	28.8125	28.8325	28.6775	28.8	18722100.0
2015-08-07 12:00:00	AAPL	Stock	28.8	28.825	28.675	28.7322	12601552.0
2015-08-07 13:00:00	AAPL	Stock	28.7325	28.8325	28.7225	28.76	12310896.0
2015-08-07 14:00:00	AAPL	Stock	28.759	28.805	28.75	28.795	10476656.0
2015-08-07 15:00:00	AAPL	Stock	28.795	28.9025	28.7575	28.885	25436420.0
2015-08-07 16:00:00	AAPL	Stock	28.88	28.895	28.7388	28.8825	4398360.0
2015-08-07 17:00:00	AAPL	Stock	28.8775	28.8875	28.87	28.8725	323816.0
2015-08-07 18:00:00	AAPL	Stock	28.875	28.8875	28.8725	28.885	66868.0
2015-08-07 19:00:00	AAPL	Stock	28.8832	28.8875	28.88	28.88	88140.0
2015-08-07 07:00:00	MSFT	Stock	46.6	46.6	46.6	46.6	800.0
2015-08-07 08:00:00	MSFT	Stock	46.453	46.57	46.4	46.57	30805.0
2015-08-07 09:00:00	MSFT	Stock	46.64	46.745	46.29	46.685	2530945.0
2015-08-07 10:00:00	MSFT	Stock	46.69	46.765	46.44	46.489	2398148.0
2015-08-07 11:00:00	MSFT	Stock	46.49	46.49	46.26	46.43	2073728.0
2015-08-07 12:00:00	MSFT	Stock	46.43	46.47	46.27	46.39	1383506.0
2015-08-07 13:00:00	MSFT	Stock	46.38	46.54	46.33	46.45	1224707.0
2015-08-07 14:00:00	MSFT	Stock	46.44	46.61	46.38	46.58	1930291.0
2015-08-07 15:00:00	MSFT	Stock	46.58	46.78	46.48	46.76	4367261.0
2015-08-07 16:00:00	MSFT	Stock	46.74	46.8	46.508	46.75	2253084.0
2015-08-07 17:00:00	MSFT	Stock	46.75	46.76	46.75	46.76	850.0
2015-08-07 18:00:00	MSFT	Stock	46.75	46.77	46.75	46.77	3494.0
2015-08-07 05:00:00	NVDA	Stock	0.5528	0.5528	0.5525	0.5525	186600.0
2015-08-07 06:00:00	NVDA	Stock	0.5575	0.563	0.5548	0.563	63800.0
2015-08-07 07:00:00	NVDA	Stock	0.5598	0.562	0.5585	0.5588	2494600.0
2015-08-07 08:00:00	NVDA	Stock	0.5625	0.5625	0.5525	0.5548	23645480.0
2015-08-07 09:00:00	NVDA	Stock	0.556	0.5642	0.547	0.5616	324088880.0
2015-08-07 10:00:00	NVDA	Stock	0.5619	0.5685	0.5575	0.5612	281508760.0
2015-08-07 11:00:00	NVDA	Stock	0.5612	0.5632	0.5565	0.5612	112039920.0
2015-08-07 12:00:00	NVDA	Stock	0.5612	0.5635	0.5608	0.5628	70130120.0
2015-08-07 13:00:00	NVDA	Stock	0.5628	0.571	0.562	0.5702	90037400.0
2015-08-07 14:00:00	NVDA	Stock	0.5701	0.5843	0.57	0.5789	180195720.0
2015-08-07 15:00:00	NVDA	Stock	0.5788	0.5832	0.572	0.5745	243778720.0
2015-08-07 16:00:00	NVDA	Stock	0.5745	0.5765	0.5745	0.5765	36330400.0
2015-08-07 17:00:00	NVDA	Stock	0.575	0.5762	0.575	0.575	102200.0
2015-08-07 18:00:00	NVDA	Stock	0.5762	0.5762	0.575	0.575	32000.0
2015-08-07 19:00:00	NVDA	Stock	0.5748	0.5748	0.5738	0.5738	35800.0
2015-08-07 04:00:00	AMZN	Stock	26.5125	26.5125	26.464	26.464	8800.0
2015-08-07 07:00:00	AMZN	Stock	26.45	26.45	26.3755	26.3755	10040.0
2015-08-07 08:00:00	AMZN	Stock	26.4405	26.5	26.4075	26.48	70340.0
2015-08-07 09:00:00	AMZN	Stock	26.525	26.547	26.066	26.2772	10893680.0
2015-08-07 10:00:00	AMZN	Stock	26.2865	26.3165	26.057	26.113	9405480.0
2015-08-07 11:00:00	AMZN	Stock	26.1225	26.145	25.9105	26.0995	10412040.0
2015-08-07 12:00:00	AMZN	Stock	26.1	26.267	26.0888	26.1395	10200860.0

> showing 50 of 47,904 rows — these rows as CSV

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