PREVIEW / stock_30min / 2014-11-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-12.parquet
  size:    1.6 MB
  rows:    82,937
  symbols: 3,549

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-12 04:00:00	AAPL	Stock	27.35	27.3975	27.33	27.3975	10400.0
2014-11-12 04:30:00	AAPL	Stock	27.3375	27.3375	27.3375	27.3375	1600.0
2014-11-12 05:00:00	AAPL	Stock	27.3225	27.335	27.3225	27.335	7200.0
2014-11-12 05:30:00	AAPL	Stock	27.3625	27.375	27.3075	27.375	6800.0
2014-11-12 06:00:00	AAPL	Stock	27.35	27.375	27.35	27.35	3680.0
2014-11-12 06:30:00	AAPL	Stock	27.315	27.33	27.3075	27.33	10800.0
2014-11-12 07:00:00	AAPL	Stock	27.3325	27.35	27.3325	27.34	38264.0
2014-11-12 07:30:00	AAPL	Stock	27.34	27.3625	27.3375	27.35	25612.0
2014-11-12 08:00:00	AAPL	Stock	27.3575	27.3675	27.2075	27.35	263836.0
2014-11-12 08:30:00	AAPL	Stock	27.345	27.35	27.3325	27.3425	115556.0
2014-11-12 09:00:00	AAPL	Stock	27.3375	27.3575	27.3375	27.355	130712.0
2014-11-12 09:30:00	AAPL	Stock	27.345	27.6175	27.3425	27.56	33472900.0
2014-11-12 10:00:00	AAPL	Stock	27.56	27.7325	27.515	27.6815	19546640.0
2014-11-12 10:30:00	AAPL	Stock	27.6812	27.6825	27.6275	27.6282	12649008.0
2014-11-12 11:00:00	AAPL	Stock	27.6275	27.685	27.605	27.665	10601148.0
2014-11-12 11:30:00	AAPL	Stock	27.665	27.75	27.665	27.7475	10388848.0
2014-11-12 12:00:00	AAPL	Stock	27.7475	27.77	27.7035	27.7332	10226304.0
2014-11-12 12:30:00	AAPL	Stock	27.7338	27.77	27.715	27.7465	5965484.0
2014-11-12 13:00:00	AAPL	Stock	27.7475	27.7725	27.7275	27.7675	5226868.0
2014-11-12 13:30:00	AAPL	Stock	27.765	27.7925	27.7425	27.7558	8474136.0
2014-11-12 14:00:00	AAPL	Stock	27.755	27.7775	27.75	27.7675	4087384.0
2014-11-12 14:30:00	AAPL	Stock	27.77	27.7775	27.705	27.745	7501864.0
2014-11-12 15:00:00	AAPL	Stock	27.745	27.7925	27.735	27.7925	6334380.0
2014-11-12 15:30:00	AAPL	Stock	27.7862	27.8575	27.785	27.8125	20300856.0
2014-11-12 16:00:00	AAPL	Stock	27.8125	27.8375	27.6675	27.825	15781532.0
2014-11-12 16:30:00	AAPL	Stock	27.8375	27.85	27.7655	27.85	82028.0
2014-11-12 17:00:00	AAPL	Stock	27.845	27.845	27.7158	27.83	113364.0
2014-11-12 17:30:00	AAPL	Stock	27.8125	27.845	27.8125	27.8125	378120.0
2014-11-12 18:00:00	AAPL	Stock	27.8475	27.855	27.8125	27.8425	141892.0
2014-11-12 18:30:00	AAPL	Stock	27.8425	27.85	27.8125	27.85	812412.0
2014-11-12 19:00:00	AAPL	Stock	27.8475	27.85	27.8375	27.845	53092.0
2014-11-12 19:30:00	AAPL	Stock	27.845	27.855	27.845	27.8475	45180.0
2014-11-12 06:00:00	MSFT	Stock	48.75	48.75	48.75	48.75	100.0
2014-11-12 07:30:00	MSFT	Stock	48.7	48.7	48.7	48.7	215.0
2014-11-12 08:00:00	MSFT	Stock	48.7	48.74	48.61	48.74	5061.0
2014-11-12 08:30:00	MSFT	Stock	48.69	48.72	48.68	48.68	1828.0
2014-11-12 09:00:00	MSFT	Stock	48.69	48.7	48.49	48.61	9900.0
2014-11-12 09:30:00	MSFT	Stock	48.56	48.835	48.52	48.805	1638954.0
2014-11-12 10:00:00	MSFT	Stock	48.81	48.83	48.65	48.66	1156806.0
2014-11-12 10:30:00	MSFT	Stock	48.665	48.76	48.64	48.725	1080561.0
2014-11-12 11:00:00	MSFT	Stock	48.725	48.76	48.62	48.76	1744128.0
2014-11-12 11:30:00	MSFT	Stock	48.76	48.85	48.755	48.79	1712308.0
2014-11-12 12:00:00	MSFT	Stock	48.79	48.88	48.78	48.875	1099629.0
2014-11-12 12:30:00	MSFT	Stock	48.875	48.88	48.81	48.843	1245626.0
2014-11-12 13:00:00	MSFT	Stock	48.84	48.92	48.835	48.9	1341871.0
2014-11-12 13:30:00	MSFT	Stock	48.89	48.91	48.73	48.74	1263620.0
2014-11-12 14:00:00	MSFT	Stock	48.73	48.83	48.72	48.812	1153689.0
2014-11-12 14:30:00	MSFT	Stock	48.82	48.87	48.77	48.78	1375203.0
2014-11-12 15:00:00	MSFT	Stock	48.775	48.85	48.75	48.85	1434221.0
2014-11-12 15:30:00	MSFT	Stock	48.85	48.89	48.76	48.77	3178779.0

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

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