PREVIEW / stock_30min / 2016-12-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-15.parquet
  size:    1.6 MB
  rows:    83,671
  symbols: 3,170

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
2016-12-15 04:00:00	AAPL	Stock	28.755	28.755	28.7525	28.7525	800.0
2016-12-15 05:00:00	AAPL	Stock	28.75	28.75	28.6875	28.6875	4436.0
2016-12-15 05:30:00	AAPL	Stock	28.7075	28.725	28.7075	28.725	2872.0
2016-12-15 06:00:00	AAPL	Stock	28.7075	28.74	28.7075	28.72	18176.0
2016-12-15 06:30:00	AAPL	Stock	28.74	28.74	28.67	28.675	9432.0
2016-12-15 07:00:00	AAPL	Stock	28.7	28.7	28.6775	28.6775	7220.0
2016-12-15 07:30:00	AAPL	Stock	28.68	28.725	28.6725	28.7175	69184.0
2016-12-15 08:00:00	AAPL	Stock	28.68	28.765	28.68	28.765	72932.0
2016-12-15 08:30:00	AAPL	Stock	28.75	28.7975	28.7375	28.7775	181824.0
2016-12-15 09:00:00	AAPL	Stock	28.7875	28.8475	28.7725	28.8475	199356.0
2016-12-15 09:30:00	AAPL	Stock	28.845	29.1825	28.8075	29.1175	24103064.0
2016-12-15 10:00:00	AAPL	Stock	29.12	29.125	28.9875	29.0025	9221892.0
2016-12-15 10:30:00	AAPL	Stock	29.0025	29.0425	28.955	29.0275	7103236.0
2016-12-15 11:00:00	AAPL	Stock	29.0275	29.12	29.0225	29.07	7047488.0
2016-12-15 11:30:00	AAPL	Stock	29.07	29.0825	28.9838	29.0125	5740864.0
2016-12-15 12:00:00	AAPL	Stock	29.0125	29.0635	28.96	29.025	4849072.0
2016-12-15 12:30:00	AAPL	Stock	29.0225	29.05	29.01	29.0375	5604784.0
2016-12-15 13:00:00	AAPL	Stock	29.0375	29.0805	29.0112	29.0675	4948032.0
2016-12-15 13:30:00	AAPL	Stock	29.0675	29.0875	28.8525	28.9088	7815088.0
2016-12-15 14:00:00	AAPL	Stock	28.9075	28.97	28.865	28.97	5031008.0
2016-12-15 14:30:00	AAPL	Stock	28.97	28.99	28.9325	28.9485	3900700.0
2016-12-15 15:00:00	AAPL	Stock	28.9488	28.9725	28.93	28.95	4530280.0
2016-12-15 15:30:00	AAPL	Stock	28.95	29.02	28.94	28.955	11143448.0
2016-12-15 16:00:00	AAPL	Stock	28.9525	29.0	28.9488	28.955	16053456.0
2016-12-15 16:30:00	AAPL	Stock	28.9875	28.9875	28.8875	28.95	146092.0
2016-12-15 17:00:00	AAPL	Stock	28.95	28.955	28.935	28.935	42268.0
2016-12-15 17:30:00	AAPL	Stock	28.9475	28.95	28.9475	28.95	3960.0
2016-12-15 18:00:00	AAPL	Stock	28.955	28.955	28.9525	28.9525	2000.0
2016-12-15 18:30:00	AAPL	Stock	28.955	28.9575	28.955	28.9575	19384.0
2016-12-15 19:00:00	AAPL	Stock	28.975	29.0	28.975	28.995	36908.0
2016-12-15 19:30:00	AAPL	Stock	28.985	28.985	28.97	28.975	16340.0
2016-12-15 05:00:00	MSFT	Stock	62.85	62.85	62.85	62.85	159.0
2016-12-15 05:30:00	MSFT	Stock	62.8	62.8	62.75	62.75	2300.0
2016-12-15 06:00:00	MSFT	Stock	62.84	62.9	62.75	62.85	3100.0
2016-12-15 07:00:00	MSFT	Stock	62.85	62.85	62.85	62.85	450.0
2016-12-15 07:30:00	MSFT	Stock	62.85	62.85	62.85	62.85	3950.0
2016-12-15 08:00:00	MSFT	Stock	62.85	62.85	62.7	62.7	1698.0
2016-12-15 08:30:00	MSFT	Stock	62.74	62.82	62.74	62.82	1829.0
2016-12-15 09:00:00	MSFT	Stock	62.85	63.15	62.72	62.72	32801.0
2016-12-15 09:30:00	MSFT	Stock	62.7	63.0	62.54	62.83	3074790.0
2016-12-15 10:00:00	MSFT	Stock	62.83	62.88	62.68	62.78	1545232.0
2016-12-15 10:30:00	MSFT	Stock	62.78	62.84	62.66	62.695	1742796.0
2016-12-15 11:00:00	MSFT	Stock	62.69	63.13	62.68	63.01	1378764.0
2016-12-15 11:30:00	MSFT	Stock	63.02	63.154	62.865	62.99	1367104.0
2016-12-15 12:00:00	MSFT	Stock	62.99	63.03	62.87	62.98	898698.0
2016-12-15 12:30:00	MSFT	Stock	62.985	63.03	62.86	62.935	1168560.0
2016-12-15 13:00:00	MSFT	Stock	62.94	63.08	62.891	62.961	1233061.0
2016-12-15 13:30:00	MSFT	Stock	62.965	63.0	62.3	62.445	2100255.0
2016-12-15 14:00:00	MSFT	Stock	62.45	62.64	62.38	62.62	2029437.0
2016-12-15 14:30:00	MSFT	Stock	62.62	62.64	62.49	62.49	1164531.0

> showing 50 of 83,671 rows — these rows as CSV

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