PREVIEW / stock_30min / 2018-08-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-15.parquet
  size:    1.7 MB
  rows:    82,997
  symbols: 2,796

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-08-15 04:00:00	AAPL	Stock	52.5	52.5625	52.5	52.5625	8372.0
2018-08-15 04:30:00	AAPL	Stock	52.61	52.635	52.61	52.62	6952.0
2018-08-15 05:00:00	AAPL	Stock	52.6225	52.6225	52.5625	52.605	7320.0
2018-08-15 05:30:00	AAPL	Stock	52.595	52.595	52.5	52.5	5940.0
2018-08-15 06:00:00	AAPL	Stock	52.55	52.5825	52.4625	52.48	27084.0
2018-08-15 06:30:00	AAPL	Stock	52.4375	52.4375	52.255	52.27	42560.0
2018-08-15 07:00:00	AAPL	Stock	52.3075	52.3175	52.0925	52.095	352920.0
2018-08-15 07:30:00	AAPL	Stock	52.1	52.1	52.0	52.0475	435592.0
2018-08-15 08:00:00	AAPL	Stock	52.275	52.3125	52.0175	52.1475	306668.0
2018-08-15 08:30:00	AAPL	Stock	52.145	52.1475	52.05	52.11	152056.0
2018-08-15 09:00:00	AAPL	Stock	52.11	52.31	52.075	52.29	284556.0
2018-08-15 09:30:00	AAPL	Stock	52.3	52.495	52.2075	52.2838	12726776.0
2018-08-15 10:00:00	AAPL	Stock	52.2825	52.3125	52.1008	52.133	9718044.0
2018-08-15 10:30:00	AAPL	Stock	52.135	52.31	52.0825	52.1502	6779680.0
2018-08-15 11:00:00	AAPL	Stock	52.1475	52.2975	52.125	52.2225	6337480.0
2018-08-15 11:30:00	AAPL	Stock	52.2225	52.3025	52.0975	52.1038	5346840.0
2018-08-15 12:00:00	AAPL	Stock	52.1025	52.2475	52.0975	52.2463	4438296.0
2018-08-15 12:30:00	AAPL	Stock	52.245	52.3125	52.22	52.2962	3508424.0
2018-08-15 13:00:00	AAPL	Stock	52.2975	52.5375	52.265	52.4525	10618716.0
2018-08-15 13:30:00	AAPL	Stock	52.4525	52.51	52.38	52.381	3938712.0
2018-08-15 14:00:00	AAPL	Stock	52.3775	52.3975	52.2625	52.2975	4180424.0
2018-08-15 14:30:00	AAPL	Stock	52.295	52.4263	52.2875	52.4263	4116396.0
2018-08-15 15:00:00	AAPL	Stock	52.425	52.5172	52.4168	52.5	4787584.0
2018-08-15 15:30:00	AAPL	Stock	52.4975	52.685	52.4952	52.575	13198068.0
2018-08-15 16:00:00	AAPL	Stock	52.6225	52.6225	52.5325	52.56	7826240.0
2018-08-15 16:30:00	AAPL	Stock	52.595	52.6125	52.585	52.605	21516.0
2018-08-15 17:00:00	AAPL	Stock	52.605	52.605	52.5825	52.5825	21684.0
2018-08-15 17:30:00	AAPL	Stock	52.5825	52.6175	52.5825	52.6	45220.0
2018-08-15 18:00:00	AAPL	Stock	52.6	52.61	52.585	52.6	7116.0
2018-08-15 18:30:00	AAPL	Stock	52.605	52.605	52.575	52.6	25120.0
2018-08-15 19:00:00	AAPL	Stock	52.5775	52.6	52.575	52.6	10312.0
2018-08-15 19:30:00	AAPL	Stock	52.5775	52.6	52.5375	52.5375	78840.0
2018-08-15 04:00:00	MSFT	Stock	109.48	109.5	109.48	109.5	678.0
2018-08-15 04:30:00	MSFT	Stock	109.72	109.72	109.48	109.48	504.0
2018-08-15 05:00:00	MSFT	Stock	109.36	109.36	109.3	109.3	586.0
2018-08-15 05:30:00	MSFT	Stock	109.29	109.29	109.2	109.2	806.0
2018-08-15 06:00:00	MSFT	Stock	109.2	109.28	109.0	109.0	6290.0
2018-08-15 06:30:00	MSFT	Stock	108.86	108.86	108.58	108.58	13797.0
2018-08-15 07:00:00	MSFT	Stock	108.76	108.88	108.59	108.68	19743.0
2018-08-15 07:30:00	MSFT	Stock	108.61	108.61	108.25	108.49	9581.0
2018-08-15 08:00:00	MSFT	Stock	108.76	108.79	108.42	108.7	20027.0
2018-08-15 08:30:00	MSFT	Stock	108.65	108.65	108.52	108.58	5242.0
2018-08-15 09:00:00	MSFT	Stock	108.56	108.66	108.37	108.38	13605.0
2018-08-15 09:30:00	MSFT	Stock	108.46	108.985	108.01	108.13	2831004.0
2018-08-15 10:00:00	MSFT	Stock	108.13	108.15	107.19	107.225	3254885.0
2018-08-15 10:30:00	MSFT	Stock	107.22	107.78	107.05	107.27	2064656.0
2018-08-15 11:00:00	MSFT	Stock	107.27	107.72	107.12	107.435	2426182.0
2018-08-15 11:30:00	MSFT	Stock	107.44	107.73	107.25	107.28	1295665.0
2018-08-15 12:00:00	MSFT	Stock	107.27	107.6	107.16	107.59	1144622.0
2018-08-15 12:30:00	MSFT	Stock	107.59	107.86	107.55	107.62	1027946.0

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

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