PREVIEW / stock_30min / 2021-10-18

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-10-18.parquet
  size:    2.2 MB
  rows:    109,004
  symbols: 2,660

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-18 04:00:00	AAPL	Stock	144.39	144.39	144.04	144.2	8787.0
2021-10-18 04:30:00	AAPL	Stock	144.25	144.28	144.2	144.25	3374.0
2021-10-18 05:00:00	AAPL	Stock	144.21	144.4	144.16	144.35	8164.0
2021-10-18 05:30:00	AAPL	Stock	144.28	144.32	144.22	144.32	2083.0
2021-10-18 06:00:00	AAPL	Stock	144.3	144.32	144.0	144.27	14223.0
2021-10-18 06:30:00	AAPL	Stock	144.14	144.27	144.14	144.2	3496.0
2021-10-18 07:00:00	AAPL	Stock	144.27	144.85	144.25	144.84	45777.0
2021-10-18 07:30:00	AAPL	Stock	144.86	144.87	144.6	144.64	30952.0
2021-10-18 08:00:00	AAPL	Stock	144.6	144.89	144.25	144.31	278435.0
2021-10-18 08:30:00	AAPL	Stock	144.3001	144.38	144.0	144.15	173881.0
2021-10-18 09:00:00	AAPL	Stock	144.11	144.3	143.21	143.48	498006.0
2021-10-18 09:30:00	AAPL	Stock	143.445	144.46	143.16	144.315	10868455.0
2021-10-18 10:00:00	AAPL	Stock	144.32	144.7	144.17	144.48	5353267.0
2021-10-18 10:30:00	AAPL	Stock	144.475	144.88	144.1714	144.83	4269876.0
2021-10-18 11:00:00	AAPL	Stock	144.83	145.515	144.8297	145.41	5672690.0
2021-10-18 11:30:00	AAPL	Stock	145.42	145.52	145.19	145.3901	2945591.0
2021-10-18 12:00:00	AAPL	Stock	145.4	145.48	145.1101	145.275	2472373.0
2021-10-18 12:30:00	AAPL	Stock	145.2794	145.4	145.07	145.2226	2078628.0
2021-10-18 13:00:00	AAPL	Stock	145.225	146.04	144.96	145.845	5883290.0
2021-10-18 13:30:00	AAPL	Stock	145.84	146.055	145.69	145.885	4143399.0
2021-10-18 14:00:00	AAPL	Stock	145.885	146.03	145.71	145.785	2999368.0
2021-10-18 14:30:00	AAPL	Stock	145.79	146.39	145.78	146.3221	2903125.0
2021-10-18 15:00:00	AAPL	Stock	146.32	146.8	146.24	146.625	4134340.0
2021-10-18 15:30:00	AAPL	Stock	146.62	146.84	146.45	146.54	7268807.0
2021-10-18 16:00:00	AAPL	Stock	146.55	146.79	146.55	146.62	9690873.0
2021-10-18 16:30:00	AAPL	Stock	146.6	146.67	146.55	146.65	1124347.0
2021-10-18 17:00:00	AAPL	Stock	146.62	146.76	146.59	146.73	43733.0
2021-10-18 17:30:00	AAPL	Stock	146.72	146.84	146.61	146.84	67408.0
2021-10-18 18:00:00	AAPL	Stock	146.84	146.85	146.77	146.77	33319.0
2021-10-18 18:30:00	AAPL	Stock	146.76	146.78	146.61	146.63	26092.0
2021-10-18 19:00:00	AAPL	Stock	146.63	146.69	146.63	146.65	15647.0
2021-10-18 19:30:00	AAPL	Stock	146.66	146.8	146.66	146.79	34384.0
2021-10-18 04:00:00	MSFT	Stock	303.33	303.41	302.99	303.41	396.0
2021-10-18 04:30:00	MSFT	Stock	303.11	303.11	303.01	303.01	301.0
2021-10-18 05:00:00	MSFT	Stock	302.77	302.95	302.72	302.95	1326.0
2021-10-18 06:00:00	MSFT	Stock	302.71	302.71	302.01	302.11	1579.0
2021-10-18 06:30:00	MSFT	Stock	302.47	302.47	302.47	302.47	100.0
2021-10-18 07:00:00	MSFT	Stock	302.74	303.8	302.74	303.68	7246.0
2021-10-18 07:30:00	MSFT	Stock	303.77	303.9	303.21	303.3	3467.0
2021-10-18 08:00:00	MSFT	Stock	303.25	304.18	303.0	303.7	37285.0
2021-10-18 08:30:00	MSFT	Stock	303.88	303.95	302.5	302.9	38785.0
2021-10-18 09:00:00	MSFT	Stock	303.0	303.79	302.54	303.59	10343.0
2021-10-18 09:30:00	MSFT	Stock	303.42	305.07	302.69	304.48	2106091.0
2021-10-18 10:00:00	MSFT	Stock	304.5	304.98	303.74	303.92	1105685.0
2021-10-18 10:30:00	MSFT	Stock	303.938	304.4267	303.29	304.34	769885.0
2021-10-18 11:00:00	MSFT	Stock	304.34	304.56	304.02	304.38	819563.0
2021-10-18 11:30:00	MSFT	Stock	304.4	304.97	304.13	304.6602	691270.0
2021-10-18 12:00:00	MSFT	Stock	304.6513	305.3897	304.55	305.34	1120413.0
2021-10-18 12:30:00	MSFT	Stock	305.3315	306.37	305.29	306.126	1248411.0
2021-10-18 13:00:00	MSFT	Stock	306.12	307.36	306.12	307.24	1094377.0

> showing 50 of 109,004 rows — these rows as CSV

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