PREVIEW / stock_1hour / 2017-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-13.parquet
  size:    1.1 MB
  rows:    49,603
  symbols: 2,938

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-12-13 04:00:00	AAPL	Stock	42.935	42.935	42.935	42.935	400.0
2017-12-13 05:00:00	AAPL	Stock	42.975	42.975	42.975	42.975	6000.0
2017-12-13 06:00:00	AAPL	Stock	42.975	42.975	42.925	42.9625	44168.0
2017-12-13 07:00:00	AAPL	Stock	42.895	42.96	42.88	42.895	34780.0
2017-12-13 08:00:00	AAPL	Stock	42.9625	43.12	42.8775	43.0775	267592.0
2017-12-13 09:00:00	AAPL	Stock	43.08	43.385	43.075	43.235	15440460.0
2017-12-13 10:00:00	AAPL	Stock	43.235	43.2975	43.14	43.245	11640480.0
2017-12-13 11:00:00	AAPL	Stock	43.2475	43.285	43.1675	43.225	8385080.0
2017-12-13 12:00:00	AAPL	Stock	43.2225	43.2225	43.0	43.165	9521952.0
2017-12-13 13:00:00	AAPL	Stock	43.1625	43.1875	43.0775	43.0925	5468124.0
2017-12-13 14:00:00	AAPL	Stock	43.0925	43.295	43.09	43.2625	9345416.0
2017-12-13 15:00:00	AAPL	Stock	43.264	43.2825	43.035	43.0775	13797412.0
2017-12-13 16:00:00	AAPL	Stock	43.0675	43.1125	43.0675	43.0875	9201744.0
2017-12-13 17:00:00	AAPL	Stock	43.0775	43.095	43.075	43.0925	18580.0
2017-12-13 18:00:00	AAPL	Stock	43.1	43.1	43.0875	43.1	24080.0
2017-12-13 19:00:00	AAPL	Stock	43.1	43.1425	43.0875	43.1425	51460.0
2017-12-13 07:00:00	MSFT	Stock	85.99	85.99	85.6	85.6	1970.0
2017-12-13 08:00:00	MSFT	Stock	85.8	85.97	85.65	85.97	1472.0
2017-12-13 09:00:00	MSFT	Stock	85.66	86.0	85.33	85.49	2372387.0
2017-12-13 10:00:00	MSFT	Stock	85.495	85.92	85.42	85.915	2762406.0
2017-12-13 11:00:00	MSFT	Stock	85.915	85.96	85.543	85.56	1920473.0
2017-12-13 12:00:00	MSFT	Stock	85.565	85.565	85.25	85.426	2082270.0
2017-12-13 13:00:00	MSFT	Stock	85.43	85.49	85.17	85.33	1479276.0
2017-12-13 14:00:00	MSFT	Stock	85.35	85.68	85.35	85.56	2178936.0
2017-12-13 15:00:00	MSFT	Stock	85.555	85.64	85.28	85.35	3990689.0
2017-12-13 16:00:00	MSFT	Stock	85.35	85.41	85.3	85.31	3288793.0
2017-12-13 17:00:00	MSFT	Stock	85.31	85.32	85.31	85.32	320.0
2017-12-13 19:00:00	MSFT	Stock	85.41	85.58	85.41	85.58	1743.0
2017-12-13 04:00:00	NVDA	Stock	4.7825	4.7875	4.7825	4.7875	13200.0
2017-12-13 06:00:00	NVDA	Stock	4.788	4.7883	4.787	4.787	50000.0
2017-12-13 07:00:00	NVDA	Stock	4.7845	4.7875	4.7658	4.7712	209680.0
2017-12-13 08:00:00	NVDA	Stock	4.7815	4.7943	4.7645	4.7943	5112840.0
2017-12-13 09:00:00	NVDA	Stock	4.794	4.8138	4.7602	4.764	69530600.0
2017-12-13 10:00:00	NVDA	Stock	4.763	4.7672	4.7278	4.749	102259000.0
2017-12-13 11:00:00	NVDA	Stock	4.7475	4.75	4.701	4.7062	65693600.0
2017-12-13 12:00:00	NVDA	Stock	4.7062	4.709	4.6665	4.6795	79703800.0
2017-12-13 13:00:00	NVDA	Stock	4.678	4.694	4.6722	4.6845	37020000.0
2017-12-13 14:00:00	NVDA	Stock	4.6846	4.6983	4.6765	4.6915	43259840.0
2017-12-13 15:00:00	NVDA	Stock	4.6905	4.6934	4.647	4.6555	107135040.0
2017-12-13 16:00:00	NVDA	Stock	4.6545	4.7169	4.6518	4.6548	5212720.0
2017-12-13 17:00:00	NVDA	Stock	4.6562	4.6585	4.6512	4.6545	423000.0
2017-12-13 18:00:00	NVDA	Stock	4.6538	4.6625	4.6538	4.6625	498760.0
2017-12-13 19:00:00	NVDA	Stock	4.662	4.6738	4.662	4.665	320720.0
2017-12-13 06:00:00	AMZN	Stock	58.464	58.4895	58.464	58.4895	13000.0
2017-12-13 07:00:00	AMZN	Stock	58.375	58.375	58.2745	58.2745	14440.0
2017-12-13 08:00:00	AMZN	Stock	58.3825	58.55	58.3435	58.5	141280.0
2017-12-13 09:00:00	AMZN	Stock	58.4955	58.5435	58.1455	58.2558	7784960.0
2017-12-13 10:00:00	AMZN	Stock	58.235	58.3815	58.191	58.3445	4928560.0
2017-12-13 11:00:00	AMZN	Stock	58.3495	58.4555	58.15	58.2	5543220.0
2017-12-13 12:00:00	AMZN	Stock	58.2	58.2274	58.066	58.209	5529840.0

> showing 50 of 49,603 rows — these rows as CSV

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