PREVIEW / stock_1hour / 2020-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-05.parquet
  size:    1.3 MB
  rows:    58,412
  symbols: 2,409

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-06-05 04:00:00	AAPL	Stock	81.0725	81.225	80.8675	81.0225	33972.0
2020-06-05 05:00:00	AAPL	Stock	81.025	81.05	80.875	80.9625	13764.0
2020-06-05 06:00:00	AAPL	Stock	80.9625	80.9625	80.875	80.9	13412.0
2020-06-05 07:00:00	AAPL	Stock	80.9025	80.9875	80.75	80.775	204264.0
2020-06-05 08:00:00	AAPL	Stock	80.9255	81.1125	80.387	80.7475	766364.0
2020-06-05 09:00:00	AAPL	Stock	80.75	82.0	80.75	81.6975	16933940.0
2020-06-05 10:00:00	AAPL	Stock	81.705	82.0	81.43	81.9875	13131172.0
2020-06-05 11:00:00	AAPL	Stock	81.99	82.45	81.9058	82.4048	14647188.0
2020-06-05 12:00:00	AAPL	Stock	82.403	82.5	82.2525	82.4875	10092356.0
2020-06-05 13:00:00	AAPL	Stock	82.48	82.78	82.365	82.5775	11278544.0
2020-06-05 14:00:00	AAPL	Stock	82.575	82.6775	82.3125	82.5612	10233612.0
2020-06-05 15:00:00	AAPL	Stock	82.5625	82.9375	82.455	82.875	21316160.0
2020-06-05 16:00:00	AAPL	Stock	82.9225	82.9225	78.75	82.8125	11555792.0
2020-06-05 17:00:00	AAPL	Stock	82.795	82.825	82.725	82.7275	127968.0
2020-06-05 18:00:00	AAPL	Stock	82.7275	82.7825	82.7225	82.725	24384.0
2020-06-05 19:00:00	AAPL	Stock	82.7275	82.7625	82.7225	82.7225	49492.0
2020-06-05 04:00:00	MSFT	Stock	183.67	184.4	183.67	184.4	1858.0
2020-06-05 05:00:00	MSFT	Stock	184.0	184.0	184.0	184.0	700.0
2020-06-05 06:00:00	MSFT	Stock	183.46	183.6	183.31	183.31	1194.0
2020-06-05 07:00:00	MSFT	Stock	183.54	183.55	182.95	182.95	40305.0
2020-06-05 08:00:00	MSFT	Stock	183.3	183.55	181.75	182.8	209573.0
2020-06-05 09:00:00	MSFT	Stock	182.88	185.265	182.01	185.04	4941881.0
2020-06-05 10:00:00	MSFT	Stock	185.05	185.39	183.87	185.05	4737895.0
2020-06-05 11:00:00	MSFT	Stock	185.055	186.0	184.98	185.785	3766952.0
2020-06-05 12:00:00	MSFT	Stock	185.78	186.5	185.67	186.39	3288421.0
2020-06-05 13:00:00	MSFT	Stock	186.38	186.78	185.9	186.11	2477019.0
2020-06-05 14:00:00	MSFT	Stock	186.11	187.0	185.98	186.85	3166003.0
2020-06-05 15:00:00	MSFT	Stock	186.86	187.73	186.23	187.26	6903336.0
2020-06-05 16:00:00	MSFT	Stock	187.29	187.4	186.225	187.02	4599005.0
2020-06-05 17:00:00	MSFT	Stock	187.04	187.16	187.04	187.09	7746.0
2020-06-05 18:00:00	MSFT	Stock	187.08	187.15	187.05	187.15	11211.0
2020-06-05 19:00:00	MSFT	Stock	187.09	187.25	187.08	187.2	6721.0
2020-06-05 04:00:00	NVDA	Stock	8.8332	8.8692	8.8332	8.85	75120.0
2020-06-05 05:00:00	NVDA	Stock	8.83	8.83	8.83	8.83	4840.0
2020-06-05 06:00:00	NVDA	Stock	8.8125	8.813	8.7775	8.7775	33160.0
2020-06-05 07:00:00	NVDA	Stock	8.795	8.8075	8.7875	8.7875	491160.0
2020-06-05 08:00:00	NVDA	Stock	8.8024	8.8175	8.7373	8.7838	2159560.0
2020-06-05 09:00:00	NVDA	Stock	8.7839	8.8435	8.708	8.7925	75631640.0
2020-06-05 10:00:00	NVDA	Stock	8.7905	8.8625	8.772	8.8306	65675680.0
2020-06-05 11:00:00	NVDA	Stock	8.8318	8.8688	8.8037	8.8655	40299240.0
2020-06-05 12:00:00	NVDA	Stock	8.8668	8.9718	8.8572	8.955	72021760.0
2020-06-05 13:00:00	NVDA	Stock	8.9555	8.9675	8.9158	8.9482	38106440.0
2020-06-05 14:00:00	NVDA	Stock	8.9465	8.997	8.9375	8.9532	44884160.0
2020-06-05 15:00:00	NVDA	Stock	8.9529	8.9718	8.8838	8.913	65905200.0
2020-06-05 16:00:00	NVDA	Stock	8.9115	8.9235	8.9078	8.917	6297480.0
2020-06-05 17:00:00	NVDA	Stock	8.9168	8.9168	8.892	8.892	141640.0
2020-06-05 18:00:00	NVDA	Stock	8.9	8.906	8.8938	8.905	83520.0
2020-06-05 19:00:00	NVDA	Stock	8.9002	8.9025	8.9	8.9	38080.0
2020-06-05 04:00:00	AMZN	Stock	123.458	123.458	123.25	123.3575	12000.0
2020-06-05 05:00:00	AMZN	Stock	123.2455	123.375	123.2455	123.2455	11320.0

> showing 50 of 58,412 rows — these rows as CSV

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