PREVIEW / stock_1hour / 2017-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-15.parquet
  size:    1.1 MB
  rows:    48,733
  symbols: 3,082

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
2017-03-15 04:00:00	AAPL	Stock	34.7925	34.7925	34.7925	34.7925	3120.0
2017-03-15 05:00:00	AAPL	Stock	34.83	34.83	34.7825	34.7825	3080.0
2017-03-15 06:00:00	AAPL	Stock	34.8125	34.8425	34.8125	34.8225	18996.0
2017-03-15 07:00:00	AAPL	Stock	34.8125	34.825	34.8125	34.8225	45096.0
2017-03-15 08:00:00	AAPL	Stock	34.8125	34.8275	34.8	34.805	84456.0
2017-03-15 09:00:00	AAPL	Stock	34.81	34.8875	34.7562	34.815	9847636.0
2017-03-15 10:00:00	AAPL	Stock	34.8125	34.8375	34.78	34.8038	6624768.0
2017-03-15 11:00:00	AAPL	Stock	34.8025	34.885	34.7925	34.88	5374436.0
2017-03-15 12:00:00	AAPL	Stock	34.88	35.035	34.855	34.986	15393480.0
2017-03-15 13:00:00	AAPL	Stock	34.9875	35.0125	34.945	34.9775	6161908.0
2017-03-15 14:00:00	AAPL	Stock	34.9775	35.1	34.9325	35.08	16587972.0
2017-03-15 15:00:00	AAPL	Stock	35.08	35.1875	35.06	35.1125	18578848.0
2017-03-15 16:00:00	AAPL	Stock	35.1075	35.14	35.0625	35.105	8472592.0
2017-03-15 17:00:00	AAPL	Stock	35.1175	35.1275	35.1125	35.1125	133372.0
2017-03-15 18:00:00	AAPL	Stock	35.1125	35.1275	35.105	35.1275	25776.0
2017-03-15 19:00:00	AAPL	Stock	35.14	35.1425	35.125	35.13	21636.0
2017-03-15 07:00:00	MSFT	Stock	64.45	64.45	64.45	64.45	100.0
2017-03-15 08:00:00	MSFT	Stock	64.54	64.6	64.48	64.48	1888.0
2017-03-15 09:00:00	MSFT	Stock	64.6	64.6	64.355	64.46	1469368.0
2017-03-15 10:00:00	MSFT	Stock	64.45	64.46	64.25	64.4	1706735.0
2017-03-15 11:00:00	MSFT	Stock	64.4	64.58	64.39	64.565	1440446.0
2017-03-15 12:00:00	MSFT	Stock	64.565	64.71	64.55	64.65	1095134.0
2017-03-15 13:00:00	MSFT	Stock	64.645	64.67	64.475	64.52	1419214.0
2017-03-15 14:00:00	MSFT	Stock	64.515	64.92	64.515	64.76	3744356.0
2017-03-15 15:00:00	MSFT	Stock	64.76	64.9	64.71	64.73	3224567.0
2017-03-15 16:00:00	MSFT	Stock	64.71	64.77	64.7	64.77	4873364.0
2017-03-15 17:00:00	MSFT	Stock	64.69	64.75	64.64	64.64	4213964.0
2017-03-15 18:00:00	MSFT	Stock	64.74	64.79	64.66	64.78	3935.0
2017-03-15 19:00:00	MSFT	Stock	64.7	64.79	64.7	64.75	2200.0
2017-03-15 04:00:00	NVDA	Stock	2.5435	2.5598	2.5435	2.5598	41440.0
2017-03-15 06:00:00	NVDA	Stock	2.5625	2.5625	2.5625	2.5625	32000.0
2017-03-15 07:00:00	NVDA	Stock	2.5528	2.5625	2.5512	2.5613	181000.0
2017-03-15 08:00:00	NVDA	Stock	2.5613	2.5648	2.5528	2.562	1879600.0
2017-03-15 09:00:00	NVDA	Stock	2.5615	2.565	2.525	2.536	106721480.0
2017-03-15 10:00:00	NVDA	Stock	2.5355	2.5415	2.508	2.5398	127517200.0
2017-03-15 11:00:00	NVDA	Stock	2.5398	2.551	2.536	2.55	70028000.0
2017-03-15 12:00:00	NVDA	Stock	2.5501	2.5677	2.5495	2.5568	73554280.0
2017-03-15 13:00:00	NVDA	Stock	2.5565	2.5592	2.5455	2.5533	34349760.0
2017-03-15 14:00:00	NVDA	Stock	2.5533	2.5748	2.5472	2.5648	87134600.0
2017-03-15 15:00:00	NVDA	Stock	2.5648	2.5715	2.5613	2.5638	81299480.0
2017-03-15 16:00:00	NVDA	Stock	2.5638	2.5638	2.5593	2.5625	17362200.0
2017-03-15 17:00:00	NVDA	Stock	2.5598	2.5625	2.559	2.5625	202440.0
2017-03-15 18:00:00	NVDA	Stock	2.5622	2.5675	2.5622	2.5675	112000.0
2017-03-15 19:00:00	NVDA	Stock	2.5638	2.5638	2.5602	2.5638	90400.0
2017-03-15 07:00:00	AMZN	Stock	42.6945	42.7225	42.6945	42.6945	14000.0
2017-03-15 08:00:00	AMZN	Stock	42.694	42.7	42.6635	42.7	12800.0
2017-03-15 09:00:00	AMZN	Stock	42.7	42.75	42.3923	42.4428	6442140.0
2017-03-15 10:00:00	AMZN	Stock	42.4435	42.495	42.3555	42.385	9536280.0
2017-03-15 11:00:00	AMZN	Stock	42.3815	42.4848	42.371	42.482	3710860.0
2017-03-15 12:00:00	AMZN	Stock	42.487	42.549	42.4805	42.54	4074880.0

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

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