PREVIEW / stock_30min / 2014-07-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-30.parquet
  size:    1.6 MB
  rows:    83,152
  symbols: 3,547

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
2014-07-30 04:00:00	AAPL	Stock	24.6125	24.64	24.6125	24.625	3200.0
2014-07-30 05:00:00	AAPL	Stock	24.605	24.6325	24.605	24.6325	15288.0
2014-07-30 05:30:00	AAPL	Stock	24.6325	24.6375	24.6275	24.6375	5204.0
2014-07-30 06:00:00	AAPL	Stock	24.6275	24.6275	24.6275	24.6275	400.0
2014-07-30 06:30:00	AAPL	Stock	24.62	24.6375	24.62	24.6375	23624.0
2014-07-30 07:00:00	AAPL	Stock	24.6375	24.65	24.615	24.65	47400.0
2014-07-30 07:30:00	AAPL	Stock	24.6375	24.655	24.6375	24.645	30444.0
2014-07-30 08:00:00	AAPL	Stock	24.6475	24.65	24.575	24.5875	253428.0
2014-07-30 08:30:00	AAPL	Stock	24.59	24.67	24.59	24.64	410268.0
2014-07-30 09:00:00	AAPL	Stock	24.6475	24.675	24.595	24.6125	281204.0
2014-07-30 09:30:00	AAPL	Stock	24.61	24.675	24.5425	24.579	19842448.0
2014-07-30 10:00:00	AAPL	Stock	24.58	24.6375	24.53	24.6083	11108520.0
2014-07-30 10:30:00	AAPL	Stock	24.6092	24.6475	24.545	24.59	7148576.0
2014-07-30 11:00:00	AAPL	Stock	24.59	24.59	24.5425	24.5538	10014528.0
2014-07-30 11:30:00	AAPL	Stock	24.5525	24.5725	24.445	24.445	10536148.0
2014-07-30 12:00:00	AAPL	Stock	24.4462	24.5175	24.4175	24.4968	9437992.0
2014-07-30 12:30:00	AAPL	Stock	24.4962	24.5625	24.48	24.5325	5136860.0
2014-07-30 13:00:00	AAPL	Stock	24.535	24.5462	24.49	24.5175	4133960.0
2014-07-30 13:30:00	AAPL	Stock	24.5175	24.57	24.5025	24.558	4503688.0
2014-07-30 14:00:00	AAPL	Stock	24.5575	24.65	24.5275	24.6288	11891220.0
2014-07-30 14:30:00	AAPL	Stock	24.6298	24.6475	24.5325	24.57	6554160.0
2014-07-30 15:00:00	AAPL	Stock	24.5725	24.58	24.5025	24.565	7786624.0
2014-07-30 15:30:00	AAPL	Stock	24.5668	24.62	24.5325	24.5325	11330816.0
2014-07-30 16:00:00	AAPL	Stock	24.5325	24.5852	24.5325	24.535	3795156.0
2014-07-30 16:30:00	AAPL	Stock	24.535	24.5375	24.5125	24.535	353100.0
2014-07-30 17:00:00	AAPL	Stock	24.5375	24.5672	24.525	24.5275	40356.0
2014-07-30 17:30:00	AAPL	Stock	24.5275	24.5425	24.5225	24.5425	31356.0
2014-07-30 18:00:00	AAPL	Stock	24.5425	24.5425	24.53	24.53	13784.0
2014-07-30 18:30:00	AAPL	Stock	24.5325	24.54	24.5275	24.5275	37196.0
2014-07-30 19:00:00	AAPL	Stock	24.535	24.5375	24.53	24.5325	12000.0
2014-07-30 19:30:00	AAPL	Stock	24.5375	24.54	24.53	24.535	16224.0
2014-07-30 04:30:00	MSFT	Stock	43.9	43.9	43.9	43.9	400.0
2014-07-30 08:00:00	MSFT	Stock	43.87	43.9	43.87	43.9	233.0
2014-07-30 08:30:00	MSFT	Stock	44.02	44.15	44.0	44.07	31765.0
2014-07-30 09:00:00	MSFT	Stock	44.07	44.07	44.07	44.07	600.0
2014-07-30 09:30:00	MSFT	Stock	44.07	44.1	43.7	43.75	2388835.0
2014-07-30 10:00:00	MSFT	Stock	43.755	43.785	43.51	43.51	2693007.0
2014-07-30 10:30:00	MSFT	Stock	43.51	43.61	43.29	43.43	3824448.0
2014-07-30 11:00:00	MSFT	Stock	43.43	43.485	43.35	43.43	2215337.0
2014-07-30 11:30:00	MSFT	Stock	43.425	43.51	43.42	43.45	923097.0
2014-07-30 12:00:00	MSFT	Stock	43.46	43.55	43.42	43.515	1090664.0
2014-07-30 12:30:00	MSFT	Stock	43.52	43.54	43.46	43.53	935667.0
2014-07-30 13:00:00	MSFT	Stock	43.53	43.54	43.37	43.41	1312236.0
2014-07-30 13:30:00	MSFT	Stock	43.41	43.46	43.38	43.42	1484848.0
2014-07-30 14:00:00	MSFT	Stock	43.42	43.48	43.35	43.4	4241152.0
2014-07-30 14:30:00	MSFT	Stock	43.4	43.42	43.33	43.4	1838226.0
2014-07-30 15:00:00	MSFT	Stock	43.393	43.42	43.33	43.383	1706337.0
2014-07-30 15:30:00	MSFT	Stock	43.39	43.595	43.38	43.58	3668118.0
2014-07-30 16:00:00	MSFT	Stock	43.58	43.59	43.48	43.589	2500797.0
2014-07-30 16:30:00	MSFT	Stock	43.5	43.55	43.5	43.55	600.0

> showing 50 of 83,152 rows — these rows as CSV

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