PREVIEW / stock_30min / 2017-10-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-24.parquet
  size:    1.6 MB
  rows:    82,225
  symbols: 2,936

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-24 04:00:00	AAPL	Stock	38.825	39.1875	38.825	39.125	27688.0
2017-10-24 04:30:00	AAPL	Stock	39.125	39.125	39.1125	39.1125	8400.0
2017-10-24 05:00:00	AAPL	Stock	39.1125	39.1875	39.1125	39.1875	9768.0
2017-10-24 05:30:00	AAPL	Stock	39.1725	39.185	38.775	38.775	76576.0
2017-10-24 06:00:00	AAPL	Stock	38.7625	38.825	38.7325	38.8	50696.0
2017-10-24 06:30:00	AAPL	Stock	38.825	38.9325	38.82	38.9325	46204.0
2017-10-24 07:00:00	AAPL	Stock	38.925	39.04	38.925	39.0	128100.0
2017-10-24 07:30:00	AAPL	Stock	39.0	39.025	38.97	39.0125	110272.0
2017-10-24 08:00:00	AAPL	Stock	39.02	39.085	38.9162	39.085	323664.0
2017-10-24 08:30:00	AAPL	Stock	39.0875	39.1975	39.0875	39.155	312300.0
2017-10-24 09:00:00	AAPL	Stock	39.145	39.175	39.0625	39.07	273712.0
2017-10-24 09:30:00	AAPL	Stock	39.07	39.2375	39.05	39.2	12247544.0
2017-10-24 10:00:00	AAPL	Stock	39.1995	39.355	39.1975	39.3075	7009644.0
2017-10-24 10:30:00	AAPL	Stock	39.3075	39.35	39.225	39.2275	5321572.0
2017-10-24 11:00:00	AAPL	Stock	39.2275	39.2785	39.2125	39.2537	4783408.0
2017-10-24 11:30:00	AAPL	Stock	39.2525	39.3125	39.2375	39.24	3098744.0
2017-10-24 12:00:00	AAPL	Stock	39.24	39.2575	39.215	39.23	2034760.0
2017-10-24 12:30:00	AAPL	Stock	39.2325	39.295	39.23	39.255	2342252.0
2017-10-24 13:00:00	AAPL	Stock	39.255	39.2848	39.2175	39.2675	2001500.0
2017-10-24 13:30:00	AAPL	Stock	39.2675	39.3225	39.26	39.28	2335632.0
2017-10-24 14:00:00	AAPL	Stock	39.2825	39.2925	39.25	39.2518	1638120.0
2017-10-24 14:30:00	AAPL	Stock	39.255	39.2722	39.1825	39.191	2944928.0
2017-10-24 15:00:00	AAPL	Stock	39.19	39.25	39.1325	39.2175	4217604.0
2017-10-24 15:30:00	AAPL	Stock	39.2152	39.275	39.195	39.2725	6120384.0
2017-10-24 16:00:00	AAPL	Stock	39.2725	39.275	39.25	39.255	4372828.0
2017-10-24 16:30:00	AAPL	Stock	39.2625	39.275	39.2125	39.215	30168.0
2017-10-24 17:00:00	AAPL	Stock	39.22	39.23	39.215	39.2175	7860.0
2017-10-24 17:30:00	AAPL	Stock	39.22	39.2625	39.2175	39.2625	12296.0
2017-10-24 18:00:00	AAPL	Stock	39.275	39.275	39.225	39.25	408300.0
2017-10-24 18:30:00	AAPL	Stock	39.25	39.2525	39.215	39.215	15488.0
2017-10-24 19:00:00	AAPL	Stock	39.2025	39.225	39.2025	39.225	6008.0
2017-10-24 19:30:00	AAPL	Stock	39.205	39.205	39.175	39.175	21372.0
2017-10-24 04:30:00	MSFT	Stock	78.92	78.92	78.9	78.9	605.0
2017-10-24 07:30:00	MSFT	Stock	78.93	78.93	78.93	78.93	267.0
2017-10-24 08:00:00	MSFT	Stock	78.84	79.1	78.84	79.0	5476.0
2017-10-24 08:30:00	MSFT	Stock	79.08	79.08	78.93	79.0	1986.0
2017-10-24 09:00:00	MSFT	Stock	79.01	79.07	78.88	78.92	48696.0
2017-10-24 09:30:00	MSFT	Stock	78.91	79.0	78.46	78.635	3206779.0
2017-10-24 10:00:00	MSFT	Stock	78.64	78.825	78.63	78.763	1129495.0
2017-10-24 10:30:00	MSFT	Stock	78.76	78.94	78.7	78.92	790654.0
2017-10-24 11:00:00	MSFT	Stock	78.912	79.16	78.91	79.08	869235.0
2017-10-24 11:30:00	MSFT	Stock	79.075	79.2	79.01	79.155	760177.0
2017-10-24 12:00:00	MSFT	Stock	79.15	79.19	79.07	79.17	581602.0
2017-10-24 12:30:00	MSFT	Stock	79.175	79.19	79.08	79.105	445130.0
2017-10-24 13:00:00	MSFT	Stock	79.11	79.146	79.06	79.1	418446.0
2017-10-24 13:30:00	MSFT	Stock	79.112	79.2	79.08	79.11	525754.0
2017-10-24 14:00:00	MSFT	Stock	79.105	79.18	79.1	79.1	502600.0
2017-10-24 14:30:00	MSFT	Stock	79.1	79.14	78.935	78.96	801355.0
2017-10-24 15:00:00	MSFT	Stock	78.96	79.0	78.8	78.81	1143209.0
2017-10-24 15:30:00	MSFT	Stock	78.815	78.86	78.71	78.86	2182389.0

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

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