PREVIEW / stock_30min / 2017-07-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-12.parquet
  size:    1.6 MB
  rows:    81,266
  symbols: 3,007

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-12 05:00:00	AAPL	Stock	36.45	36.45	36.45	36.45	400.0
2017-07-12 05:30:00	AAPL	Stock	36.4425	36.5	36.4425	36.5	7104.0
2017-07-12 06:00:00	AAPL	Stock	36.4875	36.4875	36.4875	36.4875	14000.0
2017-07-12 06:30:00	AAPL	Stock	36.4675	36.4925	36.465	36.465	15796.0
2017-07-12 07:00:00	AAPL	Stock	36.4625	36.5375	36.4625	36.5375	37516.0
2017-07-12 07:30:00	AAPL	Stock	36.5375	36.5375	36.45	36.4625	122944.0
2017-07-12 08:00:00	AAPL	Stock	36.45	36.5525	36.3975	36.4375	129016.0
2017-07-12 08:30:00	AAPL	Stock	36.4475	36.57	36.4475	36.53	273468.0
2017-07-12 09:00:00	AAPL	Stock	36.53	36.5475	36.4425	36.4525	643972.0
2017-07-12 09:30:00	AAPL	Stock	36.455	36.545	36.24	36.3225	16273684.0
2017-07-12 10:00:00	AAPL	Stock	36.325	36.38	36.22	36.3175	9079008.0
2017-07-12 10:30:00	AAPL	Stock	36.318	36.3225	36.205	36.2262	7225592.0
2017-07-12 11:00:00	AAPL	Stock	36.2262	36.395	36.225	36.336	5209800.0
2017-07-12 11:30:00	AAPL	Stock	36.335	36.35	36.28	36.295	3652556.0
2017-07-12 12:00:00	AAPL	Stock	36.2955	36.31	36.2425	36.309	4714368.0
2017-07-12 12:30:00	AAPL	Stock	36.31	36.3225	36.2875	36.315	2058868.0
2017-07-12 13:00:00	AAPL	Stock	36.3152	36.325	36.2525	36.3088	2849824.0
2017-07-12 13:30:00	AAPL	Stock	36.3088	36.4	36.305	36.3962	3438608.0
2017-07-12 14:00:00	AAPL	Stock	36.3975	36.4375	36.3525	36.425	3296024.0
2017-07-12 14:30:00	AAPL	Stock	36.425	36.4775	36.4025	36.4688	3937376.0
2017-07-12 15:00:00	AAPL	Stock	36.47	36.515	36.45	36.4725	6109224.0
2017-07-12 15:30:00	AAPL	Stock	36.4728	36.5125	36.4225	36.4425	9041264.0
2017-07-12 16:00:00	AAPL	Stock	36.435	36.47	36.375	36.38	6442284.0
2017-07-12 16:30:00	AAPL	Stock	36.4	36.4	36.35	36.375	40088.0
2017-07-12 17:00:00	AAPL	Stock	36.375	36.435	36.3475	36.435	100660.0
2017-07-12 17:30:00	AAPL	Stock	36.3675	36.375	36.3475	36.35	31860.0
2017-07-12 18:00:00	AAPL	Stock	36.35	36.375	36.35	36.355	18300.0
2017-07-12 18:30:00	AAPL	Stock	36.3675	36.3675	36.355	36.3675	2000.0
2017-07-12 19:00:00	AAPL	Stock	36.375	36.375	36.3675	36.37	15248.0
2017-07-12 19:30:00	AAPL	Stock	36.375	36.375	36.3525	36.3625	21352.0
2017-07-12 08:00:00	MSFT	Stock	70.55	70.55	70.39	70.39	300.0
2017-07-12 08:30:00	MSFT	Stock	70.11	70.5	70.11	70.38	5270.0
2017-07-12 09:00:00	MSFT	Stock	70.58	70.83	70.55	70.64	26220.0
2017-07-12 09:30:00	MSFT	Stock	70.65	70.86	70.55	70.81	2079993.0
2017-07-12 10:00:00	MSFT	Stock	70.81	70.98	70.785	70.906	1441791.0
2017-07-12 10:30:00	MSFT	Stock	70.92	70.93	70.74	70.87	929216.0
2017-07-12 11:00:00	MSFT	Stock	70.86	71.03	70.86	70.99	1138647.0
2017-07-12 11:30:00	MSFT	Stock	70.99	70.99	70.84	70.885	595793.0
2017-07-12 12:00:00	MSFT	Stock	70.89	71.04	70.82	70.9	867608.0
2017-07-12 12:30:00	MSFT	Stock	70.91	70.95	70.85	70.88	466822.0
2017-07-12 13:00:00	MSFT	Stock	70.88	70.94	70.81	70.83	456015.0
2017-07-12 13:30:00	MSFT	Stock	70.84	70.971	70.82	70.955	645573.0
2017-07-12 14:00:00	MSFT	Stock	70.95	70.98	70.83	70.976	608449.0
2017-07-12 14:30:00	MSFT	Stock	70.975	71.04	70.945	70.995	645659.0
2017-07-12 15:00:00	MSFT	Stock	70.99	71.14	70.97	71.09	999490.0
2017-07-12 15:30:00	MSFT	Stock	71.09	71.28	71.085	71.15	3357965.0
2017-07-12 16:00:00	MSFT	Stock	71.15	71.16	71.1	71.15	1959361.0
2017-07-12 16:30:00	MSFT	Stock	71.09	71.15	71.09	71.15	334.0
2017-07-12 17:00:00	MSFT	Stock	71.24	71.24	71.24	71.24	200.0
2017-07-12 18:00:00	MSFT	Stock	71.12	71.12	71.12	71.12	200.0

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

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