PREVIEW / stock_30min / 2014-12-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-09.parquet
  size:    1.7 MB
  rows:    85,659
  symbols: 3,546

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-12-09 04:00:00	AAPL	Stock	28.0875	28.0875	27.7125	27.7575	57884.0
2014-12-09 04:30:00	AAPL	Stock	27.7575	27.805	27.675	27.72	178944.0
2014-12-09 05:00:00	AAPL	Stock	27.72	27.765	27.6875	27.755	39076.0
2014-12-09 05:30:00	AAPL	Stock	27.765	27.8	27.6875	27.795	69660.0
2014-12-09 06:00:00	AAPL	Stock	27.7875	27.8875	27.785	27.875	94668.0
2014-12-09 06:30:00	AAPL	Stock	27.8575	27.9	27.82	27.8225	21972.0
2014-12-09 07:00:00	AAPL	Stock	27.835	27.86	27.7875	27.8125	92256.0
2014-12-09 07:30:00	AAPL	Stock	27.8075	27.8175	27.74	27.7875	346176.0
2014-12-09 08:00:00	AAPL	Stock	27.7888	27.8925	27.6775	27.7212	1244076.0
2014-12-09 08:30:00	AAPL	Stock	27.725	27.7375	27.64	27.7	906440.0
2014-12-09 09:00:00	AAPL	Stock	27.7025	28.1	27.525	27.55	2164388.0
2014-12-09 09:30:00	AAPL	Stock	27.5525	27.875	27.3375	27.825	50073676.0
2014-12-09 10:00:00	AAPL	Stock	27.8375	27.905	27.6275	27.6375	18532988.0
2014-12-09 10:30:00	AAPL	Stock	27.6375	27.8875	27.5675	27.7825	17768432.0
2014-12-09 11:00:00	AAPL	Stock	27.7825	28.0025	27.7825	27.9775	13184984.0
2014-12-09 11:30:00	AAPL	Stock	27.9775	27.9875	27.8575	27.925	9541452.0
2014-12-09 12:00:00	AAPL	Stock	27.925	28.0475	27.9025	28.0038	9758032.0
2014-12-09 12:30:00	AAPL	Stock	28.0025	28.21	27.9675	28.2	12181396.0
2014-12-09 13:00:00	AAPL	Stock	28.2	28.3438	28.17	28.3	14767408.0
2014-12-09 13:30:00	AAPL	Stock	28.3	28.415	28.3	28.36	11568188.0
2014-12-09 14:00:00	AAPL	Stock	28.36	28.375	28.2875	28.3225	6702892.0
2014-12-09 14:30:00	AAPL	Stock	28.3175	28.325	28.2075	28.2828	7929556.0
2014-12-09 15:00:00	AAPL	Stock	28.285	28.46	28.2762	28.4125	10206728.0
2014-12-09 15:30:00	AAPL	Stock	28.41	28.575	28.41	28.5325	21021804.0
2014-12-09 16:00:00	AAPL	Stock	28.535	28.545	27.9092	28.5028	15237676.0
2014-12-09 16:30:00	AAPL	Stock	28.425	28.5328	27.807	28.53	179852.0
2014-12-09 17:00:00	AAPL	Stock	28.5275	28.5325	28.5075	28.5075	27520.0
2014-12-09 17:30:00	AAPL	Stock	28.505	28.53	28.505	28.5225	170704.0
2014-12-09 18:00:00	AAPL	Stock	28.525	28.54	28.525	28.5325	47244.0
2014-12-09 18:30:00	AAPL	Stock	28.5375	28.5375	28.525	28.53	45116.0
2014-12-09 19:00:00	AAPL	Stock	28.535	28.54	28.0905	28.54	36156.0
2014-12-09 19:30:00	AAPL	Stock	28.54	28.5625	28.5375	28.55	67280.0
2014-12-09 06:30:00	MSFT	Stock	47.4	47.4	47.4	47.4	100.0
2014-12-09 07:00:00	MSFT	Stock	47.45	47.45	47.45	47.45	1000.0
2014-12-09 07:30:00	MSFT	Stock	47.36	47.36	47.31	47.31	200.0
2014-12-09 08:00:00	MSFT	Stock	47.4	47.45	47.3	47.3	8002.0
2014-12-09 08:30:00	MSFT	Stock	47.3	47.3	47.01	47.09	15393.0
2014-12-09 09:00:00	MSFT	Stock	47.1	47.18	47.06	47.18	12626.0
2014-12-09 09:30:00	MSFT	Stock	47.11	47.62	47.05	47.5	3251511.0
2014-12-09 10:00:00	MSFT	Stock	47.495	47.54	47.21	47.4	1833162.0
2014-12-09 10:30:00	MSFT	Stock	47.4	47.455	47.24	47.35	1409255.0
2014-12-09 11:00:00	MSFT	Stock	47.35	47.67	47.31	47.55	1004217.0
2014-12-09 11:30:00	MSFT	Stock	47.545	47.66	47.51	47.65	873121.0
2014-12-09 12:00:00	MSFT	Stock	47.635	47.67	47.5	47.6	748911.0
2014-12-09 12:30:00	MSFT	Stock	47.6	47.74	47.545	47.71	703232.0
2014-12-09 13:00:00	MSFT	Stock	47.71	47.84	47.69	47.824	731506.0
2014-12-09 13:30:00	MSFT	Stock	47.83	47.92	47.78	47.79	995645.0
2014-12-09 14:00:00	MSFT	Stock	47.79	47.85	47.69	47.735	1069702.0
2014-12-09 14:30:00	MSFT	Stock	47.735	47.74	47.465	47.6	1464290.0
2014-12-09 15:00:00	MSFT	Stock	47.6	47.67	47.51	47.59	1181050.0

> showing 50 of 85,659 rows — these rows as CSV

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