PREVIEW / stock_30min / 2015-05-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-18.parquet
  size:    1.6 MB
  rows:    82,561
  symbols: 3,502

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-05-18 04:00:00	AAPL	Stock	32.195	32.2	32.175	32.1875	18724.0
2015-05-18 05:00:00	AAPL	Stock	32.175	32.175	32.175	32.175	800.0
2015-05-18 05:30:00	AAPL	Stock	32.2125	32.22	32.205	32.215	7376.0
2015-05-18 06:00:00	AAPL	Stock	32.19	32.19	32.1025	32.1125	17200.0
2015-05-18 06:30:00	AAPL	Stock	32.08	32.1	32.0775	32.1	13132.0
2015-05-18 07:00:00	AAPL	Stock	32.1075	32.1275	32.095	32.1175	27600.0
2015-05-18 07:30:00	AAPL	Stock	32.11	32.11	32.0775	32.1075	48560.0
2015-05-18 08:00:00	AAPL	Stock	32.1025	32.1625	32.005	32.0725	247540.0
2015-05-18 08:30:00	AAPL	Stock	32.075	32.13	32.055	32.1175	167736.0
2015-05-18 09:00:00	AAPL	Stock	32.1125	32.1775	32.095	32.095	383464.0
2015-05-18 09:30:00	AAPL	Stock	32.095	32.3875	32.09	32.3075	22110544.0
2015-05-18 10:00:00	AAPL	Stock	32.3125	32.3625	32.2275	32.2905	11358560.0
2015-05-18 10:30:00	AAPL	Stock	32.2925	32.345	32.1578	32.1948	9960884.0
2015-05-18 11:00:00	AAPL	Stock	32.195	32.5225	32.1875	32.5205	32391660.0
2015-05-18 11:30:00	AAPL	Stock	32.52	32.635	32.52	32.567	20565324.0
2015-05-18 12:00:00	AAPL	Stock	32.565	32.5875	32.4775	32.525	10069736.0
2015-05-18 12:30:00	AAPL	Stock	32.5265	32.62	32.4938	32.59	8580756.0
2015-05-18 13:00:00	AAPL	Stock	32.59	32.68	32.5875	32.645	10739600.0
2015-05-18 13:30:00	AAPL	Stock	32.6438	32.66	32.605	32.63	7107820.0
2015-05-18 14:00:00	AAPL	Stock	32.6325	32.655	32.57	32.61	8237840.0
2015-05-18 14:30:00	AAPL	Stock	32.6075	32.6575	32.58	32.6425	7822380.0
2015-05-18 15:00:00	AAPL	Stock	32.6448	32.6575	32.595	32.6002	8808396.0
2015-05-18 15:30:00	AAPL	Stock	32.6002	32.625	32.5325	32.5425	14447504.0
2015-05-18 16:00:00	AAPL	Stock	32.5475	32.56	32.2785	32.525	16644184.0
2015-05-18 16:30:00	AAPL	Stock	32.525	32.5475	32.5125	32.54	2014472.0
2015-05-18 17:00:00	AAPL	Stock	32.54	32.5475	32.53	32.53	83960.0
2015-05-18 17:30:00	AAPL	Stock	32.5375	32.54	32.5025	32.5375	111808.0
2015-05-18 18:00:00	AAPL	Stock	32.5375	32.555	32.5325	32.5525	65956.0
2015-05-18 18:30:00	AAPL	Stock	32.5575	32.565	32.5525	32.565	53448.0
2015-05-18 19:00:00	AAPL	Stock	32.565	32.5725	32.5625	32.5722	71096.0
2015-05-18 19:30:00	AAPL	Stock	32.5725	32.5875	32.5625	32.565	147108.0
2015-05-18 06:00:00	MSFT	Stock	48.28	48.28	48.21	48.23	3100.0
2015-05-18 07:00:00	MSFT	Stock	48.15	48.15	48.1	48.1	2100.0
2015-05-18 07:30:00	MSFT	Stock	48.15	48.15	48.13	48.13	500.0
2015-05-18 08:00:00	MSFT	Stock	48.11	48.15	48.09	48.11	3900.0
2015-05-18 08:30:00	MSFT	Stock	48.11	48.18	48.11	48.16	5085.0
2015-05-18 09:00:00	MSFT	Stock	48.16	48.19	47.93	47.95	61412.0
2015-05-18 09:30:00	MSFT	Stock	47.98	48.09	47.61	47.82	4174164.0
2015-05-18 10:00:00	MSFT	Stock	47.825	47.86	47.66	47.69	1888876.0
2015-05-18 10:30:00	MSFT	Stock	47.695	47.76	47.63	47.696	1714232.0
2015-05-18 11:00:00	MSFT	Stock	47.7	47.84	47.66	47.82	1435028.0
2015-05-18 11:30:00	MSFT	Stock	47.815	47.89	47.81	47.855	1253692.0
2015-05-18 12:00:00	MSFT	Stock	47.855	47.885	47.78	47.795	936049.0
2015-05-18 12:30:00	MSFT	Stock	47.795	47.94	47.765	47.923	1046161.0
2015-05-18 13:00:00	MSFT	Stock	47.925	47.96	47.87	47.95	837453.0
2015-05-18 13:30:00	MSFT	Stock	47.945	48.02	47.9	47.97	970480.0
2015-05-18 14:00:00	MSFT	Stock	47.965	48.065	47.963	47.985	1019823.0
2015-05-18 14:30:00	MSFT	Stock	47.985	48.165	47.98	48.14	1404250.0
2015-05-18 15:00:00	MSFT	Stock	48.15	48.22	48.1	48.103	1303502.0
2015-05-18 15:30:00	MSFT	Stock	48.105	48.16	48.0	48.0	2406756.0

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

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