PREVIEW / stock_1hour / 2020-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-03.parquet
  size:    1.3 MB
  rows:    61,082
  symbols: 2,627

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-12-03 04:00:00	AAPL	Stock	123.27	123.36	123.23	123.36	8859.0
2020-12-03 05:00:00	AAPL	Stock	123.4	123.4	123.25	123.33	4199.0
2020-12-03 06:00:00	AAPL	Stock	123.33	123.4	123.29	123.36	11630.0
2020-12-03 07:00:00	AAPL	Stock	123.33	123.88	123.33	123.67	204699.0
2020-12-03 08:00:00	AAPL	Stock	123.83	123.88	123.41	123.48	331415.0
2020-12-03 09:00:00	AAPL	Stock	123.479	123.78	122.69	123.16	11176118.0
2020-12-03 10:00:00	AAPL	Stock	123.16	123.45	122.58	122.603	12435924.0
2020-12-03 11:00:00	AAPL	Stock	122.61	123.19	122.21	123.095	8370768.0
2020-12-03 12:00:00	AAPL	Stock	123.1	123.23	122.74	122.885	5923674.0
2020-12-03 13:00:00	AAPL	Stock	122.88	123.03	122.595	122.66	5024034.0
2020-12-03 14:00:00	AAPL	Stock	122.67	123.1	122.615	123.039	5291684.0
2020-12-03 15:00:00	AAPL	Stock	123.035	123.33	122.53	122.94	12180839.0
2020-12-03 16:00:00	AAPL	Stock	122.94	123.05	122.73	122.85	10952103.0
2020-12-03 17:00:00	AAPL	Stock	122.82	122.87	122.77	122.8	51731.0
2020-12-03 18:00:00	AAPL	Stock	122.8	122.95	122.78	122.87	67412.0
2020-12-03 19:00:00	AAPL	Stock	122.9	123.05	122.83	122.88	70854.0
2020-12-03 04:00:00	MSFT	Stock	215.45	215.45	215.05	215.2	1060.0
2020-12-03 05:00:00	MSFT	Stock	215.25	215.25	214.89	215.0	422.0
2020-12-03 06:00:00	MSFT	Stock	215.19	215.48	215.19	215.48	1839.0
2020-12-03 07:00:00	MSFT	Stock	215.25	215.37	214.9	215.07	9989.0
2020-12-03 08:00:00	MSFT	Stock	214.8	215.37	214.75	215.1	41730.0
2020-12-03 09:00:00	MSFT	Stock	215.2	215.24	214.33	214.96	2337985.0
2020-12-03 10:00:00	MSFT	Stock	214.96	216.376	214.25	214.6	3504955.0
2020-12-03 11:00:00	MSFT	Stock	214.6	214.962	213.95	214.68	2540096.0
2020-12-03 12:00:00	MSFT	Stock	214.69	214.99	214.27	214.45	1419094.0
2020-12-03 13:00:00	MSFT	Stock	214.47	214.59	214.01	214.071	1584103.0
2020-12-03 14:00:00	MSFT	Stock	214.07	215.05	214.02	214.89	1326308.0
2020-12-03 15:00:00	MSFT	Stock	214.88	215.39	213.65	214.27	3175070.0
2020-12-03 16:00:00	MSFT	Stock	214.24	214.64	214.18	214.3	5413052.0
2020-12-03 17:00:00	MSFT	Stock	214.24	214.33	214.22	214.24	10739.0
2020-12-03 18:00:00	MSFT	Stock	214.35	214.58	214.31	214.41	11003.0
2020-12-03 19:00:00	MSFT	Stock	214.49	214.49	214.3	214.35	12093.0
2020-12-03 07:00:00	NVDA	Stock	13.585	13.6185	13.5815	13.5848	187600.0
2020-12-03 08:00:00	NVDA	Stock	13.6	13.605	13.575	13.5975	560920.0
2020-12-03 09:00:00	NVDA	Stock	13.5975	13.66	13.4765	13.512	27514880.0
2020-12-03 10:00:00	NVDA	Stock	13.5113	13.568	13.4062	13.42	31917160.0
2020-12-03 11:00:00	NVDA	Stock	13.415	13.4302	13.329	13.423	24840040.0
2020-12-03 12:00:00	NVDA	Stock	13.4232	13.4355	13.3525	13.3822	12443600.0
2020-12-03 13:00:00	NVDA	Stock	13.3814	13.4312	13.3702	13.4	10787200.0
2020-12-03 14:00:00	NVDA	Stock	13.4025	13.4601	13.3952	13.45	11486160.0
2020-12-03 15:00:00	NVDA	Stock	13.4483	13.453	13.3652	13.403	22503760.0
2020-12-03 16:00:00	NVDA	Stock	13.396	13.4185	13.3628	13.4113	16238760.0
2020-12-03 17:00:00	NVDA	Stock	13.4062	13.4175	13.4	13.4175	164000.0
2020-12-03 18:00:00	NVDA	Stock	13.4225	13.4275	13.4075	13.4128	156640.0
2020-12-03 19:00:00	NVDA	Stock	13.4162	13.4275	13.4162	13.4275	155360.0
2020-12-03 05:00:00	AMZN	Stock	160.539	160.539	160.539	160.539	2000.0
2020-12-03 07:00:00	AMZN	Stock	160.465	160.6765	160.465	160.594	121640.0
2020-12-03 08:00:00	AMZN	Stock	160.5	160.6145	160.4	160.45	209180.0
2020-12-03 09:00:00	AMZN	Stock	160.3585	161.3785	160.0555	160.6525	7017060.0
2020-12-03 10:00:00	AMZN	Stock	160.5572	161.432	160.2408	160.2905	5121200.0

> showing 50 of 61,082 rows — these rows as CSV

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