PREVIEW / stock_30min / 2016-02-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-01.parquet
  size:    1.6 MB
  rows:    82,387
  symbols: 3,372

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-02-01 04:00:00	AAPL	Stock	24.275	24.275	24.1925	24.205	5172.0
2016-02-01 04:30:00	AAPL	Stock	24.1375	24.1375	24.1375	24.1375	3096.0
2016-02-01 05:00:00	AAPL	Stock	24.1375	24.1375	24.135	24.1375	1600.0
2016-02-01 05:30:00	AAPL	Stock	24.175	24.19	24.17	24.1875	7120.0
2016-02-01 06:00:00	AAPL	Stock	24.1875	24.205	24.17	24.1925	10800.0
2016-02-01 06:30:00	AAPL	Stock	24.1975	24.1975	24.15	24.15	5600.0
2016-02-01 07:00:00	AAPL	Stock	24.15	24.15	24.1	24.125	16020.0
2016-02-01 07:30:00	AAPL	Stock	24.1	24.12	24.0325	24.075	47596.0
2016-02-01 08:00:00	AAPL	Stock	24.075	24.17	24.0525	24.0725	191504.0
2016-02-01 08:30:00	AAPL	Stock	24.0775	24.335	24.075	24.1375	390268.0
2016-02-01 09:00:00	AAPL	Stock	24.335	24.335	24.09	24.0925	159824.0
2016-02-01 09:30:00	AAPL	Stock	24.1175	24.1375	23.965	24.015	21588320.0
2016-02-01 10:00:00	AAPL	Stock	24.0125	24.06	23.85	23.8875	15622716.0
2016-02-01 10:30:00	AAPL	Stock	23.8878	24.11	23.87	24.0962	11993336.0
2016-02-01 11:00:00	AAPL	Stock	24.095	24.1162	23.9975	24.0288	10534596.0
2016-02-01 11:30:00	AAPL	Stock	24.03	24.1675	24.0225	24.1025	11291364.0
2016-02-01 12:00:00	AAPL	Stock	24.1075	24.1262	24.025	24.0328	6525376.0
2016-02-01 12:30:00	AAPL	Stock	24.035	24.0588	23.9562	23.98	7544680.0
2016-02-01 13:00:00	AAPL	Stock	23.9825	24.0625	23.9375	24.0538	7814200.0
2016-02-01 13:30:00	AAPL	Stock	24.055	24.06	24.0	24.0535	7226680.0
2016-02-01 14:00:00	AAPL	Stock	24.0535	24.1028	24.0158	24.0975	7703344.0
2016-02-01 14:30:00	AAPL	Stock	24.0978	24.1325	24.0625	24.1175	7382920.0
2016-02-01 15:00:00	AAPL	Stock	24.115	24.1775	24.0625	24.1475	10523044.0
2016-02-01 15:30:00	AAPL	Stock	24.1475	24.17	24.09	24.095	12832572.0
2016-02-01 16:00:00	AAPL	Stock	24.1075	24.335	24.075	24.09	11311324.0
2016-02-01 16:30:00	AAPL	Stock	24.1	24.1	24.0825	24.09	98212.0
2016-02-01 17:00:00	AAPL	Stock	24.0975	24.1	24.0775	24.0775	33508.0
2016-02-01 17:30:00	AAPL	Stock	24.075	24.075	24.07	24.07	3800.0
2016-02-01 18:00:00	AAPL	Stock	24.075	24.075	24.015	24.0625	34824.0
2016-02-01 18:30:00	AAPL	Stock	24.05	24.0575	24.03	24.05	20228.0
2016-02-01 19:00:00	AAPL	Stock	24.0575	24.07	24.045	24.0625	10816.0
2016-02-01 19:30:00	AAPL	Stock	24.0625	24.0625	24.0525	24.0625	16864.0
2016-02-01 04:00:00	MSFT	Stock	54.9	54.9	54.9	54.9	600.0
2016-02-01 05:00:00	MSFT	Stock	54.77	54.77	54.77	54.77	400.0
2016-02-01 06:00:00	MSFT	Stock	54.77	54.87	54.7	54.8	1300.0
2016-02-01 06:30:00	MSFT	Stock	54.79	54.79	54.77	54.77	500.0
2016-02-01 07:00:00	MSFT	Stock	54.71	54.72	54.68	54.68	2401.0
2016-02-01 07:30:00	MSFT	Stock	54.62	54.62	54.46	54.46	4200.0
2016-02-01 08:00:00	MSFT	Stock	54.55	54.89	54.49	54.59	17523.0
2016-02-01 08:30:00	MSFT	Stock	54.56	55.09	54.56	54.58	21864.0
2016-02-01 09:00:00	MSFT	Stock	55.09	55.09	54.61	54.88	43223.0
2016-02-01 09:30:00	MSFT	Stock	54.87	55.09	54.585	54.692	5011469.0
2016-02-01 10:00:00	MSFT	Stock	54.7	55.0	54.5	54.88	3530056.0
2016-02-01 10:30:00	MSFT	Stock	54.89	55.08	54.77	54.95	2487851.0
2016-02-01 11:00:00	MSFT	Stock	54.95	54.99	54.71	54.905	2163234.0
2016-02-01 11:30:00	MSFT	Stock	54.91	55.01	54.75	54.76	1845016.0
2016-02-01 12:00:00	MSFT	Stock	54.77	54.835	54.59	54.64	1903489.0
2016-02-01 12:30:00	MSFT	Stock	54.63	54.803	54.61	54.697	1433697.0
2016-02-01 13:00:00	MSFT	Stock	54.695	54.83	54.63	54.72	1376792.0
2016-02-01 13:30:00	MSFT	Stock	54.715	54.77	54.6	54.735	2184695.0

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

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