PREVIEW / stock_1hour / 2022-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-20.parquet
  size:    1.4 MB
  rows:    62,731
  symbols: 2,399

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-20 04:00:00	AAPL	Stock	139.02	140.1	138.32	139.43	75368.0
2022-05-20 05:00:00	AAPL	Stock	139.36	139.6	139.0	139.23	57323.0
2022-05-20 06:00:00	AAPL	Stock	139.18	139.46	139.16	139.19	14074.0
2022-05-20 07:00:00	AAPL	Stock	139.17	139.99	138.88	139.6	159151.0
2022-05-20 08:00:00	AAPL	Stock	139.05	139.99	138.86	139.2	1014186.0
2022-05-20 09:00:00	AAPL	Stock	139.15	140.3597	138.07	139.86	15926864.0
2022-05-20 10:00:00	AAPL	Stock	139.87	140.7	137.06	137.19	14321074.0
2022-05-20 11:00:00	AAPL	Stock	137.2	137.53	136.32	136.77	11522959.0
2022-05-20 12:00:00	AAPL	Stock	136.78	136.89	133.6	134.36	17342785.0
2022-05-20 13:00:00	AAPL	Stock	134.34	134.45	132.61	134.15	15120984.0
2022-05-20 14:00:00	AAPL	Stock	134.15	134.94	133.38	134.3647	11277353.0
2022-05-20 15:00:00	AAPL	Stock	134.37	137.89	133.76	137.62	23226212.0
2022-05-20 16:00:00	AAPL	Stock	137.59	137.9	137.05	137.29	9977763.0
2022-05-20 17:00:00	AAPL	Stock	137.28	137.59	137.16	137.36	1092032.0
2022-05-20 18:00:00	AAPL	Stock	137.33	137.38	137.2	137.2	90557.0
2022-05-20 19:00:00	AAPL	Stock	137.23	137.68	137.2	137.56	111236.0
2022-05-20 04:00:00	MSFT	Stock	256.8	258.27	256.8	257.77	10283.0
2022-05-20 05:00:00	MSFT	Stock	257.61	258.3	257.46	257.57	4785.0
2022-05-20 06:00:00	MSFT	Stock	257.5	257.73	257.3	257.3	623.0
2022-05-20 07:00:00	MSFT	Stock	257.47	258.35	256.94	257.5	19102.0
2022-05-20 08:00:00	MSFT	Stock	257.0	258.28	256.3	256.75	37470.0
2022-05-20 09:00:00	MSFT	Stock	256.86	258.54	255.38	257.37	2907141.0
2022-05-20 10:00:00	MSFT	Stock	257.31	257.83	253.32	253.46	2492775.0
2022-05-20 11:00:00	MSFT	Stock	253.46	253.88	252.19	252.41	2097113.0
2022-05-20 12:00:00	MSFT	Stock	252.38	252.58	247.95	249.55	4409336.0
2022-05-20 13:00:00	MSFT	Stock	249.56	250.56	248.03	249.95	2462792.0
2022-05-20 14:00:00	MSFT	Stock	249.99	250.08	247.38	248.25	2878554.0
2022-05-20 15:00:00	MSFT	Stock	248.285	252.92	246.44	252.56	6502141.0
2022-05-20 16:00:00	MSFT	Stock	252.56	252.99	252.3	252.4	4684278.0
2022-05-20 17:00:00	MSFT	Stock	252.49	252.78	252.25	252.6	96315.0
2022-05-20 18:00:00	MSFT	Stock	252.56	252.9	252.46	252.9	12862.0
2022-05-20 19:00:00	MSFT	Stock	252.85	253.0	252.72	252.8	5101.0
2022-05-20 04:00:00	NVDA	Stock	17.576	17.679	17.52	17.603	222010.0
2022-05-20 05:00:00	NVDA	Stock	17.601	17.689	17.6	17.616	72770.0
2022-05-20 06:00:00	NVDA	Stock	17.601	17.7	17.52	17.55	303430.0
2022-05-20 07:00:00	NVDA	Stock	17.564	17.629	17.52	17.575	586550.0
2022-05-20 08:00:00	NVDA	Stock	17.544	17.63	17.435	17.48	1591210.0
2022-05-20 09:00:00	NVDA	Stock	17.478	17.55	16.778	16.91	79425740.0
2022-05-20 10:00:00	NVDA	Stock	16.914	16.941	16.423	16.451	92527200.0
2022-05-20 11:00:00	NVDA	Stock	16.447	16.519	16.1719	16.25	73630780.0
2022-05-20 12:00:00	NVDA	Stock	16.25	16.27	15.764	15.887	75602590.0
2022-05-20 13:00:00	NVDA	Stock	15.887	16.13	15.755	16.0727	66361180.0
2022-05-20 14:00:00	NVDA	Stock	16.078	16.149	15.856	16.035	64164560.0
2022-05-20 15:00:00	NVDA	Stock	16.035	16.728	15.965	16.699	115099680.0
2022-05-20 16:00:00	NVDA	Stock	16.699	16.76	16.6	16.719	28220530.0
2022-05-20 17:00:00	NVDA	Stock	16.717	16.732	16.694	16.72	649340.0
2022-05-20 18:00:00	NVDA	Stock	16.716	16.749	16.65	16.729	806830.0
2022-05-20 19:00:00	NVDA	Stock	16.725	16.812	16.68	16.694	775860.0
2022-05-20 05:00:00	AMZN	Stock	109.5	109.5	109.5	109.5	2000.0
2022-05-20 07:00:00	AMZN	Stock	109.1155	109.2415	109.0	109.05	48420.0

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

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