PREVIEW / stock_30min / 2017-04-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-03.parquet
  size:    1.6 MB
  rows:    83,343
  symbols: 3,068

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-04-03 05:00:00	AAPL	Stock	35.9	35.9075	35.9	35.9075	28228.0
2017-04-03 05:30:00	AAPL	Stock	35.91	35.91	35.91	35.91	400.0
2017-04-03 06:00:00	AAPL	Stock	35.975	35.975	35.97	35.97	5276.0
2017-04-03 06:30:00	AAPL	Stock	35.93	35.93	35.93	35.93	496.0
2017-04-03 07:00:00	AAPL	Stock	35.9525	35.9675	35.94	35.94	21220.0
2017-04-03 07:30:00	AAPL	Stock	35.94	35.95	35.9325	35.9375	12824.0
2017-04-03 08:00:00	AAPL	Stock	35.9375	35.9475	35.8875	35.9225	74136.0
2017-04-03 08:30:00	AAPL	Stock	35.905	35.945	35.9	35.93	101836.0
2017-04-03 09:00:00	AAPL	Stock	35.925	35.9475	35.8825	35.9125	158716.0
2017-04-03 09:30:00	AAPL	Stock	35.9275	36.03	35.8875	35.962	10759040.0
2017-04-03 10:00:00	AAPL	Stock	35.96	36.015	35.88	35.9925	6592064.0
2017-04-03 10:30:00	AAPL	Stock	35.994	36.0075	35.915	35.925	4826524.0
2017-04-03 11:00:00	AAPL	Stock	35.9233	35.9375	35.8075	35.904	6931720.0
2017-04-03 11:30:00	AAPL	Stock	35.9025	35.915	35.81	35.8462	5701484.0
2017-04-03 12:00:00	AAPL	Stock	35.8475	35.9025	35.7625	35.885	6043744.0
2017-04-03 12:30:00	AAPL	Stock	35.8825	35.91	35.8588	35.8975	2809840.0
2017-04-03 13:00:00	AAPL	Stock	35.895	35.9275	35.875	35.9088	2469304.0
2017-04-03 13:30:00	AAPL	Stock	35.91	35.9138	35.85	35.88	2221312.0
2017-04-03 14:00:00	AAPL	Stock	35.8825	35.9075	35.8388	35.9015	2340860.0
2017-04-03 14:30:00	AAPL	Stock	35.9	35.94	35.89	35.925	2504564.0
2017-04-03 15:00:00	AAPL	Stock	35.9242	35.975	35.9125	35.96	3808744.0
2017-04-03 15:30:00	AAPL	Stock	35.96	35.965	35.915	35.925	6971284.0
2017-04-03 16:00:00	AAPL	Stock	35.925	35.9325	35.8958	35.9238	7766656.0
2017-04-03 16:30:00	AAPL	Stock	35.925	35.925	35.915	35.925	9140.0
2017-04-03 17:00:00	AAPL	Stock	35.915	35.915	35.915	35.915	800.0
2017-04-03 17:30:00	AAPL	Stock	35.92	35.925	35.9125	35.9225	26444.0
2017-04-03 18:00:00	AAPL	Stock	35.9225	35.9225	35.9	35.9	9088.0
2017-04-03 18:30:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	1192.0
2017-04-03 19:00:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	3696.0
2017-04-03 19:30:00	AAPL	Stock	35.91	35.91	35.9075	35.9075	5300.0
2017-04-03 07:00:00	MSFT	Stock	66.0	66.0	66.0	66.0	147.0
2017-04-03 07:30:00	MSFT	Stock	66.0	66.0	66.0	66.0	666.0
2017-04-03 08:00:00	MSFT	Stock	66.0	66.0	65.86	65.95	4416.0
2017-04-03 08:30:00	MSFT	Stock	65.99	65.99	65.97	65.97	400.0
2017-04-03 09:00:00	MSFT	Stock	65.93	65.94	65.73	65.81	15037.0
2017-04-03 09:30:00	MSFT	Stock	65.81	65.94	65.65	65.72	2292581.0
2017-04-03 10:00:00	MSFT	Stock	65.72	65.82	65.57	65.69	1620156.0
2017-04-03 10:30:00	MSFT	Stock	65.69	65.72	65.4	65.411	1345878.0
2017-04-03 11:00:00	MSFT	Stock	65.415	65.453	65.2	65.38	1512655.0
2017-04-03 11:30:00	MSFT	Stock	65.385	65.45	65.31	65.37	1241140.0
2017-04-03 12:00:00	MSFT	Stock	65.36	65.395	65.19	65.36	1058363.0
2017-04-03 12:30:00	MSFT	Stock	65.36	65.49	65.34	65.483	704582.0
2017-04-03 13:00:00	MSFT	Stock	65.49	65.51	65.36	65.38	730833.0
2017-04-03 13:30:00	MSFT	Stock	65.37	65.42	65.26	65.41	774439.0
2017-04-03 14:00:00	MSFT	Stock	65.41	65.48	65.32	65.47	542425.0
2017-04-03 14:30:00	MSFT	Stock	65.47	65.56	65.45	65.5	636933.0
2017-04-03 15:00:00	MSFT	Stock	65.5	65.64	65.47	65.59	919211.0
2017-04-03 15:30:00	MSFT	Stock	65.59	65.6	65.51	65.55	1970250.0
2017-04-03 16:00:00	MSFT	Stock	65.55	65.606	65.0	65.32	3494534.0
2017-04-03 16:30:00	MSFT	Stock	65.38	65.47	65.35	65.43	8330.0

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

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