PREVIEW / stock_30min / 2018-07-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-05.parquet
  size:    1.6 MB
  rows:    83,211
  symbols: 2,820

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-07-05 04:00:00	AAPL	Stock	46.1125	46.25	46.1125	46.235	10440.0
2018-07-05 04:30:00	AAPL	Stock	46.25	46.25	46.25	46.25	400.0
2018-07-05 05:00:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	1216.0
2018-07-05 05:30:00	AAPL	Stock	46.3	46.3	46.3	46.3	2000.0
2018-07-05 06:00:00	AAPL	Stock	46.295	46.295	46.25	46.25	2860.0
2018-07-05 06:30:00	AAPL	Stock	46.24	46.24	46.24	46.24	3816.0
2018-07-05 07:00:00	AAPL	Stock	46.2425	46.325	46.24	46.3	69032.0
2018-07-05 07:30:00	AAPL	Stock	46.3025	46.355	46.3	46.35	89272.0
2018-07-05 08:00:00	AAPL	Stock	46.3562	46.41	46.2675	46.3725	130560.0
2018-07-05 08:30:00	AAPL	Stock	46.3575	46.395	46.315	46.3275	127460.0
2018-07-05 09:00:00	AAPL	Stock	46.33	46.345	46.275	46.3075	193924.0
2018-07-05 09:30:00	AAPL	Stock	46.2975	46.6025	46.285	46.39	10442440.0
2018-07-05 10:00:00	AAPL	Stock	46.41	46.4642	46.201	46.23	6246876.0
2018-07-05 10:30:00	AAPL	Stock	46.2325	46.3225	46.07	46.1375	6073268.0
2018-07-05 11:00:00	AAPL	Stock	46.135	46.355	46.105	46.335	3903004.0
2018-07-05 11:30:00	AAPL	Stock	46.335	46.425	46.33	46.36	2606728.0
2018-07-05 12:00:00	AAPL	Stock	46.36	46.5225	46.3425	46.4975	2397360.0
2018-07-05 12:30:00	AAPL	Stock	46.4975	46.5	46.4225	46.4538	1769452.0
2018-07-05 13:00:00	AAPL	Stock	46.455	46.4875	46.4212	46.4275	1578960.0
2018-07-05 13:30:00	AAPL	Stock	46.4288	46.445	46.3325	46.39	1658916.0
2018-07-05 14:00:00	AAPL	Stock	46.3875	46.4475	46.24	46.3975	3510848.0
2018-07-05 14:30:00	AAPL	Stock	46.3925	46.4325	46.3775	46.4175	1863204.0
2018-07-05 15:00:00	AAPL	Stock	46.4175	46.4875	46.3408	46.3825	3252356.0
2018-07-05 15:30:00	AAPL	Stock	46.3825	46.43	46.335	46.345	6774428.0
2018-07-05 16:00:00	AAPL	Stock	46.3475	46.4225	46.3475	46.3625	5592336.0
2018-07-05 16:30:00	AAPL	Stock	46.3725	46.3875	46.35	46.375	12880.0
2018-07-05 17:00:00	AAPL	Stock	46.3675	46.375	46.335	46.335	21876.0
2018-07-05 17:30:00	AAPL	Stock	46.3075	46.3125	46.25	46.255	21984.0
2018-07-05 18:00:00	AAPL	Stock	46.275	46.3	46.25	46.25	60492.0
2018-07-05 18:30:00	AAPL	Stock	46.25	46.275	46.25	46.25	14108.0
2018-07-05 19:00:00	AAPL	Stock	46.25	46.2625	46.2375	46.2625	16028.0
2018-07-05 19:30:00	AAPL	Stock	46.2625	46.2625	46.2	46.2125	13392.0
2018-07-05 05:30:00	MSFT	Stock	99.27	99.83	99.27	99.83	1505.0
2018-07-05 06:00:00	MSFT	Stock	99.39	99.78	99.39	99.78	505.0
2018-07-05 07:00:00	MSFT	Stock	99.7	99.79	99.7	99.79	791.0
2018-07-05 07:30:00	MSFT	Stock	99.8	99.92	99.71	99.9	6961.0
2018-07-05 08:00:00	MSFT	Stock	99.58	99.84	99.58	99.78	13368.0
2018-07-05 08:30:00	MSFT	Stock	99.77	99.77	99.73	99.75	4999.0
2018-07-05 09:00:00	MSFT	Stock	99.75	99.75	99.5	99.5	7489.0
2018-07-05 09:30:00	MSFT	Stock	99.5	99.82	99.3	99.37	2599187.0
2018-07-05 10:00:00	MSFT	Stock	99.39	99.65	99.33	99.47	1330840.0
2018-07-05 10:30:00	MSFT	Stock	99.48	99.48	99.03	99.2	1281131.0
2018-07-05 11:00:00	MSFT	Stock	99.2	99.66	99.15	99.605	1139971.0
2018-07-05 11:30:00	MSFT	Stock	99.61	99.72	99.52	99.53	1317189.0
2018-07-05 12:00:00	MSFT	Stock	99.54	99.88	99.48	99.79	874507.0
2018-07-05 12:30:00	MSFT	Stock	99.79	99.83	99.575	99.69	693363.0
2018-07-05 13:00:00	MSFT	Stock	99.685	99.775	99.65	99.657	694158.0
2018-07-05 13:30:00	MSFT	Stock	99.65	99.67	99.41	99.62	670400.0
2018-07-05 14:00:00	MSFT	Stock	99.62	99.79	99.16	99.425	921333.0
2018-07-05 14:30:00	MSFT	Stock	99.42	99.68	99.385	99.665	747530.0

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

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