PREVIEW / stock_30min / 2018-08-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-17.parquet
  size:    1.6 MB
  rows:    80,855
  symbols: 2,786

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
2018-08-17 04:00:00	AAPL	Stock	53.375	53.4875	53.375	53.4875	8080.0
2018-08-17 04:30:00	AAPL	Stock	53.4875	53.5	53.4375	53.45	4600.0
2018-08-17 05:00:00	AAPL	Stock	53.425	53.45	53.425	53.425	7408.0
2018-08-17 05:30:00	AAPL	Stock	53.425	53.425	53.28	53.28	12244.0
2018-08-17 06:00:00	AAPL	Stock	53.28	53.3125	53.2725	53.3125	20212.0
2018-08-17 06:30:00	AAPL	Stock	53.3125	53.335	53.3125	53.335	10928.0
2018-08-17 07:00:00	AAPL	Stock	53.3475	53.3775	53.32	53.3475	43532.0
2018-08-17 07:30:00	AAPL	Stock	53.3475	53.3475	53.3	53.3	19792.0
2018-08-17 08:00:00	AAPL	Stock	53.3625	53.375	53.2	53.22	183244.0
2018-08-17 08:30:00	AAPL	Stock	53.225	53.2825	53.225	53.265	93800.0
2018-08-17 09:00:00	AAPL	Stock	53.2725	53.365	53.2375	53.355	138176.0
2018-08-17 09:30:00	AAPL	Stock	53.36	53.8	53.29	53.6725	20963936.0
2018-08-17 10:00:00	AAPL	Stock	53.67	53.6875	53.42	53.605	10263024.0
2018-08-17 10:30:00	AAPL	Stock	53.6075	53.835	53.6075	53.8242	9506028.0
2018-08-17 11:00:00	AAPL	Stock	53.8275	54.06	53.755	54.0125	10291656.0
2018-08-17 11:30:00	AAPL	Stock	54.013	54.42	53.9975	54.325	12206300.0
2018-08-17 12:00:00	AAPL	Stock	54.3292	54.34	54.1175	54.21	8837976.0
2018-08-17 12:30:00	AAPL	Stock	54.2088	54.2168	54.025	54.08	5606328.0
2018-08-17 13:00:00	AAPL	Stock	54.08	54.23	54.0575	54.0745	4527692.0
2018-08-17 13:30:00	AAPL	Stock	54.0725	54.205	54.0625	54.1825	3896132.0
2018-08-17 14:00:00	AAPL	Stock	54.1832	54.3875	54.1675	54.325	7272736.0
2018-08-17 14:30:00	AAPL	Stock	54.3225	54.375	54.22	54.3375	4344892.0
2018-08-17 15:00:00	AAPL	Stock	54.3375	54.3548	54.2355	54.2725	4622980.0
2018-08-17 15:30:00	AAPL	Stock	54.2725	54.4875	54.2675	54.4025	13335480.0
2018-08-17 16:00:00	AAPL	Stock	54.4025	54.4025	54.365	54.365	5100840.0
2018-08-17 16:30:00	AAPL	Stock	54.37	54.4	54.3675	54.3875	105852.0
2018-08-17 17:00:00	AAPL	Stock	54.3825	54.3875	54.375	54.3775	41112.0
2018-08-17 17:30:00	AAPL	Stock	54.3775	54.3775	54.37	54.37	45720.0
2018-08-17 18:00:00	AAPL	Stock	54.375	54.3775	54.37	54.37	26280.0
2018-08-17 18:30:00	AAPL	Stock	54.37	54.37	54.3525	54.3525	34860.0
2018-08-17 19:00:00	AAPL	Stock	54.3575	54.3775	54.3575	54.3775	13096.0
2018-08-17 19:30:00	AAPL	Stock	54.3725	54.3825	54.3725	54.3825	24628.0
2018-08-17 06:30:00	MSFT	Stock	107.5	107.5	107.5	107.5	1504.0
2018-08-17 07:30:00	MSFT	Stock	107.49	107.73	107.49	107.73	539.0
2018-08-17 08:00:00	MSFT	Stock	107.5	107.77	107.33	107.38	11683.0
2018-08-17 08:30:00	MSFT	Stock	107.39	107.58	107.38	107.58	5051.0
2018-08-17 09:00:00	MSFT	Stock	107.585	107.588	107.15	107.34	14922.0
2018-08-17 09:30:00	MSFT	Stock	107.37	107.58	106.95	107.14	3111798.0
2018-08-17 10:00:00	MSFT	Stock	107.12	107.255	106.88	106.89	1186424.0
2018-08-17 10:30:00	MSFT	Stock	106.9	107.06	106.69	106.93	1071378.0
2018-08-17 11:00:00	MSFT	Stock	106.94	107.1	106.78	107.0	890940.0
2018-08-17 11:30:00	MSFT	Stock	107.0	107.24	106.92	107.195	1177065.0
2018-08-17 12:00:00	MSFT	Stock	107.195	107.24	107.07	107.16	509023.0
2018-08-17 12:30:00	MSFT	Stock	107.165	107.17	106.95	106.96	445267.0
2018-08-17 13:00:00	MSFT	Stock	106.95	107.11	106.87	106.88	500480.0
2018-08-17 13:30:00	MSFT	Stock	106.873	107.135	106.87	107.075	563136.0
2018-08-17 14:00:00	MSFT	Stock	107.065	107.72	107.0	107.67	1474146.0
2018-08-17 14:30:00	MSFT	Stock	107.67	107.9	107.52	107.79	769496.0
2018-08-17 15:00:00	MSFT	Stock	107.78	107.82	107.48	107.53	762567.0
2018-08-17 15:30:00	MSFT	Stock	107.53	107.795	107.46	107.58	1919945.0

> showing 50 of 80,855 rows — these rows as CSV

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