PREVIEW / stock_30min / 2016-01-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-29.parquet
  size:    1.6 MB
  rows:    84,507
  symbols: 3,407

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
2016-01-29 04:00:00	AAPL	Stock	23.5125	23.5125	23.5125	23.5125	2000.0
2016-01-29 04:30:00	AAPL	Stock	23.6275	23.7075	23.6075	23.7075	29688.0
2016-01-29 05:00:00	AAPL	Stock	23.68	23.695	23.68	23.695	2400.0
2016-01-29 05:30:00	AAPL	Stock	23.665	23.665	23.6025	23.665	40020.0
2016-01-29 06:00:00	AAPL	Stock	23.6575	23.6875	23.615	23.615	59808.0
2016-01-29 06:30:00	AAPL	Stock	23.63	23.6375	23.6125	23.6375	3480.0
2016-01-29 07:00:00	AAPL	Stock	23.6125	23.625	23.5875	23.615	27640.0
2016-01-29 07:30:00	AAPL	Stock	23.615	23.645	23.61	23.615	62940.0
2016-01-29 08:00:00	AAPL	Stock	23.615	23.66	23.54	23.565	167152.0
2016-01-29 08:30:00	AAPL	Stock	23.565	23.625	23.545	23.625	111536.0
2016-01-29 09:00:00	AAPL	Stock	23.6125	23.75	23.565	23.6275	812128.0
2016-01-29 09:30:00	AAPL	Stock	23.63	23.94	23.5875	23.9	30542108.0
2016-01-29 10:00:00	AAPL	Stock	23.9	24.0125	23.8475	23.8575	20473860.0
2016-01-29 10:30:00	AAPL	Stock	23.8575	23.9425	23.8075	23.895	14683008.0
2016-01-29 11:00:00	AAPL	Stock	23.8962	23.955	23.8438	23.885	10494416.0
2016-01-29 11:30:00	AAPL	Stock	23.885	23.94	23.855	23.935	12957564.0
2016-01-29 12:00:00	AAPL	Stock	23.9375	24.0875	23.89	24.06	18239152.0
2016-01-29 12:30:00	AAPL	Stock	24.06	24.0725	23.955	24.048	11603136.0
2016-01-29 13:00:00	AAPL	Stock	24.0475	24.1225	24.0075	24.0892	10654704.0
2016-01-29 13:30:00	AAPL	Stock	24.09	24.1905	24.085	24.18	11824020.0
2016-01-29 14:00:00	AAPL	Stock	24.1797	24.215	24.12	24.2138	9510688.0
2016-01-29 14:30:00	AAPL	Stock	24.215	24.2275	24.1175	24.1612	10983252.0
2016-01-29 15:00:00	AAPL	Stock	24.1625	24.2275	24.1412	24.225	10739188.0
2016-01-29 15:30:00	AAPL	Stock	24.2275	24.305	24.1725	24.285	32003932.0
2016-01-29 16:00:00	AAPL	Stock	24.335	24.335	23.9902	24.2675	33987640.0
2016-01-29 16:30:00	AAPL	Stock	24.2625	24.335	24.2525	24.265	726724.0
2016-01-29 17:00:00	AAPL	Stock	24.2675	24.335	24.265	24.335	115688.0
2016-01-29 17:30:00	AAPL	Stock	24.295	24.295	24.2775	24.2925	30392.0
2016-01-29 18:00:00	AAPL	Stock	24.2875	24.3	24.2825	24.29	22976.0
2016-01-29 18:30:00	AAPL	Stock	24.29	24.3	24.29	24.3	24124.0
2016-01-29 19:00:00	AAPL	Stock	24.2925	24.3075	24.29	24.295	22968.0
2016-01-29 19:30:00	AAPL	Stock	24.305	24.3125	24.29	24.2975	25116.0
2016-01-29 04:00:00	MSFT	Stock	54.25	54.25	54.25	54.25	5448.0
2016-01-29 04:30:00	MSFT	Stock	54.25	54.25	54.0	54.0	1482.0
2016-01-29 05:30:00	MSFT	Stock	53.95	53.95	53.7	53.7	1448.0
2016-01-29 06:00:00	MSFT	Stock	53.88	53.88	53.76	53.85	1459.0
2016-01-29 06:30:00	MSFT	Stock	53.84	54.28	53.8	54.2	58771.0
2016-01-29 07:00:00	MSFT	Stock	54.2	54.75	54.2	54.6	61468.0
2016-01-29 07:30:00	MSFT	Stock	54.63	54.74	54.44	54.46	77299.0
2016-01-29 08:00:00	MSFT	Stock	54.41	54.72	53.82	54.04	306914.0
2016-01-29 08:30:00	MSFT	Stock	54.03	54.34	54.0	54.27	217019.0
2016-01-29 09:00:00	MSFT	Stock	54.28	54.81	54.2	54.73	1031770.0
2016-01-29 09:30:00	MSFT	Stock	54.74	54.79	54.0	54.5	14787103.0
2016-01-29 10:00:00	MSFT	Stock	54.495	54.935	54.43	54.485	6954715.0
2016-01-29 10:30:00	MSFT	Stock	54.49	54.74	54.22	54.315	4358048.0
2016-01-29 11:00:00	MSFT	Stock	54.32	54.49	54.26	54.32	3473113.0
2016-01-29 11:30:00	MSFT	Stock	54.32	54.73	54.32	54.67	3773343.0
2016-01-29 12:00:00	MSFT	Stock	54.68	55.01	54.57	54.994	3558820.0
2016-01-29 12:30:00	MSFT	Stock	54.994	55.0	54.805	54.896	2758309.0
2016-01-29 13:00:00	MSFT	Stock	54.893	54.94	54.79	54.905	2354996.0

> showing 50 of 84,507 rows — these rows as CSV

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