PREVIEW / stock_30min / 2017-10-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-06.parquet
  size:    1.6 MB
  rows:    81,917
  symbols: 2,961

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
2017-10-06 04:00:00	AAPL	Stock	38.825	38.825	38.75	38.78	2164.0
2017-10-06 04:30:00	AAPL	Stock	38.8225	38.8225	38.75	38.75	1600.0
2017-10-06 05:00:00	AAPL	Stock	38.7475	38.7475	38.7475	38.7475	1200.0
2017-10-06 05:30:00	AAPL	Stock	38.76	38.7625	38.7575	38.7625	2588.0
2017-10-06 06:00:00	AAPL	Stock	38.76	38.76	38.76	38.76	592.0
2017-10-06 06:30:00	AAPL	Stock	38.775	38.8175	38.775	38.8175	21600.0
2017-10-06 07:00:00	AAPL	Stock	38.7875	38.82	38.7675	38.81	27016.0
2017-10-06 07:30:00	AAPL	Stock	38.765	38.7825	38.75	38.75	24232.0
2017-10-06 08:00:00	AAPL	Stock	38.805	38.93	38.705	38.7175	235248.0
2017-10-06 08:30:00	AAPL	Stock	38.715	38.75	38.665	38.6675	249520.0
2017-10-06 09:00:00	AAPL	Stock	38.665	38.75	38.655	38.75	226988.0
2017-10-06 09:30:00	AAPL	Stock	38.7425	38.8725	38.64	38.685	9594752.0
2017-10-06 10:00:00	AAPL	Stock	38.6825	38.79	38.6825	38.7725	4335288.0
2017-10-06 10:30:00	AAPL	Stock	38.77	38.775	38.6575	38.6925	3603828.0
2017-10-06 11:00:00	AAPL	Stock	38.6925	38.7938	38.691	38.76	3400396.0
2017-10-06 11:30:00	AAPL	Stock	38.76	38.76	38.6825	38.6888	2552852.0
2017-10-06 12:00:00	AAPL	Stock	38.6888	38.763	38.6525	38.7575	3145888.0
2017-10-06 12:30:00	AAPL	Stock	38.76	38.7775	38.725	38.76	2452408.0
2017-10-06 13:00:00	AAPL	Stock	38.7575	38.8125	38.745	38.7535	3198344.0
2017-10-06 13:30:00	AAPL	Stock	38.7525	38.7875	38.7275	38.7798	2178448.0
2017-10-06 14:00:00	AAPL	Stock	38.7775	38.8	38.7375	38.756	1912228.0
2017-10-06 14:30:00	AAPL	Stock	38.7562	38.78	38.7425	38.7725	1817552.0
2017-10-06 15:00:00	AAPL	Stock	38.7725	38.8075	38.75	38.77	4719756.0
2017-10-06 15:30:00	AAPL	Stock	38.7725	38.835	38.7475	38.8225	10255044.0
2017-10-06 16:00:00	AAPL	Stock	38.825	38.845	38.8175	38.845	5364832.0
2017-10-06 16:30:00	AAPL	Stock	38.825	38.845	38.825	38.83	13656.0
2017-10-06 17:00:00	AAPL	Stock	38.83	38.85	38.825	38.8325	92076.0
2017-10-06 17:30:00	AAPL	Stock	38.8475	38.85	38.825	38.8325	72880.0
2017-10-06 18:00:00	AAPL	Stock	38.8325	38.8425	38.8275	38.83	22348.0
2017-10-06 18:30:00	AAPL	Stock	38.83	38.835	38.8275	38.8275	22948.0
2017-10-06 19:00:00	AAPL	Stock	38.835	38.835	38.825	38.835	2012.0
2017-10-06 19:30:00	AAPL	Stock	38.83	38.8425	38.825	38.8425	19288.0
2017-10-06 06:00:00	MSFT	Stock	75.88	75.88	75.88	75.88	200.0
2017-10-06 07:00:00	MSFT	Stock	76.04	76.04	76.04	76.04	220.0
2017-10-06 07:30:00	MSFT	Stock	75.99	75.99	75.99	75.99	200.0
2017-10-06 08:00:00	MSFT	Stock	75.97	75.97	75.97	75.97	5215.0
2017-10-06 08:30:00	MSFT	Stock	75.92	75.92	75.7	75.72	4438.0
2017-10-06 09:00:00	MSFT	Stock	75.79	75.79	75.61	75.62	7161.0
2017-10-06 09:30:00	MSFT	Stock	75.66	75.92	75.56	75.78	1532562.0
2017-10-06 10:00:00	MSFT	Stock	75.78	76.03	75.78	75.885	989376.0
2017-10-06 10:30:00	MSFT	Stock	75.9	75.91	75.54	75.64	911535.0
2017-10-06 11:00:00	MSFT	Stock	75.64	75.849	75.64	75.825	483712.0
2017-10-06 11:30:00	MSFT	Stock	75.825	75.84	75.74	75.83	470236.0
2017-10-06 12:00:00	MSFT	Stock	75.82	75.89	75.747	75.86	451708.0
2017-10-06 12:30:00	MSFT	Stock	75.87	75.93	75.785	75.795	388926.0
2017-10-06 13:00:00	MSFT	Stock	75.795	75.8	75.69	75.69	387212.0
2017-10-06 13:30:00	MSFT	Stock	75.68	75.76	75.673	75.72	265451.0
2017-10-06 14:00:00	MSFT	Stock	75.724	75.73	75.65	75.68	346918.0
2017-10-06 14:30:00	MSFT	Stock	75.69	75.72	75.57	75.665	646817.0
2017-10-06 15:00:00	MSFT	Stock	75.665	75.77	75.64	75.765	608319.0

> showing 50 of 81,917 rows — these rows as CSV

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