PREVIEW / stock_1hour / 2022-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-19.parquet
  size:    1.4 MB
  rows:    62,629
  symbols: 2,237

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-09-19 04:00:00	AAPL	Stock	149.97	149.97	149.02	149.2	30892.0
2022-09-19 05:00:00	AAPL	Stock	149.24	149.31	149.01	149.17	28173.0
2022-09-19 06:00:00	AAPL	Stock	149.09	149.2	148.71	149.2	35439.0
2022-09-19 07:00:00	AAPL	Stock	149.2	149.42	149.04	149.15	105321.0
2022-09-19 08:00:00	AAPL	Stock	149.17	149.88	149.0412	149.61	211504.0
2022-09-19 09:00:00	AAPL	Stock	149.62	151.12	149.08	151.105	9032543.0
2022-09-19 10:00:00	AAPL	Stock	151.11	152.4	150.57	152.09	10422305.0
2022-09-19 11:00:00	AAPL	Stock	152.1	152.83	151.75	151.94	9777289.0
2022-09-19 12:00:00	AAPL	Stock	151.9371	153.33	151.42	153.1607	7993050.0
2022-09-19 13:00:00	AAPL	Stock	153.161	153.45	152.7	152.9591	5849510.0
2022-09-19 14:00:00	AAPL	Stock	152.96	153.1801	152.6018	153.09	5711556.0
2022-09-19 15:00:00	AAPL	Stock	153.1	154.56	153.1	154.54	13750785.0
2022-09-19 16:00:00	AAPL	Stock	154.53	154.88	154.3	154.56	7113997.0
2022-09-19 17:00:00	AAPL	Stock	154.56	154.72	154.48	154.64	85106.0
2022-09-19 18:00:00	AAPL	Stock	154.67	154.91	154.62	154.79	33238.0
2022-09-19 19:00:00	AAPL	Stock	154.8	155.01	154.67	155.01	80668.0
2022-09-19 04:00:00	MSFT	Stock	243.0	243.28	242.5	242.5	6458.0
2022-09-19 05:00:00	MSFT	Stock	242.5	242.81	242.21	242.49	4099.0
2022-09-19 06:00:00	MSFT	Stock	242.35	242.48	242.1	242.48	2346.0
2022-09-19 07:00:00	MSFT	Stock	242.48	242.92	242.15	242.21	25912.0
2022-09-19 08:00:00	MSFT	Stock	242.1004	243.2741	242.1	243.07	35352.0
2022-09-19 09:00:00	MSFT	Stock	242.95	243.98	241.95	243.61	2178787.0
2022-09-19 10:00:00	MSFT	Stock	243.63	244.58	242.7101	243.62	2136179.0
2022-09-19 11:00:00	MSFT	Stock	243.66	244.18	241.65	241.6911	2201745.0
2022-09-19 12:00:00	MSFT	Stock	241.67	242.83	240.85	242.58	2785425.0
2022-09-19 13:00:00	MSFT	Stock	242.5706	242.76	241.75	242.3116	1563944.0
2022-09-19 14:00:00	MSFT	Stock	242.32	243.0999	241.8656	243.06	1754162.0
2022-09-19 15:00:00	MSFT	Stock	243.06	245.14	243.06	244.58	3801892.0
2022-09-19 16:00:00	MSFT	Stock	244.57	245.15	244.44	244.83	4112526.0
2022-09-19 17:00:00	MSFT	Stock	244.79	245.0	244.79	244.92	11075.0
2022-09-19 18:00:00	MSFT	Stock	244.9	245.16	244.75	245.12	6594.0
2022-09-19 19:00:00	MSFT	Stock	245.1	245.39	244.87	245.23	11771.0
2022-09-19 04:00:00	NVDA	Stock	13.136	13.136	12.985	13.0	182310.0
2022-09-19 05:00:00	NVDA	Stock	13.001	13.034	12.999	13.025	59840.0
2022-09-19 06:00:00	NVDA	Stock	13.025	13.025	12.983	13.022	86850.0
2022-09-19 07:00:00	NVDA	Stock	13.039	13.053	12.967	12.975	425620.0
2022-09-19 08:00:00	NVDA	Stock	13.035	13.098	12.97	13.07	1605240.0
2022-09-19 09:00:00	NVDA	Stock	13.075	13.339	13.01	13.2815	77204730.0
2022-09-19 10:00:00	NVDA	Stock	13.283	13.463	13.182	13.403	102354190.0
2022-09-19 11:00:00	NVDA	Stock	13.403	13.415	13.171	13.18	71897060.0
2022-09-19 12:00:00	NVDA	Stock	13.178	13.302	13.1411	13.291	45874240.0
2022-09-19 13:00:00	NVDA	Stock	13.288	13.295	13.202	13.2655	39210780.0
2022-09-19 14:00:00	NVDA	Stock	13.267	13.329	13.221	13.288	43478490.0
2022-09-19 15:00:00	NVDA	Stock	13.2872	13.3959	13.287	13.382	65354420.0
2022-09-19 16:00:00	NVDA	Stock	13.382	13.4329	13.365	13.406	25728500.0
2022-09-19 17:00:00	NVDA	Stock	13.403	13.412	13.392	13.395	237510.0
2022-09-19 18:00:00	NVDA	Stock	13.393	13.422	13.39	13.416	169340.0
2022-09-19 19:00:00	NVDA	Stock	13.418	13.45	13.401	13.45	395480.0
2022-09-19 04:00:00	AMZN	Stock	122.99	122.99	122.01	122.01	8564.0
2022-09-19 05:00:00	AMZN	Stock	122.12	122.28	122.05	122.23	5769.0

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

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