PREVIEW / stock_30min / 2017-07-31

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-31.parquet
  size:    1.6 MB
  rows:    81,028
  symbols: 2,991

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-07-31 04:00:00	AAPL	Stock	37.4375	37.465	37.4375	37.465	924.0
2017-07-31 05:00:00	AAPL	Stock	37.55	37.5625	37.55	37.5625	6992.0
2017-07-31 05:30:00	AAPL	Stock	37.5575	37.5575	37.51	37.51	800.0
2017-07-31 06:00:00	AAPL	Stock	37.5125	37.5325	37.5125	37.525	2916.0
2017-07-31 06:30:00	AAPL	Stock	37.5375	37.55	37.5	37.5	9880.0
2017-07-31 07:00:00	AAPL	Stock	37.5	37.525	37.5	37.5225	32740.0
2017-07-31 07:30:00	AAPL	Stock	37.5225	37.5225	37.5	37.5	37180.0
2017-07-31 08:00:00	AAPL	Stock	37.4775	37.525	37.475	37.5	141864.0
2017-07-31 08:30:00	AAPL	Stock	37.495	37.495	37.455	37.455	82484.0
2017-07-31 09:00:00	AAPL	Stock	37.455	37.49	37.45	37.4825	69080.0
2017-07-31 09:30:00	AAPL	Stock	37.475	37.5825	37.305	37.3475	11521868.0
2017-07-31 10:00:00	AAPL	Stock	37.3475	37.365	37.15	37.1625	6809672.0
2017-07-31 10:30:00	AAPL	Stock	37.16	37.24	37.0625	37.1975	5996656.0
2017-07-31 11:00:00	AAPL	Stock	37.2	37.2325	37.135	37.1775	2770372.0
2017-07-31 11:30:00	AAPL	Stock	37.18	37.275	37.1702	37.2012	2980576.0
2017-07-31 12:00:00	AAPL	Stock	37.2	37.2225	37.1085	37.2055	2625192.0
2017-07-31 12:30:00	AAPL	Stock	37.205	37.2438	37.125	37.185	2734352.0
2017-07-31 13:00:00	AAPL	Stock	37.1875	37.21	37.0925	37.1438	2764500.0
2017-07-31 13:30:00	AAPL	Stock	37.145	37.15	37.06	37.1	3053584.0
2017-07-31 14:00:00	AAPL	Stock	37.1002	37.1925	37.0325	37.1775	3025104.0
2017-07-31 14:30:00	AAPL	Stock	37.18	37.2025	37.0975	37.1287	3404956.0
2017-07-31 15:00:00	AAPL	Stock	37.1275	37.2275	37.1275	37.224	3328492.0
2017-07-31 15:30:00	AAPL	Stock	37.225	37.25	37.15	37.1925	8559992.0
2017-07-31 16:00:00	AAPL	Stock	37.1925	37.2225	37.0902	37.195	9723064.0
2017-07-31 16:30:00	AAPL	Stock	37.1925	37.195	37.1775	37.1875	12264.0
2017-07-31 17:00:00	AAPL	Stock	37.185	37.1875	37.13	37.1425	39628.0
2017-07-31 17:30:00	AAPL	Stock	37.1375	37.15	37.0075	37.03	131096.0
2017-07-31 18:00:00	AAPL	Stock	37.03	37.0375	37.0025	37.0125	70752.0
2017-07-31 18:30:00	AAPL	Stock	37.03	37.03	37.0	37.0125	28896.0
2017-07-31 19:00:00	AAPL	Stock	37.0125	37.025	37.0075	37.0175	31432.0
2017-07-31 19:30:00	AAPL	Stock	37.03	37.05	37.0275	37.0275	19792.0
2017-07-31 05:30:00	MSFT	Stock	73.5	73.5	73.5	73.5	2419.0
2017-07-31 07:00:00	MSFT	Stock	73.3	73.3	73.3	73.3	100.0
2017-07-31 07:30:00	MSFT	Stock	73.2	73.3	73.2	73.3	6755.0
2017-07-31 08:00:00	MSFT	Stock	73.3	73.59	73.24	73.24	5633.0
2017-07-31 08:30:00	MSFT	Stock	73.11	73.35	73.11	73.31	14000.0
2017-07-31 09:00:00	MSFT	Stock	73.35	73.4	73.35	73.39	10437.0
2017-07-31 09:30:00	MSFT	Stock	73.3	73.44	72.8	72.83	2011849.0
2017-07-31 10:00:00	MSFT	Stock	72.83	72.906	72.55	72.56	1470654.0
2017-07-31 10:30:00	MSFT	Stock	72.56	72.58	72.41	72.52	1398419.0
2017-07-31 11:00:00	MSFT	Stock	72.53	72.76	72.525	72.72	1112722.0
2017-07-31 11:30:00	MSFT	Stock	72.73	73.05	72.72	72.945	778561.0
2017-07-31 12:00:00	MSFT	Stock	72.945	73.04	72.865	73.015	733998.0
2017-07-31 12:30:00	MSFT	Stock	73.01	73.31	72.98	73.29	1317348.0
2017-07-31 13:00:00	MSFT	Stock	73.299	73.37	73.2	73.34	1017691.0
2017-07-31 13:30:00	MSFT	Stock	73.34	73.36	73.14	73.285	689434.0
2017-07-31 14:00:00	MSFT	Stock	73.287	73.29	72.99	73.02	962768.0
2017-07-31 14:30:00	MSFT	Stock	73.02	73.06	72.84	72.86	966958.0
2017-07-31 15:00:00	MSFT	Stock	72.86	72.92	72.84	72.885	1077769.0
2017-07-31 15:30:00	MSFT	Stock	72.89	72.9	72.61	72.72	3590413.0

> showing 50 of 81,028 rows — these rows as CSV

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