PREVIEW / stock_30min / 2017-05-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-22.parquet
  size:    1.6 MB
  rows:    81,341
  symbols: 3,027

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-05-22 05:00:00	AAPL	Stock	38.3375	38.3375	38.3375	38.3375	1572.0
2017-05-22 05:30:00	AAPL	Stock	38.3375	38.3375	38.3375	38.3375	1200.0
2017-05-22 06:00:00	AAPL	Stock	38.425	38.425	38.425	38.425	948.0
2017-05-22 06:30:00	AAPL	Stock	38.3375	38.35	38.335	38.35	7964.0
2017-05-22 07:00:00	AAPL	Stock	38.375	38.45	38.3725	38.425	48652.0
2017-05-22 07:30:00	AAPL	Stock	38.4	38.43	38.4	38.415	14176.0
2017-05-22 08:00:00	AAPL	Stock	38.4	38.4375	38.3375	38.39	178840.0
2017-05-22 08:30:00	AAPL	Stock	38.4	38.465	38.4	38.45	64940.0
2017-05-22 09:00:00	AAPL	Stock	38.4475	38.525	38.4462	38.5075	303316.0
2017-05-22 09:30:00	AAPL	Stock	38.5	38.645	38.4175	38.4288	16622592.0
2017-05-22 10:00:00	AAPL	Stock	38.4288	38.455	38.245	38.3462	11705336.0
2017-05-22 10:30:00	AAPL	Stock	38.345	38.3675	38.2275	38.295	5601092.0
2017-05-22 11:00:00	AAPL	Stock	38.295	38.4175	38.275	38.405	4547188.0
2017-05-22 11:30:00	AAPL	Stock	38.4025	38.4475	38.3775	38.415	3771824.0
2017-05-22 12:00:00	AAPL	Stock	38.4165	38.4775	38.4025	38.4625	3145680.0
2017-05-22 12:30:00	AAPL	Stock	38.4648	38.505	38.432	38.4888	3332776.0
2017-05-22 13:00:00	AAPL	Stock	38.4892	38.5275	38.475	38.5238	3226984.0
2017-05-22 13:30:00	AAPL	Stock	38.525	38.5275	38.41	38.46	3659960.0
2017-05-22 14:00:00	AAPL	Stock	38.46	38.46	38.395	38.4415	3711456.0
2017-05-22 14:30:00	AAPL	Stock	38.4415	38.4775	38.4252	38.4625	3000704.0
2017-05-22 15:00:00	AAPL	Stock	38.4638	38.4825	38.4175	38.435	3197908.0
2017-05-22 15:30:00	AAPL	Stock	38.435	38.5025	38.435	38.49	8402760.0
2017-05-22 16:00:00	AAPL	Stock	38.4975	38.525	38.485	38.5025	7116456.0
2017-05-22 16:30:00	AAPL	Stock	38.4975	38.51	38.4975	38.5075	170564.0
2017-05-22 17:00:00	AAPL	Stock	38.495	38.5125	38.495	38.5	32964.0
2017-05-22 17:30:00	AAPL	Stock	38.5	38.5125	38.4925	38.5125	14264.0
2017-05-22 18:00:00	AAPL	Stock	38.5125	38.5125	38.5	38.5125	11460.0
2017-05-22 18:30:00	AAPL	Stock	38.5125	38.5125	38.475	38.4975	39712.0
2017-05-22 19:00:00	AAPL	Stock	38.4775	38.495	38.4425	38.4425	15240.0
2017-05-22 19:30:00	AAPL	Stock	38.4625	38.475	38.4175	38.4225	25988.0
2017-05-22 07:30:00	MSFT	Stock	67.81	67.81	67.81	67.81	845.0
2017-05-22 08:00:00	MSFT	Stock	67.81	67.82	67.7	67.7	925.0
2017-05-22 08:30:00	MSFT	Stock	67.68	67.8	67.68	67.8	2420.0
2017-05-22 09:00:00	MSFT	Stock	67.85	67.85	67.58	67.58	14562.0
2017-05-22 09:30:00	MSFT	Stock	67.89	68.028	67.5	68.01	1849701.0
2017-05-22 10:00:00	MSFT	Stock	68.01	68.15	67.96	68.15	1034694.0
2017-05-22 10:30:00	MSFT	Stock	68.15	68.196	68.04	68.1	645104.0
2017-05-22 11:00:00	MSFT	Stock	68.09	68.2	68.075	68.18	676881.0
2017-05-22 11:30:00	MSFT	Stock	68.18	68.3	68.175	68.29	836560.0
2017-05-22 12:00:00	MSFT	Stock	68.28	68.29	68.16	68.255	617467.0
2017-05-22 12:30:00	MSFT	Stock	68.255	68.277	68.21	68.22	367715.0
2017-05-22 13:00:00	MSFT	Stock	68.23	68.27	68.19	68.24	414134.0
2017-05-22 13:30:00	MSFT	Stock	68.25	68.29	68.01	68.211	456809.0
2017-05-22 14:00:00	MSFT	Stock	68.21	68.26	68.19	68.23	447780.0
2017-05-22 14:30:00	MSFT	Stock	68.225	68.36	68.225	68.26	821153.0
2017-05-22 15:00:00	MSFT	Stock	68.26	68.35	68.2	68.345	751641.0
2017-05-22 15:30:00	MSFT	Stock	68.35	68.47	68.3	68.45	2504069.0
2017-05-22 16:00:00	MSFT	Stock	68.5	68.5	68.4	68.45	2714304.0
2017-05-22 16:30:00	MSFT	Stock	68.45	68.45	68.37	68.45	23113.0
2017-05-22 17:00:00	MSFT	Stock	68.38	68.38	68.38	68.38	170.0

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

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