PREVIEW / stock_30min / 2015-08-07

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-07.parquet
  size:    1.6 MB
  rows:    80,662
  symbols: 3,465

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-08-07 04:00:00	AAPL	Stock	28.7875	28.7875	28.7875	28.7875	9292.0
2015-08-07 05:00:00	AAPL	Stock	28.82	28.82	28.775	28.775	3892.0
2015-08-07 05:30:00	AAPL	Stock	28.7875	28.7875	28.775	28.775	1976.0
2015-08-07 06:00:00	AAPL	Stock	28.7725	28.775	28.73	28.77	10368.0
2015-08-07 06:30:00	AAPL	Stock	28.75	28.77	28.7125	28.75	6356.0
2015-08-07 07:00:00	AAPL	Stock	28.725	28.7375	28.71	28.725	30516.0
2015-08-07 07:30:00	AAPL	Stock	28.725	28.73	28.7075	28.7125	29576.0
2015-08-07 08:00:00	AAPL	Stock	28.7125	28.7625	28.685	28.7075	210296.0
2015-08-07 08:30:00	AAPL	Stock	28.72	28.7825	28.6925	28.7575	367592.0
2015-08-07 09:00:00	AAPL	Stock	28.7825	28.7875	28.635	28.6475	459088.0
2015-08-07 09:30:00	AAPL	Stock	28.6425	29.045	28.625	29.025	30371452.0
2015-08-07 10:00:00	AAPL	Stock	29.025	29.0625	28.8125	28.835	17518352.0
2015-08-07 10:30:00	AAPL	Stock	28.835	28.91	28.78	28.8125	10409844.0
2015-08-07 11:00:00	AAPL	Stock	28.8125	28.8325	28.7	28.7262	10317180.0
2015-08-07 11:30:00	AAPL	Stock	28.725	28.81	28.6775	28.8	8404920.0
2015-08-07 12:00:00	AAPL	Stock	28.8	28.825	28.75	28.7525	5364268.0
2015-08-07 12:30:00	AAPL	Stock	28.75	28.7825	28.675	28.7322	7237284.0
2015-08-07 13:00:00	AAPL	Stock	28.7325	28.7725	28.7225	28.75	5701124.0
2015-08-07 13:30:00	AAPL	Stock	28.75	28.8325	28.7475	28.76	6609772.0
2015-08-07 14:00:00	AAPL	Stock	28.759	28.805	28.75	28.7675	5485272.0
2015-08-07 14:30:00	AAPL	Stock	28.77	28.805	28.75	28.795	4991384.0
2015-08-07 15:00:00	AAPL	Stock	28.795	28.8725	28.7575	28.8675	9230760.0
2015-08-07 15:30:00	AAPL	Stock	28.8675	28.9025	28.8175	28.885	16205660.0
2015-08-07 16:00:00	AAPL	Stock	28.88	28.895	28.7388	28.885	4309048.0
2015-08-07 16:30:00	AAPL	Stock	28.885	28.8875	28.88	28.8825	89312.0
2015-08-07 17:00:00	AAPL	Stock	28.8775	28.8875	28.875	28.8875	259116.0
2015-08-07 17:30:00	AAPL	Stock	28.8875	28.8875	28.87	28.8725	64700.0
2015-08-07 18:00:00	AAPL	Stock	28.875	28.885	28.8725	28.885	43400.0
2015-08-07 18:30:00	AAPL	Stock	28.8875	28.8875	28.875	28.885	23468.0
2015-08-07 19:00:00	AAPL	Stock	28.8832	28.8875	28.88	28.88	33848.0
2015-08-07 19:30:00	AAPL	Stock	28.88	28.8875	28.88	28.88	54292.0
2015-08-07 07:30:00	MSFT	Stock	46.6	46.6	46.6	46.6	800.0
2015-08-07 08:00:00	MSFT	Stock	46.453	46.5	46.453	46.5	1525.0
2015-08-07 08:30:00	MSFT	Stock	46.41	46.57	46.4	46.57	29280.0
2015-08-07 09:00:00	MSFT	Stock	46.64	46.64	46.32	46.43	20358.0
2015-08-07 09:30:00	MSFT	Stock	46.42	46.745	46.29	46.685	2510587.0
2015-08-07 10:00:00	MSFT	Stock	46.69	46.73	46.44	46.52	1150417.0
2015-08-07 10:30:00	MSFT	Stock	46.525	46.765	46.46	46.489	1247731.0
2015-08-07 11:00:00	MSFT	Stock	46.49	46.49	46.26	46.405	1079890.0
2015-08-07 11:30:00	MSFT	Stock	46.4	46.445	46.29	46.43	993838.0
2015-08-07 12:00:00	MSFT	Stock	46.43	46.47	46.34	46.36	699474.0
2015-08-07 12:30:00	MSFT	Stock	46.36	46.44	46.27	46.39	684032.0
2015-08-07 13:00:00	MSFT	Stock	46.38	46.48	46.33	46.44	697540.0
2015-08-07 13:30:00	MSFT	Stock	46.43	46.54	46.42	46.45	527167.0
2015-08-07 14:00:00	MSFT	Stock	46.44	46.5	46.38	46.47	705079.0
2015-08-07 14:30:00	MSFT	Stock	46.47	46.61	46.47	46.58	1225212.0
2015-08-07 15:00:00	MSFT	Stock	46.58	46.77	46.48	46.72	1543287.0
2015-08-07 15:30:00	MSFT	Stock	46.73	46.78	46.61	46.76	2823974.0
2015-08-07 16:00:00	MSFT	Stock	46.74	46.8	46.508	46.75	2250009.0
2015-08-07 16:30:00	MSFT	Stock	46.753	46.753	46.75	46.75	3075.0

> showing 50 of 80,662 rows — these rows as CSV

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