PREVIEW / stock_30min / 2022-07-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-28.parquet
  size:    2.1 MB
  rows:    105,585
  symbols: 2,290

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-07-28 04:00:00	AAPL	Stock	155.39	156.09	155.39	155.53	27193.0
2022-07-28 04:30:00	AAPL	Stock	155.56	155.69	155.52	155.57	13789.0
2022-07-28 05:00:00	AAPL	Stock	155.52	155.64	155.3	155.3	8441.0
2022-07-28 05:30:00	AAPL	Stock	155.34	155.84	155.34	155.84	26890.0
2022-07-28 06:00:00	AAPL	Stock	155.84	155.89	155.67	155.8	21442.0
2022-07-28 06:30:00	AAPL	Stock	155.9	155.9	155.71	155.81	6885.0
2022-07-28 07:00:00	AAPL	Stock	155.84	156.19	155.8	156.07	33605.0
2022-07-28 07:30:00	AAPL	Stock	156.03	156.05	155.9	155.96	7365.0
2022-07-28 08:00:00	AAPL	Stock	156.12	156.399	155.78	155.97	92073.0
2022-07-28 08:30:00	AAPL	Stock	156.0	157.25	155.56	156.62	500921.0
2022-07-28 09:00:00	AAPL	Stock	156.71	157.15	156.4	156.97	256262.0
2022-07-28 09:30:00	AAPL	Stock	156.98	157.49	154.8	155.42	6800377.0
2022-07-28 10:00:00	AAPL	Stock	155.43	155.945	154.41	154.805	4453641.0
2022-07-28 10:30:00	AAPL	Stock	154.79	155.9	154.59	155.8999	3341749.0
2022-07-28 11:00:00	AAPL	Stock	155.9	156.89	155.87	156.86	3816322.0
2022-07-28 11:30:00	AAPL	Stock	156.86	157.09	156.285	156.895	3948340.0
2022-07-28 12:00:00	AAPL	Stock	156.8955	157.135	156.61	156.9901	2977497.0
2022-07-28 12:30:00	AAPL	Stock	157.01	157.17	156.44	156.45	2310750.0
2022-07-28 13:00:00	AAPL	Stock	156.45	157.14	156.16	156.9705	2816860.0
2022-07-28 13:30:00	AAPL	Stock	156.975	157.64	156.92	157.355	3140956.0
2022-07-28 14:00:00	AAPL	Stock	157.3521	157.38	156.83	156.85	2901063.0
2022-07-28 14:30:00	AAPL	Stock	156.855	157.4	156.6	157.27	3521511.0
2022-07-28 15:00:00	AAPL	Stock	157.28	157.6	157.08	157.305	3764828.0
2022-07-28 15:30:00	AAPL	Stock	157.3001	157.6	156.64	157.3	8090494.0
2022-07-28 16:00:00	AAPL	Stock	157.35	159.4	157.0	159.1	7063782.0
2022-07-28 16:30:00	AAPL	Stock	159.17	163.87	155.85	163.85	5541733.0
2022-07-28 17:00:00	AAPL	Stock	163.85	164.01	157.35	162.01	2579208.0
2022-07-28 17:30:00	AAPL	Stock	162.0	162.49	161.15	162.36	815690.0
2022-07-28 18:00:00	AAPL	Stock	162.36	162.98	161.91	162.82	486491.0
2022-07-28 18:30:00	AAPL	Stock	162.78	162.85	161.8	162.03	165620.0
2022-07-28 19:00:00	AAPL	Stock	162.05	162.2	161.85	162.1	88191.0
2022-07-28 19:30:00	AAPL	Stock	162.1	162.31	162.0	162.02	143922.0
2022-07-28 04:00:00	MSFT	Stock	267.46	267.46	266.3	266.89	2322.0
2022-07-28 04:30:00	MSFT	Stock	266.51	266.83	266.45	266.58	2102.0
2022-07-28 05:00:00	MSFT	Stock	266.47	266.49	266.05	266.05	3163.0
2022-07-28 05:30:00	MSFT	Stock	266.2	266.55	266.2	266.55	931.0
2022-07-28 06:00:00	MSFT	Stock	266.7	267.15	266.7	267.15	1384.0
2022-07-28 06:30:00	MSFT	Stock	267.41	267.41	267.15	267.15	729.0
2022-07-28 07:00:00	MSFT	Stock	267.3	267.9	267.3	267.3	5103.0
2022-07-28 07:30:00	MSFT	Stock	267.15	267.16	266.92	266.92	2879.0
2022-07-28 08:00:00	MSFT	Stock	267.5	267.93	266.61	266.8284	20604.0
2022-07-28 08:30:00	MSFT	Stock	266.99	268.71	265.85	267.53	58798.0
2022-07-28 09:00:00	MSFT	Stock	267.54	269.85	267.31	269.18	69725.0
2022-07-28 09:30:00	MSFT	Stock	269.67	271.4638	267.87	269.575	3017709.0
2022-07-28 10:00:00	MSFT	Stock	269.625	271.4799	269.55	270.76	2053215.0
2022-07-28 10:30:00	MSFT	Stock	270.8039	273.23	269.955	273.225	1832354.0
2022-07-28 11:00:00	MSFT	Stock	273.24	275.35	273.075	275.03	2853186.0
2022-07-28 11:30:00	MSFT	Stock	275.05	275.28	273.83	274.13	1406923.0
2022-07-28 12:00:00	MSFT	Stock	274.16	274.695	273.56	274.46	1048586.0
2022-07-28 12:30:00	MSFT	Stock	274.475	274.845	274.06	274.06	797228.0

> showing 50 of 105,585 rows — these rows as CSV

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