PREVIEW / stock_30min / 2018-04-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-23.parquet
  size:    1.6 MB
  rows:    81,502
  symbols: 2,854

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
2018-04-23 04:00:00	AAPL	Stock	41.505	41.505	41.5	41.5	3600.0
2018-04-23 05:00:00	AAPL	Stock	41.525	41.525	41.525	41.525	400.0
2018-04-23 05:30:00	AAPL	Stock	41.5475	41.5475	41.525	41.525	5328.0
2018-04-23 06:00:00	AAPL	Stock	41.525	41.525	41.5	41.525	1436.0
2018-04-23 06:30:00	AAPL	Stock	41.595	41.6675	41.595	41.6625	26388.0
2018-04-23 07:00:00	AAPL	Stock	41.6375	41.735	41.6225	41.7125	276360.0
2018-04-23 07:30:00	AAPL	Stock	41.7175	41.805	41.695	41.775	161828.0
2018-04-23 08:00:00	AAPL	Stock	41.775	41.815	41.625	41.7375	575276.0
2018-04-23 08:30:00	AAPL	Stock	41.7275	41.75	41.6625	41.6625	363628.0
2018-04-23 09:00:00	AAPL	Stock	41.6625	41.7375	41.6575	41.725	410860.0
2018-04-23 09:30:00	AAPL	Stock	41.7025	41.73	41.3025	41.48	20792256.0
2018-04-23 10:00:00	AAPL	Stock	41.4775	41.62	41.4	41.5825	10116392.0
2018-04-23 10:30:00	AAPL	Stock	41.5838	41.7	41.5475	41.646	9639564.0
2018-04-23 11:00:00	AAPL	Stock	41.645	41.6862	41.5925	41.6525	7278988.0
2018-04-23 11:30:00	AAPL	Stock	41.6525	41.665	41.585	41.635	5216836.0
2018-04-23 12:00:00	AAPL	Stock	41.635	41.655	41.39	41.4225	7250436.0
2018-04-23 12:30:00	AAPL	Stock	41.4238	41.45	41.2	41.245	9796364.0
2018-04-23 13:00:00	AAPL	Stock	41.2425	41.3225	41.1775	41.19	5164036.0
2018-04-23 13:30:00	AAPL	Stock	41.1912	41.2975	41.1375	41.2575	6014816.0
2018-04-23 14:00:00	AAPL	Stock	41.255	41.2825	41.0725	41.125	7807036.0
2018-04-23 14:30:00	AAPL	Stock	41.126	41.205	41.0225	41.075	6343068.0
2018-04-23 15:00:00	AAPL	Stock	41.0725	41.204	41.055	41.1975	5495792.0
2018-04-23 15:30:00	AAPL	Stock	41.1975	41.315	41.1612	41.3125	11444912.0
2018-04-23 16:00:00	AAPL	Stock	41.31	41.4075	41.25	41.325	16870196.0
2018-04-23 16:30:00	AAPL	Stock	41.315	41.335	41.2825	41.3025	21560.0
2018-04-23 17:00:00	AAPL	Stock	41.31	41.325	41.31	41.32	1776868.0
2018-04-23 17:30:00	AAPL	Stock	41.325	41.325	41.275	41.275	28424.0
2018-04-23 18:00:00	AAPL	Stock	41.275	41.3125	41.275	41.28	9088.0
2018-04-23 18:30:00	AAPL	Stock	41.3	41.32	41.285	41.3025	14648.0
2018-04-23 19:00:00	AAPL	Stock	41.3025	41.305	41.275	41.275	13680.0
2018-04-23 19:30:00	AAPL	Stock	41.28	41.3375	41.2625	41.2875	84700.0
2018-04-23 07:00:00	MSFT	Stock	95.38	95.4	95.32	95.32	3549.0
2018-04-23 07:30:00	MSFT	Stock	95.3	95.4	95.21	95.39	10364.0
2018-04-23 08:00:00	MSFT	Stock	95.39	95.58	95.3	95.47	8956.0
2018-04-23 08:30:00	MSFT	Stock	95.46	95.65	95.46	95.65	13680.0
2018-04-23 09:00:00	MSFT	Stock	95.64	95.71	95.45	95.71	10260.0
2018-04-23 09:30:00	MSFT	Stock	95.744	95.77	95.03	95.45	2149314.0
2018-04-23 10:00:00	MSFT	Stock	95.46	95.595	95.18	95.54	1137556.0
2018-04-23 10:30:00	MSFT	Stock	95.55	96.09	95.29	95.94	1548846.0
2018-04-23 11:00:00	MSFT	Stock	95.94	96.29	95.81	96.23	1349923.0
2018-04-23 11:30:00	MSFT	Stock	96.22	96.25	95.73	95.855	1094539.0
2018-04-23 12:00:00	MSFT	Stock	95.86	95.915	95.56	95.58	661182.0
2018-04-23 12:30:00	MSFT	Stock	95.57	95.68	95.295	95.4	991997.0
2018-04-23 13:00:00	MSFT	Stock	95.4	95.59	95.225	95.37	812429.0
2018-04-23 13:30:00	MSFT	Stock	95.37	95.52	95.26	95.37	730468.0
2018-04-23 14:00:00	MSFT	Stock	95.375	95.41	94.76	94.858	1121756.0
2018-04-23 14:30:00	MSFT	Stock	94.86	95.14	94.64	94.695	904143.0
2018-04-23 15:00:00	MSFT	Stock	94.69	95.14	94.63	95.03	990673.0
2018-04-23 15:30:00	MSFT	Stock	95.025	95.4	94.875	95.36	2522161.0
2018-04-23 16:00:00	MSFT	Stock	95.35	95.79	95.2	95.36	2307675.0

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

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