PREVIEW / stock_1hour / 2021-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-06.parquet
  size:    1.4 MB
  rows:    66,755
  symbols: 2,914

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
2021-07-06 04:00:00	AAPL	Stock	139.5	139.9	139.39	139.69	39522.0
2021-07-06 05:00:00	AAPL	Stock	139.66	139.9	139.66	139.72	9986.0
2021-07-06 06:00:00	AAPL	Stock	139.77	140.0	139.69	139.94	16834.0
2021-07-06 07:00:00	AAPL	Stock	139.92	140.38	139.84	140.31	245449.0
2021-07-06 08:00:00	AAPL	Stock	139.9402	140.38	139.611	140.17	401116.0
2021-07-06 09:00:00	AAPL	Stock	140.2288	142.885	140.0	142.73	19400238.0
2021-07-06 10:00:00	AAPL	Stock	142.73	143.15	141.8	141.815	17797327.0
2021-07-06 11:00:00	AAPL	Stock	141.8101	142.11	141.16	141.57	11839353.0
2021-07-06 12:00:00	AAPL	Stock	141.56	141.66	140.12	141.61	11881130.0
2021-07-06 13:00:00	AAPL	Stock	141.602	142.04	141.37	141.606	8569077.0
2021-07-06 14:00:00	AAPL	Stock	141.605	141.82	141.22	141.7197	6982588.0
2021-07-06 15:00:00	AAPL	Stock	141.715	142.2	141.63	142.02	11364604.0
2021-07-06 16:00:00	AAPL	Stock	142.06	142.15	141.76	141.99	7681639.0
2021-07-06 17:00:00	AAPL	Stock	141.95	142.02	141.93	142.0	43465.0
2021-07-06 18:00:00	AAPL	Stock	141.97	142.25	141.97	142.14	87176.0
2021-07-06 19:00:00	AAPL	Stock	142.17	142.25	142.0	142.06	74878.0
2021-07-06 04:00:00	MSFT	Stock	277.85	277.95	277.41	277.95	3142.0
2021-07-06 05:00:00	MSFT	Stock	277.82	277.9	277.78	277.78	1149.0
2021-07-06 06:00:00	MSFT	Stock	277.85	278.35	277.85	278.35	2889.0
2021-07-06 07:00:00	MSFT	Stock	278.11	278.63	278.0	278.4	20347.0
2021-07-06 08:00:00	MSFT	Stock	278.4	278.7	277.9	278.4592	34974.0
2021-07-06 09:00:00	MSFT	Stock	278.46	279.21	277.62	278.2199	3266427.0
2021-07-06 10:00:00	MSFT	Stock	278.2	279.3698	278.04	278.79	2788500.0
2021-07-06 11:00:00	MSFT	Stock	278.8	279.03	277.0425	277.42	2303387.0
2021-07-06 12:00:00	MSFT	Stock	277.4	277.567	274.3	276.5	4105234.0
2021-07-06 13:00:00	MSFT	Stock	276.5	276.86	275.93	276.18	1616163.0
2021-07-06 14:00:00	MSFT	Stock	276.17	276.885	276.13	276.6	1186434.0
2021-07-06 15:00:00	MSFT	Stock	276.6	277.73	276.48	277.66	2722860.0
2021-07-06 16:00:00	MSFT	Stock	277.66	278.0	277.2998	277.75	3513509.0
2021-07-06 17:00:00	MSFT	Stock	277.79	277.9	277.75	277.86	4316.0
2021-07-06 18:00:00	MSFT	Stock	277.82	277.94	277.82	277.86	1586.0
2021-07-06 19:00:00	MSFT	Stock	277.86	277.98	277.83	277.95	14469.0
2021-07-06 04:00:00	NVDA	Stock	20.451	20.5572	20.451	20.5572	53080.0
2021-07-06 05:00:00	NVDA	Stock	20.5558	20.5825	20.5558	20.5825	50280.0
2021-07-06 06:00:00	NVDA	Stock	20.5825	20.6	20.5825	20.6	87040.0
2021-07-06 07:00:00	NVDA	Stock	20.623	20.7973	20.623	20.75	1413480.0
2021-07-06 08:00:00	NVDA	Stock	20.74	20.8248	20.6076	20.755	1990480.0
2021-07-06 09:00:00	NVDA	Stock	20.7625	20.842	20.5625	20.7796	63586480.0
2021-07-06 10:00:00	NVDA	Stock	20.7762	20.837	20.6252	20.715	47154040.0
2021-07-06 11:00:00	NVDA	Stock	20.7098	20.7638	20.618	20.6598	24884160.0
2021-07-06 12:00:00	NVDA	Stock	20.6545	20.6545	20.3503	20.5801	47504800.0
2021-07-06 13:00:00	NVDA	Stock	20.5793	20.6837	20.538	20.6481	23984240.0
2021-07-06 14:00:00	NVDA	Stock	20.6461	20.7148	20.6003	20.6265	17923480.0
2021-07-06 15:00:00	NVDA	Stock	20.6264	20.7125	20.6195	20.7005	23934360.0
2021-07-06 16:00:00	NVDA	Stock	20.6985	20.7065	20.6875	20.6938	26683520.0
2021-07-06 17:00:00	NVDA	Stock	20.697	20.697	20.6798	20.6798	62320.0
2021-07-06 18:00:00	NVDA	Stock	20.6875	20.7248	20.6862	20.7195	451880.0
2021-07-06 19:00:00	NVDA	Stock	20.7143	20.7193	20.71	20.717	172520.0
2021-07-06 04:00:00	AMZN	Stock	175.75	175.7575	175.75	175.7575	12840.0
2021-07-06 05:00:00	AMZN	Stock	175.703	175.7685	175.703	175.75	8000.0

> showing 50 of 66,755 rows — these rows as CSV

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