PREVIEW / stock_1hour / 2022-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-21.parquet
  size:    1.4 MB
  rows:    65,557
  symbols: 2,520

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-03-21 04:00:00	AAPL	Stock	164.0	164.0	163.0	163.0	12531.0
2022-03-21 05:00:00	AAPL	Stock	163.1	163.52	163.01	163.52	7226.0
2022-03-21 06:00:00	AAPL	Stock	163.51	163.64	163.4	163.64	7230.0
2022-03-21 07:00:00	AAPL	Stock	163.67	164.33	163.58	164.05	75900.0
2022-03-21 08:00:00	AAPL	Stock	163.74	164.33	163.0	163.6	470175.0
2022-03-21 09:00:00	AAPL	Stock	163.58	165.59	163.42	164.0324	9852246.0
2022-03-21 10:00:00	AAPL	Stock	164.08	165.0	163.015	164.865	10414277.0
2022-03-21 11:00:00	AAPL	Stock	164.87	166.35	164.54	166.25	11037033.0
2022-03-21 12:00:00	AAPL	Stock	166.25	166.31	163.82	163.935	8486919.0
2022-03-21 13:00:00	AAPL	Stock	163.94	164.1	163.16	163.89	6758005.0
2022-03-21 14:00:00	AAPL	Stock	163.89	164.87	163.61	164.07	7377251.0
2022-03-21 15:00:00	AAPL	Stock	164.0701	165.4	163.91	165.38	9468305.0
2022-03-21 16:00:00	AAPL	Stock	165.38	165.82	165.27	165.5	11711537.0
2022-03-21 17:00:00	AAPL	Stock	165.4	165.52	165.31	165.42	54432.0
2022-03-21 18:00:00	AAPL	Stock	165.42	165.45	165.13	165.21	24185.0
2022-03-21 19:00:00	AAPL	Stock	165.17	165.29	165.0	165.0	49682.0
2022-03-21 04:00:00	MSFT	Stock	299.75	299.75	298.85	299.4	6218.0
2022-03-21 05:00:00	MSFT	Stock	299.38	300.43	298.97	300.43	15956.0
2022-03-21 06:00:00	MSFT	Stock	299.74	299.75	298.78	298.99	4734.0
2022-03-21 07:00:00	MSFT	Stock	299.53	300.07	299.2	299.41	14312.0
2022-03-21 08:00:00	MSFT	Stock	299.5	300.2	298.25	298.25	49029.0
2022-03-21 09:00:00	MSFT	Stock	298.4	300.14	296.76	297.1799	2306392.0
2022-03-21 10:00:00	MSFT	Stock	297.23	298.45	295.63	298.11	2501859.0
2022-03-21 11:00:00	MSFT	Stock	298.12	299.7755	297.62	299.37	2054169.0
2022-03-21 12:00:00	MSFT	Stock	299.39	299.47	295.95	296.11	1656347.0
2022-03-21 13:00:00	MSFT	Stock	296.19	296.705	294.9	296.3199	1825343.0
2022-03-21 14:00:00	MSFT	Stock	296.3	297.929	295.78	296.5	1533857.0
2022-03-21 15:00:00	MSFT	Stock	296.46	299.36	296.31	299.17	2654943.0
2022-03-21 16:00:00	MSFT	Stock	299.15	299.85	299.15	299.6	5382918.0
2022-03-21 17:00:00	MSFT	Stock	299.58	299.69	299.16	299.16	87268.0
2022-03-21 18:00:00	MSFT	Stock	299.28	299.32	299.1	299.2	6334.0
2022-03-21 19:00:00	MSFT	Stock	299.1	299.33	298.62	298.76	9593.0
2022-03-21 04:00:00	NVDA	Stock	26.4	26.452	26.237	26.288	217850.0
2022-03-21 05:00:00	NVDA	Stock	26.285	26.431	26.265	26.35	46040.0
2022-03-21 06:00:00	NVDA	Stock	26.398	26.465	26.36	26.431	96030.0
2022-03-21 07:00:00	NVDA	Stock	26.447	26.813	26.415	26.64	1066820.0
2022-03-21 08:00:00	NVDA	Stock	26.685	26.818	26.011	26.582	1742500.0
2022-03-21 09:00:00	NVDA	Stock	26.58	26.963	26.145	26.297	65345750.0
2022-03-21 10:00:00	NVDA	Stock	26.3	26.649	25.967	26.581	73878250.0
2022-03-21 11:00:00	NVDA	Stock	26.581	27.152	26.3945	27.087	66296470.0
2022-03-21 12:00:00	NVDA	Stock	27.089	27.119	26.162	26.201	60473000.0
2022-03-21 13:00:00	NVDA	Stock	26.209	26.434	26.049	26.426	44665690.0
2022-03-21 14:00:00	NVDA	Stock	26.423	26.7	26.252	26.3791	43070440.0
2022-03-21 15:00:00	NVDA	Stock	26.3675	26.749	26.343	26.742	58358930.0
2022-03-21 16:00:00	NVDA	Stock	26.741	26.775	26.72	26.74	29190970.0
2022-03-21 17:00:00	NVDA	Stock	26.736	26.744	26.703	26.71	833020.0
2022-03-21 18:00:00	NVDA	Stock	26.71	26.725	26.653	26.7	349800.0
2022-03-21 19:00:00	NVDA	Stock	26.698	26.71	26.601	26.617	305810.0
2022-03-21 05:00:00	AMZN	Stock	160.25	160.25	160.25	160.25	2000.0
2022-03-21 07:00:00	AMZN	Stock	160.5	161.452	160.5	161.355	36880.0

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

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