PREVIEW / stock_30min / 2015-07-29

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-29.parquet
  size:    1.6 MB
  rows:    81,754
  symbols: 3,480

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-07-29 04:00:00	AAPL	Stock	30.9575	30.9575	30.8725	30.8725	8800.0
2015-07-29 04:30:00	AAPL	Stock	30.875	30.9125	30.875	30.9125	800.0
2015-07-29 05:00:00	AAPL	Stock	30.915	30.955	30.9125	30.955	3600.0
2015-07-29 05:30:00	AAPL	Stock	30.94	30.9725	30.9275	30.9725	19008.0
2015-07-29 06:00:00	AAPL	Stock	30.96	30.96	30.875	30.875	5600.0
2015-07-29 06:30:00	AAPL	Stock	30.92	30.92	30.905	30.905	7700.0
2015-07-29 07:00:00	AAPL	Stock	30.9	30.905	30.8525	30.8525	25560.0
2015-07-29 07:30:00	AAPL	Stock	30.8475	30.8625	30.835	30.8625	23864.0
2015-07-29 08:00:00	AAPL	Stock	30.8625	30.9225	30.77	30.7775	292472.0
2015-07-29 08:30:00	AAPL	Stock	30.78	30.785	30.715	30.7495	245384.0
2015-07-29 09:00:00	AAPL	Stock	30.7525	30.8	30.7275	30.8	230608.0
2015-07-29 09:30:00	AAPL	Stock	30.7875	30.875	30.65	30.6782	17571180.0
2015-07-29 10:00:00	AAPL	Stock	30.6775	30.695	30.5675	30.6768	14867208.0
2015-07-29 10:30:00	AAPL	Stock	30.6775	30.77	30.66	30.6825	9320892.0
2015-07-29 11:00:00	AAPL	Stock	30.68	30.7075	30.625	30.64	7451036.0
2015-07-29 11:30:00	AAPL	Stock	30.64	30.7025	30.6325	30.69	4973520.0
2015-07-29 12:00:00	AAPL	Stock	30.6875	30.705	30.62	30.645	5040020.0
2015-07-29 12:30:00	AAPL	Stock	30.6442	30.68	30.615	30.645	4256996.0
2015-07-29 13:00:00	AAPL	Stock	30.6462	30.6875	30.6375	30.6815	3664632.0
2015-07-29 13:30:00	AAPL	Stock	30.6835	30.7325	30.65	30.6925	4282296.0
2015-07-29 14:00:00	AAPL	Stock	30.6905	30.775	30.62	30.7375	11180164.0
2015-07-29 14:30:00	AAPL	Stock	30.74	30.82	30.7362	30.78	8831384.0
2015-07-29 15:00:00	AAPL	Stock	30.7825	30.795	30.6962	30.7225	8379544.0
2015-07-29 15:30:00	AAPL	Stock	30.7225	30.7475	30.66	30.745	16786968.0
2015-07-29 16:00:00	AAPL	Stock	30.7475	30.7475	30.5775	30.6	8376860.0
2015-07-29 16:30:00	AAPL	Stock	30.6	30.7475	30.6	30.6638	2572040.0
2015-07-29 17:00:00	AAPL	Stock	30.6325	30.6925	30.63	30.675	167328.0
2015-07-29 17:30:00	AAPL	Stock	30.675	30.725	30.6625	30.665	145296.0
2015-07-29 18:00:00	AAPL	Stock	30.665	30.675	30.6375	30.64	66116.0
2015-07-29 18:30:00	AAPL	Stock	30.64	30.6625	30.6375	30.6475	33260.0
2015-07-29 19:00:00	AAPL	Stock	30.6375	30.65	30.6375	30.65	20404.0
2015-07-29 19:30:00	AAPL	Stock	30.64	30.675	30.64	30.64	64964.0
2015-07-29 06:00:00	MSFT	Stock	45.41	45.41	45.41	45.41	100.0
2015-07-29 07:30:00	MSFT	Stock	45.67	45.69	45.5	45.6	5613.0
2015-07-29 08:00:00	MSFT	Stock	45.49	45.59	45.48	45.48	20995.0
2015-07-29 08:30:00	MSFT	Stock	45.48	45.49	45.48	45.48	2152.0
2015-07-29 09:00:00	MSFT	Stock	45.45	45.49	45.2	45.29	24738.0
2015-07-29 09:30:00	MSFT	Stock	45.37	45.785	45.26	45.51	2846405.0
2015-07-29 10:00:00	MSFT	Stock	45.51	45.85	45.421	45.77	2369458.0
2015-07-29 10:30:00	MSFT	Stock	45.78	45.99	45.775	45.94	2235532.0
2015-07-29 11:00:00	MSFT	Stock	45.94	46.16	45.89	45.983	2917079.0
2015-07-29 11:30:00	MSFT	Stock	45.98	46.44	45.96	46.42	2673625.0
2015-07-29 12:00:00	MSFT	Stock	46.42	46.48	46.3	46.475	2114837.0
2015-07-29 12:30:00	MSFT	Stock	46.47	46.65	46.43	46.636	2334238.0
2015-07-29 13:00:00	MSFT	Stock	46.63	46.78	46.605	46.66	2532068.0
2015-07-29 13:30:00	MSFT	Stock	46.67	46.67	46.44	46.55	2413212.0
2015-07-29 14:00:00	MSFT	Stock	46.55	46.705	46.38	46.45	2890684.0
2015-07-29 14:30:00	MSFT	Stock	46.45	46.67	46.41	46.56	2267761.0
2015-07-29 15:00:00	MSFT	Stock	46.56	46.58	46.31	46.365	3108633.0
2015-07-29 15:30:00	MSFT	Stock	46.37	46.38	46.24	46.28	5970845.0

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

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