PREVIEW / stock_30min / 2017-07-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-28.parquet
  size:    1.6 MB
  rows:    79,828
  symbols: 2,969

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-28 04:30:00	AAPL	Stock	37.3725	37.375	37.3025	37.3675	10100.0
2017-07-28 05:30:00	AAPL	Stock	37.325	37.3725	37.325	37.325	9600.0
2017-07-28 06:00:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 06:30:00	AAPL	Stock	37.325	37.355	37.325	37.3375	16752.0
2017-07-28 07:00:00	AAPL	Stock	37.375	37.4225	37.375	37.4075	12128.0
2017-07-28 07:30:00	AAPL	Stock	37.39	37.4325	37.39	37.4175	7992.0
2017-07-28 08:00:00	AAPL	Stock	37.445	37.4475	37.3775	37.3775	90700.0
2017-07-28 08:30:00	AAPL	Stock	37.3875	37.4575	37.3775	37.4575	71088.0
2017-07-28 09:00:00	AAPL	Stock	37.4625	37.4925	37.4	37.475	216740.0
2017-07-28 09:30:00	AAPL	Stock	37.485	37.5575	37.315	37.38	12389304.0
2017-07-28 10:00:00	AAPL	Stock	37.3802	37.55	37.375	37.435	4645484.0
2017-07-28 10:30:00	AAPL	Stock	37.4312	37.5	37.3775	37.41	3891568.0
2017-07-28 11:00:00	AAPL	Stock	37.41	37.4625	37.365	37.407	4308808.0
2017-07-28 11:30:00	AAPL	Stock	37.405	37.4512	37.3775	37.433	2784620.0
2017-07-28 12:00:00	AAPL	Stock	37.4325	37.5215	37.4225	37.4725	2624860.0
2017-07-28 12:30:00	AAPL	Stock	37.4738	37.5325	37.4525	37.51	2804068.0
2017-07-28 13:00:00	AAPL	Stock	37.5102	37.5225	37.4375	37.5	1727964.0
2017-07-28 13:30:00	AAPL	Stock	37.5012	37.5125	37.4575	37.4652	2481160.0
2017-07-28 14:00:00	AAPL	Stock	37.47	37.5075	37.46	37.485	1994296.0
2017-07-28 14:30:00	AAPL	Stock	37.485	37.5075	37.4475	37.46	2646628.0
2017-07-28 15:00:00	AAPL	Stock	37.46	37.4725	37.3425	37.3598	4099108.0
2017-07-28 15:30:00	AAPL	Stock	37.36	37.385	37.2975	37.3725	8674136.0
2017-07-28 16:00:00	AAPL	Stock	37.375	37.375	37.3325	37.355	5544900.0
2017-07-28 16:30:00	AAPL	Stock	37.3575	37.375	37.355	37.3625	576240.0
2017-07-28 17:00:00	AAPL	Stock	37.35	37.3525	37.35	37.3525	2880.0
2017-07-28 17:30:00	AAPL	Stock	37.3425	37.3625	37.3425	37.3475	12408.0
2017-07-28 18:00:00	AAPL	Stock	37.3575	37.3625	37.345	37.345	34136.0
2017-07-28 18:30:00	AAPL	Stock	37.375	37.375	37.3625	37.3625	8140.0
2017-07-28 19:00:00	AAPL	Stock	37.3475	37.3625	37.3475	37.3625	2920.0
2017-07-28 19:30:00	AAPL	Stock	37.35	37.37	37.35	37.37	18776.0
2017-07-28 06:00:00	MSFT	Stock	72.56	72.56	72.56	72.56	1500.0
2017-07-28 06:30:00	MSFT	Stock	72.61	72.61	72.61	72.61	1432.0
2017-07-28 07:00:00	MSFT	Stock	72.61	72.76	72.55	72.75	3548.0
2017-07-28 07:30:00	MSFT	Stock	72.76	72.76	72.68	72.68	889.0
2017-07-28 08:00:00	MSFT	Stock	72.75	72.79	72.65	72.65	13251.0
2017-07-28 08:30:00	MSFT	Stock	72.75	72.78	72.56	72.78	13144.0
2017-07-28 09:00:00	MSFT	Stock	72.74	72.84	72.56	72.72	47243.0
2017-07-28 09:30:00	MSFT	Stock	72.72	73.12	72.54	72.91	2374639.0
2017-07-28 10:00:00	MSFT	Stock	72.9	73.03	72.68	72.88	1144853.0
2017-07-28 10:30:00	MSFT	Stock	72.88	73.01	72.8	72.92	890353.0
2017-07-28 11:00:00	MSFT	Stock	72.93	73.03	72.82	72.89	955889.0
2017-07-28 11:30:00	MSFT	Stock	72.89	73.07	72.88	72.995	1142941.0
2017-07-28 12:00:00	MSFT	Stock	72.99	73.13	72.96	73.1	785027.0
2017-07-28 12:30:00	MSFT	Stock	73.1	73.31	73.09	73.245	751135.0
2017-07-28 13:00:00	MSFT	Stock	73.245	73.29	73.075	73.14	637934.0
2017-07-28 13:30:00	MSFT	Stock	73.135	73.275	73.13	73.175	588252.0
2017-07-28 14:00:00	MSFT	Stock	73.175	73.2	73.06	73.095	716795.0
2017-07-28 14:30:00	MSFT	Stock	73.09	73.19	73.04	73.13	701982.0
2017-07-28 15:00:00	MSFT	Stock	73.14	73.175	72.98	73.05	1115767.0
2017-07-28 15:30:00	MSFT	Stock	73.05	73.1	72.975	73.03	2046052.0

> showing 50 of 79,828 rows — these rows as CSV

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