PREVIEW / stock_1hour / 2023-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-25.parquet
  size:    1.3 MB
  rows:    60,690
  symbols: 1,671

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
2023-05-25 04:00:00	AAPL	Stock	171.37	171.8	171.37	171.64	37071.0
2023-05-25 05:00:00	AAPL	Stock	171.72	171.75	171.52	171.65	18216.0
2023-05-25 06:00:00	AAPL	Stock	171.59	171.68	171.08	171.13	39570.0
2023-05-25 07:00:00	AAPL	Stock	171.16	171.2	170.67	171.15	128872.0
2023-05-25 08:00:00	AAPL	Stock	171.1582	172.18	170.75	172.16	439719.0
2023-05-25 09:00:00	AAPL	Stock	172.16	173.22	172.05	172.51	6685745.0
2023-05-25 10:00:00	AAPL	Stock	172.515	172.87	171.69	172.42	5265035.0
2023-05-25 11:00:00	AAPL	Stock	172.43	172.8	171.755	172.32	4238155.0
2023-05-25 12:00:00	AAPL	Stock	172.315	173.73	172.305	173.0988	5251203.0
2023-05-25 13:00:00	AAPL	Stock	173.11	173.465	172.84	173.375	3058193.0
2023-05-25 14:00:00	AAPL	Stock	173.38	173.895	172.7	172.82	4028164.0
2023-05-25 15:00:00	AAPL	Stock	172.826	173.8588	172.82	172.9984	7001336.0
2023-05-25 16:00:00	AAPL	Stock	172.98	173.5442	172.88	172.99	9247605.0
2023-05-25 17:00:00	AAPL	Stock	172.94	172.99	172.75	172.87	22127.0
2023-05-25 18:00:00	AAPL	Stock	172.89	172.99	172.88	172.98	13698.0
2023-05-25 19:00:00	AAPL	Stock	172.9899	172.9899	172.6	172.85	19939.0
2023-05-25 04:00:00	MSFT	Stock	318.97	319.97	318.51	319.34	18671.0
2023-05-25 05:00:00	MSFT	Stock	319.35	319.77	319.11	319.7	21721.0
2023-05-25 06:00:00	MSFT	Stock	319.81	320.5	319.6	320.47	31227.0
2023-05-25 07:00:00	MSFT	Stock	320.51	321.84	320.11	321.45	121104.0
2023-05-25 08:00:00	MSFT	Stock	320.47	323.48	319.52	323.0	234836.0
2023-05-25 09:00:00	MSFT	Stock	323.06	324.5	320.0	320.62	5064738.0
2023-05-25 10:00:00	MSFT	Stock	320.63	323.9	320.52	323.86	4254342.0
2023-05-25 11:00:00	MSFT	Stock	323.8699	325.59	322.97	323.23	4547509.0
2023-05-25 12:00:00	MSFT	Stock	323.25	325.53	323.21	324.5504	2274167.0
2023-05-25 13:00:00	MSFT	Stock	324.56	325.75	324.48	325.48	1741144.0
2023-05-25 14:00:00	MSFT	Stock	325.47	326.41	324.51	324.8108	2405087.0
2023-05-25 15:00:00	MSFT	Stock	324.8	326.9	324.8	325.96	4752556.0
2023-05-25 16:00:00	MSFT	Stock	325.97	326.3	325.5	325.61	5145512.0
2023-05-25 17:00:00	MSFT	Stock	325.61	325.7	325.16	325.4	21147.0
2023-05-25 18:00:00	MSFT	Stock	325.3	325.4	324.39	324.5	18088.0
2023-05-25 19:00:00	MSFT	Stock	324.5	324.75	323.72	323.9	39646.0
2023-05-25 04:00:00	NVDA	Stock	37.222	38.235	37.071	37.89	5960290.0
2023-05-25 05:00:00	NVDA	Stock	37.89	38.47	37.822	38.42	1742590.0
2023-05-25 06:00:00	NVDA	Stock	38.427	39.1	38.35	38.95	3232050.0
2023-05-25 07:00:00	NVDA	Stock	38.902	39.498	38.646	39.4	12480500.0
2023-05-25 08:00:00	NVDA	Stock	38.917	39.95	36.69	39.468	32330470.0
2023-05-25 09:00:00	NVDA	Stock	39.468	39.73	36.635	37.95	279694080.0
2023-05-25 10:00:00	NVDA	Stock	37.945	38.5	37.7	38.179	195220690.0
2023-05-25 11:00:00	NVDA	Stock	38.1755	39.48	38.034	38.53	195703980.0
2023-05-25 12:00:00	NVDA	Stock	38.535	38.796	38.201	38.7179	106635830.0
2023-05-25 13:00:00	NVDA	Stock	38.721	38.895	38.433	38.4892	68225310.0
2023-05-25 14:00:00	NVDA	Stock	38.496	38.597	38.0951	38.203	75035760.0
2023-05-25 15:00:00	NVDA	Stock	38.203	38.548	37.78	37.979	128757870.0
2023-05-25 16:00:00	NVDA	Stock	37.98	38.05	37.78	37.827	49157120.0
2023-05-25 17:00:00	NVDA	Stock	37.827	37.98	37.666	37.875	1273520.0
2023-05-25 18:00:00	NVDA	Stock	37.88	37.92	37.809	37.85	499030.0
2023-05-25 19:00:00	NVDA	Stock	37.871	37.897	37.795	37.795	586040.0
2023-05-25 04:00:00	AMZN	Stock	116.86	117.33	116.7	117.18	35224.0
2023-05-25 05:00:00	AMZN	Stock	117.16	117.37	116.9	117.01	13459.0

> showing 50 of 60,690 rows — these rows as CSV

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