PREVIEW / stock_30min / 2021-07-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-09.parquet
  size:    2.2 MB
  rows:    110,145
  symbols: 2,901

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-09 04:00:00	AAPL	Stock	143.24	143.89	143.24	143.3	27462.0
2021-07-09 04:30:00	AAPL	Stock	143.49	143.56	143.45	143.5	9152.0
2021-07-09 05:00:00	AAPL	Stock	143.51	143.6	143.43	143.51	7113.0
2021-07-09 05:30:00	AAPL	Stock	143.5	143.59	142.86	143.0	32241.0
2021-07-09 06:00:00	AAPL	Stock	143.0	143.0	142.55	142.95	16805.0
2021-07-09 06:30:00	AAPL	Stock	142.95	143.0	142.8	142.9	9772.0
2021-07-09 07:00:00	AAPL	Stock	142.95	143.44	142.82	142.92	118940.0
2021-07-09 07:30:00	AAPL	Stock	142.95	143.08	142.81	143.03	70508.0
2021-07-09 08:00:00	AAPL	Stock	143.12	143.35	142.86	143.1	249061.0
2021-07-09 08:30:00	AAPL	Stock	143.09	143.14	142.85	142.98	174941.0
2021-07-09 09:00:00	AAPL	Stock	142.96	142.99	142.6	142.73	283052.0
2021-07-09 09:30:00	AAPL	Stock	142.73	143.98	142.6522	143.935	11199947.0
2021-07-09 10:00:00	AAPL	Stock	143.9457	144.59	143.88	144.295	8598244.0
2021-07-09 10:30:00	AAPL	Stock	144.295	145.35	144.1	145.2001	10502172.0
2021-07-09 11:00:00	AAPL	Stock	145.205	145.44	144.8501	145.28	7548053.0
2021-07-09 11:30:00	AAPL	Stock	145.27	145.3299	144.93	145.2319	5694718.0
2021-07-09 12:00:00	AAPL	Stock	145.2382	145.55	145.04	145.473	6498682.0
2021-07-09 12:30:00	AAPL	Stock	145.475	145.65	145.29	145.4299	4619334.0
2021-07-09 13:00:00	AAPL	Stock	145.4274	145.48	145.1	145.23	3509215.0
2021-07-09 13:30:00	AAPL	Stock	145.2301	145.35	145.02	145.11	2872800.0
2021-07-09 14:00:00	AAPL	Stock	145.11	145.16	144.8	144.88	3950492.0
2021-07-09 14:30:00	AAPL	Stock	144.89	145.2472	144.84	145.165	3811548.0
2021-07-09 15:00:00	AAPL	Stock	145.16	145.22	144.84	144.86	4154665.0
2021-07-09 15:30:00	AAPL	Stock	144.87	145.29	144.84	145.11	9794895.0
2021-07-09 16:00:00	AAPL	Stock	145.11	145.11	144.9	145.0	7386220.0
2021-07-09 16:30:00	AAPL	Stock	145.02	145.11	144.98	145.0	57851.0
2021-07-09 17:00:00	AAPL	Stock	145.0	145.11	144.95	145.07	188062.0
2021-07-09 17:30:00	AAPL	Stock	145.08	145.11	145.07	145.11	42700.0
2021-07-09 18:00:00	AAPL	Stock	145.11	145.1699	145.05	145.12	22686.0
2021-07-09 18:30:00	AAPL	Stock	145.14	145.14	145.05	145.06	15674.0
2021-07-09 19:00:00	AAPL	Stock	145.06	145.14	145.06	145.1	19937.0
2021-07-09 19:30:00	AAPL	Stock	145.11	145.18	145.05	145.07	39462.0
2021-07-09 04:00:00	MSFT	Stock	277.64	278.0	277.55	277.55	2366.0
2021-07-09 04:30:00	MSFT	Stock	277.6	277.6	277.3	277.3	1010.0
2021-07-09 05:00:00	MSFT	Stock	277.5	277.5	276.71	277.49	3327.0
2021-07-09 05:30:00	MSFT	Stock	277.2	277.49	277.0	277.0	3757.0
2021-07-09 06:00:00	MSFT	Stock	276.82	276.84	276.21	276.8	6716.0
2021-07-09 06:30:00	MSFT	Stock	276.82	277.0	276.6	276.66	4839.0
2021-07-09 07:00:00	MSFT	Stock	276.87	277.25	276.61	276.78	16978.0
2021-07-09 07:30:00	MSFT	Stock	276.72	276.79	276.1	276.7	21346.0
2021-07-09 08:00:00	MSFT	Stock	276.6	277.1	276.41	276.55	11389.0
2021-07-09 08:30:00	MSFT	Stock	276.69	276.69	276.1	276.36	24178.0
2021-07-09 09:00:00	MSFT	Stock	276.45	276.45	275.35	275.54	42790.0
2021-07-09 09:30:00	MSFT	Stock	275.6	276.93	275.32	276.4573	2249319.0
2021-07-09 10:00:00	MSFT	Stock	276.44	276.56	275.32	275.96	1559053.0
2021-07-09 10:30:00	MSFT	Stock	275.9401	277.41	275.65	277.4	1294678.0
2021-07-09 11:00:00	MSFT	Stock	277.41	277.69	276.73	277.14	1026656.0
2021-07-09 11:30:00	MSFT	Stock	277.14	277.64	276.9301	277.26	859001.0
2021-07-09 12:00:00	MSFT	Stock	277.26	277.57	277.19	277.42	632007.0
2021-07-09 12:30:00	MSFT	Stock	277.42	277.87	277.3744	277.59	578222.0

> showing 50 of 110,145 rows — these rows as CSV

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