PREVIEW / stock_30min / 2021-07-07

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-07.parquet
  size:    2.2 MB
  rows:    110,424
  symbols: 2,869

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-07 04:00:00	AAPL	Stock	142.41	143.15	142.41	142.84	53800.0
2021-07-07 04:30:00	AAPL	Stock	142.89	142.97	142.66	142.66	10490.0
2021-07-07 05:00:00	AAPL	Stock	142.7	142.88	142.7	142.88	5212.0
2021-07-07 05:30:00	AAPL	Stock	142.9	143.04	142.84	142.85	8125.0
2021-07-07 06:00:00	AAPL	Stock	142.85	142.88	142.73	142.85	2355.0
2021-07-07 06:30:00	AAPL	Stock	142.9	142.96	142.78	142.81	9039.0
2021-07-07 07:00:00	AAPL	Stock	142.78	143.24	142.75	143.23	144278.0
2021-07-07 07:30:00	AAPL	Stock	143.22	143.22	143.03	143.2	69577.0
2021-07-07 08:00:00	AAPL	Stock	142.9	143.3	142.82	143.22	428553.0
2021-07-07 08:30:00	AAPL	Stock	143.23	143.4	143.08	143.4	202855.0
2021-07-07 09:00:00	AAPL	Stock	143.39	143.61	143.33	143.54	363677.0
2021-07-07 09:30:00	AAPL	Stock	143.54	144.44	142.66	144.14	18271093.0
2021-07-07 10:00:00	AAPL	Stock	144.15	144.5	143.45	143.78	10905998.0
2021-07-07 10:30:00	AAPL	Stock	143.781	143.9	142.84	143.44	7930713.0
2021-07-07 11:00:00	AAPL	Stock	143.43	143.47	142.87	143.45	4468529.0
2021-07-07 11:30:00	AAPL	Stock	143.44	144.26	143.125	143.91	5278075.0
2021-07-07 12:00:00	AAPL	Stock	143.91	144.1	143.85	143.855	3176584.0
2021-07-07 12:30:00	AAPL	Stock	143.86	144.1	143.72	143.95	2614918.0
2021-07-07 13:00:00	AAPL	Stock	143.945	144.2	143.56	144.19	3272282.0
2021-07-07 13:30:00	AAPL	Stock	144.19	144.4	143.98	144.36	4221545.0
2021-07-07 14:00:00	AAPL	Stock	144.37	144.89	144.32	144.66	6680316.0
2021-07-07 14:30:00	AAPL	Stock	144.65	144.66	144.08	144.355	5165397.0
2021-07-07 15:00:00	AAPL	Stock	144.3501	144.6	144.24	144.3306	4225376.0
2021-07-07 15:30:00	AAPL	Stock	144.3311	144.68	144.295	144.59	7516436.0
2021-07-07 16:00:00	AAPL	Stock	144.57	144.8	144.54	144.67	9390175.0
2021-07-07 16:30:00	AAPL	Stock	144.62	144.86	144.53	144.71	107075.0
2021-07-07 17:00:00	AAPL	Stock	144.715	144.72	144.54	144.58	54023.0
2021-07-07 17:30:00	AAPL	Stock	144.56	144.6	144.55	144.59	21479.0
2021-07-07 18:00:00	AAPL	Stock	144.59	144.65	144.57	144.59	27511.0
2021-07-07 18:30:00	AAPL	Stock	144.59	144.72	144.59	144.72	36712.0
2021-07-07 19:00:00	AAPL	Stock	144.71	144.75	144.65	144.69	37779.0
2021-07-07 19:30:00	AAPL	Stock	144.6899	144.8	144.66	144.76	41716.0
2021-07-07 04:00:00	MSFT	Stock	279.29	279.29	278.34	279.02	8326.0
2021-07-07 04:30:00	MSFT	Stock	279.19	279.19	278.89	278.89	1754.0
2021-07-07 05:00:00	MSFT	Stock	278.98	279.17	278.98	279.17	642.0
2021-07-07 05:30:00	MSFT	Stock	279.09	279.2	279.09	279.2	1782.0
2021-07-07 06:00:00	MSFT	Stock	279.16	279.2	279.0	279.12	2208.0
2021-07-07 06:30:00	MSFT	Stock	278.71	279.25	278.71	279.25	3758.0
2021-07-07 07:00:00	MSFT	Stock	279.03	279.34	278.82	279.28	15874.0
2021-07-07 07:30:00	MSFT	Stock	279.25	279.25	279.0	279.0	11671.0
2021-07-07 08:00:00	MSFT	Stock	279.09	279.3499	278.9	279.0	27810.0
2021-07-07 08:30:00	MSFT	Stock	279.0	279.05	278.67	278.87	13958.0
2021-07-07 09:00:00	MSFT	Stock	278.99	279.78	278.75	279.4	34654.0
2021-07-07 09:30:00	MSFT	Stock	279.4	279.95	278.1	279.1	2408617.0
2021-07-07 10:00:00	MSFT	Stock	279.11	280.5	278.91	279.95	2155086.0
2021-07-07 10:30:00	MSFT	Stock	279.95	280.22	278.52	279.24	1698306.0
2021-07-07 11:00:00	MSFT	Stock	279.24	279.46	277.15	278.93	1059075.0
2021-07-07 11:30:00	MSFT	Stock	278.945	279.98	278.52	279.69	802080.0
2021-07-07 12:00:00	MSFT	Stock	279.705	280.24	279.66	279.72	830384.0
2021-07-07 12:30:00	MSFT	Stock	279.725	280.06	279.52	279.985	616549.0

> showing 50 of 110,424 rows — these rows as CSV

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