PREVIEW / stock_30min / 2022-04-19

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-19.parquet
  size:    2.2 MB
  rows:    106,756
  symbols: 2,444

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-19 04:00:00	AAPL	Stock	165.5	165.61	165.07	165.39	16635.0
2022-04-19 04:30:00	AAPL	Stock	165.39	165.41	164.25	164.41	11864.0
2022-04-19 05:00:00	AAPL	Stock	164.33	164.5	164.17	164.27	5682.0
2022-04-19 05:30:00	AAPL	Stock	164.17	164.44	164.1	164.44	3168.0
2022-04-19 06:00:00	AAPL	Stock	164.36	164.72	164.35	164.72	1253.0
2022-04-19 06:30:00	AAPL	Stock	164.6	164.74	164.58	164.65	3925.0
2022-04-19 07:00:00	AAPL	Stock	164.78	165.15	164.78	164.95	35431.0
2022-04-19 07:30:00	AAPL	Stock	164.92	165.39	164.84	165.3	10467.0
2022-04-19 08:00:00	AAPL	Stock	165.0	166.43	164.79	165.4985	157948.0
2022-04-19 08:30:00	AAPL	Stock	165.46	165.63	164.95	165.08	112427.0
2022-04-19 09:00:00	AAPL	Stock	165.11	165.35	164.51	165.0	115444.0
2022-04-19 09:30:00	AAPL	Stock	165.0	165.135	163.91	165.09	7749924.0
2022-04-19 10:00:00	AAPL	Stock	165.08	166.51	164.89	166.27	5386805.0
2022-04-19 10:30:00	AAPL	Stock	166.27	167.2742	166.22	166.78	4246878.0
2022-04-19 11:00:00	AAPL	Stock	166.78	167.44	166.51	167.23	3423456.0
2022-04-19 11:30:00	AAPL	Stock	167.235	167.45	166.96	166.9955	2636218.0
2022-04-19 12:00:00	AAPL	Stock	167.0	167.045	166.48	166.5	2579381.0
2022-04-19 12:30:00	AAPL	Stock	166.49	166.665	166.25	166.469	1902473.0
2022-04-19 13:00:00	AAPL	Stock	166.47	166.69	166.12	166.1267	1984702.0
2022-04-19 13:30:00	AAPL	Stock	166.13	166.65	166.11	166.485	2326403.0
2022-04-19 14:00:00	AAPL	Stock	166.48	166.51	165.855	166.37	2789810.0
2022-04-19 14:30:00	AAPL	Stock	166.37	166.7	166.15	166.6099	2249334.0
2022-04-19 15:00:00	AAPL	Stock	166.605	167.617	166.495	167.49	3731930.0
2022-04-19 15:30:00	AAPL	Stock	167.495	167.82	166.945	167.46	8345532.0
2022-04-19 16:00:00	AAPL	Stock	167.465	167.465	165.92	166.42	8132346.0
2022-04-19 16:30:00	AAPL	Stock	166.4302	167.4	166.35	166.45	118600.0
2022-04-19 17:00:00	AAPL	Stock	166.4999	166.5	166.16	166.19	36754.0
2022-04-19 17:30:00	AAPL	Stock	166.17	166.39	166.17	166.33	13697.0
2022-04-19 18:00:00	AAPL	Stock	166.34	166.62	166.34	166.57	18723.0
2022-04-19 18:30:00	AAPL	Stock	166.63	166.71	166.51	166.51	13485.0
2022-04-19 19:00:00	AAPL	Stock	166.51	166.52	166.2	166.2	29775.0
2022-04-19 19:30:00	AAPL	Stock	166.21	166.41	166.18	166.34	13241.0
2022-04-19 04:00:00	MSFT	Stock	281.39	281.8	281.25	281.32	3393.0
2022-04-19 04:30:00	MSFT	Stock	281.21	281.21	279.2	279.2	5256.0
2022-04-19 05:00:00	MSFT	Stock	279.38	279.6	279.13	279.2	3063.0
2022-04-19 05:30:00	MSFT	Stock	279.01	279.2	278.67	279.1	1200.0
2022-04-19 06:30:00	MSFT	Stock	279.82	279.82	279.8	279.8	200.0
2022-04-19 07:00:00	MSFT	Stock	279.87	280.35	279.87	279.89	12667.0
2022-04-19 07:30:00	MSFT	Stock	280.05	280.65	279.7	280.65	4989.0
2022-04-19 08:00:00	MSFT	Stock	280.15	283.21	279.8	280.7	18827.0
2022-04-19 08:30:00	MSFT	Stock	280.99	280.99	279.63	279.81	12312.0
2022-04-19 09:00:00	MSFT	Stock	280.15	280.79	278.94	279.38	37478.0
2022-04-19 09:30:00	MSFT	Stock	279.38	282.42	278.41	282.42	2323575.0
2022-04-19 10:00:00	MSFT	Stock	282.4	284.405	282.06	283.33	1206930.0
2022-04-19 10:30:00	MSFT	Stock	283.36	284.75	283.23	283.93	921502.0
2022-04-19 11:00:00	MSFT	Stock	283.88	284.6622	283.58	284.42	902219.0
2022-04-19 11:30:00	MSFT	Stock	284.41	284.865	283.9	284.2933	575293.0
2022-04-19 12:00:00	MSFT	Stock	284.3	284.33	283.52	283.5878	472551.0
2022-04-19 12:30:00	MSFT	Stock	283.6	283.99	283.29	283.81	520458.0
2022-04-19 13:00:00	MSFT	Stock	283.7803	284.06	283.15	283.2	492671.0

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

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