PREVIEW / stock_1hour / 2023-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-20.parquet
  size:    1.4 MB
  rows:    61,716
  symbols: 1,759

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-20 04:00:00	AAPL	Stock	154.38	154.66	151.75	154.62	62733.0
2023-03-20 05:00:00	AAPL	Stock	154.64	156.0	154.21	155.5	48570.0
2023-03-20 06:00:00	AAPL	Stock	155.31	155.65	155.03	155.5	20451.0
2023-03-20 07:00:00	AAPL	Stock	155.41	155.56	154.7	155.1	53468.0
2023-03-20 08:00:00	AAPL	Stock	155.15	155.75	153.68	155.19	185018.0
2023-03-20 09:00:00	AAPL	Stock	155.24	155.43	154.15	154.46	7332873.0
2023-03-20 10:00:00	AAPL	Stock	154.46	156.31	154.42	156.2099	7983572.0
2023-03-20 11:00:00	AAPL	Stock	156.2	156.88	155.99	156.275	7207316.0
2023-03-20 12:00:00	AAPL	Stock	156.28	156.87	155.735	156.74	5818201.0
2023-03-20 13:00:00	AAPL	Stock	156.75	157.77	156.69	157.385	7765495.0
2023-03-20 14:00:00	AAPL	Stock	157.3834	157.82	157.083	157.43	6308083.0
2023-03-20 15:00:00	AAPL	Stock	157.41	157.82	157.17	157.46	9283732.0
2023-03-20 16:00:00	AAPL	Stock	157.4	157.82	157.4	157.49	13050758.0
2023-03-20 17:00:00	AAPL	Stock	157.4969	157.58	157.4444	157.53	19552.0
2023-03-20 18:00:00	AAPL	Stock	157.53	157.56	157.36	157.43	31209.0
2023-03-20 19:00:00	AAPL	Stock	157.42	157.42	157.33	157.41	34865.0
2023-03-20 04:00:00	MSFT	Stock	275.83	279.99	275.83	279.8	32750.0
2023-03-20 05:00:00	MSFT	Stock	279.97	281.19	279.97	280.5	33673.0
2023-03-20 06:00:00	MSFT	Stock	280.52	280.97	279.36	280.07	33944.0
2023-03-20 07:00:00	MSFT	Stock	280.14	280.43	278.12	278.7	36627.0
2023-03-20 08:00:00	MSFT	Stock	279.7	280.43	277.1	278.9	92856.0
2023-03-20 09:00:00	MSFT	Stock	278.63	278.85	271.17	271.555	4837599.0
2023-03-20 10:00:00	MSFT	Stock	271.56	273.4	269.85	270.56	5919041.0
2023-03-20 11:00:00	MSFT	Stock	270.57	273.8309	270.312	271.045	4288920.0
2023-03-20 12:00:00	MSFT	Stock	271.04	271.34	269.92	270.8	2848669.0
2023-03-20 13:00:00	MSFT	Stock	270.82	271.51	270.7	271.35	2173509.0
2023-03-20 14:00:00	MSFT	Stock	271.34	271.44	270.27	270.86	2450496.0
2023-03-20 15:00:00	MSFT	Stock	270.84	272.24	270.27	272.23	4554913.0
2023-03-20 16:00:00	MSFT	Stock	272.23	272.4763	272.01	272.29	4362882.0
2023-03-20 17:00:00	MSFT	Stock	272.37	272.63	272.3599	272.37	9484.0
2023-03-20 18:00:00	MSFT	Stock	272.37	272.37	272.21	272.25	3118.0
2023-03-20 19:00:00	MSFT	Stock	272.3	272.3	271.75	272.0	9077.0
2023-03-20 04:00:00	NVDA	Stock	25.513	25.701	25.383	25.59	495820.0
2023-03-20 05:00:00	NVDA	Stock	25.68	25.877	25.675	25.877	242990.0
2023-03-20 06:00:00	NVDA	Stock	25.849	25.946	25.8	25.817	169900.0
2023-03-20 07:00:00	NVDA	Stock	25.83	25.833	25.652	25.7	745220.0
2023-03-20 08:00:00	NVDA	Stock	25.76	25.8464	25.302	25.784	2193850.0
2023-03-20 09:00:00	NVDA	Stock	25.789	25.7961	25.1298	25.274	47911210.0
2023-03-20 10:00:00	NVDA	Stock	25.267	25.652	25.236	25.624	53450640.0
2023-03-20 11:00:00	NVDA	Stock	25.629	25.844	25.538	25.543	50259380.0
2023-03-20 12:00:00	NVDA	Stock	25.547	25.815	25.501	25.773	36275770.0
2023-03-20 13:00:00	NVDA	Stock	25.777	26.024	25.733	25.994	43261700.0
2023-03-20 14:00:00	NVDA	Stock	25.9939	26.018	25.781	25.9	36178420.0
2023-03-20 15:00:00	NVDA	Stock	25.895	26.008	25.788	25.912	43293860.0
2023-03-20 16:00:00	NVDA	Stock	25.893	25.9	25.85	25.88	25075660.0
2023-03-20 17:00:00	NVDA	Stock	25.88	25.885	25.8624	25.873	144860.0
2023-03-20 18:00:00	NVDA	Stock	25.874	25.935	25.874	25.92	179840.0
2023-03-20 19:00:00	NVDA	Stock	25.92	25.962	25.91	25.96	350220.0
2023-03-20 04:00:00	AMZN	Stock	97.4	98.55	97.4	98.24	42636.0
2023-03-20 05:00:00	AMZN	Stock	98.4	98.71	98.22	98.59	9140.0

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

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