PREVIEW / stock_30min / 2014-08-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-13.parquet
  size:    1.6 MB
  rows:    82,573
  symbols: 3,571

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-08-13 04:00:00	AAPL	Stock	24.0725	24.0725	24.055	24.055	5800.0
2014-08-13 04:30:00	AAPL	Stock	24.055	24.055	24.0025	24.0225	51176.0
2014-08-13 05:00:00	AAPL	Stock	24.0275	24.0275	23.9975	23.9975	34384.0
2014-08-13 05:30:00	AAPL	Stock	24.025	24.0275	24.025	24.0275	3120.0
2014-08-13 06:00:00	AAPL	Stock	24.0275	24.0475	24.0275	24.045	6004.0
2014-08-13 06:30:00	AAPL	Stock	24.0525	24.07	24.05	24.065	26840.0
2014-08-13 07:00:00	AAPL	Stock	24.0625	24.0975	24.0525	24.0975	36164.0
2014-08-13 07:30:00	AAPL	Stock	24.0925	24.095	24.0775	24.0875	53460.0
2014-08-13 08:00:00	AAPL	Stock	24.0875	24.0975	24.0375	24.05	288948.0
2014-08-13 08:30:00	AAPL	Stock	24.055	24.0625	24.04	24.05	151524.0
2014-08-13 09:00:00	AAPL	Stock	24.0575	24.0575	24.025	24.0375	208912.0
2014-08-13 09:30:00	AAPL	Stock	24.035	24.1275	24.01	24.0775	17009216.0
2014-08-13 10:00:00	AAPL	Stock	24.0765	24.1575	24.075	24.155	11874412.0
2014-08-13 10:30:00	AAPL	Stock	24.155	24.1725	24.126	24.16	7150248.0
2014-08-13 11:00:00	AAPL	Stock	24.16	24.21	24.1598	24.2008	9929252.0
2014-08-13 11:30:00	AAPL	Stock	24.2	24.2375	24.19	24.1975	7529388.0
2014-08-13 12:00:00	AAPL	Stock	24.1962	24.21	24.165	24.205	4983676.0
2014-08-13 12:30:00	AAPL	Stock	24.2025	24.2125	24.18	24.205	3433316.0
2014-08-13 13:00:00	AAPL	Stock	24.205	24.2275	24.19	24.2125	3973688.0
2014-08-13 13:30:00	AAPL	Stock	24.21	24.27	24.21	24.2675	7032316.0
2014-08-13 14:00:00	AAPL	Stock	24.27	24.2775	24.215	24.265	8572384.0
2014-08-13 14:30:00	AAPL	Stock	24.265	24.2775	24.235	24.2665	4362988.0
2014-08-13 15:00:00	AAPL	Stock	24.2653	24.2975	24.24	24.2922	8073496.0
2014-08-13 15:30:00	AAPL	Stock	24.2925	24.3075	24.265	24.3075	16688864.0
2014-08-13 16:00:00	AAPL	Stock	24.31	24.325	24.1865	24.31	5579164.0
2014-08-13 16:30:00	AAPL	Stock	24.3225	24.325	24.2875	24.3175	92936.0
2014-08-13 17:00:00	AAPL	Stock	24.31	24.3175	24.0278	24.0748	250868.0
2014-08-13 17:30:00	AAPL	Stock	24.31	24.325	24.31	24.32	33124.0
2014-08-13 18:00:00	AAPL	Stock	24.315	24.3275	24.3125	24.32	26284.0
2014-08-13 18:30:00	AAPL	Stock	24.325	24.3275	24.325	24.3275	15512.0
2014-08-13 19:00:00	AAPL	Stock	24.32	24.3275	24.32	24.325	21552.0
2014-08-13 19:30:00	AAPL	Stock	24.325	24.33	24.3125	24.32	56072.0
2014-08-13 08:00:00	MSFT	Stock	43.65	43.74	43.65	43.74	525.0
2014-08-13 09:00:00	MSFT	Stock	43.66	43.7	43.65	43.65	4400.0
2014-08-13 09:30:00	MSFT	Stock	43.68	43.85	43.52	43.58	3030785.0
2014-08-13 10:00:00	MSFT	Stock	43.58	43.775	43.56	43.745	2183224.0
2014-08-13 10:30:00	MSFT	Stock	43.745	43.85	43.71	43.83	1965199.0
2014-08-13 11:00:00	MSFT	Stock	43.83	44.0	43.83	43.951	1479484.0
2014-08-13 11:30:00	MSFT	Stock	43.951	44.0	43.89	43.89	925188.0
2014-08-13 12:00:00	MSFT	Stock	43.89	43.99	43.86	43.98	1328909.0
2014-08-13 12:30:00	MSFT	Stock	43.975	44.18	43.97	44.07	1666121.0
2014-08-13 13:00:00	MSFT	Stock	44.06	44.085	44.01	44.03	1180337.0
2014-08-13 13:30:00	MSFT	Stock	44.04	44.12	43.95	43.955	1105809.0
2014-08-13 14:00:00	MSFT	Stock	43.955	44.0	43.94	43.98	825393.0
2014-08-13 14:30:00	MSFT	Stock	43.985	44.08	43.97	44.04	865342.0
2014-08-13 15:00:00	MSFT	Stock	44.043	44.05	43.98	44.01	1292746.0
2014-08-13 15:30:00	MSFT	Stock	44.01	44.1	44.0	44.08	2732091.0
2014-08-13 16:00:00	MSFT	Stock	44.08	44.15	43.911	44.11	1184638.0
2014-08-13 16:30:00	MSFT	Stock	44.08	44.12	44.04	44.04	5044.0
2014-08-13 17:00:00	MSFT	Stock	44.08	44.1	43.628	43.628	71535.0

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

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