PREVIEW / stock_1hour / 2019-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-12.parquet
  size:    1.1 MB
  rows:    49,066
  symbols: 2,593

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
2019-06-12 04:00:00	AAPL	Stock	48.5425	48.5425	48.3275	48.3275	5356.0
2019-06-12 05:00:00	AAPL	Stock	48.35	48.35	48.35	48.35	3500.0
2019-06-12 06:00:00	AAPL	Stock	48.2975	48.35	48.2975	48.35	8372.0
2019-06-12 07:00:00	AAPL	Stock	48.37	48.4125	48.28	48.295	79468.0
2019-06-12 08:00:00	AAPL	Stock	48.3975	48.425	48.2655	48.3175	196652.0
2019-06-12 09:00:00	AAPL	Stock	48.335	48.808	48.325	48.795	12302896.0
2019-06-12 10:00:00	AAPL	Stock	48.7975	48.9925	48.5825	48.7875	13097812.0
2019-06-12 11:00:00	AAPL	Stock	48.79	48.8525	48.635	48.6775	6630736.0
2019-06-12 12:00:00	AAPL	Stock	48.6825	48.7625	48.5938	48.71	6809800.0
2019-06-12 13:00:00	AAPL	Stock	48.708	48.7475	48.6025	48.6412	4234652.0
2019-06-12 14:00:00	AAPL	Stock	48.645	48.6875	48.515	48.5985	5785444.0
2019-06-12 15:00:00	AAPL	Stock	48.6012	48.6082	48.4475	48.5475	8473232.0
2019-06-12 16:00:00	AAPL	Stock	48.5475	48.5475	48.5	48.535	4262372.0
2019-06-12 17:00:00	AAPL	Stock	48.525	48.525	48.5	48.5225	14364.0
2019-06-12 18:00:00	AAPL	Stock	48.525	48.625	48.525	48.5975	51172.0
2019-06-12 19:00:00	AAPL	Stock	48.5975	48.675	48.575	48.675	59588.0
2019-06-12 04:00:00	MSFT	Stock	132.45	132.45	132.45	132.45	100.0
2019-06-12 05:00:00	MSFT	Stock	131.42	131.42	131.42	131.42	100.0
2019-06-12 06:00:00	MSFT	Stock	131.32	131.7	131.32	131.69	1345.0
2019-06-12 07:00:00	MSFT	Stock	131.4	131.69	131.4	131.5	4275.0
2019-06-12 08:00:00	MSFT	Stock	131.58	132.43	131.58	131.69	20631.0
2019-06-12 09:00:00	MSFT	Stock	131.7	131.97	130.79	131.44	2335739.0
2019-06-12 10:00:00	MSFT	Stock	131.45	131.69	130.71	130.91	2420231.0
2019-06-12 11:00:00	MSFT	Stock	130.91	131.23	130.85	130.88	1694155.0
2019-06-12 12:00:00	MSFT	Stock	130.88	131.324	130.81	131.3	1366314.0
2019-06-12 13:00:00	MSFT	Stock	131.29	131.43	131.08	131.138	1050167.0
2019-06-12 14:00:00	MSFT	Stock	131.14	131.4	130.99	131.364	1303581.0
2019-06-12 15:00:00	MSFT	Stock	131.38	131.62	131.12	131.49	2307139.0
2019-06-12 16:00:00	MSFT	Stock	131.49	131.58	131.38	131.41	1776937.0
2019-06-12 17:00:00	MSFT	Stock	131.48	131.49	131.42	131.42	2099.0
2019-06-12 18:00:00	MSFT	Stock	131.5	131.55	131.45	131.55	1797.0
2019-06-12 19:00:00	MSFT	Stock	131.52	131.74	131.52	131.74	5169.0
2019-06-12 05:00:00	NVDA	Stock	3.7188	3.7188	3.7105	3.7105	46080.0
2019-06-12 06:00:00	NVDA	Stock	3.7	3.7	3.7	3.7	21400.0
2019-06-12 07:00:00	NVDA	Stock	3.7068	3.7312	3.7042	3.7185	377560.0
2019-06-12 08:00:00	NVDA	Stock	3.725	3.7362	3.7075	3.7188	910880.0
2019-06-12 09:00:00	NVDA	Stock	3.7188	3.7312	3.6848	3.6981	47432680.0
2019-06-12 10:00:00	NVDA	Stock	3.6988	3.7025	3.657	3.6637	58106480.0
2019-06-12 11:00:00	NVDA	Stock	3.6628	3.6812	3.6572	3.6582	47806960.0
2019-06-12 12:00:00	NVDA	Stock	3.6585	3.6838	3.6585	3.674	27296200.0
2019-06-12 13:00:00	NVDA	Stock	3.674	3.677	3.6583	3.6645	28136640.0
2019-06-12 14:00:00	NVDA	Stock	3.6642	3.6662	3.6403	3.6472	41843600.0
2019-06-12 15:00:00	NVDA	Stock	3.6476	3.6602	3.6398	3.6541	56709200.0
2019-06-12 16:00:00	NVDA	Stock	3.655	3.66	3.65	3.6575	18121680.0
2019-06-12 17:00:00	NVDA	Stock	3.6562	3.6562	3.6513	3.6538	228800.0
2019-06-12 18:00:00	NVDA	Stock	3.6525	3.6625	3.6525	3.66	575680.0
2019-06-12 19:00:00	NVDA	Stock	3.6588	3.6665	3.6588	3.66	222840.0
2019-06-12 05:00:00	AMZN	Stock	92.5515	92.5515	92.5	92.513	26040.0
2019-06-12 06:00:00	AMZN	Stock	92.55	92.55	92.4755	92.4755	20780.0
2019-06-12 07:00:00	AMZN	Stock	92.7	92.7	92.5	92.525	131200.0

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

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