PREVIEW / stock_30min / 2014-11-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-20.parquet
  size:    1.6 MB
  rows:    84,248
  symbols: 3,563

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
2014-11-20 04:00:00	AAPL	Stock	27.5	28.595	27.5	28.595	1600.0
2014-11-20 04:30:00	AAPL	Stock	28.595	28.595	28.5875	28.5875	11200.0
2014-11-20 05:00:00	AAPL	Stock	28.5675	28.5675	28.5675	28.5675	5152.0
2014-11-20 05:30:00	AAPL	Stock	28.57	28.6025	28.57	28.57	4400.0
2014-11-20 06:00:00	AAPL	Stock	28.585	28.585	28.5675	28.5675	6264.0
2014-11-20 06:30:00	AAPL	Stock	28.57	28.59	28.5625	28.5875	3700.0
2014-11-20 07:00:00	AAPL	Stock	28.605	28.6375	28.58	28.62	53472.0
2014-11-20 07:30:00	AAPL	Stock	28.62	28.6475	28.62	28.625	46788.0
2014-11-20 08:00:00	AAPL	Stock	28.63	28.7425	28.58	28.7325	282072.0
2014-11-20 08:30:00	AAPL	Stock	28.725	28.7725	28.6675	28.7275	6372264.0
2014-11-20 09:00:00	AAPL	Stock	28.725	28.7475	28.7125	28.7325	566676.0
2014-11-20 09:30:00	AAPL	Stock	28.7275	28.9625	28.7125	28.9	27974116.0
2014-11-20 10:00:00	AAPL	Stock	28.9	29.0125	28.9	28.9975	15879736.0
2014-11-20 10:30:00	AAPL	Stock	28.9975	29.1075	28.98	29.0875	16746020.0
2014-11-20 11:00:00	AAPL	Stock	29.09	29.21	29.0875	29.2088	14536992.0
2014-11-20 11:30:00	AAPL	Stock	29.2075	29.215	29.105	29.1375	10717632.0
2014-11-20 12:00:00	AAPL	Stock	29.135	29.1575	29.08	29.0925	8515748.0
2014-11-20 12:30:00	AAPL	Stock	29.0925	29.155	29.0675	29.1225	7253884.0
2014-11-20 13:00:00	AAPL	Stock	29.1225	29.1675	29.115	29.1625	5815828.0
2014-11-20 13:30:00	AAPL	Stock	29.1625	29.1725	29.105	29.1082	4337468.0
2014-11-20 14:00:00	AAPL	Stock	29.1075	29.1525	29.1	29.1425	5652152.0
2014-11-20 14:30:00	AAPL	Stock	29.14	29.165	29.1075	29.1125	5311356.0
2014-11-20 15:00:00	AAPL	Stock	29.1125	29.135	29.0828	29.115	6603204.0
2014-11-20 15:30:00	AAPL	Stock	29.115	29.1275	29.055	29.075	16243920.0
2014-11-20 16:00:00	AAPL	Stock	29.0775	29.1068	28.9025	29.084	9104112.0
2014-11-20 16:30:00	AAPL	Stock	29.0975	29.1155	29.0725	29.0925	211556.0
2014-11-20 17:00:00	AAPL	Stock	29.0875	29.095	29.0775	29.0875	1029892.0
2014-11-20 17:30:00	AAPL	Stock	29.09	29.1	29.0775	29.0975	71456.0
2014-11-20 18:00:00	AAPL	Stock	29.0975	29.1	29.0825	29.095	31840.0
2014-11-20 18:30:00	AAPL	Stock	29.0975	29.1025	29.0825	29.085	43272.0
2014-11-20 19:00:00	AAPL	Stock	29.085	29.1	29.08	29.1	61112.0
2014-11-20 19:30:00	AAPL	Stock	29.1	29.11	29.1	29.1075	92364.0
2014-11-20 04:00:00	MSFT	Stock	48.18	48.18	48.18	48.18	100.0
2014-11-20 06:30:00	MSFT	Stock	48.06	48.06	48.06	48.06	200.0
2014-11-20 07:00:00	MSFT	Stock	48.06	48.06	48.06	48.06	200.0
2014-11-20 08:00:00	MSFT	Stock	48.03	48.05	48.03	48.05	1980.0
2014-11-20 08:30:00	MSFT	Stock	48.0	48.05	48.0	48.0	2599.0
2014-11-20 09:00:00	MSFT	Stock	48.02	48.06	47.9	48.0	15286.0
2014-11-20 09:30:00	MSFT	Stock	48.01	48.1	47.87	48.04	2849465.0
2014-11-20 10:00:00	MSFT	Stock	48.05	48.23	48.04	48.21	1876322.0
2014-11-20 10:30:00	MSFT	Stock	48.21	48.35	48.1	48.33	1309043.0
2014-11-20 11:00:00	MSFT	Stock	48.33	48.39	48.29	48.34	730371.0
2014-11-20 11:30:00	MSFT	Stock	48.34	48.4	48.31	48.36	674644.0
2014-11-20 12:00:00	MSFT	Stock	48.36	48.36	48.25	48.35	706157.0
2014-11-20 12:30:00	MSFT	Stock	48.35	48.49	48.35	48.43	859752.0
2014-11-20 13:00:00	MSFT	Stock	48.43	48.47	48.37	48.47	1249581.0
2014-11-20 13:30:00	MSFT	Stock	48.47	48.48	48.38	48.41	781904.0
2014-11-20 14:00:00	MSFT	Stock	48.405	48.56	48.4	48.53	1447869.0
2014-11-20 14:30:00	MSFT	Stock	48.53	48.59	48.495	48.55	1149714.0
2014-11-20 15:00:00	MSFT	Stock	48.54	48.607	48.51	48.58	1255755.0

> showing 50 of 84,248 rows — these rows as CSV

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