PREVIEW / stock_30min / 2020-11-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-02.parquet
  size:    1.9 MB
  rows:    97,820
  symbols: 2,536

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-02 04:00:00	AAPL	Stock	109.62	109.65	109.02	109.56	54554.0
2020-11-02 04:30:00	AAPL	Stock	109.56	109.85	109.46	109.64	16965.0
2020-11-02 05:00:00	AAPL	Stock	109.65	109.9	109.59	109.77	9874.0
2020-11-02 05:30:00	AAPL	Stock	109.77	110.1	109.62	110.0	23597.0
2020-11-02 06:00:00	AAPL	Stock	109.99	110.04	109.68	109.83	17195.0
2020-11-02 06:30:00	AAPL	Stock	109.83	109.98	109.5	109.69	25271.0
2020-11-02 07:00:00	AAPL	Stock	109.67	109.87	109.27	109.47	236831.0
2020-11-02 07:30:00	AAPL	Stock	109.49	109.68	109.3	109.5	192269.0
2020-11-02 08:00:00	AAPL	Stock	109.45	109.8	109.22	109.44	568486.0
2020-11-02 08:30:00	AAPL	Stock	109.43	109.45	109.05	109.1	313039.0
2020-11-02 09:00:00	AAPL	Stock	109.11	109.14	108.8	109.12	414795.0
2020-11-02 09:30:00	AAPL	Stock	109.14	110.68	109.11	109.82	16498269.0
2020-11-02 10:00:00	AAPL	Stock	109.83	110.23	109.05	109.81	9842209.0
2020-11-02 10:30:00	AAPL	Stock	109.8	109.85	108.43	108.49	9625365.0
2020-11-02 11:00:00	AAPL	Stock	108.48	108.69	107.77	107.99	8133415.0
2020-11-02 11:30:00	AAPL	Stock	108.0	108.36	107.72	107.915	5690219.0
2020-11-02 12:00:00	AAPL	Stock	107.91	108.6	107.79	108.51	7373525.0
2020-11-02 12:30:00	AAPL	Stock	108.514	108.515	107.8	108.135	5021673.0
2020-11-02 13:00:00	AAPL	Stock	108.14	108.2	107.55	108.04	5449720.0
2020-11-02 13:30:00	AAPL	Stock	108.04	108.25	107.32	107.413	5694002.0
2020-11-02 14:00:00	AAPL	Stock	107.415	107.9	107.36	107.81	5513591.0
2020-11-02 14:30:00	AAPL	Stock	107.805	108.1	107.57	107.832	4997726.0
2020-11-02 15:00:00	AAPL	Stock	107.832	108.338	107.73	108.225	5313225.0
2020-11-02 15:30:00	AAPL	Stock	108.23	108.78	107.78	108.77	11622220.0
2020-11-02 16:00:00	AAPL	Stock	108.77	108.85	108.49	108.56	7321432.0
2020-11-02 16:30:00	AAPL	Stock	108.58	108.77	108.41	108.72	169913.0
2020-11-02 17:00:00	AAPL	Stock	108.7	108.7	108.38	108.43	77141.0
2020-11-02 17:30:00	AAPL	Stock	108.47	108.48	108.25	108.47	48186.0
2020-11-02 18:00:00	AAPL	Stock	108.47	108.74	108.46	108.68	79018.0
2020-11-02 18:30:00	AAPL	Stock	108.68	108.71	108.6	108.61	36798.0
2020-11-02 19:00:00	AAPL	Stock	108.61	108.95	108.58	108.94	71509.0
2020-11-02 19:30:00	AAPL	Stock	108.96	109.18	108.88	109.13	116399.0
2020-11-02 04:00:00	MSFT	Stock	203.7	204.8	203.7	204.78	4579.0
2020-11-02 04:30:00	MSFT	Stock	204.87	205.19	204.82	204.9	3683.0
2020-11-02 05:00:00	MSFT	Stock	205.03	205.14	205.0	205.14	1789.0
2020-11-02 05:30:00	MSFT	Stock	205.06	205.33	204.95	205.24	5460.0
2020-11-02 06:00:00	MSFT	Stock	205.11	205.2	204.9	204.9	4399.0
2020-11-02 06:30:00	MSFT	Stock	204.9	205.15	204.87	204.93	2257.0
2020-11-02 07:00:00	MSFT	Stock	204.93	205.0	204.39	204.7	25116.0
2020-11-02 07:30:00	MSFT	Stock	204.67	204.74	203.72	204.02	22899.0
2020-11-02 08:00:00	MSFT	Stock	204.38	204.99	203.85	204.3	41533.0
2020-11-02 08:30:00	MSFT	Stock	204.4	204.4	203.6	204.1	26550.0
2020-11-02 09:00:00	MSFT	Stock	204.09	204.3	203.66	204.29	29045.0
2020-11-02 09:30:00	MSFT	Stock	204.27	205.28	203.61	204.39	3173192.0
2020-11-02 10:00:00	MSFT	Stock	204.46	204.89	203.5	204.15	1995546.0
2020-11-02 10:30:00	MSFT	Stock	204.112	204.22	202.81	203.07	1490926.0
2020-11-02 11:00:00	MSFT	Stock	203.07	203.3	201.91	202.31	1463246.0
2020-11-02 11:30:00	MSFT	Stock	202.33	202.65	201.75	201.85	1261790.0
2020-11-02 12:00:00	MSFT	Stock	201.87	202.02	201.24	201.95	1338731.0
2020-11-02 12:30:00	MSFT	Stock	201.95	202.006	200.72	201.25	1082360.0

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

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