PREVIEW / stock_1hour / 2022-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-14.parquet
  size:    1.4 MB
  rows:    63,773
  symbols: 2,420

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-06-14 04:00:00	AAPL	Stock	133.01	134.0	133.01	133.1	38557.0
2022-06-14 05:00:00	AAPL	Stock	133.15	133.3	133.0	133.15	14501.0
2022-06-14 06:00:00	AAPL	Stock	133.0	133.28	132.5	133.13	25200.0
2022-06-14 07:00:00	AAPL	Stock	133.0	133.06	132.35	132.4	73608.0
2022-06-14 08:00:00	AAPL	Stock	132.8299	134.47	131.551	133.2	735880.0
2022-06-14 09:00:00	AAPL	Stock	133.16	133.77	131.53	133.1001	10435359.0
2022-06-14 10:00:00	AAPL	Stock	133.11	133.25	131.48	132.5898	11767633.0
2022-06-14 11:00:00	AAPL	Stock	132.58	132.95	131.82	132.81	7877699.0
2022-06-14 12:00:00	AAPL	Stock	132.81	132.84	131.91	132.5	5505445.0
2022-06-14 13:00:00	AAPL	Stock	132.5	133.89	132.29	132.4802	7405388.0
2022-06-14 14:00:00	AAPL	Stock	132.49	133.14	132.285	132.4	6639980.0
2022-06-14 15:00:00	AAPL	Stock	132.395	133.49	131.71	132.86	13592442.0
2022-06-14 16:00:00	AAPL	Stock	132.76	132.87	132.62	132.84	8341559.0
2022-06-14 17:00:00	AAPL	Stock	132.81	132.9099	132.69	132.72	179157.0
2022-06-14 18:00:00	AAPL	Stock	132.74	133.3	132.74	133.07	97899.0
2022-06-14 19:00:00	AAPL	Stock	133.15	133.9	133.0	133.79	121786.0
2022-06-14 04:00:00	MSFT	Stock	244.87	245.4	243.82	243.89	13340.0
2022-06-14 05:00:00	MSFT	Stock	243.9	244.5	243.84	244.06	6159.0
2022-06-14 06:00:00	MSFT	Stock	244.03	244.85	243.63	244.85	4088.0
2022-06-14 07:00:00	MSFT	Stock	244.52	244.61	243.16	243.16	13673.0
2022-06-14 08:00:00	MSFT	Stock	244.891	247.42	241.655	243.4274	64748.0
2022-06-14 09:00:00	MSFT	Stock	243.38	245.19	241.85	243.575	2453417.0
2022-06-14 10:00:00	MSFT	Stock	243.58	244.25	241.51	243.27	2589505.0
2022-06-14 11:00:00	MSFT	Stock	243.27	244.32	241.89	244.12	1890593.0
2022-06-14 12:00:00	MSFT	Stock	244.105	244.23	242.86	244.17	1351096.0
2022-06-14 13:00:00	MSFT	Stock	244.16	245.74	243.3	243.5701	1868952.0
2022-06-14 14:00:00	MSFT	Stock	243.57	244.47	242.98	243.04	1703284.0
2022-06-14 15:00:00	MSFT	Stock	243.065	245.69	242.23	244.5676	4134004.0
2022-06-14 16:00:00	MSFT	Stock	244.49	244.97	244.0162	244.7	4273580.0
2022-06-14 17:00:00	MSFT	Stock	244.7	245.47	244.02	245.0	67261.0
2022-06-14 18:00:00	MSFT	Stock	244.97	245.56	244.79	245.2	6229.0
2022-06-14 19:00:00	MSFT	Stock	245.26	246.98	244.55	246.8	15840.0
2022-06-14 04:00:00	NVDA	Stock	15.905	15.976	15.813	15.829	225230.0
2022-06-14 05:00:00	NVDA	Stock	15.816	15.888	15.805	15.851	61370.0
2022-06-14 06:00:00	NVDA	Stock	15.821	15.875	15.755	15.855	107520.0
2022-06-14 07:00:00	NVDA	Stock	15.833	15.859	15.681	15.7	468070.0
2022-06-14 08:00:00	NVDA	Stock	15.8	16.16	15.6808	15.825	1041710.0
2022-06-14 09:00:00	NVDA	Stock	15.825	15.918	15.412	15.763	53881310.0
2022-06-14 10:00:00	NVDA	Stock	15.766	15.829	15.5	15.716	62306720.0
2022-06-14 11:00:00	NVDA	Stock	15.712	15.933	15.637	15.9055	53087000.0
2022-06-14 12:00:00	NVDA	Stock	15.907	15.909	15.717	15.794	38905360.0
2022-06-14 13:00:00	NVDA	Stock	15.792	16.066	15.775	15.8182	47453190.0
2022-06-14 14:00:00	NVDA	Stock	15.816	15.9	15.758	15.765	37137440.0
2022-06-14 15:00:00	NVDA	Stock	15.766	15.9	15.596	15.844	66937000.0
2022-06-14 16:00:00	NVDA	Stock	15.836	15.894	15.812	15.892	18280630.0
2022-06-14 17:00:00	NVDA	Stock	15.895	15.916	15.836	15.877	229350.0
2022-06-14 18:00:00	NVDA	Stock	15.874	15.976	15.874	15.95	306720.0
2022-06-14 19:00:00	NVDA	Stock	15.934	16.052	15.915	16.032	434670.0
2022-06-14 04:00:00	AMZN	Stock	105.26	108.57	104.58	104.61	37054.0
2022-06-14 05:00:00	AMZN	Stock	104.74	104.95	104.44	104.7	21072.0

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

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