PREVIEW / stock_1hour / 2020-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-21.parquet
  size:    1.2 MB
  rows:    54,794
  symbols: 2,364

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-21 04:00:00	AAPL	Stock	79.5325	79.5325	79.19	79.3475	21344.0
2020-05-21 05:00:00	AAPL	Stock	79.4775	79.4925	79.3775	79.3775	3488.0
2020-05-21 06:00:00	AAPL	Stock	79.3075	79.4425	79.29	79.4425	13648.0
2020-05-21 07:00:00	AAPL	Stock	79.45	79.7175	79.415	79.605	148500.0
2020-05-21 08:00:00	AAPL	Stock	79.7125	79.8725	79.375	79.6675	344508.0
2020-05-21 09:00:00	AAPL	Stock	79.6625	80.2225	79.5	79.915	14607356.0
2020-05-21 10:00:00	AAPL	Stock	79.9125	80.01	79.2582	79.59	15359352.0
2020-05-21 11:00:00	AAPL	Stock	79.58	79.58	78.9675	79.275	11074328.0
2020-05-21 12:00:00	AAPL	Stock	79.275	79.47	79.1575	79.4075	7397528.0
2020-05-21 13:00:00	AAPL	Stock	79.425	79.68	79.32	79.5942	8260588.0
2020-05-21 14:00:00	AAPL	Stock	79.595	79.765	79.2625	79.445	8595244.0
2020-05-21 15:00:00	AAPL	Stock	79.455	79.6675	79.145	79.235	12394040.0
2020-05-21 16:00:00	AAPL	Stock	79.2725	79.3125	79.05	79.1975	5792412.0
2020-05-21 17:00:00	AAPL	Stock	79.1975	79.1975	79.125	79.1875	17232.0
2020-05-21 18:00:00	AAPL	Stock	79.1325	79.3325	79.125	79.29	60384.0
2020-05-21 19:00:00	AAPL	Stock	79.2975	79.5	79.295	79.5	44844.0
2020-05-21 04:00:00	MSFT	Stock	185.09	185.09	184.12	184.33	3470.0
2020-05-21 05:00:00	MSFT	Stock	184.38	184.78	184.38	184.78	235.0
2020-05-21 06:00:00	MSFT	Stock	184.5	184.9	184.5	184.76	1815.0
2020-05-21 07:00:00	MSFT	Stock	184.77	185.29	184.76	184.85	14327.0
2020-05-21 08:00:00	MSFT	Stock	184.781	185.7	184.68	185.34	73382.0
2020-05-21 09:00:00	MSFT	Stock	185.201	186.67	185.1	185.89	3530267.0
2020-05-21 10:00:00	MSFT	Stock	185.89	186.082	184.47	185.27	3404478.0
2020-05-21 11:00:00	MSFT	Stock	185.28	185.28	184.185	184.82	2544973.0
2020-05-21 12:00:00	MSFT	Stock	184.805	185.45	184.42	184.5	2094839.0
2020-05-21 13:00:00	MSFT	Stock	184.51	185.1	183.823	184.15	3079535.0
2020-05-21 14:00:00	MSFT	Stock	184.16	184.68	183.38	183.85	3053476.0
2020-05-21 15:00:00	MSFT	Stock	183.845	184.43	183.29	183.41	4617262.0
2020-05-21 16:00:00	MSFT	Stock	183.43	183.85	183.21	183.33	2941084.0
2020-05-21 17:00:00	MSFT	Stock	183.3	183.375	183.16	183.2	9053.0
2020-05-21 18:00:00	MSFT	Stock	183.16	183.74	183.11	183.6	14822.0
2020-05-21 19:00:00	MSFT	Stock	183.74	184.0	183.62	183.9	12189.0
2020-05-21 04:00:00	NVDA	Stock	8.9875	8.9875	8.9475	8.9698	58560.0
2020-05-21 05:00:00	NVDA	Stock	8.9738	8.9825	8.9688	8.969	48560.0
2020-05-21 06:00:00	NVDA	Stock	8.9688	8.9688	8.9502	8.9625	75520.0
2020-05-21 07:00:00	NVDA	Stock	8.981	9.0332	8.97	9.0175	1443760.0
2020-05-21 08:00:00	NVDA	Stock	9.0002	9.085	8.9478	9.0725	3561400.0
2020-05-21 09:00:00	NVDA	Stock	9.0745	9.08	8.9535	8.9875	74634760.0
2020-05-21 10:00:00	NVDA	Stock	8.9881	8.9972	8.8338	8.8645	97996840.0
2020-05-21 11:00:00	NVDA	Stock	8.8635	8.935	8.7625	8.886	98602320.0
2020-05-21 12:00:00	NVDA	Stock	8.8872	8.963	8.855	8.8701	58159960.0
2020-05-21 13:00:00	NVDA	Stock	8.872	8.921	8.8625	8.8818	33919440.0
2020-05-21 14:00:00	NVDA	Stock	8.8828	8.902	8.7625	8.7978	78518880.0
2020-05-21 15:00:00	NVDA	Stock	8.7953	8.8457	8.7375	8.7795	115090360.0
2020-05-21 16:00:00	NVDA	Stock	8.7795	8.95	8.6185	8.8	60331160.0
2020-05-21 17:00:00	NVDA	Stock	8.8	8.8	8.6625	8.71	11123400.0
2020-05-21 18:00:00	NVDA	Stock	8.7125	8.7942	8.6662	8.7585	6922080.0
2020-05-21 19:00:00	NVDA	Stock	8.7712	8.7825	8.725	8.7255	3039480.0
2020-05-21 05:00:00	AMZN	Stock	124.9605	124.9605	124.9605	124.9605	2000.0
2020-05-21 06:00:00	AMZN	Stock	124.5005	124.75	124.5	124.75	50440.0

> showing 50 of 54,794 rows — these rows as CSV

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