PREVIEW / stock_30min / 2018-11-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-16.parquet
  size:    1.7 MB
  rows:    82,810
  symbols: 2,746

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-11-16 04:00:00	AAPL	Stock	47.645	47.645	47.4775	47.505	18896.0
2018-11-16 04:30:00	AAPL	Stock	47.5725	47.625	47.5725	47.5975	9204.0
2018-11-16 05:00:00	AAPL	Stock	47.5325	47.55	47.45	47.455	10728.0
2018-11-16 05:30:00	AAPL	Stock	47.475	47.475	47.45	47.475	7600.0
2018-11-16 06:00:00	AAPL	Stock	47.45	47.475	47.41	47.4375	11208.0
2018-11-16 06:30:00	AAPL	Stock	47.495	47.5925	47.4375	47.5	13060.0
2018-11-16 07:00:00	AAPL	Stock	47.5	47.5625	47.4075	47.475	64296.0
2018-11-16 07:30:00	AAPL	Stock	47.4825	47.5675	47.395	47.54	60320.0
2018-11-16 08:00:00	AAPL	Stock	47.4625	47.6	47.3825	47.39	192916.0
2018-11-16 08:30:00	AAPL	Stock	47.3825	47.55	47.315	47.55	362476.0
2018-11-16 09:00:00	AAPL	Stock	47.5325	47.6325	47.475	47.6025	331952.0
2018-11-16 09:30:00	AAPL	Stock	47.6025	48.19	47.365	48.1525	19751204.0
2018-11-16 10:00:00	AAPL	Stock	48.1525	48.6925	48.0925	48.6322	19655840.0
2018-11-16 10:30:00	AAPL	Stock	48.635	48.7425	48.3925	48.4342	11396132.0
2018-11-16 11:00:00	AAPL	Stock	48.4325	48.52	48.265	48.4	6928620.0
2018-11-16 11:30:00	AAPL	Stock	48.4032	48.45	48.1325	48.2075	6589464.0
2018-11-16 12:00:00	AAPL	Stock	48.212	48.3725	48.1525	48.2175	5118928.0
2018-11-16 12:30:00	AAPL	Stock	48.21	48.6275	48.0875	48.4112	8850944.0
2018-11-16 13:00:00	AAPL	Stock	48.4172	48.475	48.1625	48.2425	4216124.0
2018-11-16 13:30:00	AAPL	Stock	48.252	48.2588	48.0578	48.1625	3967996.0
2018-11-16 14:00:00	AAPL	Stock	48.1575	48.355	48.1175	48.3175	4004916.0
2018-11-16 14:30:00	AAPL	Stock	48.3175	48.5938	48.3175	48.5475	5661568.0
2018-11-16 15:00:00	AAPL	Stock	48.5472	48.6375	48.485	48.5498	6505016.0
2018-11-16 15:30:00	AAPL	Stock	48.5475	48.62	48.355	48.3825	13091064.0
2018-11-16 16:00:00	AAPL	Stock	48.3825	48.445	48.3775	48.425	11258856.0
2018-11-16 16:30:00	AAPL	Stock	48.4225	48.4375	48.3825	48.425	507152.0
2018-11-16 17:00:00	AAPL	Stock	48.4375	48.4532	48.42	48.435	46504.0
2018-11-16 17:30:00	AAPL	Stock	48.4425	48.4675	48.4375	48.4675	44072.0
2018-11-16 18:00:00	AAPL	Stock	48.4575	48.47	48.44	48.47	20500.0
2018-11-16 18:30:00	AAPL	Stock	48.4625	48.5	48.45	48.4975	39380.0
2018-11-16 19:00:00	AAPL	Stock	48.495	48.5	48.465	48.475	15424.0
2018-11-16 19:30:00	AAPL	Stock	48.475	48.5	48.475	48.5	9548.0
2018-11-16 04:00:00	MSFT	Stock	106.7	106.7	106.7	106.7	500.0
2018-11-16 06:00:00	MSFT	Stock	106.4	106.4	106.4	106.4	2336.0
2018-11-16 06:30:00	MSFT	Stock	106.13	106.13	106.13	106.13	399.0
2018-11-16 07:00:00	MSFT	Stock	106.65	106.65	106.3	106.4	3350.0
2018-11-16 07:30:00	MSFT	Stock	106.4	106.66	106.4	106.64	3725.0
2018-11-16 08:00:00	MSFT	Stock	106.4	106.66	106.21	106.21	13981.0
2018-11-16 08:30:00	MSFT	Stock	106.21	106.69	106.0	106.69	24797.0
2018-11-16 09:00:00	MSFT	Stock	106.56	107.1	106.39	107.07	48642.0
2018-11-16 09:30:00	MSFT	Stock	107.08	107.95	106.8	107.77	4871572.0
2018-11-16 10:00:00	MSFT	Stock	107.765	108.23	107.56	108.13	1738018.0
2018-11-16 10:30:00	MSFT	Stock	108.15	108.61	108.09	108.16	2018041.0
2018-11-16 11:00:00	MSFT	Stock	108.17	108.24	107.65	107.81	1426774.0
2018-11-16 11:30:00	MSFT	Stock	107.82	107.931	107.26	107.5	1420127.0
2018-11-16 12:00:00	MSFT	Stock	107.51	107.885	107.3	107.575	1129699.0
2018-11-16 12:30:00	MSFT	Stock	107.56	108.88	107.43	108.31	2278502.0
2018-11-16 13:00:00	MSFT	Stock	108.31	108.38	107.82	108.1	1555633.0
2018-11-16 13:30:00	MSFT	Stock	108.11	108.25	107.73	107.9	1259513.0
2018-11-16 14:00:00	MSFT	Stock	107.9	108.23	107.635	108.06	1410714.0

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

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