PREVIEW / stock_1hour / 2022-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-08.parquet
  size:    1.3 MB
  rows:    60,601
  symbols: 2,302

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-07-08 04:00:00	AAPL	Stock	145.74	145.86	145.3	145.47	11205.0
2022-07-08 05:00:00	AAPL	Stock	145.36	145.51	145.19	145.51	9662.0
2022-07-08 06:00:00	AAPL	Stock	145.51	145.88	145.41	145.44	15286.0
2022-07-08 07:00:00	AAPL	Stock	145.59	145.76	145.5	145.7	30334.0
2022-07-08 08:00:00	AAPL	Stock	145.5525	145.985	144.25	144.86	619000.0
2022-07-08 09:00:00	AAPL	Stock	144.9	146.62	144.8	145.77	8408591.0
2022-07-08 10:00:00	AAPL	Stock	145.77	147.2699	145.4859	146.86	10795268.0
2022-07-08 11:00:00	AAPL	Stock	146.86	147.46	146.82	147.25	6416266.0
2022-07-08 12:00:00	AAPL	Stock	147.25	147.3	145.54	145.79	5974563.0
2022-07-08 13:00:00	AAPL	Stock	145.7906	147.11	145.54	146.845	5615845.0
2022-07-08 14:00:00	AAPL	Stock	146.85	147.55	146.62	147.46	5717824.0
2022-07-08 15:00:00	AAPL	Stock	147.46	147.54	146.84	147.03	8757540.0
2022-07-08 16:00:00	AAPL	Stock	147.03	147.04	146.66	147.02	4659432.0
2022-07-08 17:00:00	AAPL	Stock	147.0	147.04	146.77	146.8	77547.0
2022-07-08 18:00:00	AAPL	Stock	146.97	147.03	146.82	146.99	20420.0
2022-07-08 19:00:00	AAPL	Stock	146.99	147.0	146.77	146.78	24770.0
2022-07-08 04:00:00	MSFT	Stock	267.63	267.83	267.29	267.29	398.0
2022-07-08 05:00:00	MSFT	Stock	266.58	267.2	266.1	267.2	3331.0
2022-07-08 06:00:00	MSFT	Stock	267.9	267.9	267.2	267.2	379.0
2022-07-08 07:00:00	MSFT	Stock	266.8	267.9	266.8	267.9	3769.0
2022-07-08 08:00:00	MSFT	Stock	267.1903	267.729	264.1259	265.55	104844.0
2022-07-08 09:00:00	MSFT	Stock	265.6499	266.27	263.66	263.92	2032123.0
2022-07-08 10:00:00	MSFT	Stock	263.93	265.8185	263.285	265.77	2537545.0
2022-07-08 11:00:00	MSFT	Stock	265.7703	268.02	265.75	267.98	1623494.0
2022-07-08 12:00:00	MSFT	Stock	268.0	268.02	265.2	265.35	1060149.0
2022-07-08 13:00:00	MSFT	Stock	265.33	266.97	265.0579	266.66	1049533.0
2022-07-08 14:00:00	MSFT	Stock	266.64	267.89	266.27	267.76	1115280.0
2022-07-08 15:00:00	MSFT	Stock	267.77	268.1	267.03	267.66	2225028.0
2022-07-08 16:00:00	MSFT	Stock	267.59	267.7	267.45	267.61	2747246.0
2022-07-08 17:00:00	MSFT	Stock	267.51	267.66	267.51	267.5159	6774.0
2022-07-08 18:00:00	MSFT	Stock	267.54	267.7	267.5101	267.58	5246.0
2022-07-08 19:00:00	MSFT	Stock	267.55	267.61	267.51	267.6	2377.0
2022-07-08 04:00:00	NVDA	Stock	15.72	15.747	15.66	15.7	57450.0
2022-07-08 05:00:00	NVDA	Stock	15.672	15.682	15.605	15.67	61780.0
2022-07-08 06:00:00	NVDA	Stock	15.672	15.75	15.652	15.653	92950.0
2022-07-08 07:00:00	NVDA	Stock	15.656	15.741	15.65	15.735	350740.0
2022-07-08 08:00:00	NVDA	Stock	15.695	15.8976	15.495	15.513	2847010.0
2022-07-08 09:00:00	NVDA	Stock	15.53	15.696	15.38	15.4495	60599090.0
2022-07-08 10:00:00	NVDA	Stock	15.449	15.778	15.389	15.773	71497280.0
2022-07-08 11:00:00	NVDA	Stock	15.774	16.037	15.772	15.881	62308550.0
2022-07-08 12:00:00	NVDA	Stock	15.883	15.884	15.5644	15.6025	50051130.0
2022-07-08 13:00:00	NVDA	Stock	15.603	15.829	15.542	15.742	45394410.0
2022-07-08 14:00:00	NVDA	Stock	15.742	15.929	15.696	15.8609	43264200.0
2022-07-08 15:00:00	NVDA	Stock	15.863	15.876	15.768	15.838	49517930.0
2022-07-08 16:00:00	NVDA	Stock	15.833	15.853	15.817	15.82	12684940.0
2022-07-08 17:00:00	NVDA	Stock	15.822	15.83	15.816	15.8216	141520.0
2022-07-08 18:00:00	NVDA	Stock	15.822	15.829	15.815	15.827	136450.0
2022-07-08 19:00:00	NVDA	Stock	15.827	15.83	15.818	15.825	121420.0
2022-07-08 04:00:00	AMZN	Stock	115.8	116.0	115.22	115.48	4742.0
2022-07-08 05:00:00	AMZN	Stock	115.37	115.57	115.12	115.5	7994.0

> showing 50 of 60,601 rows — these rows as CSV

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