PREVIEW / stock_30min / 2020-10-30

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-30.parquet
  size:    1.9 MB
  rows:    96,739
  symbols: 2,516

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-10-30 04:00:00	AAPL	Stock	109.82	109.89	108.7	109.57	104046.0
2020-10-30 04:30:00	AAPL	Stock	109.59	109.86	109.19	109.8	46367.0
2020-10-30 05:00:00	AAPL	Stock	109.78	110.4	109.5	110.37	46674.0
2020-10-30 05:30:00	AAPL	Stock	110.4	110.64	110.07	110.51	35491.0
2020-10-30 06:00:00	AAPL	Stock	110.45	111.13	110.1	110.78	84022.0
2020-10-30 06:30:00	AAPL	Stock	110.82	111.28	110.62	111.05	69528.0
2020-10-30 07:00:00	AAPL	Stock	111.06	111.12	110.65	110.68	293916.0
2020-10-30 07:30:00	AAPL	Stock	110.68	110.75	110.5	110.73	140772.0
2020-10-30 08:00:00	AAPL	Stock	110.95	111.1	110.15	110.8	695060.0
2020-10-30 08:30:00	AAPL	Stock	110.81	111.4	110.58	110.96	540128.0
2020-10-30 09:00:00	AAPL	Stock	110.9	111.95	110.35	111.05	742211.0
2020-10-30 09:30:00	AAPL	Stock	111.03	111.99	108.85	109.698	28645190.0
2020-10-30 10:00:00	AAPL	Stock	109.69	110.44	108.3	108.97	16909663.0
2020-10-30 10:30:00	AAPL	Stock	108.965	109.514	108.47	108.57	12419186.0
2020-10-30 11:00:00	AAPL	Stock	108.57	109.852	108.55	109.26	10258717.0
2020-10-30 11:30:00	AAPL	Stock	109.25	109.47	108.71	108.77	7923786.0
2020-10-30 12:00:00	AAPL	Stock	108.77	109.97	108.7	109.479	8417413.0
2020-10-30 12:30:00	AAPL	Stock	109.47	109.48	108.77	108.889	6797197.0
2020-10-30 13:00:00	AAPL	Stock	108.88	109.19	108.5	108.85	7077702.0
2020-10-30 13:30:00	AAPL	Stock	108.856	108.856	108.1	108.35	8096952.0
2020-10-30 14:00:00	AAPL	Stock	108.34	108.79	108.15	108.235	6484246.0
2020-10-30 14:30:00	AAPL	Stock	108.23	108.61	108.0	108.15	7843208.0
2020-10-30 15:00:00	AAPL	Stock	108.14	108.68	107.72	108.103	12561304.0
2020-10-30 15:30:00	AAPL	Stock	108.104	109.3	107.85	108.9	18223271.0
2020-10-30 16:00:00	AAPL	Stock	109.0	109.15	108.81	109.01	14822276.0
2020-10-30 16:30:00	AAPL	Stock	109.01	109.15	108.98	109.07	241541.0
2020-10-30 17:00:00	AAPL	Stock	109.03	109.05	108.89	108.89	87977.0
2020-10-30 17:30:00	AAPL	Stock	108.9	108.95	108.5	108.86	79261.0
2020-10-30 18:00:00	AAPL	Stock	108.86	108.93	108.79	108.79	63347.0
2020-10-30 18:30:00	AAPL	Stock	108.79	108.86	108.75	108.76	63643.0
2020-10-30 19:00:00	AAPL	Stock	108.76	108.79	108.58	108.6	42942.0
2020-10-30 19:30:00	AAPL	Stock	108.58	108.61	108.5	108.51	114332.0
2020-10-30 04:00:00	MSFT	Stock	201.8	202.0	200.62	200.64	13288.0
2020-10-30 04:30:00	MSFT	Stock	200.53	201.0	200.05	200.49	9785.0
2020-10-30 05:00:00	MSFT	Stock	200.77	201.0	200.54	201.0	4203.0
2020-10-30 05:30:00	MSFT	Stock	200.97	201.79	200.81	201.7	8196.0
2020-10-30 06:00:00	MSFT	Stock	201.94	202.4	201.22	201.75	5956.0
2020-10-30 06:30:00	MSFT	Stock	201.82	202.85	201.61	202.85	6625.0
2020-10-30 07:00:00	MSFT	Stock	202.54	202.82	202.33	202.55	9663.0
2020-10-30 07:30:00	MSFT	Stock	202.58	202.79	202.48	202.79	8612.0
2020-10-30 08:00:00	MSFT	Stock	202.71	202.878	201.8	202.017	45045.0
2020-10-30 08:30:00	MSFT	Stock	202.06	203.3	201.9	202.72	43598.0
2020-10-30 09:00:00	MSFT	Stock	202.8	203.5	202.56	203.44	27079.0
2020-10-30 09:30:00	MSFT	Stock	203.47	204.29	202.89	203.17	2631921.0
2020-10-30 10:00:00	MSFT	Stock	203.1	203.2	200.75	200.93	2097407.0
2020-10-30 10:30:00	MSFT	Stock	200.92	201.24	199.76	199.77	2711750.0
2020-10-30 11:00:00	MSFT	Stock	199.77	200.93	199.77	200.01	1916332.0
2020-10-30 11:30:00	MSFT	Stock	200.01	200.67	199.62	200.515	1696118.0
2020-10-30 12:00:00	MSFT	Stock	200.5	202.44	200.32	202.28	1410951.0
2020-10-30 12:30:00	MSFT	Stock	202.28	202.32	201.13	201.545	1055079.0

> showing 50 of 96,739 rows — these rows as CSV

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