PREVIEW / stock_30min / 2017-10-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-26.parquet
  size:    1.6 MB
  rows:    82,363
  symbols: 2,940

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-10-26 04:30:00	AAPL	Stock	39.155	39.155	39.155	39.155	800.0
2017-10-26 05:30:00	AAPL	Stock	39.175	39.175	39.175	39.175	400.0
2017-10-26 06:00:00	AAPL	Stock	39.245	39.25	39.245	39.25	19400.0
2017-10-26 06:30:00	AAPL	Stock	39.185	39.185	39.185	39.185	1332.0
2017-10-26 07:00:00	AAPL	Stock	39.185	39.275	39.185	39.25	78820.0
2017-10-26 07:30:00	AAPL	Stock	39.2975	39.2975	39.25	39.2525	24568.0
2017-10-26 08:00:00	AAPL	Stock	39.25	39.3	39.235	39.2425	129456.0
2017-10-26 08:30:00	AAPL	Stock	39.275	39.3225	39.2375	39.25	164432.0
2017-10-26 09:00:00	AAPL	Stock	39.2675	39.3125	39.2025	39.3075	134672.0
2017-10-26 09:30:00	AAPL	Stock	39.3125	39.4575	39.285	39.315	10431404.0
2017-10-26 10:00:00	AAPL	Stock	39.315	39.3675	39.195	39.3	5557684.0
2017-10-26 10:30:00	AAPL	Stock	39.3025	39.4325	39.28	39.3852	4195516.0
2017-10-26 11:00:00	AAPL	Stock	39.385	39.425	39.3198	39.365	3701508.0
2017-10-26 11:30:00	AAPL	Stock	39.3625	39.3975	39.3325	39.374	2205952.0
2017-10-26 12:00:00	AAPL	Stock	39.3725	39.4225	39.37	39.4075	1685524.0
2017-10-26 12:30:00	AAPL	Stock	39.4075	39.4075	39.3125	39.3425	1894064.0
2017-10-26 13:00:00	AAPL	Stock	39.3448	39.37	39.3175	39.325	1509152.0
2017-10-26 13:30:00	AAPL	Stock	39.3225	39.3512	39.2725	39.35	2153632.0
2017-10-26 14:00:00	AAPL	Stock	39.35	39.405	39.325	39.395	2131980.0
2017-10-26 14:30:00	AAPL	Stock	39.3975	39.4375	39.3975	39.4175	2991420.0
2017-10-26 15:00:00	AAPL	Stock	39.4175	39.43	39.3725	39.395	3003236.0
2017-10-26 15:30:00	AAPL	Stock	39.395	39.42	39.3475	39.355	8098004.0
2017-10-26 16:00:00	AAPL	Stock	39.3525	39.435	39.3025	39.425	11651420.0
2017-10-26 16:30:00	AAPL	Stock	39.435	39.45	39.3525	39.435	123384.0
2017-10-26 17:00:00	AAPL	Stock	39.435	39.465	39.3525	39.46	90596.0
2017-10-26 17:30:00	AAPL	Stock	39.4625	39.465	39.46	39.465	67076.0
2017-10-26 18:00:00	AAPL	Stock	39.4625	39.475	39.4625	39.475	106316.0
2017-10-26 18:30:00	AAPL	Stock	39.4875	39.4875	39.4675	39.47	6644.0
2017-10-26 19:00:00	AAPL	Stock	39.47	39.4875	39.47	39.4875	18124.0
2017-10-26 19:30:00	AAPL	Stock	39.485	39.4875	39.425	39.4825	104808.0
2017-10-26 04:00:00	MSFT	Stock	78.85	78.85	78.85	78.85	327.0
2017-10-26 04:30:00	MSFT	Stock	79.03	79.03	79.03	79.03	100.0
2017-10-26 06:30:00	MSFT	Stock	78.9	78.9	78.9	78.9	100.0
2017-10-26 07:00:00	MSFT	Stock	78.9	78.92	78.89	78.92	300.0
2017-10-26 07:30:00	MSFT	Stock	78.9	78.95	78.9	78.95	6071.0
2017-10-26 08:00:00	MSFT	Stock	78.95	79.1	78.84	78.95	50456.0
2017-10-26 08:30:00	MSFT	Stock	78.91	78.95	78.88	78.88	30270.0
2017-10-26 09:00:00	MSFT	Stock	78.93	79.15	78.85	79.15	46229.0
2017-10-26 09:30:00	MSFT	Stock	79.18	79.42	79.08	79.12	3783405.0
2017-10-26 10:00:00	MSFT	Stock	79.115	79.12	78.85	79.015	2382447.0
2017-10-26 10:30:00	MSFT	Stock	79.02	79.27	78.92	79.19	1356152.0
2017-10-26 11:00:00	MSFT	Stock	79.195	79.23	78.96	79.016	1349968.0
2017-10-26 11:30:00	MSFT	Stock	79.015	79.11	78.95	79.02	1089293.0
2017-10-26 12:00:00	MSFT	Stock	79.026	79.25	79.025	79.17	1112129.0
2017-10-26 12:30:00	MSFT	Stock	79.17	79.17	79.04	79.12	927675.0
2017-10-26 13:00:00	MSFT	Stock	79.12	79.27	79.065	79.21	812112.0
2017-10-26 13:30:00	MSFT	Stock	79.215	79.25	79.04	79.125	879758.0
2017-10-26 14:00:00	MSFT	Stock	79.125	79.25	79.06	79.14	1245864.0
2017-10-26 14:30:00	MSFT	Stock	79.145	79.24	79.06	79.07	1456087.0
2017-10-26 15:00:00	MSFT	Stock	79.07	79.15	79.06	79.11	1835978.0

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

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