PREVIEW / stock_30min / 2016-04-06

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-06.parquet
  size:    1.6 MB
  rows:    81,194
  symbols: 3,328

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-04-06 04:00:00	AAPL	Stock	27.525	27.525	27.525	27.525	400.0
2016-04-06 05:00:00	AAPL	Stock	27.55	27.55	27.55	27.55	760.0
2016-04-06 05:30:00	AAPL	Stock	27.5975	27.5975	27.5975	27.5975	400.0
2016-04-06 07:00:00	AAPL	Stock	27.55	27.55	27.5	27.5375	42876.0
2016-04-06 07:30:00	AAPL	Stock	27.5625	27.5825	27.5625	27.5825	15696.0
2016-04-06 08:00:00	AAPL	Stock	27.53	27.6475	27.5	27.635	236904.0
2016-04-06 08:30:00	AAPL	Stock	27.635	27.645	27.59	27.6075	124980.0
2016-04-06 09:00:00	AAPL	Stock	27.6175	27.6575	27.555	27.5575	377604.0
2016-04-06 09:30:00	AAPL	Stock	27.5575	27.625	27.4175	27.4698	15105004.0
2016-04-06 10:00:00	AAPL	Stock	27.4675	27.51	27.3	27.315	11476540.0
2016-04-06 10:30:00	AAPL	Stock	27.315	27.4775	27.3	27.475	8458912.0
2016-04-06 11:00:00	AAPL	Stock	27.475	27.545	27.4525	27.525	6926416.0
2016-04-06 11:30:00	AAPL	Stock	27.525	27.5625	27.4825	27.55	5932872.0
2016-04-06 12:00:00	AAPL	Stock	27.5475	27.615	27.535	27.585	4121356.0
2016-04-06 12:30:00	AAPL	Stock	27.5875	27.595	27.5375	27.541	3378200.0
2016-04-06 13:00:00	AAPL	Stock	27.5425	27.6038	27.5105	27.5375	3981044.0
2016-04-06 13:30:00	AAPL	Stock	27.5382	27.5612	27.5025	27.5202	2854164.0
2016-04-06 14:00:00	AAPL	Stock	27.5225	27.5575	27.46	27.485	5328648.0
2016-04-06 14:30:00	AAPL	Stock	27.4875	27.53	27.45	27.52	3628052.0
2016-04-06 15:00:00	AAPL	Stock	27.52	27.605	27.505	27.6025	5660960.0
2016-04-06 15:30:00	AAPL	Stock	27.6025	27.745	27.5925	27.7378	12420556.0
2016-04-06 16:00:00	AAPL	Stock	27.74	27.77	27.4892	27.7575	5763204.0
2016-04-06 16:30:00	AAPL	Stock	27.7575	27.7575	27.7375	27.75	78372.0
2016-04-06 17:00:00	AAPL	Stock	27.75	27.75	27.6975	27.74	297372.0
2016-04-06 17:30:00	AAPL	Stock	27.7375	27.7375	27.7025	27.705	55568.0
2016-04-06 18:00:00	AAPL	Stock	27.73	27.73	27.7	27.7025	17300.0
2016-04-06 18:30:00	AAPL	Stock	27.7025	27.725	27.7025	27.725	1300.0
2016-04-06 19:00:00	AAPL	Stock	27.7225	27.73	27.715	27.73	22920.0
2016-04-06 19:30:00	AAPL	Stock	27.725	27.73	27.72	27.72	23200.0
2016-04-06 08:00:00	MSFT	Stock	54.7	54.7	54.7	54.7	500.0
2016-04-06 08:30:00	MSFT	Stock	54.75	54.75	54.66	54.66	550.0
2016-04-06 09:00:00	MSFT	Stock	54.72	54.72	54.37	54.39	14992.0
2016-04-06 09:30:00	MSFT	Stock	54.37	54.53	54.24	54.46	2909262.0
2016-04-06 10:00:00	MSFT	Stock	54.46	54.55	54.234	54.295	1543267.0
2016-04-06 10:30:00	MSFT	Stock	54.3	54.62	54.21	54.62	1609828.0
2016-04-06 11:00:00	MSFT	Stock	54.62	54.81	54.56	54.81	1182402.0
2016-04-06 11:30:00	MSFT	Stock	54.81	54.87	54.72	54.76	995999.0
2016-04-06 12:00:00	MSFT	Stock	54.76	54.78	54.67	54.75	505452.0
2016-04-06 12:30:00	MSFT	Stock	54.75	54.805	54.67	54.74	652811.0
2016-04-06 13:00:00	MSFT	Stock	54.74	54.955	54.72	54.9	857023.0
2016-04-06 13:30:00	MSFT	Stock	54.91	54.97	54.83	54.923	678036.0
2016-04-06 14:00:00	MSFT	Stock	54.92	54.96	54.8	54.91	955206.0
2016-04-06 14:30:00	MSFT	Stock	54.92	54.98	54.8	54.95	966327.0
2016-04-06 15:00:00	MSFT	Stock	54.94	55.19	54.91	55.175	1529375.0
2016-04-06 15:30:00	MSFT	Stock	55.17	55.2	55.08	55.13	3327207.0
2016-04-06 16:00:00	MSFT	Stock	55.12	55.12	55.1	55.1	1987198.0
2016-04-06 17:30:00	MSFT	Stock	55.13	55.15	55.12	55.15	57845.0
2016-04-06 18:00:00	MSFT	Stock	55.12	55.12	55.1	55.1	1720.0
2016-04-06 19:00:00	MSFT	Stock	55.08	55.08	55.08	55.08	700.0
2016-04-06 19:30:00	MSFT	Stock	55.1	55.1	55.1	55.1	700.0

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

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