PREVIEW / stock_30min / 2022-04-22

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-22.parquet
  size:    2.2 MB
  rows:    106,245
  symbols: 2,451

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-04-22 04:00:00	AAPL	Stock	166.52	166.84	166.28	166.5	19816.0
2022-04-22 04:30:00	AAPL	Stock	166.32	166.32	166.01	166.01	2472.0
2022-04-22 05:00:00	AAPL	Stock	166.1	166.35	166.09	166.33	5166.0
2022-04-22 05:30:00	AAPL	Stock	166.2	166.2	165.54	165.54	12273.0
2022-04-22 06:00:00	AAPL	Stock	165.71	165.91	165.61	165.61	4618.0
2022-04-22 06:30:00	AAPL	Stock	165.61	166.01	165.61	165.9	6940.0
2022-04-22 07:00:00	AAPL	Stock	166.0	166.43	165.93	166.39	31447.0
2022-04-22 07:30:00	AAPL	Stock	166.37	167.24	166.23	166.96	49041.0
2022-04-22 08:00:00	AAPL	Stock	166.1801	167.6	165.89	167.46	356909.0
2022-04-22 08:30:00	AAPL	Stock	167.4501	167.48	166.38	166.66	197375.0
2022-04-22 09:00:00	AAPL	Stock	166.66	166.77	166.11	166.45	309040.0
2022-04-22 09:30:00	AAPL	Stock	166.49	167.8699	165.81	166.33	7762570.0
2022-04-22 10:00:00	AAPL	Stock	166.34	167.05	165.24	165.48	4984383.0
2022-04-22 10:30:00	AAPL	Stock	165.48	166.55	165.4	165.9258	4068129.0
2022-04-22 11:00:00	AAPL	Stock	165.925	166.56	165.57	165.93	3417557.0
2022-04-22 11:30:00	AAPL	Stock	165.9288	166.05	164.51	164.53	3487669.0
2022-04-22 12:00:00	AAPL	Stock	164.52	164.81	164.14	164.6313	3483753.0
2022-04-22 12:30:00	AAPL	Stock	164.63	165.335	164.57	164.7132	3157924.0
2022-04-22 13:00:00	AAPL	Stock	164.71	164.76	164.0	164.07	2924132.0
2022-04-22 13:30:00	AAPL	Stock	164.07	164.2	163.72	163.7216	2670954.0
2022-04-22 14:00:00	AAPL	Stock	163.72	164.27	163.31	163.4756	3576379.0
2022-04-22 14:30:00	AAPL	Stock	163.46	163.6306	162.56	162.9699	3843200.0
2022-04-22 15:00:00	AAPL	Stock	162.9641	163.685	162.55	163.15	5015525.0
2022-04-22 15:30:00	AAPL	Stock	163.13	164.16	161.5	161.83	11353753.0
2022-04-22 16:00:00	AAPL	Stock	161.82	163.62	161.2	161.4506	9333005.0
2022-04-22 16:30:00	AAPL	Stock	161.43	161.79	161.28	161.5	349854.0
2022-04-22 17:00:00	AAPL	Stock	161.5	161.73	161.46	161.59	41734.0
2022-04-22 17:30:00	AAPL	Stock	161.6001	161.6001	161.31	161.32	29447.0
2022-04-22 18:00:00	AAPL	Stock	161.3001	161.39	161.25	161.32	27796.0
2022-04-22 18:30:00	AAPL	Stock	161.32	161.37	161.11	161.32	22618.0
2022-04-22 19:00:00	AAPL	Stock	161.3	161.3	161.16	161.21	21000.0
2022-04-22 19:30:00	AAPL	Stock	161.21	161.52	161.2	161.5	27052.0
2022-04-22 04:00:00	MSFT	Stock	280.84	281.0	280.05	280.37	3840.0
2022-04-22 04:30:00	MSFT	Stock	280.16	280.16	280.16	280.16	100.0
2022-04-22 05:00:00	MSFT	Stock	280.23	280.64	280.22	280.22	1459.0
2022-04-22 05:30:00	MSFT	Stock	280.65	280.67	279.75	279.99	1432.0
2022-04-22 06:00:00	MSFT	Stock	279.95	280.15	279.4	279.4	3525.0
2022-04-22 06:30:00	MSFT	Stock	279.4	281.0	279.23	280.23	6406.0
2022-04-22 07:00:00	MSFT	Stock	280.3	281.15	280.2	281.15	4210.0
2022-04-22 07:30:00	MSFT	Stock	281.2	281.91	281.0	281.5	10087.0
2022-04-22 08:00:00	MSFT	Stock	281.3	282.38	280.3	282.38	21008.0
2022-04-22 08:30:00	MSFT	Stock	282.35	282.35	281.0	281.45	13595.0
2022-04-22 09:00:00	MSFT	Stock	281.2912	281.99	280.25	281.94	19990.0
2022-04-22 09:30:00	MSFT	Stock	281.97	283.2	279.72	280.47	2263679.0
2022-04-22 10:00:00	MSFT	Stock	280.55	282.3	278.9667	279.6	1064378.0
2022-04-22 10:30:00	MSFT	Stock	279.59	281.0497	279.36	279.67	1139212.0
2022-04-22 11:00:00	MSFT	Stock	279.65	280.37	276.03	279.23	858316.0
2022-04-22 11:30:00	MSFT	Stock	279.26	279.52	277.185	277.28	937683.0
2022-04-22 12:00:00	MSFT	Stock	277.285	278.0	276.84	277.625	710899.0
2022-04-22 12:30:00	MSFT	Stock	277.6	278.365	277.03	277.16	707747.0

> showing 50 of 106,245 rows — these rows as CSV

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