PREVIEW / stock_30min / 2017-01-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-09.parquet
  size:    1.6 MB
  rows:    82,051
  symbols: 3,127

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-01-09 04:00:00	AAPL	Stock	29.5	29.5	29.43	29.43	5676.0
2017-01-09 05:00:00	AAPL	Stock	29.45	29.45	29.45	29.45	3392.0
2017-01-09 05:30:00	AAPL	Stock	29.45	29.4725	29.4375	29.4475	9072.0
2017-01-09 06:30:00	AAPL	Stock	29.415	29.4275	29.3775	29.405	18828.0
2017-01-09 07:00:00	AAPL	Stock	29.4375	29.4725	29.4375	29.4725	15168.0
2017-01-09 07:30:00	AAPL	Stock	29.47	29.5425	29.47	29.525	81828.0
2017-01-09 08:00:00	AAPL	Stock	29.52	29.5475	29.5025	29.53	145412.0
2017-01-09 08:30:00	AAPL	Stock	29.5375	29.5675	29.525	29.5275	211008.0
2017-01-09 09:00:00	AAPL	Stock	29.5275	29.5825	29.4725	29.4875	544076.0
2017-01-09 09:30:00	AAPL	Stock	29.485	29.825	29.485	29.7625	31900272.0
2017-01-09 10:00:00	AAPL	Stock	29.7625	29.8225	29.6935	29.7675	12724440.0
2017-01-09 10:30:00	AAPL	Stock	29.7688	29.8	29.73	29.7888	6434816.0
2017-01-09 11:00:00	AAPL	Stock	29.7875	29.8575	29.765	29.8035	8131360.0
2017-01-09 11:30:00	AAPL	Stock	29.8038	29.805	29.7295	29.745	5659556.0
2017-01-09 12:00:00	AAPL	Stock	29.7425	29.7825	29.71	29.7738	6051228.0
2017-01-09 12:30:00	AAPL	Stock	29.7725	29.8	29.735	29.795	4103556.0
2017-01-09 13:00:00	AAPL	Stock	29.795	29.805	29.7575	29.76	3476712.0
2017-01-09 13:30:00	AAPL	Stock	29.76	29.775	29.75	29.7635	3228012.0
2017-01-09 14:00:00	AAPL	Stock	29.7625	29.765	29.695	29.73	4331644.0
2017-01-09 14:30:00	AAPL	Stock	29.7275	29.7725	29.68	29.7685	5789280.0
2017-01-09 15:00:00	AAPL	Stock	29.7675	29.8225	29.765	29.815	6278000.0
2017-01-09 15:30:00	AAPL	Stock	29.815	29.845	29.7425	29.75	11025696.0
2017-01-09 16:00:00	AAPL	Stock	29.75	29.7575	29.725	29.7525	14362600.0
2017-01-09 16:30:00	AAPL	Stock	29.7525	29.7525	29.74	29.75	22296.0
2017-01-09 17:00:00	AAPL	Stock	29.75	29.75	29.7	29.7475	21380.0
2017-01-09 17:30:00	AAPL	Stock	29.7475	29.7525	29.7275	29.7525	26028.0
2017-01-09 18:00:00	AAPL	Stock	29.7425	29.75	29.7175	29.75	24228.0
2017-01-09 18:30:00	AAPL	Stock	29.7275	29.7625	29.725	29.755	18620.0
2017-01-09 19:00:00	AAPL	Stock	29.755	29.755	29.7375	29.74	6988.0
2017-01-09 19:30:00	AAPL	Stock	29.7525	29.7525	29.7275	29.7275	7840.0
2017-01-09 04:30:00	MSFT	Stock	63.13	63.13	63.13	63.13	575.0
2017-01-09 06:00:00	MSFT	Stock	63.02	63.02	63.02	63.02	100.0
2017-01-09 07:30:00	MSFT	Stock	62.97	62.97	62.97	62.97	463.0
2017-01-09 08:00:00	MSFT	Stock	62.99	62.99	62.9	62.9	285.0
2017-01-09 08:30:00	MSFT	Stock	62.98	62.98	62.94	62.94	1378.0
2017-01-09 09:00:00	MSFT	Stock	62.95	62.95	62.76	62.79	34843.0
2017-01-09 09:30:00	MSFT	Stock	62.79	63.08	62.57	63.03	3080172.0
2017-01-09 10:00:00	MSFT	Stock	63.025	63.06	62.83	62.96	1087787.0
2017-01-09 10:30:00	MSFT	Stock	62.96	62.98	62.77	62.85	1211433.0
2017-01-09 11:00:00	MSFT	Stock	62.84	62.93	62.81	62.856	569038.0
2017-01-09 11:30:00	MSFT	Stock	62.85	62.9	62.79	62.84	553599.0
2017-01-09 12:00:00	MSFT	Stock	62.845	62.895	62.79	62.83	758347.0
2017-01-09 12:30:00	MSFT	Stock	62.82	62.9	62.75	62.88	904113.0
2017-01-09 13:00:00	MSFT	Stock	62.88	62.885	62.755	62.788	679885.0
2017-01-09 13:30:00	MSFT	Stock	62.78	62.79	62.64	62.69	874232.0
2017-01-09 14:00:00	MSFT	Stock	62.69	62.7	62.54	62.655	911443.0
2017-01-09 14:30:00	MSFT	Stock	62.65	62.67	62.6	62.65	817302.0
2017-01-09 15:00:00	MSFT	Stock	62.65	62.745	62.61	62.725	769940.0
2017-01-09 15:30:00	MSFT	Stock	62.73	62.75	62.64	62.65	1669952.0
2017-01-09 16:00:00	MSFT	Stock	62.64	62.75	62.56	62.74	5356583.0

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

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