PREVIEW / stock_30min / 2017-01-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-12.parquet
  size:    1.6 MB
  rows:    82,829
  symbols: 3,106

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-01-12 04:00:00	AAPL	Stock	29.9	29.9	29.8375	29.8375	12668.0
2017-01-12 04:30:00	AAPL	Stock	29.825	29.8375	29.825	29.8375	6000.0
2017-01-12 05:00:00	AAPL	Stock	29.815	29.8175	29.8125	29.8175	13200.0
2017-01-12 05:30:00	AAPL	Stock	29.82	29.82	29.7725	29.785	28960.0
2017-01-12 06:00:00	AAPL	Stock	29.77	29.815	29.7675	29.7775	103060.0
2017-01-12 06:30:00	AAPL	Stock	29.7825	29.7825	29.7125	29.7275	32100.0
2017-01-12 07:00:00	AAPL	Stock	29.7475	29.785	29.7175	29.75	97668.0
2017-01-12 07:30:00	AAPL	Stock	29.75	29.75	29.6925	29.7	178972.0
2017-01-12 08:00:00	AAPL	Stock	29.7125	29.875	29.6925	29.7625	357396.0
2017-01-12 08:30:00	AAPL	Stock	29.7625	29.7875	29.75	29.77	190148.0
2017-01-12 09:00:00	AAPL	Stock	29.765	29.7875	29.6875	29.7125	388600.0
2017-01-12 09:30:00	AAPL	Stock	29.715	29.7975	29.66	29.71	20955500.0
2017-01-12 10:00:00	AAPL	Stock	29.7125	29.745	29.5825	29.6925	13514788.0
2017-01-12 10:30:00	AAPL	Stock	29.695	29.7075	29.5875	29.5925	6035672.0
2017-01-12 11:00:00	AAPL	Stock	29.5925	29.6575	29.5525	29.6425	7599544.0
2017-01-12 11:30:00	AAPL	Stock	29.6425	29.6962	29.6125	29.6625	4302208.0
2017-01-12 12:00:00	AAPL	Stock	29.665	29.7075	29.6525	29.6875	4455120.0
2017-01-12 12:30:00	AAPL	Stock	29.6875	29.75	29.685	29.735	4081108.0
2017-01-12 13:00:00	AAPL	Stock	29.7348	29.7775	29.7025	29.7275	4387648.0
2017-01-12 13:30:00	AAPL	Stock	29.7275	29.7575	29.7118	29.725	3789400.0
2017-01-12 14:00:00	AAPL	Stock	29.725	29.745	29.7025	29.7245	3516252.0
2017-01-12 14:30:00	AAPL	Stock	29.725	29.7575	29.7125	29.75	4023660.0
2017-01-12 15:00:00	AAPL	Stock	29.7518	29.7525	29.6898	29.745	4068368.0
2017-01-12 15:30:00	AAPL	Stock	29.745	29.825	29.7325	29.8125	11302792.0
2017-01-12 16:00:00	AAPL	Stock	29.8125	29.8125	29.78	29.8	7075360.0
2017-01-12 16:30:00	AAPL	Stock	29.81	29.8125	29.795	29.805	112800.0
2017-01-12 17:00:00	AAPL	Stock	29.7975	29.8075	29.7825	29.7925	89468.0
2017-01-12 17:30:00	AAPL	Stock	29.79	29.81	29.7875	29.79	9080.0
2017-01-12 18:00:00	AAPL	Stock	29.795	29.8025	29.795	29.8025	5200.0
2017-01-12 18:30:00	AAPL	Stock	29.8	29.8125	29.795	29.795	12176.0
2017-01-12 19:00:00	AAPL	Stock	29.7875	29.79	29.7875	29.7875	4720.0
2017-01-12 19:30:00	AAPL	Stock	29.8	29.8	29.7975	29.7975	6800.0
2017-01-12 07:30:00	MSFT	Stock	62.84	62.84	62.83	62.83	407.0
2017-01-12 08:30:00	MSFT	Stock	63.09	63.09	63.0	63.0	25200.0
2017-01-12 09:00:00	MSFT	Stock	63.0	63.19	62.89	63.1	14528.0
2017-01-12 09:30:00	MSFT	Stock	63.09	63.4	62.17	62.3	3652739.0
2017-01-12 10:00:00	MSFT	Stock	62.31	62.33	62.02	62.16	2186976.0
2017-01-12 10:30:00	MSFT	Stock	62.16	62.2	61.955	62.0	1858502.0
2017-01-12 11:00:00	MSFT	Stock	62.0	62.15	61.95	62.11	1323031.0
2017-01-12 11:30:00	MSFT	Stock	62.12	62.13	62.04	62.05	866027.0
2017-01-12 12:00:00	MSFT	Stock	62.055	62.305	62.04	62.265	1023444.0
2017-01-12 12:30:00	MSFT	Stock	62.27	62.41	62.27	62.35	852180.0
2017-01-12 13:00:00	MSFT	Stock	62.35	62.445	62.32	62.37	651052.0
2017-01-12 13:30:00	MSFT	Stock	62.375	62.49	62.37	62.441	628678.0
2017-01-12 14:00:00	MSFT	Stock	62.449	62.49	62.41	62.42	684564.0
2017-01-12 14:30:00	MSFT	Stock	62.425	62.5	62.364	62.47	1068187.0
2017-01-12 15:00:00	MSFT	Stock	62.465	62.5	62.425	62.48	646789.0
2017-01-12 15:30:00	MSFT	Stock	62.48	62.68	62.47	62.61	2553054.0
2017-01-12 16:00:00	MSFT	Stock	62.61	62.65	62.57	62.61	1492984.0
2017-01-12 17:00:00	MSFT	Stock	62.53	62.61	62.53	62.61	66495.0

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

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