PREVIEW / stock_1hour / 2020-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-18.parquet
  size:    1.3 MB
  rows:    56,457
  symbols: 2,492

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-09-18 04:00:00	AAPL	Stock	111.0	111.61	110.6	111.3	41362.0
2020-09-18 05:00:00	AAPL	Stock	111.23	111.9	111.23	111.5	21557.0
2020-09-18 06:00:00	AAPL	Stock	111.45	111.7	111.12	111.4	29406.0
2020-09-18 07:00:00	AAPL	Stock	111.42	111.55	110.6	110.92	717171.0
2020-09-18 08:00:00	AAPL	Stock	110.89	111.54	110.067	111.02	1557792.0
2020-09-18 09:00:00	AAPL	Stock	111.05	111.5	109.02	109.43	34213737.0
2020-09-18 10:00:00	AAPL	Stock	109.43	110.018	108.06	108.18	26458993.0
2020-09-18 11:00:00	AAPL	Stock	108.18	108.43	107.2	108.14	28068665.0
2020-09-18 12:00:00	AAPL	Stock	108.14	108.5	106.52	106.959	26431137.0
2020-09-18 13:00:00	AAPL	Stock	106.96	107.39	106.09	107.315	23284791.0
2020-09-18 14:00:00	AAPL	Stock	107.31	107.74	106.77	107.6	17018894.0
2020-09-18 15:00:00	AAPL	Stock	107.61	108.1	106.55	106.6	30071228.0
2020-09-18 16:00:00	AAPL	Stock	106.6	107.42	106.5	107.02	62519986.0
2020-09-18 17:00:00	AAPL	Stock	107.0	107.04	106.75	107.0	330897.0
2020-09-18 18:00:00	AAPL	Stock	107.0	107.0	106.88	106.91	137327.0
2020-09-18 19:00:00	AAPL	Stock	106.91	107.0	106.84	106.93	245820.0
2020-09-18 04:00:00	MSFT	Stock	203.31	204.0	202.41	203.47	2333.0
2020-09-18 05:00:00	MSFT	Stock	203.95	204.0	203.95	203.99	711.0
2020-09-18 06:00:00	MSFT	Stock	203.45	203.8	203.19	203.6	2463.0
2020-09-18 07:00:00	MSFT	Stock	203.6	204.4	203.4	204.08	23846.0
2020-09-18 08:00:00	MSFT	Stock	203.71	204.43	203.24	204.2	75145.0
2020-09-18 09:00:00	MSFT	Stock	204.03	204.71	201.735	202.33	10064444.0
2020-09-18 10:00:00	MSFT	Stock	202.35	203.1	200.49	200.735	3617666.0
2020-09-18 11:00:00	MSFT	Stock	200.735	200.88	198.81	200.05	4493852.0
2020-09-18 12:00:00	MSFT	Stock	200.012	200.44	197.67	198.405	4142851.0
2020-09-18 13:00:00	MSFT	Stock	198.4	198.62	196.25	198.53	4039652.0
2020-09-18 14:00:00	MSFT	Stock	198.53	199.23	197.93	198.935	2777445.0
2020-09-18 15:00:00	MSFT	Stock	198.93	200.64	198.715	200.45	6027934.0
2020-09-18 16:00:00	MSFT	Stock	200.31	200.49	199.81	200.22	9449496.0
2020-09-18 17:00:00	MSFT	Stock	200.21	200.34	200.0	200.14	17523.0
2020-09-18 18:00:00	MSFT	Stock	200.13	200.13	200.01	200.09	7997.0
2020-09-18 19:00:00	MSFT	Stock	200.02	200.09	200.0	200.04	12289.0
2020-09-18 04:00:00	NVDA	Stock	12.5055	12.5925	12.5055	12.5543	35360.0
2020-09-18 05:00:00	NVDA	Stock	12.59	12.625	12.59	12.6125	107760.0
2020-09-18 06:00:00	NVDA	Stock	12.6	12.601	12.5832	12.5832	22360.0
2020-09-18 07:00:00	NVDA	Stock	12.604	12.6375	12.5778	12.58	653880.0
2020-09-18 08:00:00	NVDA	Stock	12.6075	12.6375	12.5265	12.6	2314680.0
2020-09-18 09:00:00	NVDA	Stock	12.6243	12.6435	12.3702	12.4171	80611600.0
2020-09-18 10:00:00	NVDA	Stock	12.4166	12.4553	12.2645	12.278	86100720.0
2020-09-18 11:00:00	NVDA	Stock	12.278	12.312	12.188	12.2618	64398200.0
2020-09-18 12:00:00	NVDA	Stock	12.257	12.3048	12.054	12.0892	83662200.0
2020-09-18 13:00:00	NVDA	Stock	12.0932	12.1248	11.9888	12.114	73582240.0
2020-09-18 14:00:00	NVDA	Stock	12.111	12.1816	12.0688	12.1738	48396640.0
2020-09-18 15:00:00	NVDA	Stock	12.175	12.314	12.1525	12.1865	106119280.0
2020-09-18 16:00:00	NVDA	Stock	12.182	12.2225	12.179	12.2125	43766280.0
2020-09-18 17:00:00	NVDA	Stock	12.2038	12.2125	12.175	12.1782	262760.0
2020-09-18 18:00:00	NVDA	Stock	12.1858	12.1923	12.1825	12.1923	130240.0
2020-09-18 19:00:00	NVDA	Stock	12.1875	12.1925	12.1668	12.1825	224640.0
2020-09-18 06:00:00	AMZN	Stock	151.35	151.3515	151.35	151.3515	6760.0
2020-09-18 07:00:00	AMZN	Stock	151.3	151.431	151.05	151.299	240100.0

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

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