PREVIEW / stock_1hour / 2022-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-10.parquet
  size:    1.4 MB
  rows:    62,851
  symbols: 2,360

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-10 04:00:00	AAPL	Stock	143.03	143.48	142.9	143.0	27582.0
2022-06-10 05:00:00	AAPL	Stock	143.04	143.38	143.04	143.26	7137.0
2022-06-10 06:00:00	AAPL	Stock	143.29	143.31	142.77	142.95	7885.0
2022-06-10 07:00:00	AAPL	Stock	143.03	143.19	142.75	142.95	69947.0
2022-06-10 08:00:00	AAPL	Stock	142.7999	143.7	139.66	140.05	1186412.0
2022-06-10 09:00:00	AAPL	Stock	139.86	140.76	138.32	138.49	11499647.0
2022-06-10 10:00:00	AAPL	Stock	138.48	138.539	137.38	137.64	13552578.0
2022-06-10 11:00:00	AAPL	Stock	137.64	138.0513	137.27	137.84	8291088.0
2022-06-10 12:00:00	AAPL	Stock	137.8586	138.21	137.45	137.7747	6127735.0
2022-06-10 13:00:00	AAPL	Stock	137.775	138.74	137.46	138.2	6042446.0
2022-06-10 14:00:00	AAPL	Stock	138.21	139.02	137.79	138.74	6425550.0
2022-06-10 15:00:00	AAPL	Stock	138.75	139.165	137.06	137.12	16060749.0
2022-06-10 16:00:00	AAPL	Stock	137.125	137.52	137.06	137.37	10288415.0
2022-06-10 17:00:00	AAPL	Stock	137.35	137.37	137.13	137.28	147004.0
2022-06-10 18:00:00	AAPL	Stock	137.3	137.4	137.25	137.35	62977.0
2022-06-10 19:00:00	AAPL	Stock	137.35	137.5	137.29	137.37	46111.0
2022-06-10 04:00:00	MSFT	Stock	264.73	265.5	264.73	265.2	3020.0
2022-06-10 05:00:00	MSFT	Stock	265.5	265.71	265.15	265.3	3344.0
2022-06-10 06:00:00	MSFT	Stock	265.05	265.1	265.0	265.1	300.0
2022-06-10 07:00:00	MSFT	Stock	265.08	265.85	264.77	265.6	13744.0
2022-06-10 08:00:00	MSFT	Stock	265.0	266.55	260.22	260.22	138528.0
2022-06-10 09:00:00	MSFT	Stock	260.25	261.4454	255.65	256.31	3289835.0
2022-06-10 10:00:00	MSFT	Stock	255.79	256.27	253.95	254.07	3963353.0
2022-06-10 11:00:00	MSFT	Stock	254.07	255.5	254.03	255.175	2130576.0
2022-06-10 12:00:00	MSFT	Stock	255.18	255.56	254.1201	254.38	1395721.0
2022-06-10 13:00:00	MSFT	Stock	254.37	255.66	253.8974	255.075	1400455.0
2022-06-10 14:00:00	MSFT	Stock	255.075	256.1495	254.5	255.9	1241944.0
2022-06-10 15:00:00	MSFT	Stock	255.92	256.47	252.53	252.89	4734236.0
2022-06-10 16:00:00	MSFT	Stock	252.89	253.5	252.8	253.0	4967215.0
2022-06-10 17:00:00	MSFT	Stock	252.99	253.19	252.99	253.0	78609.0
2022-06-10 18:00:00	MSFT	Stock	253.05	253.06	252.99	253.05	6346.0
2022-06-10 19:00:00	MSFT	Stock	253.0	253.19	252.8001	252.99	6866.0
2022-06-10 04:00:00	NVDA	Stock	18.014	18.13	18.014	18.063	105470.0
2022-06-10 05:00:00	NVDA	Stock	18.084	18.112	18.074	18.08	38720.0
2022-06-10 06:00:00	NVDA	Stock	18.095	18.095	18.02	18.02	25800.0
2022-06-10 07:00:00	NVDA	Stock	18.04	18.099	18.008	18.068	105760.0
2022-06-10 08:00:00	NVDA	Stock	18.036	18.098	17.28	17.383	3820130.0
2022-06-10 09:00:00	NVDA	Stock	17.3743	17.697	17.252	17.376	57283110.0
2022-06-10 10:00:00	NVDA	Stock	17.374	17.374	17.005	17.014	67765440.0
2022-06-10 11:00:00	NVDA	Stock	17.01	17.095	16.869	17.063	47696580.0
2022-06-10 12:00:00	NVDA	Stock	17.062	17.12	16.972	17.0517	32552680.0
2022-06-10 13:00:00	NVDA	Stock	17.052	17.25	17.022	17.143	30634060.0
2022-06-10 14:00:00	NVDA	Stock	17.149	17.207	17.055	17.171	32148960.0
2022-06-10 15:00:00	NVDA	Stock	17.173	17.238	16.95	16.973	65634060.0
2022-06-10 16:00:00	NVDA	Stock	16.9735	17.019	16.961	17.004	32769880.0
2022-06-10 17:00:00	NVDA	Stock	17.0	17.005	16.974	16.999	901970.0
2022-06-10 18:00:00	NVDA	Stock	16.997	17.001	16.98	16.98	135770.0
2022-06-10 19:00:00	NVDA	Stock	16.98	16.988	16.93	16.951	195690.0
2022-06-10 04:00:00	AMZN	Stock	116.82	116.95	116.25	116.3	19562.0
2022-06-10 05:00:00	AMZN	Stock	116.35	116.7	116.35	116.5	10676.0

> showing 50 of 62,851 rows — these rows as CSV

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