PREVIEW / stock_30min / 2020-09-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-28.parquet
  size:    1.9 MB
  rows:    98,144
  symbols: 2,507

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
2020-09-28 04:00:00	AAPL	Stock	113.8	114.32	113.7	114.17	49395.0
2020-09-28 04:30:00	AAPL	Stock	114.28	114.42	114.15	114.19	21141.0
2020-09-28 05:00:00	AAPL	Stock	114.2	114.35	114.2	114.3	9199.0
2020-09-28 05:30:00	AAPL	Stock	114.27	114.4	114.2	114.26	21665.0
2020-09-28 06:00:00	AAPL	Stock	114.21	114.8	114.18	114.64	95682.0
2020-09-28 06:30:00	AAPL	Stock	114.64	114.9	114.58	114.7	41641.0
2020-09-28 07:00:00	AAPL	Stock	114.6	115.1	114.35	114.94	522992.0
2020-09-28 07:30:00	AAPL	Stock	114.94	115.45	114.93	115.4	299232.0
2020-09-28 08:00:00	AAPL	Stock	115.41	115.5	114.35	115.21	909906.0
2020-09-28 08:30:00	AAPL	Stock	115.25	115.47	115.07	115.15	335196.0
2020-09-28 09:00:00	AAPL	Stock	115.16	115.25	114.67	114.91	661059.0
2020-09-28 09:30:00	AAPL	Stock	114.93	115.32	112.96	113.487	20740411.0
2020-09-28 10:00:00	AAPL	Stock	113.49	113.89	112.78	113.53	11219323.0
2020-09-28 10:30:00	AAPL	Stock	113.53	113.73	112.82	112.9	8227111.0
2020-09-28 11:00:00	AAPL	Stock	112.908	113.68	112.9	113.555	6991403.0
2020-09-28 11:30:00	AAPL	Stock	113.555	113.85	113.23	113.67	6167392.0
2020-09-28 12:00:00	AAPL	Stock	113.67	113.69	113.13	113.35	4993425.0
2020-09-28 12:30:00	AAPL	Stock	113.35	113.97	113.264	113.91	5505150.0
2020-09-28 13:00:00	AAPL	Stock	113.914	114.4	113.64	114.247	6497455.0
2020-09-28 13:30:00	AAPL	Stock	114.25	114.72	114.25	114.565	7371885.0
2020-09-28 14:00:00	AAPL	Stock	114.56	114.68	113.81	114.12	6814470.0
2020-09-28 14:30:00	AAPL	Stock	114.13	114.43	114.02	114.335	5341492.0
2020-09-28 15:00:00	AAPL	Stock	114.34	114.77	114.17	114.727	7260746.0
2020-09-28 15:30:00	AAPL	Stock	114.72	115.0	114.16	115.0	14964260.0
2020-09-28 16:00:00	AAPL	Stock	115.0	115.37	113.35	115.09	9782205.0
2020-09-28 16:30:00	AAPL	Stock	115.1	115.32	115.1	115.18	188714.0
2020-09-28 17:00:00	AAPL	Stock	115.19	115.2	114.91	114.92	110983.0
2020-09-28 17:30:00	AAPL	Stock	114.93	115.06	114.92	114.98	78423.0
2020-09-28 18:00:00	AAPL	Stock	115.0	115.2	115.0	115.12	90776.0
2020-09-28 18:30:00	AAPL	Stock	115.12	115.25	115.1	115.18	69322.0
2020-09-28 19:00:00	AAPL	Stock	115.18	115.38	115.17	115.36	76291.0
2020-09-28 19:30:00	AAPL	Stock	115.36	115.5	115.28	115.5	134178.0
2020-09-28 04:00:00	MSFT	Stock	209.48	209.58	209.27	209.3	1257.0
2020-09-28 04:30:00	MSFT	Stock	209.54	209.55	209.16	209.16	4985.0
2020-09-28 05:00:00	MSFT	Stock	209.16	209.26	209.16	209.26	375.0
2020-09-28 05:30:00	MSFT	Stock	209.47	209.58	209.46	209.57	3406.0
2020-09-28 06:00:00	MSFT	Stock	209.57	210.89	209.57	210.69	39365.0
2020-09-28 06:30:00	MSFT	Stock	210.53	211.2	210.53	210.96	18616.0
2020-09-28 07:00:00	MSFT	Stock	210.52	210.94	210.15	210.85	34563.0
2020-09-28 07:30:00	MSFT	Stock	210.63	211.3	210.5	211.3	28156.0
2020-09-28 08:00:00	MSFT	Stock	210.5	211.94	210.1	211.6	57646.0
2020-09-28 08:30:00	MSFT	Stock	211.5	212.0	211.32	211.46	26544.0
2020-09-28 09:00:00	MSFT	Stock	211.44	211.7	210.22	210.6	87775.0
2020-09-28 09:30:00	MSFT	Stock	210.75	212.57	209.61	209.75	4579114.0
2020-09-28 10:00:00	MSFT	Stock	209.755	210.38	209.16	209.72	1751236.0
2020-09-28 10:30:00	MSFT	Stock	209.72	209.72	208.06	208.55	1780340.0
2020-09-28 11:00:00	MSFT	Stock	208.56	209.73	208.32	209.6	1418762.0
2020-09-28 11:30:00	MSFT	Stock	209.605	209.93	208.91	209.155	982007.0
2020-09-28 12:00:00	MSFT	Stock	209.18	209.19	208.3	208.645	889213.0
2020-09-28 12:30:00	MSFT	Stock	208.635	209.29	208.44	209.29	852428.0

> showing 50 of 98,144 rows — these rows as CSV

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