PREVIEW / stock_30min / 2017-03-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-08.parquet
  size:    1.6 MB
  rows:    82,567
  symbols: 3,098

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-03-08 05:30:00	AAPL	Stock	34.92	34.92	34.92	34.92	1040.0
2017-03-08 06:00:00	AAPL	Stock	34.9075	34.9125	34.875	34.875	9944.0
2017-03-08 06:30:00	AAPL	Stock	34.875	34.9075	34.875	34.9075	2260.0
2017-03-08 07:00:00	AAPL	Stock	34.875	34.875	34.7675	34.7675	92432.0
2017-03-08 07:30:00	AAPL	Stock	34.7625	34.8075	34.725	34.8075	95856.0
2017-03-08 08:00:00	AAPL	Stock	34.7625	34.8075	34.7	34.78	373716.0
2017-03-08 08:30:00	AAPL	Stock	34.775	34.785	34.6775	34.73	379884.0
2017-03-08 09:00:00	AAPL	Stock	34.7375	34.75	34.705	34.725	198080.0
2017-03-08 09:30:00	AAPL	Stock	34.7375	34.9	34.725	34.8988	12698388.0
2017-03-08 10:00:00	AAPL	Stock	34.9	34.905	34.8075	34.88	5172828.0
2017-03-08 10:30:00	AAPL	Stock	34.88	34.9375	34.855	34.925	4348008.0
2017-03-08 11:00:00	AAPL	Stock	34.9238	34.95	34.9	34.915	3434280.0
2017-03-08 11:30:00	AAPL	Stock	34.915	34.915	34.7825	34.7975	4808420.0
2017-03-08 12:00:00	AAPL	Stock	34.7975	34.815	34.7775	34.795	3229964.0
2017-03-08 12:30:00	AAPL	Stock	34.7975	34.8488	34.7962	34.81	2262392.0
2017-03-08 13:00:00	AAPL	Stock	34.81	34.8575	34.8038	34.8237	1939808.0
2017-03-08 13:30:00	AAPL	Stock	34.825	34.8525	34.8125	34.835	2143796.0
2017-03-08 14:00:00	AAPL	Stock	34.8358	34.8575	34.725	34.7412	4259624.0
2017-03-08 14:30:00	AAPL	Stock	34.74	34.7775	34.7305	34.7762	2989936.0
2017-03-08 15:00:00	AAPL	Stock	34.7762	34.8075	34.7625	34.78	2767992.0
2017-03-08 15:30:00	AAPL	Stock	34.78	34.7812	34.705	34.7525	7462676.0
2017-03-08 16:00:00	AAPL	Stock	34.75	34.765	34.75	34.75	7442784.0
2017-03-08 16:30:00	AAPL	Stock	34.745	34.76	34.7425	34.7425	12644.0
2017-03-08 17:00:00	AAPL	Stock	34.75	34.7525	34.7425	34.75	34592.0
2017-03-08 17:30:00	AAPL	Stock	34.75	34.75	34.7275	34.73	5664.0
2017-03-08 18:00:00	AAPL	Stock	34.75	34.7525	34.75	34.75	6908.0
2017-03-08 18:30:00	AAPL	Stock	34.76	34.76	34.76	34.76	4408.0
2017-03-08 19:00:00	AAPL	Stock	34.76	34.76	34.75	34.75	2100.0
2017-03-08 19:30:00	AAPL	Stock	34.755	34.7725	34.75	34.76	9768.0
2017-03-08 04:00:00	MSFT	Stock	64.69	64.69	64.69	64.69	100.0
2017-03-08 07:00:00	MSFT	Stock	64.4	64.4	64.4	64.4	196.0
2017-03-08 07:30:00	MSFT	Stock	64.39	64.48	64.39	64.48	2529.0
2017-03-08 08:00:00	MSFT	Stock	64.2	64.2	64.2	64.2	170.0
2017-03-08 08:30:00	MSFT	Stock	64.45	64.45	64.45	64.45	100.0
2017-03-08 09:00:00	MSFT	Stock	64.26	64.33	64.26	64.29	3612.0
2017-03-08 09:30:00	MSFT	Stock	64.26	64.6	64.25	64.57	1734606.0
2017-03-08 10:00:00	MSFT	Stock	64.57	64.8	64.44	64.77	1402625.0
2017-03-08 10:30:00	MSFT	Stock	64.78	64.9	64.7	64.885	1159855.0
2017-03-08 11:00:00	MSFT	Stock	64.88	65.035	64.865	64.98	1607663.0
2017-03-08 11:30:00	MSFT	Stock	64.983	64.985	64.75	64.875	989856.0
2017-03-08 12:00:00	MSFT	Stock	64.874	64.93	64.825	64.904	524430.0
2017-03-08 12:30:00	MSFT	Stock	64.906	64.99	64.9	64.985	607042.0
2017-03-08 13:00:00	MSFT	Stock	64.985	65.085	64.97	64.974	979713.0
2017-03-08 13:30:00	MSFT	Stock	64.98	65.01	64.95	64.97	996200.0
2017-03-08 14:00:00	MSFT	Stock	64.975	65.02	64.75	64.815	1127829.0
2017-03-08 14:30:00	MSFT	Stock	64.815	64.95	64.77	64.93	1003977.0
2017-03-08 15:00:00	MSFT	Stock	64.94	65.02	64.9	64.913	1248832.0
2017-03-08 15:30:00	MSFT	Stock	64.915	65.01	64.77	64.99	3033052.0
2017-03-08 16:00:00	MSFT	Stock	64.98	64.99	64.91	64.99	3220338.0
2017-03-08 16:30:00	MSFT	Stock	64.9	64.99	64.89	64.9	20546.0

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

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