PREVIEW / stock_1hour / 2021-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-30.parquet
  size:    1.5 MB
  rows:    68,287
  symbols: 2,727

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
2021-11-30 04:00:00	AAPL	Stock	159.24	159.58	158.56	159.1	69074.0
2021-11-30 05:00:00	AAPL	Stock	159.1	159.19	158.5	159.17	34138.0
2021-11-30 06:00:00	AAPL	Stock	159.23	159.39	158.96	158.96	51196.0
2021-11-30 07:00:00	AAPL	Stock	159.0	159.39	158.97	159.11	148035.0
2021-11-30 08:00:00	AAPL	Stock	159.1999	159.84	158.75	159.59	508012.0
2021-11-30 09:00:00	AAPL	Stock	159.56	162.3	159.33	162.09	11891122.0
2021-11-30 10:00:00	AAPL	Stock	162.1	164.58	162.0089	162.15	28140336.0
2021-11-30 11:00:00	AAPL	Stock	162.17	163.44	161.84	162.53	19733283.0
2021-11-30 12:00:00	AAPL	Stock	162.53	164.26	162.035	163.575	14551428.0
2021-11-30 13:00:00	AAPL	Stock	163.59	164.37	163.13	164.34	10386397.0
2021-11-30 14:00:00	AAPL	Stock	164.34	164.92	163.93	164.235	13089869.0
2021-11-30 15:00:00	AAPL	Stock	164.22	165.52	163.05	165.43	24943363.0
2021-11-30 16:00:00	AAPL	Stock	165.43	166.4	165.26	165.9	25202332.0
2021-11-30 17:00:00	AAPL	Stock	165.88	166.64	165.77	166.42	362377.0
2021-11-30 18:00:00	AAPL	Stock	166.48	166.64	166.23	166.41	130670.0
2021-11-30 19:00:00	AAPL	Stock	166.41	166.64	165.9	166.35	167729.0
2021-11-30 04:00:00	MSFT	Stock	335.66	335.96	334.71	335.7	13056.0
2021-11-30 05:00:00	MSFT	Stock	335.87	335.95	335.47	335.83	3176.0
2021-11-30 06:00:00	MSFT	Stock	335.6	336.51	335.19	335.19	5078.0
2021-11-30 07:00:00	MSFT	Stock	335.4	336.0	335.06	335.35	16612.0
2021-11-30 08:00:00	MSFT	Stock	335.3499	336.65	334.79	336.65	39825.0
2021-11-30 09:00:00	MSFT	Stock	336.5	336.63	334.12	335.98	2199590.0
2021-11-30 10:00:00	MSFT	Stock	335.95	337.78	332.13	332.19	3593106.0
2021-11-30 11:00:00	MSFT	Stock	332.2	332.34	328.99	329.99	3513238.0
2021-11-30 12:00:00	MSFT	Stock	329.98	331.48	329.62	330.39	1945763.0
2021-11-30 13:00:00	MSFT	Stock	330.43	332.0	330.0	331.999	1293123.0
2021-11-30 14:00:00	MSFT	Stock	331.99	332.53	330.8	331.4901	1600965.0
2021-11-30 15:00:00	MSFT	Stock	331.51	331.9	330.01	330.64	3801854.0
2021-11-30 16:00:00	MSFT	Stock	330.67	334.26	330.59	334.26	10435239.0
2021-11-30 17:00:00	MSFT	Stock	334.15	334.15	333.42	333.43	15611.0
2021-11-30 18:00:00	MSFT	Stock	333.6	334.27	333.4	333.5	12339.0
2021-11-30 19:00:00	MSFT	Stock	333.5999	334.15	332.51	333.35	26605.0
2021-11-30 04:00:00	NVDA	Stock	32.996	33.07	32.795	33.07	443590.0
2021-11-30 05:00:00	NVDA	Stock	33.05	33.1	32.955	33.011	111420.0
2021-11-30 06:00:00	NVDA	Stock	33.056	33.134	32.963	33.047	120250.0
2021-11-30 07:00:00	NVDA	Stock	33.01	33.297	33.01	33.186	1982090.0
2021-11-30 08:00:00	NVDA	Stock	33.172	33.3	33.04	33.275	1426590.0
2021-11-30 09:00:00	NVDA	Stock	33.285	33.46	32.791	33.1834	53767610.0
2021-11-30 10:00:00	NVDA	Stock	33.1935	33.353	32.183	32.1905	76079200.0
2021-11-30 11:00:00	NVDA	Stock	32.1841	32.435	31.89	32.14	60460560.0
2021-11-30 12:00:00	NVDA	Stock	32.144	32.4005	31.864	32.16	47455590.0
2021-11-30 13:00:00	NVDA	Stock	32.161	32.6	32.018	32.582	40254970.0
2021-11-30 14:00:00	NVDA	Stock	32.5795	32.6267	32.157	32.252	43053200.0
2021-11-30 15:00:00	NVDA	Stock	32.2535	32.789	32.171	32.71	57429640.0
2021-11-30 16:00:00	NVDA	Stock	32.707	32.925	32.676	32.772	76697530.0
2021-11-30 17:00:00	NVDA	Stock	32.784	32.827	32.75	32.775	391170.0
2021-11-30 18:00:00	NVDA	Stock	32.798	32.89	32.798	32.865	416860.0
2021-11-30 19:00:00	NVDA	Stock	32.865	32.892	32.725	32.725	492070.0
2021-11-30 04:00:00	AMZN	Stock	177.55	177.55	177.55	177.55	2000.0
2021-11-30 06:00:00	AMZN	Stock	177.577	177.577	177.577	177.577	2000.0

> showing 50 of 68,287 rows — these rows as CSV

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