PREVIEW / stock_30min / 2021-10-01

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-10-01.parquet
  size:    2.2 MB
  rows:    108,980
  symbols: 2,745

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-01 04:00:00	AAPL	Stock	140.72	141.3	140.53	140.82	21165.0
2021-10-01 04:30:00	AAPL	Stock	140.82	140.82	140.55	140.59	8643.0
2021-10-01 05:00:00	AAPL	Stock	140.65	140.8	140.64	140.79	4967.0
2021-10-01 05:30:00	AAPL	Stock	140.82	140.85	140.69	140.75	41919.0
2021-10-01 06:00:00	AAPL	Stock	140.75	141.15	140.75	140.82	20598.0
2021-10-01 06:30:00	AAPL	Stock	141.0	141.34	140.92	141.34	27722.0
2021-10-01 07:00:00	AAPL	Stock	141.2	142.15	141.15	142.1	145750.0
2021-10-01 07:30:00	AAPL	Stock	142.01	142.3	141.81	142.0	287729.0
2021-10-01 08:00:00	AAPL	Stock	142.0	142.28	141.21	142.09	570785.0
2021-10-01 08:30:00	AAPL	Stock	142.06	142.1	141.57	141.79	332045.0
2021-10-01 09:00:00	AAPL	Stock	141.8	141.96	141.74	141.81	225925.0
2021-10-01 09:30:00	AAPL	Stock	141.87	142.04	140.24	140.53	10870371.0
2021-10-01 10:00:00	AAPL	Stock	140.54	140.69	139.5	139.53	9014046.0
2021-10-01 10:30:00	AAPL	Stock	139.52	140.06	139.1101	140.06	6937907.0
2021-10-01 11:00:00	AAPL	Stock	140.06	140.42	139.5675	140.015	6132933.0
2021-10-01 11:30:00	AAPL	Stock	140.0145	140.4	139.97	140.3144	4232302.0
2021-10-01 12:00:00	AAPL	Stock	140.32	140.58	140.065	140.5059	3680031.0
2021-10-01 12:30:00	AAPL	Stock	140.51	140.81	140.28	140.421	3209726.0
2021-10-01 13:00:00	AAPL	Stock	140.44	140.91	140.295	140.7795	2862792.0
2021-10-01 13:30:00	AAPL	Stock	140.78	141.553	140.765	141.35	3534001.0
2021-10-01 14:00:00	AAPL	Stock	141.36	141.765	141.29	141.57	3980485.0
2021-10-01 14:30:00	AAPL	Stock	141.57	142.18	141.53	142.06	3535273.0
2021-10-01 15:00:00	AAPL	Stock	142.0537	142.5	141.99	142.25	4021292.0
2021-10-01 15:30:00	AAPL	Stock	142.245	142.92	141.9	142.64	9881015.0
2021-10-01 16:00:00	AAPL	Stock	142.65	142.65	142.05	142.4	9818410.0
2021-10-01 16:30:00	AAPL	Stock	142.41	142.53	142.4	142.53	19056.0
2021-10-01 17:00:00	AAPL	Stock	142.53	142.57	142.5	142.5	19782.0
2021-10-01 17:30:00	AAPL	Stock	142.5	142.58	142.49	142.55	18102.0
2021-10-01 18:00:00	AAPL	Stock	142.53	142.56	142.5	142.53	8302.0
2021-10-01 18:30:00	AAPL	Stock	142.55	142.56	142.51	142.52	5007.0
2021-10-01 19:00:00	AAPL	Stock	142.55	142.59	142.55	142.56	4664.0
2021-10-01 19:30:00	AAPL	Stock	142.53	142.6	142.5	142.58	21057.0
2021-10-01 04:00:00	MSFT	Stock	280.31	280.99	279.64	280.21	10282.0
2021-10-01 04:30:00	MSFT	Stock	280.05	280.09	279.78	279.85	2509.0
2021-10-01 05:00:00	MSFT	Stock	280.1	280.48	280.1	280.44	647.0
2021-10-01 05:30:00	MSFT	Stock	280.45	280.48	280.19	280.19	3023.0
2021-10-01 06:00:00	MSFT	Stock	280.25	280.94	280.25	280.74	4705.0
2021-10-01 06:30:00	MSFT	Stock	280.8	280.89	280.66	280.89	9221.0
2021-10-01 07:00:00	MSFT	Stock	280.95	282.63	280.8	282.49	41577.0
2021-10-01 07:30:00	MSFT	Stock	282.63	283.29	282.3	282.38	35826.0
2021-10-01 08:00:00	MSFT	Stock	282.6006	283.11	280.85	282.88	56370.0
2021-10-01 08:30:00	MSFT	Stock	282.77	282.9	281.65	282.11	21792.0
2021-10-01 09:00:00	MSFT	Stock	282.37	282.69	281.92	282.09	25473.0
2021-10-01 09:30:00	MSFT	Stock	282.05	284.14	281.29	283.71	2508912.0
2021-10-01 10:00:00	MSFT	Stock	283.72	284.59	282.5666	282.71	1918766.0
2021-10-01 10:30:00	MSFT	Stock	282.7	285.03	282.58	284.97	1286932.0
2021-10-01 11:00:00	MSFT	Stock	284.96	286.3439	284.41	285.88	1191924.0
2021-10-01 11:30:00	MSFT	Stock	285.87	286.87	285.75	286.3382	1057062.0
2021-10-01 12:00:00	MSFT	Stock	286.32	286.82	285.96	286.31	866146.0
2021-10-01 12:30:00	MSFT	Stock	286.33	286.73	285.79	286.12	629134.0

> showing 50 of 108,980 rows — these rows as CSV

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