PREVIEW / stock_30min / 2015-11-04

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-04.parquet
  size:    1.6 MB
  rows:    82,174
  symbols: 3,404

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
2015-11-04 04:00:00	AAPL	Stock	30.675	30.7325	30.675	30.7325	6300.0
2015-11-04 04:30:00	AAPL	Stock	30.74	30.75	30.74	30.75	2400.0
2015-11-04 05:00:00	AAPL	Stock	30.7475	30.7475	30.7475	30.7475	560.0
2015-11-04 05:30:00	AAPL	Stock	30.745	30.75	30.725	30.75	4244.0
2015-11-04 06:00:00	AAPL	Stock	30.7675	30.7875	30.725	30.7775	32460.0
2015-11-04 06:30:00	AAPL	Stock	30.7775	30.7775	30.7775	30.7775	1600.0
2015-11-04 07:00:00	AAPL	Stock	30.7725	30.785	30.75	30.7625	42492.0
2015-11-04 07:30:00	AAPL	Stock	30.77	30.7775	30.755	30.7675	147804.0
2015-11-04 08:00:00	AAPL	Stock	30.7675	30.8175	30.575	30.815	654860.0
2015-11-04 08:30:00	AAPL	Stock	30.8125	30.8425	30.79	30.83	338360.0
2015-11-04 09:00:00	AAPL	Stock	30.825	30.8325	30.7575	30.77	259296.0
2015-11-04 09:30:00	AAPL	Stock	30.7825	30.955	30.725	30.8125	28530404.0
2015-11-04 10:00:00	AAPL	Stock	30.8125	30.8425	30.6325	30.6775	17104244.0
2015-11-04 10:30:00	AAPL	Stock	30.6775	30.725	30.49	30.525	16938020.0
2015-11-04 11:00:00	AAPL	Stock	30.5275	30.6675	30.4425	30.6475	15066424.0
2015-11-04 11:30:00	AAPL	Stock	30.65	30.693	30.575	30.605	9249108.0
2015-11-04 12:00:00	AAPL	Stock	30.6025	30.7075	30.5775	30.635	6415364.0
2015-11-04 12:30:00	AAPL	Stock	30.6325	30.66	30.5075	30.56	6620956.0
2015-11-04 13:00:00	AAPL	Stock	30.5625	30.575	30.4775	30.53	7903956.0
2015-11-04 13:30:00	AAPL	Stock	30.53	30.57	30.47	30.555	7309296.0
2015-11-04 14:00:00	AAPL	Stock	30.5532	30.6375	30.5325	30.565	8799292.0
2015-11-04 14:30:00	AAPL	Stock	30.5625	30.6175	30.5325	30.5475	6721508.0
2015-11-04 15:00:00	AAPL	Stock	30.5475	30.5725	30.4925	30.5208	7844728.0
2015-11-04 15:30:00	AAPL	Stock	30.52	30.5525	30.405	30.5025	15812860.0
2015-11-04 16:00:00	AAPL	Stock	30.5	30.6672	30.455	30.4925	8990920.0
2015-11-04 16:30:00	AAPL	Stock	30.4925	30.515	30.47	30.4875	84960.0
2015-11-04 17:00:00	AAPL	Stock	30.4875	30.5375	30.4875	30.5375	1642968.0
2015-11-04 17:30:00	AAPL	Stock	30.545	30.545	30.5175	30.545	19664.0
2015-11-04 18:00:00	AAPL	Stock	30.5375	30.5375	30.52	30.53	24960.0
2015-11-04 18:30:00	AAPL	Stock	30.53	30.5475	30.525	30.5475	14324.0
2015-11-04 19:00:00	AAPL	Stock	30.54	30.5475	30.525	30.5375	32608.0
2015-11-04 19:30:00	AAPL	Stock	30.545	30.5625	30.5375	30.5625	92828.0
2015-11-04 04:00:00	MSFT	Stock	54.23	54.23	54.23	54.23	100.0
2015-11-04 06:30:00	MSFT	Stock	54.15	54.15	54.15	54.15	100.0
2015-11-04 07:00:00	MSFT	Stock	54.19	54.19	54.14	54.17	1388.0
2015-11-04 07:30:00	MSFT	Stock	54.21	54.21	54.2	54.2	1100.0
2015-11-04 08:00:00	MSFT	Stock	54.2	54.3	54.2	54.27	20220.0
2015-11-04 08:30:00	MSFT	Stock	54.25	54.3	54.2	54.26	6672.0
2015-11-04 09:00:00	MSFT	Stock	54.29	54.32	54.18	54.18	14132.0
2015-11-04 09:30:00	MSFT	Stock	54.19	54.88	54.1	54.645	6705038.0
2015-11-04 10:00:00	MSFT	Stock	54.65	54.66	54.355	54.61	2451617.0
2015-11-04 10:30:00	MSFT	Stock	54.61	54.64	54.255	54.292	2936784.0
2015-11-04 11:00:00	MSFT	Stock	54.29	54.405	54.12	54.265	1947318.0
2015-11-04 11:30:00	MSFT	Stock	54.265	54.36	54.06	54.235	1950790.0
2015-11-04 12:00:00	MSFT	Stock	54.235	54.56	54.21	54.504	2120047.0
2015-11-04 12:30:00	MSFT	Stock	54.5	54.51	54.23	54.25	1579799.0
2015-11-04 13:00:00	MSFT	Stock	54.25	54.29	54.09	54.28	1371209.0
2015-11-04 13:30:00	MSFT	Stock	54.29	54.315	54.11	54.29	1240951.0
2015-11-04 14:00:00	MSFT	Stock	54.29	54.59	54.16	54.26	4016101.0
2015-11-04 14:30:00	MSFT	Stock	54.252	54.49	54.16	54.49	1875267.0

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

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