PREVIEW / stock_30min / 2023-03-23

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-23.parquet
  size:    2.1 MB
  rows:    100,856
  symbols: 1,728

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
2023-03-23 04:00:00	AAPL	Stock	159.02	159.65	158.52	159.54	21573.0
2023-03-23 04:30:00	AAPL	Stock	159.5	159.78	159.42	159.71	9838.0
2023-03-23 05:00:00	AAPL	Stock	159.72	159.79	159.5	159.52	30297.0
2023-03-23 05:30:00	AAPL	Stock	159.56	159.82	159.44	159.7	10107.0
2023-03-23 06:00:00	AAPL	Stock	159.75	159.82	159.38	159.56	9961.0
2023-03-23 06:30:00	AAPL	Stock	159.51	159.6	159.33	159.6	5652.0
2023-03-23 07:00:00	AAPL	Stock	159.61	159.8	159.43	159.61	34642.0
2023-03-23 07:30:00	AAPL	Stock	159.58	159.7	159.43	159.45	23975.0
2023-03-23 08:00:00	AAPL	Stock	159.7	159.85	158.44	159.52	106855.0
2023-03-23 08:30:00	AAPL	Stock	159.5999	159.75	159.34	159.51	114284.0
2023-03-23 09:00:00	AAPL	Stock	159.51	159.71	158.61	158.77	182052.0
2023-03-23 09:30:00	AAPL	Stock	158.77	159.78	158.73	159.67	6221489.0
2023-03-23 10:00:00	AAPL	Stock	159.67	160.7	159.54	160.37	4607256.0
2023-03-23 10:30:00	AAPL	Stock	160.3787	161.2999	160.12	161.24	3464142.0
2023-03-23 11:00:00	AAPL	Stock	161.24	161.5501	160.5425	160.61	3321927.0
2023-03-23 11:30:00	AAPL	Stock	160.62	160.99	160.36	160.6402	2816426.0
2023-03-23 12:00:00	AAPL	Stock	160.645	161.0	160.52	160.8691	2066309.0
2023-03-23 12:30:00	AAPL	Stock	160.8675	161.02	160.31	160.41	2173083.0
2023-03-23 13:00:00	AAPL	Stock	160.41	160.64	159.62	159.82	2872625.0
2023-03-23 13:30:00	AAPL	Stock	159.8267	160.27	159.52	159.61	2258651.0
2023-03-23 14:00:00	AAPL	Stock	159.6024	159.83	158.675	158.68	3044175.0
2023-03-23 14:30:00	AAPL	Stock	158.68	158.88	157.7	158.6005	4731224.0
2023-03-23 15:00:00	AAPL	Stock	158.61	159.5	157.68	158.36	5273573.0
2023-03-23 15:30:00	AAPL	Stock	158.35	159.64	158.09	158.89	7222183.0
2023-03-23 16:00:00	AAPL	Stock	158.89	158.95	158.64	158.84	7992868.0
2023-03-23 16:30:00	AAPL	Stock	158.85	159.97	158.82	159.2	90098.0
2023-03-23 17:00:00	AAPL	Stock	159.2	159.37	158.93	159.29	174410.0
2023-03-23 17:30:00	AAPL	Stock	159.26	159.3499	159.2228	159.2228	19140.0
2023-03-23 18:00:00	AAPL	Stock	159.22	159.22	158.81	159.01	18813.0
2023-03-23 18:30:00	AAPL	Stock	159.0	159.04	158.8	158.93	10867.0
2023-03-23 19:00:00	AAPL	Stock	158.94	159.29	158.9	159.2	10648.0
2023-03-23 19:30:00	AAPL	Stock	159.14	159.32	159.01	159.05	8249.0
2023-03-23 04:00:00	MSFT	Stock	274.1	276.5	273.98	276.11	8446.0
2023-03-23 04:30:00	MSFT	Stock	276.02	277.0	276.0	276.67	11334.0
2023-03-23 05:00:00	MSFT	Stock	276.4	276.6	276.0	276.2	3885.0
2023-03-23 05:30:00	MSFT	Stock	275.9	276.55	275.87	276.31	3783.0
2023-03-23 06:00:00	MSFT	Stock	276.49	276.49	275.59	275.89	5582.0
2023-03-23 06:30:00	MSFT	Stock	275.51	276.0	275.51	276.0	5412.0
2023-03-23 07:00:00	MSFT	Stock	276.02	276.67	275.61	275.61	11760.0
2023-03-23 07:30:00	MSFT	Stock	275.62	276.09	275.33	275.98	6855.0
2023-03-23 08:00:00	MSFT	Stock	276.2115	276.5	271.61	276.09	43308.0
2023-03-23 08:30:00	MSFT	Stock	275.8	276.6	275.5018	276.1995	20455.0
2023-03-23 09:00:00	MSFT	Stock	276.25	278.3	275.3	278.01	52152.0
2023-03-23 09:30:00	MSFT	Stock	277.89	278.61	275.34	276.98	2844904.0
2023-03-23 10:00:00	MSFT	Stock	276.99	278.27	276.39	277.8982	1767112.0
2023-03-23 10:30:00	MSFT	Stock	277.89	280.13	277.5	280.09	1888819.0
2023-03-23 11:00:00	MSFT	Stock	280.1	280.98	279.94	280.065	1893687.0
2023-03-23 11:30:00	MSFT	Stock	280.065	281.06	279.59	280.31	1167198.0
2023-03-23 12:00:00	MSFT	Stock	280.29	280.65	279.78	280.48	1032463.0
2023-03-23 12:30:00	MSFT	Stock	280.47	280.68	279.69	280.01	1111495.0

> showing 50 of 100,856 rows — these rows as CSV

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