PREVIEW / stock_30min / 2015-04-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-20.parquet
  size:    1.6 MB
  rows:    82,790
  symbols: 3,502

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-04-20 04:00:00	AAPL	Stock	31.375	31.4075	31.3475	31.395	24832.0
2015-04-20 04:30:00	AAPL	Stock	31.395	31.405	31.3875	31.39	10604.0
2015-04-20 05:00:00	AAPL	Stock	31.4	31.4	31.325	31.325	17720.0
2015-04-20 05:30:00	AAPL	Stock	31.36	31.3625	31.355	31.3625	7200.0
2015-04-20 06:00:00	AAPL	Stock	31.355	31.39	31.355	31.39	23332.0
2015-04-20 06:30:00	AAPL	Stock	31.4125	31.425	31.3925	31.425	8460.0
2015-04-20 07:00:00	AAPL	Stock	31.4125	31.4675	31.4125	31.4225	128464.0
2015-04-20 07:30:00	AAPL	Stock	31.4125	31.4175	31.315	31.3425	122284.0
2015-04-20 08:00:00	AAPL	Stock	31.3475	31.4675	31.3	31.3375	465296.0
2015-04-20 08:30:00	AAPL	Stock	31.3375	31.3725	31.3325	31.37	281152.0
2015-04-20 09:00:00	AAPL	Stock	31.37	31.4075	31.34	31.39	476208.0
2015-04-20 09:30:00	AAPL	Stock	31.385	31.6	31.2925	31.5975	27026404.0
2015-04-20 10:00:00	AAPL	Stock	31.5975	31.72	31.53	31.715	21044600.0
2015-04-20 10:30:00	AAPL	Stock	31.7175	31.7875	31.69	31.785	14474580.0
2015-04-20 11:00:00	AAPL	Stock	31.785	31.8725	31.7825	31.87	12412104.0
2015-04-20 11:30:00	AAPL	Stock	31.8725	31.9025	31.83	31.894	10700112.0
2015-04-20 12:00:00	AAPL	Stock	31.895	31.955	31.87	31.9435	8796336.0
2015-04-20 12:30:00	AAPL	Stock	31.945	31.98	31.89	31.9275	8314920.0
2015-04-20 13:00:00	AAPL	Stock	31.9255	32.03	31.9225	31.975	10421776.0
2015-04-20 13:30:00	AAPL	Stock	31.9775	32.0175	31.9635	32.0	6001564.0
2015-04-20 14:00:00	AAPL	Stock	32.0012	32.0125	31.9325	31.9822	7592244.0
2015-04-20 14:30:00	AAPL	Stock	31.9812	31.9875	31.935	31.955	6745072.0
2015-04-20 15:00:00	AAPL	Stock	31.955	31.975	31.8625	31.8675	10946224.0
2015-04-20 15:30:00	AAPL	Stock	31.8675	31.915	31.8275	31.8975	18358516.0
2015-04-20 16:00:00	AAPL	Stock	31.9	31.935	31.8875	31.9125	12468696.0
2015-04-20 16:30:00	AAPL	Stock	31.92	31.9225	31.8825	31.8825	94236.0
2015-04-20 17:00:00	AAPL	Stock	31.8975	31.8975	31.8775	31.8875	58508.0
2015-04-20 17:30:00	AAPL	Stock	31.89	31.9075	31.8875	31.9	28040.0
2015-04-20 18:00:00	AAPL	Stock	31.8975	31.91	31.8925	31.905	37948.0
2015-04-20 18:30:00	AAPL	Stock	31.91	31.91	31.905	31.905	9996.0
2015-04-20 19:00:00	AAPL	Stock	31.9	31.9125	31.895	31.9125	62096.0
2015-04-20 19:30:00	AAPL	Stock	31.9125	31.925	31.9125	31.925	74440.0
2015-04-20 05:00:00	MSFT	Stock	41.68	41.68	41.66	41.66	200.0
2015-04-20 05:30:00	MSFT	Stock	41.62	41.62	41.62	41.62	100.0
2015-04-20 07:00:00	MSFT	Stock	41.75	41.75	41.75	41.75	1000.0
2015-04-20 07:30:00	MSFT	Stock	41.68	41.68	41.68	41.68	100.0
2015-04-20 08:00:00	MSFT	Stock	41.66	41.73	41.64	41.699	3753.0
2015-04-20 08:30:00	MSFT	Stock	41.615	41.73	41.615	41.73	8807.0
2015-04-20 09:00:00	MSFT	Stock	41.7	41.76	41.64	41.73	5856.0
2015-04-20 09:30:00	MSFT	Stock	41.72	42.21	41.68	42.2	3663311.0
2015-04-20 10:00:00	MSFT	Stock	42.21	42.32	42.17	42.315	2505320.0
2015-04-20 10:30:00	MSFT	Stock	42.32	42.49	42.28	42.48	2303485.0
2015-04-20 11:00:00	MSFT	Stock	42.48	42.62	42.48	42.5	2694965.0
2015-04-20 11:30:00	MSFT	Stock	42.5	42.64	42.49	42.63	1672449.0
2015-04-20 12:00:00	MSFT	Stock	42.63	42.82	42.615	42.795	1776713.0
2015-04-20 12:30:00	MSFT	Stock	42.795	42.86	42.73	42.855	1570679.0
2015-04-20 13:00:00	MSFT	Stock	42.85	43.05	42.84	42.965	3625523.0
2015-04-20 13:30:00	MSFT	Stock	42.965	43.11	42.95	43.035	3295388.0
2015-04-20 14:00:00	MSFT	Stock	43.035	43.04	42.83	42.865	2683095.0
2015-04-20 14:30:00	MSFT	Stock	42.865	43.04	42.83	43.0	2406570.0

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

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