PREVIEW / stock_1hour / 2022-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-24.parquet
  size:    1.4 MB
  rows:    61,326
  symbols: 2,135

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-10-24 04:00:00	AAPL	Stock	147.9	147.9	145.64	146.06	79141.0
2022-10-24 05:00:00	AAPL	Stock	146.11	146.78	145.9	146.65	30402.0
2022-10-24 06:00:00	AAPL	Stock	146.67	147.27	146.5	147.26	54697.0
2022-10-24 07:00:00	AAPL	Stock	147.27	148.15	147.2	147.83	166015.0
2022-10-24 08:00:00	AAPL	Stock	147.39	148.13	146.41	147.24	289699.0
2022-10-24 09:00:00	AAPL	Stock	147.25	148.35	146.25	148.2811	10875058.0
2022-10-24 10:00:00	AAPL	Stock	148.29	148.34	146.0	147.69	10303481.0
2022-10-24 11:00:00	AAPL	Stock	147.6813	148.49	147.41	148.475	7938484.0
2022-10-24 12:00:00	AAPL	Stock	148.47	148.82	148.185	148.495	6458880.0
2022-10-24 13:00:00	AAPL	Stock	148.5	148.7	147.91	148.55	4835545.0
2022-10-24 14:00:00	AAPL	Stock	148.56	149.87	148.5	149.7897	6511020.0
2022-10-24 15:00:00	AAPL	Stock	149.785	150.23	149.13	149.56	11912459.0
2022-10-24 16:00:00	AAPL	Stock	149.56	149.68	149.29	149.35	7158698.0
2022-10-24 17:00:00	AAPL	Stock	149.36	149.56	149.28	149.41	85399.0
2022-10-24 18:00:00	AAPL	Stock	149.43	149.58	149.42	149.54	21909.0
2022-10-24 19:00:00	AAPL	Stock	149.54	149.65	149.5	149.59	42705.0
2022-10-24 04:00:00	MSFT	Stock	241.99	242.21	240.91	241.99	17746.0
2022-10-24 05:00:00	MSFT	Stock	241.58	243.3	241.58	243.0	5792.0
2022-10-24 06:00:00	MSFT	Stock	243.26	244.47	242.1	244.26	10032.0
2022-10-24 07:00:00	MSFT	Stock	243.64	244.98	243.47	244.51	26293.0
2022-10-24 08:00:00	MSFT	Stock	244.0	245.17	241.515	244.688	87642.0
2022-10-24 09:00:00	MSFT	Stock	244.69	245.73	241.5	244.63	3131991.0
2022-10-24 10:00:00	MSFT	Stock	244.62	244.66	241.295	244.2344	3088582.0
2022-10-24 11:00:00	MSFT	Stock	244.245	245.84	243.37	245.77	1926757.0
2022-10-24 12:00:00	MSFT	Stock	245.77	246.7	245.27	246.05	1524413.0
2022-10-24 13:00:00	MSFT	Stock	246.05	246.0775	244.82	245.29	1182491.0
2022-10-24 14:00:00	MSFT	Stock	245.29	247.15	245.195	247.1132	1503652.0
2022-10-24 15:00:00	MSFT	Stock	247.17	247.84	246.41	247.32	3168836.0
2022-10-24 16:00:00	MSFT	Stock	247.25	247.49	246.3221	246.62	3324710.0
2022-10-24 17:00:00	MSFT	Stock	246.7286	246.94	246.55	246.7476	11262.0
2022-10-24 18:00:00	MSFT	Stock	246.6	246.97	246.5	246.95	8680.0
2022-10-24 19:00:00	MSFT	Stock	247.0	247.5	246.9	247.5	23465.0
2022-10-24 04:00:00	NVDA	Stock	12.423	12.448	12.258	12.336	171900.0
2022-10-24 05:00:00	NVDA	Stock	12.33	12.443	12.317	12.439	80860.0
2022-10-24 06:00:00	NVDA	Stock	12.44	12.514	12.411	12.514	119710.0
2022-10-24 07:00:00	NVDA	Stock	12.506	12.588	12.494	12.565	393220.0
2022-10-24 08:00:00	NVDA	Stock	12.514	12.597	12.4349	12.53	1535480.0
2022-10-24 09:00:00	NVDA	Stock	12.507	12.565	12.22	12.265	63348270.0
2022-10-24 10:00:00	NVDA	Stock	12.27	12.3482	12.064	12.334	81040020.0
2022-10-24 11:00:00	NVDA	Stock	12.3365	12.5248	12.295	12.5085	65534850.0
2022-10-24 12:00:00	NVDA	Stock	12.509	12.557	12.446	12.504	48536990.0
2022-10-24 13:00:00	NVDA	Stock	12.503	12.564	12.424	12.527	44102620.0
2022-10-24 14:00:00	NVDA	Stock	12.53	12.682	12.52	12.61	60908420.0
2022-10-24 15:00:00	NVDA	Stock	12.612	12.71	12.5671	12.599	60867020.0
2022-10-24 16:00:00	NVDA	Stock	12.599	12.612	12.518	12.55	21389410.0
2022-10-24 17:00:00	NVDA	Stock	12.542	12.586	12.54	12.556	256590.0
2022-10-24 18:00:00	NVDA	Stock	12.56	12.585	12.555	12.585	148570.0
2022-10-24 19:00:00	NVDA	Stock	12.585	12.59	12.56	12.56	225350.0
2022-10-24 04:00:00	AMZN	Stock	119.02	119.2	118.2	118.79	16300.0
2022-10-24 05:00:00	AMZN	Stock	118.85	119.65	118.61	119.35	15736.0

> showing 50 of 61,326 rows — these rows as CSV

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