PREVIEW / stock_30min / 2015-06-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-01.parquet
  size:    1.6 MB
  rows:    82,864
  symbols: 3,503

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-06-01 04:00:00	AAPL	Stock	32.5	32.7125	32.5	32.7125	25836.0
2015-06-01 04:30:00	AAPL	Stock	32.7125	32.7175	32.67	32.7175	18552.0
2015-06-01 05:30:00	AAPL	Stock	32.6	32.6	32.6	32.6	400.0
2015-06-01 06:00:00	AAPL	Stock	32.605	32.6625	32.605	32.6625	18616.0
2015-06-01 06:30:00	AAPL	Stock	32.6625	32.675	32.6425	32.6425	14284.0
2015-06-01 07:00:00	AAPL	Stock	32.64	32.745	32.64	32.6525	36624.0
2015-06-01 07:30:00	AAPL	Stock	32.6975	32.775	32.6975	32.765	72676.0
2015-06-01 08:00:00	AAPL	Stock	32.75	32.775	32.65	32.75	368560.0
2015-06-01 08:30:00	AAPL	Stock	32.75	32.76	32.68	32.7375	320344.0
2015-06-01 09:00:00	AAPL	Stock	32.735	32.865	32.735	32.84	369664.0
2015-06-01 09:30:00	AAPL	Stock	32.84	32.865	32.535	32.6775	26253956.0
2015-06-01 10:00:00	AAPL	Stock	32.6775	32.7425	32.5125	32.6355	16029240.0
2015-06-01 10:30:00	AAPL	Stock	32.63	32.65	32.5375	32.6325	8273832.0
2015-06-01 11:00:00	AAPL	Stock	32.6325	32.715	32.575	32.59	7966112.0
2015-06-01 11:30:00	AAPL	Stock	32.5875	32.6325	32.57	32.5912	4298236.0
2015-06-01 12:00:00	AAPL	Stock	32.5912	32.7475	32.5775	32.745	7422096.0
2015-06-01 12:30:00	AAPL	Stock	32.7475	32.7488	32.7112	32.7328	5759960.0
2015-06-01 13:00:00	AAPL	Stock	32.7362	32.75	32.675	32.695	5529380.0
2015-06-01 13:30:00	AAPL	Stock	32.695	32.7178	32.675	32.6965	4127228.0
2015-06-01 14:00:00	AAPL	Stock	32.6975	32.7175	32.6425	32.7062	5154660.0
2015-06-01 14:30:00	AAPL	Stock	32.7075	32.7175	32.66	32.6965	4443040.0
2015-06-01 15:00:00	AAPL	Stock	32.696	32.7125	32.6625	32.6675	4335632.0
2015-06-01 15:30:00	AAPL	Stock	32.67	32.6725	32.5925	32.6325	10414004.0
2015-06-01 16:00:00	AAPL	Stock	32.6275	32.6725	32.605	32.615	5023228.0
2015-06-01 16:30:00	AAPL	Stock	32.615	32.6948	32.615	32.6948	94772.0
2015-06-01 17:00:00	AAPL	Stock	32.6325	32.665	32.6325	32.66	136768.0
2015-06-01 17:30:00	AAPL	Stock	32.66	32.6825	32.6575	32.67	108776.0
2015-06-01 18:00:00	AAPL	Stock	32.6625	32.67	32.635	32.65	86980.0
2015-06-01 18:30:00	AAPL	Stock	32.65	32.6625	32.6475	32.6625	18088.0
2015-06-01 19:00:00	AAPL	Stock	32.6575	32.6625	32.655	32.6625	24672.0
2015-06-01 19:30:00	AAPL	Stock	32.6625	32.675	32.6625	32.6725	58952.0
2015-06-01 04:30:00	MSFT	Stock	47.07	47.07	47.07	47.07	100.0
2015-06-01 05:30:00	MSFT	Stock	46.97	46.97	46.97	46.97	100.0
2015-06-01 06:00:00	MSFT	Stock	46.93	46.93	46.93	46.93	200.0
2015-06-01 06:30:00	MSFT	Stock	46.97	46.97	46.97	46.97	722.0
2015-06-01 07:00:00	MSFT	Stock	46.91	46.99	46.9	46.99	2900.0
2015-06-01 08:00:00	MSFT	Stock	47.17	47.19	47.12	47.19	10170.0
2015-06-01 08:30:00	MSFT	Stock	47.22	47.22	47.16	47.16	8830.0
2015-06-01 09:00:00	MSFT	Stock	46.86	47.22	46.86	47.06	60885.0
2015-06-01 09:30:00	MSFT	Stock	47.06	47.3	46.76	46.82	3465346.0
2015-06-01 10:00:00	MSFT	Stock	46.83	47.02	46.62	46.72	2368593.0
2015-06-01 10:30:00	MSFT	Stock	46.71	46.96	46.63	46.905	1838777.0
2015-06-01 11:00:00	MSFT	Stock	46.905	47.16	46.89	47.06	1508589.0
2015-06-01 11:30:00	MSFT	Stock	47.05	47.2	47.04	47.105	1186431.0
2015-06-01 12:00:00	MSFT	Stock	47.105	47.44	47.09	47.38	1416089.0
2015-06-01 12:30:00	MSFT	Stock	47.39	47.54	47.33	47.52	1271831.0
2015-06-01 13:00:00	MSFT	Stock	47.52	47.77	47.5	47.64	2309956.0
2015-06-01 13:30:00	MSFT	Stock	47.65	47.71	47.55	47.605	903661.0
2015-06-01 14:00:00	MSFT	Stock	47.605	47.68	47.49	47.645	1074301.0
2015-06-01 14:30:00	MSFT	Stock	47.64	47.68	47.48	47.55	1161500.0

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

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