PREVIEW / stock_1hour / 2018-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-21.parquet
  size:    1.1 MB
  rows:    49,311
  symbols: 2,824

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-06-21 04:00:00	AAPL	Stock	46.8325	46.8325	46.8325	46.8325	400.0
2018-06-21 05:00:00	AAPL	Stock	46.75	46.75	46.6025	46.6625	10320.0
2018-06-21 06:00:00	AAPL	Stock	46.6575	46.76	46.6575	46.76	11108.0
2018-06-21 07:00:00	AAPL	Stock	46.8875	46.965	46.755	46.9625	123012.0
2018-06-21 08:00:00	AAPL	Stock	46.8495	46.98	46.785	46.845	317952.0
2018-06-21 09:00:00	AAPL	Stock	46.8325	47.0875	46.74	46.9475	9506152.0
2018-06-21 10:00:00	AAPL	Stock	46.9438	46.945	46.615	46.665	13613216.0
2018-06-21 11:00:00	AAPL	Stock	46.6625	46.81	46.5825	46.6675	7560404.0
2018-06-21 12:00:00	AAPL	Stock	46.665	46.67	46.2725	46.3225	11267064.0
2018-06-21 13:00:00	AAPL	Stock	46.3225	46.405	46.2825	46.3212	6319596.0
2018-06-21 14:00:00	AAPL	Stock	46.32	46.4	46.2675	46.2675	6323880.0
2018-06-21 15:00:00	AAPL	Stock	46.2675	46.3925	46.235	46.3675	12489644.0
2018-06-21 16:00:00	AAPL	Stock	46.365	46.365	46.255	46.255	8960184.0
2018-06-21 17:00:00	AAPL	Stock	46.2855	46.3092	46.2375	46.2775	64320.0
2018-06-21 18:00:00	AAPL	Stock	46.2875	46.3125	46.255	46.255	45276.0
2018-06-21 19:00:00	AAPL	Stock	46.2875	46.2875	46.25	46.27	19436.0
2018-06-21 04:00:00	MSFT	Stock	102.05	102.05	102.05	102.05	100.0
2018-06-21 06:00:00	MSFT	Stock	101.87	101.88	101.87	101.88	379.0
2018-06-21 07:00:00	MSFT	Stock	101.93	102.07	101.87	101.88	5029.0
2018-06-21 08:00:00	MSFT	Stock	102.01	102.08	101.51	101.87	26267.0
2018-06-21 09:00:00	MSFT	Stock	101.78	102.46	101.63	102.17	2548538.0
2018-06-21 10:00:00	MSFT	Stock	102.17	102.17	100.98	101.64	3625026.0
2018-06-21 11:00:00	MSFT	Stock	101.64	101.8	101.35	101.75	2064386.0
2018-06-21 12:00:00	MSFT	Stock	101.75	101.76	101.14	101.17	1874197.0
2018-06-21 13:00:00	MSFT	Stock	101.17	101.555	101.11	101.295	1309134.0
2018-06-21 14:00:00	MSFT	Stock	101.29	101.44	101.16	101.17	1264688.0
2018-06-21 15:00:00	MSFT	Stock	101.16	101.38	100.88	101.15	3732129.0
2018-06-21 16:00:00	MSFT	Stock	101.14	101.15	99.8	99.9	2626436.0
2018-06-21 17:00:00	MSFT	Stock	99.8	100.0	99.3	99.65	57590.0
2018-06-21 18:00:00	MSFT	Stock	99.85	100.1	99.77	100.1	11008.0
2018-06-21 19:00:00	MSFT	Stock	100.04	100.33	99.95	100.1	8229.0
2018-06-21 04:00:00	NVDA	Stock	6.59	6.59	6.59	6.59	6000.0
2018-06-21 05:00:00	NVDA	Stock	6.5622	6.5645	6.56	6.5603	90000.0
2018-06-21 07:00:00	NVDA	Stock	6.5575	6.5793	6.5575	6.5718	748920.0
2018-06-21 08:00:00	NVDA	Stock	6.5805	6.5805	6.55	6.5578	1258680.0
2018-06-21 09:00:00	NVDA	Stock	6.5655	6.6198	6.5422	6.5592	50292320.0
2018-06-21 10:00:00	NVDA	Stock	6.5591	6.561	6.4625	6.4688	58782360.0
2018-06-21 11:00:00	NVDA	Stock	6.4697	6.4928	6.451	6.4752	43841520.0
2018-06-21 12:00:00	NVDA	Stock	6.4762	6.4823	6.4361	6.4378	28167320.0
2018-06-21 13:00:00	NVDA	Stock	6.4375	6.468	6.4248	6.4468	27871280.0
2018-06-21 14:00:00	NVDA	Stock	6.4463	6.4623	6.4425	6.4428	19104000.0
2018-06-21 15:00:00	NVDA	Stock	6.4425	6.457	6.42	6.4298	58773880.0
2018-06-21 16:00:00	NVDA	Stock	6.4278	6.435	6.419	6.4245	18778120.0
2018-06-21 17:00:00	NVDA	Stock	6.4198	6.4252	6.4088	6.4125	153080.0
2018-06-21 18:00:00	NVDA	Stock	6.4118	6.4118	6.4002	6.407	175120.0
2018-06-21 19:00:00	NVDA	Stock	6.402	6.4125	6.4	6.4	262640.0
2018-06-21 04:00:00	AMZN	Stock	87.988	88.0	87.95	87.955	19200.0
2018-06-21 05:00:00	AMZN	Stock	87.8155	87.8155	87.7	87.7315	25620.0
2018-06-21 06:00:00	AMZN	Stock	87.6015	87.7	87.6015	87.7	19020.0
2018-06-21 07:00:00	AMZN	Stock	87.718	87.8565	87.7	87.8055	124880.0

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

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