PREVIEW / stock_30min / 2015-01-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-14.parquet
  size:    1.6 MB
  rows:    84,005
  symbols: 3,535

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-14 04:00:00	AAPL	Stock	27.5425	27.5425	27.4275	27.475	5408.0
2015-01-14 04:30:00	AAPL	Stock	27.5125	27.545	27.42	27.545	18000.0
2015-01-14 05:00:00	AAPL	Stock	27.5675	27.675	27.55	27.55	21672.0
2015-01-14 05:30:00	AAPL	Stock	27.6225	27.625	27.55	27.55	10800.0
2015-01-14 06:00:00	AAPL	Stock	27.5625	27.6175	27.5475	27.5475	9160.0
2015-01-14 06:30:00	AAPL	Stock	27.56	27.5875	27.56	27.5875	3720.0
2015-01-14 07:00:00	AAPL	Stock	27.5525	27.5525	27.4775	27.4875	68664.0
2015-01-14 07:30:00	AAPL	Stock	27.495	27.495	27.435	27.4625	76416.0
2015-01-14 08:00:00	AAPL	Stock	27.4725	27.5225	27.3925	27.405	471296.0
2015-01-14 08:30:00	AAPL	Stock	27.405	27.4075	27.155	27.225	1778572.0
2015-01-14 09:00:00	AAPL	Stock	27.225	27.2725	27.1775	27.2325	654044.0
2015-01-14 09:30:00	AAPL	Stock	27.235	27.6225	27.235	27.4375	27072368.0
2015-01-14 10:00:00	AAPL	Stock	27.4372	27.5872	27.41	27.4825	14127128.0
2015-01-14 10:30:00	AAPL	Stock	27.48	27.4875	27.315	27.3975	13260120.0
2015-01-14 11:00:00	AAPL	Stock	27.4	27.415	27.2625	27.315	10001676.0
2015-01-14 11:30:00	AAPL	Stock	27.3162	27.3975	27.23	27.2825	12343792.0
2015-01-14 12:00:00	AAPL	Stock	27.2872	27.325	27.2125	27.275	8741632.0
2015-01-14 12:30:00	AAPL	Stock	27.275	27.3175	27.1825	27.2725	8553444.0
2015-01-14 13:00:00	AAPL	Stock	27.275	27.3	27.1925	27.225	6770148.0
2015-01-14 13:30:00	AAPL	Stock	27.225	27.245	27.125	27.23	11126092.0
2015-01-14 14:00:00	AAPL	Stock	27.2322	27.45	27.205	27.4375	13516288.0
2015-01-14 14:30:00	AAPL	Stock	27.44	27.495	27.27	27.2728	11836236.0
2015-01-14 15:00:00	AAPL	Stock	27.275	27.4675	27.268	27.435	11447416.0
2015-01-14 15:30:00	AAPL	Stock	27.4338	27.475	27.345	27.4475	17823180.0
2015-01-14 16:00:00	AAPL	Stock	27.45	27.48	27.361	27.45	12008060.0
2015-01-14 16:30:00	AAPL	Stock	27.47	27.5	27.25	27.495	945804.0
2015-01-14 17:00:00	AAPL	Stock	27.495	27.4975	27.3342	27.4675	670548.0
2015-01-14 17:30:00	AAPL	Stock	27.465	27.4975	27.45	27.495	95980.0
2015-01-14 18:00:00	AAPL	Stock	27.495	27.5475	27.45	27.5	196796.0
2015-01-14 18:30:00	AAPL	Stock	27.45	27.545	27.45	27.5325	320724.0
2015-01-14 19:00:00	AAPL	Stock	27.535	27.5375	27.52	27.5325	52120.0
2015-01-14 19:30:00	AAPL	Stock	27.53	27.53	27.495	27.495	203692.0
2015-01-14 04:00:00	MSFT	Stock	46.25	46.25	46.25	46.25	400.0
2015-01-14 04:30:00	MSFT	Stock	46.32	46.32	46.32	46.32	800.0
2015-01-14 05:00:00	MSFT	Stock	46.35	46.35	46.35	46.35	600.0
2015-01-14 06:00:00	MSFT	Stock	46.33	46.33	46.33	46.33	100.0
2015-01-14 06:30:00	MSFT	Stock	46.28	46.34	46.28	46.34	363.0
2015-01-14 07:00:00	MSFT	Stock	46.21	46.21	46.2	46.2	200.0
2015-01-14 07:30:00	MSFT	Stock	46.12	46.12	46.11	46.11	797.0
2015-01-14 08:00:00	MSFT	Stock	46.13	46.14	46.0	46.0	1850.0
2015-01-14 08:30:00	MSFT	Stock	46.0	46.08	45.78	45.79	28346.0
2015-01-14 09:00:00	MSFT	Stock	45.83	45.95	45.79	45.95	14251.0
2015-01-14 09:30:00	MSFT	Stock	45.96	46.24	45.83	45.99	3334489.0
2015-01-14 10:00:00	MSFT	Stock	45.99	46.195	45.93	46.16	2446469.0
2015-01-14 10:30:00	MSFT	Stock	46.16	46.165	45.93	46.0	2073050.0
2015-01-14 11:00:00	MSFT	Stock	46.0	46.015	45.87	45.9	1737993.0
2015-01-14 11:30:00	MSFT	Stock	45.9	46.1	45.86	45.95	1326350.0
2015-01-14 12:00:00	MSFT	Stock	45.95	46.016	45.83	45.978	1053408.0
2015-01-14 12:30:00	MSFT	Stock	45.98	46.035	45.84	45.925	1055375.0
2015-01-14 13:00:00	MSFT	Stock	45.925	45.97	45.79	45.816	882069.0

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

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