PREVIEW / stock_30min / 2015-01-26

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-26.parquet
  size:    1.6 MB
  rows:    85,425
  symbols: 3,532

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-01-26 04:00:00	AAPL	Stock	28.1375	28.2875	28.1375	28.2875	38544.0
2015-01-26 04:30:00	AAPL	Stock	28.25	28.395	28.245	28.395	120220.0
2015-01-26 05:00:00	AAPL	Stock	28.3575	28.3975	28.3575	28.365	6400.0
2015-01-26 05:30:00	AAPL	Stock	28.395	28.395	28.3275	28.3375	12752.0
2015-01-26 06:00:00	AAPL	Stock	28.3525	28.4625	28.3525	28.425	52196.0
2015-01-26 06:30:00	AAPL	Stock	28.3925	28.3925	28.3175	28.325	64216.0
2015-01-26 07:00:00	AAPL	Stock	28.325	28.42	28.325	28.4	154748.0
2015-01-26 07:30:00	AAPL	Stock	28.4	28.485	28.3975	28.485	209804.0
2015-01-26 08:00:00	AAPL	Stock	28.485	28.485	28.245	28.4375	942800.0
2015-01-26 08:30:00	AAPL	Stock	28.4375	28.5025	28.435	28.4825	902096.0
2015-01-26 09:00:00	AAPL	Stock	28.4825	28.4875	28.41	28.41	951516.0
2015-01-26 09:30:00	AAPL	Stock	28.41	28.4775	28.2825	28.4195	31041020.0
2015-01-26 10:00:00	AAPL	Stock	28.4225	28.46	28.315	28.4012	15420480.0
2015-01-26 10:30:00	AAPL	Stock	28.4	28.5625	28.375	28.555	15833192.0
2015-01-26 11:00:00	AAPL	Stock	28.555	28.5908	28.4775	28.5025	13376988.0
2015-01-26 11:30:00	AAPL	Stock	28.5025	28.5175	28.3775	28.3968	12042280.0
2015-01-26 12:00:00	AAPL	Stock	28.3975	28.4375	28.346	28.4075	10957148.0
2015-01-26 12:30:00	AAPL	Stock	28.4075	28.42	28.355	28.3825	6781580.0
2015-01-26 13:00:00	AAPL	Stock	28.3825	28.395	28.3275	28.375	6557228.0
2015-01-26 13:30:00	AAPL	Stock	28.375	28.4475	28.375	28.4148	8325372.0
2015-01-26 14:00:00	AAPL	Stock	28.4172	28.4525	28.385	28.4175	9214040.0
2015-01-26 14:30:00	AAPL	Stock	28.42	28.435	28.225	28.286	14518912.0
2015-01-26 15:00:00	AAPL	Stock	28.2875	28.345	28.235	28.2575	12240272.0
2015-01-26 15:30:00	AAPL	Stock	28.2575	28.315	28.2	28.2725	18747900.0
2015-01-26 16:00:00	AAPL	Stock	28.275	28.4665	28.225	28.295	21737884.0
2015-01-26 16:30:00	AAPL	Stock	28.2975	28.325	28.275	28.3225	186324.0
2015-01-26 17:00:00	AAPL	Stock	28.315	28.3225	28.275	28.3	111100.0
2015-01-26 17:30:00	AAPL	Stock	28.3	28.35	28.2975	28.35	197688.0
2015-01-26 18:00:00	AAPL	Stock	28.35	28.3625	28.3275	28.36	89012.0
2015-01-26 18:30:00	AAPL	Stock	28.355	28.3625	28.3375	28.36	82124.0
2015-01-26 19:00:00	AAPL	Stock	28.355	28.36	28.3375	28.35	44156.0
2015-01-26 19:30:00	AAPL	Stock	28.3375	28.3725	28.3375	28.37	174812.0
2015-01-26 04:30:00	MSFT	Stock	47.24	47.24	47.24	47.24	2100.0
2015-01-26 05:00:00	MSFT	Stock	47.27	47.36	47.27	47.36	220.0
2015-01-26 05:30:00	MSFT	Stock	47.27	47.27	47.24	47.24	500.0
2015-01-26 06:00:00	MSFT	Stock	47.35	47.41	47.35	47.41	900.0
2015-01-26 06:30:00	MSFT	Stock	47.38	47.46	47.27	47.27	8253.0
2015-01-26 07:00:00	MSFT	Stock	47.24	47.39	47.24	47.39	8062.0
2015-01-26 07:30:00	MSFT	Stock	47.39	47.44	47.33	47.33	16265.0
2015-01-26 08:00:00	MSFT	Stock	47.4	47.44	47.31	47.44	31634.0
2015-01-26 08:30:00	MSFT	Stock	47.45	47.48	47.4	47.43	20944.0
2015-01-26 09:00:00	MSFT	Stock	47.45	47.45	46.83	46.99	120367.0
2015-01-26 09:30:00	MSFT	Stock	47.0	47.134	46.63	46.737	4181168.0
2015-01-26 10:00:00	MSFT	Stock	46.737	46.81	46.49	46.51	2826983.0
2015-01-26 10:30:00	MSFT	Stock	46.51	46.64	46.47	46.62	2451414.0
2015-01-26 11:00:00	MSFT	Stock	46.626	46.626	46.3	46.33	2105662.0
2015-01-26 11:30:00	MSFT	Stock	46.33	46.43	46.24	46.37	2457139.0
2015-01-26 12:00:00	MSFT	Stock	46.37	46.55	46.36	46.485	1236917.0
2015-01-26 12:30:00	MSFT	Stock	46.485	46.62	46.48	46.53	1289999.0
2015-01-26 13:00:00	MSFT	Stock	46.53	46.61	46.48	46.53	913284.0

> showing 50 of 85,425 rows — these rows as CSV

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