PREVIEW / stock_30min / 2021-07-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-23.parquet
  size:    2.2 MB
  rows:    108,513
  symbols: 2,814

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-23 04:00:00	AAPL	Stock	147.5	147.69	147.5	147.69	5722.0
2021-07-23 04:30:00	AAPL	Stock	147.75	147.9	147.75	147.78	5893.0
2021-07-23 05:00:00	AAPL	Stock	147.75	147.85	147.7	147.8	1169.0
2021-07-23 05:30:00	AAPL	Stock	147.74	147.74	147.6	147.61	6095.0
2021-07-23 06:00:00	AAPL	Stock	147.54	147.54	147.49	147.54	1986.0
2021-07-23 06:30:00	AAPL	Stock	147.53	147.6	147.52	147.52	4764.0
2021-07-23 07:00:00	AAPL	Stock	147.58	147.8	147.4	147.44	83272.0
2021-07-23 07:30:00	AAPL	Stock	147.43	147.51	147.32	147.51	27070.0
2021-07-23 08:00:00	AAPL	Stock	147.7	147.75	147.25	147.38	233040.0
2021-07-23 08:30:00	AAPL	Stock	147.38	147.49	147.1301	147.21	140260.0
2021-07-23 09:00:00	AAPL	Stock	147.2	147.82	147.11	147.53	207170.0
2021-07-23 09:30:00	AAPL	Stock	147.52	148.02	146.92	147.675	10733812.0
2021-07-23 10:00:00	AAPL	Stock	147.675	148.08	147.57	148.025	5060086.0
2021-07-23 10:30:00	AAPL	Stock	148.03	148.16	147.73	147.865	4198647.0
2021-07-23 11:00:00	AAPL	Stock	147.86	148.25	147.77	148.1401	4017805.0
2021-07-23 11:30:00	AAPL	Stock	148.145	148.27	148.0	148.1	2900975.0
2021-07-23 12:00:00	AAPL	Stock	148.1	148.26	147.85	148.095	2743181.0
2021-07-23 12:30:00	AAPL	Stock	148.1	148.25	148.02	148.15	2109448.0
2021-07-23 13:00:00	AAPL	Stock	148.145	148.64	148.13	148.49	3368169.0
2021-07-23 13:30:00	AAPL	Stock	148.4899	148.5	148.145	148.43	2830025.0
2021-07-23 14:00:00	AAPL	Stock	148.42	148.7177	148.4	148.6001	2707923.0
2021-07-23 14:30:00	AAPL	Stock	148.61	148.675	148.28	148.445	2610364.0
2021-07-23 15:00:00	AAPL	Stock	148.45	148.47	148.19	148.38	2694918.0
2021-07-23 15:30:00	AAPL	Stock	148.38	148.63	148.3319	148.57	6028751.0
2021-07-23 16:00:00	AAPL	Stock	148.56	148.56	148.16	148.41	4363083.0
2021-07-23 16:30:00	AAPL	Stock	148.42	148.45	148.3	148.3	55428.0
2021-07-23 17:00:00	AAPL	Stock	148.3	148.31	148.13	148.17	94737.0
2021-07-23 17:30:00	AAPL	Stock	148.17	148.23	148.11	148.18	81068.0
2021-07-23 18:00:00	AAPL	Stock	148.18	148.2	148.16	148.2	18854.0
2021-07-23 18:30:00	AAPL	Stock	148.22	148.31	148.18	148.28	18092.0
2021-07-23 19:00:00	AAPL	Stock	148.28	148.31	148.27	148.3	13768.0
2021-07-23 19:30:00	AAPL	Stock	148.28	148.31	148.2	148.27	32787.0
2021-07-23 04:00:00	MSFT	Stock	288.27	288.96	288.0	288.12	4902.0
2021-07-23 04:30:00	MSFT	Stock	288.49	288.49	287.82	287.82	1706.0
2021-07-23 05:00:00	MSFT	Stock	288.05	288.1	288.05	288.06	822.0
2021-07-23 05:30:00	MSFT	Stock	288.05	288.2	288.05	288.05	3191.0
2021-07-23 06:00:00	MSFT	Stock	288.05	288.44	288.05	288.44	1561.0
2021-07-23 06:30:00	MSFT	Stock	288.46	288.49	288.36	288.37	2077.0
2021-07-23 07:00:00	MSFT	Stock	288.35	288.39	287.7	287.72	10599.0
2021-07-23 07:30:00	MSFT	Stock	287.72	287.95	287.66	287.94	10341.0
2021-07-23 08:00:00	MSFT	Stock	288.3999	288.4	287.56	287.56	27023.0
2021-07-23 08:30:00	MSFT	Stock	287.65	287.7	287.15	287.36	15017.0
2021-07-23 09:00:00	MSFT	Stock	287.21	288.3	287.0	287.37	62713.0
2021-07-23 09:30:00	MSFT	Stock	287.37	288.54	286.5	288.0	2820909.0
2021-07-23 10:00:00	MSFT	Stock	287.9968	288.8	287.84	288.3	1642579.0
2021-07-23 10:30:00	MSFT	Stock	288.3	288.715	287.97	288.44	1089130.0
2021-07-23 11:00:00	MSFT	Stock	288.455	289.6	288.28	289.45	1192888.0
2021-07-23 11:30:00	MSFT	Stock	289.4482	289.68	289.2101	289.2619	1138940.0
2021-07-23 12:00:00	MSFT	Stock	289.27	289.67	289.1	289.2872	878372.0
2021-07-23 12:30:00	MSFT	Stock	289.285	289.33	288.88	288.99	853124.0

> showing 50 of 108,513 rows — these rows as CSV

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