PREVIEW / stock_30min / 2017-11-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-10.parquet
  size:    1.6 MB
  rows:    82,194
  symbols: 2,942

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-11-10 04:00:00	AAPL	Stock	43.855	43.855	43.66	43.66	33052.0
2017-11-10 04:30:00	AAPL	Stock	43.68	43.6825	43.65	43.65	17516.0
2017-11-10 05:00:00	AAPL	Stock	43.625	43.625	43.6	43.6	14752.0
2017-11-10 05:30:00	AAPL	Stock	43.6075	43.76	43.575	43.66	34936.0
2017-11-10 06:00:00	AAPL	Stock	43.6625	43.745	43.6625	43.7	13820.0
2017-11-10 06:30:00	AAPL	Stock	43.6975	43.71	43.6925	43.6925	2400.0
2017-11-10 07:00:00	AAPL	Stock	43.71	43.7725	43.71	43.74	56440.0
2017-11-10 07:30:00	AAPL	Stock	43.73	43.825	43.725	43.8125	81368.0
2017-11-10 08:00:00	AAPL	Stock	43.8125	43.87	43.7125	43.8225	285952.0
2017-11-10 08:30:00	AAPL	Stock	43.8375	43.8375	43.805	43.825	166212.0
2017-11-10 09:00:00	AAPL	Stock	43.815	43.8625	43.75	43.75	308896.0
2017-11-10 09:30:00	AAPL	Stock	43.7775	43.845	43.5675	43.7125	13805524.0
2017-11-10 10:00:00	AAPL	Stock	43.715	43.75	43.605	43.7062	6447328.0
2017-11-10 10:30:00	AAPL	Stock	43.7075	43.8125	43.6375	43.8103	5309188.0
2017-11-10 11:00:00	AAPL	Stock	43.8125	43.835	43.6625	43.6975	4908492.0
2017-11-10 11:30:00	AAPL	Stock	43.7	43.765	43.68	43.7532	3560020.0
2017-11-10 12:00:00	AAPL	Stock	43.7525	43.7725	43.705	43.7112	2503172.0
2017-11-10 12:30:00	AAPL	Stock	43.7125	43.745	43.695	43.705	2944580.0
2017-11-10 13:00:00	AAPL	Stock	43.7038	43.783	43.675	43.7575	3235236.0
2017-11-10 13:30:00	AAPL	Stock	43.7562	43.7708	43.69	43.705	2809684.0
2017-11-10 14:00:00	AAPL	Stock	43.705	43.7625	43.6925	43.7345	3067432.0
2017-11-10 14:30:00	AAPL	Stock	43.735	43.76	43.7325	43.74	3036016.0
2017-11-10 15:00:00	AAPL	Stock	43.7388	43.75	43.665	43.7175	3694992.0
2017-11-10 15:30:00	AAPL	Stock	43.7175	43.725	43.6512	43.665	6452488.0
2017-11-10 16:00:00	AAPL	Stock	43.665	43.69	43.64	43.6425	23712416.0
2017-11-10 16:30:00	AAPL	Stock	43.65	43.6675	43.6275	43.63	34216.0
2017-11-10 17:00:00	AAPL	Stock	43.6275	43.6475	43.6125	43.6175	50844.0
2017-11-10 17:30:00	AAPL	Stock	43.62	43.65	43.62	43.6375	11404.0
2017-11-10 18:00:00	AAPL	Stock	43.625	43.6375	43.6225	43.6375	8252.0
2017-11-10 18:30:00	AAPL	Stock	43.625	43.64	43.625	43.625	6988.0
2017-11-10 19:00:00	AAPL	Stock	43.6325	43.6475	43.6325	43.6475	17600.0
2017-11-10 19:30:00	AAPL	Stock	43.635	43.6475	43.635	43.64	10772.0
2017-11-10 06:00:00	MSFT	Stock	84.03	84.03	84.03	84.03	400.0
2017-11-10 06:30:00	MSFT	Stock	83.68	83.68	83.68	83.68	100.0
2017-11-10 07:00:00	MSFT	Stock	83.96	83.96	83.96	83.96	4600.0
2017-11-10 07:30:00	MSFT	Stock	83.89	83.94	83.89	83.94	5030.0
2017-11-10 08:00:00	MSFT	Stock	83.81	83.94	83.81	83.82	1475.0
2017-11-10 08:30:00	MSFT	Stock	83.82	83.82	83.82	83.82	100.0
2017-11-10 09:00:00	MSFT	Stock	83.95	83.95	83.73	83.74	17872.0
2017-11-10 09:30:00	MSFT	Stock	83.79	84.095	83.67	83.73	2462751.0
2017-11-10 10:00:00	MSFT	Stock	83.735	83.77	83.38	83.44	1729622.0
2017-11-10 10:30:00	MSFT	Stock	83.43	83.47	83.23	83.46	1079552.0
2017-11-10 11:00:00	MSFT	Stock	83.46	83.51	83.285	83.33	907978.0
2017-11-10 11:30:00	MSFT	Stock	83.34	83.6	83.32	83.564	572174.0
2017-11-10 12:00:00	MSFT	Stock	83.56	83.63	83.505	83.51	757852.0
2017-11-10 12:30:00	MSFT	Stock	83.51	83.57	83.4	83.415	533537.0
2017-11-10 13:00:00	MSFT	Stock	83.415	83.64	83.33	83.635	1131963.0
2017-11-10 13:30:00	MSFT	Stock	83.635	83.66	83.53	83.565	631658.0
2017-11-10 14:00:00	MSFT	Stock	83.565	83.755	83.565	83.705	919443.0
2017-11-10 14:30:00	MSFT	Stock	83.705	83.8	83.7	83.716	618618.0

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

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