PREVIEW / stock_30min / 2022-03-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-28.parquet
  size:    2.2 MB
  rows:    109,175
  symbols: 2,508

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-03-28 04:00:00	AAPL	Stock	174.0	174.0	171.77	172.21	169255.0
2022-03-28 04:30:00	AAPL	Stock	172.21	172.21	171.34	172.1	80345.0
2022-03-28 05:00:00	AAPL	Stock	172.1	172.1	170.73	171.44	43551.0
2022-03-28 05:30:00	AAPL	Stock	171.36	171.65	171.33	171.44	26210.0
2022-03-28 06:00:00	AAPL	Stock	171.5	171.52	171.1	171.2	25875.0
2022-03-28 06:30:00	AAPL	Stock	171.2	171.5	171.0	171.33	27328.0
2022-03-28 07:00:00	AAPL	Stock	171.49	173.0	171.45	172.95	267054.0
2022-03-28 07:30:00	AAPL	Stock	172.94	173.07	172.4	172.49	196722.0
2022-03-28 08:00:00	AAPL	Stock	172.6701	174.284	171.6	172.17	634006.0
2022-03-28 08:30:00	AAPL	Stock	172.2	172.34	171.8	172.16	373368.0
2022-03-28 09:00:00	AAPL	Stock	172.16	172.43	171.85	172.09	452885.0
2022-03-28 09:30:00	AAPL	Stock	172.17	175.005	172.0	174.4818	12310134.0
2022-03-28 10:00:00	AAPL	Stock	174.48	174.54	173.62	174.34	7219794.0
2022-03-28 10:30:00	AAPL	Stock	174.345	175.0	173.7	174.97	5229577.0
2022-03-28 11:00:00	AAPL	Stock	174.96	175.005	174.1101	174.38	4932515.0
2022-03-28 11:30:00	AAPL	Stock	174.375	174.395	173.1	173.1512	4720068.0
2022-03-28 12:00:00	AAPL	Stock	173.16	173.67	173.08	173.4	3265831.0
2022-03-28 12:30:00	AAPL	Stock	173.41	174.09	173.33	174.04	2845664.0
2022-03-28 13:00:00	AAPL	Stock	174.05	174.6	173.91	174.4418	2968624.0
2022-03-28 13:30:00	AAPL	Stock	174.44	174.61	174.1506	174.425	2835060.0
2022-03-28 14:00:00	AAPL	Stock	174.43	174.8	174.3316	174.7401	3561650.0
2022-03-28 14:30:00	AAPL	Stock	174.74	175.06	174.525	175.0471	4416356.0
2022-03-28 15:00:00	AAPL	Stock	175.045	175.11	174.7439	175.0	4596901.0
2022-03-28 15:30:00	AAPL	Stock	175.0	175.73	174.8	175.59	11092212.0
2022-03-28 16:00:00	AAPL	Stock	175.59	175.75	175.51	175.74	6401199.0
2022-03-28 16:30:00	AAPL	Stock	175.68	175.74	175.6	175.6	62516.0
2022-03-28 17:00:00	AAPL	Stock	175.62	175.63	175.46	175.54	45309.0
2022-03-28 17:30:00	AAPL	Stock	175.55	175.55	175.47	175.52	11472.0
2022-03-28 18:00:00	AAPL	Stock	175.48	175.5	175.42	175.43	16647.0
2022-03-28 18:30:00	AAPL	Stock	175.42	175.49	175.4	175.44	10043.0
2022-03-28 19:00:00	AAPL	Stock	175.44	175.44	175.25	175.43	36426.0
2022-03-28 19:30:00	AAPL	Stock	175.46	175.47	175.43	175.46	34158.0
2022-03-28 04:00:00	MSFT	Stock	304.03	304.03	303.06	303.67	2444.0
2022-03-28 04:30:00	MSFT	Stock	303.5	303.7	303.47	303.55	3619.0
2022-03-28 05:00:00	MSFT	Stock	303.49	303.49	302.8	302.8	2253.0
2022-03-28 05:30:00	MSFT	Stock	303.33	303.5	303.2	303.3	870.0
2022-03-28 06:00:00	MSFT	Stock	303.48	303.48	302.99	302.99	1274.0
2022-03-28 06:30:00	MSFT	Stock	303.06	303.5	303.06	303.31	2610.0
2022-03-28 07:00:00	MSFT	Stock	303.5	304.19	303.5	304.14	4383.0
2022-03-28 07:30:00	MSFT	Stock	304.22	304.48	304.22	304.4	5847.0
2022-03-28 08:00:00	MSFT	Stock	303.81	304.7245	303.57	304.35	25641.0
2022-03-28 08:30:00	MSFT	Stock	304.13	304.2599	303.75	303.75	12774.0
2022-03-28 09:00:00	MSFT	Stock	303.7	304.75	303.3	304.33	16694.0
2022-03-28 09:30:00	MSFT	Stock	304.25	310.5	304.25	310.07	3590065.0
2022-03-28 10:00:00	MSFT	Stock	310.08	310.4	307.3	308.33	1692467.0
2022-03-28 10:30:00	MSFT	Stock	308.325	309.4999	307.07	309.3897	1078684.0
2022-03-28 11:00:00	MSFT	Stock	309.41	309.56	307.38	308.51	958279.0
2022-03-28 11:30:00	MSFT	Stock	308.5	308.52	305.46	305.74	936923.0
2022-03-28 12:00:00	MSFT	Stock	305.7	306.49	305.0401	306.01	696996.0
2022-03-28 12:30:00	MSFT	Stock	306.0	307.03	305.93	306.925	655338.0

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

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