PREVIEW / stock_30min / 2022-10-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-28.parquet
  size:    2.1 MB
  rows:    101,884
  symbols: 2,106

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-10-28 04:00:00	AAPL	Stock	143.69	145.73	143.69	145.4	65401.0
2022-10-28 04:30:00	AAPL	Stock	145.51	146.37	145.51	146.34	24472.0
2022-10-28 05:00:00	AAPL	Stock	146.36	146.36	145.68	145.72	29227.0
2022-10-28 05:30:00	AAPL	Stock	145.7	146.11	145.48	146.11	56516.0
2022-10-28 06:00:00	AAPL	Stock	146.11	146.28	145.99	146.24	18680.0
2022-10-28 06:30:00	AAPL	Stock	146.17	146.65	145.65	145.9	57186.0
2022-10-28 07:00:00	AAPL	Stock	145.84	146.09	145.37	146.0	90937.0
2022-10-28 07:30:00	AAPL	Stock	145.98	146.0	144.9	145.67	138596.0
2022-10-28 08:00:00	AAPL	Stock	145.68	146.08	144.31	145.0	426130.0
2022-10-28 08:30:00	AAPL	Stock	144.94	146.24	144.69	145.0	399552.0
2022-10-28 09:00:00	AAPL	Stock	145.0	148.3	144.86	148.23	857307.0
2022-10-28 09:30:00	AAPL	Stock	148.08	151.91	147.82	151.28	20950403.0
2022-10-28 10:00:00	AAPL	Stock	151.3	155.3	151.265	154.6	20943136.0
2022-10-28 10:30:00	AAPL	Stock	154.5999	156.03	154.15	155.735	15204845.0
2022-10-28 11:00:00	AAPL	Stock	155.74	156.48	155.26	155.64	11177106.0
2022-10-28 11:30:00	AAPL	Stock	155.64	156.17	154.96	155.08	7401321.0
2022-10-28 12:00:00	AAPL	Stock	155.0718	155.96	154.75	155.8909	7442175.0
2022-10-28 12:30:00	AAPL	Stock	155.8999	156.99	155.84	156.7465	7766229.0
2022-10-28 13:00:00	AAPL	Stock	156.75	157.0	156.41	156.71	5341973.0
2022-10-28 13:30:00	AAPL	Stock	156.715	157.5	156.44	156.4499	6759701.0
2022-10-28 14:00:00	AAPL	Stock	156.45	156.55	155.6	155.7699	6198741.0
2022-10-28 14:30:00	AAPL	Stock	155.76	156.59	155.71	156.125	5786671.0
2022-10-28 15:00:00	AAPL	Stock	156.13	156.17	155.36	155.72	6403224.0
2022-10-28 15:30:00	AAPL	Stock	155.725	156.25	155.58	155.71	10945694.0
2022-10-28 16:00:00	AAPL	Stock	155.71	156.1799	155.69	156.13	10957903.0
2022-10-28 16:30:00	AAPL	Stock	156.13	156.4583	155.74	156.3	169664.0
2022-10-28 17:00:00	AAPL	Stock	156.3	156.3	155.73	156.08	128555.0
2022-10-28 17:30:00	AAPL	Stock	156.0	156.08	155.82	155.94	50212.0
2022-10-28 18:00:00	AAPL	Stock	155.94	155.94	155.85	155.85	16666.0
2022-10-28 18:30:00	AAPL	Stock	155.85	155.9	155.76	155.8	17309.0
2022-10-28 19:00:00	AAPL	Stock	155.8	155.88	155.79	155.85	13808.0
2022-10-28 19:30:00	AAPL	Stock	155.87	155.88	155.81	155.83	36561.0
2022-10-28 04:00:00	MSFT	Stock	224.01	224.09	223.55	223.76	15798.0
2022-10-28 04:30:00	MSFT	Stock	223.75	224.4	223.5	224.21	7172.0
2022-10-28 05:00:00	MSFT	Stock	224.21	224.21	223.25	224.1	4960.0
2022-10-28 05:30:00	MSFT	Stock	223.8	224.3	223.8	224.29	6030.0
2022-10-28 06:00:00	MSFT	Stock	224.3	224.49	223.91	224.49	2511.0
2022-10-28 06:30:00	MSFT	Stock	224.48	224.48	224.03	224.37	3744.0
2022-10-28 07:00:00	MSFT	Stock	224.15	225.0	223.85	224.99	11543.0
2022-10-28 07:30:00	MSFT	Stock	225.0	225.09	224.7	224.9	35903.0
2022-10-28 08:00:00	MSFT	Stock	224.39	225.1	223.85	224.5	54449.0
2022-10-28 08:30:00	MSFT	Stock	224.5	227.0	224.22	225.69	91429.0
2022-10-28 09:00:00	MSFT	Stock	225.7	226.68	225.2425	226.24	79511.0
2022-10-28 09:30:00	MSFT	Stock	226.24	230.94	226.05	229.235	4174245.0
2022-10-28 10:00:00	MSFT	Stock	229.28	232.7	228.39	231.705	2681583.0
2022-10-28 10:30:00	MSFT	Stock	231.67	235.19	231.67	233.67	3639577.0
2022-10-28 11:00:00	MSFT	Stock	233.68	234.58	232.7	232.71	1937927.0
2022-10-28 11:30:00	MSFT	Stock	232.715	233.35	232.11	232.5	1497711.0
2022-10-28 12:00:00	MSFT	Stock	232.5	233.56	231.72	233.48	1364347.0
2022-10-28 12:30:00	MSFT	Stock	233.47	233.81	232.7	232.995	915208.0

> showing 50 of 101,884 rows — these rows as CSV

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