PREVIEW / stock_30min / 2017-07-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-19.parquet
  size:    1.6 MB
  rows:    81,230
  symbols: 2,996

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-07-19 04:00:00	AAPL	Stock	37.5875	37.5875	37.575	37.575	4400.0
2017-07-19 04:30:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	400.0
2017-07-19 05:00:00	AAPL	Stock	37.565	37.565	37.525	37.525	4552.0
2017-07-19 05:30:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	400.0
2017-07-19 06:30:00	AAPL	Stock	37.585	37.5875	37.585	37.5875	3808.0
2017-07-19 07:00:00	AAPL	Stock	37.5875	37.6175	37.5875	37.6125	13420.0
2017-07-19 07:30:00	AAPL	Stock	37.6125	37.6125	37.5625	37.565	48516.0
2017-07-19 08:00:00	AAPL	Stock	37.6125	37.615	37.4375	37.615	77708.0
2017-07-19 08:30:00	AAPL	Stock	37.61	37.61	37.57	37.5875	40684.0
2017-07-19 09:00:00	AAPL	Stock	37.6	37.65	37.5875	37.62	153092.0
2017-07-19 09:30:00	AAPL	Stock	37.61	37.7375	37.4875	37.6625	10471860.0
2017-07-19 10:00:00	AAPL	Stock	37.66	37.7025	37.5625	37.6275	6577920.0
2017-07-19 10:30:00	AAPL	Stock	37.63	37.6575	37.5725	37.6025	3961412.0
2017-07-19 11:00:00	AAPL	Stock	37.6025	37.6725	37.6025	37.6362	3379916.0
2017-07-19 11:30:00	AAPL	Stock	37.639	37.69	37.6362	37.6825	3278564.0
2017-07-19 12:00:00	AAPL	Stock	37.685	37.715	37.6675	37.695	3231404.0
2017-07-19 12:30:00	AAPL	Stock	37.695	37.7575	37.6875	37.7525	3834580.0
2017-07-19 13:00:00	AAPL	Stock	37.7525	37.855	37.7525	37.78	6532356.0
2017-07-19 13:30:00	AAPL	Stock	37.7825	37.8325	37.7175	37.76	5289600.0
2017-07-19 14:00:00	AAPL	Stock	37.7615	37.825	37.7615	37.82	2663824.0
2017-07-19 14:30:00	AAPL	Stock	37.8225	37.825	37.7625	37.7625	2865608.0
2017-07-19 15:00:00	AAPL	Stock	37.765	37.775	37.715	37.755	3444904.0
2017-07-19 15:30:00	AAPL	Stock	37.7575	37.765	37.685	37.755	9117484.0
2017-07-19 16:00:00	AAPL	Stock	37.755	37.7625	37.7	37.755	9315480.0
2017-07-19 16:30:00	AAPL	Stock	37.7125	37.725	37.7	37.7	143776.0
2017-07-19 17:00:00	AAPL	Stock	37.6925	37.7	37.675	37.6775	20652.0
2017-07-19 17:30:00	AAPL	Stock	37.7	37.755	37.69	37.7	201744.0
2017-07-19 18:00:00	AAPL	Stock	37.7	37.7125	37.7	37.7125	3524.0
2017-07-19 18:30:00	AAPL	Stock	37.7125	37.7125	37.7	37.7125	7984.0
2017-07-19 19:00:00	AAPL	Stock	37.7125	37.7125	37.7125	37.7125	4400.0
2017-07-19 19:30:00	AAPL	Stock	37.6975	37.6975	37.6975	37.6975	2008.0
2017-07-19 04:00:00	MSFT	Stock	73.53	73.53	73.5	73.5	2800.0
2017-07-19 06:00:00	MSFT	Stock	73.52	73.52	73.52	73.52	100.0
2017-07-19 06:30:00	MSFT	Stock	73.46	73.51	73.4	73.51	1680.0
2017-07-19 07:00:00	MSFT	Stock	73.5	73.5	73.5	73.5	600.0
2017-07-19 07:30:00	MSFT	Stock	73.52	73.52	73.43	73.48	4713.0
2017-07-19 08:00:00	MSFT	Stock	73.45	73.59	73.43	73.52	14916.0
2017-07-19 08:30:00	MSFT	Stock	73.55	73.55	73.44	73.5	4751.0
2017-07-19 09:00:00	MSFT	Stock	73.54	73.7	73.43	73.43	37744.0
2017-07-19 09:30:00	MSFT	Stock	73.5	73.78	73.45	73.68	2772938.0
2017-07-19 10:00:00	MSFT	Stock	73.68	73.735	73.54	73.68	1501300.0
2017-07-19 10:30:00	MSFT	Stock	73.69	73.72	73.57	73.71	1304030.0
2017-07-19 11:00:00	MSFT	Stock	73.71	73.85	73.702	73.755	1067219.0
2017-07-19 11:30:00	MSFT	Stock	73.755	73.83	73.75	73.81	1129503.0
2017-07-19 12:00:00	MSFT	Stock	73.82	73.93	73.815	73.845	1114330.0
2017-07-19 12:30:00	MSFT	Stock	73.849	73.97	73.84	73.94	1143522.0
2017-07-19 13:00:00	MSFT	Stock	73.94	74.04	73.92	74.0	1130903.0
2017-07-19 13:30:00	MSFT	Stock	73.995	74.0	73.875	73.895	957869.0
2017-07-19 14:00:00	MSFT	Stock	73.89	74.03	73.89	73.92	1106873.0
2017-07-19 14:30:00	MSFT	Stock	73.92	73.96	73.88	73.88	950890.0

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

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