PREVIEW / stock_30min / 2017-11-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-27.parquet
  size:    1.7 MB
  rows:    83,735
  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-27 04:00:00	AAPL	Stock	43.715	43.75	43.715	43.75	800.0
2017-11-27 04:30:00	AAPL	Stock	43.725	43.725	43.7175	43.725	1400.0
2017-11-27 05:00:00	AAPL	Stock	43.725	43.77	43.725	43.77	1152.0
2017-11-27 05:30:00	AAPL	Stock	43.7975	43.8	43.7975	43.8	1276.0
2017-11-27 06:00:00	AAPL	Stock	43.81	43.845	43.81	43.845	1200.0
2017-11-27 06:30:00	AAPL	Stock	43.81	43.81	43.75	43.775	14524.0
2017-11-27 07:00:00	AAPL	Stock	43.755	43.7875	43.73	43.73	45692.0
2017-11-27 07:30:00	AAPL	Stock	43.73	43.73	43.61	43.645	65784.0
2017-11-27 08:00:00	AAPL	Stock	43.81	43.875	43.6125	43.6625	173224.0
2017-11-27 08:30:00	AAPL	Stock	43.6625	43.6925	43.65	43.6775	141888.0
2017-11-27 09:00:00	AAPL	Stock	43.675	43.765	43.67	43.765	239212.0
2017-11-27 09:30:00	AAPL	Stock	43.7625	43.775	43.335	43.6538	16990920.0
2017-11-27 10:00:00	AAPL	Stock	43.66	43.745	43.6475	43.6558	5138288.0
2017-11-27 10:30:00	AAPL	Stock	43.66	43.7	43.6125	43.63	4018508.0
2017-11-27 11:00:00	AAPL	Stock	43.63	43.6325	43.4	43.415	6483436.0
2017-11-27 11:30:00	AAPL	Stock	43.415	43.5262	43.4125	43.5125	4333712.0
2017-11-27 12:00:00	AAPL	Stock	43.5175	43.5875	43.465	43.565	4154780.0
2017-11-27 12:30:00	AAPL	Stock	43.5675	43.58	43.4908	43.52	3855592.0
2017-11-27 13:00:00	AAPL	Stock	43.5225	43.615	43.515	43.6025	2167008.0
2017-11-27 13:30:00	AAPL	Stock	43.6012	43.6225	43.564	43.6025	1712528.0
2017-11-27 14:00:00	AAPL	Stock	43.6012	43.6038	43.5125	43.5275	2708108.0
2017-11-27 14:30:00	AAPL	Stock	43.5262	43.5725	43.525	43.5707	2263764.0
2017-11-27 15:00:00	AAPL	Stock	43.57	43.5775	43.5025	43.515	2654200.0
2017-11-27 15:30:00	AAPL	Stock	43.515	43.56	43.505	43.52	5665432.0
2017-11-27 16:00:00	AAPL	Stock	43.5225	43.5475	43.515	43.5225	10531028.0
2017-11-27 16:30:00	AAPL	Stock	43.52	43.535	43.515	43.5225	9760.0
2017-11-27 17:00:00	AAPL	Stock	43.5225	43.54	43.5025	43.54	5904.0
2017-11-27 17:30:00	AAPL	Stock	43.54	43.54	43.505	43.5225	399716.0
2017-11-27 18:00:00	AAPL	Stock	43.505	43.505	43.495	43.495	18940.0
2017-11-27 18:30:00	AAPL	Stock	43.4875	43.5	43.4875	43.4875	30964.0
2017-11-27 19:00:00	AAPL	Stock	43.49	43.49	43.4625	43.4625	20516.0
2017-11-27 19:30:00	AAPL	Stock	43.4625	43.4725	43.4	43.4525	20716.0
2017-11-27 06:00:00	MSFT	Stock	83.47	83.47	83.47	83.47	100.0
2017-11-27 07:00:00	MSFT	Stock	83.4	83.4	83.3	83.3	2007.0
2017-11-27 07:30:00	MSFT	Stock	83.26	83.26	83.24	83.25	2829.0
2017-11-27 08:00:00	MSFT	Stock	83.3	83.35	83.18	83.35	11973.0
2017-11-27 08:30:00	MSFT	Stock	83.3	83.47	83.25	83.25	840.0
2017-11-27 09:00:00	MSFT	Stock	83.27	83.39	83.27	83.35	830.0
2017-11-27 09:30:00	MSFT	Stock	83.31	83.965	83.3	83.855	2217472.0
2017-11-27 10:00:00	MSFT	Stock	83.86	83.965	83.83	83.84	1205327.0
2017-11-27 10:30:00	MSFT	Stock	83.85	83.915	83.74	83.865	1162086.0
2017-11-27 11:00:00	MSFT	Stock	83.865	83.98	83.69	83.75	996731.0
2017-11-27 11:30:00	MSFT	Stock	83.748	83.92	83.67	83.91	1132162.0
2017-11-27 12:00:00	MSFT	Stock	83.91	83.96	83.84	83.87	829867.0
2017-11-27 12:30:00	MSFT	Stock	83.87	83.89	83.7	83.71	518422.0
2017-11-27 13:00:00	MSFT	Stock	83.71	83.85	83.7	83.725	494714.0
2017-11-27 13:30:00	MSFT	Stock	83.73	83.73	83.56	83.61	587699.0
2017-11-27 14:00:00	MSFT	Stock	83.61	83.66	83.54	83.65	501929.0
2017-11-27 14:30:00	MSFT	Stock	83.65	83.86	83.65	83.86	725632.0
2017-11-27 15:00:00	MSFT	Stock	83.85	83.87	83.75	83.83	1138242.0

> showing 50 of 83,735 rows — these rows as CSV

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