PREVIEW / stock_30min / 2017-08-29

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-29.parquet
  size:    1.6 MB
  rows:    80,962
  symbols: 2,980

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-08-29 04:00:00	AAPL	Stock	40.05	40.05	39.92	39.945	12008.0
2017-08-29 04:30:00	AAPL	Stock	39.95	39.95	39.8875	39.9125	16208.0
2017-08-29 05:00:00	AAPL	Stock	39.9025	39.93	39.875	39.925	16776.0
2017-08-29 05:30:00	AAPL	Stock	39.975	40.0375	39.975	40.025	27512.0
2017-08-29 06:00:00	AAPL	Stock	40.0025	40.04	39.9775	40.0375	65372.0
2017-08-29 06:30:00	AAPL	Stock	40.025	40.09	40.025	40.09	11260.0
2017-08-29 07:00:00	AAPL	Stock	40.095	40.1	40.05	40.05	72316.0
2017-08-29 07:30:00	AAPL	Stock	40.0675	40.0925	40.0025	40.0375	97904.0
2017-08-29 08:00:00	AAPL	Stock	40.0725	40.0975	40.0025	40.025	259624.0
2017-08-29 08:30:00	AAPL	Stock	40.03	40.0625	39.975	40.045	274180.0
2017-08-29 09:00:00	AAPL	Stock	40.03	40.09	39.9775	40.0475	328236.0
2017-08-29 09:30:00	AAPL	Stock	40.045	40.3625	40.0	40.3625	16062848.0
2017-08-29 10:00:00	AAPL	Stock	40.36	40.4575	40.245	40.4525	9700136.0
2017-08-29 10:30:00	AAPL	Stock	40.4525	40.615	40.4525	40.5525	10776152.0
2017-08-29 11:00:00	AAPL	Stock	40.5488	40.7125	40.5475	40.66	9218972.0
2017-08-29 11:30:00	AAPL	Stock	40.66	40.74	40.6	40.7125	7852072.0
2017-08-29 12:00:00	AAPL	Stock	40.71	40.72	40.59	40.6085	4861360.0
2017-08-29 12:30:00	AAPL	Stock	40.61	40.64	40.5525	40.5775	6002720.0
2017-08-29 13:00:00	AAPL	Stock	40.5762	40.6625	40.54	40.5925	4403952.0
2017-08-29 13:30:00	AAPL	Stock	40.59	40.6525	40.5675	40.5925	4194452.0
2017-08-29 14:00:00	AAPL	Stock	40.59	40.655	40.59	40.6138	3084708.0
2017-08-29 14:30:00	AAPL	Stock	40.6125	40.7125	40.6012	40.7	4362272.0
2017-08-29 15:00:00	AAPL	Stock	40.699	40.75	40.6575	40.745	6126452.0
2017-08-29 15:30:00	AAPL	Stock	40.7475	40.78	40.7275	40.73	12731392.0
2017-08-29 16:00:00	AAPL	Stock	40.7425	40.775	40.72	40.7575	6988200.0
2017-08-29 16:30:00	AAPL	Stock	40.7275	40.78	40.7275	40.7625	83980.0
2017-08-29 17:00:00	AAPL	Stock	40.7725	40.7725	40.7525	40.7675	39780.0
2017-08-29 17:30:00	AAPL	Stock	40.7675	40.7725	40.7525	40.7725	28468.0
2017-08-29 18:00:00	AAPL	Stock	40.7725	40.8	40.755	40.8	67356.0
2017-08-29 18:30:00	AAPL	Stock	40.7875	40.8025	40.77	40.8025	65020.0
2017-08-29 19:00:00	AAPL	Stock	40.805	40.825	40.805	40.82	30860.0
2017-08-29 19:30:00	AAPL	Stock	40.82	40.825	40.805	40.825	48392.0
2017-08-29 05:30:00	MSFT	Stock	72.21	72.21	72.21	72.21	100.0
2017-08-29 07:00:00	MSFT	Stock	72.28	72.28	72.28	72.28	100.0
2017-08-29 07:30:00	MSFT	Stock	72.45	72.45	72.45	72.45	433.0
2017-08-29 08:00:00	MSFT	Stock	72.43	72.43	72.28	72.28	2673.0
2017-08-29 08:30:00	MSFT	Stock	72.28	72.3	72.2	72.2	3717.0
2017-08-29 09:00:00	MSFT	Stock	72.21	72.33	72.15	72.33	7712.0
2017-08-29 09:30:00	MSFT	Stock	72.28	72.696	72.05	72.65	1367939.0
2017-08-29 10:00:00	MSFT	Stock	72.645	72.76	72.48	72.64	817837.0
2017-08-29 10:30:00	MSFT	Stock	72.64	72.81	72.63	72.71	652101.0
2017-08-29 11:00:00	MSFT	Stock	72.713	72.86	72.7	72.725	519834.0
2017-08-29 11:30:00	MSFT	Stock	72.73	72.94	72.68	72.87	681804.0
2017-08-29 12:00:00	MSFT	Stock	72.87	72.93	72.86	72.89	351073.0
2017-08-29 12:30:00	MSFT	Stock	72.89	73.0	72.86	72.91	303820.0
2017-08-29 13:00:00	MSFT	Stock	72.91	73.01	72.86	72.985	595588.0
2017-08-29 13:30:00	MSFT	Stock	72.985	73.02	72.92	72.98	430465.0
2017-08-29 14:00:00	MSFT	Stock	72.97	73.03	72.96	72.99	328426.0
2017-08-29 14:30:00	MSFT	Stock	72.98	73.15	72.97	73.07	550038.0
2017-08-29 15:00:00	MSFT	Stock	73.08	73.16	73.04	73.1	571361.0

> showing 50 of 80,962 rows — these rows as CSV

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