PREVIEW / stock_1hour / 2019-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-07.parquet
  size:    1.1 MB
  rows:    49,035
  symbols: 2,607

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-07 04:00:00	AAPL	Stock	46.4275	46.625	46.4275	46.625	21692.0
2019-06-07 05:00:00	AAPL	Stock	46.63	46.6575	46.63	46.6575	4356.0
2019-06-07 06:00:00	AAPL	Stock	46.65	46.655	46.585	46.6	31120.0
2019-06-07 07:00:00	AAPL	Stock	46.5925	46.615	46.4675	46.4675	68036.0
2019-06-07 08:00:00	AAPL	Stock	46.6118	46.9	46.305	46.595	898844.0
2019-06-07 09:00:00	AAPL	Stock	46.5525	47.165	46.4425	47.1438	15709020.0
2019-06-07 10:00:00	AAPL	Stock	47.1425	47.9125	47.1312	47.9125	24533108.0
2019-06-07 11:00:00	AAPL	Stock	47.9125	47.98	47.5775	47.6225	16633092.0
2019-06-07 12:00:00	AAPL	Stock	47.615	47.64	47.4925	47.565	8659256.0
2019-06-07 13:00:00	AAPL	Stock	47.5675	47.6375	47.4925	47.6225	7479256.0
2019-06-07 14:00:00	AAPL	Stock	47.6175	47.6262	47.4525	47.4878	7353168.0
2019-06-07 15:00:00	AAPL	Stock	47.4875	47.56	47.4475	47.535	17417464.0
2019-06-07 16:00:00	AAPL	Stock	47.5375	47.55	47.4925	47.525	8341412.0
2019-06-07 17:00:00	AAPL	Stock	47.5372	47.5375	47.5	47.5	28740.0
2019-06-07 18:00:00	AAPL	Stock	47.5025	47.5225	47.4625	47.5175	49092.0
2019-06-07 19:00:00	AAPL	Stock	47.5175	47.5625	47.5175	47.5625	48820.0
2019-06-07 04:00:00	MSFT	Stock	128.0	128.36	128.0	128.22	1462.0
2019-06-07 05:00:00	MSFT	Stock	128.5	128.5	128.44	128.44	1005.0
2019-06-07 06:00:00	MSFT	Stock	128.49	128.56	128.49	128.56	3027.0
2019-06-07 07:00:00	MSFT	Stock	128.57	128.68	128.29	128.29	5664.0
2019-06-07 08:00:00	MSFT	Stock	128.48	128.85	127.7	128.32	100996.0
2019-06-07 09:00:00	MSFT	Stock	128.3	130.85	128.15	130.67	4987528.0
2019-06-07 10:00:00	MSFT	Stock	130.69	132.14	130.58	131.945	6644203.0
2019-06-07 11:00:00	MSFT	Stock	131.945	132.25	131.41	131.61	3766764.0
2019-06-07 12:00:00	MSFT	Stock	131.59	131.91	131.4	131.905	2515628.0
2019-06-07 13:00:00	MSFT	Stock	131.91	131.94	131.51	131.695	2135956.0
2019-06-07 14:00:00	MSFT	Stock	131.69	131.98	131.46	131.5	2121309.0
2019-06-07 15:00:00	MSFT	Stock	131.5	131.82	131.17	131.4	4202191.0
2019-06-07 16:00:00	MSFT	Stock	131.4	131.58	131.31	131.58	3366001.0
2019-06-07 17:00:00	MSFT	Stock	131.55	131.55	131.35	131.45	4354.0
2019-06-07 18:00:00	MSFT	Stock	131.5	131.5	131.36	131.45	1963.0
2019-06-07 19:00:00	MSFT	Stock	131.48	131.58	131.45	131.45	5863.0
2019-06-07 04:00:00	NVDA	Stock	3.6125	3.625	3.6125	3.625	44880.0
2019-06-07 05:00:00	NVDA	Stock	3.6175	3.625	3.6175	3.625	86520.0
2019-06-07 06:00:00	NVDA	Stock	3.625	3.625	3.6168	3.6168	35840.0
2019-06-07 07:00:00	NVDA	Stock	3.6188	3.6188	3.58	3.58	647520.0
2019-06-07 08:00:00	NVDA	Stock	3.6025	3.6245	3.5738	3.6012	2927880.0
2019-06-07 09:00:00	NVDA	Stock	3.6	3.6288	3.5812	3.6288	57298280.0
2019-06-07 10:00:00	NVDA	Stock	3.6288	3.6652	3.6144	3.6638	63876480.0
2019-06-07 11:00:00	NVDA	Stock	3.664	3.6678	3.6352	3.6508	44736200.0
2019-06-07 12:00:00	NVDA	Stock	3.6499	3.6705	3.649	3.66	27673000.0
2019-06-07 13:00:00	NVDA	Stock	3.6604	3.672	3.6548	3.672	26378640.0
2019-06-07 14:00:00	NVDA	Stock	3.6712	3.672	3.646	3.6475	25761560.0
2019-06-07 15:00:00	NVDA	Stock	3.6478	3.6558	3.634	3.6375	50190680.0
2019-06-07 16:00:00	NVDA	Stock	3.632	3.6412	3.632	3.6362	17698640.0
2019-06-07 17:00:00	NVDA	Stock	3.6385	3.6385	3.6338	3.636	91760.0
2019-06-07 18:00:00	NVDA	Stock	3.6358	3.6375	3.635	3.6375	176080.0
2019-06-07 19:00:00	NVDA	Stock	3.637	3.6375	3.634	3.6375	256920.0
2019-06-07 05:00:00	AMZN	Stock	88.4065	88.425	88.4065	88.425	4000.0
2019-06-07 06:00:00	AMZN	Stock	88.424	88.424	88.375	88.375	4000.0

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

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