PREVIEW / stock_30min / 2014-09-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-04.parquet
  size:    1.6 MB
  rows:    81,698
  symbols: 3,590

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-09-04 04:00:00	AAPL	Stock	25.0	25.0	24.5025	24.565	206304.0
2014-09-04 04:30:00	AAPL	Stock	24.545	24.5575	24.03	24.07	444192.0
2014-09-04 05:00:00	AAPL	Stock	24.0625	24.325	24.0575	24.3025	291220.0
2014-09-04 05:30:00	AAPL	Stock	24.3125	24.4275	24.295	24.3975	292544.0
2014-09-04 06:00:00	AAPL	Stock	24.3925	24.5	24.3125	24.4775	204188.0
2014-09-04 06:30:00	AAPL	Stock	24.4775	24.58	24.4375	24.5725	188856.0
2014-09-04 07:00:00	AAPL	Stock	24.5725	24.6225	24.5325	24.6025	371928.0
2014-09-04 07:30:00	AAPL	Stock	24.61	24.675	24.565	24.6275	569404.0
2014-09-04 08:00:00	AAPL	Stock	24.5525	24.7375	24.4325	24.665	1303988.0
2014-09-04 08:30:00	AAPL	Stock	24.6725	24.9175	24.64	24.9125	2251856.0
2014-09-04 09:00:00	AAPL	Stock	24.9225	24.97	24.7175	24.7175	3608204.0
2014-09-04 09:30:00	AAPL	Stock	24.725	24.95	24.4475	24.91	89207052.0
2014-09-04 10:00:00	AAPL	Stock	24.91	25.0225	24.88	24.9825	34375324.0
2014-09-04 10:30:00	AAPL	Stock	24.98	25.02	24.94	24.985	22653668.0
2014-09-04 11:00:00	AAPL	Stock	24.9825	24.9975	24.8375	24.9172	19667160.0
2014-09-04 11:30:00	AAPL	Stock	24.9172	24.95	24.8525	24.8775	12129416.0
2014-09-04 12:00:00	AAPL	Stock	24.875	24.9225	24.7775	24.8025	12252536.0
2014-09-04 12:30:00	AAPL	Stock	24.802	24.91	24.7775	24.8475	11133780.0
2014-09-04 13:00:00	AAPL	Stock	24.8475	24.8775	24.825	24.8458	7521988.0
2014-09-04 13:30:00	AAPL	Stock	24.8475	24.86	24.76	24.7725	8381388.0
2014-09-04 14:00:00	AAPL	Stock	24.7725	24.8175	24.7525	24.764	10049612.0
2014-09-04 14:30:00	AAPL	Stock	24.7648	24.7675	24.515	24.525	23726864.0
2014-09-04 15:00:00	AAPL	Stock	24.5275	24.56	24.47	24.55	25482300.0
2014-09-04 15:30:00	AAPL	Stock	24.55	24.5672	24.4625	24.5275	27839980.0
2014-09-04 16:00:00	AAPL	Stock	24.53	24.9565	24.5	24.55	5477508.0
2014-09-04 16:30:00	AAPL	Stock	24.545	24.5525	21.3307	24.55	332416.0
2014-09-04 17:00:00	AAPL	Stock	24.55	24.5625	24.53	24.5625	802388.0
2014-09-04 17:30:00	AAPL	Stock	24.565	24.57	24.5525	24.5675	132620.0
2014-09-04 18:00:00	AAPL	Stock	24.5675	24.575	24.565	24.57	99248.0
2014-09-04 18:30:00	AAPL	Stock	24.5725	24.575	24.53	24.5725	208624.0
2014-09-04 19:00:00	AAPL	Stock	24.57	24.575	24.5675	24.5725	40872.0
2014-09-04 19:30:00	AAPL	Stock	24.5725	24.575	24.555	24.57	212220.0
2014-09-04 05:00:00	MSFT	Stock	45.0	45.0	45.0	45.0	900.0
2014-09-04 06:30:00	MSFT	Stock	45.12	45.12	45.12	45.12	100.0
2014-09-04 07:00:00	MSFT	Stock	45.07	45.08	45.07	45.08	980.0
2014-09-04 07:30:00	MSFT	Stock	45.04	45.06	45.04	45.05	600.0
2014-09-04 08:00:00	MSFT	Stock	45.04	45.05	44.93	44.93	4050.0
2014-09-04 08:30:00	MSFT	Stock	44.91	44.97	44.76	44.8	10312.0
2014-09-04 09:00:00	MSFT	Stock	44.77	44.88	44.67	44.73	50401.0
2014-09-04 09:30:00	MSFT	Stock	44.74	45.08	44.72	45.03	3974546.0
2014-09-04 10:00:00	MSFT	Stock	45.025	45.21	45.01	45.035	2567520.0
2014-09-04 10:30:00	MSFT	Stock	45.045	45.16	45.01	45.13	1660825.0
2014-09-04 11:00:00	MSFT	Stock	45.125	45.19	45.02	45.049	1767863.0
2014-09-04 11:30:00	MSFT	Stock	45.045	45.16	45.03	45.13	1262602.0
2014-09-04 12:00:00	MSFT	Stock	45.137	45.16	45.1	45.13	872358.0
2014-09-04 12:30:00	MSFT	Stock	45.135	45.19	45.105	45.165	792671.0
2014-09-04 13:00:00	MSFT	Stock	45.17	45.2	45.15	45.195	574386.0
2014-09-04 13:30:00	MSFT	Stock	45.195	45.21	45.16	45.18	1225389.0
2014-09-04 14:00:00	MSFT	Stock	45.18	45.25	45.151	45.22	1189716.0
2014-09-04 14:30:00	MSFT	Stock	45.22	45.225	45.115	45.155	1670276.0

> showing 50 of 81,698 rows — these rows as CSV

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