PREVIEW / stock_30min / 2016-02-03

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-03.parquet
  size:    1.6 MB
  rows:    82,532
  symbols: 3,371

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
2016-02-03 04:00:00	AAPL	Stock	23.73	23.75	23.73	23.75	3960.0
2016-02-03 04:30:00	AAPL	Stock	23.7125	23.7125	23.7125	23.7125	4400.0
2016-02-03 05:00:00	AAPL	Stock	23.66	23.68	23.6375	23.6375	9200.0
2016-02-03 05:30:00	AAPL	Stock	23.665	23.665	23.65	23.6575	9600.0
2016-02-03 06:30:00	AAPL	Stock	23.775	23.7925	23.75	23.75	4908.0
2016-02-03 07:00:00	AAPL	Stock	23.785	23.825	23.755	23.755	48624.0
2016-02-03 07:30:00	AAPL	Stock	23.765	23.765	23.71	23.71	11412.0
2016-02-03 08:00:00	AAPL	Stock	23.7175	23.825	23.6925	23.745	140656.0
2016-02-03 08:30:00	AAPL	Stock	23.74	23.7875	23.7275	23.77	256868.0
2016-02-03 09:00:00	AAPL	Stock	23.765	23.8	23.7275	23.75	291428.0
2016-02-03 09:30:00	AAPL	Stock	23.75	23.91	23.715	23.7925	15839104.0
2016-02-03 10:00:00	AAPL	Stock	23.7925	23.7975	23.5625	23.565	14608096.0
2016-02-03 10:30:00	AAPL	Stock	23.5625	23.6625	23.52	23.6262	15271120.0
2016-02-03 11:00:00	AAPL	Stock	23.6275	23.725	23.5475	23.64	11929564.0
2016-02-03 11:30:00	AAPL	Stock	23.6425	23.7925	23.59	23.675	9824276.0
2016-02-03 12:00:00	AAPL	Stock	23.6775	23.7275	23.6	23.66	6828648.0
2016-02-03 12:30:00	AAPL	Stock	23.6575	23.7025	23.575	23.6938	6208448.0
2016-02-03 13:00:00	AAPL	Stock	23.6925	23.75	23.6325	23.695	5726316.0
2016-02-03 13:30:00	AAPL	Stock	23.6965	23.6975	23.6025	23.61	5828284.0
2016-02-03 14:00:00	AAPL	Stock	23.6088	24.005	23.6088	23.9575	11949064.0
2016-02-03 14:30:00	AAPL	Stock	23.9575	24.1375	23.92	24.13	16259228.0
2016-02-03 15:00:00	AAPL	Stock	24.1305	24.21	24.065	24.065	18173348.0
2016-02-03 15:30:00	AAPL	Stock	24.0675	24.145	24.015	24.085	17805180.0
2016-02-03 16:00:00	AAPL	Stock	24.0875	24.11	23.647	24.075	8402232.0
2016-02-03 16:30:00	AAPL	Stock	24.08	24.085	23.62	24.065	1921996.0
2016-02-03 17:00:00	AAPL	Stock	24.0675	24.075	24.05	24.05	70276.0
2016-02-03 17:30:00	AAPL	Stock	24.04	24.05	23.9525	23.9775	91916.0
2016-02-03 18:00:00	AAPL	Stock	23.98	24.025	23.96	24.025	104276.0
2016-02-03 18:30:00	AAPL	Stock	24.0125	24.0125	23.9975	24.0025	28800.0
2016-02-03 19:00:00	AAPL	Stock	23.9875	24.035	23.9875	24.025	15812.0
2016-02-03 19:30:00	AAPL	Stock	24.0125	24.025	23.9875	24.0075	89196.0
2016-02-03 05:00:00	MSFT	Stock	53.0	53.0	53.0	53.0	200.0
2016-02-03 06:00:00	MSFT	Stock	52.97	52.98	52.97	52.98	4100.0
2016-02-03 06:30:00	MSFT	Stock	52.98	52.98	52.98	52.98	145.0
2016-02-03 07:00:00	MSFT	Stock	53.15	53.16	53.15	53.16	800.0
2016-02-03 07:30:00	MSFT	Stock	53.15	53.16	53.04	53.05	3400.0
2016-02-03 08:00:00	MSFT	Stock	53.17	53.17	52.95	53.1	11335.0
2016-02-03 08:30:00	MSFT	Stock	53.05	53.28	53.05	53.28	17614.0
2016-02-03 09:00:00	MSFT	Stock	53.27	53.33	53.0	53.28	85629.0
2016-02-03 09:30:00	MSFT	Stock	53.29	53.39	53.12	53.2	5177107.0
2016-02-03 10:00:00	MSFT	Stock	53.19	53.195	52.225	52.285	3697922.0
2016-02-03 10:30:00	MSFT	Stock	52.28	52.525	52.07	52.425	4314143.0
2016-02-03 11:00:00	MSFT	Stock	52.43	52.44	51.89	52.19	3681717.0
2016-02-03 11:30:00	MSFT	Stock	52.2	52.27	51.76	51.94	4483759.0
2016-02-03 12:00:00	MSFT	Stock	51.944	52.085	51.765	51.84	2048189.0
2016-02-03 12:30:00	MSFT	Stock	51.848	51.85	51.36	51.605	2626663.0
2016-02-03 13:00:00	MSFT	Stock	51.6	51.74	51.42	51.48	2025816.0
2016-02-03 13:30:00	MSFT	Stock	51.49	51.52	51.26	51.29	2305966.0
2016-02-03 14:00:00	MSFT	Stock	51.28	52.21	51.28	52.1	4371753.0
2016-02-03 14:30:00	MSFT	Stock	52.1	52.429	51.92	52.28	5937403.0

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

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