PREVIEW / stock_1hour / 2022-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-07.parquet
  size:    1.4 MB
  rows:    62,945
  symbols: 2,457

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
2022-04-07 04:00:00	AAPL	Stock	172.02	172.36	171.55	172.36	17612.0
2022-04-07 05:00:00	AAPL	Stock	172.33	172.55	172.0	172.43	11658.0
2022-04-07 06:00:00	AAPL	Stock	172.43	172.54	172.22	172.22	18277.0
2022-04-07 07:00:00	AAPL	Stock	172.22	172.62	171.95	172.17	127145.0
2022-04-07 08:00:00	AAPL	Stock	172.12	172.7154	170.98	171.22	395489.0
2022-04-07 09:00:00	AAPL	Stock	171.23	172.69	170.89	172.46	8458039.0
2022-04-07 10:00:00	AAPL	Stock	172.45	173.14	171.1401	171.42	10123387.0
2022-04-07 11:00:00	AAPL	Stock	171.38	171.7963	170.405	170.685	6667205.0
2022-04-07 12:00:00	AAPL	Stock	170.6901	171.535	169.85	170.285	6913425.0
2022-04-07 13:00:00	AAPL	Stock	170.28	171.74	170.22	171.67	6068949.0
2022-04-07 14:00:00	AAPL	Stock	171.66	172.77	171.41	172.66	6360339.0
2022-04-07 15:00:00	AAPL	Stock	172.65	173.36	171.88	172.2675	12175284.0
2022-04-07 16:00:00	AAPL	Stock	172.2475	172.38	171.6992	171.96	6794840.0
2022-04-07 17:00:00	AAPL	Stock	171.92	172.1	171.85	172.05	15001.0
2022-04-07 18:00:00	AAPL	Stock	172.03	172.05	171.81	171.9	23471.0
2022-04-07 19:00:00	AAPL	Stock	171.89	172.28	171.85	172.25	49358.0
2022-04-07 04:00:00	MSFT	Stock	299.42	300.5	299.42	300.5	5290.0
2022-04-07 05:00:00	MSFT	Stock	300.7	300.75	300.32	300.65	2979.0
2022-04-07 06:00:00	MSFT	Stock	300.65	300.76	299.91	299.91	10078.0
2022-04-07 07:00:00	MSFT	Stock	300.0	300.75	299.45	299.98	16304.0
2022-04-07 08:00:00	MSFT	Stock	300.0	300.8876	297.75	298.06	37153.0
2022-04-07 09:00:00	MSFT	Stock	298.01	301.71	296.1	301.39	3126270.0
2022-04-07 10:00:00	MSFT	Stock	301.36	302.64	299.9359	301.57	3720035.0
2022-04-07 11:00:00	MSFT	Stock	301.5666	302.33	298.83	299.19	2505580.0
2022-04-07 12:00:00	MSFT	Stock	299.17	300.31	298.65	299.29	2035462.0
2022-04-07 13:00:00	MSFT	Stock	299.28	301.3	299.2	301.1	2223682.0
2022-04-07 14:00:00	MSFT	Stock	301.1	302.47	300.17	302.32	1884790.0
2022-04-07 15:00:00	MSFT	Stock	302.29	303.65	300.91	301.5	4204048.0
2022-04-07 16:00:00	MSFT	Stock	301.37	301.88	300.845	301.28	3288669.0
2022-04-07 17:00:00	MSFT	Stock	301.17	301.21	301.02	301.21	6276.0
2022-04-07 18:00:00	MSFT	Stock	301.1	301.44	301.1	301.3	6871.0
2022-04-07 19:00:00	MSFT	Stock	301.3	302.3	301.12	302.3	11904.0
2022-04-07 04:00:00	NVDA	Stock	24.597	24.678	24.284	24.673	261130.0
2022-04-07 05:00:00	NVDA	Stock	24.655	24.762	24.602	24.721	113480.0
2022-04-07 06:00:00	NVDA	Stock	24.78	24.805	24.64	24.641	139520.0
2022-04-07 07:00:00	NVDA	Stock	24.663	24.75	24.535	24.624	954130.0
2022-04-07 08:00:00	NVDA	Stock	24.6	24.75	24.34	24.372	1897920.0
2022-04-07 09:00:00	NVDA	Stock	24.38	24.677	24.137	24.556	48788460.0
2022-04-07 10:00:00	NVDA	Stock	24.5586	24.722	24.11	24.2286	61108370.0
2022-04-07 11:00:00	NVDA	Stock	24.229	24.356	23.744	23.804	51984010.0
2022-04-07 12:00:00	NVDA	Stock	23.806	23.948	23.478	23.649	54523920.0
2022-04-07 13:00:00	NVDA	Stock	23.641	24.08	23.621	24.058	53319500.0
2022-04-07 14:00:00	NVDA	Stock	24.054	24.333	23.936	24.297	54478950.0
2022-04-07 15:00:00	NVDA	Stock	24.286	24.558	24.182	24.201	72271970.0
2022-04-07 16:00:00	NVDA	Stock	24.208	24.2123	24.103	24.139	14763520.0
2022-04-07 17:00:00	NVDA	Stock	24.141	24.175	24.13	24.153	172440.0
2022-04-07 18:00:00	NVDA	Stock	24.175	24.19	24.14	24.15	289670.0
2022-04-07 19:00:00	NVDA	Stock	24.141	24.297	24.117	24.275	444350.0
2022-04-07 06:00:00	AMZN	Stock	159.455	159.455	159.455	159.455	2000.0
2022-04-07 07:00:00	AMZN	Stock	159.25	159.5035	159.15	159.4875	17840.0

> showing 50 of 62,945 rows — these rows as CSV

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