PREVIEW / stock_30min / 2020-09-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-18.parquet
  size:    2.0 MB
  rows:    96,807
  symbols: 2,492

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-18 04:00:00	AAPL	Stock	111.0	111.61	110.6	111.45	28178.0
2020-09-18 04:30:00	AAPL	Stock	111.49	111.5	110.8	111.3	13184.0
2020-09-18 05:00:00	AAPL	Stock	111.23	111.52	111.23	111.51	11632.0
2020-09-18 05:30:00	AAPL	Stock	111.52	111.9	111.5	111.5	9925.0
2020-09-18 06:00:00	AAPL	Stock	111.45	111.5	111.31	111.5	9620.0
2020-09-18 06:30:00	AAPL	Stock	111.5	111.7	111.12	111.4	19786.0
2020-09-18 07:00:00	AAPL	Stock	111.42	111.52	110.6	111.5	429479.0
2020-09-18 07:30:00	AAPL	Stock	111.49	111.55	110.72	110.92	287692.0
2020-09-18 08:00:00	AAPL	Stock	110.89	111.54	110.067	110.52	979357.0
2020-09-18 08:30:00	AAPL	Stock	110.57	111.17	110.54	111.02	578435.0
2020-09-18 09:00:00	AAPL	Stock	111.05	111.5	110.38	110.4	965585.0
2020-09-18 09:30:00	AAPL	Stock	110.38	110.88	109.02	109.43	33248152.0
2020-09-18 10:00:00	AAPL	Stock	109.43	110.018	109.085	109.33	10424188.0
2020-09-18 10:30:00	AAPL	Stock	109.34	109.42	108.06	108.18	16034805.0
2020-09-18 11:00:00	AAPL	Stock	108.18	108.43	107.55	107.931	14896054.0
2020-09-18 11:30:00	AAPL	Stock	107.93	108.35	107.2	108.14	13172611.0
2020-09-18 12:00:00	AAPL	Stock	108.14	108.5	107.25	107.57	11668883.0
2020-09-18 12:30:00	AAPL	Stock	107.56	107.65	106.52	106.959	14762254.0
2020-09-18 13:00:00	AAPL	Stock	106.96	107.15	106.2	106.22	11232405.0
2020-09-18 13:30:00	AAPL	Stock	106.22	107.39	106.09	107.315	12052386.0
2020-09-18 14:00:00	AAPL	Stock	107.31	107.74	106.77	107.431	9507946.0
2020-09-18 14:30:00	AAPL	Stock	107.43	107.65	107.09	107.6	7510948.0
2020-09-18 15:00:00	AAPL	Stock	107.61	107.88	107.28	107.698	9440982.0
2020-09-18 15:30:00	AAPL	Stock	107.695	108.1	106.55	106.6	20630246.0
2020-09-18 16:00:00	AAPL	Stock	106.6	107.42	106.5	106.98	62324990.0
2020-09-18 16:30:00	AAPL	Stock	107.0	107.07	106.848	107.02	194996.0
2020-09-18 17:00:00	AAPL	Stock	107.0	107.04	106.84	106.87	211841.0
2020-09-18 17:30:00	AAPL	Stock	106.88	107.0	106.75	107.0	119056.0
2020-09-18 18:00:00	AAPL	Stock	107.0	107.0	106.88	106.9	80690.0
2020-09-18 18:30:00	AAPL	Stock	106.88	106.96	106.88	106.91	56637.0
2020-09-18 19:00:00	AAPL	Stock	106.91	107.0	106.84	106.93	125726.0
2020-09-18 19:30:00	AAPL	Stock	106.94	106.99	106.86	106.93	120094.0
2020-09-18 04:00:00	MSFT	Stock	203.31	204.0	203.31	204.0	1014.0
2020-09-18 04:30:00	MSFT	Stock	203.75	203.75	202.41	203.47	1319.0
2020-09-18 05:00:00	MSFT	Stock	203.95	204.0	203.95	203.99	711.0
2020-09-18 06:00:00	MSFT	Stock	203.45	203.8	203.19	203.8	1466.0
2020-09-18 06:30:00	MSFT	Stock	203.63	203.63	203.37	203.6	997.0
2020-09-18 07:00:00	MSFT	Stock	203.6	204.31	203.4	204.31	13200.0
2020-09-18 07:30:00	MSFT	Stock	204.3	204.4	203.73	204.08	10646.0
2020-09-18 08:00:00	MSFT	Stock	203.71	204.38	203.24	203.88	35170.0
2020-09-18 08:30:00	MSFT	Stock	203.669	204.43	203.669	204.2	39975.0
2020-09-18 09:00:00	MSFT	Stock	204.03	204.71	202.8	202.8	137889.0
2020-09-18 09:30:00	MSFT	Stock	202.8	203.65	201.735	202.33	9926555.0
2020-09-18 10:00:00	MSFT	Stock	202.35	203.1	201.6	201.93	1477531.0
2020-09-18 10:30:00	MSFT	Stock	201.949	202.04	200.49	200.735	2140135.0
2020-09-18 11:00:00	MSFT	Stock	200.735	200.88	199.6	200.1	2147937.0
2020-09-18 11:30:00	MSFT	Stock	200.12	200.49	198.81	200.05	2345915.0
2020-09-18 12:00:00	MSFT	Stock	200.012	200.44	198.76	198.93	1796603.0
2020-09-18 12:30:00	MSFT	Stock	198.95	199.055	197.67	198.405	2346248.0
2020-09-18 13:00:00	MSFT	Stock	198.4	198.6	197.01	197.01	1864446.0

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

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