PREVIEW / stock_30min / 2018-09-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-10.parquet
  size:    1.7 MB
  rows:    82,989
  symbols: 2,772

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-09-10 04:00:00	AAPL	Stock	55.25	55.475	55.25	55.3025	80004.0
2018-09-10 04:30:00	AAPL	Stock	55.3025	55.375	55.2775	55.375	9128.0
2018-09-10 05:00:00	AAPL	Stock	55.345	55.345	55.335	55.335	3900.0
2018-09-10 05:30:00	AAPL	Stock	55.25	55.255	55.25	55.25	7008.0
2018-09-10 06:00:00	AAPL	Stock	55.1775	55.445	55.175	55.445	29988.0
2018-09-10 06:30:00	AAPL	Stock	55.4425	55.57	55.4425	55.5	81640.0
2018-09-10 07:00:00	AAPL	Stock	55.48	55.61	55.445	55.61	109036.0
2018-09-10 07:30:00	AAPL	Stock	55.6125	55.6125	55.525	55.575	124840.0
2018-09-10 08:00:00	AAPL	Stock	55.4875	55.6225	55.45	55.595	279120.0
2018-09-10 08:30:00	AAPL	Stock	55.6175	55.6175	55.46	55.465	283672.0
2018-09-10 09:00:00	AAPL	Stock	55.47	55.48	55.165	55.265	594724.0
2018-09-10 09:30:00	AAPL	Stock	55.24	55.4625	54.3065	54.7025	27449612.0
2018-09-10 10:00:00	AAPL	Stock	54.71	54.7925	54.1175	54.1888	15743804.0
2018-09-10 10:30:00	AAPL	Stock	54.1875	54.5525	54.12	54.39	10944156.0
2018-09-10 11:00:00	AAPL	Stock	54.39	54.74	54.265	54.73	9145964.0
2018-09-10 11:30:00	AAPL	Stock	54.7325	54.8775	54.5925	54.84	7938744.0
2018-09-10 12:00:00	AAPL	Stock	54.8412	54.8425	54.295	54.4432	7812316.0
2018-09-10 12:30:00	AAPL	Stock	54.4438	54.4875	54.2025	54.2738	5694356.0
2018-09-10 13:00:00	AAPL	Stock	54.27	54.495	54.2612	54.46	4314164.0
2018-09-10 13:30:00	AAPL	Stock	54.461	54.6075	54.4275	54.575	4140420.0
2018-09-10 14:00:00	AAPL	Stock	54.5738	54.6875	54.5305	54.6025	4153900.0
2018-09-10 14:30:00	AAPL	Stock	54.6038	54.6125	54.535	54.585	3075664.0
2018-09-10 15:00:00	AAPL	Stock	54.585	54.725	54.5832	54.6275	4903204.0
2018-09-10 15:30:00	AAPL	Stock	54.625	54.7475	54.5475	54.585	12182684.0
2018-09-10 16:00:00	AAPL	Stock	54.585	54.6025	54.545	54.545	14044444.0
2018-09-10 16:30:00	AAPL	Stock	54.56	54.5825	54.5	54.545	236748.0
2018-09-10 17:00:00	AAPL	Stock	54.54	54.57	54.53	54.565	18564.0
2018-09-10 17:30:00	AAPL	Stock	54.565	54.6	54.5625	54.6	20552.0
2018-09-10 18:00:00	AAPL	Stock	54.5875	54.69	54.5875	54.6525	61484.0
2018-09-10 18:30:00	AAPL	Stock	54.6575	54.6875	54.655	54.675	20728.0
2018-09-10 19:00:00	AAPL	Stock	54.6875	54.6925	54.675	54.675	2316.0
2018-09-10 19:30:00	AAPL	Stock	54.6925	54.725	54.675	54.6775	34296.0
2018-09-10 04:30:00	MSFT	Stock	108.89	108.89	108.89	108.89	106.0
2018-09-10 05:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	411.0
2018-09-10 06:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	623.0
2018-09-10 06:30:00	MSFT	Stock	109.03	109.03	108.9	108.9	1000.0
2018-09-10 07:00:00	MSFT	Stock	108.65	108.89	108.65	108.89	2258.0
2018-09-10 07:30:00	MSFT	Stock	108.88	108.89	108.72	108.85	1200.0
2018-09-10 08:00:00	MSFT	Stock	108.88	108.95	108.85	108.89	3879.0
2018-09-10 08:30:00	MSFT	Stock	108.89	108.9	108.74	108.85	8180.0
2018-09-10 09:00:00	MSFT	Stock	108.85	108.9	108.8	108.85	10292.0
2018-09-10 09:30:00	MSFT	Stock	108.85	108.97	108.41	108.54	1963814.0
2018-09-10 10:00:00	MSFT	Stock	108.54	108.76	108.36	108.635	1162425.0
2018-09-10 10:30:00	MSFT	Stock	108.64	108.84	108.555	108.69	951226.0
2018-09-10 11:00:00	MSFT	Stock	108.69	109.28	108.52	109.222	1224955.0
2018-09-10 11:30:00	MSFT	Stock	109.23	109.24	109.09	109.17	582394.0
2018-09-10 12:00:00	MSFT	Stock	109.165	109.35	108.975	109.07	711638.0
2018-09-10 12:30:00	MSFT	Stock	109.075	109.29	109.02	109.287	559068.0
2018-09-10 13:00:00	MSFT	Stock	109.285	109.64	109.2	109.605	796254.0
2018-09-10 13:30:00	MSFT	Stock	109.61	109.63	109.37	109.53	637165.0

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

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