PREVIEW / stock_30min / 2017-09-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-18.parquet
  size:    1.6 MB
  rows:    82,491
  symbols: 2,965

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-09-18 04:00:00	AAPL	Stock	40.055	40.055	40.05	40.05	2164.0
2017-09-18 04:30:00	AAPL	Stock	40.1125	40.15	40.1125	40.15	5600.0
2017-09-18 05:00:00	AAPL	Stock	40.125	40.125	40.125	40.125	1200.0
2017-09-18 05:30:00	AAPL	Stock	40.1225	40.1575	40.1225	40.1375	5700.0
2017-09-18 06:00:00	AAPL	Stock	40.16	40.1625	40.1375	40.1425	16264.0
2017-09-18 06:30:00	AAPL	Stock	40.1375	40.15	40.1125	40.15	13388.0
2017-09-18 07:00:00	AAPL	Stock	40.1425	40.1425	40.09	40.09	40452.0
2017-09-18 07:30:00	AAPL	Stock	40.09	40.1	40.075	40.08	53544.0
2017-09-18 08:00:00	AAPL	Stock	40.08	40.145	39.97	40.0475	165460.0
2017-09-18 08:30:00	AAPL	Stock	40.0575	40.08	40.0025	40.02	142944.0
2017-09-18 09:00:00	AAPL	Stock	40.025	40.095	40.025	40.04	159072.0
2017-09-18 09:30:00	AAPL	Stock	40.0275	40.125	39.9275	40.018	14791216.0
2017-09-18 10:00:00	AAPL	Stock	40.015	40.03	39.7625	39.8975	10336816.0
2017-09-18 10:30:00	AAPL	Stock	39.8975	39.9225	39.8275	39.8288	6229124.0
2017-09-18 11:00:00	AAPL	Stock	39.8278	40.015	39.8278	39.9825	6163452.0
2017-09-18 11:30:00	AAPL	Stock	39.985	40.0225	39.925	39.9375	3832276.0
2017-09-18 12:00:00	AAPL	Stock	39.9375	39.975	39.9075	39.9362	2481132.0
2017-09-18 12:30:00	AAPL	Stock	39.9375	39.945	39.8675	39.9	2475448.0
2017-09-18 13:00:00	AAPL	Stock	39.9	39.905	39.8	39.8138	3066444.0
2017-09-18 13:30:00	AAPL	Stock	39.8128	39.8575	39.81	39.8225	2513272.0
2017-09-18 14:00:00	AAPL	Stock	39.82	39.8375	39.585	39.6538	8291860.0
2017-09-18 14:30:00	AAPL	Stock	39.653	39.6775	39.4988	39.6075	10209024.0
2017-09-18 15:00:00	AAPL	Stock	39.605	39.6875	39.525	39.645	5298820.0
2017-09-18 15:30:00	AAPL	Stock	39.6425	39.7475	39.6325	39.66	8539852.0
2017-09-18 16:00:00	AAPL	Stock	39.6675	39.9162	39.635	39.6675	18034612.0
2017-09-18 16:30:00	AAPL	Stock	39.6625	39.6825	39.6625	39.665	39252.0
2017-09-18 17:00:00	AAPL	Stock	39.6825	39.6825	39.665	39.6825	16184.0
2017-09-18 17:30:00	AAPL	Stock	39.675	39.6875	39.675	39.6875	8480.0
2017-09-18 18:00:00	AAPL	Stock	39.68	39.68	39.6675	39.6675	18444.0
2017-09-18 18:30:00	AAPL	Stock	39.6675	39.6675	39.655	39.6625	13928.0
2017-09-18 19:00:00	AAPL	Stock	39.6675	39.6675	39.655	39.655	13656.0
2017-09-18 19:30:00	AAPL	Stock	39.655	39.6875	39.655	39.675	5364.0
2017-09-18 06:00:00	MSFT	Stock	75.53	75.53	75.53	75.53	300.0
2017-09-18 07:00:00	MSFT	Stock	75.5	75.5	75.5	75.5	796.0
2017-09-18 07:30:00	MSFT	Stock	75.47	75.48	75.47	75.48	1458.0
2017-09-18 08:00:00	MSFT	Stock	75.41	75.47	75.31	75.4	7178.0
2017-09-18 08:30:00	MSFT	Stock	75.4	75.4	75.29	75.35	2551.0
2017-09-18 09:00:00	MSFT	Stock	75.35	75.4	75.29	75.29	2760.0
2017-09-18 09:30:00	MSFT	Stock	75.26	75.53	75.15	75.52	1714496.0
2017-09-18 10:00:00	MSFT	Stock	75.515	75.635	75.49	75.575	975004.0
2017-09-18 10:30:00	MSFT	Stock	75.57	75.66	75.5	75.6	807879.0
2017-09-18 11:00:00	MSFT	Stock	75.6	75.816	75.585	75.815	835017.0
2017-09-18 11:30:00	MSFT	Stock	75.81	75.89	75.75	75.845	746124.0
2017-09-18 12:00:00	MSFT	Stock	75.85	75.97	75.79	75.81	728482.0
2017-09-18 12:30:00	MSFT	Stock	75.805	75.81	75.54	75.6	718532.0
2017-09-18 13:00:00	MSFT	Stock	75.605	75.71	75.515	75.6	606584.0
2017-09-18 13:30:00	MSFT	Stock	75.605	75.675	75.57	75.58	816981.0
2017-09-18 14:00:00	MSFT	Stock	75.58	75.59	75.135	75.21	1345924.0
2017-09-18 14:30:00	MSFT	Stock	75.21	75.355	75.07	75.17	1711159.0
2017-09-18 15:00:00	MSFT	Stock	75.17	75.195	75.05	75.13	836613.0

> showing 50 of 82,491 rows — these rows as CSV

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