PREVIEW / stock_1hour / 2020-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-29.parquet
  size:    1.2 MB
  rows:    55,358
  symbols: 2,383

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-29 04:00:00	AAPL	Stock	79.5225	79.63	79.315	79.525	14436.0
2020-05-29 05:00:00	AAPL	Stock	79.5475	79.75	79.545	79.75	16108.0
2020-05-29 06:00:00	AAPL	Stock	79.7675	79.925	79.76	79.925	19100.0
2020-05-29 07:00:00	AAPL	Stock	79.815	80.2225	79.7275	80.175	190924.0
2020-05-29 08:00:00	AAPL	Stock	79.7875	80.3125	79.7262	79.8752	359220.0
2020-05-29 09:00:00	AAPL	Stock	79.86	80.0	79.5	79.595	11645724.0
2020-05-29 10:00:00	AAPL	Stock	79.585	79.695	79.1175	79.5188	14061128.0
2020-05-29 11:00:00	AAPL	Stock	79.52	79.7905	79.2425	79.76	9913640.0
2020-05-29 12:00:00	AAPL	Stock	79.765	79.8875	79.2675	79.7725	10890344.0
2020-05-29 13:00:00	AAPL	Stock	79.765	79.895	79.5675	79.7125	6295468.0
2020-05-29 14:00:00	AAPL	Stock	79.7025	80.065	79.135	79.9415	16839000.0
2020-05-29 15:00:00	AAPL	Stock	79.9575	80.2875	79.365	79.48	27506376.0
2020-05-29 16:00:00	AAPL	Stock	79.4775	79.825	79.43	79.825	29207688.0
2020-05-29 17:00:00	AAPL	Stock	79.825	79.87	79.7725	79.7725	147780.0
2020-05-29 18:00:00	AAPL	Stock	79.755	79.755	79.715	79.725	61232.0
2020-05-29 19:00:00	AAPL	Stock	79.73	79.775	79.715	79.75	23136.0
2020-05-29 04:00:00	MSFT	Stock	180.35	181.18	180.35	180.97	5291.0
2020-05-29 05:00:00	MSFT	Stock	180.8	181.2	180.8	181.2	4047.0
2020-05-29 06:00:00	MSFT	Stock	181.62	181.65	181.62	181.65	308.0
2020-05-29 07:00:00	MSFT	Stock	181.35	182.75	181.35	182.75	18451.0
2020-05-29 08:00:00	MSFT	Stock	182.0	183.26	181.52	182.2	46500.0
2020-05-29 09:00:00	MSFT	Stock	182.2	183.58	181.87	183.08	2946500.0
2020-05-29 10:00:00	MSFT	Stock	183.07	183.105	180.77	181.19	4396633.0
2020-05-29 11:00:00	MSFT	Stock	181.2	181.94	180.41	181.87	3397642.0
2020-05-29 12:00:00	MSFT	Stock	181.88	182.43	180.43	182.07	2410605.0
2020-05-29 13:00:00	MSFT	Stock	182.12	182.37	181.67	182.28	1761055.0
2020-05-29 14:00:00	MSFT	Stock	182.286	183.5	181.32	183.49	3488952.0
2020-05-29 15:00:00	MSFT	Stock	183.49	184.27	182.92	183.26	7463213.0
2020-05-29 16:00:00	MSFT	Stock	183.22	184.2	182.669	183.85	10015188.0
2020-05-29 17:00:00	MSFT	Stock	183.8	183.99	183.61	183.9	11912.0
2020-05-29 18:00:00	MSFT	Stock	183.89	183.89	183.61	183.79	5659.0
2020-05-29 19:00:00	MSFT	Stock	183.79	184.0	183.65	183.7	6239.0
2020-05-29 04:00:00	NVDA	Stock	8.425	8.425	8.4045	8.4058	144240.0
2020-05-29 05:00:00	NVDA	Stock	8.4688	8.4688	8.4688	8.4688	8000.0
2020-05-29 06:00:00	NVDA	Stock	8.5043	8.5043	8.4848	8.4848	69720.0
2020-05-29 07:00:00	NVDA	Stock	8.4935	8.5925	8.4822	8.575	923320.0
2020-05-29 08:00:00	NVDA	Stock	8.4899	8.614	8.4822	8.5513	1754360.0
2020-05-29 09:00:00	NVDA	Stock	8.5522	8.6747	8.506	8.6384	92190280.0
2020-05-29 10:00:00	NVDA	Stock	8.638	8.6562	8.485	8.598	103127360.0
2020-05-29 11:00:00	NVDA	Stock	8.5988	8.6388	8.5338	8.6161	60070040.0
2020-05-29 12:00:00	NVDA	Stock	8.6198	8.64	8.55	8.6147	47813480.0
2020-05-29 13:00:00	NVDA	Stock	8.6168	8.6498	8.5715	8.6018	47941800.0
2020-05-29 14:00:00	NVDA	Stock	8.6025	8.6635	8.515	8.6453	88904520.0
2020-05-29 15:00:00	NVDA	Stock	8.647	8.8668	8.647	8.8412	186548480.0
2020-05-29 16:00:00	NVDA	Stock	8.8418	8.88	8.699	8.8725	14613200.0
2020-05-29 17:00:00	NVDA	Stock	8.8725	8.8775	8.865	8.875	4941840.0
2020-05-29 18:00:00	NVDA	Stock	8.8625	8.8675	8.8518	8.8538	205360.0
2020-05-29 19:00:00	NVDA	Stock	8.8538	8.86	8.85	8.853	278840.0
2020-05-29 04:00:00	AMZN	Stock	119.5755	119.5755	119.5755	119.5755	9040.0
2020-05-29 07:00:00	AMZN	Stock	120.3115	120.422	120.3115	120.422	16340.0

> showing 50 of 55,358 rows — these rows as CSV

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