PREVIEW / stock_30min / 2014-11-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-03.parquet
  size:    1.6 MB
  rows:    84,390
  symbols: 3,559

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-11-03 04:00:00	AAPL	Stock	27.0	27.0	26.96	26.96	22748.0
2014-11-03 04:30:00	AAPL	Stock	26.9675	26.9675	26.9375	26.9375	11360.0
2014-11-03 05:00:00	AAPL	Stock	26.975	26.98	26.975	26.98	2572.0
2014-11-03 05:30:00	AAPL	Stock	26.99	26.995	26.9775	26.9775	9520.0
2014-11-03 06:00:00	AAPL	Stock	26.9875	27.0	26.9875	27.0	5600.0
2014-11-03 06:30:00	AAPL	Stock	27.025	27.025	26.97	26.975	26640.0
2014-11-03 07:00:00	AAPL	Stock	26.985	26.9875	26.965	26.975	45296.0
2014-11-03 07:30:00	AAPL	Stock	26.975	26.9925	26.9625	26.9925	83208.0
2014-11-03 08:00:00	AAPL	Stock	26.9925	27.035	26.9625	27.035	238516.0
2014-11-03 08:30:00	AAPL	Stock	27.0375	27.095	27.0125	27.0675	339692.0
2014-11-03 09:00:00	AAPL	Stock	27.0675	27.11	27.04	27.055	1231936.0
2014-11-03 09:30:00	AAPL	Stock	27.055	27.2675	27.0025	27.26	32280956.0
2014-11-03 10:00:00	AAPL	Stock	27.26	27.3225	27.23	27.245	20030536.0
2014-11-03 10:30:00	AAPL	Stock	27.2425	27.435	27.2425	27.4298	18880288.0
2014-11-03 11:00:00	AAPL	Stock	27.43	27.475	27.4038	27.4115	21212556.0
2014-11-03 11:30:00	AAPL	Stock	27.4125	27.425	27.3675	27.4	9166708.0
2014-11-03 12:00:00	AAPL	Stock	27.4002	27.435	27.38	27.43	7126552.0
2014-11-03 12:30:00	AAPL	Stock	27.43	27.46	27.4125	27.435	6875116.0
2014-11-03 13:00:00	AAPL	Stock	27.4375	27.455	27.4225	27.4502	5913876.0
2014-11-03 13:30:00	AAPL	Stock	27.4525	27.455	27.39	27.3912	7025592.0
2014-11-03 14:00:00	AAPL	Stock	27.3925	27.415	27.3325	27.3812	9097828.0
2014-11-03 14:30:00	AAPL	Stock	27.38	27.38	27.2325	27.2662	13704008.0
2014-11-03 15:00:00	AAPL	Stock	27.265	27.3425	27.2525	27.255	8845976.0
2014-11-03 15:30:00	AAPL	Stock	27.2575	27.3525	27.2572	27.345	15867764.0
2014-11-03 16:00:00	AAPL	Stock	27.35	27.4448	27.326	27.3475	5280432.0
2014-11-03 16:30:00	AAPL	Stock	27.3475	27.35	27.33	27.3425	311992.0
2014-11-03 17:00:00	AAPL	Stock	27.3425	27.35	27.325	27.325	705528.0
2014-11-03 17:30:00	AAPL	Stock	27.315	27.3608	27.2498	27.3175	93740.0
2014-11-03 18:00:00	AAPL	Stock	27.32	27.3225	27.315	27.3175	36852.0
2014-11-03 18:30:00	AAPL	Stock	27.32	27.35	27.3175	27.32	90648.0
2014-11-03 19:00:00	AAPL	Stock	27.3225	27.35	27.3	27.3	175536.0
2014-11-03 19:30:00	AAPL	Stock	27.31	27.3225	27.2925	27.3125	63968.0
2014-11-03 08:00:00	MSFT	Stock	46.88	46.88	46.82	46.82	1498.0
2014-11-03 08:30:00	MSFT	Stock	46.82	46.95	46.82	46.88	34239.0
2014-11-03 09:00:00	MSFT	Stock	46.88	46.95	46.69	46.76	25684.0
2014-11-03 09:30:00	MSFT	Stock	46.75	47.18	46.73	47.165	3121431.0
2014-11-03 10:00:00	MSFT	Stock	47.17	47.25	47.06	47.22	1930054.0
2014-11-03 10:30:00	MSFT	Stock	47.229	47.28	47.12	47.24	1998832.0
2014-11-03 11:00:00	MSFT	Stock	47.24	47.31	47.16	47.167	1353519.0
2014-11-03 11:30:00	MSFT	Stock	47.17	47.38	47.16	47.325	1337697.0
2014-11-03 12:00:00	MSFT	Stock	47.32	47.33	47.235	47.27	719244.0
2014-11-03 12:30:00	MSFT	Stock	47.265	47.4	47.26	47.364	972489.0
2014-11-03 13:00:00	MSFT	Stock	47.365	47.4	47.31	47.37	839292.0
2014-11-03 13:30:00	MSFT	Stock	47.375	47.45	47.34	47.424	692119.0
2014-11-03 14:00:00	MSFT	Stock	47.421	47.46	47.39	47.405	1054502.0
2014-11-03 14:30:00	MSFT	Stock	47.4	47.41	47.34	47.37	1345180.0
2014-11-03 15:00:00	MSFT	Stock	47.36	47.41	47.295	47.3	1124629.0
2014-11-03 15:30:00	MSFT	Stock	47.3	47.46	47.3	47.43	3150663.0
2014-11-03 16:00:00	MSFT	Stock	47.44	47.45	47.272	47.4	1779028.0
2014-11-03 16:30:00	MSFT	Stock	47.42	47.44	47.377	47.43	69962.0

> showing 50 of 84,390 rows — these rows as CSV

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