PREVIEW / stock_30min / 2021-08-12

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-12.parquet
  size:    2.2 MB
  rows:    109,354
  symbols: 2,813

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-08-12 04:00:00	AAPL	Stock	145.61	145.67	145.5	145.5	3319.0
2021-08-12 04:30:00	AAPL	Stock	145.61	145.84	145.61	145.84	1219.0
2021-08-12 05:00:00	AAPL	Stock	145.75	145.82	145.75	145.82	368.0
2021-08-12 05:30:00	AAPL	Stock	145.78	145.78	145.75	145.76	2165.0
2021-08-12 06:00:00	AAPL	Stock	145.74	145.77	145.72	145.77	752.0
2021-08-12 06:30:00	AAPL	Stock	145.8	145.92	145.8	145.91	1713.0
2021-08-12 07:00:00	AAPL	Stock	145.9	146.1	145.85	146.05	29246.0
2021-08-12 07:30:00	AAPL	Stock	146.05	146.09	146.02	146.04	15114.0
2021-08-12 08:00:00	AAPL	Stock	146.0495	146.1	145.496	145.95	72374.0
2021-08-12 08:30:00	AAPL	Stock	145.91	145.94	145.55	145.6	122388.0
2021-08-12 09:00:00	AAPL	Stock	145.61	146.28	145.57	146.19	259116.0
2021-08-12 09:30:00	AAPL	Stock	146.2	147.43	145.84	147.06	10494012.0
2021-08-12 10:00:00	AAPL	Stock	147.07	147.57	146.58	147.535	6970000.0
2021-08-12 10:30:00	AAPL	Stock	147.545	148.25	147.48	148.17	6074972.0
2021-08-12 11:00:00	AAPL	Stock	148.17	148.49	148.06	148.37	4608832.0
2021-08-12 11:30:00	AAPL	Stock	148.3601	148.53	148.02	148.0398	3396886.0
2021-08-12 12:00:00	AAPL	Stock	148.0399	148.2	147.7	148.17	3321692.0
2021-08-12 12:30:00	AAPL	Stock	148.175	148.44	148.1708	148.3003	2694106.0
2021-08-12 13:00:00	AAPL	Stock	148.3	148.33	148.065	148.2399	2327086.0
2021-08-12 13:30:00	AAPL	Stock	148.24	148.45	148.2	148.335	2240776.0
2021-08-12 14:00:00	AAPL	Stock	148.3397	148.69	148.22	148.6698	2913887.0
2021-08-12 14:30:00	AAPL	Stock	148.665	148.85	148.62	148.705	2949555.0
2021-08-12 15:00:00	AAPL	Stock	148.71	148.89	148.61	148.715	3121084.0
2021-08-12 15:30:00	AAPL	Stock	148.71	149.05	148.57	148.885	7198609.0
2021-08-12 16:00:00	AAPL	Stock	148.89	149.02	148.88	149.0	6115637.0
2021-08-12 16:30:00	AAPL	Stock	149.0	149.02	148.96	148.99	39357.0
2021-08-12 17:00:00	AAPL	Stock	148.99	149.02	148.9	148.9	33184.0
2021-08-12 17:30:00	AAPL	Stock	148.93	148.96	148.86	148.94	19264.0
2021-08-12 18:00:00	AAPL	Stock	148.9399	148.95	148.84	148.85	23681.0
2021-08-12 18:30:00	AAPL	Stock	148.85	148.94	148.82	148.9001	10096.0
2021-08-12 19:00:00	AAPL	Stock	148.91	148.97	148.89	148.96	13515.0
2021-08-12 19:30:00	AAPL	Stock	148.96	148.98	148.93	148.98	35667.0
2021-08-12 04:00:00	MSFT	Stock	286.38	286.38	286.32	286.32	400.0
2021-08-12 05:00:00	MSFT	Stock	286.22	286.4	286.22	286.4	387.0
2021-08-12 05:30:00	MSFT	Stock	286.41	286.41	286.41	286.41	383.0
2021-08-12 06:00:00	MSFT	Stock	286.47	286.5	286.47	286.5	1441.0
2021-08-12 06:30:00	MSFT	Stock	286.85	286.85	286.85	286.85	100.0
2021-08-12 07:00:00	MSFT	Stock	286.86	287.0	286.86	287.0	3369.0
2021-08-12 07:30:00	MSFT	Stock	287.19	287.2	287.19	287.2	257.0
2021-08-12 08:00:00	MSFT	Stock	286.86	287.2	286.82	287.07	12028.0
2021-08-12 08:30:00	MSFT	Stock	286.94	286.95	286.2	286.42	11566.0
2021-08-12 09:00:00	MSFT	Stock	286.35	287.07	286.2	286.5	19461.0
2021-08-12 09:30:00	MSFT	Stock	286.62	288.08	286.34	287.68	1287891.0
2021-08-12 10:00:00	MSFT	Stock	287.67	288.68	286.95	288.42	906454.0
2021-08-12 10:30:00	MSFT	Stock	288.43	289.74	288.43	289.52	971453.0
2021-08-12 11:00:00	MSFT	Stock	289.5	289.6	289.11	289.13	543912.0
2021-08-12 11:30:00	MSFT	Stock	289.13	289.45	289.0442	289.0442	517285.0
2021-08-12 12:00:00	MSFT	Stock	289.04	289.15	288.73	288.85	414510.0
2021-08-12 12:30:00	MSFT	Stock	288.855	289.13	288.84	288.94	322262.0
2021-08-12 13:00:00	MSFT	Stock	288.945	289.38	288.785	289.3653	396279.0

> showing 50 of 109,354 rows — these rows as CSV

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