PREVIEW / stock_30min / 2022-09-21

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-21.parquet
  size:    2.1 MB
  rows:    103,691
  symbols: 2,234

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-09-21 04:00:00	AAPL	Stock	157.39	157.39	156.32	156.65	16760.0
2022-09-21 04:30:00	AAPL	Stock	156.63	156.72	156.51	156.68	4652.0
2022-09-21 05:00:00	AAPL	Stock	156.62	156.62	156.38	156.49	4900.0
2022-09-21 05:30:00	AAPL	Stock	156.49	156.97	156.49	156.75	16569.0
2022-09-21 06:00:00	AAPL	Stock	156.8	156.8	156.58	156.6	3227.0
2022-09-21 06:30:00	AAPL	Stock	156.67	156.77	156.41	156.71	9123.0
2022-09-21 07:00:00	AAPL	Stock	156.64	156.68	156.36	156.4	41998.0
2022-09-21 07:30:00	AAPL	Stock	156.44	156.86	156.44	156.82	47895.0
2022-09-21 08:00:00	AAPL	Stock	156.5732	157.12	156.35	157.12	101781.0
2022-09-21 08:30:00	AAPL	Stock	157.1	157.47	157.09	157.3	176852.0
2022-09-21 09:00:00	AAPL	Stock	157.34	157.46	157.05	157.44	166244.0
2022-09-21 09:30:00	AAPL	Stock	157.34	158.4	156.521	157.0301	10026622.0
2022-09-21 10:00:00	AAPL	Stock	157.02	157.4	156.565	157.39	5058784.0
2022-09-21 10:30:00	AAPL	Stock	157.3918	157.425	156.31	156.465	3857548.0
2022-09-21 11:00:00	AAPL	Stock	156.46	156.51	155.92	156.135	3234913.0
2022-09-21 11:30:00	AAPL	Stock	156.14	156.53	156.115	156.3086	2449390.0
2022-09-21 12:00:00	AAPL	Stock	156.29	157.19	156.16	157.1474	3319485.0
2022-09-21 12:30:00	AAPL	Stock	157.14	157.3712	157.08	157.091	2767438.0
2022-09-21 13:00:00	AAPL	Stock	157.1	157.34	156.962	157.232	2365763.0
2022-09-21 13:30:00	AAPL	Stock	157.23	158.05	157.21	157.89	3718796.0
2022-09-21 14:00:00	AAPL	Stock	157.89	158.02	154.44	155.1	10445132.0
2022-09-21 14:30:00	AAPL	Stock	155.1	158.74	154.69	158.34	12811908.0
2022-09-21 15:00:00	AAPL	Stock	158.33	158.61	155.68	155.71	8106205.0
2022-09-21 15:30:00	AAPL	Stock	155.705	155.96	153.6	153.71	10992948.0
2022-09-21 16:00:00	AAPL	Stock	153.71	153.818	153.01	153.1	6767795.0
2022-09-21 16:30:00	AAPL	Stock	153.08	153.72	153.0	153.45	256917.0
2022-09-21 17:00:00	AAPL	Stock	153.45	153.72	153.22	153.27	134691.0
2022-09-21 17:30:00	AAPL	Stock	153.33	153.33	153.17	153.2565	70109.0
2022-09-21 18:00:00	AAPL	Stock	153.27	153.39	152.92	153.01	104896.0
2022-09-21 18:30:00	AAPL	Stock	153.03	153.09	152.41	152.53	71906.0
2022-09-21 19:00:00	AAPL	Stock	152.55	152.55	152.22	152.35	41131.0
2022-09-21 19:30:00	AAPL	Stock	152.33	152.47	152.23	152.45	45646.0
2022-09-21 04:00:00	MSFT	Stock	242.41	242.89	242.28	242.89	1557.0
2022-09-21 04:30:00	MSFT	Stock	242.78	242.97	242.78	242.97	215.0
2022-09-21 05:00:00	MSFT	Stock	242.6	242.6	242.45	242.45	200.0
2022-09-21 05:30:00	MSFT	Stock	242.85	243.1	242.85	243.1	545.0
2022-09-21 06:00:00	MSFT	Stock	242.97	242.97	242.97	242.97	102.0
2022-09-21 06:30:00	MSFT	Stock	242.57	242.78	242.31	242.78	2392.0
2022-09-21 07:00:00	MSFT	Stock	242.6	242.92	242.47	242.58	3881.0
2022-09-21 07:30:00	MSFT	Stock	242.6	243.35	242.6	243.1	4448.0
2022-09-21 08:00:00	MSFT	Stock	242.5149	243.25	242.4	243.25	28226.0
2022-09-21 08:30:00	MSFT	Stock	243.35	244.38	243.35	244.38	21213.0
2022-09-21 09:00:00	MSFT	Stock	244.49	244.759	243.77	244.38	30907.0
2022-09-21 09:30:00	MSFT	Stock	244.37	245.49	243.63	244.82	1912407.0
2022-09-21 10:00:00	MSFT	Stock	244.81	245.16	243.85	244.71	1034962.0
2022-09-21 10:30:00	MSFT	Stock	244.7	244.76	243.66	243.95	592862.0
2022-09-21 11:00:00	MSFT	Stock	243.9329	244.06	243.44	243.84	464938.0
2022-09-21 11:30:00	MSFT	Stock	243.85	244.609	243.8	244.5	660307.0
2022-09-21 12:00:00	MSFT	Stock	244.465	245.22	244.27	245.2	616477.0
2022-09-21 12:30:00	MSFT	Stock	245.19	245.69	245.02	245.029	658182.0

> showing 50 of 103,691 rows — these rows as CSV

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