PREVIEW / stock_1hour / 2021-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-01.parquet
  size:    1.4 MB
  rows:    67,035
  symbols: 2,949

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
2021-04-01 04:00:00	AAPL	Stock	123.45	123.79	123.2	123.63	52280.0
2021-04-01 05:00:00	AAPL	Stock	123.56	123.64	123.33	123.5	30974.0
2021-04-01 06:00:00	AAPL	Stock	123.6	123.61	123.18	123.23	12605.0
2021-04-01 07:00:00	AAPL	Stock	123.15	123.53	123.09	123.32	212874.0
2021-04-01 08:00:00	AAPL	Stock	123.2899	123.68	122.15	123.52	479182.0
2021-04-01 09:00:00	AAPL	Stock	123.51	124.18	122.15	123.59	11427138.0
2021-04-01 10:00:00	AAPL	Stock	123.58	123.67	123.0	123.452	10458203.0
2021-04-01 11:00:00	AAPL	Stock	123.45	123.7	122.89	122.9005	8249938.0
2021-04-01 12:00:00	AAPL	Stock	122.9	123.44	122.84	123.188	5979031.0
2021-04-01 13:00:00	AAPL	Stock	123.185	123.2426	122.62	122.67	6236235.0
2021-04-01 14:00:00	AAPL	Stock	122.67	122.96	122.57	122.675	5760792.0
2021-04-01 15:00:00	AAPL	Stock	122.674	123.0	122.49	122.99	10324993.0
2021-04-01 16:00:00	AAPL	Stock	123.0	123.01	122.9	122.92	6144181.0
2021-04-01 17:00:00	AAPL	Stock	122.9499	123.0	122.93	122.98	34451.0
2021-04-01 18:00:00	AAPL	Stock	122.99	123.06	122.94	122.98	60849.0
2021-04-01 19:00:00	AAPL	Stock	122.98	123.09	122.85	123.0	88656.0
2021-04-01 04:00:00	MSFT	Stock	238.82	238.97	238.5	238.5	6879.0
2021-04-01 05:00:00	MSFT	Stock	238.5	238.75	238.3	238.56	10729.0
2021-04-01 06:00:00	MSFT	Stock	238.53	238.56	238.01	238.53	19561.0
2021-04-01 07:00:00	MSFT	Stock	238.56	238.65	238.27	238.47	37108.0
2021-04-01 08:00:00	MSFT	Stock	238.4504	238.8	235.77	238.33	87160.0
2021-04-01 09:00:00	MSFT	Stock	238.32	241.425	235.77	241.4238	4296890.0
2021-04-01 10:00:00	MSFT	Stock	241.425	242.06	240.56	241.83	4527782.0
2021-04-01 11:00:00	MSFT	Stock	241.81	241.9656	240.75	241.46	2410952.0
2021-04-01 12:00:00	MSFT	Stock	241.45	241.67	240.82	241.61	1690352.0
2021-04-01 13:00:00	MSFT	Stock	241.62	241.9299	241.2084	241.74	1762008.0
2021-04-01 14:00:00	MSFT	Stock	241.7399	242.1	241.61	241.885	1923896.0
2021-04-01 15:00:00	MSFT	Stock	241.88	242.64	241.22	242.35	3819689.0
2021-04-01 16:00:00	MSFT	Stock	242.84	242.84	242.18	242.5	2692593.0
2021-04-01 17:00:00	MSFT	Stock	242.47	242.61	242.35	242.35	23450.0
2021-04-01 18:00:00	MSFT	Stock	242.35	242.45	242.1	242.4	10718.0
2021-04-01 19:00:00	MSFT	Stock	242.3	242.58	242.28	242.55	8864.0
2021-04-01 04:00:00	NVDA	Stock	13.5262	13.5525	13.5262	13.5525	63800.0
2021-04-01 05:00:00	NVDA	Stock	13.55	13.55	13.55	13.55	9160.0
2021-04-01 06:00:00	NVDA	Stock	13.5363	13.5363	13.5363	13.5363	7840.0
2021-04-01 07:00:00	NVDA	Stock	13.5363	13.55	13.5125	13.55	243520.0
2021-04-01 08:00:00	NVDA	Stock	13.5125	13.5738	13.3482	13.545	489360.0
2021-04-01 09:00:00	NVDA	Stock	13.5612	13.712	13.5113	13.6795	35257280.0
2021-04-01 10:00:00	NVDA	Stock	13.6798	13.73	13.583	13.7003	23736280.0
2021-04-01 11:00:00	NVDA	Stock	13.7002	13.7342	13.6442	13.6648	16671480.0
2021-04-01 12:00:00	NVDA	Stock	13.6643	13.7912	13.6572	13.7875	22261680.0
2021-04-01 13:00:00	NVDA	Stock	13.7893	13.8217	13.7485	13.8045	17408800.0
2021-04-01 14:00:00	NVDA	Stock	13.8048	13.87	13.7626	13.845	16457640.0
2021-04-01 15:00:00	NVDA	Stock	13.8452	13.857	13.752	13.8182	32714840.0
2021-04-01 16:00:00	NVDA	Stock	13.8118	13.8125	13.7842	13.8002	16173520.0
2021-04-01 17:00:00	NVDA	Stock	13.8038	13.807	13.795	13.807	119520.0
2021-04-01 18:00:00	NVDA	Stock	13.8078	13.8215	13.8	13.8215	243680.0
2021-04-01 19:00:00	NVDA	Stock	13.8012	13.83	13.8012	13.8068	134880.0
2021-04-01 05:00:00	AMZN	Stock	155.6	155.6	155.6	155.6	2000.0
2021-04-01 06:00:00	AMZN	Stock	155.74	155.74	155.74	155.74	2000.0

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

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