PREVIEW / stock_30min / 2022-06-09

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-09.parquet
  size:    2.1 MB
  rows:    104,265
  symbols: 2,356

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-06-09 04:00:00	AAPL	Stock	147.8	147.8	147.55	147.59	5287.0
2022-06-09 04:30:00	AAPL	Stock	147.74	148.53	147.74	148.53	9514.0
2022-06-09 05:00:00	AAPL	Stock	148.5	148.5	148.27	148.28	3590.0
2022-06-09 05:30:00	AAPL	Stock	148.35	148.36	148.28	148.33	3218.0
2022-06-09 06:00:00	AAPL	Stock	148.37	149.0	148.28	149.0	19153.0
2022-06-09 06:30:00	AAPL	Stock	149.01	149.76	148.61	148.8	42154.0
2022-06-09 07:00:00	AAPL	Stock	148.78	149.29	148.61	148.92	79348.0
2022-06-09 07:30:00	AAPL	Stock	148.93	149.23	148.46	148.56	66678.0
2022-06-09 08:00:00	AAPL	Stock	148.75	149.29	147.591	148.4	409742.0
2022-06-09 08:30:00	AAPL	Stock	148.39	148.48	147.35	147.69	404133.0
2022-06-09 09:00:00	AAPL	Stock	147.66	147.82	146.89	147.08	300026.0
2022-06-09 09:30:00	AAPL	Stock	147.09	147.95	146.38	147.63	8448253.0
2022-06-09 10:00:00	AAPL	Stock	147.63	147.66	146.31	147.07	5197628.0
2022-06-09 10:30:00	AAPL	Stock	147.08	147.4	146.1416	146.4301	3874126.0
2022-06-09 11:00:00	AAPL	Stock	146.43	146.615	145.95	146.3368	2908180.0
2022-06-09 11:30:00	AAPL	Stock	146.34	146.92	146.03	146.3199	2921449.0
2022-06-09 12:00:00	AAPL	Stock	146.33	146.48	145.8	146.1586	2770109.0
2022-06-09 12:30:00	AAPL	Stock	146.16	146.52	146.03	146.37	2281345.0
2022-06-09 13:00:00	AAPL	Stock	146.38	146.64	145.96	146.035	2190043.0
2022-06-09 13:30:00	AAPL	Stock	146.03	146.05	145.58	146.0399	2623103.0
2022-06-09 14:00:00	AAPL	Stock	146.04	146.04	145.33	145.535	2200811.0
2022-06-09 14:30:00	AAPL	Stock	145.54	145.54	144.74	144.755	3141749.0
2022-06-09 15:00:00	AAPL	Stock	144.755	144.79	143.61	143.615	5472446.0
2022-06-09 15:30:00	AAPL	Stock	143.62	143.8	142.53	142.605	8517147.0
2022-06-09 16:00:00	AAPL	Stock	142.6	142.84	142.0	142.75	7552327.0
2022-06-09 16:30:00	AAPL	Stock	142.75	142.9	142.64	142.89	180998.0
2022-06-09 17:00:00	AAPL	Stock	142.89	143.08	142.85	143.0	68543.0
2022-06-09 17:30:00	AAPL	Stock	142.98	143.1399	142.64	143.0484	354396.0
2022-06-09 18:00:00	AAPL	Stock	143.03	143.23	142.82	142.89	31632.0
2022-06-09 18:30:00	AAPL	Stock	142.83	142.93	142.83	142.9	10511.0
2022-06-09 19:00:00	AAPL	Stock	142.86	142.98	142.75	142.92	17467.0
2022-06-09 19:30:00	AAPL	Stock	142.98	143.14	142.86	143.0	41734.0
2022-06-09 04:00:00	MSFT	Stock	269.65	269.8	269.65	269.8	589.0
2022-06-09 04:30:00	MSFT	Stock	270.11	271.27	270.06	271.27	3305.0
2022-06-09 05:00:00	MSFT	Stock	271.3	271.45	271.3	271.4	1967.0
2022-06-09 05:30:00	MSFT	Stock	271.38	271.52	271.38	271.4	5796.0
2022-06-09 06:00:00	MSFT	Stock	271.4	272.17	271.4	272.17	1787.0
2022-06-09 06:30:00	MSFT	Stock	271.67	271.67	271.47	271.47	808.0
2022-06-09 07:00:00	MSFT	Stock	271.5	271.65	271.15	271.65	4779.0
2022-06-09 07:30:00	MSFT	Stock	271.5	271.75	270.61	270.75	5098.0
2022-06-09 08:00:00	MSFT	Stock	271.4985	271.7	269.2	269.82	23393.0
2022-06-09 08:30:00	MSFT	Stock	270.25	270.6325	268.91	268.98	22642.0
2022-06-09 09:00:00	MSFT	Stock	268.91	269.28	267.5	267.7	22557.0
2022-06-09 09:30:00	MSFT	Stock	267.78	272.12	267.21	271.98	2481828.0
2022-06-09 10:00:00	MSFT	Stock	271.96	272.29	270.785	272.2575	1085941.0
2022-06-09 10:30:00	MSFT	Stock	272.27	272.7081	271.04	271.29	802467.0
2022-06-09 11:00:00	MSFT	Stock	271.285	271.45	270.15	270.88	826631.0
2022-06-09 11:30:00	MSFT	Stock	270.88	272.25	270.73	271.294	844794.0
2022-06-09 12:00:00	MSFT	Stock	271.26	271.49	270.28	271.21	496052.0
2022-06-09 12:30:00	MSFT	Stock	271.25	271.92	270.895	271.7	476124.0

> showing 50 of 104,265 rows — these rows as CSV

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