PREVIEW / stock_1hour / 2020-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-20.parquet
  size:    1.2 MB
  rows:    56,927
  symbols: 2,487

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-10-20 04:00:00	AAPL	Stock	117.5	118.35	117.24	117.25	60024.0
2020-10-20 05:00:00	AAPL	Stock	117.27	117.4	117.09	117.2	29887.0
2020-10-20 06:00:00	AAPL	Stock	117.18	117.6	117.1	117.37	56033.0
2020-10-20 07:00:00	AAPL	Stock	117.35	117.5	116.95	117.06	293653.0
2020-10-20 08:00:00	AAPL	Stock	117.42	117.47	116.26	116.55	830639.0
2020-10-20 09:00:00	AAPL	Stock	116.532	117.07	115.63	117.05	14174248.0
2020-10-20 10:00:00	AAPL	Stock	117.03	117.62	116.21	116.41	16418829.0
2020-10-20 11:00:00	AAPL	Stock	116.41	117.19	115.93	117.17	13322313.0
2020-10-20 12:00:00	AAPL	Stock	117.16	118.51	117.0	118.175	14777828.0
2020-10-20 13:00:00	AAPL	Stock	118.173	118.98	118.1	118.31	13199466.0
2020-10-20 14:00:00	AAPL	Stock	118.305	118.54	117.73	117.98	12551740.0
2020-10-20 15:00:00	AAPL	Stock	117.99	118.42	116.94	117.5	19773334.0
2020-10-20 16:00:00	AAPL	Stock	117.5	117.7	116.95	117.21	9154597.0
2020-10-20 17:00:00	AAPL	Stock	117.24	117.5	117.18	117.5	82578.0
2020-10-20 18:00:00	AAPL	Stock	117.48	117.9	117.48	117.74	226305.0
2020-10-20 19:00:00	AAPL	Stock	117.74	118.0	117.69	117.83	219962.0
2020-10-20 04:00:00	MSFT	Stock	216.2	216.5	216.13	216.13	2086.0
2020-10-20 05:00:00	MSFT	Stock	216.14	216.2	216.13	216.2	549.0
2020-10-20 06:00:00	MSFT	Stock	216.4	217.66	216.4	217.01	4551.0
2020-10-20 07:00:00	MSFT	Stock	216.78	216.98	216.18	216.37	37291.0
2020-10-20 08:00:00	MSFT	Stock	216.75	216.9	215.0	215.72	60339.0
2020-10-20 09:00:00	MSFT	Stock	215.57	216.71	214.67	216.71	1812686.0
2020-10-20 10:00:00	MSFT	Stock	216.63	217.37	214.0	214.04	2677948.0
2020-10-20 11:00:00	MSFT	Stock	214.02	215.1	213.09	214.93	2514992.0
2020-10-20 12:00:00	MSFT	Stock	214.92	216.05	214.32	215.33	2097589.0
2020-10-20 13:00:00	MSFT	Stock	215.39	216.86	215.01	216.09	1741665.0
2020-10-20 14:00:00	MSFT	Stock	216.09	217.09	215.63	216.15	1640660.0
2020-10-20 15:00:00	MSFT	Stock	216.17	216.65	214.15	214.57	3253023.0
2020-10-20 16:00:00	MSFT	Stock	214.65	214.98	214.0	214.69	2606368.0
2020-10-20 17:00:00	MSFT	Stock	214.56	214.75	214.5	214.7	6267.0
2020-10-20 18:00:00	MSFT	Stock	214.75	215.5	214.5	215.5	20021.0
2020-10-20 19:00:00	MSFT	Stock	215.25	215.55	215.0	215.25	28108.0
2020-10-20 04:00:00	NVDA	Stock	13.65	13.65	13.65	13.65	5920.0
2020-10-20 05:00:00	NVDA	Stock	13.6	13.6	13.5825	13.585	21360.0
2020-10-20 06:00:00	NVDA	Stock	13.6425	13.6562	13.6425	13.6562	47520.0
2020-10-20 07:00:00	NVDA	Stock	13.6525	13.6525	13.6125	13.6205	249240.0
2020-10-20 08:00:00	NVDA	Stock	13.615	13.6724	13.526	13.575	1317080.0
2020-10-20 09:00:00	NVDA	Stock	13.5722	13.6668	13.5348	13.6644	30356920.0
2020-10-20 10:00:00	NVDA	Stock	13.662	13.7145	13.5435	13.5638	33614440.0
2020-10-20 11:00:00	NVDA	Stock	13.5555	13.6668	13.507	13.6668	19907240.0
2020-10-20 12:00:00	NVDA	Stock	13.663	13.6858	13.6215	13.6425	14791560.0
2020-10-20 13:00:00	NVDA	Stock	13.646	13.7648	13.639	13.727	18769960.0
2020-10-20 14:00:00	NVDA	Stock	13.7275	13.7998	13.6942	13.72	19216360.0
2020-10-20 15:00:00	NVDA	Stock	13.7135	13.7623	13.6053	13.6455	42684760.0
2020-10-20 16:00:00	NVDA	Stock	13.6455	13.65	13.6053	13.61	4631960.0
2020-10-20 17:00:00	NVDA	Stock	13.6058	13.645	13.6058	13.6425	249280.0
2020-10-20 18:00:00	NVDA	Stock	13.6498	13.6875	13.6408	13.6575	873480.0
2020-10-20 19:00:00	NVDA	Stock	13.6575	13.685	13.6572	13.6705	350720.0
2020-10-20 07:00:00	AMZN	Stock	161.918	162.0	161.395	161.55	157440.0
2020-10-20 08:00:00	AMZN	Stock	161.5125	162.1152	160.3881	160.8	405100.0

> showing 50 of 56,927 rows — these rows as CSV

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