PREVIEW / stock_1hour / 2018-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-06.parquet
  size:    1.1 MB
  rows:    48,743
  symbols: 2,780

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
2018-09-06 04:00:00	AAPL	Stock	56.67	56.875	56.6	56.875	37864.0
2018-09-06 05:00:00	AAPL	Stock	56.875	57.0	56.875	56.97	21756.0
2018-09-06 06:00:00	AAPL	Stock	56.8025	56.8875	56.76	56.8125	18296.0
2018-09-06 07:00:00	AAPL	Stock	56.7575	56.8	56.6675	56.7925	98764.0
2018-09-06 08:00:00	AAPL	Stock	56.725	56.9225	56.6675	56.92	416392.0
2018-09-06 09:00:00	AAPL	Stock	56.92	56.925	56.1075	56.5825	15109976.0
2018-09-06 10:00:00	AAPL	Stock	56.5825	56.6075	55.545	55.76	27151008.0
2018-09-06 11:00:00	AAPL	Stock	55.77	55.9025	55.325	55.88	22884280.0
2018-09-06 12:00:00	AAPL	Stock	55.8775	55.975	55.66	55.6992	10196576.0
2018-09-06 13:00:00	AAPL	Stock	55.6975	55.9625	55.5825	55.7425	9890864.0
2018-09-06 14:00:00	AAPL	Stock	55.745	55.8362	55.6125	55.7275	8852304.0
2018-09-06 15:00:00	AAPL	Stock	55.7275	55.885	55.675	55.78	15365576.0
2018-09-06 16:00:00	AAPL	Stock	55.7775	55.8125	55.6745	55.775	7558672.0
2018-09-06 17:00:00	AAPL	Stock	55.775	55.855	55.755	55.825	41084.0
2018-09-06 18:00:00	AAPL	Stock	55.835	55.8475	55.8175	55.825	44744.0
2018-09-06 19:00:00	AAPL	Stock	55.8375	55.875	55.8175	55.875	65744.0
2018-09-06 04:00:00	MSFT	Stock	108.5	108.6	108.5	108.6	2101.0
2018-09-06 05:00:00	MSFT	Stock	108.8	108.8	108.8	108.8	1179.0
2018-09-06 06:00:00	MSFT	Stock	108.6	108.6	108.49	108.56	2602.0
2018-09-06 07:00:00	MSFT	Stock	108.69	108.71	108.46	108.48	4743.0
2018-09-06 08:00:00	MSFT	Stock	108.65	108.88	108.49	108.6	29950.0
2018-09-06 09:00:00	MSFT	Stock	108.7	108.99	108.25	108.7	2374922.0
2018-09-06 10:00:00	MSFT	Stock	108.71	108.78	107.51	107.82	3446341.0
2018-09-06 11:00:00	MSFT	Stock	107.82	108.435	107.52	108.29	2928515.0
2018-09-06 12:00:00	MSFT	Stock	108.27	108.36	107.95	108.0	1661302.0
2018-09-06 13:00:00	MSFT	Stock	108.0	108.58	107.77	108.35	1671827.0
2018-09-06 14:00:00	MSFT	Stock	108.345	108.51	108.06	108.235	1537985.0
2018-09-06 15:00:00	MSFT	Stock	108.24	108.97	108.24	108.75	3907360.0
2018-09-06 16:00:00	MSFT	Stock	108.74	108.94	108.224	108.77	2995442.0
2018-09-06 17:00:00	MSFT	Stock	108.76	108.76	108.71	108.71	236688.0
2018-09-06 18:00:00	MSFT	Stock	108.58	108.77	108.58	108.74	3609.0
2018-09-06 19:00:00	MSFT	Stock	108.74	108.77	108.64	108.64	300.0
2018-09-06 04:00:00	NVDA	Stock	6.9392	6.941	6.9392	6.941	22520.0
2018-09-06 06:00:00	NVDA	Stock	6.9513	6.9513	6.912	6.912	215920.0
2018-09-06 07:00:00	NVDA	Stock	6.9125	6.9775	6.9125	6.9775	481600.0
2018-09-06 08:00:00	NVDA	Stock	6.9708	6.9835	6.9125	6.9502	547200.0
2018-09-06 09:00:00	NVDA	Stock	6.962	6.9685	6.8438	6.9198	40667240.0
2018-09-06 10:00:00	NVDA	Stock	6.9182	6.9218	6.8025	6.8365	54575640.0
2018-09-06 11:00:00	NVDA	Stock	6.837	6.8688	6.7909	6.8567	46222240.0
2018-09-06 12:00:00	NVDA	Stock	6.8565	6.87	6.8065	6.809	21193880.0
2018-09-06 13:00:00	NVDA	Stock	6.8082	6.8245	6.7848	6.8032	28531480.0
2018-09-06 14:00:00	NVDA	Stock	6.8038	6.8315	6.7943	6.8278	21642600.0
2018-09-06 15:00:00	NVDA	Stock	6.828	6.85	6.816	6.8188	39306680.0
2018-09-06 16:00:00	NVDA	Stock	6.818	6.83	6.8078	6.825	15289040.0
2018-09-06 17:00:00	NVDA	Stock	6.8125	6.8272	6.8108	6.8108	157640.0
2018-09-06 18:00:00	NVDA	Stock	6.823	6.8318	6.8215	6.8288	131040.0
2018-09-06 19:00:00	NVDA	Stock	6.8268	6.8325	6.8225	6.8325	78320.0
2018-09-06 04:00:00	AMZN	Stock	100.25	100.5	100.25	100.5	17220.0
2018-09-06 05:00:00	AMZN	Stock	100.5	100.5	100.38	100.38	21140.0
2018-09-06 06:00:00	AMZN	Stock	100.425	100.425	100.35	100.35	13000.0

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

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