PREVIEW / stock_30min / 2015-10-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-28.parquet
  size:    1.6 MB
  rows:    82,151
  symbols: 3,430

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-10-28 04:00:00	AAPL	Stock	28.9475	29.0625	28.9475	29.05	83436.0
2015-10-28 04:30:00	AAPL	Stock	29.025	29.155	29.025	29.1475	37520.0
2015-10-28 05:00:00	AAPL	Stock	29.1475	29.175	29.1225	29.165	34152.0
2015-10-28 05:30:00	AAPL	Stock	29.15	29.245	29.1425	29.2	75136.0
2015-10-28 06:00:00	AAPL	Stock	29.1775	29.225	29.1375	29.2	74744.0
2015-10-28 06:30:00	AAPL	Stock	29.2	29.225	29.1375	29.225	120196.0
2015-10-28 07:00:00	AAPL	Stock	29.2375	29.335	29.1525	29.1625	469748.0
2015-10-28 07:30:00	AAPL	Stock	29.1625	29.175	28.9125	29.0	686068.0
2015-10-28 08:00:00	AAPL	Stock	29.02	29.325	28.9225	29.0725	2301704.0
2015-10-28 08:30:00	AAPL	Stock	29.0625	29.22	29.05	29.1875	1733060.0
2015-10-28 09:00:00	AAPL	Stock	29.2	29.25	29.1275	29.25	1778776.0
2015-10-28 09:30:00	AAPL	Stock	29.2325	29.4875	29.0575	29.2275	68300024.0
2015-10-28 10:00:00	AAPL	Stock	29.225	29.25	29.015	29.163	34813232.0
2015-10-28 10:30:00	AAPL	Stock	29.1625	29.2475	29.1425	29.215	18789724.0
2015-10-28 11:00:00	AAPL	Stock	29.2175	29.2975	29.095	29.275	17018780.0
2015-10-28 11:30:00	AAPL	Stock	29.2738	29.3625	29.2725	29.3575	14798940.0
2015-10-28 12:00:00	AAPL	Stock	29.3575	29.51	29.3575	29.485	20050608.0
2015-10-28 12:30:00	AAPL	Stock	29.485	29.4875	29.3568	29.4325	12769776.0
2015-10-28 13:00:00	AAPL	Stock	29.4325	29.5325	29.3875	29.49	13201496.0
2015-10-28 13:30:00	AAPL	Stock	29.49	29.505	29.375	29.4125	14878856.0
2015-10-28 14:00:00	AAPL	Stock	29.4125	29.465	29.2725	29.39	23071328.0
2015-10-28 14:30:00	AAPL	Stock	29.3912	29.53	29.3275	29.5275	15617040.0
2015-10-28 15:00:00	AAPL	Stock	29.525	29.7175	29.375	29.6992	22063028.0
2015-10-28 15:30:00	AAPL	Stock	29.7025	29.825	29.6875	29.825	34155940.0
2015-10-28 16:00:00	AAPL	Stock	29.8175	29.8375	29.8	29.82	6645736.0
2015-10-28 16:30:00	AAPL	Stock	29.8225	29.825	29.77	29.78	1262628.0
2015-10-28 17:00:00	AAPL	Stock	29.775	29.7975	29.775	29.775	84476.0
2015-10-28 17:30:00	AAPL	Stock	29.78	29.78	29.755	29.7625	61284.0
2015-10-28 18:00:00	AAPL	Stock	29.7625	29.7725	29.755	29.77	90164.0
2015-10-28 18:30:00	AAPL	Stock	29.77	29.77	29.7525	29.7525	46828.0
2015-10-28 19:00:00	AAPL	Stock	29.7575	29.7675	29.725	29.725	70152.0
2015-10-28 19:30:00	AAPL	Stock	29.7275	29.75	29.725	29.75	81804.0
2015-10-28 04:00:00	MSFT	Stock	53.7	53.7	53.7	53.7	615.0
2015-10-28 05:00:00	MSFT	Stock	53.7	53.7	53.7	53.7	873.0
2015-10-28 06:00:00	MSFT	Stock	53.65	53.65	53.65	53.65	20100.0
2015-10-28 06:30:00	MSFT	Stock	53.65	53.65	53.63	53.65	827.0
2015-10-28 07:30:00	MSFT	Stock	53.63	53.65	53.63	53.64	2011.0
2015-10-28 08:00:00	MSFT	Stock	53.64	53.64	53.6	53.6	2600.0
2015-10-28 08:30:00	MSFT	Stock	53.63	53.63	53.6	53.6	2200.0
2015-10-28 09:00:00	MSFT	Stock	53.59	53.59	53.56	53.57	1227.0
2015-10-28 09:30:00	MSFT	Stock	53.54	53.775	53.41	53.526	3770593.0
2015-10-28 10:00:00	MSFT	Stock	53.525	53.54	52.955	52.985	4525300.0
2015-10-28 10:30:00	MSFT	Stock	52.99	53.153	52.86	53.0	3890887.0
2015-10-28 11:00:00	MSFT	Stock	53.0	53.44	52.99	53.18	3374780.0
2015-10-28 11:30:00	MSFT	Stock	53.185	53.35	53.11	53.26	2600705.0
2015-10-28 12:00:00	MSFT	Stock	53.255	53.325	53.2	53.265	1722344.0
2015-10-28 12:30:00	MSFT	Stock	53.265	53.355	53.14	53.285	1815304.0
2015-10-28 13:00:00	MSFT	Stock	53.285	53.3	53.165	53.23	1365664.0
2015-10-28 13:30:00	MSFT	Stock	53.235	53.7	53.22	53.65	1955963.0
2015-10-28 14:00:00	MSFT	Stock	53.64	53.65	53.02	53.17	3723620.0

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

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