PREVIEW / stock_30min / 2014-12-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-05.parquet
  size:    1.6 MB
  rows:    84,386
  symbols: 3,561

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-05 04:00:00	AAPL	Stock	28.9125	28.925	28.9125	28.925	10400.0
2014-12-05 04:30:00	AAPL	Stock	28.95	28.95	28.925	28.9375	5528.0
2014-12-05 05:00:00	AAPL	Stock	28.9275	28.9375	28.925	28.925	3600.0
2014-12-05 05:30:00	AAPL	Stock	28.925	28.925	28.925	28.925	2000.0
2014-12-05 06:00:00	AAPL	Stock	28.9375	28.975	28.9375	28.975	20548.0
2014-12-05 06:30:00	AAPL	Stock	28.98	28.9975	28.98	28.9975	13304.0
2014-12-05 07:00:00	AAPL	Stock	28.985	28.985	28.95	28.9575	46780.0
2014-12-05 07:30:00	AAPL	Stock	28.9625	28.9975	28.9625	28.9825	41020.0
2014-12-05 08:00:00	AAPL	Stock	28.975	28.98	28.8725	28.97	184152.0
2014-12-05 08:30:00	AAPL	Stock	28.9525	29.05	28.8875	28.9648	693020.0
2014-12-05 09:00:00	AAPL	Stock	28.97	29.0152	28.93	28.9625	397476.0
2014-12-05 09:30:00	AAPL	Stock	28.9975	28.9975	28.7675	28.93	23126668.0
2014-12-05 10:00:00	AAPL	Stock	28.93	28.93	28.795	28.8538	13710344.0
2014-12-05 10:30:00	AAPL	Stock	28.855	28.915	28.8375	28.865	9077588.0
2014-12-05 11:00:00	AAPL	Stock	28.865	28.9125	28.8525	28.8812	7133904.0
2014-12-05 11:30:00	AAPL	Stock	28.8825	28.925	28.8325	28.8925	7701628.0
2014-12-05 12:00:00	AAPL	Stock	28.8925	28.97	28.8825	28.9625	6685628.0
2014-12-05 12:30:00	AAPL	Stock	28.965	29.02	28.955	28.9632	13663660.0
2014-12-05 13:00:00	AAPL	Stock	28.9628	28.9675	28.88	28.9225	6130592.0
2014-12-05 13:30:00	AAPL	Stock	28.9225	28.9575	28.9075	28.9292	4196440.0
2014-12-05 14:00:00	AAPL	Stock	28.93	28.94	28.835	28.8475	6050268.0
2014-12-05 14:30:00	AAPL	Stock	28.8468	28.87	28.795	28.8125	5309000.0
2014-12-05 15:00:00	AAPL	Stock	28.8125	28.8575	28.785	28.7988	7397180.0
2014-12-05 15:30:00	AAPL	Stock	28.8	28.8075	28.66	28.7475	23602816.0
2014-12-05 16:00:00	AAPL	Stock	28.75	28.9375	28.735	28.7475	9288208.0
2014-12-05 16:30:00	AAPL	Stock	28.7475	28.75	28.7425	28.745	77436.0
2014-12-05 17:00:00	AAPL	Stock	28.745	28.75	28.745	28.7475	1264888.0
2014-12-05 17:30:00	AAPL	Stock	28.75	28.75	28.74	28.75	229568.0
2014-12-05 18:00:00	AAPL	Stock	28.74	28.75	28.7375	28.75	50444.0
2014-12-05 18:30:00	AAPL	Stock	28.7425	28.75	28.7375	28.7375	21412.0
2014-12-05 19:00:00	AAPL	Stock	28.73	28.75	28.725	28.75	16400.0
2014-12-05 19:30:00	AAPL	Stock	28.74	28.75	28.7375	28.75	25740.0
2014-12-05 08:00:00	MSFT	Stock	48.9	48.9	48.85	48.9	3700.0
2014-12-05 08:30:00	MSFT	Stock	48.9	48.99	48.8	48.9	16611.0
2014-12-05 09:00:00	MSFT	Stock	48.86	48.91	48.81	48.84	5685.0
2014-12-05 09:30:00	MSFT	Stock	48.88	48.97	48.57	48.58	3304427.0
2014-12-05 10:00:00	MSFT	Stock	48.59	48.755	48.385	48.6	2695960.0
2014-12-05 10:30:00	MSFT	Stock	48.59	48.65	48.54	48.63	1120050.0
2014-12-05 11:00:00	MSFT	Stock	48.635	48.68	48.61	48.665	850907.0
2014-12-05 11:30:00	MSFT	Stock	48.66	48.67	48.57	48.609	1047441.0
2014-12-05 12:00:00	MSFT	Stock	48.607	48.66	48.59	48.65	574521.0
2014-12-05 12:30:00	MSFT	Stock	48.645	48.7	48.61	48.635	662275.0
2014-12-05 13:00:00	MSFT	Stock	48.635	48.64	48.475	48.514	731191.0
2014-12-05 13:30:00	MSFT	Stock	48.51	48.545	48.48	48.53	483515.0
2014-12-05 14:00:00	MSFT	Stock	48.53	48.54	48.46	48.5	1242314.0
2014-12-05 14:30:00	MSFT	Stock	48.51	48.54	48.45	48.51	1067365.0
2014-12-05 15:00:00	MSFT	Stock	48.5	48.6	48.48	48.575	1922593.0
2014-12-05 15:30:00	MSFT	Stock	48.58	48.58	48.38	48.41	3598918.0
2014-12-05 16:00:00	MSFT	Stock	48.42	48.65	48.41	48.414	5555249.0
2014-12-05 16:30:00	MSFT	Stock	48.575	48.575	48.43	48.43	13747.0

> showing 50 of 84,386 rows — these rows as CSV

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