PREVIEW / stock_1hour / 2019-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-09.parquet
  size:    1.1 MB
  rows:    49,855
  symbols: 2,565

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-09-09 04:00:00	AAPL	Stock	53.425	53.45	53.3475	53.45	6652.0
2019-09-09 05:00:00	AAPL	Stock	53.415	53.45	53.415	53.45	1600.0
2019-09-09 06:00:00	AAPL	Stock	53.5325	53.575	53.5325	53.55	9424.0
2019-09-09 07:00:00	AAPL	Stock	53.5225	53.64	53.5	53.585	145012.0
2019-09-09 08:00:00	AAPL	Stock	53.55	53.69	53.5	53.65	275032.0
2019-09-09 09:00:00	AAPL	Stock	53.6575	54.01	53.6062	53.8038	15232396.0
2019-09-09 10:00:00	AAPL	Stock	53.8025	53.87	53.66	53.83	10862328.0
2019-09-09 11:00:00	AAPL	Stock	53.8325	54.11	53.795	54.0838	9366856.0
2019-09-09 12:00:00	AAPL	Stock	54.085	54.095	53.34	53.7825	12734192.0
2019-09-09 13:00:00	AAPL	Stock	53.7842	53.8	53.4625	53.6425	7030652.0
2019-09-09 14:00:00	AAPL	Stock	53.6425	53.6425	53.4675	53.5712	7351140.0
2019-09-09 15:00:00	AAPL	Stock	53.5705	53.725	52.7675	53.5375	11636120.0
2019-09-09 16:00:00	AAPL	Stock	53.5425	53.59	53.5025	53.55	9816048.0
2019-09-09 17:00:00	AAPL	Stock	53.57	53.6048	53.5425	53.6048	29304.0
2019-09-09 18:00:00	AAPL	Stock	53.605	53.65	53.605	53.645	13028.0
2019-09-09 19:00:00	AAPL	Stock	53.635	53.65	53.6125	53.6375	31732.0
2019-09-09 04:00:00	MSFT	Stock	139.55	139.55	139.5	139.5	250.0
2019-09-09 05:00:00	MSFT	Stock	139.6	139.6	139.6	139.6	391.0
2019-09-09 06:00:00	MSFT	Stock	139.6	139.7	139.55	139.55	2616.0
2019-09-09 07:00:00	MSFT	Stock	139.43	139.6	139.43	139.5	6245.0
2019-09-09 08:00:00	MSFT	Stock	139.4	139.75	139.37	139.7	14948.0
2019-09-09 09:00:00	MSFT	Stock	139.7	139.77	137.27	137.46	3561375.0
2019-09-09 10:00:00	MSFT	Stock	137.45	138.05	137.01	138.01	4440419.0
2019-09-09 11:00:00	MSFT	Stock	138.0	138.1	137.63	137.905	1695548.0
2019-09-09 12:00:00	MSFT	Stock	137.91	137.97	136.63	137.094	2524840.0
2019-09-09 13:00:00	MSFT	Stock	137.09	137.179	136.46	136.84	1627001.0
2019-09-09 14:00:00	MSFT	Stock	136.847	136.889	136.51	136.68	1321624.0
2019-09-09 15:00:00	MSFT	Stock	136.68	137.74	136.6	137.58	3556590.0
2019-09-09 16:00:00	MSFT	Stock	137.52	137.7	137.4	137.43	2652365.0
2019-09-09 17:00:00	MSFT	Stock	137.45	137.49	137.4	137.4	3645.0
2019-09-09 18:00:00	MSFT	Stock	137.49	137.57	137.4	137.52	3605.0
2019-09-09 19:00:00	MSFT	Stock	137.52	137.59	137.52	137.59	4656.0
2019-09-09 04:00:00	NVDA	Stock	4.493	4.493	4.493	4.493	4000.0
2019-09-09 05:00:00	NVDA	Stock	4.4918	4.4918	4.4888	4.4888	12000.0
2019-09-09 06:00:00	NVDA	Stock	4.486	4.4922	4.486	4.4922	21680.0
2019-09-09 07:00:00	NVDA	Stock	4.4925	4.505	4.4873	4.505	128880.0
2019-09-09 08:00:00	NVDA	Stock	4.4968	4.5097	4.4875	4.506	591720.0
2019-09-09 09:00:00	NVDA	Stock	4.505	4.556	4.4925	4.5126	56215320.0
2019-09-09 10:00:00	NVDA	Stock	4.5138	4.5943	4.5132	4.5758	64531400.0
2019-09-09 11:00:00	NVDA	Stock	4.5758	4.5995	4.5755	4.5812	59175080.0
2019-09-09 12:00:00	NVDA	Stock	4.5818	4.5855	4.4985	4.5205	53548800.0
2019-09-09 13:00:00	NVDA	Stock	4.5215	4.5335	4.5008	4.5135	25378240.0
2019-09-09 14:00:00	NVDA	Stock	4.5136	4.5168	4.4968	4.5093	25188560.0
2019-09-09 15:00:00	NVDA	Stock	4.5093	4.5375	4.5055	4.511	55921640.0
2019-09-09 16:00:00	NVDA	Stock	4.5125	4.5238	4.5125	4.52	9751320.0
2019-09-09 17:00:00	NVDA	Stock	4.52	4.525	4.52	4.5248	140200.0
2019-09-09 18:00:00	NVDA	Stock	4.525	4.5265	4.525	4.525	77680.0
2019-09-09 19:00:00	NVDA	Stock	4.525	4.53	4.5138	4.5138	257600.0
2019-09-09 04:00:00	AMZN	Stock	91.8515	91.9015	91.8515	91.9015	21700.0
2019-09-09 05:00:00	AMZN	Stock	92.0875	92.0875	92.0875	92.0875	4720.0

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

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