PREVIEW / stock_1hour / 2021-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-28.parquet
  size:    1.5 MB
  rows:    65,998
  symbols: 2,694

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-10-28 04:00:00	AAPL	Stock	149.2	149.6	149.2	149.38	13736.0
2021-10-28 05:00:00	AAPL	Stock	149.4	149.46	149.34	149.4	13233.0
2021-10-28 06:00:00	AAPL	Stock	149.39	149.8	149.35	149.75	19994.0
2021-10-28 07:00:00	AAPL	Stock	149.75	150.0	149.5	149.64	122543.0
2021-10-28 08:00:00	AAPL	Stock	149.7001	149.99	148.478	149.78	626001.0
2021-10-28 09:00:00	AAPL	Stock	149.79	152.11	148.85	152.07	14769327.0
2021-10-28 10:00:00	AAPL	Stock	152.06	152.92	151.7	152.5452	14251218.0
2021-10-28 11:00:00	AAPL	Stock	152.55	153.165	152.32	152.635	10329616.0
2021-10-28 12:00:00	AAPL	Stock	152.63	152.84	151.97	152.2	7408372.0
2021-10-28 13:00:00	AAPL	Stock	152.204	152.7	152.15	152.4929	5273622.0
2021-10-28 14:00:00	AAPL	Stock	152.5	152.89	152.455	152.615	5916019.0
2021-10-28 15:00:00	AAPL	Stock	152.615	152.69	152.17	152.4766	11956444.0
2021-10-28 16:00:00	AAPL	Stock	152.57	152.58	144.42	146.99	13808213.0
2021-10-28 17:00:00	AAPL	Stock	146.91	148.89	146.48	146.98	2316813.0
2021-10-28 18:00:00	AAPL	Stock	146.98	147.34	146.75	147.01	461811.0
2021-10-28 19:00:00	AAPL	Stock	147.0	147.2	146.75	147.19	391842.0
2021-10-28 04:00:00	MSFT	Stock	324.05	325.37	324.01	325.37	7866.0
2021-10-28 05:00:00	MSFT	Stock	325.34	325.43	324.43	324.43	5535.0
2021-10-28 06:00:00	MSFT	Stock	324.3	324.3	324.04	324.3	1725.0
2021-10-28 07:00:00	MSFT	Stock	324.43	325.7	324.3	324.5	19707.0
2021-10-28 08:00:00	MSFT	Stock	324.9985	325.75	324.02	324.05	60008.0
2021-10-28 09:00:00	MSFT	Stock	324.2881	325.34	321.3601	321.84	3156978.0
2021-10-28 10:00:00	MSFT	Stock	321.78	323.19	321.43	322.48	3800692.0
2021-10-28 11:00:00	MSFT	Stock	322.4623	324.38	322.42	323.79	2287456.0
2021-10-28 12:00:00	MSFT	Stock	323.8	324.0	322.2752	322.58	1554807.0
2021-10-28 13:00:00	MSFT	Stock	322.63	323.64	322.45	323.63	1136432.0
2021-10-28 14:00:00	MSFT	Stock	323.6443	324.02	323.46	323.52	1233058.0
2021-10-28 15:00:00	MSFT	Stock	323.5025	324.87	322.6	324.32	3040985.0
2021-10-28 16:00:00	MSFT	Stock	324.35	325.5	323.17	325.0	3751490.0
2021-10-28 17:00:00	MSFT	Stock	325.05	325.2	324.74	325.03	37599.0
2021-10-28 18:00:00	MSFT	Stock	325.03	325.03	324.68	324.72	12902.0
2021-10-28 19:00:00	MSFT	Stock	324.87	325.04	324.66	324.71	9107.0
2021-10-28 04:00:00	NVDA	Stock	24.608	24.728	24.58	24.728	45260.0
2021-10-28 05:00:00	NVDA	Stock	24.729	24.729	24.653	24.653	35310.0
2021-10-28 06:00:00	NVDA	Stock	24.661	24.672	24.653	24.67	9030.0
2021-10-28 07:00:00	NVDA	Stock	24.718	24.79	24.702	24.767	378940.0
2021-10-28 08:00:00	NVDA	Stock	24.75	24.8	24.616	24.658	696160.0
2021-10-28 09:00:00	NVDA	Stock	24.687	24.912	24.451	24.5818	37793390.0
2021-10-28 10:00:00	NVDA	Stock	24.585	24.842	24.5442	24.7235	31896480.0
2021-10-28 11:00:00	NVDA	Stock	24.725	24.7961	24.607	24.6318	18606540.0
2021-10-28 12:00:00	NVDA	Stock	24.631	24.745	24.597	24.638	11922190.0
2021-10-28 13:00:00	NVDA	Stock	24.64	24.812	24.638	24.749	11582350.0
2021-10-28 14:00:00	NVDA	Stock	24.751	24.836	24.72	24.744	17951640.0
2021-10-28 15:00:00	NVDA	Stock	24.74	24.95	24.718	24.943	22402460.0
2021-10-28 16:00:00	NVDA	Stock	24.941	24.996	24.451	24.996	25530990.0
2021-10-28 17:00:00	NVDA	Stock	24.984	25.233	24.971	25.233	829490.0
2021-10-28 18:00:00	NVDA	Stock	25.205	25.205	25.06	25.1	306610.0
2021-10-28 19:00:00	NVDA	Stock	25.12	25.15	25.075	25.125	204540.0
2021-10-28 05:00:00	AMZN	Stock	170.7425	170.7425	170.587	170.587	4000.0
2021-10-28 07:00:00	AMZN	Stock	170.755	170.95	170.45	170.45	156220.0

> showing 50 of 65,998 rows — these rows as CSV

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