PREVIEW / stock_1hour / 2020-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-29.parquet
  size:    1.3 MB
  rows:    57,851
  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-10-29 04:00:00	AAPL	Stock	112.79	113.14	112.5	112.75	56998.0
2020-10-29 05:00:00	AAPL	Stock	112.82	113.69	112.82	113.18	47792.0
2020-10-29 06:00:00	AAPL	Stock	113.18	113.29	112.75	113.28	52178.0
2020-10-29 07:00:00	AAPL	Stock	113.18	113.24	111.7	111.7	472766.0
2020-10-29 08:00:00	AAPL	Stock	112.94	113.1	111.7	112.59	1121886.0
2020-10-29 09:00:00	AAPL	Stock	112.58	114.2	112.2	114.025	15333476.0
2020-10-29 10:00:00	AAPL	Stock	114.02	114.6	113.41	113.97	14453072.0
2020-10-29 11:00:00	AAPL	Stock	113.97	114.98	113.6	114.505	11694861.0
2020-10-29 12:00:00	AAPL	Stock	114.504	115.25	114.36	115.07	9889046.0
2020-10-29 13:00:00	AAPL	Stock	115.07	116.22	114.995	116.195	11693868.0
2020-10-29 14:00:00	AAPL	Stock	116.2	116.93	115.82	116.04	16307892.0
2020-10-29 15:00:00	AAPL	Stock	116.05	116.73	114.52	114.52	23352056.0
2020-10-29 16:00:00	AAPL	Stock	114.52	116.22	109.2	109.96	19244937.0
2020-10-29 17:00:00	AAPL	Stock	109.9	112.65	108.77	109.26	4564594.0
2020-10-29 18:00:00	AAPL	Stock	109.29	110.47	108.59	110.33	1506193.0
2020-10-29 19:00:00	AAPL	Stock	110.34	111.15	110.3	110.45	931239.0
2020-10-29 04:00:00	MSFT	Stock	204.99	205.84	204.0	204.66	8441.0
2020-10-29 05:00:00	MSFT	Stock	204.85	205.58	204.71	205.32	6621.0
2020-10-29 06:00:00	MSFT	Stock	205.18	205.18	204.6	204.6	5289.0
2020-10-29 07:00:00	MSFT	Stock	205.0	205.09	202.7	202.73	71751.0
2020-10-29 08:00:00	MSFT	Stock	204.15	205.0	202.65	203.41	121366.0
2020-10-29 09:00:00	MSFT	Stock	203.224	205.07	203.22	204.72	3817660.0
2020-10-29 10:00:00	MSFT	Stock	204.72	205.47	204.0	204.85	3504313.0
2020-10-29 11:00:00	MSFT	Stock	204.87	205.25	203.95	204.31	2415419.0
2020-10-29 12:00:00	MSFT	Stock	204.33	205.14	204.21	204.8	1825175.0
2020-10-29 13:00:00	MSFT	Stock	204.83	206.11	204.53	206.04	2197846.0
2020-10-29 14:00:00	MSFT	Stock	206.03	207.36	205.96	206.6	2793734.0
2020-10-29 15:00:00	MSFT	Stock	206.63	206.73	204.2	204.39	4479871.0
2020-10-29 16:00:00	MSFT	Stock	204.53	205.423	203.0	203.3	4006204.0
2020-10-29 17:00:00	MSFT	Stock	203.3	203.95	202.61	203.2	85485.0
2020-10-29 18:00:00	MSFT	Stock	203.13	203.45	202.7	202.85	53809.0
2020-10-29 19:00:00	MSFT	Stock	202.9	203.35	202.75	203.3	37232.0
2020-10-29 04:00:00	NVDA	Stock	12.8	12.835	12.8	12.805	27440.0
2020-10-29 05:00:00	NVDA	Stock	12.85	12.85	12.85	12.85	6640.0
2020-10-29 07:00:00	NVDA	Stock	12.8128	12.8245	12.7015	12.7038	1283360.0
2020-10-29 08:00:00	NVDA	Stock	12.8	12.8248	12.6585	12.7625	1196840.0
2020-10-29 09:00:00	NVDA	Stock	12.769	12.9528	12.7465	12.9358	56852200.0
2020-10-29 10:00:00	NVDA	Stock	12.9405	13.0211	12.918	12.9798	50448920.0
2020-10-29 11:00:00	NVDA	Stock	12.9798	13.0822	12.9562	13.0089	31615640.0
2020-10-29 12:00:00	NVDA	Stock	13.0123	13.0933	12.9765	13.067	22932920.0
2020-10-29 13:00:00	NVDA	Stock	13.066	13.1025	13.0393	13.0805	22816800.0
2020-10-29 14:00:00	NVDA	Stock	13.08	13.1928	13.0798	13.138	34535360.0
2020-10-29 15:00:00	NVDA	Stock	13.1357	13.1625	13.0065	13.0155	40639520.0
2020-10-29 16:00:00	NVDA	Stock	13.024	13.0488	12.875	12.888	9150200.0
2020-10-29 17:00:00	NVDA	Stock	12.8848	12.9	12.852	12.9	464800.0
2020-10-29 18:00:00	NVDA	Stock	12.8875	12.8875	12.8	12.8255	209080.0
2020-10-29 19:00:00	NVDA	Stock	12.8	12.9125	12.7802	12.8738	258920.0
2020-10-29 06:00:00	AMZN	Stock	160.2	160.2325	160.0	160.2325	19240.0
2020-10-29 07:00:00	AMZN	Stock	160.2325	160.25	158.8505	158.8755	468820.0
2020-10-29 08:00:00	AMZN	Stock	160.0043	160.25	158.973	159.775	567060.0

> showing 50 of 57,851 rows — these rows as CSV

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