PREVIEW / stock_1hour / 2020-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-30.parquet
  size:    1.4 MB
  rows:    64,692
  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-11-30 04:00:00	AAPL	Stock	116.44	116.49	116.22	116.25	26673.0
2020-11-30 05:00:00	AAPL	Stock	116.3	116.6	116.24	116.6	8877.0
2020-11-30 06:00:00	AAPL	Stock	116.6	117.3	116.55	117.16	59178.0
2020-11-30 07:00:00	AAPL	Stock	117.15	117.25	116.76	117.04	307182.0
2020-11-30 08:00:00	AAPL	Stock	117.03	117.25	116.61	117.0	587036.0
2020-11-30 09:00:00	AAPL	Stock	117.01	119.39	116.81	118.95	18773834.0
2020-11-30 10:00:00	AAPL	Stock	118.95	119.5	116.91	118.13	21101617.0
2020-11-30 11:00:00	AAPL	Stock	118.13	119.01	117.5	118.88	12889006.0
2020-11-30 12:00:00	AAPL	Stock	118.87	119.11	118.61	119.045	8758744.0
2020-11-30 13:00:00	AAPL	Stock	119.045	119.76	118.81	119.735	10297781.0
2020-11-30 14:00:00	AAPL	Stock	119.735	120.83	119.59	120.565	17235717.0
2020-11-30 15:00:00	AAPL	Stock	120.57	120.97	119.05	119.06	26346067.0
2020-11-30 16:00:00	AAPL	Stock	119.62	120.16	119.038	119.86	32684638.0
2020-11-30 17:00:00	AAPL	Stock	119.88	120.6	119.035	120.56	479771.0
2020-11-30 18:00:00	AAPL	Stock	120.56	120.8	120.2	120.55	325196.0
2020-11-30 19:00:00	AAPL	Stock	120.53	120.88	120.51	120.81	238155.0
2020-11-30 04:00:00	MSFT	Stock	214.98	215.0	214.9	215.0	393.0
2020-11-30 05:00:00	MSFT	Stock	214.67	214.9	214.6	214.9	911.0
2020-11-30 06:00:00	MSFT	Stock	214.81	214.97	214.62	214.82	1554.0
2020-11-30 07:00:00	MSFT	Stock	214.94	215.81	214.77	215.39	22319.0
2020-11-30 08:00:00	MSFT	Stock	215.32	215.94	214.39	214.98	31231.0
2020-11-30 09:00:00	MSFT	Stock	214.805	215.15	212.92	213.94	2936893.0
2020-11-30 10:00:00	MSFT	Stock	213.94	214.17	210.93	211.93	3343630.0
2020-11-30 11:00:00	MSFT	Stock	211.92	212.2	210.835	211.58	2711846.0
2020-11-30 12:00:00	MSFT	Stock	211.575	212.58	211.36	212.405	1971201.0
2020-11-30 13:00:00	MSFT	Stock	212.4	212.89	212.21	212.25	1372872.0
2020-11-30 14:00:00	MSFT	Stock	212.25	213.27	212.05	213.22	2204614.0
2020-11-30 15:00:00	MSFT	Stock	213.24	214.5	212.43	214.24	4012884.0
2020-11-30 16:00:00	MSFT	Stock	214.25	214.77	213.94	214.33	6673313.0
2020-11-30 17:00:00	MSFT	Stock	214.24	214.32	214.043	214.11	191056.0
2020-11-30 18:00:00	MSFT	Stock	214.3	214.57	213.99	214.57	15775.0
2020-11-30 19:00:00	MSFT	Stock	214.37	214.68	214.11	214.4	8729.0
2020-11-30 04:00:00	NVDA	Stock	13.2102	13.2238	13.2102	13.2238	22080.0
2020-11-30 05:00:00	NVDA	Stock	13.2125	13.2125	13.2125	13.2125	4000.0
2020-11-30 06:00:00	NVDA	Stock	13.2125	13.2125	13.2125	13.2125	4000.0
2020-11-30 07:00:00	NVDA	Stock	13.2125	13.2635	13.2125	13.257	304480.0
2020-11-30 08:00:00	NVDA	Stock	13.2325	13.2694	13.225	13.2515	910560.0
2020-11-30 09:00:00	NVDA	Stock	13.2438	13.3863	13.2178	13.311	36470280.0
2020-11-30 10:00:00	NVDA	Stock	13.3191	13.341	12.9724	13.1002	35606600.0
2020-11-30 11:00:00	NVDA	Stock	13.0946	13.1832	13.0625	13.1393	20460320.0
2020-11-30 12:00:00	NVDA	Stock	13.1345	13.223	13.1012	13.207	15634880.0
2020-11-30 13:00:00	NVDA	Stock	13.21	13.256	13.1898	13.2382	15905000.0
2020-11-30 14:00:00	NVDA	Stock	13.2375	13.32	13.2107	13.32	20879680.0
2020-11-30 15:00:00	NVDA	Stock	13.32	13.4125	13.2748	13.4122	44277640.0
2020-11-30 16:00:00	NVDA	Stock	13.4015	13.501	13.4002	13.428	9190960.0
2020-11-30 17:00:00	NVDA	Stock	13.415	13.425	13.3998	13.425	479280.0
2020-11-30 18:00:00	NVDA	Stock	13.425	13.4375	13.4062	13.4375	386520.0
2020-11-30 19:00:00	NVDA	Stock	13.4375	13.475	13.4318	13.4405	485760.0
2020-11-30 04:00:00	AMZN	Stock	160.25	160.25	160.25	160.25	2000.0
2020-11-30 06:00:00	AMZN	Stock	160.3	160.3	160.3	160.3	3920.0

> showing 50 of 64,692 rows — these rows as CSV

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