PREVIEW / stock_30min / 2014-06-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-12.parquet
  size:    1.6 MB
  rows:    82,173
  symbols: 3,525

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-06-12 04:00:00	AAPL	Stock	23.475	23.475	23.47	23.47	4000.0
2014-06-12 05:30:00	AAPL	Stock	23.4625	23.485	23.4625	23.4625	4516.0
2014-06-12 06:00:00	AAPL	Stock	23.4625	23.5	23.4625	23.4975	17484.0
2014-06-12 06:30:00	AAPL	Stock	23.4875	23.4875	23.475	23.485	8460.0
2014-06-12 07:00:00	AAPL	Stock	23.475	23.4925	23.475	23.4825	36884.0
2014-06-12 07:30:00	AAPL	Stock	23.4925	23.5375	23.4825	23.5175	66740.0
2014-06-12 08:00:00	AAPL	Stock	23.52	23.5325	23.4775	23.5	364220.0
2014-06-12 08:30:00	AAPL	Stock	23.5	23.52	23.485	23.505	176800.0
2014-06-12 09:00:00	AAPL	Stock	23.5	23.53	23.44	23.5	409364.0
2014-06-12 09:30:00	AAPL	Stock	23.51	23.53	23.3275	23.4425	23816864.0
2014-06-12 10:00:00	AAPL	Stock	23.4375	23.46	23.3275	23.33	11461648.0
2014-06-12 10:30:00	AAPL	Stock	23.33	23.3825	23.265	23.345	14245264.0
2014-06-12 11:00:00	AAPL	Stock	23.345	23.3675	23.285	23.3238	8420164.0
2014-06-12 11:30:00	AAPL	Stock	23.3245	23.325	23.27	23.271	7126020.0
2014-06-12 12:00:00	AAPL	Stock	23.27	23.2875	23.185	23.2468	16971868.0
2014-06-12 12:30:00	AAPL	Stock	23.247	23.2475	23.07	23.13	16177220.0
2014-06-12 13:00:00	AAPL	Stock	23.13	23.1375	23.025	23.0585	14475756.0
2014-06-12 13:30:00	AAPL	Stock	23.0575	23.105	23.0175	23.0625	12032648.0
2014-06-12 14:00:00	AAPL	Stock	23.06	23.0675	22.975	23.0162	15670872.0
2014-06-12 14:30:00	AAPL	Stock	23.0175	23.0875	22.975	23.0825	11680724.0
2014-06-12 15:00:00	AAPL	Stock	23.0825	23.085	23.0	23.0588	12308864.0
2014-06-12 15:30:00	AAPL	Stock	23.06	23.075	23.0025	23.065	22014068.0
2014-06-12 16:00:00	AAPL	Stock	23.0675	23.0725	23.0375	23.0625	6220640.0
2014-06-12 16:30:00	AAPL	Stock	23.065	23.0675	23.025	23.04	388440.0
2014-06-12 17:00:00	AAPL	Stock	23.045	23.065	23.04	23.05	125928.0
2014-06-12 17:30:00	AAPL	Stock	23.055	23.06	23.0475	23.0475	64088.0
2014-06-12 18:00:00	AAPL	Stock	23.0425	23.05	23.0375	23.05	51460.0
2014-06-12 18:30:00	AAPL	Stock	23.05	23.055	23.035	23.0425	107864.0
2014-06-12 19:00:00	AAPL	Stock	23.0325	23.0375	23.015	23.015	79120.0
2014-06-12 19:30:00	AAPL	Stock	23.02	23.02	23.0	23.0125	128540.0
2014-06-12 08:00:00	MSFT	Stock	40.86	40.9	40.86	40.9	1500.0
2014-06-12 09:00:00	MSFT	Stock	40.87	40.87	40.8	40.8	3468.0
2014-06-12 09:30:00	MSFT	Stock	40.81	40.88	40.5	40.58	2689396.0
2014-06-12 10:00:00	MSFT	Stock	40.574	40.71	40.46	40.46	1722222.0
2014-06-12 10:30:00	MSFT	Stock	40.46	40.58	40.457	40.525	1298385.0
2014-06-12 11:00:00	MSFT	Stock	40.526	40.68	40.51	40.665	1179977.0
2014-06-12 11:30:00	MSFT	Stock	40.665	40.71	40.59	40.592	716286.0
2014-06-12 12:00:00	MSFT	Stock	40.59	40.62	40.57	40.592	762105.0
2014-06-12 12:30:00	MSFT	Stock	40.59	40.69	40.5	40.555	771644.0
2014-06-12 13:00:00	MSFT	Stock	40.55	40.562	40.45	40.47	2019703.0
2014-06-12 13:30:00	MSFT	Stock	40.48	40.5	40.4	40.46	1236974.0
2014-06-12 14:00:00	MSFT	Stock	40.45	40.49	40.39	40.45	1047710.0
2014-06-12 14:30:00	MSFT	Stock	40.46	40.46	40.37	40.38	1322082.0
2014-06-12 15:00:00	MSFT	Stock	40.385	40.43	40.29	40.36	3201777.0
2014-06-12 15:30:00	MSFT	Stock	40.36	40.6	40.3	40.58	5887129.0
2014-06-12 16:00:00	MSFT	Stock	40.58	41.14	40.322	40.95	4720580.0
2014-06-12 16:30:00	MSFT	Stock	41.0	41.01	40.47	40.9	78961.0
2014-06-12 17:00:00	MSFT	Stock	40.82	40.82	40.58	40.58	35545.0
2014-06-12 17:30:00	MSFT	Stock	40.76	40.92	40.76	40.82	4600.0
2014-06-12 18:00:00	MSFT	Stock	40.9	40.9	40.84	40.86	1600.0

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

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