PREVIEW / stock_30min / 2021-07-19

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-19.parquet
  size:    2.3 MB
  rows:    117,566
  symbols: 2,902

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-19 04:00:00	AAPL	Stock	145.85	145.85	145.25	145.69	50720.0
2021-07-19 04:30:00	AAPL	Stock	145.68	145.68	144.95	145.12	32536.0
2021-07-19 05:00:00	AAPL	Stock	145.1	145.45	145.03	145.08	31917.0
2021-07-19 05:30:00	AAPL	Stock	145.03	145.4	144.95	145.24	27404.0
2021-07-19 06:00:00	AAPL	Stock	145.34	145.35	145.05	145.32	22444.0
2021-07-19 06:30:00	AAPL	Stock	145.34	145.34	145.05	145.22	15143.0
2021-07-19 07:00:00	AAPL	Stock	145.17	145.29	143.52	143.52	484943.0
2021-07-19 07:30:00	AAPL	Stock	143.51	143.82	143.3	143.69	328048.0
2021-07-19 08:00:00	AAPL	Stock	143.68	146.025	143.35	144.0	834499.0
2021-07-19 08:30:00	AAPL	Stock	143.92	144.38	143.75	144.01	388249.0
2021-07-19 09:00:00	AAPL	Stock	144.0	144.05	143.3	143.75	459504.0
2021-07-19 09:30:00	AAPL	Stock	143.75	144.07	142.02	142.045	18463513.0
2021-07-19 10:00:00	AAPL	Stock	142.05	142.55	141.67	142.4	12221882.0
2021-07-19 10:30:00	AAPL	Stock	142.405	143.05	141.96	143.0314	7740554.0
2021-07-19 11:00:00	AAPL	Stock	143.04	143.59	142.85	143.1999	5735401.0
2021-07-19 11:30:00	AAPL	Stock	143.2	143.95	143.15	143.3557	5164133.0
2021-07-19 12:00:00	AAPL	Stock	143.34	143.4069	142.8	142.9076	4574584.0
2021-07-19 12:30:00	AAPL	Stock	142.9	143.05	142.015	142.0818	5301549.0
2021-07-19 13:00:00	AAPL	Stock	142.08	142.29	141.73	141.79	4578020.0
2021-07-19 13:30:00	AAPL	Stock	141.78	142.28	141.7	141.9	4654616.0
2021-07-19 14:00:00	AAPL	Stock	141.9	142.55	141.88	142.53	3872111.0
2021-07-19 14:30:00	AAPL	Stock	142.53	142.58	141.94	142.135	3761402.0
2021-07-19 15:00:00	AAPL	Stock	142.13	142.58	141.86	141.865	5237433.0
2021-07-19 15:30:00	AAPL	Stock	141.87	142.56	141.76	142.53	10177871.0
2021-07-19 16:00:00	AAPL	Stock	142.45	142.73	142.27	142.67	8394697.0
2021-07-19 16:30:00	AAPL	Stock	142.66	143.1899	142.45	143.11	987786.0
2021-07-19 17:00:00	AAPL	Stock	143.05	143.14	143.01	143.1	59153.0
2021-07-19 17:30:00	AAPL	Stock	143.07	143.2	143.05	143.17	42969.0
2021-07-19 18:00:00	AAPL	Stock	143.15	143.17	143.05	143.05	47646.0
2021-07-19 18:30:00	AAPL	Stock	143.06	143.08	143.05	143.07	34120.0
2021-07-19 19:00:00	AAPL	Stock	143.06	143.11	143.05	143.09	12298.0
2021-07-19 19:30:00	AAPL	Stock	143.09	143.18	143.05	143.18	47206.0
2021-07-19 04:00:00	MSFT	Stock	280.57	281.5	280.29	281.46	14572.0
2021-07-19 04:30:00	MSFT	Stock	281.34	281.34	280.21	280.23	4347.0
2021-07-19 05:00:00	MSFT	Stock	280.09	280.67	280.0	280.16	4705.0
2021-07-19 05:30:00	MSFT	Stock	280.14	280.84	280.14	280.6	4272.0
2021-07-19 06:00:00	MSFT	Stock	280.8	280.8	280.12	280.59	2833.0
2021-07-19 06:30:00	MSFT	Stock	280.23	280.67	280.2	280.4	5149.0
2021-07-19 07:00:00	MSFT	Stock	280.33	280.7	279.3	279.3	24234.0
2021-07-19 07:30:00	MSFT	Stock	279.2	279.59	278.41	279.43	40806.0
2021-07-19 08:00:00	MSFT	Stock	278.6199	280.5	278.2771	278.7	41425.0
2021-07-19 08:30:00	MSFT	Stock	278.78	279.52	278.4	279.52	41174.0
2021-07-19 09:00:00	MSFT	Stock	279.36	279.52	278.05	279.11	46480.0
2021-07-19 09:30:00	MSFT	Stock	279.11	280.37	277.84	278.6	3787080.0
2021-07-19 10:00:00	MSFT	Stock	278.6	279.18	276.13	276.72	2591439.0
2021-07-19 10:30:00	MSFT	Stock	276.67	276.73	274.45	276.2	1778269.0
2021-07-19 11:00:00	MSFT	Stock	276.2	276.76	275.86	276.48	1459830.0
2021-07-19 11:30:00	MSFT	Stock	276.49	277.48	276.44	276.57	1303070.0
2021-07-19 12:00:00	MSFT	Stock	276.55	276.88	275.825	276.55	1074926.0
2021-07-19 12:30:00	MSFT	Stock	276.5428	276.95	275.85	276.41	816726.0

> showing 50 of 117,566 rows — these rows as CSV

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