PREVIEW / stock_1hour / 2021-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-11.parquet
  size:    1.4 MB
  rows:    66,689
  symbols: 2,691

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-01-11 04:00:00	AAPL	Stock	131.75	131.75	131.0	131.28	59388.0
2021-01-11 05:00:00	AAPL	Stock	131.21	131.48	131.17	131.4	18866.0
2021-01-11 06:00:00	AAPL	Stock	131.47	131.73	131.28	131.52	28186.0
2021-01-11 07:00:00	AAPL	Stock	131.6	131.67	130.24	130.64	451142.0
2021-01-11 08:00:00	AAPL	Stock	131.14	131.43	130.02	130.18	836428.0
2021-01-11 09:00:00	AAPL	Stock	130.21	130.21	128.5	129.425	16444797.0
2021-01-11 10:00:00	AAPL	Stock	129.41	130.17	129.32	129.57	14046579.0
2021-01-11 11:00:00	AAPL	Stock	129.56	129.69	129.03	129.51	8258339.0
2021-01-11 12:00:00	AAPL	Stock	129.51	130.06	129.35	129.55	7183087.0
2021-01-11 13:00:00	AAPL	Stock	129.545	129.93	129.22	129.345	7512409.0
2021-01-11 14:00:00	AAPL	Stock	129.348	129.348	128.87	129.31	7960376.0
2021-01-11 15:00:00	AAPL	Stock	129.31	129.44	128.69	128.98	12543838.0
2021-01-11 16:00:00	AAPL	Stock	128.98	129.15	128.95	128.95	11983622.0
2021-01-11 17:00:00	AAPL	Stock	128.96	129.05	128.91	129.05	105738.0
2021-01-11 18:00:00	AAPL	Stock	129.02	129.17	128.97	129.12	96003.0
2021-01-11 19:00:00	AAPL	Stock	129.14	129.24	129.04	129.15	128586.0
2021-01-11 04:00:00	MSFT	Stock	218.8	219.6	218.6	219.51	2075.0
2021-01-11 05:00:00	MSFT	Stock	219.13	219.13	218.97	219.0	1697.0
2021-01-11 06:00:00	MSFT	Stock	218.71	218.76	218.71	218.73	446.0
2021-01-11 07:00:00	MSFT	Stock	218.71	219.0	218.3	218.75	22147.0
2021-01-11 08:00:00	MSFT	Stock	218.88	218.88	217.53	217.7	38105.0
2021-01-11 09:00:00	MSFT	Stock	217.93	218.65	216.73	217.43	2521707.0
2021-01-11 10:00:00	MSFT	Stock	217.425	218.91	217.0	218.361	2229684.0
2021-01-11 11:00:00	MSFT	Stock	218.38	218.562	217.44	218.11	1366297.0
2021-01-11 12:00:00	MSFT	Stock	218.12	218.55	217.88	218.26	1108083.0
2021-01-11 13:00:00	MSFT	Stock	218.28	218.53	217.51	217.79	913306.0
2021-01-11 14:00:00	MSFT	Stock	217.79	218.06	217.216	217.95	1206973.0
2021-01-11 15:00:00	MSFT	Stock	217.97	218.09	217.12	217.5	2440906.0
2021-01-11 16:00:00	MSFT	Stock	217.49	218.0	217.49	217.72	6831217.0
2021-01-11 17:00:00	MSFT	Stock	217.73	217.75	217.67	217.67	3810.0
2021-01-11 18:00:00	MSFT	Stock	217.68	217.89	217.53	217.7	10367.0
2021-01-11 19:00:00	MSFT	Stock	217.73	218.38	217.6	217.76	3149.0
2021-01-11 04:00:00	NVDA	Stock	13.45	13.45	13.342	13.3828	99320.0
2021-01-11 05:00:00	NVDA	Stock	13.3765	13.5328	13.3765	13.525	179360.0
2021-01-11 06:00:00	NVDA	Stock	13.5245	13.5975	13.5115	13.5975	152840.0
2021-01-11 07:00:00	NVDA	Stock	13.55	13.633	13.5128	13.5525	2992040.0
2021-01-11 08:00:00	NVDA	Stock	13.545	13.6375	13.416	13.4588	2925080.0
2021-01-11 09:00:00	NVDA	Stock	13.4625	13.9165	13.3625	13.8355	114427000.0
2021-01-11 10:00:00	NVDA	Stock	13.8304	13.9242	13.764	13.8324	69033480.0
2021-01-11 11:00:00	NVDA	Stock	13.8345	13.8494	13.7025	13.7405	36476600.0
2021-01-11 12:00:00	NVDA	Stock	13.7465	13.9408	13.7052	13.8965	45224800.0
2021-01-11 13:00:00	NVDA	Stock	13.9	13.961	13.8588	13.8995	32299960.0
2021-01-11 14:00:00	NVDA	Stock	13.8958	13.8958	13.726	13.7773	30245120.0
2021-01-11 15:00:00	NVDA	Stock	13.777	13.777	13.591	13.6143	60610840.0
2021-01-11 16:00:00	NVDA	Stock	13.6215	13.65	13.6105	13.625	29704800.0
2021-01-11 17:00:00	NVDA	Stock	13.6375	13.6488	13.635	13.6468	177840.0
2021-01-11 18:00:00	NVDA	Stock	13.64	13.6488	13.64	13.6465	134520.0
2021-01-11 19:00:00	NVDA	Stock	13.645	13.6688	13.645	13.6688	398920.0
2021-01-11 04:00:00	AMZN	Stock	158.4	158.44	158.16	158.44	9480.0
2021-01-11 05:00:00	AMZN	Stock	158.2	158.25	158.2	158.2205	15400.0

> showing 50 of 66,689 rows — these rows as CSV

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