PREVIEW / stock_1hour / 2019-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-14.parquet
  size:    1.1 MB
  rows:    48,314
  symbols: 2,497

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-10-14 04:00:00	AAPL	Stock	59.1625	59.1625	59.005	59.1	9148.0
2019-10-14 05:00:00	AAPL	Stock	59.0325	59.0325	58.45	58.5925	102544.0
2019-10-14 06:00:00	AAPL	Stock	58.6025	58.75	58.54	58.75	32084.0
2019-10-14 07:00:00	AAPL	Stock	58.68	59.055	58.68	59.055	258708.0
2019-10-14 08:00:00	AAPL	Stock	58.9545	59.075	58.725	58.9625	403564.0
2019-10-14 09:00:00	AAPL	Stock	58.9625	59.3175	58.6675	59.29	14887996.0
2019-10-14 10:00:00	AAPL	Stock	59.29	59.5335	59.27	59.4738	16666572.0
2019-10-14 11:00:00	AAPL	Stock	59.4745	59.4875	59.2325	59.25	10744916.0
2019-10-14 12:00:00	AAPL	Stock	59.247	59.2622	59.019	59.0875	8909812.0
2019-10-14 13:00:00	AAPL	Stock	59.0825	59.1875	59.0588	59.1738	6171932.0
2019-10-14 14:00:00	AAPL	Stock	59.1725	59.2175	59.015	59.06	5160184.0
2019-10-14 15:00:00	AAPL	Stock	59.055	59.1075	58.915	58.9725	11743924.0
2019-10-14 16:00:00	AAPL	Stock	58.9675	59.1372	58.85	58.975	6184728.0
2019-10-14 17:00:00	AAPL	Stock	58.9775	59.0	58.9625	58.975	20612.0
2019-10-14 18:00:00	AAPL	Stock	58.975	59.0325	58.975	59.0325	71560.0
2019-10-14 19:00:00	AAPL	Stock	59.03	59.1225	59.03	59.1125	122968.0
2019-10-14 04:00:00	MSFT	Stock	140.0	140.0	139.75	139.75	619.0
2019-10-14 05:00:00	MSFT	Stock	139.67	139.67	139.05	139.1	3298.0
2019-10-14 06:00:00	MSFT	Stock	139.17	139.18	139.17	139.18	200.0
2019-10-14 07:00:00	MSFT	Stock	139.49	139.72	139.38	139.72	10541.0
2019-10-14 08:00:00	MSFT	Stock	139.44	139.83	139.36	139.68	21900.0
2019-10-14 09:00:00	MSFT	Stock	139.65	140.29	139.5	139.91	1710911.0
2019-10-14 10:00:00	MSFT	Stock	139.9	140.21	139.59	140.16	1635062.0
2019-10-14 11:00:00	MSFT	Stock	140.17	140.17	139.82	139.93	1193670.0
2019-10-14 12:00:00	MSFT	Stock	139.928	140.01	139.582	139.67	882657.0
2019-10-14 13:00:00	MSFT	Stock	139.65	139.85	139.52	139.81	773104.0
2019-10-14 14:00:00	MSFT	Stock	139.81	139.99	139.72	139.89	821870.0
2019-10-14 15:00:00	MSFT	Stock	139.885	139.96	139.53	139.54	1958738.0
2019-10-14 16:00:00	MSFT	Stock	139.57	139.7	139.53	139.6	2889808.0
2019-10-14 17:00:00	MSFT	Stock	139.596	139.6	139.59	139.6	387.0
2019-10-14 18:00:00	MSFT	Stock	139.63	139.74	139.63	139.73	6841.0
2019-10-14 19:00:00	MSFT	Stock	139.74	139.85	139.68	139.82	12318.0
2019-10-14 04:00:00	NVDA	Stock	4.645	4.653	4.645	4.65	20320.0
2019-10-14 05:00:00	NVDA	Stock	4.655	4.6562	4.65	4.65	71480.0
2019-10-14 06:00:00	NVDA	Stock	4.632	4.6328	4.632	4.6328	8000.0
2019-10-14 07:00:00	NVDA	Stock	4.625	4.6488	4.625	4.6485	136080.0
2019-10-14 08:00:00	NVDA	Stock	4.645	4.6488	4.6288	4.6325	713800.0
2019-10-14 09:00:00	NVDA	Stock	4.6425	4.6663	4.6153	4.6319	25493080.0
2019-10-14 10:00:00	NVDA	Stock	4.633	4.6461	4.6096	4.6397	35666640.0
2019-10-14 11:00:00	NVDA	Stock	4.6408	4.6562	4.6345	4.6556	16129080.0
2019-10-14 12:00:00	NVDA	Stock	4.6548	4.6603	4.6373	4.6489	18105240.0
2019-10-14 13:00:00	NVDA	Stock	4.649	4.6625	4.6484	4.6565	9436720.0
2019-10-14 14:00:00	NVDA	Stock	4.6565	4.6658	4.6554	4.66	13599760.0
2019-10-14 15:00:00	NVDA	Stock	4.6595	4.6843	4.6592	4.6635	37572720.0
2019-10-14 16:00:00	NVDA	Stock	4.6633	4.6738	4.6633	4.6633	24652560.0
2019-10-14 17:00:00	NVDA	Stock	4.665	4.6682	4.6648	4.6675	73120.0
2019-10-14 18:00:00	NVDA	Stock	4.6663	4.67	4.6663	4.6688	22280.0
2019-10-14 19:00:00	NVDA	Stock	4.6715	4.6845	4.6697	4.6697	169280.0
2019-10-14 06:00:00	AMZN	Stock	86.2	86.2	86.2	86.2	2000.0
2019-10-14 07:00:00	AMZN	Stock	86.2945	86.45	86.2945	86.45	44160.0

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

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