PREVIEW / stock_1hour / 2022-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-19.parquet
  size:    1.4 MB
  rows:    63,181
  symbols: 2,444

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-04-19 04:00:00	AAPL	Stock	165.5	165.61	164.25	164.41	28499.0
2022-04-19 05:00:00	AAPL	Stock	164.33	164.5	164.1	164.44	8850.0
2022-04-19 06:00:00	AAPL	Stock	164.36	164.74	164.35	164.65	5178.0
2022-04-19 07:00:00	AAPL	Stock	164.78	165.39	164.78	165.3	45898.0
2022-04-19 08:00:00	AAPL	Stock	165.0	166.43	164.79	165.08	270375.0
2022-04-19 09:00:00	AAPL	Stock	165.11	165.35	163.91	165.09	7865368.0
2022-04-19 10:00:00	AAPL	Stock	165.08	167.2742	164.89	166.78	9633683.0
2022-04-19 11:00:00	AAPL	Stock	166.78	167.45	166.51	166.9955	6059674.0
2022-04-19 12:00:00	AAPL	Stock	167.0	167.045	166.25	166.469	4481854.0
2022-04-19 13:00:00	AAPL	Stock	166.47	166.69	166.11	166.485	4311105.0
2022-04-19 14:00:00	AAPL	Stock	166.48	166.7	165.855	166.6099	5039144.0
2022-04-19 15:00:00	AAPL	Stock	166.605	167.82	166.495	167.46	12077462.0
2022-04-19 16:00:00	AAPL	Stock	167.465	167.465	165.92	166.45	8250946.0
2022-04-19 17:00:00	AAPL	Stock	166.4999	166.5	166.16	166.33	50451.0
2022-04-19 18:00:00	AAPL	Stock	166.34	166.71	166.34	166.51	32208.0
2022-04-19 19:00:00	AAPL	Stock	166.51	166.52	166.18	166.34	43016.0
2022-04-19 04:00:00	MSFT	Stock	281.39	281.8	279.2	279.2	8649.0
2022-04-19 05:00:00	MSFT	Stock	279.38	279.6	278.67	279.1	4263.0
2022-04-19 06:00:00	MSFT	Stock	279.82	279.82	279.8	279.8	200.0
2022-04-19 07:00:00	MSFT	Stock	279.87	280.65	279.7	280.65	17656.0
2022-04-19 08:00:00	MSFT	Stock	280.15	283.21	279.63	279.81	31139.0
2022-04-19 09:00:00	MSFT	Stock	280.15	282.42	278.41	282.42	2361053.0
2022-04-19 10:00:00	MSFT	Stock	282.4	284.75	282.06	283.93	2128432.0
2022-04-19 11:00:00	MSFT	Stock	283.88	284.865	283.58	284.2933	1477512.0
2022-04-19 12:00:00	MSFT	Stock	284.3	284.33	283.29	283.81	993009.0
2022-04-19 13:00:00	MSFT	Stock	283.7803	284.06	282.98	283.55	1222703.0
2022-04-19 14:00:00	MSFT	Stock	283.545	284.36	282.91	284.26	1221935.0
2022-04-19 15:00:00	MSFT	Stock	284.28	286.17	284.05	285.38	3305296.0
2022-04-19 16:00:00	MSFT	Stock	285.3	285.59	283.13	283.8057	3361723.0
2022-04-19 17:00:00	MSFT	Stock	283.8	283.98	283.5512	283.7009	7586.0
2022-04-19 18:00:00	MSFT	Stock	283.8	284.5	283.75	284.06	13890.0
2022-04-19 19:00:00	MSFT	Stock	284.05	284.3	283.51	283.74	6613.0
2022-04-19 04:00:00	NVDA	Stock	21.997	22.0	21.67	21.7	155670.0
2022-04-19 05:00:00	NVDA	Stock	21.675	21.725	21.606	21.664	82660.0
2022-04-19 06:00:00	NVDA	Stock	21.713	21.814	21.68	21.775	116420.0
2022-04-19 07:00:00	NVDA	Stock	21.824	21.9	21.771	21.881	398460.0
2022-04-19 08:00:00	NVDA	Stock	21.873	22.319	21.7695	21.86	1216480.0
2022-04-19 09:00:00	NVDA	Stock	21.87	21.871	21.314	21.757	65404750.0
2022-04-19 10:00:00	NVDA	Stock	21.747	22.339	21.725	22.259	85575940.0
2022-04-19 11:00:00	NVDA	Stock	22.254	22.373	22.143	22.261	54117330.0
2022-04-19 12:00:00	NVDA	Stock	22.266	22.2688	22.061	22.139	31981170.0
2022-04-19 13:00:00	NVDA	Stock	22.1405	22.173	22.029	22.126	31434870.0
2022-04-19 14:00:00	NVDA	Stock	22.127	22.136	21.911	22.122	39441200.0
2022-04-19 15:00:00	NVDA	Stock	22.122	22.255	22.016	22.205	59216080.0
2022-04-19 16:00:00	NVDA	Stock	22.2005	22.201	21.869	21.909	19318350.0
2022-04-19 17:00:00	NVDA	Stock	21.915	21.916	21.825	21.895	255430.0
2022-04-19 18:00:00	NVDA	Stock	21.885	21.979	21.877	21.93	248940.0
2022-04-19 19:00:00	NVDA	Stock	21.912	21.92	21.877	21.885	255490.0
2022-04-19 04:00:00	AMZN	Stock	153.2495	153.3775	153.2495	153.3445	6000.0
2022-04-19 05:00:00	AMZN	Stock	152.0	152.0495	151.9995	152.0495	8000.0

> showing 50 of 63,181 rows — these rows as CSV

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