PREVIEW / stock_30min / 2016-05-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-12.parquet
  size:    1.6 MB
  rows:    81,806
  symbols: 3,297

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-05-12 04:00:00	AAPL	Stock	23.125	23.135	23.125	23.135	1600.0
2016-05-12 04:30:00	AAPL	Stock	23.135	23.17	23.135	23.17	15656.0
2016-05-12 05:00:00	AAPL	Stock	23.16	23.16	23.16	23.16	480.0
2016-05-12 05:30:00	AAPL	Stock	23.1625	23.175	23.1625	23.175	3888.0
2016-05-12 06:00:00	AAPL	Stock	23.1725	23.1825	23.1725	23.1825	4000.0
2016-05-12 06:30:00	AAPL	Stock	23.1825	23.2075	23.1825	23.2075	3600.0
2016-05-12 07:00:00	AAPL	Stock	23.1975	23.2475	23.1875	23.19	23120.0
2016-05-12 07:30:00	AAPL	Stock	23.195	23.205	23.1725	23.1925	79420.0
2016-05-12 08:00:00	AAPL	Stock	23.1925	23.2	23.145	23.1625	76128.0
2016-05-12 08:30:00	AAPL	Stock	23.165	23.175	23.16	23.1625	44876.0
2016-05-12 09:00:00	AAPL	Stock	23.1625	23.2	23.07	23.1925	579564.0
2016-05-12 09:30:00	AAPL	Stock	23.1925	23.195	22.7125	22.735	40683556.0
2016-05-12 10:00:00	AAPL	Stock	22.7338	22.8025	22.6425	22.72	35864520.0
2016-05-12 10:30:00	AAPL	Stock	22.7175	22.7225	22.525	22.5425	27679240.0
2016-05-12 11:00:00	AAPL	Stock	22.5425	22.5525	22.3675	22.5208	44113372.0
2016-05-12 11:30:00	AAPL	Stock	22.5212	22.5825	22.4675	22.4792	18095980.0
2016-05-12 12:00:00	AAPL	Stock	22.4775	22.58	22.445	22.5725	16073196.0
2016-05-12 12:30:00	AAPL	Stock	22.5725	22.5725	22.5	22.5668	10637800.0
2016-05-12 13:00:00	AAPL	Stock	22.5675	22.5825	22.4875	22.535	11143360.0
2016-05-12 13:30:00	AAPL	Stock	22.536	22.5725	22.4725	22.5612	10742108.0
2016-05-12 14:00:00	AAPL	Stock	22.5612	22.6325	22.5225	22.6125	14784668.0
2016-05-12 14:30:00	AAPL	Stock	22.6125	22.6925	22.5625	22.6425	12131272.0
2016-05-12 15:00:00	AAPL	Stock	22.6447	22.7025	22.6025	22.6488	12939976.0
2016-05-12 15:30:00	AAPL	Stock	22.645	22.65	22.5325	22.585	20190564.0
2016-05-12 16:00:00	AAPL	Stock	22.585	22.9232	22.5325	22.5325	6705344.0
2016-05-12 16:30:00	AAPL	Stock	22.545	22.5955	22.535	22.5375	198996.0
2016-05-12 17:00:00	AAPL	Stock	22.5425	22.565	22.5375	22.5525	85132.0
2016-05-12 17:30:00	AAPL	Stock	22.565	22.575	22.5525	22.555	50284.0
2016-05-12 18:00:00	AAPL	Stock	22.555	22.5675	22.5325	22.5375	52488.0
2016-05-12 18:30:00	AAPL	Stock	22.5375	22.54	22.5225	22.5325	38104.0
2016-05-12 19:00:00	AAPL	Stock	22.525	22.54	22.5	22.505	112820.0
2016-05-12 19:30:00	AAPL	Stock	22.5175	22.5225	22.47	22.505	208352.0
2016-05-12 07:00:00	MSFT	Stock	51.32	51.32	51.28	51.28	1400.0
2016-05-12 07:30:00	MSFT	Stock	51.28	51.29	51.24	51.29	22956.0
2016-05-12 08:00:00	MSFT	Stock	51.25	51.43	51.25	51.35	1953.0
2016-05-12 08:30:00	MSFT	Stock	51.28	51.3	51.27	51.28	2200.0
2016-05-12 09:00:00	MSFT	Stock	51.28	51.28	51.05	51.2	3111.0
2016-05-12 09:30:00	MSFT	Stock	51.2	51.48	51.2	51.33	2281588.0
2016-05-12 10:00:00	MSFT	Stock	51.335	51.47	51.325	51.41	1347790.0
2016-05-12 10:30:00	MSFT	Stock	51.41	51.518	51.34	51.41	1744177.0
2016-05-12 11:00:00	MSFT	Stock	51.41	51.43	51.03	51.06	1792296.0
2016-05-12 11:30:00	MSFT	Stock	51.05	51.1	50.98	51.02	986331.0
2016-05-12 12:00:00	MSFT	Stock	51.015	51.115	50.92	51.075	981140.0
2016-05-12 12:30:00	MSFT	Stock	51.074	51.21	50.95	51.2	694512.0
2016-05-12 13:00:00	MSFT	Stock	51.207	51.22	51.11	51.2	655067.0
2016-05-12 13:30:00	MSFT	Stock	51.2	51.44	51.144	51.44	1263793.0
2016-05-12 14:00:00	MSFT	Stock	51.44	51.75	51.43	51.69	1634826.0
2016-05-12 14:30:00	MSFT	Stock	51.68	51.81	51.57	51.7	1544804.0
2016-05-12 15:00:00	MSFT	Stock	51.69	51.7	51.54	51.655	1608530.0
2016-05-12 15:30:00	MSFT	Stock	51.65	51.69	51.442	51.51	4251478.0

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

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