PREVIEW / stock_30min / 2018-07-31

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-31.parquet
  size:    1.7 MB
  rows:    83,218
  symbols: 2,818

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-31 04:00:00	AAPL	Stock	47.5825	47.5825	47.58	47.58	2976.0
2018-07-31 04:30:00	AAPL	Stock	47.5425	47.5475	47.5425	47.5475	6800.0
2018-07-31 05:00:00	AAPL	Stock	47.5525	47.57	47.55	47.55	9600.0
2018-07-31 05:30:00	AAPL	Stock	47.5375	47.5375	47.515	47.5375	28120.0
2018-07-31 06:00:00	AAPL	Stock	47.5225	47.55	47.5225	47.55	5780.0
2018-07-31 06:30:00	AAPL	Stock	47.56	47.5625	47.5375	47.56	24696.0
2018-07-31 07:00:00	AAPL	Stock	47.5525	47.6475	47.54	47.6475	116560.0
2018-07-31 07:30:00	AAPL	Stock	47.65	47.7125	47.6375	47.7075	53220.0
2018-07-31 08:00:00	AAPL	Stock	47.7025	47.7082	47.5538	47.6475	97916.0
2018-07-31 08:30:00	AAPL	Stock	47.655	47.6925	47.575	47.6025	164304.0
2018-07-31 09:00:00	AAPL	Stock	47.61	47.7675	47.4775	47.5875	427316.0
2018-07-31 09:30:00	AAPL	Stock	47.585	47.7525	47.4775	47.5522	11374428.0
2018-07-31 10:00:00	AAPL	Stock	47.55	47.5975	47.3625	47.3625	7787628.0
2018-07-31 10:30:00	AAPL	Stock	47.365	47.49	47.335	47.4175	5436068.0
2018-07-31 11:00:00	AAPL	Stock	47.415	47.555	47.4125	47.5025	5029800.0
2018-07-31 11:30:00	AAPL	Stock	47.505	47.6375	47.4975	47.635	5113308.0
2018-07-31 12:00:00	AAPL	Stock	47.6375	47.99	47.6375	47.9725	9224544.0
2018-07-31 12:30:00	AAPL	Stock	47.974	48.035	47.8825	47.9075	6533796.0
2018-07-31 13:00:00	AAPL	Stock	47.91	47.9915	47.7512	47.8475	7686708.0
2018-07-31 13:30:00	AAPL	Stock	47.8475	47.89	47.74	47.835	4371612.0
2018-07-31 14:00:00	AAPL	Stock	47.8375	47.8475	47.7225	47.8125	4233216.0
2018-07-31 14:30:00	AAPL	Stock	47.8082	47.9675	47.8	47.895	5207472.0
2018-07-31 15:00:00	AAPL	Stock	47.895	47.8975	47.7525	47.7725	5900632.0
2018-07-31 15:30:00	AAPL	Stock	47.775	47.8525	47.5875	47.645	17802348.0
2018-07-31 16:00:00	AAPL	Stock	47.655	47.9175	47.4775	47.75	11616736.0
2018-07-31 16:30:00	AAPL	Stock	47.9025	49.1625	47.7075	48.925	16158992.0
2018-07-31 17:00:00	AAPL	Stock	48.93	49.4325	48.012	49.2225	5496208.0
2018-07-31 17:30:00	AAPL	Stock	49.2175	49.35	49.1375	49.25	1404188.0
2018-07-31 18:00:00	AAPL	Stock	49.25	49.5	49.1975	49.4225	1561164.0
2018-07-31 18:30:00	AAPL	Stock	49.4225	49.46	49.2075	49.2975	1017288.0
2018-07-31 19:00:00	AAPL	Stock	49.2875	49.3625	49.2475	49.25	397492.0
2018-07-31 19:30:00	AAPL	Stock	49.2275	49.5	49.2275	49.4875	951604.0
2018-07-31 04:00:00	MSFT	Stock	106.0	106.25	105.93	105.97	6269.0
2018-07-31 05:00:00	MSFT	Stock	105.87	105.87	105.7	105.78	1641.0
2018-07-31 05:30:00	MSFT	Stock	105.78	105.86	105.78	105.86	2330.0
2018-07-31 06:30:00	MSFT	Stock	105.63	105.94	105.57	105.94	3330.0
2018-07-31 07:00:00	MSFT	Stock	105.92	105.95	105.7	105.8	4970.0
2018-07-31 07:30:00	MSFT	Stock	105.88	105.9	105.85	105.9	1747.0
2018-07-31 08:00:00	MSFT	Stock	105.8	106.04	105.8	105.95	37213.0
2018-07-31 08:30:00	MSFT	Stock	105.95	106.01	105.73	105.73	28443.0
2018-07-31 09:00:00	MSFT	Stock	105.73	106.6	105.7	106.49	263573.0
2018-07-31 09:30:00	MSFT	Stock	106.53	106.7	105.7	105.77	3866403.0
2018-07-31 10:00:00	MSFT	Stock	105.765	106.05	105.38	105.84	2303869.0
2018-07-31 10:30:00	MSFT	Stock	105.835	106.07	105.68	105.72	1401593.0
2018-07-31 11:00:00	MSFT	Stock	105.71	106.26	105.69	106.14	1259392.0
2018-07-31 11:30:00	MSFT	Stock	106.15	106.495	105.98	106.385	1339036.0
2018-07-31 12:00:00	MSFT	Stock	106.385	106.72	106.38	106.61	1085619.0
2018-07-31 12:30:00	MSFT	Stock	106.6	106.61	106.24	106.38	763231.0
2018-07-31 13:00:00	MSFT	Stock	106.38	106.45	106.17	106.215	707250.0
2018-07-31 13:30:00	MSFT	Stock	106.22	106.48	106.105	106.45	731679.0

> showing 50 of 83,218 rows — these rows as CSV

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