PREVIEW / stock_30min / 2018-09-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-24.parquet
  size:    1.7 MB
  rows:    85,261
  symbols: 2,792

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-24 04:00:00	AAPL	Stock	54.4125	54.4125	54.375	54.375	4324.0
2018-09-24 04:30:00	AAPL	Stock	54.175	54.175	54.175	54.175	1264.0
2018-09-24 05:30:00	AAPL	Stock	54.15	54.175	54.15	54.15	5092.0
2018-09-24 06:00:00	AAPL	Stock	54.2075	54.2075	54.2075	54.2075	400.0
2018-09-24 06:30:00	AAPL	Stock	54.1925	54.2075	54.1875	54.2075	8120.0
2018-09-24 07:00:00	AAPL	Stock	54.1825	54.22	54.115	54.1625	121436.0
2018-09-24 07:30:00	AAPL	Stock	54.185	54.295	54.1675	54.215	33792.0
2018-09-24 08:00:00	AAPL	Stock	54.2175	54.29	54.1275	54.2125	281580.0
2018-09-24 08:30:00	AAPL	Stock	54.2075	54.335	54.205	54.2525	134332.0
2018-09-24 09:00:00	AAPL	Stock	54.255	54.4625	54.14	54.14	385244.0
2018-09-24 09:30:00	AAPL	Stock	54.2425	54.7075	54.1575	54.4825	14094080.0
2018-09-24 10:00:00	AAPL	Stock	54.4825	54.5225	54.295	54.46	7146108.0
2018-09-24 10:30:00	AAPL	Stock	54.455	54.7	54.3925	54.6975	7370744.0
2018-09-24 11:00:00	AAPL	Stock	54.6925	54.9375	54.625	54.885	7316216.0
2018-09-24 11:30:00	AAPL	Stock	54.8875	55.05	54.885	55.025	6389492.0
2018-09-24 12:00:00	AAPL	Stock	55.0275	55.045	54.9475	55.0225	4076756.0
2018-09-24 12:30:00	AAPL	Stock	55.0225	55.08	54.9	54.9475	4823804.0
2018-09-24 13:00:00	AAPL	Stock	54.9525	55.04	54.915	54.9662	2823404.0
2018-09-24 13:30:00	AAPL	Stock	54.9675	55.0725	54.95	55.065	2678188.0
2018-09-24 14:00:00	AAPL	Stock	55.065	55.08	54.9675	54.985	2448860.0
2018-09-24 14:30:00	AAPL	Stock	54.9875	55.04	54.9425	55.0075	3052952.0
2018-09-24 15:00:00	AAPL	Stock	55.0075	55.0925	54.98	55.065	3378188.0
2018-09-24 15:30:00	AAPL	Stock	55.065	55.315	55.0575	55.1975	12541492.0
2018-09-24 16:00:00	AAPL	Stock	55.1975	55.245	55.1975	55.2125	13730640.0
2018-09-24 16:30:00	AAPL	Stock	55.22	55.25	55.1975	55.25	156832.0
2018-09-24 17:00:00	AAPL	Stock	55.2325	55.2375	55.21	55.225	38804.0
2018-09-24 17:30:00	AAPL	Stock	55.225	55.2375	55.2125	55.215	4836.0
2018-09-24 18:00:00	AAPL	Stock	55.2375	55.2375	55.225	55.225	5292.0
2018-09-24 18:30:00	AAPL	Stock	55.2425	55.2425	55.2275	55.2275	5392.0
2018-09-24 19:00:00	AAPL	Stock	55.2475	55.25	55.23	55.25	30376.0
2018-09-24 19:30:00	AAPL	Stock	55.25	55.2875	55.25	55.285	25320.0
2018-09-24 05:00:00	MSFT	Stock	113.83	113.83	113.83	113.83	300.0
2018-09-24 07:00:00	MSFT	Stock	113.88	113.88	113.71	113.71	1677.0
2018-09-24 07:30:00	MSFT	Stock	113.77	113.77	113.71	113.75	543.0
2018-09-24 08:00:00	MSFT	Stock	113.88	113.88	113.61	113.88	5411.0
2018-09-24 08:30:00	MSFT	Stock	113.75	113.8	113.7	113.71	3450.0
2018-09-24 09:00:00	MSFT	Stock	113.76	113.78	113.02	113.03	32854.0
2018-09-24 09:30:00	MSFT	Stock	113.02	113.67	112.218	113.65	3701346.0
2018-09-24 10:00:00	MSFT	Stock	113.66	114.07	113.54	113.825	2027002.0
2018-09-24 10:30:00	MSFT	Stock	113.82	114.13	113.57	113.85	1444109.0
2018-09-24 11:00:00	MSFT	Stock	113.85	114.57	113.73	114.395	1307127.0
2018-09-24 11:30:00	MSFT	Stock	114.395	114.54	114.37	114.485	1049869.0
2018-09-24 12:00:00	MSFT	Stock	114.49	114.54	114.23	114.29	770315.0
2018-09-24 12:30:00	MSFT	Stock	114.28	114.34	114.031	114.15	929078.0
2018-09-24 13:00:00	MSFT	Stock	114.16	114.49	114.117	114.425	868993.0
2018-09-24 13:30:00	MSFT	Stock	114.425	114.695	114.42	114.61	997942.0
2018-09-24 14:00:00	MSFT	Stock	114.609	114.67	114.44	114.535	665198.0
2018-09-24 14:30:00	MSFT	Stock	114.53	114.62	114.48	114.49	622333.0
2018-09-24 15:00:00	MSFT	Stock	114.48	114.73	114.434	114.72	1158424.0
2018-09-24 15:30:00	MSFT	Stock	114.73	114.9	114.64	114.67	2997174.0

> showing 50 of 85,261 rows — these rows as CSV

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