PREVIEW / stock_30min / 2020-11-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-03.parquet
  size:    1.9 MB
  rows:    97,368
  symbols: 2,532

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-11-03 04:00:00	AAPL	Stock	109.54	109.9	109.49	109.64	23084.0
2020-11-03 04:30:00	AAPL	Stock	109.66	109.87	109.41	109.41	19317.0
2020-11-03 05:00:00	AAPL	Stock	109.43	109.85	109.27	109.85	10917.0
2020-11-03 05:30:00	AAPL	Stock	109.88	109.92	109.33	109.37	16078.0
2020-11-03 06:00:00	AAPL	Stock	109.36	109.59	109.17	109.29	26008.0
2020-11-03 06:30:00	AAPL	Stock	109.34	109.34	108.74	109.28	34634.0
2020-11-03 07:00:00	AAPL	Stock	109.29	109.58	109.22	109.28	104091.0
2020-11-03 07:30:00	AAPL	Stock	109.29	109.56	109.19	109.23	72632.0
2020-11-03 08:00:00	AAPL	Stock	109.25	109.57	109.16	109.39	305529.0
2020-11-03 08:30:00	AAPL	Stock	109.35	109.57	109.28	109.3	164203.0
2020-11-03 09:00:00	AAPL	Stock	109.3	109.65	109.18	109.62	261205.0
2020-11-03 09:30:00	AAPL	Stock	109.66	109.94	108.73	109.88	12604939.0
2020-11-03 10:00:00	AAPL	Stock	109.89	111.08	109.785	110.685	11381394.0
2020-11-03 10:30:00	AAPL	Stock	110.685	111.21	110.4	111.19	7625010.0
2020-11-03 11:00:00	AAPL	Stock	111.2	111.39	110.68	110.882	6390161.0
2020-11-03 11:30:00	AAPL	Stock	110.89	111.45	110.8	110.905	6176463.0
2020-11-03 12:00:00	AAPL	Stock	110.91	111.07	110.53	111.035	5090928.0
2020-11-03 12:30:00	AAPL	Stock	111.04	111.06	110.6	110.719	3502937.0
2020-11-03 13:00:00	AAPL	Stock	110.71	110.915	110.43	110.54	3534388.0
2020-11-03 13:30:00	AAPL	Stock	110.53	110.68	109.76	109.85	5553717.0
2020-11-03 14:00:00	AAPL	Stock	109.85	110.34	109.8	110.08	5042717.0
2020-11-03 14:30:00	AAPL	Stock	110.09	110.47	109.976	110.366	4065342.0
2020-11-03 15:00:00	AAPL	Stock	110.369	110.86	109.99	110.855	5460154.0
2020-11-03 15:30:00	AAPL	Stock	110.86	111.49	110.31	110.375	12877511.0
2020-11-03 16:00:00	AAPL	Stock	110.44	110.451	110.08	110.18	7845117.0
2020-11-03 16:30:00	AAPL	Stock	110.18	110.3	110.11	110.25	131308.0
2020-11-03 17:00:00	AAPL	Stock	110.26	110.3	110.18	110.28	61590.0
2020-11-03 17:30:00	AAPL	Stock	110.29	110.44	110.24	110.39	48987.0
2020-11-03 18:00:00	AAPL	Stock	110.38	110.89	110.26	110.74	149435.0
2020-11-03 18:30:00	AAPL	Stock	110.78	110.9	110.74	110.81	113497.0
2020-11-03 19:00:00	AAPL	Stock	110.8	111.04	110.62	110.85	158363.0
2020-11-03 19:30:00	AAPL	Stock	110.86	110.95	110.2	110.25	197286.0
2020-11-03 04:00:00	MSFT	Stock	204.07	204.36	203.9	203.9	1416.0
2020-11-03 04:30:00	MSFT	Stock	203.9	203.98	203.26	203.26	3431.0
2020-11-03 05:00:00	MSFT	Stock	203.42	203.91	203.24	203.91	1138.0
2020-11-03 05:30:00	MSFT	Stock	204.16	204.16	203.36	203.37	3393.0
2020-11-03 06:00:00	MSFT	Stock	203.33	203.48	203.0	203.0	3617.0
2020-11-03 06:30:00	MSFT	Stock	203.04	203.04	202.52	202.97	12544.0
2020-11-03 07:00:00	MSFT	Stock	203.18	203.5	203.0	203.16	19723.0
2020-11-03 07:30:00	MSFT	Stock	203.3	203.35	203.0	203.15	6745.0
2020-11-03 08:00:00	MSFT	Stock	203.5	203.5	202.64	203.3	25550.0
2020-11-03 08:30:00	MSFT	Stock	203.39	203.95	203.3	203.5	10148.0
2020-11-03 09:00:00	MSFT	Stock	203.481	203.69	203.31	203.69	21392.0
2020-11-03 09:30:00	MSFT	Stock	203.7	205.395	203.12	205.35	2285086.0
2020-11-03 10:00:00	MSFT	Stock	205.39	207.93	205.18	207.619	2215067.0
2020-11-03 10:30:00	MSFT	Stock	207.62	207.95	206.64	207.88	1511754.0
2020-11-03 11:00:00	MSFT	Stock	207.89	208.12	207.073	207.65	1209634.0
2020-11-03 11:30:00	MSFT	Stock	207.69	208.06	207.21	207.44	1167965.0
2020-11-03 12:00:00	MSFT	Stock	207.46	207.64	206.65	207.41	843960.0
2020-11-03 12:30:00	MSFT	Stock	207.4	207.45	206.78	207.045	717025.0

> showing 50 of 97,368 rows — these rows as CSV

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