PREVIEW / stock_30min / 2016-01-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-07.parquet
  size:    1.7 MB
  rows:    86,007
  symbols: 3,420

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-07 04:00:00	AAPL	Stock	23.9975	25.1475	23.9975	24.175	273436.0
2016-01-07 04:30:00	AAPL	Stock	24.1775	24.3875	24.175	24.375	95368.0
2016-01-07 05:00:00	AAPL	Stock	24.39	24.49	24.3	24.355	124912.0
2016-01-07 05:30:00	AAPL	Stock	24.3025	24.41	24.3	24.3675	89480.0
2016-01-07 06:00:00	AAPL	Stock	24.375	24.5125	24.3675	24.4375	114568.0
2016-01-07 06:30:00	AAPL	Stock	24.4375	24.46	24.325	24.335	153752.0
2016-01-07 07:00:00	AAPL	Stock	24.35	24.5	24.325	24.4875	321792.0
2016-01-07 07:30:00	AAPL	Stock	24.47	24.5	24.4125	24.4675	421608.0
2016-01-07 08:00:00	AAPL	Stock	24.485	24.5175	24.325	24.495	801868.0
2016-01-07 08:30:00	AAPL	Stock	24.495	24.7175	24.4875	24.705	1143452.0
2016-01-07 09:00:00	AAPL	Stock	24.7	24.75	24.61	24.6425	1045368.0
2016-01-07 09:30:00	AAPL	Stock	24.6575	24.9075	24.44	24.7475	48090880.0
2016-01-07 10:00:00	AAPL	Stock	24.7475	24.875	24.6075	24.8375	21555216.0
2016-01-07 10:30:00	AAPL	Stock	24.84	25.0	24.82	24.9475	20838068.0
2016-01-07 11:00:00	AAPL	Stock	24.949	25.0325	24.8078	24.815	14060460.0
2016-01-07 11:30:00	AAPL	Stock	24.815	24.865	24.7025	24.7512	11565116.0
2016-01-07 12:00:00	AAPL	Stock	24.7525	24.7825	24.6525	24.675	10405736.0
2016-01-07 12:30:00	AAPL	Stock	24.6725	24.6875	24.5175	24.546	12193384.0
2016-01-07 13:00:00	AAPL	Stock	24.5425	24.5575	24.4175	24.486	19919948.0
2016-01-07 13:30:00	AAPL	Stock	24.4875	24.535	24.425	24.4455	19032364.0
2016-01-07 14:00:00	AAPL	Stock	24.4475	24.4675	24.2975	24.3075	17071324.0
2016-01-07 14:30:00	AAPL	Stock	24.305	24.4125	24.17	24.2925	21827940.0
2016-01-07 15:00:00	AAPL	Stock	24.2875	24.3675	24.15	24.15	17754936.0
2016-01-07 15:30:00	AAPL	Stock	24.15	24.345	24.1075	24.135	38038740.0
2016-01-07 16:00:00	AAPL	Stock	24.1125	24.2325	23.94	24.0	17837872.0
2016-01-07 16:30:00	AAPL	Stock	24.01	24.0275	23.9025	24.0	577592.0
2016-01-07 17:00:00	AAPL	Stock	23.975	24.1125	23.95	23.9825	421188.0
2016-01-07 17:30:00	AAPL	Stock	23.9825	24.0	23.9575	23.975	320028.0
2016-01-07 18:00:00	AAPL	Stock	23.9675	23.9925	23.925	23.945	319452.0
2016-01-07 18:30:00	AAPL	Stock	23.945	23.995	23.925	23.93	220380.0
2016-01-07 19:00:00	AAPL	Stock	23.93	23.9375	23.875	23.8875	154688.0
2016-01-07 19:30:00	AAPL	Stock	23.8875	23.9225	23.85	23.9025	208556.0
2016-01-07 04:00:00	MSFT	Stock	53.61	53.61	52.47	52.47	3200.0
2016-01-07 04:30:00	MSFT	Stock	52.61	52.65	52.5	52.65	1548.0
2016-01-07 05:00:00	MSFT	Stock	52.63	52.63	52.63	52.63	500.0
2016-01-07 06:00:00	MSFT	Stock	52.51	52.73	52.5	52.65	6100.0
2016-01-07 06:30:00	MSFT	Stock	52.66	52.66	52.43	52.43	11576.0
2016-01-07 07:00:00	MSFT	Stock	52.46	52.74	52.43	52.72	9730.0
2016-01-07 07:30:00	MSFT	Stock	52.6	52.74	52.6	52.65	21075.0
2016-01-07 08:00:00	MSFT	Stock	52.65	52.7	52.25	52.36	44097.0
2016-01-07 08:30:00	MSFT	Stock	52.4	52.73	52.3	52.7	70917.0
2016-01-07 09:00:00	MSFT	Stock	52.65	52.81	52.55	52.73	70226.0
2016-01-07 09:30:00	MSFT	Stock	52.7	52.96	52.07	52.73	8023322.0
2016-01-07 10:00:00	MSFT	Stock	52.72	53.02	52.54	52.86	4136164.0
2016-01-07 10:30:00	MSFT	Stock	52.86	53.485	52.85	53.305	4471126.0
2016-01-07 11:00:00	MSFT	Stock	53.305	53.33	52.84	52.9	2817419.0
2016-01-07 11:30:00	MSFT	Stock	52.9	53.09	52.79	52.85	1963770.0
2016-01-07 12:00:00	MSFT	Stock	52.856	52.91	52.74	52.81	1624990.0
2016-01-07 12:30:00	MSFT	Stock	52.809	52.91	52.74	52.78	1422446.0
2016-01-07 13:00:00	MSFT	Stock	52.777	52.83	52.38	52.64	3061768.0

> showing 50 of 86,007 rows — these rows as CSV

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