PREVIEW / stock_30min / 2017-04-05

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-05.parquet
  size:    1.6 MB
  rows:    83,718
  symbols: 3,073

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-04-05 05:00:00	AAPL	Stock	36.175	36.175	36.1625	36.1625	1744.0
2017-04-05 06:00:00	AAPL	Stock	36.15	36.15	36.15	36.15	1600.0
2017-04-05 06:30:00	AAPL	Stock	36.15	36.15	36.15	36.15	5200.0
2017-04-05 07:00:00	AAPL	Stock	36.1375	36.1475	36.125	36.1425	19896.0
2017-04-05 07:30:00	AAPL	Stock	36.1275	36.165	36.1275	36.1625	37124.0
2017-04-05 08:00:00	AAPL	Stock	36.1675	36.1825	36.15	36.18	142428.0
2017-04-05 08:30:00	AAPL	Stock	36.1725	36.1725	35.8175	35.9675	1127076.0
2017-04-05 09:00:00	AAPL	Stock	35.965	36.16	35.9375	36.16	1221864.0
2017-04-05 09:30:00	AAPL	Stock	36.055	36.2975	36.055	36.193	20015100.0
2017-04-05 10:00:00	AAPL	Stock	36.1925	36.2688	36.135	36.2615	7971088.0
2017-04-05 10:30:00	AAPL	Stock	36.26	36.3475	36.2375	36.32	8136908.0
2017-04-05 11:00:00	AAPL	Stock	36.315	36.3475	36.2125	36.225	6247624.0
2017-04-05 11:30:00	AAPL	Stock	36.225	36.335	36.205	36.3	3916208.0
2017-04-05 12:00:00	AAPL	Stock	36.3	36.3638	36.2875	36.2962	3884676.0
2017-04-05 12:30:00	AAPL	Stock	36.2975	36.3588	36.2825	36.3362	3032384.0
2017-04-05 13:00:00	AAPL	Stock	36.3365	36.36	36.2975	36.315	2824720.0
2017-04-05 13:30:00	AAPL	Stock	36.315	36.365	36.315	36.3575	3371420.0
2017-04-05 14:00:00	AAPL	Stock	36.355	36.3575	36.29	36.32	4622320.0
2017-04-05 14:30:00	AAPL	Stock	36.32	36.335	36.2025	36.21	5447828.0
2017-04-05 15:00:00	AAPL	Stock	36.2122	36.2338	36.0075	36.0975	9298492.0
2017-04-05 15:30:00	AAPL	Stock	36.0975	36.1	35.9525	36.005	13768948.0
2017-04-05 16:00:00	AAPL	Stock	36.005	36.191	35.9675	36.005	4020172.0
2017-04-05 16:30:00	AAPL	Stock	35.975	36.005	35.87	35.8975	305412.0
2017-04-05 17:00:00	AAPL	Stock	35.8925	35.9075	35.8125	35.8175	150052.0
2017-04-05 17:30:00	AAPL	Stock	35.85	36.005	35.825	35.8625	77712.0
2017-04-05 18:00:00	AAPL	Stock	35.8675	35.87	35.8375	35.855	39372.0
2017-04-05 18:30:00	AAPL	Stock	35.855	35.8975	35.855	35.8925	37300.0
2017-04-05 19:00:00	AAPL	Stock	35.8775	35.8925	35.8775	35.88	10012.0
2017-04-05 19:30:00	AAPL	Stock	35.88	35.8925	35.8775	35.88	18752.0
2017-04-05 07:00:00	MSFT	Stock	65.82	65.82	65.82	65.82	100.0
2017-04-05 08:00:00	MSFT	Stock	65.73	65.87	65.73	65.87	1522.0
2017-04-05 08:30:00	MSFT	Stock	65.8	65.87	65.8	65.87	845.0
2017-04-05 09:00:00	MSFT	Stock	65.81	65.94	65.81	65.87	13085.0
2017-04-05 09:30:00	MSFT	Stock	66.3	66.3	65.76	66.01	1699081.0
2017-04-05 10:00:00	MSFT	Stock	66.02	66.14	65.96	66.119	1271523.0
2017-04-05 10:30:00	MSFT	Stock	66.115	66.28	66.06	66.25	1266905.0
2017-04-05 11:00:00	MSFT	Stock	66.255	66.35	66.17	66.195	1399285.0
2017-04-05 11:30:00	MSFT	Stock	66.19	66.25	66.13	66.13	870504.0
2017-04-05 12:00:00	MSFT	Stock	66.132	66.21	66.11	66.166	634918.0
2017-04-05 12:30:00	MSFT	Stock	66.17	66.22	66.12	66.14	715538.0
2017-04-05 13:00:00	MSFT	Stock	66.14	66.175	66.09	66.11	1133818.0
2017-04-05 13:30:00	MSFT	Stock	66.11	66.22	66.07	66.19	928039.0
2017-04-05 14:00:00	MSFT	Stock	66.19	66.35	66.05	66.345	1690749.0
2017-04-05 14:30:00	MSFT	Stock	66.34	66.35	65.97	65.98	1514121.0
2017-04-05 15:00:00	MSFT	Stock	65.974	66.07	65.66	65.765	1896452.0
2017-04-05 15:30:00	MSFT	Stock	65.768	65.775	65.444	65.56	3131466.0
2017-04-05 16:00:00	MSFT	Stock	65.57	65.57	65.51	65.56	1474710.0
2017-04-05 16:30:00	MSFT	Stock	65.54	65.54	65.43	65.43	3742.0
2017-04-05 17:00:00	MSFT	Stock	65.53	65.53	65.53	65.53	431.0
2017-04-05 17:30:00	MSFT	Stock	65.45	65.56	65.43	65.56	6200.0

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

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