PREVIEW / stock_30min / 2016-01-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-20.parquet
  size:    1.7 MB
  rows:    88,130
  symbols: 3,415

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-20 04:00:00	AAPL	Stock	23.875	23.875	23.4175	23.6225	99668.0
2016-01-20 04:30:00	AAPL	Stock	23.555	23.6825	23.555	23.6825	12940.0
2016-01-20 05:00:00	AAPL	Stock	23.65	23.65	23.5825	23.625	18196.0
2016-01-20 05:30:00	AAPL	Stock	23.625	23.6375	23.585	23.6125	51024.0
2016-01-20 06:00:00	AAPL	Stock	23.635	23.6725	23.6125	23.6525	54612.0
2016-01-20 06:30:00	AAPL	Stock	23.6525	23.6975	23.6125	23.6525	64836.0
2016-01-20 07:00:00	AAPL	Stock	23.67	23.775	23.645	23.7125	133800.0
2016-01-20 07:30:00	AAPL	Stock	23.72	23.75	23.65	23.7	173292.0
2016-01-20 08:00:00	AAPL	Stock	23.715	23.775	23.625	23.7	895288.0
2016-01-20 08:30:00	AAPL	Stock	23.695	23.865	23.6875	23.85	480976.0
2016-01-20 09:00:00	AAPL	Stock	23.8525	23.885	23.7675	23.7775	621992.0
2016-01-20 09:30:00	AAPL	Stock	23.775	23.8675	23.605	23.63	33062980.0
2016-01-20 10:00:00	AAPL	Stock	23.6255	23.7025	23.4775	23.51	22029984.0
2016-01-20 10:30:00	AAPL	Stock	23.5075	23.5275	23.355	23.375	21074584.0
2016-01-20 11:00:00	AAPL	Stock	23.3775	23.5925	23.3625	23.5725	18114516.0
2016-01-20 11:30:00	AAPL	Stock	23.5738	23.715	23.445	23.52	16668680.0
2016-01-20 12:00:00	AAPL	Stock	23.52	23.5922	23.4237	23.5	14077928.0
2016-01-20 12:30:00	AAPL	Stock	23.4988	23.6625	23.4625	23.6425	13936440.0
2016-01-20 13:00:00	AAPL	Stock	23.64	23.725	23.535	23.6775	14607996.0
2016-01-20 13:30:00	AAPL	Stock	23.675	23.95	23.6725	23.899	18308656.0
2016-01-20 14:00:00	AAPL	Stock	23.8995	23.995	23.8025	23.9225	14078580.0
2016-01-20 14:30:00	AAPL	Stock	23.925	24.06	23.8352	23.965	13962624.0
2016-01-20 15:00:00	AAPL	Stock	23.96	24.5475	23.9275	24.5	23577460.0
2016-01-20 15:30:00	AAPL	Stock	24.5	24.5225	24.17	24.2025	27791364.0
2016-01-20 16:00:00	AAPL	Stock	24.2	24.25	24.175	24.2175	16238588.0
2016-01-20 16:30:00	AAPL	Stock	24.2275	24.23	24.1625	24.1875	945860.0
2016-01-20 17:00:00	AAPL	Stock	24.1625	24.2075	24.16	24.195	42328.0
2016-01-20 17:30:00	AAPL	Stock	24.1775	24.1975	24.1775	24.1975	22320.0
2016-01-20 18:00:00	AAPL	Stock	24.1975	24.27	24.1975	24.27	36176.0
2016-01-20 18:30:00	AAPL	Stock	24.2775	24.2875	24.2525	24.275	35696.0
2016-01-20 19:00:00	AAPL	Stock	24.28	24.3125	24.25	24.29	71284.0
2016-01-20 19:30:00	AAPL	Stock	24.2875	24.315	24.275	24.3075	61876.0
2016-01-20 04:00:00	MSFT	Stock	50.01	50.01	49.8	49.8	1265.0
2016-01-20 04:30:00	MSFT	Stock	49.6	49.69	49.6	49.64	2800.0
2016-01-20 05:00:00	MSFT	Stock	49.5	49.5	49.5	49.5	200.0
2016-01-20 05:30:00	MSFT	Stock	49.51	49.51	49.51	49.51	100.0
2016-01-20 06:00:00	MSFT	Stock	49.51	49.51	49.51	49.51	300.0
2016-01-20 06:30:00	MSFT	Stock	49.54	49.63	49.52	49.63	1893.0
2016-01-20 07:00:00	MSFT	Stock	49.6	49.6	49.45	49.57	4266.0
2016-01-20 07:30:00	MSFT	Stock	49.5	49.61	49.5	49.53	2600.0
2016-01-20 08:00:00	MSFT	Stock	49.53	49.72	49.5	49.65	17213.0
2016-01-20 08:30:00	MSFT	Stock	49.64	49.9	49.64	49.85	18636.0
2016-01-20 09:00:00	MSFT	Stock	49.74	49.95	49.65	49.93	78997.0
2016-01-20 09:30:00	MSFT	Stock	49.98	50.199	49.58	49.72	5462346.0
2016-01-20 10:00:00	MSFT	Stock	49.72	50.07	49.52	49.93	4067164.0
2016-01-20 10:30:00	MSFT	Stock	49.93	49.99	49.55	49.636	3217439.0
2016-01-20 11:00:00	MSFT	Stock	49.64	49.9	49.57	49.84	2722617.0
2016-01-20 11:30:00	MSFT	Stock	49.84	50.23	49.69	49.72	3710878.0
2016-01-20 12:00:00	MSFT	Stock	49.728	49.83	49.1	49.264	3841126.0
2016-01-20 12:30:00	MSFT	Stock	49.27	49.78	49.261	49.75	2607087.0

> showing 50 of 88,130 rows — these rows as CSV

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