PREVIEW / stock_1hour / 2021-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-09.parquet
  size:    1.4 MB
  rows:    65,519
  symbols: 2,662

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-12-09 04:00:00	AAPL	Stock	175.58	175.58	174.4	174.56	27265.0
2021-12-09 05:00:00	AAPL	Stock	174.56	174.56	173.7	173.85	60210.0
2021-12-09 06:00:00	AAPL	Stock	173.85	173.9	173.61	173.85	25948.0
2021-12-09 07:00:00	AAPL	Stock	173.85	174.69	173.85	174.57	173396.0
2021-12-09 08:00:00	AAPL	Stock	174.1001	174.77	173.82	174.69	439937.0
2021-12-09 09:00:00	AAPL	Stock	174.73	176.75	174.55	176.11	14886610.0
2021-12-09 10:00:00	AAPL	Stock	176.13	176.2	173.92	175.92	20169368.0
2021-12-09 11:00:00	AAPL	Stock	175.92	175.95	174.68	174.7183	11732406.0
2021-12-09 12:00:00	AAPL	Stock	174.725	175.815	174.48	175.5	9651830.0
2021-12-09 13:00:00	AAPL	Stock	175.5	175.9599	175.1306	175.645	7613708.0
2021-12-09 14:00:00	AAPL	Stock	175.65	175.96	175.16	175.36	7459722.0
2021-12-09 15:00:00	AAPL	Stock	175.37	175.7199	174.19	174.62	14400670.0
2021-12-09 16:00:00	AAPL	Stock	174.58	174.64	174.01	174.2	9651992.0
2021-12-09 17:00:00	AAPL	Stock	174.29	174.36	174.11	174.23	68216.0
2021-12-09 18:00:00	AAPL	Stock	174.23	174.36	174.2	174.27	33797.0
2021-12-09 19:00:00	AAPL	Stock	174.29	174.34	174.12	174.15	40670.0
2021-12-09 04:00:00	MSFT	Stock	334.33	334.78	334.16	334.61	1781.0
2021-12-09 05:00:00	MSFT	Stock	334.64	334.64	334.0	334.0	1431.0
2021-12-09 06:00:00	MSFT	Stock	333.98	334.01	333.5	333.9	1152.0
2021-12-09 07:00:00	MSFT	Stock	333.9	334.18	333.7	333.95	6557.0
2021-12-09 08:00:00	MSFT	Stock	334.97	334.97	333.4	333.79	19251.0
2021-12-09 09:00:00	MSFT	Stock	333.89	336.489	333.89	334.62	1951889.0
2021-12-09 10:00:00	MSFT	Stock	334.61	335.0299	332.89	333.93	1643379.0
2021-12-09 11:00:00	MSFT	Stock	333.9418	335.3273	333.35	334.32	1252394.0
2021-12-09 12:00:00	MSFT	Stock	334.3269	334.845	333.49	334.7768	1060718.0
2021-12-09 13:00:00	MSFT	Stock	334.77	334.97	333.3	334.29	1086540.0
2021-12-09 14:00:00	MSFT	Stock	334.3	334.85	333.57	333.845	1124648.0
2021-12-09 15:00:00	MSFT	Stock	333.86	334.18	332.12	333.11	2774731.0
2021-12-09 16:00:00	MSFT	Stock	333.1	333.2	332.33	332.84	4189219.0
2021-12-09 17:00:00	MSFT	Stock	332.9299	332.9299	332.43	332.8	11892.0
2021-12-09 18:00:00	MSFT	Stock	332.79	333.17	332.78	332.78	12168.0
2021-12-09 19:00:00	MSFT	Stock	332.75	332.99	332.6501	332.6501	2706.0
2021-12-09 04:00:00	NVDA	Stock	31.799	31.799	31.601	31.669	44080.0
2021-12-09 05:00:00	NVDA	Stock	31.66	31.66	31.57	31.594	33470.0
2021-12-09 06:00:00	NVDA	Stock	31.568	31.6	31.501	31.53	30670.0
2021-12-09 07:00:00	NVDA	Stock	31.574	31.675	31.54	31.675	114520.0
2021-12-09 08:00:00	NVDA	Stock	31.826	31.826	31.481	31.572	841300.0
2021-12-09 09:00:00	NVDA	Stock	31.6	32.205	31.5	31.6964	50979500.0
2021-12-09 10:00:00	NVDA	Stock	31.699	31.774	31.28	31.3965	56365370.0
2021-12-09 11:00:00	NVDA	Stock	31.401	31.67	31.307	31.448	37857130.0
2021-12-09 12:00:00	NVDA	Stock	31.442	31.507	31.145	31.2865	38715140.0
2021-12-09 13:00:00	NVDA	Stock	31.289	31.36	30.875	30.958	31997580.0
2021-12-09 14:00:00	NVDA	Stock	30.951	31.007	30.428	30.81	55087030.0
2021-12-09 15:00:00	NVDA	Stock	30.8115	30.986	30.44	30.479	77888190.0
2021-12-09 16:00:00	NVDA	Stock	30.479	30.573	30.4	30.538	29685480.0
2021-12-09 17:00:00	NVDA	Stock	30.527	30.544	30.495	30.51	269020.0
2021-12-09 18:00:00	NVDA	Stock	30.502	30.588	30.5	30.53	292620.0
2021-12-09 19:00:00	NVDA	Stock	30.52	30.538	30.475	30.476	236680.0
2021-12-09 07:00:00	AMZN	Stock	175.25	175.7	175.2	175.7	39640.0
2021-12-09 08:00:00	AMZN	Stock	175.475	175.74	175.35	175.74	27800.0

> showing 50 of 65,519 rows — these rows as CSV

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