PREVIEW / stock_1hour / 2022-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-29.parquet
  size:    1.4 MB
  rows:    63,772
  symbols: 2,477

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-29 04:00:00	AAPL	Stock	161.0	161.5	159.63	159.9	149198.0
2022-04-29 05:00:00	AAPL	Stock	159.87	159.98	158.97	159.23	88420.0
2022-04-29 06:00:00	AAPL	Stock	159.24	159.65	159.02	159.2	57191.0
2022-04-29 07:00:00	AAPL	Stock	159.25	161.56	159.0	160.73	401277.0
2022-04-29 08:00:00	AAPL	Stock	159.35	162.85	159.01	161.76	1716152.0
2022-04-29 09:00:00	AAPL	Stock	161.71	165.99	160.51	165.9899	19199872.0
2022-04-29 10:00:00	AAPL	Stock	165.985	166.2	161.72	162.3542	17590572.0
2022-04-29 11:00:00	AAPL	Stock	162.34	162.5708	161.15	161.54	9572647.0
2022-04-29 12:00:00	AAPL	Stock	161.5309	161.64	159.8	160.07	8851064.0
2022-04-29 13:00:00	AAPL	Stock	160.06	160.7299	159.59	160.01	7712504.0
2022-04-29 14:00:00	AAPL	Stock	160.0	160.39	159.285	159.785	8649540.0
2022-04-29 15:00:00	AAPL	Stock	159.78	159.78	157.25	157.71	21679267.0
2022-04-29 16:00:00	AAPL	Stock	157.67	157.95	157.31	157.9	17968145.0
2022-04-29 17:00:00	AAPL	Stock	157.89	157.94	157.75	157.86	137988.0
2022-04-29 18:00:00	AAPL	Stock	157.85	157.93	157.8	157.9	56727.0
2022-04-29 19:00:00	AAPL	Stock	157.8701	158.15	157.86	157.93	76555.0
2022-04-29 04:00:00	MSFT	Stock	289.99	290.94	289.14	289.69	8857.0
2022-04-29 05:00:00	MSFT	Stock	289.53	289.84	289.15	289.15	9525.0
2022-04-29 06:00:00	MSFT	Stock	289.01	289.58	289.0	289.58	4855.0
2022-04-29 07:00:00	MSFT	Stock	289.15	289.5	288.0	288.5	12702.0
2022-04-29 08:00:00	MSFT	Stock	289.0015	290.69	288.0	288.5001	37821.0
2022-04-29 09:00:00	MSFT	Stock	288.53	289.88	286.681	287.39	2732720.0
2022-04-29 10:00:00	MSFT	Stock	287.39	287.54	283.79	284.57	2867652.0
2022-04-29 11:00:00	MSFT	Stock	284.56	285.58	283.4069	284.12	2065231.0
2022-04-29 12:00:00	MSFT	Stock	284.17	284.265	282.9	283.1999	1581473.0
2022-04-29 13:00:00	MSFT	Stock	283.17	284.48	282.5201	282.53	1310317.0
2022-04-29 14:00:00	MSFT	Stock	282.545	282.77	280.76	281.231	1779128.0
2022-04-29 15:00:00	MSFT	Stock	281.23	281.28	276.5	277.54	6774937.0
2022-04-29 16:00:00	MSFT	Stock	277.63	279.07	276.5	278.09	7478734.0
2022-04-29 17:00:00	MSFT	Stock	278.15	278.5	278.12	278.32	23723.0
2022-04-29 18:00:00	MSFT	Stock	278.45	278.45	278.1	278.23	8630.0
2022-04-29 19:00:00	MSFT	Stock	278.2	278.4	278.0	278.24	28663.0
2022-04-29 04:00:00	NVDA	Stock	19.538	19.567	19.401	19.505	340560.0
2022-04-29 05:00:00	NVDA	Stock	19.51	19.532	19.41	19.48	327850.0
2022-04-29 06:00:00	NVDA	Stock	19.488	19.488	19.362	19.402	48110.0
2022-04-29 07:00:00	NVDA	Stock	19.367	19.424	19.3	19.33	253130.0
2022-04-29 08:00:00	NVDA	Stock	19.3522	19.579	19.281	19.36	1154830.0
2022-04-29 09:00:00	NVDA	Stock	19.378	20.1285	19.25	20.0818	50793280.0
2022-04-29 10:00:00	NVDA	Stock	20.081	20.1095	19.282	19.441	67113260.0
2022-04-29 11:00:00	NVDA	Stock	19.437	19.56	19.268	19.339	43017800.0
2022-04-29 12:00:00	NVDA	Stock	19.341	19.36	18.978	19.007	36481040.0
2022-04-29 13:00:00	NVDA	Stock	19.002	19.234	18.985	19.051	35638580.0
2022-04-29 14:00:00	NVDA	Stock	19.052	19.0767	18.691	18.791	40124070.0
2022-04-29 15:00:00	NVDA	Stock	18.79	18.8143	18.517	18.546	67695750.0
2022-04-29 16:00:00	NVDA	Stock	18.547	18.623	18.53	18.601	40869410.0
2022-04-29 17:00:00	NVDA	Stock	18.614	18.623	18.57	18.596	255600.0
2022-04-29 18:00:00	NVDA	Stock	18.595	18.609	18.591	18.609	88700.0
2022-04-29 19:00:00	NVDA	Stock	18.605	18.65	18.593	18.64	201300.0
2022-04-29 04:00:00	AMZN	Stock	131.8005	132.5505	131.8005	132.3205	96460.0
2022-04-29 05:00:00	AMZN	Stock	132.25	132.25	132.0	132.0	32080.0

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

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