PREVIEW / stock_1hour / 2023-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-30.parquet
  size:    1.3 MB
  rows:    59,767
  symbols: 1,722

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-03-30 04:00:00	AAPL	Stock	161.15	161.15	160.86	160.95	4958.0
2023-03-30 05:00:00	AAPL	Stock	160.94	161.08	160.9	161.04	11182.0
2023-03-30 06:00:00	AAPL	Stock	161.04	161.29	160.95	161.26	15786.0
2023-03-30 07:00:00	AAPL	Stock	161.2	161.47	161.08	161.15	75610.0
2023-03-30 08:00:00	AAPL	Stock	161.16	161.49	160.25	161.22	149136.0
2023-03-30 09:00:00	AAPL	Stock	161.22	161.97	160.77	161.97	5927267.0
2023-03-30 10:00:00	AAPL	Stock	161.96	162.47	161.5	162.32	7225836.0
2023-03-30 11:00:00	AAPL	Stock	162.325	162.395	161.95	162.0846	4388641.0
2023-03-30 12:00:00	AAPL	Stock	162.09	162.225	161.62	161.7284	4151040.0
2023-03-30 13:00:00	AAPL	Stock	161.725	162.05	161.35	161.58	3451299.0
2023-03-30 14:00:00	AAPL	Stock	161.58	162.3318	161.545	162.05	4017438.0
2023-03-30 15:00:00	AAPL	Stock	162.05	162.38	161.86	162.37	5881309.0
2023-03-30 16:00:00	AAPL	Stock	162.36	162.46	162.3	162.35	5958500.0
2023-03-30 17:00:00	AAPL	Stock	162.31	162.36	162.26	162.27	24825.0
2023-03-30 18:00:00	AAPL	Stock	162.25	162.29	162.2	162.29	19096.0
2023-03-30 19:00:00	AAPL	Stock	162.3	162.47	162.26	162.44	20395.0
2023-03-30 04:00:00	MSFT	Stock	281.33	281.43	281.02	281.42	4881.0
2023-03-30 05:00:00	MSFT	Stock	281.4	282.72	281.4	282.33	5660.0
2023-03-30 06:00:00	MSFT	Stock	282.35	282.9	282.29	282.6	3879.0
2023-03-30 07:00:00	MSFT	Stock	282.51	283.67	282.45	283.51	30025.0
2023-03-30 08:00:00	MSFT	Stock	282.74	284.39	280.69	284.01	129151.0
2023-03-30 09:00:00	MSFT	Stock	283.96	284.72	282.3273	283.4729	2981049.0
2023-03-30 10:00:00	MSFT	Stock	283.47	283.9	282.17	282.76	2807304.0
2023-03-30 11:00:00	MSFT	Stock	282.74	283.75	282.44	283.2	1885950.0
2023-03-30 12:00:00	MSFT	Stock	283.2	283.59	281.86	282.08	1697865.0
2023-03-30 13:00:00	MSFT	Stock	282.09	282.22	281.48	282.03	1407987.0
2023-03-30 14:00:00	MSFT	Stock	282.0609	283.52	282.02	283.3224	1772661.0
2023-03-30 15:00:00	MSFT	Stock	283.31	284.13	282.88	284.09	2732865.0
2023-03-30 16:00:00	MSFT	Stock	284.05	284.1886	283.9	284.03	2874557.0
2023-03-30 17:00:00	MSFT	Stock	284.0117	284.13	283.82	283.83	5515.0
2023-03-30 18:00:00	MSFT	Stock	283.63	283.75	283.2	283.57	11776.0
2023-03-30 19:00:00	MSFT	Stock	283.55	284.25	283.55	284.25	5663.0
2023-03-30 04:00:00	NVDA	Stock	27.05	27.076	26.998	27.064	102380.0
2023-03-30 05:00:00	NVDA	Stock	27.07	27.14	27.07	27.13	65640.0
2023-03-30 06:00:00	NVDA	Stock	27.12	27.196	27.12	27.174	167260.0
2023-03-30 07:00:00	NVDA	Stock	27.168	27.235	27.147	27.215	465660.0
2023-03-30 08:00:00	NVDA	Stock	27.188	27.318	26.861	27.261	1304060.0
2023-03-30 09:00:00	NVDA	Stock	27.267	27.3153	27.102	27.285	40153890.0
2023-03-30 10:00:00	NVDA	Stock	27.2835	27.48	27.157	27.4273	64529570.0
2023-03-30 11:00:00	NVDA	Stock	27.427	27.499	27.296	27.367	36305510.0
2023-03-30 12:00:00	NVDA	Stock	27.37	27.3738	27.251	27.32	28769380.0
2023-03-30 13:00:00	NVDA	Stock	27.319	27.374	27.1655	27.231	24747880.0
2023-03-30 14:00:00	NVDA	Stock	27.23	27.368	27.194	27.35	26528530.0
2023-03-30 15:00:00	NVDA	Stock	27.35	27.449	27.307	27.395	39677670.0
2023-03-30 16:00:00	NVDA	Stock	27.383	27.433	27.375	27.397	19172270.0
2023-03-30 17:00:00	NVDA	Stock	27.395	27.3999	27.38	27.388	248840.0
2023-03-30 18:00:00	NVDA	Stock	27.388	27.388	27.31	27.332	376880.0
2023-03-30 19:00:00	NVDA	Stock	27.35	27.38	27.331	27.331	250010.0
2023-03-30 04:00:00	AMZN	Stock	100.12	100.57	100.12	100.56	6853.0
2023-03-30 05:00:00	AMZN	Stock	100.55	100.69	100.52	100.6	7496.0

> showing 50 of 59,767 rows — these rows as CSV

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