PREVIEW / stock_30min / 2015-04-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-28.parquet
  size:    1.6 MB
  rows:    82,667
  symbols: 3,506

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-04-28 04:00:00	AAPL	Stock	33.6375	33.6375	33.5	33.525	116928.0
2015-04-28 04:30:00	AAPL	Stock	33.56	33.675	33.56	33.665	61096.0
2015-04-28 05:00:00	AAPL	Stock	33.675	33.7425	33.6625	33.7125	49524.0
2015-04-28 05:30:00	AAPL	Stock	33.74	33.74	33.6675	33.7125	90860.0
2015-04-28 06:00:00	AAPL	Stock	33.725	33.8475	33.685	33.775	203804.0
2015-04-28 06:30:00	AAPL	Stock	33.8	33.9375	33.7125	33.8875	247288.0
2015-04-28 07:00:00	AAPL	Stock	33.8875	34.05	33.84	34.03	1857724.0
2015-04-28 07:30:00	AAPL	Stock	34.035	34.05	33.9	33.9275	1275976.0
2015-04-28 08:00:00	AAPL	Stock	33.9125	34.045	33.5825	33.675	4816516.0
2015-04-28 08:30:00	AAPL	Stock	33.675	33.68	33.5275	33.6	3922308.0
2015-04-28 09:00:00	AAPL	Stock	33.595	33.68	33.5425	33.6125	3049832.0
2015-04-28 09:30:00	AAPL	Stock	33.615	33.635	32.5825	32.79	121728884.0
2015-04-28 10:00:00	AAPL	Stock	32.79	32.85	32.3925	32.7325	60365912.0
2015-04-28 10:30:00	AAPL	Stock	32.7325	32.7925	32.61	32.7175	28579160.0
2015-04-28 11:00:00	AAPL	Stock	32.72	32.9775	32.7088	32.8625	31028340.0
2015-04-28 11:30:00	AAPL	Stock	32.8625	33.185	32.8575	33.15	28409232.0
2015-04-28 12:00:00	AAPL	Stock	33.15	33.28	33.14	33.201	28514600.0
2015-04-28 12:30:00	AAPL	Stock	33.2025	33.25	33.0925	33.2175	15565192.0
2015-04-28 13:00:00	AAPL	Stock	33.2175	33.2375	33.105	33.106	11548588.0
2015-04-28 13:30:00	AAPL	Stock	33.1062	33.1528	32.995	33.0072	16102332.0
2015-04-28 14:00:00	AAPL	Stock	33.0025	33.0075	32.765	32.8175	22503376.0
2015-04-28 14:30:00	AAPL	Stock	32.8185	32.855	32.7125	32.715	17702796.0
2015-04-28 15:00:00	AAPL	Stock	32.7162	32.7925	32.6	32.6257	20372444.0
2015-04-28 15:30:00	AAPL	Stock	32.6275	32.7475	32.57	32.64	27794624.0
2015-04-28 16:00:00	AAPL	Stock	32.64	32.7835	32.5725	32.605	4674584.0
2015-04-28 16:30:00	AAPL	Stock	32.6025	32.6025	32.55	32.5875	241968.0
2015-04-28 17:00:00	AAPL	Stock	32.5825	32.585	32.5375	32.55	186520.0
2015-04-28 17:30:00	AAPL	Stock	32.55	32.5625	32.5175	32.5525	160960.0
2015-04-28 18:00:00	AAPL	Stock	32.555	32.585	32.55	32.5625	114236.0
2015-04-28 18:30:00	AAPL	Stock	32.56	32.575	32.525	32.5622	150872.0
2015-04-28 19:00:00	AAPL	Stock	32.5625	32.5625	32.5425	32.545	93424.0
2015-04-28 19:30:00	AAPL	Stock	32.5475	32.575	32.525	32.5675	202896.0
2015-04-28 04:00:00	MSFT	Stock	47.79	47.88	47.79	47.88	460.0
2015-04-28 05:00:00	MSFT	Stock	47.94	47.94	47.94	47.94	140.0
2015-04-28 05:30:00	MSFT	Stock	47.84	47.84	47.84	47.84	200.0
2015-04-28 06:00:00	MSFT	Stock	47.84	47.85	47.84	47.85	1500.0
2015-04-28 06:30:00	MSFT	Stock	47.81	47.84	47.81	47.81	1910.0
2015-04-28 07:00:00	MSFT	Stock	47.79	47.79	47.72	47.75	14740.0
2015-04-28 07:30:00	MSFT	Stock	47.75	47.75	47.69	47.74	5269.0
2015-04-28 08:00:00	MSFT	Stock	47.75	47.78	47.71	47.75	15397.0
2015-04-28 08:30:00	MSFT	Stock	47.75	47.82	47.75	47.78	8701.0
2015-04-28 09:00:00	MSFT	Stock	47.76	47.87	47.68	47.79	83651.0
2015-04-28 09:30:00	MSFT	Stock	47.78	48.72	47.7	48.64	7573003.0
2015-04-28 10:00:00	MSFT	Stock	48.635	48.91	48.54	48.75	6591415.0
2015-04-28 10:30:00	MSFT	Stock	48.755	49.0	48.73	48.955	5155738.0
2015-04-28 11:00:00	MSFT	Stock	48.95	49.135	48.87	48.925	5150471.0
2015-04-28 11:30:00	MSFT	Stock	48.92	49.05	48.905	49.02	3134016.0
2015-04-28 12:00:00	MSFT	Stock	49.02	49.04	48.884	48.89	2556301.0
2015-04-28 12:30:00	MSFT	Stock	48.905	48.99	48.81	48.98	2056100.0
2015-04-28 13:00:00	MSFT	Stock	48.98	49.09	48.93	49.03	2420160.0

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

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