PREVIEW / stock_30min / 2021-07-06

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-06.parquet
  size:    2.2 MB
  rows:    113,296
  symbols: 2,914

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
2021-07-06 04:00:00	AAPL	Stock	139.5	139.9	139.39	139.65	31274.0
2021-07-06 04:30:00	AAPL	Stock	139.57	139.69	139.52	139.69	8248.0
2021-07-06 05:00:00	AAPL	Stock	139.66	139.9	139.66	139.9	6998.0
2021-07-06 05:30:00	AAPL	Stock	139.89	139.89	139.7	139.72	2988.0
2021-07-06 06:00:00	AAPL	Stock	139.77	139.8	139.69	139.7	6301.0
2021-07-06 06:30:00	AAPL	Stock	139.72	140.0	139.7	139.94	10533.0
2021-07-06 07:00:00	AAPL	Stock	139.92	140.38	139.84	140.33	170585.0
2021-07-06 07:30:00	AAPL	Stock	140.329	140.33	140.18	140.31	74864.0
2021-07-06 08:00:00	AAPL	Stock	139.9402	140.38	139.611	140.31	210251.0
2021-07-06 08:30:00	AAPL	Stock	140.31	140.35	140.1	140.17	190865.0
2021-07-06 09:00:00	AAPL	Stock	140.2288	140.44	140.0	140.09	464786.0
2021-07-06 09:30:00	AAPL	Stock	140.1	142.885	140.07	142.73	18935452.0
2021-07-06 10:00:00	AAPL	Stock	142.73	143.15	142.45	142.895	10241248.0
2021-07-06 10:30:00	AAPL	Stock	142.89	142.91	141.8	141.815	7556079.0
2021-07-06 11:00:00	AAPL	Stock	141.8101	142.11	141.34	141.805	6206615.0
2021-07-06 11:30:00	AAPL	Stock	141.805	141.99	141.16	141.57	5632738.0
2021-07-06 12:00:00	AAPL	Stock	141.56	141.56	140.12	140.569	6634806.0
2021-07-06 12:30:00	AAPL	Stock	140.56	141.66	140.39	141.61	5246324.0
2021-07-06 13:00:00	AAPL	Stock	141.602	141.68	141.37	141.615	3999670.0
2021-07-06 13:30:00	AAPL	Stock	141.61	142.04	141.525	141.606	4569407.0
2021-07-06 14:00:00	AAPL	Stock	141.605	141.79	141.22	141.7623	3976658.0
2021-07-06 14:30:00	AAPL	Stock	141.765	141.82	141.5	141.7197	3005930.0
2021-07-06 15:00:00	AAPL	Stock	141.715	142.2	141.63	142.1	4257062.0
2021-07-06 15:30:00	AAPL	Stock	142.11	142.15	141.7819	142.02	7107542.0
2021-07-06 16:00:00	AAPL	Stock	142.06	142.06	141.76	142.05	7632129.0
2021-07-06 16:30:00	AAPL	Stock	142.06	142.15	141.9	141.99	49510.0
2021-07-06 17:00:00	AAPL	Stock	141.95	142.02	141.93	141.95	25687.0
2021-07-06 17:30:00	AAPL	Stock	141.95	142.0	141.93	142.0	17778.0
2021-07-06 18:00:00	AAPL	Stock	141.97	142.25	141.97	142.24	57847.0
2021-07-06 18:30:00	AAPL	Stock	142.24	142.25	142.0	142.14	29329.0
2021-07-06 19:00:00	AAPL	Stock	142.17	142.17	142.04	142.04	21388.0
2021-07-06 19:30:00	AAPL	Stock	142.04	142.25	142.0	142.06	53490.0
2021-07-06 04:00:00	MSFT	Stock	277.85	277.93	277.41	277.93	2674.0
2021-07-06 04:30:00	MSFT	Stock	277.55	277.95	277.55	277.95	468.0
2021-07-06 05:00:00	MSFT	Stock	277.82	277.9	277.82	277.9	1049.0
2021-07-06 05:30:00	MSFT	Stock	277.78	277.78	277.78	277.78	100.0
2021-07-06 06:00:00	MSFT	Stock	277.85	278.0	277.85	277.9	731.0
2021-07-06 06:30:00	MSFT	Stock	278.05	278.35	278.05	278.35	2158.0
2021-07-06 07:00:00	MSFT	Stock	278.11	278.53	278.0	278.36	12492.0
2021-07-06 07:30:00	MSFT	Stock	278.5	278.63	278.11	278.4	7855.0
2021-07-06 08:00:00	MSFT	Stock	278.4	278.5857	277.9	278.2	19888.0
2021-07-06 08:30:00	MSFT	Stock	278.2	278.7	278.13	278.4592	15086.0
2021-07-06 09:00:00	MSFT	Stock	278.46	278.61	277.72	278.04	58225.0
2021-07-06 09:30:00	MSFT	Stock	278.01	279.21	277.62	278.2199	3208202.0
2021-07-06 10:00:00	MSFT	Stock	278.2	279.3698	278.04	279.25	1407921.0
2021-07-06 10:30:00	MSFT	Stock	279.2499	279.35	278.1501	278.79	1380579.0
2021-07-06 11:00:00	MSFT	Stock	278.8	279.03	278.1	278.465	1037400.0
2021-07-06 11:30:00	MSFT	Stock	278.49	278.53	277.0425	277.42	1265987.0
2021-07-06 12:00:00	MSFT	Stock	277.4	277.567	275.95	276.5	1250669.0
2021-07-06 12:30:00	MSFT	Stock	276.505	276.56	274.3	276.5	2854565.0

> showing 50 of 113,296 rows — these rows as CSV

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