PREVIEW / stock_30min / 2018-07-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-18.parquet
  size:    1.7 MB
  rows:    82,782
  symbols: 2,824

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-07-18 04:00:00	AAPL	Stock	48.0125	48.0125	47.9875	48.0	27004.0
2018-07-18 04:30:00	AAPL	Stock	48.0	48.0375	47.9875	48.0375	10592.0
2018-07-18 05:00:00	AAPL	Stock	48.0475	48.0525	48.04	48.0525	1356.0
2018-07-18 05:30:00	AAPL	Stock	48.05	48.1	48.05	48.1	2800.0
2018-07-18 06:00:00	AAPL	Stock	48.0975	48.0975	48.0625	48.09	3516.0
2018-07-18 06:30:00	AAPL	Stock	48.05	48.075	48.05	48.075	5148.0
2018-07-18 07:00:00	AAPL	Stock	48.045	48.0525	48.0025	48.0025	32952.0
2018-07-18 07:30:00	AAPL	Stock	48.0025	48.0625	48.0	48.025	49268.0
2018-07-18 08:00:00	AAPL	Stock	48.05	48.06	47.95	48.0	130316.0
2018-07-18 08:30:00	AAPL	Stock	48.0	48.0375	47.9975	48.0375	58324.0
2018-07-18 09:00:00	AAPL	Stock	48.0375	48.05	47.9375	47.9375	196840.0
2018-07-18 09:30:00	AAPL	Stock	47.945	47.95	47.5505	47.595	10612804.0
2018-07-18 10:00:00	AAPL	Stock	47.5925	47.6492	47.4825	47.5475	5219312.0
2018-07-18 10:30:00	AAPL	Stock	47.545	47.61	47.4875	47.555	3479728.0
2018-07-18 11:00:00	AAPL	Stock	47.555	47.63	47.5175	47.5825	2840252.0
2018-07-18 11:30:00	AAPL	Stock	47.5825	47.625	47.545	47.5985	2080524.0
2018-07-18 12:00:00	AAPL	Stock	47.6	47.6025	47.49	47.5338	2206464.0
2018-07-18 12:30:00	AAPL	Stock	47.5325	47.579	47.5	47.55	1726660.0
2018-07-18 13:00:00	AAPL	Stock	47.5488	47.5775	47.525	47.5625	1712292.0
2018-07-18 13:30:00	AAPL	Stock	47.5625	47.5875	47.51	47.5675	1378424.0
2018-07-18 14:00:00	AAPL	Stock	47.5675	47.6112	47.5575	47.605	1540252.0
2018-07-18 14:30:00	AAPL	Stock	47.605	47.6075	47.5325	47.5588	1442272.0
2018-07-18 15:00:00	AAPL	Stock	47.56	47.6375	47.5425	47.6075	1987164.0
2018-07-18 15:30:00	AAPL	Stock	47.6075	47.6675	47.565	47.6	6157964.0
2018-07-18 16:00:00	AAPL	Stock	47.6	47.6	47.5468	47.575	11109824.0
2018-07-18 16:30:00	AAPL	Stock	47.575	47.6	47.5625	47.5625	21860.0
2018-07-18 17:00:00	AAPL	Stock	47.575	47.595	47.575	47.595	2620.0
2018-07-18 17:30:00	AAPL	Stock	47.6	47.6	47.5675	47.58	16332.0
2018-07-18 18:00:00	AAPL	Stock	47.57	47.58	47.57	47.575	2396.0
2018-07-18 18:30:00	AAPL	Stock	47.585	47.595	47.585	47.585	34812.0
2018-07-18 19:00:00	AAPL	Stock	47.585	47.6225	47.585	47.6225	12764.0
2018-07-18 19:30:00	AAPL	Stock	47.6225	47.635	47.6125	47.6325	37196.0
2018-07-18 04:30:00	MSFT	Stock	106.31	106.32	106.3	106.32	2103.0
2018-07-18 05:00:00	MSFT	Stock	106.32	106.37	106.32	106.37	629.0
2018-07-18 05:30:00	MSFT	Stock	106.37	106.37	106.33	106.33	749.0
2018-07-18 06:00:00	MSFT	Stock	106.35	106.38	106.28	106.28	5308.0
2018-07-18 06:30:00	MSFT	Stock	106.1	106.2	106.1	106.2	733.0
2018-07-18 07:00:00	MSFT	Stock	106.28	106.34	106.24	106.25	7661.0
2018-07-18 07:30:00	MSFT	Stock	106.12	106.25	106.05	106.24	8092.0
2018-07-18 08:00:00	MSFT	Stock	106.28	106.34	105.86	106.05	29595.0
2018-07-18 08:30:00	MSFT	Stock	106.0	106.15	105.99	106.12	5711.0
2018-07-18 09:00:00	MSFT	Stock	106.1	106.34	105.85	105.93	31372.0
2018-07-18 09:30:00	MSFT	Stock	105.89	106.05	104.715	105.02	4857446.0
2018-07-18 10:00:00	MSFT	Stock	105.03	105.27	104.982	105.11	1999795.0
2018-07-18 10:30:00	MSFT	Stock	105.1	105.14	104.91	105.05	1483606.0
2018-07-18 11:00:00	MSFT	Stock	105.06	105.365	105.005	105.32	1494274.0
2018-07-18 11:30:00	MSFT	Stock	105.32	105.41	105.185	105.225	1176226.0
2018-07-18 12:00:00	MSFT	Stock	105.22	105.25	104.93	105.045	1466998.0
2018-07-18 12:30:00	MSFT	Stock	105.05	105.1	104.95	105.01	1015873.0
2018-07-18 13:00:00	MSFT	Stock	105.01	105.1	104.96	105.043	834434.0

> showing 50 of 82,782 rows — these rows as CSV

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