PREVIEW / stock_30min / 2016-12-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-28.parquet
  size:    1.6 MB
  rows:    81,065
  symbols: 3,165

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
2016-12-28 05:30:00	AAPL	Stock	29.345	29.345	29.345	29.345	460.0
2016-12-28 06:00:00	AAPL	Stock	29.325	29.325	29.3125	29.3125	1396.0
2016-12-28 06:30:00	AAPL	Stock	29.3375	29.3375	29.3375	29.3375	636.0
2016-12-28 07:00:00	AAPL	Stock	29.37	29.3725	29.37	29.3725	2000.0
2016-12-28 07:30:00	AAPL	Stock	29.37	29.3925	29.3625	29.3925	6288.0
2016-12-28 08:00:00	AAPL	Stock	29.395	29.43	29.3625	29.4125	75984.0
2016-12-28 08:30:00	AAPL	Stock	29.425	29.4375	29.4	29.4125	64996.0
2016-12-28 09:00:00	AAPL	Stock	29.4125	29.425	29.3525	29.375	158796.0
2016-12-28 09:30:00	AAPL	Stock	29.38	29.5042	29.3225	29.335	13640732.0
2016-12-28 10:00:00	AAPL	Stock	29.3375	29.3875	29.2525	29.2775	7874956.0
2016-12-28 10:30:00	AAPL	Stock	29.275	29.3	29.1925	29.2375	5649272.0
2016-12-28 11:00:00	AAPL	Stock	29.2332	29.3218	29.2275	29.3138	6089204.0
2016-12-28 11:30:00	AAPL	Stock	29.3125	29.3175	29.27	29.29	4146048.0
2016-12-28 12:00:00	AAPL	Stock	29.2875	29.2888	29.2125	29.24	4684860.0
2016-12-28 12:30:00	AAPL	Stock	29.2425	29.25	29.1875	29.25	3767776.0
2016-12-28 13:00:00	AAPL	Stock	29.25	29.26	29.215	29.2275	2989608.0
2016-12-28 13:30:00	AAPL	Stock	29.2275	29.2525	29.1725	29.2038	3033948.0
2016-12-28 14:00:00	AAPL	Stock	29.203	29.2375	29.16	29.2	3052496.0
2016-12-28 14:30:00	AAPL	Stock	29.1975	29.215	29.1675	29.2125	2720264.0
2016-12-28 15:00:00	AAPL	Stock	29.21	29.2388	29.195	29.1975	3206924.0
2016-12-28 15:30:00	AAPL	Stock	29.2	29.2075	29.05	29.1875	8074436.0
2016-12-28 16:00:00	AAPL	Stock	29.185	29.19	29.1625	29.1675	3714632.0
2016-12-28 16:30:00	AAPL	Stock	29.165	29.1875	29.1475	29.175	34016.0
2016-12-28 17:00:00	AAPL	Stock	29.15	29.1875	29.15	29.1875	14620.0
2016-12-28 18:00:00	AAPL	Stock	29.16	29.18	29.16	29.175	12000.0
2016-12-28 18:30:00	AAPL	Stock	29.1775	29.1775	29.1775	29.1775	400.0
2016-12-28 19:00:00	AAPL	Stock	29.1775	29.1775	29.1675	29.1675	6732.0
2016-12-28 19:30:00	AAPL	Stock	29.1625	29.1625	29.1575	29.1625	3700.0
2016-12-28 06:00:00	MSFT	Stock	63.28	63.28	63.28	63.28	158.0
2016-12-28 07:00:00	MSFT	Stock	63.03	63.03	63.03	63.03	200.0
2016-12-28 07:30:00	MSFT	Stock	63.2	63.2	63.2	63.2	100.0
2016-12-28 08:00:00	MSFT	Stock	63.4	63.4	63.36	63.36	1850.0
2016-12-28 08:30:00	MSFT	Stock	63.3	63.39	63.3	63.39	782.0
2016-12-28 09:00:00	MSFT	Stock	63.4	63.4	63.3	63.33	5569.0
2016-12-28 09:30:00	MSFT	Stock	63.4	63.4	62.88	62.88	1725039.0
2016-12-28 10:00:00	MSFT	Stock	62.885	63.16	62.83	63.145	1073248.0
2016-12-28 10:30:00	MSFT	Stock	63.14	63.22	63.11	63.215	786309.0
2016-12-28 11:00:00	MSFT	Stock	63.217	63.36	63.2	63.314	846703.0
2016-12-28 11:30:00	MSFT	Stock	63.32	63.35	63.21	63.229	441096.0
2016-12-28 12:00:00	MSFT	Stock	63.22	63.23	63.08	63.23	816170.0
2016-12-28 12:30:00	MSFT	Stock	63.23	63.23	63.0	63.1	680378.0
2016-12-28 13:00:00	MSFT	Stock	63.1	63.1	63.0	63.03	467947.0
2016-12-28 13:30:00	MSFT	Stock	63.03	63.08	62.97	63.0	494309.0
2016-12-28 14:00:00	MSFT	Stock	63.0	63.05	62.88	63.005	661977.0
2016-12-28 14:30:00	MSFT	Stock	63.0	63.055	62.945	63.05	508427.0
2016-12-28 15:00:00	MSFT	Stock	63.045	63.08	62.97	62.98	700290.0
2016-12-28 15:30:00	MSFT	Stock	62.985	63.04	62.9	62.99	2038912.0
2016-12-28 16:00:00	MSFT	Stock	62.99	63.1	62.99	63.01	1430872.0
2016-12-28 16:30:00	MSFT	Stock	62.99	63.07	62.98	63.07	100695.0
2016-12-28 17:00:00	MSFT	Stock	62.95	62.95	62.95	62.95	100.0

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

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