PREVIEW / stock_1hour / 2022-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-04.parquet
  size:    1.4 MB
  rows:    63,276
  symbols: 2,448

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-05-04 04:00:00	AAPL	Stock	159.88	159.88	159.43	159.52	6809.0
2022-05-04 05:00:00	AAPL	Stock	159.38	159.75	159.22	159.67	3853.0
2022-05-04 06:00:00	AAPL	Stock	159.75	160.0	159.63	159.94	10121.0
2022-05-04 07:00:00	AAPL	Stock	159.84	160.16	159.69	159.81	56258.0
2022-05-04 08:00:00	AAPL	Stock	159.9452	160.17	159.35	159.35	1574639.0
2022-05-04 09:00:00	AAPL	Stock	159.38	161.32	159.25	160.425	10356885.0
2022-05-04 10:00:00	AAPL	Stock	160.4388	160.812	159.4865	160.19	11281497.0
2022-05-04 11:00:00	AAPL	Stock	160.2	161.05	159.26	160.7789	7733197.0
2022-05-04 12:00:00	AAPL	Stock	160.77	161.94	160.31	161.913	6690216.0
2022-05-04 13:00:00	AAPL	Stock	161.92	162.92	161.55	162.6	7875869.0
2022-05-04 14:00:00	AAPL	Stock	162.58	164.1	159.66	163.835	19378859.0
2022-05-04 15:00:00	AAPL	Stock	163.85	166.48	163.29	166.14	23036255.0
2022-05-04 16:00:00	AAPL	Stock	166.12	166.15	160.1493	165.6738	6991655.0
2022-05-04 17:00:00	AAPL	Stock	165.6	166.0	165.53	165.92	134745.0
2022-05-04 18:00:00	AAPL	Stock	165.94	166.09	165.78	165.88	74776.0
2022-05-04 19:00:00	AAPL	Stock	165.83	165.98	165.67	165.77	66415.0
2022-05-04 04:00:00	MSFT	Stock	281.77	281.77	281.77	281.77	100.0
2022-05-04 05:00:00	MSFT	Stock	281.93	282.56	281.9	282.1	2293.0
2022-05-04 06:00:00	MSFT	Stock	282.3	282.3	282.1	282.1	708.0
2022-05-04 07:00:00	MSFT	Stock	282.4	282.93	282.1	282.5	3092.0
2022-05-04 08:00:00	MSFT	Stock	282.2601	282.78	281.78	282.0999	447636.0
2022-05-04 09:00:00	MSFT	Stock	282.01	284.21	280.52	280.56	1888084.0
2022-05-04 10:00:00	MSFT	Stock	280.61	281.39	277.735	278.04	2753421.0
2022-05-04 11:00:00	MSFT	Stock	278.02	279.62	276.73	279.313	1976420.0
2022-05-04 12:00:00	MSFT	Stock	279.315	282.169	279.0799	282.14	1550800.0
2022-05-04 13:00:00	MSFT	Stock	282.13	283.84	281.49	283.33	1517765.0
2022-05-04 14:00:00	MSFT	Stock	283.25	286.23	278.28	285.61	4439210.0
2022-05-04 15:00:00	MSFT	Stock	285.65	290.88	284.76	290.03	5977949.0
2022-05-04 16:00:00	MSFT	Stock	290.11	290.13	282.917	288.94	3704490.0
2022-05-04 17:00:00	MSFT	Stock	288.94	289.66	288.72	289.27	12281.0
2022-05-04 18:00:00	MSFT	Stock	289.27	289.8	289.13	289.15	7873.0
2022-05-04 19:00:00	MSFT	Stock	289.35	289.35	289.0	289.07	3573.0
2022-05-04 04:00:00	NVDA	Stock	20.137	20.137	19.919	19.94	272100.0
2022-05-04 05:00:00	NVDA	Stock	19.932	19.95	19.858	19.95	114340.0
2022-05-04 06:00:00	NVDA	Stock	19.951	19.984	19.93	19.98	94420.0
2022-05-04 07:00:00	NVDA	Stock	19.959	20.0	19.925	19.98	486930.0
2022-05-04 08:00:00	NVDA	Stock	19.997	20.05	19.892	19.9195	998760.0
2022-05-04 09:00:00	NVDA	Stock	19.926	19.995	19.192	19.217	52778710.0
2022-05-04 10:00:00	NVDA	Stock	19.22	19.257	18.895	18.995	76827490.0
2022-05-04 11:00:00	NVDA	Stock	18.99	19.006	18.751	18.928	48180160.0
2022-05-04 12:00:00	NVDA	Stock	18.9265	19.302	18.879	19.2322	49006820.0
2022-05-04 13:00:00	NVDA	Stock	19.236	19.39	19.153	19.303	38179300.0
2022-05-04 14:00:00	NVDA	Stock	19.3	19.898	18.851	19.8528	94368300.0
2022-05-04 15:00:00	NVDA	Stock	19.843	20.4	19.838	20.343	120107130.0
2022-05-04 16:00:00	NVDA	Stock	20.342	20.375	20.227	20.301	26926640.0
2022-05-04 17:00:00	NVDA	Stock	20.309	20.325	20.26	20.2602	478140.0
2022-05-04 18:00:00	NVDA	Stock	20.279	20.32	20.268	20.304	333990.0
2022-05-04 19:00:00	NVDA	Stock	20.305	20.324	20.282	20.311	306100.0
2022-05-04 06:00:00	AMZN	Stock	124.225	124.2495	124.225	124.2495	4000.0
2022-05-04 08:00:00	AMZN	Stock	124.45	124.74	124.35	124.35	21780.0

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

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