PREVIEW / stock_30min / 2018-09-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-21.parquet
  size:    1.7 MB
  rows:    85,217
  symbols: 2,786

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-21 04:00:00	AAPL	Stock	55.19	55.36	55.19	55.31	11048.0
2018-09-21 04:30:00	AAPL	Stock	55.31	55.31	55.1	55.1	13008.0
2018-09-21 05:00:00	AAPL	Stock	55.1	55.1125	55.08	55.08	4596.0
2018-09-21 05:30:00	AAPL	Stock	55.1875	55.1875	55.175	55.175	4072.0
2018-09-21 06:00:00	AAPL	Stock	55.175	55.2	55.175	55.2	4800.0
2018-09-21 06:30:00	AAPL	Stock	55.1875	55.1875	55.125	55.125	3520.0
2018-09-21 07:00:00	AAPL	Stock	55.1575	55.1575	55.05	55.05	43976.0
2018-09-21 07:30:00	AAPL	Stock	55.075	55.0875	54.98	55.075	38552.0
2018-09-21 08:00:00	AAPL	Stock	55.155	55.1575	55.0	55.0875	169500.0
2018-09-21 08:30:00	AAPL	Stock	55.085	55.225	55.085	55.185	114940.0
2018-09-21 09:00:00	AAPL	Stock	55.18	55.3375	55.155	55.19	797696.0
2018-09-21 09:30:00	AAPL	Stock	55.1425	55.34	54.935	54.9508	45233632.0
2018-09-21 10:00:00	AAPL	Stock	54.95	54.9925	54.635	54.6562	9638544.0
2018-09-21 10:30:00	AAPL	Stock	54.655	54.7962	54.595	54.7585	7128928.0
2018-09-21 11:00:00	AAPL	Stock	54.7575	54.875	54.6125	54.86	6709612.0
2018-09-21 11:30:00	AAPL	Stock	54.86	54.875	54.655	54.8368	5698668.0
2018-09-21 12:00:00	AAPL	Stock	54.8375	54.9975	54.8288	54.8525	5189344.0
2018-09-21 12:30:00	AAPL	Stock	54.8525	54.89	54.735	54.845	4287580.0
2018-09-21 13:00:00	AAPL	Stock	54.845	54.8625	54.6975	54.71	3719456.0
2018-09-21 13:30:00	AAPL	Stock	54.7125	54.755	54.61	54.7418	4287432.0
2018-09-21 14:00:00	AAPL	Stock	54.74	54.745	54.525	54.6775	4854780.0
2018-09-21 14:30:00	AAPL	Stock	54.675	54.7275	54.5325	54.565	4782064.0
2018-09-21 15:00:00	AAPL	Stock	54.565	54.618	54.465	54.4825	9800416.0
2018-09-21 15:30:00	AAPL	Stock	54.485	54.59	54.3225	54.4138	31222612.0
2018-09-21 16:00:00	AAPL	Stock	54.415	54.5	54.37	54.425	164956580.0
2018-09-21 16:30:00	AAPL	Stock	54.425	54.445	54.4125	54.43	364488.0
2018-09-21 17:00:00	AAPL	Stock	54.43	54.4975	54.415	54.475	641088.0
2018-09-21 17:30:00	AAPL	Stock	54.475	54.49	54.44	54.4725	63352.0
2018-09-21 18:00:00	AAPL	Stock	54.4725	54.49	54.445	54.4875	23320.0
2018-09-21 18:30:00	AAPL	Stock	54.45	54.47	54.4375	54.4375	6836.0
2018-09-21 19:00:00	AAPL	Stock	54.455	54.47	54.44	54.47	16100.0
2018-09-21 19:30:00	AAPL	Stock	54.4425	54.5	54.44	54.46	60156.0
2018-09-21 04:00:00	MSFT	Stock	113.7	113.9	113.7	113.8	4446.0
2018-09-21 04:30:00	MSFT	Stock	113.8	113.8	113.75	113.8	2841.0
2018-09-21 05:00:00	MSFT	Stock	113.8	113.8	113.8	113.8	200.0
2018-09-21 05:30:00	MSFT	Stock	113.8	113.8	113.8	113.8	100.0
2018-09-21 06:00:00	MSFT	Stock	113.8	113.8	113.8	113.8	100.0
2018-09-21 06:30:00	MSFT	Stock	113.66	113.66	113.66	113.66	200.0
2018-09-21 07:00:00	MSFT	Stock	113.67	113.7	113.64	113.64	2412.0
2018-09-21 08:00:00	MSFT	Stock	113.7	113.74	113.6	113.66	3065.0
2018-09-21 08:30:00	MSFT	Stock	113.72	113.8	113.7	113.8	18439.0
2018-09-21 09:00:00	MSFT	Stock	113.8	114.08	113.74	114.01	327843.0
2018-09-21 09:30:00	MSFT	Stock	113.95	114.3	113.8	114.05	14597655.0
2018-09-21 10:00:00	MSFT	Stock	114.05	114.25	113.72	113.73	1898465.0
2018-09-21 10:30:00	MSFT	Stock	113.73	114.05	113.66	113.946	1353064.0
2018-09-21 11:00:00	MSFT	Stock	113.945	114.275	113.72	114.27	1447734.0
2018-09-21 11:30:00	MSFT	Stock	114.27	114.45	114.19	114.43	1415627.0
2018-09-21 12:00:00	MSFT	Stock	114.425	114.55	114.32	114.33	1282179.0
2018-09-21 12:30:00	MSFT	Stock	114.34	114.44	114.11	114.3	1062015.0
2018-09-21 13:00:00	MSFT	Stock	114.29	114.385	114.22	114.27	786487.0

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

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