PREVIEW / stock_30min / 2017-06-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-16.parquet
  size:    1.6 MB
  rows:    82,063
  symbols: 3,022

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-06-16 04:00:00	AAPL	Stock	36.175	36.19	36.11	36.19	32872.0
2017-06-16 06:00:00	AAPL	Stock	36.125	36.1475	36.1125	36.1475	6076.0
2017-06-16 06:30:00	AAPL	Stock	36.15	36.1625	36.125	36.125	2000.0
2017-06-16 07:00:00	AAPL	Stock	36.1375	36.1625	36.1375	36.155	8300.0
2017-06-16 07:30:00	AAPL	Stock	36.1375	36.145	36.1375	36.14	10400.0
2017-06-16 08:00:00	AAPL	Stock	36.1275	36.145	36.075	36.1	118032.0
2017-06-16 08:30:00	AAPL	Stock	36.12	36.12	35.9575	35.9775	84020.0
2017-06-16 09:00:00	AAPL	Stock	35.98	36.0375	35.9	35.935	170312.0
2017-06-16 09:30:00	AAPL	Stock	35.9525	36.125	35.8375	36.0912	45243132.0
2017-06-16 10:00:00	AAPL	Stock	36.0875	36.095	35.8425	35.92	8375820.0
2017-06-16 10:30:00	AAPL	Stock	35.9175	35.95	35.75	35.7925	6718700.0
2017-06-16 11:00:00	AAPL	Stock	35.7925	35.865	35.7472	35.8462	7261632.0
2017-06-16 11:30:00	AAPL	Stock	35.8475	35.9025	35.7925	35.8425	4450508.0
2017-06-16 12:00:00	AAPL	Stock	35.8425	35.872	35.8175	35.845	3519936.0
2017-06-16 12:30:00	AAPL	Stock	35.8425	35.85	35.75	35.755	3647364.0
2017-06-16 13:00:00	AAPL	Stock	35.7575	35.7825	35.675	35.7275	6000912.0
2017-06-16 13:30:00	AAPL	Stock	35.7275	35.82	35.6775	35.81	4191036.0
2017-06-16 14:00:00	AAPL	Stock	35.81	35.8725	35.7925	35.8125	4489852.0
2017-06-16 14:30:00	AAPL	Stock	35.815	35.84	35.735	35.7362	5025628.0
2017-06-16 15:00:00	AAPL	Stock	35.7375	35.7625	35.6385	35.6562	7160144.0
2017-06-16 15:30:00	AAPL	Stock	35.655	35.675	35.55	35.5625	25724316.0
2017-06-16 16:00:00	AAPL	Stock	35.5625	35.585	35.5425	35.585	44924156.0
2017-06-16 16:30:00	AAPL	Stock	35.575	35.6125	35.565	35.575	141884.0
2017-06-16 17:00:00	AAPL	Stock	35.6	35.6075	35.5675	35.6	68708.0
2017-06-16 17:30:00	AAPL	Stock	35.6	35.61	35.5975	35.6	21880.0
2017-06-16 18:00:00	AAPL	Stock	35.6	35.61	35.6	35.605	13884.0
2017-06-16 18:30:00	AAPL	Stock	35.6075	35.6075	35.605	35.6075	3200.0
2017-06-16 19:00:00	AAPL	Stock	35.6075	35.61	35.6	35.6025	24996.0
2017-06-16 19:30:00	AAPL	Stock	35.6	35.6125	35.59	35.6125	11960.0
2017-06-16 05:30:00	MSFT	Stock	70.29	70.29	70.29	70.29	100.0
2017-06-16 08:00:00	MSFT	Stock	70.1	70.15	70.1	70.15	9957.0
2017-06-16 08:30:00	MSFT	Stock	70.15	70.15	69.9	69.9	5495.0
2017-06-16 09:00:00	MSFT	Stock	69.85	70.0	69.55	69.74	39025.0
2017-06-16 09:30:00	MSFT	Stock	69.76	69.87	69.52	69.755	13973702.0
2017-06-16 10:00:00	MSFT	Stock	69.75	69.81	69.22	69.31	2046248.0
2017-06-16 10:30:00	MSFT	Stock	69.31	69.445	69.23	69.385	1524536.0
2017-06-16 11:00:00	MSFT	Stock	69.38	69.57	69.29	69.55	961463.0
2017-06-16 11:30:00	MSFT	Stock	69.55	69.705	69.5	69.7	1084471.0
2017-06-16 12:00:00	MSFT	Stock	69.7	69.85	69.69	69.845	753159.0
2017-06-16 12:30:00	MSFT	Stock	69.85	69.91	69.76	69.815	743609.0
2017-06-16 13:00:00	MSFT	Stock	69.815	69.93	69.74	69.81	733422.0
2017-06-16 13:30:00	MSFT	Stock	69.81	69.93	69.71	69.93	643661.0
2017-06-16 14:00:00	MSFT	Stock	69.93	70.02	69.905	69.935	646410.0
2017-06-16 14:30:00	MSFT	Stock	69.94	70.01	69.88	69.965	746477.0
2017-06-16 15:00:00	MSFT	Stock	69.96	70.025	69.85	69.925	1134597.0
2017-06-16 15:30:00	MSFT	Stock	69.926	69.99	69.77	69.99	5214566.0
2017-06-16 16:00:00	MSFT	Stock	69.99	70.009	69.74	69.83	14260138.0
2017-06-16 16:30:00	MSFT	Stock	69.79	70.0	69.79	70.0	44948.0
2017-06-16 17:00:00	MSFT	Stock	69.84	69.91	69.83	69.89	9655.0
2017-06-16 17:30:00	MSFT	Stock	69.9	69.9	69.9	69.9	243.0

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

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