PREVIEW / stock_30min / 2018-12-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-04.parquet
  size:    1.7 MB
  rows:    85,070
  symbols: 2,754

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-12-04 04:00:00	AAPL	Stock	45.4625	45.535	45.39	45.4375	24948.0
2018-12-04 04:30:00	AAPL	Stock	45.43	45.4375	45.27	45.2775	6476.0
2018-12-04 05:00:00	AAPL	Stock	45.3375	45.405	45.32	45.405	2856.0
2018-12-04 05:30:00	AAPL	Stock	45.4375	45.5	45.4375	45.4875	11328.0
2018-12-04 06:00:00	AAPL	Stock	45.4575	45.57	45.4525	45.475	16200.0
2018-12-04 06:30:00	AAPL	Stock	45.4375	45.4975	45.4125	45.4125	20128.0
2018-12-04 07:00:00	AAPL	Stock	45.38	45.4375	45.2625	45.305	159684.0
2018-12-04 07:30:00	AAPL	Stock	45.3225	45.3425	45.2875	45.325	150076.0
2018-12-04 08:00:00	AAPL	Stock	45.3875	45.4425	45.175	45.29	636380.0
2018-12-04 08:30:00	AAPL	Stock	45.275	45.37	45.22	45.365	303696.0
2018-12-04 09:00:00	AAPL	Stock	45.36	45.3875	45.1875	45.2375	529884.0
2018-12-04 09:30:00	AAPL	Stock	45.2375	45.5	45.1375	45.3275	16019200.0
2018-12-04 10:00:00	AAPL	Stock	45.325	45.5975	45.255	45.3625	9920168.0
2018-12-04 10:30:00	AAPL	Stock	45.3575	45.5025	45.3275	45.3475	5563492.0
2018-12-04 11:00:00	AAPL	Stock	45.3425	45.45	45.205	45.246	6697664.0
2018-12-04 11:30:00	AAPL	Stock	45.2475	45.25	45.1025	45.1275	6752412.0
2018-12-04 12:00:00	AAPL	Stock	45.125	45.1568	44.56	44.565	13512468.0
2018-12-04 12:30:00	AAPL	Stock	44.5585	44.6275	44.3475	44.4375	9791944.0
2018-12-04 13:00:00	AAPL	Stock	44.4325	44.5568	44.1925	44.335	7974292.0
2018-12-04 13:30:00	AAPL	Stock	44.33	44.467	44.11	44.3875	8964120.0
2018-12-04 14:00:00	AAPL	Stock	44.3825	44.5475	44.2775	44.305	6846128.0
2018-12-04 14:30:00	AAPL	Stock	44.3075	44.57	44.2975	44.3975	6560240.0
2018-12-04 15:00:00	AAPL	Stock	44.3875	44.435	44.215	44.2612	8121248.0
2018-12-04 15:30:00	AAPL	Stock	44.265	44.345	44.0675	44.1775	19043688.0
2018-12-04 16:00:00	AAPL	Stock	44.1775	44.23	44.1	44.1075	16544568.0
2018-12-04 16:30:00	AAPL	Stock	44.1075	44.1725	44.075	44.1225	216252.0
2018-12-04 17:00:00	AAPL	Stock	44.1225	44.1225	44.0675	44.0775	51840.0
2018-12-04 17:30:00	AAPL	Stock	44.0775	44.0875	43.9625	43.9675	130608.0
2018-12-04 18:00:00	AAPL	Stock	44.0	44.11	43.9925	44.09	45888.0
2018-12-04 18:30:00	AAPL	Stock	44.0875	44.1225	44.025	44.0975	80184.0
2018-12-04 19:00:00	AAPL	Stock	44.1	44.2175	44.0625	44.1975	208628.0
2018-12-04 19:30:00	AAPL	Stock	44.1575	44.18	44.125	44.125	83248.0
2018-12-04 04:00:00	MSFT	Stock	111.4	111.4	111.02	111.02	658.0
2018-12-04 05:30:00	MSFT	Stock	111.5	111.5	111.5	111.5	100.0
2018-12-04 07:00:00	MSFT	Stock	111.46	111.46	111.32	111.35	4041.0
2018-12-04 07:30:00	MSFT	Stock	111.37	111.76	111.35	111.76	2932.0
2018-12-04 08:00:00	MSFT	Stock	111.32	111.76	111.32	111.7	8369.0
2018-12-04 08:30:00	MSFT	Stock	111.634	111.98	111.59	111.98	11869.0
2018-12-04 09:00:00	MSFT	Stock	111.87	111.93	111.71	111.93	23947.0
2018-12-04 09:30:00	MSFT	Stock	111.94	112.11	111.2	112.024	3056124.0
2018-12-04 10:00:00	MSFT	Stock	112.03	112.637	111.98	112.62	2247842.0
2018-12-04 10:30:00	MSFT	Stock	112.615	112.615	112.0	112.2	1638950.0
2018-12-04 11:00:00	MSFT	Stock	112.19	112.395	111.88	111.98	1509182.0
2018-12-04 11:30:00	MSFT	Stock	111.98	112.055	111.62	111.675	1241998.0
2018-12-04 12:00:00	MSFT	Stock	111.67	111.67	110.16	110.16	2654941.0
2018-12-04 12:30:00	MSFT	Stock	110.14	110.49	109.51	110.0	2749991.0
2018-12-04 13:00:00	MSFT	Stock	110.0	110.19	109.13	109.465	1848349.0
2018-12-04 13:30:00	MSFT	Stock	109.46	109.8	108.61	109.715	2770962.0
2018-12-04 14:00:00	MSFT	Stock	109.715	110.07	109.35	109.48	2257381.0
2018-12-04 14:30:00	MSFT	Stock	109.48	110.2	109.47	109.76	1898305.0

> showing 50 of 85,070 rows — these rows as CSV

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