PREVIEW / stock_30min / 2015-10-07

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-07.parquet
  size:    1.6 MB
  rows:    82,635
  symbols: 3,438

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
2015-10-07 04:00:00	AAPL	Stock	27.8325	27.915	27.825	27.915	26416.0
2015-10-07 04:30:00	AAPL	Stock	27.9175	27.965	27.9175	27.945	24800.0
2015-10-07 05:00:00	AAPL	Stock	27.9425	27.95	27.9075	27.95	19088.0
2015-10-07 05:30:00	AAPL	Stock	27.95	27.975	27.9375	27.95	13884.0
2015-10-07 06:00:00	AAPL	Stock	27.9275	27.9375	27.79	27.82	43636.0
2015-10-07 06:30:00	AAPL	Stock	27.875	27.8925	27.765	27.765	18040.0
2015-10-07 07:00:00	AAPL	Stock	27.7575	27.8975	27.7575	27.81	118532.0
2015-10-07 07:30:00	AAPL	Stock	27.8625	27.9375	27.86	27.935	188216.0
2015-10-07 08:00:00	AAPL	Stock	27.9325	28.0325	27.8	28.0125	477780.0
2015-10-07 08:30:00	AAPL	Stock	28.0125	28.0375	27.9675	27.9775	486528.0
2015-10-07 09:00:00	AAPL	Stock	27.985	28.0	27.9125	27.925	335808.0
2015-10-07 09:30:00	AAPL	Stock	27.9275	27.9425	27.7075	27.8412	26158972.0
2015-10-07 10:00:00	AAPL	Stock	27.8412	27.8575	27.7025	27.7375	15315764.0
2015-10-07 10:30:00	AAPL	Stock	27.7378	27.741	27.59	27.685	13930888.0
2015-10-07 11:00:00	AAPL	Stock	27.685	27.685	27.3525	27.385	20073888.0
2015-10-07 11:30:00	AAPL	Stock	27.3898	27.5375	27.3725	27.52	13330372.0
2015-10-07 12:00:00	AAPL	Stock	27.52	27.53	27.38	27.3995	9545060.0
2015-10-07 12:30:00	AAPL	Stock	27.4	27.4425	27.3525	27.39	7951312.0
2015-10-07 13:00:00	AAPL	Stock	27.39	27.5438	27.385	27.5075	8524428.0
2015-10-07 13:30:00	AAPL	Stock	27.5075	27.6225	27.5075	27.6125	9878088.0
2015-10-07 14:00:00	AAPL	Stock	27.615	27.6625	27.5275	27.555	8846864.0
2015-10-07 14:30:00	AAPL	Stock	27.555	27.665	27.5375	27.6025	9596888.0
2015-10-07 15:00:00	AAPL	Stock	27.6075	27.7025	27.5982	27.645	10189660.0
2015-10-07 15:30:00	AAPL	Stock	27.6475	27.6925	27.595	27.6925	15755444.0
2015-10-07 16:00:00	AAPL	Stock	27.6925	27.695	27.66	27.675	3780368.0
2015-10-07 16:30:00	AAPL	Stock	27.67	27.685	27.67	27.6825	71868.0
2015-10-07 17:00:00	AAPL	Stock	27.68	27.6875	27.68	27.685	83600.0
2015-10-07 17:30:00	AAPL	Stock	27.68	27.6875	27.68	27.6875	42976.0
2015-10-07 18:00:00	AAPL	Stock	27.6775	27.6875	27.6775	27.6825	16136.0
2015-10-07 18:30:00	AAPL	Stock	27.6875	27.6975	27.6875	27.69	23384.0
2015-10-07 19:00:00	AAPL	Stock	27.69	27.695	27.69	27.69	6720.0
2015-10-07 19:30:00	AAPL	Stock	27.6925	27.7025	27.69	27.7025	43880.0
2015-10-07 04:00:00	MSFT	Stock	47.0	47.2	47.0	47.2	260.0
2015-10-07 04:30:00	MSFT	Stock	47.19	47.19	47.14	47.14	1400.0
2015-10-07 05:00:00	MSFT	Stock	47.14	47.14	47.14	47.14	100.0
2015-10-07 06:00:00	MSFT	Stock	47.1	47.12	47.0	47.07	1771.0
2015-10-07 07:00:00	MSFT	Stock	47.08	47.1	47.08	47.1	2099.0
2015-10-07 07:30:00	MSFT	Stock	47.07	47.15	47.07	47.07	4310.0
2015-10-07 08:00:00	MSFT	Stock	47.1	47.13	47.03	47.11	44866.0
2015-10-07 08:30:00	MSFT	Stock	47.09	47.14	47.09	47.09	8618.0
2015-10-07 09:00:00	MSFT	Stock	47.12	47.14	47.03	47.04	17206.0
2015-10-07 09:30:00	MSFT	Stock	47.1	47.35	46.905	46.995	3323061.0
2015-10-07 10:00:00	MSFT	Stock	46.99	47.06	46.8	46.81	1825187.0
2015-10-07 10:30:00	MSFT	Stock	46.81	46.815	46.26	46.29	3015456.0
2015-10-07 11:00:00	MSFT	Stock	46.29	46.295	45.95	46.12	2490657.0
2015-10-07 11:30:00	MSFT	Stock	46.12	46.41	46.07	46.39	1477018.0
2015-10-07 12:00:00	MSFT	Stock	46.385	46.45	46.22	46.26	1090475.0
2015-10-07 12:30:00	MSFT	Stock	46.26	46.435	46.21	46.33	672331.0
2015-10-07 13:00:00	MSFT	Stock	46.328	46.44	46.26	46.375	757211.0
2015-10-07 13:30:00	MSFT	Stock	46.37	46.47	46.34	46.43	1198325.0

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

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