PREVIEW / stock_30min / 2017-10-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-17.parquet
  size:    1.6 MB
  rows:    81,870
  symbols: 2,950

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
2017-10-17 04:00:00	AAPL	Stock	39.99	39.99	39.9075	39.9075	2264.0
2017-10-17 05:00:00	AAPL	Stock	39.9025	39.9025	39.89	39.89	4512.0
2017-10-17 06:00:00	AAPL	Stock	39.9125	39.9525	39.91	39.91	16472.0
2017-10-17 06:30:00	AAPL	Stock	39.95	39.95	39.95	39.95	2220.0
2017-10-17 07:00:00	AAPL	Stock	39.95	39.95	39.8875	39.8875	23536.0
2017-10-17 07:30:00	AAPL	Stock	39.89	39.935	39.89	39.9325	14836.0
2017-10-17 08:00:00	AAPL	Stock	39.95	40.06	39.89	39.9175	70680.0
2017-10-17 08:30:00	AAPL	Stock	39.935	39.945	39.9125	39.94	56284.0
2017-10-17 09:00:00	AAPL	Stock	39.94	39.97	39.9275	39.9475	165116.0
2017-10-17 09:30:00	AAPL	Stock	39.9375	40.05	39.8075	39.895	12121376.0
2017-10-17 10:00:00	AAPL	Stock	39.8925	39.94	39.8325	39.8675	5402420.0
2017-10-17 10:30:00	AAPL	Stock	39.8675	39.9852	39.8575	39.965	3981760.0
2017-10-17 11:00:00	AAPL	Stock	39.9625	40.2175	39.9625	40.0875	10792120.0
2017-10-17 11:30:00	AAPL	Stock	40.0875	40.1062	39.935	39.9745	6115220.0
2017-10-17 12:00:00	AAPL	Stock	39.975	40.005	39.9425	39.975	3050260.0
2017-10-17 12:30:00	AAPL	Stock	39.975	39.9938	39.9175	39.94	2290388.0
2017-10-17 13:00:00	AAPL	Stock	39.9405	40.0475	39.93	40.0345	2330024.0
2017-10-17 13:30:00	AAPL	Stock	40.035	40.125	40.0075	40.0088	4331344.0
2017-10-17 14:00:00	AAPL	Stock	40.0088	40.0875	40.0025	40.0525	2275884.0
2017-10-17 14:30:00	AAPL	Stock	40.0525	40.0725	40.0325	40.0522	2279636.0
2017-10-17 15:00:00	AAPL	Stock	40.0525	40.07	40.0275	40.045	2259316.0
2017-10-17 15:30:00	AAPL	Stock	40.0475	40.135	40.0475	40.1175	7015600.0
2017-10-17 16:00:00	AAPL	Stock	40.1175	40.1218	40.0925	40.1125	4274576.0
2017-10-17 16:30:00	AAPL	Stock	40.1175	40.1475	40.095	40.1175	276276.0
2017-10-17 17:00:00	AAPL	Stock	40.1	40.13	40.095	40.13	14048.0
2017-10-17 17:30:00	AAPL	Stock	40.1325	40.1325	40.1275	40.1325	23044.0
2017-10-17 18:00:00	AAPL	Stock	40.125	40.135	40.1	40.1125	11856.0
2017-10-17 18:30:00	AAPL	Stock	40.1175	40.125	40.1175	40.1175	9900.0
2017-10-17 19:00:00	AAPL	Stock	40.13	40.13	40.1075	40.12	2340.0
2017-10-17 19:30:00	AAPL	Stock	40.115	40.1275	40.1125	40.12	37180.0
2017-10-17 05:00:00	MSFT	Stock	77.22	77.22	77.0	77.11	976.0
2017-10-17 06:30:00	MSFT	Stock	77.56	77.56	77.56	77.56	118.0
2017-10-17 07:00:00	MSFT	Stock	77.38	77.38	77.38	77.38	124.0
2017-10-17 07:30:00	MSFT	Stock	77.45	77.56	77.45	77.56	300.0
2017-10-17 08:00:00	MSFT	Stock	77.55	77.64	77.5	77.64	2140.0
2017-10-17 08:30:00	MSFT	Stock	77.5	77.5	77.48	77.48	200.0
2017-10-17 09:00:00	MSFT	Stock	77.49	77.5	77.45	77.49	2729.0
2017-10-17 09:30:00	MSFT	Stock	77.48	77.59	77.3	77.395	1409803.0
2017-10-17 10:00:00	MSFT	Stock	77.4	77.45	77.3	77.305	981078.0
2017-10-17 10:30:00	MSFT	Stock	77.305	77.44	77.25	77.41	937222.0
2017-10-17 11:00:00	MSFT	Stock	77.405	77.5	77.39	77.495	672302.0
2017-10-17 11:30:00	MSFT	Stock	77.49	77.54	77.4	77.46	907252.0
2017-10-17 12:00:00	MSFT	Stock	77.46	77.506	77.415	77.505	744322.0
2017-10-17 12:30:00	MSFT	Stock	77.505	77.51	77.38	77.38	767924.0
2017-10-17 13:00:00	MSFT	Stock	77.38	77.43	77.34	77.34	458842.0
2017-10-17 13:30:00	MSFT	Stock	77.345	77.415	77.325	77.36	891126.0
2017-10-17 14:00:00	MSFT	Stock	77.37	77.43	77.33	77.35	510354.0
2017-10-17 14:30:00	MSFT	Stock	77.345	77.41	77.33	77.374	497697.0
2017-10-17 15:00:00	MSFT	Stock	77.375	77.39	77.32	77.364	733947.0
2017-10-17 15:30:00	MSFT	Stock	77.37	77.62	77.365	77.57	1741498.0

> showing 50 of 81,870 rows — these rows as CSV

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