PREVIEW / stock_30min / 2018-10-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-17.parquet
  size:    1.7 MB
  rows:    83,423
  symbols: 2,758

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-10-17 04:00:00	AAPL	Stock	55.7875	55.9825	55.7875	55.865	21200.0
2018-10-17 04:30:00	AAPL	Stock	55.945	55.9475	55.86	55.86	15184.0
2018-10-17 05:00:00	AAPL	Stock	55.925	55.925	55.8475	55.8475	2408.0
2018-10-17 05:30:00	AAPL	Stock	55.8475	55.8475	55.8375	55.8425	3640.0
2018-10-17 06:00:00	AAPL	Stock	55.7875	55.7875	55.6875	55.69	4792.0
2018-10-17 06:30:00	AAPL	Stock	55.69	55.8	55.69	55.715	58028.0
2018-10-17 07:00:00	AAPL	Stock	55.75	55.795	55.65	55.65	42644.0
2018-10-17 07:30:00	AAPL	Stock	55.65	55.65	55.4625	55.4975	106692.0
2018-10-17 08:00:00	AAPL	Stock	55.525	55.8125	55.3625	55.4625	246328.0
2018-10-17 08:30:00	AAPL	Stock	55.4625	55.56	55.3875	55.55	110628.0
2018-10-17 09:00:00	AAPL	Stock	55.5325	55.645	55.4875	55.5625	170092.0
2018-10-17 09:30:00	AAPL	Stock	55.575	55.65	55.08	55.1425	11950200.0
2018-10-17 10:00:00	AAPL	Stock	55.145	55.29	54.9575	55.2655	7835776.0
2018-10-17 10:30:00	AAPL	Stock	55.265	55.3025	54.835	55.0175	6283124.0
2018-10-17 11:00:00	AAPL	Stock	55.018	55.275	54.9	55.2375	4475920.0
2018-10-17 11:30:00	AAPL	Stock	55.245	55.4	55.04	55.2575	4364908.0
2018-10-17 12:00:00	AAPL	Stock	55.265	55.4625	55.125	55.284	3633940.0
2018-10-17 12:30:00	AAPL	Stock	55.285	55.4638	55.215	55.4168	3057752.0
2018-10-17 13:00:00	AAPL	Stock	55.4162	55.66	55.38	55.4475	3825756.0
2018-10-17 13:30:00	AAPL	Stock	55.4475	55.5528	55.305	55.34	2502216.0
2018-10-17 14:00:00	AAPL	Stock	55.3325	55.465	54.98	55.1	4212672.0
2018-10-17 14:30:00	AAPL	Stock	55.1	55.42	55.0375	55.3562	2869572.0
2018-10-17 15:00:00	AAPL	Stock	55.36	55.425	55.2	55.365	3209044.0
2018-10-17 15:30:00	AAPL	Stock	55.3625	55.3675	55.04	55.3	6456908.0
2018-10-17 16:00:00	AAPL	Stock	55.2975	55.3975	55.275	55.36	8781836.0
2018-10-17 16:30:00	AAPL	Stock	55.35	55.35	55.265	55.325	35356.0
2018-10-17 17:00:00	AAPL	Stock	55.2975	55.345	55.2975	55.325	16440.0
2018-10-17 17:30:00	AAPL	Stock	55.3125	55.3475	55.3125	55.3325	16500.0
2018-10-17 18:00:00	AAPL	Stock	55.3025	55.3025	55.25	55.2575	19168.0
2018-10-17 18:30:00	AAPL	Stock	55.24	55.24	55.1875	55.1875	8276.0
2018-10-17 19:00:00	AAPL	Stock	55.1875	55.1875	55.1375	55.15	5652.0
2018-10-17 19:30:00	AAPL	Stock	55.1625	55.175	55.0	55.125	58084.0
2018-10-17 04:00:00	MSFT	Stock	111.81	111.82	111.81	111.82	400.0
2018-10-17 04:30:00	MSFT	Stock	111.51	111.52	111.47	111.47	1427.0
2018-10-17 05:00:00	MSFT	Stock	111.47	111.47	111.47	111.47	550.0
2018-10-17 06:00:00	MSFT	Stock	111.46	111.46	111.44	111.44	212.0
2018-10-17 06:30:00	MSFT	Stock	111.4	111.47	111.3	111.3	2037.0
2018-10-17 07:00:00	MSFT	Stock	111.5	111.5	111.16	111.26	7419.0
2018-10-17 07:30:00	MSFT	Stock	111.21	111.27	110.85	110.9	15698.0
2018-10-17 08:00:00	MSFT	Stock	111.38	111.69	110.57	110.81	23005.0
2018-10-17 08:30:00	MSFT	Stock	110.81	111.38	110.8	111.38	19004.0
2018-10-17 09:00:00	MSFT	Stock	111.375	111.68	111.0	111.68	22150.0
2018-10-17 09:30:00	MSFT	Stock	111.69	111.81	109.92	110.335	3200000.0
2018-10-17 10:00:00	MSFT	Stock	110.34	110.38	109.82	110.14	1721652.0
2018-10-17 10:30:00	MSFT	Stock	110.14	110.29	109.548	109.84	1640656.0
2018-10-17 11:00:00	MSFT	Stock	109.84	110.535	109.68	110.44	1204566.0
2018-10-17 11:30:00	MSFT	Stock	110.44	110.78	109.98	110.74	1282999.0
2018-10-17 12:00:00	MSFT	Stock	110.75	111.05	110.475	110.588	1086617.0
2018-10-17 12:30:00	MSFT	Stock	110.59	110.77	110.14	110.438	1379085.0
2018-10-17 13:00:00	MSFT	Stock	110.455	111.01	110.455	110.68	1246169.0

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

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