PREVIEW / stock_1hour / 2015-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-22.parquet
  size:    1.0 MB
  rows:    48,486
  symbols: 3,434

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-09-22 04:00:00	AAPL	Stock	28.525	28.625	28.45	28.475	13200.0
2015-09-22 05:00:00	AAPL	Stock	28.4675	28.5275	28.385	28.455	41032.0
2015-09-22 06:00:00	AAPL	Stock	28.455	28.52	28.315	28.5	159644.0
2015-09-22 07:00:00	AAPL	Stock	28.5	28.5725	28.43	28.5725	222816.0
2015-09-22 08:00:00	AAPL	Stock	28.3692	28.575	28.3692	28.455	1275560.0
2015-09-22 09:00:00	AAPL	Stock	28.45	28.545	28.325	28.42	27931504.0
2015-09-22 10:00:00	AAPL	Stock	28.42	28.5175	28.27	28.3112	30604752.0
2015-09-22 11:00:00	AAPL	Stock	28.3125	28.365	28.19	28.255	23273964.0
2015-09-22 12:00:00	AAPL	Stock	28.2548	28.305	28.1475	28.1612	18396228.0
2015-09-22 13:00:00	AAPL	Stock	28.1598	28.2775	28.13	28.275	17085444.0
2015-09-22 14:00:00	AAPL	Stock	28.275	28.3225	28.1825	28.305	20033212.0
2015-09-22 15:00:00	AAPL	Stock	28.3025	28.3875	28.1928	28.3425	30776176.0
2015-09-22 16:00:00	AAPL	Stock	28.35	28.454	28.35	28.3625	18118348.0
2015-09-22 17:00:00	AAPL	Stock	28.3625	28.3625	28.35	28.355	7297468.0
2015-09-22 18:00:00	AAPL	Stock	28.3625	28.37	28.345	28.345	97340.0
2015-09-22 19:00:00	AAPL	Stock	28.35	28.35	28.2575	28.275	123720.0
2015-09-22 06:00:00	MSFT	Stock	43.64	43.64	43.48	43.48	1820.0
2015-09-22 07:00:00	MSFT	Stock	43.33	43.6	43.32	43.6	2155.0
2015-09-22 08:00:00	MSFT	Stock	43.6	43.6	43.31	43.35	45922.0
2015-09-22 09:00:00	MSFT	Stock	43.37	43.713	43.3	43.54	3407150.0
2015-09-22 10:00:00	MSFT	Stock	43.54	43.69	43.31	43.455	3464936.0
2015-09-22 11:00:00	MSFT	Stock	43.46	43.77	43.455	43.7	3499010.0
2015-09-22 12:00:00	MSFT	Stock	43.7	43.813	43.44	43.493	2436433.0
2015-09-22 13:00:00	MSFT	Stock	43.49	43.68	43.37	43.635	2895041.0
2015-09-22 14:00:00	MSFT	Stock	43.63	43.77	43.505	43.75	2916016.0
2015-09-22 15:00:00	MSFT	Stock	43.746	44.05	43.66	43.9	5332331.0
2015-09-22 16:00:00	MSFT	Stock	43.9	43.93	43.9	43.91	2538142.0
2015-09-22 17:00:00	MSFT	Stock	43.89	43.89	43.89	43.89	380.0
2015-09-22 18:00:00	MSFT	Stock	43.89	43.95	43.8	43.88	4950.0
2015-09-22 19:00:00	MSFT	Stock	43.85	43.88	43.81	43.88	550.0
2015-09-22 08:00:00	NVDA	Stock	0.5788	0.5788	0.5788	0.5788	4000.0
2015-09-22 09:00:00	NVDA	Stock	0.5775	0.5795	0.5738	0.5772	37170360.0
2015-09-22 10:00:00	NVDA	Stock	0.5772	0.5785	0.5701	0.5734	44706760.0
2015-09-22 11:00:00	NVDA	Stock	0.5732	0.5762	0.573	0.5742	23100000.0
2015-09-22 12:00:00	NVDA	Stock	0.574	0.5768	0.5705	0.5719	18077440.0
2015-09-22 13:00:00	NVDA	Stock	0.5718	0.5736	0.5698	0.5708	17256360.0
2015-09-22 14:00:00	NVDA	Stock	0.5708	0.572	0.5691	0.5712	19887960.0
2015-09-22 15:00:00	NVDA	Stock	0.571	0.574	0.5694	0.5725	46636040.0
2015-09-22 16:00:00	NVDA	Stock	0.5722	0.5725	0.5722	0.5725	8531880.0
2015-09-22 17:00:00	NVDA	Stock	0.5725	0.5725	0.5725	0.5725	12000.0
2015-09-22 18:00:00	NVDA	Stock	0.57	0.57	0.57	0.57	36000.0
2015-09-22 19:00:00	NVDA	Stock	0.57	0.57	0.57	0.57	4000.0
2015-09-22 04:00:00	AMZN	Stock	27.135	27.135	27.135	27.135	10000.0
2015-09-22 05:00:00	AMZN	Stock	27.055	27.0685	27.0445	27.0445	17200.0
2015-09-22 06:00:00	AMZN	Stock	27.0015	27.0945	27.0015	27.03	19000.0
2015-09-22 07:00:00	AMZN	Stock	27.05	27.079	27.05	27.05	101760.0
2015-09-22 08:00:00	AMZN	Stock	27.0925	27.098	27.0175	27.05	402940.0
2015-09-22 09:00:00	AMZN	Stock	27.05	27.1775	26.95	26.9875	11597520.0
2015-09-22 10:00:00	AMZN	Stock	26.9995	27.065	26.7675	26.8265	12750120.0
2015-09-22 11:00:00	AMZN	Stock	26.808	26.8615	26.6515	26.7615	10671320.0

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

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