PREVIEW / stock_30min / 2014-11-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-06.parquet
  size:    1.6 MB
  rows:    82,814
  symbols: 3,541

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-06 04:00:00	AAPL	Stock	27.125	27.125	27.0825	27.0975	10760.0
2014-11-06 04:30:00	AAPL	Stock	27.09	27.1	27.09	27.0975	34532.0
2014-11-06 05:00:00	AAPL	Stock	27.105	27.105	27.105	27.105	800.0
2014-11-06 05:30:00	AAPL	Stock	27.11	27.125	27.11	27.125	5960.0
2014-11-06 06:00:00	AAPL	Stock	27.16	27.1625	27.125	27.125	8400.0
2014-11-06 06:30:00	AAPL	Stock	27.145	27.145	27.125	27.135	8536.0
2014-11-06 07:00:00	AAPL	Stock	27.145	27.1625	27.125	27.1475	80560.0
2014-11-06 07:30:00	AAPL	Stock	27.135	27.135	27.09	27.09	111344.0
2014-11-06 08:00:00	AAPL	Stock	27.0925	27.16	27.0875	27.1	360336.0
2014-11-06 08:30:00	AAPL	Stock	27.1	27.1525	27.0875	27.115	580832.0
2014-11-06 09:00:00	AAPL	Stock	27.12	27.1375	27.1	27.1275	327440.0
2014-11-06 09:30:00	AAPL	Stock	27.13	27.1625	27.015	27.0675	22498924.0
2014-11-06 10:00:00	AAPL	Stock	27.065	27.07	26.95	27.0275	12873280.0
2014-11-06 10:30:00	AAPL	Stock	27.025	27.1225	27.0025	27.1185	8959604.0
2014-11-06 11:00:00	AAPL	Stock	27.1178	27.1625	27.105	27.131	9628784.0
2014-11-06 11:30:00	AAPL	Stock	27.13	27.1475	27.09	27.1225	5821968.0
2014-11-06 12:00:00	AAPL	Stock	27.12	27.1425	27.1082	27.1352	4079644.0
2014-11-06 12:30:00	AAPL	Stock	27.135	27.1375	27.0525	27.055	6166820.0
2014-11-06 13:00:00	AAPL	Stock	27.0575	27.1175	27.05	27.11	4798880.0
2014-11-06 13:30:00	AAPL	Stock	27.11	27.13	27.0775	27.115	6054040.0
2014-11-06 14:00:00	AAPL	Stock	27.1175	27.1175	27.0975	27.1	4246224.0
2014-11-06 14:30:00	AAPL	Stock	27.1	27.11	27.08	27.085	4407012.0
2014-11-06 15:00:00	AAPL	Stock	27.0858	27.1375	27.055	27.135	11683500.0
2014-11-06 15:30:00	AAPL	Stock	27.1325	27.1975	27.1325	27.1725	15134064.0
2014-11-06 16:00:00	AAPL	Stock	27.1725	27.18	27.1095	27.17	8249056.0
2014-11-06 16:30:00	AAPL	Stock	27.175	27.175	27.1165	27.159	128868.0
2014-11-06 17:00:00	AAPL	Stock	27.1575	27.175	27.1525	27.1525	393972.0
2014-11-06 17:30:00	AAPL	Stock	27.1625	27.175	27.1625	27.165	37744.0
2014-11-06 18:00:00	AAPL	Stock	27.1575	27.175	27.1575	27.165	748788.0
2014-11-06 18:30:00	AAPL	Stock	27.16	27.1725	27.1575	27.1625	18856.0
2014-11-06 19:00:00	AAPL	Stock	27.1675	27.17	27.1625	27.1675	18368.0
2014-11-06 19:30:00	AAPL	Stock	27.1725	27.19	27.155	27.19	92088.0
2014-11-06 07:00:00	MSFT	Stock	47.77	47.77	47.76	47.77	1551.0
2014-11-06 07:30:00	MSFT	Stock	47.77	47.84	47.77	47.84	827.0
2014-11-06 08:00:00	MSFT	Stock	47.82	47.85	47.81	47.85	2440.0
2014-11-06 08:30:00	MSFT	Stock	47.89	48.11	47.89	48.09	13779.0
2014-11-06 09:00:00	MSFT	Stock	48.02	48.02	47.83	47.87	28279.0
2014-11-06 09:30:00	MSFT	Stock	47.86	48.275	47.79	48.26	4119452.0
2014-11-06 10:00:00	MSFT	Stock	48.26	48.5	48.26	48.45	3694561.0
2014-11-06 10:30:00	MSFT	Stock	48.44	48.45	48.3	48.39	2129698.0
2014-11-06 11:00:00	MSFT	Stock	48.38	48.54	48.34	48.355	2677672.0
2014-11-06 11:30:00	MSFT	Stock	48.35	48.37	48.28	48.316	1196579.0
2014-11-06 12:00:00	MSFT	Stock	48.315	48.32	48.17	48.26	1596954.0
2014-11-06 12:30:00	MSFT	Stock	48.26	48.38	48.22	48.38	1512036.0
2014-11-06 13:00:00	MSFT	Stock	48.37	48.57	48.37	48.57	1488822.0
2014-11-06 13:30:00	MSFT	Stock	48.56	48.59	48.47	48.503	1240126.0
2014-11-06 14:00:00	MSFT	Stock	48.51	48.63	48.45	48.62	1174253.0
2014-11-06 14:30:00	MSFT	Stock	48.62	48.74	48.573	48.73	1622328.0
2014-11-06 15:00:00	MSFT	Stock	48.72	48.74	48.63	48.72	2323218.0
2014-11-06 15:30:00	MSFT	Stock	48.72	48.86	48.66	48.69	4589336.0

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

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