PREVIEW / stock_30min / 2021-07-13

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-13.parquet
  size:    2.2 MB
  rows:    110,528
  symbols: 2,891

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
2021-07-13 04:00:00	AAPL	Stock	144.0	144.2	143.86	144.2	17604.0
2021-07-13 04:30:00	AAPL	Stock	144.2	144.42	144.18	144.41	7251.0
2021-07-13 05:00:00	AAPL	Stock	144.47	144.71	144.4	144.61	4959.0
2021-07-13 05:30:00	AAPL	Stock	144.68	144.8	144.6	144.8	6247.0
2021-07-13 06:00:00	AAPL	Stock	144.8	144.85	144.57	144.57	10066.0
2021-07-13 06:30:00	AAPL	Stock	144.6	144.7	144.6	144.7	9444.0
2021-07-13 07:00:00	AAPL	Stock	144.71	144.99	144.7	144.96	55901.0
2021-07-13 07:30:00	AAPL	Stock	144.97	144.97	144.85	144.87	23056.0
2021-07-13 08:00:00	AAPL	Stock	144.8701	145.0	144.139	144.7	152890.0
2021-07-13 08:30:00	AAPL	Stock	144.7	144.94	143.55	143.6	547715.0
2021-07-13 09:00:00	AAPL	Stock	143.6	144.1	143.39	144.03	415549.0
2021-07-13 09:30:00	AAPL	Stock	144.06	146.51	143.63	146.345	14584927.0
2021-07-13 10:00:00	AAPL	Stock	146.35	146.93	146.0	146.705	9521904.0
2021-07-13 10:30:00	AAPL	Stock	146.7	146.96	146.37	146.52	5611637.0
2021-07-13 11:00:00	AAPL	Stock	146.525	147.29	146.51	147.23	6823133.0
2021-07-13 11:30:00	AAPL	Stock	147.235	147.46	147.05	147.45	4340216.0
2021-07-13 12:00:00	AAPL	Stock	147.44	147.46	147.01	147.1612	3604174.0
2021-07-13 12:30:00	AAPL	Stock	147.165	147.4	147.1	147.21	2689712.0
2021-07-13 13:00:00	AAPL	Stock	147.21	147.21	146.22	146.4445	5606967.0
2021-07-13 13:30:00	AAPL	Stock	146.45	146.46	145.3	145.7301	7417515.0
2021-07-13 14:00:00	AAPL	Stock	145.73	145.89	144.62	145.88	6716784.0
2021-07-13 14:30:00	AAPL	Stock	145.89	146.07	145.5	146.065	4725987.0
2021-07-13 15:00:00	AAPL	Stock	146.0699	146.08	145.66	145.78	4801720.0
2021-07-13 15:30:00	AAPL	Stock	145.7863	145.98	145.3401	145.68	7605201.0
2021-07-13 16:00:00	AAPL	Stock	145.68	146.0745	145.5	145.52	4527209.0
2021-07-13 16:30:00	AAPL	Stock	145.53	145.61	145.5	145.58	41977.0
2021-07-13 17:00:00	AAPL	Stock	145.57	145.68	145.55	145.65	41888.0
2021-07-13 17:30:00	AAPL	Stock	145.67	145.68	145.55	145.65	20415.0
2021-07-13 18:00:00	AAPL	Stock	145.67	145.76	145.64	145.73	19326.0
2021-07-13 18:30:00	AAPL	Stock	145.74	145.75	145.67	145.7	16652.0
2021-07-13 19:00:00	AAPL	Stock	145.72	145.75	145.7	145.72	18818.0
2021-07-13 19:30:00	AAPL	Stock	145.72	145.74	145.4	145.45	62096.0
2021-07-13 04:00:00	MSFT	Stock	277.13	277.13	277.13	277.13	131.0
2021-07-13 04:30:00	MSFT	Stock	277.6	277.7	277.6	277.7	1161.0
2021-07-13 05:00:00	MSFT	Stock	278.2	278.26	278.19	278.2	1907.0
2021-07-13 05:30:00	MSFT	Stock	278.18	278.5	278.18	278.5	5216.0
2021-07-13 06:00:00	MSFT	Stock	278.48	278.48	278.45	278.45	234.0
2021-07-13 06:30:00	MSFT	Stock	278.4	278.62	278.4	278.5	696.0
2021-07-13 07:00:00	MSFT	Stock	278.31	278.45	278.25	278.41	14432.0
2021-07-13 07:30:00	MSFT	Stock	278.41	278.55	278.2	278.2	9862.0
2021-07-13 08:00:00	MSFT	Stock	278.35	278.45	278.013	278.2	6427.0
2021-07-13 08:30:00	MSFT	Stock	278.05	278.05	276.55	276.6	67235.0
2021-07-13 09:00:00	MSFT	Stock	276.63	277.84	276.55	277.58	36947.0
2021-07-13 09:30:00	MSFT	Stock	277.59	280.57	277.39	280.46	2164040.0
2021-07-13 10:00:00	MSFT	Stock	280.5	281.527	280.48	281.43	1964357.0
2021-07-13 10:30:00	MSFT	Stock	281.46	282.62	281.34	281.85	1877837.0
2021-07-13 11:00:00	MSFT	Stock	281.865	282.68	281.67	282.66	1350539.0
2021-07-13 11:30:00	MSFT	Stock	282.64	282.8477	282.135	282.4301	1329898.0
2021-07-13 12:00:00	MSFT	Stock	282.4399	282.48	281.81	282.04	944541.0
2021-07-13 12:30:00	MSFT	Stock	282.04	282.295	281.9	282.01	697047.0

> showing 50 of 110,528 rows — these rows as CSV

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