PREVIEW / stock_1hour / 2020-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-06.parquet
  size:    1.2 MB
  rows:    53,820
  symbols: 2,385

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
2020-05-06 04:00:00	AAPL	Stock	74.7925	75.0	74.7925	74.875	16524.0
2020-05-06 05:00:00	AAPL	Stock	74.9275	75.065	74.9275	75.0	16408.0
2020-05-06 06:00:00	AAPL	Stock	75.0075	75.075	74.9025	74.9025	50044.0
2020-05-06 07:00:00	AAPL	Stock	74.885	75.07	74.885	74.96	194380.0
2020-05-06 08:00:00	AAPL	Stock	75.0125	75.06	74.7625	74.9408	484612.0
2020-05-06 09:00:00	AAPL	Stock	74.95	75.735	74.925	75.5	21231396.0
2020-05-06 10:00:00	AAPL	Stock	75.5	75.7125	74.7175	75.5	24103164.0
2020-05-06 11:00:00	AAPL	Stock	75.4938	75.775	75.375	75.6725	16467188.0
2020-05-06 12:00:00	AAPL	Stock	75.67	75.81	75.545	75.6825	11708528.0
2020-05-06 13:00:00	AAPL	Stock	75.6825	75.795	75.27	75.4775	11724960.0
2020-05-06 14:00:00	AAPL	Stock	75.4675	75.6675	75.2975	75.4588	9281316.0
2020-05-06 15:00:00	AAPL	Stock	75.455	75.68	75.125	75.125	16999560.0
2020-05-06 16:00:00	AAPL	Stock	75.1575	75.235	74.9725	75.055	4445468.0
2020-05-06 17:00:00	AAPL	Stock	75.0425	75.1575	75.0	75.0375	86016.0
2020-05-06 18:00:00	AAPL	Stock	75.0175	75.0875	74.7525	74.9125	120380.0
2020-05-06 19:00:00	AAPL	Stock	74.9125	75.0	74.8625	75.0	116656.0
2020-05-06 04:00:00	MSFT	Stock	181.43	182.4	181.43	182.0	3658.0
2020-05-06 05:00:00	MSFT	Stock	182.07	182.49	182.01	182.33	2556.0
2020-05-06 06:00:00	MSFT	Stock	182.48	182.62	182.36	182.36	617.0
2020-05-06 07:00:00	MSFT	Stock	182.48	182.48	181.82	182.0	21856.0
2020-05-06 08:00:00	MSFT	Stock	182.15	182.325	181.25	181.9	59664.0
2020-05-06 09:00:00	MSFT	Stock	181.91	183.87	181.7	182.68	4066490.0
2020-05-06 10:00:00	MSFT	Stock	182.73	183.9	181.631	183.55	5014384.0
2020-05-06 11:00:00	MSFT	Stock	183.55	183.897	182.65	183.27	3234062.0
2020-05-06 12:00:00	MSFT	Stock	183.27	183.93	182.93	183.71	2643595.0
2020-05-06 13:00:00	MSFT	Stock	183.72	184.2	183.25	183.61	2885850.0
2020-05-06 14:00:00	MSFT	Stock	183.605	183.95	183.22	183.402	2940295.0
2020-05-06 15:00:00	MSFT	Stock	183.41	183.77	181.98	182.49	5139968.0
2020-05-06 16:00:00	MSFT	Stock	182.54	183.492	182.0	182.3	1793443.0
2020-05-06 17:00:00	MSFT	Stock	182.23	182.44	182.21	182.3	6750.0
2020-05-06 18:00:00	MSFT	Stock	182.26	182.43	181.5	181.5	24955.0
2020-05-06 19:00:00	MSFT	Stock	181.7	182.1	181.57	182.01	10681.0
2020-05-06 04:00:00	NVDA	Stock	7.4125	7.4375	7.4125	7.4185	32720.0
2020-05-06 05:00:00	NVDA	Stock	7.4242	7.425	7.4178	7.425	24000.0
2020-05-06 07:00:00	NVDA	Stock	7.4178	7.445	7.4068	7.409	265640.0
2020-05-06 08:00:00	NVDA	Stock	7.42	7.4372	7.375	7.39	641760.0
2020-05-06 09:00:00	NVDA	Stock	7.3993	7.5165	7.3853	7.4611	49140880.0
2020-05-06 10:00:00	NVDA	Stock	7.4582	7.55	7.41	7.5252	58017760.0
2020-05-06 11:00:00	NVDA	Stock	7.5268	7.5438	7.4753	7.5022	29105160.0
2020-05-06 12:00:00	NVDA	Stock	7.5011	7.5225	7.485	7.5055	25454600.0
2020-05-06 13:00:00	NVDA	Stock	7.5088	7.5402	7.4798	7.5332	20624440.0
2020-05-06 14:00:00	NVDA	Stock	7.5323	7.5336	7.4865	7.49	18264760.0
2020-05-06 15:00:00	NVDA	Stock	7.4892	7.5073	7.4358	7.4438	49775160.0
2020-05-06 16:00:00	NVDA	Stock	7.4408	7.5009	7.4338	7.4375	12915640.0
2020-05-06 17:00:00	NVDA	Stock	7.4412	7.4448	7.4345	7.4428	110040.0
2020-05-06 18:00:00	NVDA	Stock	7.4448	7.4448	7.4208	7.4208	184600.0
2020-05-06 19:00:00	NVDA	Stock	7.413	7.4368	7.413	7.425	78680.0
2020-05-06 06:00:00	AMZN	Stock	117.0	117.0	116.6	116.6	8360.0
2020-05-06 07:00:00	AMZN	Stock	116.55	116.645	116.55	116.55	7000.0
2020-05-06 08:00:00	AMZN	Stock	116.55	116.55	116.1515	116.3	70500.0

> showing 50 of 53,820 rows — these rows as CSV

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