PREVIEW / stock_30min / 2015-09-03

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-03.parquet
  size:    1.5 MB
  rows:    81,019
  symbols: 3,447

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-09-03 04:00:00	AAPL	Stock	28.1475	28.325	28.1475	28.2125	14976.0
2015-09-03 04:30:00	AAPL	Stock	28.2475	28.2875	28.225	28.2875	31684.0
2015-09-03 05:00:00	AAPL	Stock	28.28	28.375	28.28	28.335	17120.0
2015-09-03 05:30:00	AAPL	Stock	28.325	28.325	28.235	28.25	42712.0
2015-09-03 06:00:00	AAPL	Stock	28.2375	28.285	28.2375	28.285	49620.0
2015-09-03 06:30:00	AAPL	Stock	28.275	28.275	28.1875	28.23	73956.0
2015-09-03 07:00:00	AAPL	Stock	28.215	28.2525	28.18	28.2	152588.0
2015-09-03 07:30:00	AAPL	Stock	28.18	28.245	28.18	28.2	222460.0
2015-09-03 08:00:00	AAPL	Stock	28.1875	28.245	28.1275	28.1525	683860.0
2015-09-03 08:30:00	AAPL	Stock	28.16	28.2875	28.1325	28.2	862132.0
2015-09-03 09:00:00	AAPL	Stock	28.1875	28.19	28.0075	28.12	1423376.0
2015-09-03 09:30:00	AAPL	Stock	28.12	28.195	27.82	27.8925	29648112.0
2015-09-03 10:00:00	AAPL	Stock	27.8925	28.095	27.87	28.04	17139984.0
2015-09-03 10:30:00	AAPL	Stock	28.0425	28.0575	27.915	28.0325	12697656.0
2015-09-03 11:00:00	AAPL	Stock	28.0338	28.115	27.9425	27.9675	12205324.0
2015-09-03 11:30:00	AAPL	Stock	27.97	27.985	27.8375	27.925	12972352.0
2015-09-03 12:00:00	AAPL	Stock	27.9225	27.9825	27.8775	27.9435	7368904.0
2015-09-03 12:30:00	AAPL	Stock	27.9425	27.9475	27.7675	27.8025	11278452.0
2015-09-03 13:00:00	AAPL	Stock	27.8025	27.8125	27.615	27.7325	15167944.0
2015-09-03 13:30:00	AAPL	Stock	27.735	27.7375	27.51	27.515	12286660.0
2015-09-03 14:00:00	AAPL	Stock	27.5175	27.7125	27.5125	27.6875	12126100.0
2015-09-03 14:30:00	AAPL	Stock	27.6875	27.7875	27.6275	27.6912	11459048.0
2015-09-03 15:00:00	AAPL	Stock	27.6925	27.7575	27.6	27.6475	11678620.0
2015-09-03 15:30:00	AAPL	Stock	27.6475	27.6875	27.525	27.585	18996900.0
2015-09-03 16:00:00	AAPL	Stock	27.5925	28.0135	27.585	27.6	6898384.0
2015-09-03 16:30:00	AAPL	Stock	27.6025	27.6025	27.575	27.5925	115164.0
2015-09-03 17:00:00	AAPL	Stock	27.6075	27.6075	27.58	27.5875	67512.0
2015-09-03 17:30:00	AAPL	Stock	27.5875	27.5875	27.5375	27.5475	87880.0
2015-09-03 18:00:00	AAPL	Stock	27.5475	27.6	27.54	27.575	93460.0
2015-09-03 18:30:00	AAPL	Stock	27.5725	27.5725	27.5625	27.5625	36284.0
2015-09-03 19:00:00	AAPL	Stock	27.57	27.5875	27.5125	27.575	41656.0
2015-09-03 19:30:00	AAPL	Stock	27.575	27.605	27.5625	27.5875	68088.0
2015-09-03 04:30:00	MSFT	Stock	43.48	43.5	43.48	43.5	300.0
2015-09-03 07:00:00	MSFT	Stock	43.4	43.4	43.4	43.4	450.0
2015-09-03 07:30:00	MSFT	Stock	43.4	43.4	43.4	43.4	600.0
2015-09-03 08:00:00	MSFT	Stock	43.45	43.5	43.45	43.45	4430.0
2015-09-03 08:30:00	MSFT	Stock	43.5	43.79	43.5	43.62	25896.0
2015-09-03 09:00:00	MSFT	Stock	43.55	43.59	43.27	43.38	20841.0
2015-09-03 09:30:00	MSFT	Stock	43.41	43.98	43.28	43.755	4373852.0
2015-09-03 10:00:00	MSFT	Stock	43.76	43.87	43.65	43.83	2048532.0
2015-09-03 10:30:00	MSFT	Stock	43.83	43.91	43.69	43.905	1678492.0
2015-09-03 11:00:00	MSFT	Stock	43.9	43.96	43.79	43.82	1411077.0
2015-09-03 11:30:00	MSFT	Stock	43.83	43.83	43.625	43.69	1244291.0
2015-09-03 12:00:00	MSFT	Stock	43.69	43.84	43.66	43.83	879629.0
2015-09-03 12:30:00	MSFT	Stock	43.83	43.84	43.56	43.71	1311947.0
2015-09-03 13:00:00	MSFT	Stock	43.72	43.74	43.43	43.65	1654009.0
2015-09-03 13:30:00	MSFT	Stock	43.65	43.65	43.485	43.5	1403045.0
2015-09-03 14:00:00	MSFT	Stock	43.5	43.6	43.4	43.6	1236511.0
2015-09-03 14:30:00	MSFT	Stock	43.595	43.72	43.555	43.64	1193886.0
2015-09-03 15:00:00	MSFT	Stock	43.645	43.72	43.52	43.545	1994103.0

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

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