PREVIEW / stock_30min / 2023-07-11

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-11.parquet
  size:    2.1 MB
  rows:    100,948
  symbols: 1,561

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
2023-07-11 04:00:00	AAPL	Stock	188.8	189.0	188.74	188.88	12940.0
2023-07-11 04:30:00	AAPL	Stock	188.83	188.83	188.55	188.61	8325.0
2023-07-11 05:00:00	AAPL	Stock	188.78	188.83	188.78	188.81	7610.0
2023-07-11 05:30:00	AAPL	Stock	188.86	189.37	188.86	189.37	15048.0
2023-07-11 06:00:00	AAPL	Stock	189.2	189.3	189.09	189.21	5541.0
2023-07-11 06:30:00	AAPL	Stock	189.12	189.16	188.91	188.92	4943.0
2023-07-11 07:00:00	AAPL	Stock	189.0	189.36	189.0	189.29	15809.0
2023-07-11 07:30:00	AAPL	Stock	189.29	189.54	189.29	189.44	24109.0
2023-07-11 08:00:00	AAPL	Stock	189.1	189.96	188.63	189.46	77528.0
2023-07-11 08:30:00	AAPL	Stock	189.47	189.64	189.4	189.62	108245.0
2023-07-11 09:00:00	AAPL	Stock	189.63	189.67	189.11	189.2	140832.0
2023-07-11 09:30:00	AAPL	Stock	189.16	189.3	187.59	187.83	5230896.0
2023-07-11 10:00:00	AAPL	Stock	187.84	188.2	187.45	188.11	2695748.0
2023-07-11 10:30:00	AAPL	Stock	188.095	188.5601	187.8907	188.16	2085136.0
2023-07-11 11:00:00	AAPL	Stock	188.16	188.4609	187.655	187.715	1861395.0
2023-07-11 11:30:00	AAPL	Stock	187.7157	188.2	187.26	188.1917	2137739.0
2023-07-11 12:00:00	AAPL	Stock	188.2	188.38	187.465	187.615	2068272.0
2023-07-11 12:30:00	AAPL	Stock	187.62	187.78	187.46	187.7	1491059.0
2023-07-11 13:00:00	AAPL	Stock	187.7	187.7869	187.34	187.41	1537661.0
2023-07-11 13:30:00	AAPL	Stock	187.406	187.5478	187.175	187.47	1705802.0
2023-07-11 14:00:00	AAPL	Stock	187.47	187.5199	186.7001	186.881	2443121.0
2023-07-11 14:30:00	AAPL	Stock	186.885	187.375	186.6	187.359	1689300.0
2023-07-11 15:00:00	AAPL	Stock	187.35	187.395	187.0601	187.1372	1835839.0
2023-07-11 15:30:00	AAPL	Stock	187.13	188.27	186.97	188.06	5317720.0
2023-07-11 16:00:00	AAPL	Stock	188.05	188.15	187.7182	188.02	4798398.0
2023-07-11 16:30:00	AAPL	Stock	188.02	188.13	188.02	188.05	82425.0
2023-07-11 17:00:00	AAPL	Stock	188.04	188.17	188.03	188.09	30036.0
2023-07-11 17:30:00	AAPL	Stock	188.1	188.11	188.01	188.08	24278.0
2023-07-11 18:00:00	AAPL	Stock	188.07	188.2	188.05	188.16	8871.0
2023-07-11 18:30:00	AAPL	Stock	188.15	188.18	188.1	188.18	10258.0
2023-07-11 19:00:00	AAPL	Stock	188.19	188.26	188.11	188.11	9815.0
2023-07-11 19:30:00	AAPL	Stock	188.11	188.2	188.04	188.2	14391.0
2023-07-11 04:00:00	MSFT	Stock	332.14	332.34	331.52	331.52	8264.0
2023-07-11 04:30:00	MSFT	Stock	331.5	331.5	331.5	331.5	741.0
2023-07-11 05:00:00	MSFT	Stock	331.5	331.8	331.5	331.63	1020.0
2023-07-11 05:30:00	MSFT	Stock	331.79	332.25	331.66	332.25	1185.0
2023-07-11 06:00:00	MSFT	Stock	332.3	332.3	332.2	332.2	1410.0
2023-07-11 06:30:00	MSFT	Stock	332.03	332.48	331.76	331.84	3004.0
2023-07-11 07:00:00	MSFT	Stock	332.0	332.24	331.84	331.95	6353.0
2023-07-11 07:30:00	MSFT	Stock	332.02	332.6	331.95	332.45	6908.0
2023-07-11 08:00:00	MSFT	Stock	331.73	332.95	331.12	332.4	55175.0
2023-07-11 08:30:00	MSFT	Stock	332.5699	333.3	332.05	332.1883	34945.0
2023-07-11 09:00:00	MSFT	Stock	332.2	332.24	330.15	330.99	54806.0
2023-07-11 09:30:00	MSFT	Stock	331.06	331.45	328.28	328.715	2912485.0
2023-07-11 10:00:00	MSFT	Stock	328.72	329.09	327.0	328.815	1949788.0
2023-07-11 10:30:00	MSFT	Stock	328.79	330.23	328.78	329.86	1515151.0
2023-07-11 11:00:00	MSFT	Stock	329.875	330.79	329.4242	329.73	1301679.0
2023-07-11 11:30:00	MSFT	Stock	329.74	332.3443	329.331	332.335	1237638.0
2023-07-11 12:00:00	MSFT	Stock	332.32	332.86	330.06	330.45	1376084.0
2023-07-11 12:30:00	MSFT	Stock	330.47	331.5	330.35	331.175	798602.0

> showing 50 of 100,948 rows — these rows as CSV

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