PREVIEW / stock_30min / 2022-06-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-07.parquet
  size:    2.1 MB
  rows:    105,487
  symbols: 2,408

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
2022-06-07 04:00:00	AAPL	Stock	145.88	145.88	145.41	145.47	12598.0
2022-06-07 04:30:00	AAPL	Stock	145.49	145.7	145.48	145.62	10461.0
2022-06-07 05:00:00	AAPL	Stock	145.6	145.72	145.45	145.72	7463.0
2022-06-07 05:30:00	AAPL	Stock	145.72	145.72	145.46	145.46	3549.0
2022-06-07 06:00:00	AAPL	Stock	145.49	145.52	145.1	145.28	18079.0
2022-06-07 06:30:00	AAPL	Stock	145.45	145.55	144.96	144.96	30064.0
2022-06-07 07:00:00	AAPL	Stock	144.96	145.36	144.36	144.58	109501.0
2022-06-07 07:30:00	AAPL	Stock	144.53	144.69	143.95	144.16	97990.0
2022-06-07 08:00:00	AAPL	Stock	145.1	145.88	143.83	144.1899	631946.0
2022-06-07 08:30:00	AAPL	Stock	144.1801	144.34	143.8	144.069	232892.0
2022-06-07 09:00:00	AAPL	Stock	144.05	146.14	143.8614	144.36	256366.0
2022-06-07 09:30:00	AAPL	Stock	144.38	147.0999	144.1	146.6	9456563.0
2022-06-07 10:00:00	AAPL	Stock	146.62	147.29	145.93	147.18	5403290.0
2022-06-07 10:30:00	AAPL	Stock	147.18	148.3	147.13	147.745	5065097.0
2022-06-07 11:00:00	AAPL	Stock	147.75	147.85	146.93	146.97	3454299.0
2022-06-07 11:30:00	AAPL	Stock	146.97	147.6953	146.785	147.57	3223331.0
2022-06-07 12:00:00	AAPL	Stock	147.565	147.75	147.09	147.28	2252890.0
2022-06-07 12:30:00	AAPL	Stock	147.28	147.885	147.14	147.68	2366870.0
2022-06-07 13:00:00	AAPL	Stock	147.685	148.261	147.62	148.17	2616857.0
2022-06-07 13:30:00	AAPL	Stock	148.18	148.36	148.042	148.1388	2541848.0
2022-06-07 14:00:00	AAPL	Stock	148.14	148.95	148.03	148.755	3245125.0
2022-06-07 14:30:00	AAPL	Stock	148.7506	148.97	148.08	148.365	2907514.0
2022-06-07 15:00:00	AAPL	Stock	148.37	148.8299	148.32	148.645	2654864.0
2022-06-07 15:30:00	AAPL	Stock	148.64	149.0	148.53	148.69	6084580.0
2022-06-07 16:00:00	AAPL	Stock	148.66	148.71	148.23	148.35	6504697.0
2022-06-07 16:30:00	AAPL	Stock	148.3969	148.3969	148.2712	148.31	26873.0
2022-06-07 17:00:00	AAPL	Stock	148.3474	148.38	148.2817	148.33	12642.0
2022-06-07 17:30:00	AAPL	Stock	148.38	148.41	148.3203	148.41	16946.0
2022-06-07 18:00:00	AAPL	Stock	148.41	148.49	148.41	148.43	18403.0
2022-06-07 18:30:00	AAPL	Stock	148.41	148.48	148.4	148.48	16459.0
2022-06-07 19:00:00	AAPL	Stock	148.47	148.5	148.42	148.4899	12726.0
2022-06-07 19:30:00	AAPL	Stock	148.46	148.47	148.2	148.22	31094.0
2022-06-07 04:00:00	MSFT	Stock	267.39	267.45	267.39	267.4	1193.0
2022-06-07 04:30:00	MSFT	Stock	267.4	267.5	267.12	267.12	3918.0
2022-06-07 05:00:00	MSFT	Stock	267.11	267.37	266.9	267.37	4480.0
2022-06-07 05:30:00	MSFT	Stock	267.4	267.41	267.01	267.05	2257.0
2022-06-07 06:00:00	MSFT	Stock	266.9	266.9	266.03	266.03	1432.0
2022-06-07 06:30:00	MSFT	Stock	266.53	266.53	265.71	265.74	1388.0
2022-06-07 07:00:00	MSFT	Stock	266.03	266.97	265.76	266.97	9464.0
2022-06-07 07:30:00	MSFT	Stock	266.9	266.92	266.16	266.51	5481.0
2022-06-07 08:00:00	MSFT	Stock	266.33	268.079	265.6451	266.0	27316.0
2022-06-07 08:30:00	MSFT	Stock	265.82	265.99	265.3	265.38	9355.0
2022-06-07 09:00:00	MSFT	Stock	265.6	268.75	265.5024	266.42	16437.0
2022-06-07 09:30:00	MSFT	Stock	266.57	269.48	265.94	268.4	1825848.0
2022-06-07 10:00:00	MSFT	Stock	268.48	269.87	267.61	269.68	939279.0
2022-06-07 10:30:00	MSFT	Stock	269.67	272.0	269.54	270.93	1104706.0
2022-06-07 11:00:00	MSFT	Stock	270.94	271.58	270.375	270.46	787423.0
2022-06-07 11:30:00	MSFT	Stock	270.47	270.9299	269.84	270.7	741948.0
2022-06-07 12:00:00	MSFT	Stock	270.75	270.79	269.61	269.82	556132.0
2022-06-07 12:30:00	MSFT	Stock	269.82	271.03	269.61	270.73	565327.0

> showing 50 of 105,487 rows — these rows as CSV

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