PREVIEW / stock_30min / 2017-10-04

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-04.parquet
  size:    1.6 MB
  rows:    81,926
  symbols: 2,956

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-04 05:30:00	AAPL	Stock	38.625	38.6625	38.625	38.6625	9540.0
2017-10-04 06:00:00	AAPL	Stock	38.635	38.635	38.6325	38.6325	928.0
2017-10-04 06:30:00	AAPL	Stock	38.6275	38.6275	38.5775	38.585	41020.0
2017-10-04 07:00:00	AAPL	Stock	38.6	38.62	38.38	38.425	120160.0
2017-10-04 07:30:00	AAPL	Stock	38.425	38.5	38.3275	38.4675	171216.0
2017-10-04 08:00:00	AAPL	Stock	38.575	38.705	38.3275	38.415	190824.0
2017-10-04 08:30:00	AAPL	Stock	38.415	38.415	38.32	38.335	316900.0
2017-10-04 09:00:00	AAPL	Stock	38.35	38.435	38.3375	38.4175	283628.0
2017-10-04 09:30:00	AAPL	Stock	38.4075	38.435	38.2725	38.3838	12673900.0
2017-10-04 10:00:00	AAPL	Stock	38.3875	38.39	38.2275	38.295	7268436.0
2017-10-04 10:30:00	AAPL	Stock	38.295	38.33	38.115	38.2562	9473952.0
2017-10-04 11:00:00	AAPL	Stock	38.26	38.42	38.26	38.415	5577468.0
2017-10-04 11:30:00	AAPL	Stock	38.415	38.4575	38.335	38.369	5548004.0
2017-10-04 12:00:00	AAPL	Stock	38.375	38.465	38.3575	38.4425	3320144.0
2017-10-04 12:30:00	AAPL	Stock	38.4425	38.4442	38.35	38.395	2654444.0
2017-10-04 13:00:00	AAPL	Stock	38.3975	38.41	38.355	38.3962	2025716.0
2017-10-04 13:30:00	AAPL	Stock	38.3968	38.3968	38.28	38.34	3596572.0
2017-10-04 14:00:00	AAPL	Stock	38.34	38.355	38.2948	38.3338	2566484.0
2017-10-04 14:30:00	AAPL	Stock	38.3338	38.36	38.3075	38.3475	2371060.0
2017-10-04 15:00:00	AAPL	Stock	38.3475	38.3675	38.325	38.3298	2566680.0
2017-10-04 15:30:00	AAPL	Stock	38.3275	38.4075	38.295	38.3675	7103624.0
2017-10-04 16:00:00	AAPL	Stock	38.3675	38.37	38.3475	38.3675	4195564.0
2017-10-04 16:30:00	AAPL	Stock	38.37	38.4	38.355	38.38	274344.0
2017-10-04 17:00:00	AAPL	Stock	38.4	38.4125	38.3875	38.4	47256.0
2017-10-04 17:30:00	AAPL	Stock	38.41	38.4275	38.3925	38.4	135828.0
2017-10-04 18:00:00	AAPL	Stock	38.4025	38.4075	38.3875	38.405	31460.0
2017-10-04 18:30:00	AAPL	Stock	38.3825	38.4075	38.3825	38.3975	36188.0
2017-10-04 19:00:00	AAPL	Stock	38.3975	38.3975	38.385	38.3975	10504.0
2017-10-04 19:30:00	AAPL	Stock	38.3975	38.3975	38.385	38.385	21664.0
2017-10-04 07:00:00	MSFT	Stock	74.3	74.3	74.3	74.3	200.0
2017-10-04 08:30:00	MSFT	Stock	74.22	74.22	74.22	74.22	800.0
2017-10-04 09:00:00	MSFT	Stock	74.22	74.22	74.0	74.0	20234.0
2017-10-04 09:30:00	MSFT	Stock	74.0	74.25	73.82	73.88	1588073.0
2017-10-04 10:00:00	MSFT	Stock	73.89	73.97	73.83	73.861	650388.0
2017-10-04 10:30:00	MSFT	Stock	73.87	73.96	73.71	73.91	869251.0
2017-10-04 11:00:00	MSFT	Stock	73.905	74.09	73.905	74.09	636350.0
2017-10-04 11:30:00	MSFT	Stock	74.09	74.18	74.049	74.13	471564.0
2017-10-04 12:00:00	MSFT	Stock	74.14	74.44	74.125	74.34	604412.0
2017-10-04 12:30:00	MSFT	Stock	74.345	74.37	74.21	74.22	344591.0
2017-10-04 13:00:00	MSFT	Stock	74.23	74.26	74.11	74.17	387081.0
2017-10-04 13:30:00	MSFT	Stock	74.166	74.2	73.93	74.185	615821.0
2017-10-04 14:00:00	MSFT	Stock	74.19	74.345	74.18	74.317	738019.0
2017-10-04 14:30:00	MSFT	Stock	74.32	74.55	74.31	74.53	674313.0
2017-10-04 15:00:00	MSFT	Stock	74.53	74.57	74.415	74.55	897580.0
2017-10-04 15:30:00	MSFT	Stock	74.55	74.72	74.48	74.68	2328325.0
2017-10-04 16:00:00	MSFT	Stock	74.68	74.72	74.67	74.72	1321933.0
2017-10-04 16:30:00	MSFT	Stock	74.61	74.69	74.6	74.69	2535.0
2017-10-04 17:00:00	MSFT	Stock	74.65	74.65	74.65	74.65	100.0
2017-10-04 18:30:00	MSFT	Stock	74.62	74.69	74.62	74.69	311.0
2017-10-04 19:30:00	MSFT	Stock	74.65	74.65	74.65	74.65	100.0

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

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