PREVIEW / stock_30min / 2014-10-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-28.parquet
  size:    1.6 MB
  rows:    83,746
  symbols: 3,557

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-10-28 04:00:00	AAPL	Stock	26.1725	26.42	26.1725	26.4175	13920.0
2014-10-28 04:30:00	AAPL	Stock	26.4	26.4425	26.375	26.4425	27440.0
2014-10-28 05:00:00	AAPL	Stock	26.4	26.4025	26.4	26.4025	4400.0
2014-10-28 05:30:00	AAPL	Stock	26.4025	26.43	26.4025	26.43	24032.0
2014-10-28 06:00:00	AAPL	Stock	26.43	26.43	26.4	26.4125	22572.0
2014-10-28 06:30:00	AAPL	Stock	26.4125	26.4275	26.4	26.425	36200.0
2014-10-28 07:00:00	AAPL	Stock	26.4225	26.425	26.375	26.41	123036.0
2014-10-28 07:30:00	AAPL	Stock	26.4125	26.4125	26.3775	26.3975	66472.0
2014-10-28 08:00:00	AAPL	Stock	26.4	26.4225	26.1725	26.34	446476.0
2014-10-28 08:30:00	AAPL	Stock	26.34	26.3775	26.3375	26.375	305588.0
2014-10-28 09:00:00	AAPL	Stock	26.38	26.385	26.33	26.3525	444892.0
2014-10-28 09:30:00	AAPL	Stock	26.35	26.5425	26.3375	26.5222	27063040.0
2014-10-28 10:00:00	AAPL	Stock	26.52	26.5625	26.49	26.4918	14982164.0
2014-10-28 10:30:00	AAPL	Stock	26.49	26.575	26.465	26.57	12679872.0
2014-10-28 11:00:00	AAPL	Stock	26.5738	26.5925	26.5575	26.5825	10552840.0
2014-10-28 11:30:00	AAPL	Stock	26.585	26.5865	26.545	26.56	7389948.0
2014-10-28 12:00:00	AAPL	Stock	26.56	26.605	26.5525	26.575	7188996.0
2014-10-28 12:30:00	AAPL	Stock	26.5775	26.615	26.565	26.6065	5851764.0
2014-10-28 13:00:00	AAPL	Stock	26.6075	26.655	26.6038	26.6475	7470272.0
2014-10-28 13:30:00	AAPL	Stock	26.6475	26.6575	26.6188	26.6462	8136940.0
2014-10-28 14:00:00	AAPL	Stock	26.6462	26.6588	26.625	26.6365	8053452.0
2014-10-28 14:30:00	AAPL	Stock	26.635	26.65	26.605	26.6375	8741592.0
2014-10-28 15:00:00	AAPL	Stock	26.6375	26.6675	26.6325	26.6498	10342140.0
2014-10-28 15:30:00	AAPL	Stock	26.65	26.68	26.615	26.6775	18172236.0
2014-10-28 16:00:00	AAPL	Stock	26.685	26.685	26.5838	26.6725	1196468.0
2014-10-28 16:30:00	AAPL	Stock	26.685	26.6875	26.5745	26.6875	545604.0
2014-10-28 17:00:00	AAPL	Stock	26.68	26.6875	26.6325	26.645	5149660.0
2014-10-28 17:30:00	AAPL	Stock	26.64	26.685	26.59	26.5925	764288.0
2014-10-28 18:00:00	AAPL	Stock	26.5975	26.65	26.5025	26.545	305004.0
2014-10-28 18:30:00	AAPL	Stock	26.545	26.6	26.525	26.5875	118920.0
2014-10-28 19:00:00	AAPL	Stock	26.5875	26.61	26.5875	26.6	121044.0
2014-10-28 19:30:00	AAPL	Stock	26.605	26.6225	26.5875	26.6225	95712.0
2014-10-28 04:30:00	MSFT	Stock	46.1	46.1	46.1	46.1	730.0
2014-10-28 05:30:00	MSFT	Stock	46.08	46.15	46.08	46.15	800.0
2014-10-28 06:30:00	MSFT	Stock	46.08	46.08	46.08	46.08	1000.0
2014-10-28 07:00:00	MSFT	Stock	46.09	46.09	46.09	46.09	500.0
2014-10-28 07:30:00	MSFT	Stock	46.1	46.1	46.1	46.1	300.0
2014-10-28 08:00:00	MSFT	Stock	46.19	46.19	46.05	46.15	3670.0
2014-10-28 08:30:00	MSFT	Stock	46.07	46.13	46.01	46.05	4327.0
2014-10-28 09:00:00	MSFT	Stock	46.04	46.04	45.89	45.89	6817.0
2014-10-28 09:30:00	MSFT	Stock	45.86	46.19	45.86	46.06	2823134.0
2014-10-28 10:00:00	MSFT	Stock	46.05	46.07	45.77	45.93	2055245.0
2014-10-28 10:30:00	MSFT	Stock	45.923	46.04	45.88	45.99	2094634.0
2014-10-28 11:00:00	MSFT	Stock	45.99	46.05	45.96	45.97	1410813.0
2014-10-28 11:30:00	MSFT	Stock	45.965	46.01	45.95	45.98	818706.0
2014-10-28 12:00:00	MSFT	Stock	45.98	45.99	45.9	45.97	968695.0
2014-10-28 12:30:00	MSFT	Stock	45.97	45.985	45.91	45.94	713664.0
2014-10-28 13:00:00	MSFT	Stock	45.94	46.03	45.935	46.02	1913700.0
2014-10-28 13:30:00	MSFT	Stock	46.02	46.1	46.0	46.09	1100030.0
2014-10-28 14:00:00	MSFT	Stock	46.085	46.2	46.06	46.2	1327035.0

> showing 50 of 83,746 rows — these rows as CSV

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