PREVIEW / stock_30min / 2018-07-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-24.parquet
  size:    1.7 MB
  rows:    83,266
  symbols: 2,831

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-24 04:00:00	AAPL	Stock	48.025	48.055	48.025	48.045	8000.0
2018-07-24 04:30:00	AAPL	Stock	48.095	48.1	48.09	48.09	3400.0
2018-07-24 05:00:00	AAPL	Stock	48.0975	48.0975	48.075	48.075	1952.0
2018-07-24 05:30:00	AAPL	Stock	48.1125	48.1125	48.1125	48.1125	800.0
2018-07-24 06:00:00	AAPL	Stock	48.135	48.135	47.8775	47.935	75356.0
2018-07-24 06:30:00	AAPL	Stock	47.945	48.06	47.925	47.9625	18832.0
2018-07-24 07:00:00	AAPL	Stock	48.0	48.03	47.9375	47.9975	56688.0
2018-07-24 07:30:00	AAPL	Stock	47.9625	48.0625	47.9625	48.0625	54680.0
2018-07-24 08:00:00	AAPL	Stock	47.9625	48.1525	47.9375	48.1375	198104.0
2018-07-24 08:30:00	AAPL	Stock	48.1375	48.1525	48.0825	48.0875	104904.0
2018-07-24 09:00:00	AAPL	Stock	48.0875	48.15	48.0225	48.0225	89116.0
2018-07-24 09:30:00	AAPL	Stock	48.1125	48.415	48.0475	48.295	12644168.0
2018-07-24 10:00:00	AAPL	Stock	48.2938	48.37	48.25	48.2725	4669524.0
2018-07-24 10:30:00	AAPL	Stock	48.275	48.305	48.2075	48.2275	3763060.0
2018-07-24 11:00:00	AAPL	Stock	48.225	48.2575	48.1	48.1325	3955160.0
2018-07-24 11:30:00	AAPL	Stock	48.1325	48.145	48.0125	48.105	3321656.0
2018-07-24 12:00:00	AAPL	Stock	48.1075	48.2	48.0925	48.1925	2660608.0
2018-07-24 12:30:00	AAPL	Stock	48.1905	48.2325	48.0975	48.16	3386336.0
2018-07-24 13:00:00	AAPL	Stock	48.1575	48.2125	48.1225	48.1375	2764276.0
2018-07-24 13:30:00	AAPL	Stock	48.1425	48.235	48.0925	48.2125	2970232.0
2018-07-24 14:00:00	AAPL	Stock	48.2125	48.2125	48.115	48.1925	2518196.0
2018-07-24 14:30:00	AAPL	Stock	48.19	48.2275	48.1375	48.2025	2075488.0
2018-07-24 15:00:00	AAPL	Stock	48.2025	48.25	48.1738	48.2	2349532.0
2018-07-24 15:30:00	AAPL	Stock	48.2025	48.2475	48.1075	48.2475	6495476.0
2018-07-24 16:00:00	AAPL	Stock	48.25	48.265	48.22	48.2425	10883420.0
2018-07-24 16:30:00	AAPL	Stock	48.2375	48.2625	48.225	48.2625	114552.0
2018-07-24 17:00:00	AAPL	Stock	48.26	48.26	48.26	48.26	400.0
2018-07-24 17:30:00	AAPL	Stock	48.2175	48.245	48.2175	48.2325	8008.0
2018-07-24 18:00:00	AAPL	Stock	48.25	48.25	48.22	48.2275	4812.0
2018-07-24 18:30:00	AAPL	Stock	48.225	48.24	48.225	48.23	1416.0
2018-07-24 19:00:00	AAPL	Stock	48.2425	48.2425	48.2425	48.2425	1760.0
2018-07-24 19:30:00	AAPL	Stock	48.235	48.2375	48.225	48.225	8304.0
2018-07-24 04:00:00	MSFT	Stock	108.5	108.5	108.47	108.5	1747.0
2018-07-24 05:00:00	MSFT	Stock	108.5	108.65	108.5	108.65	1066.0
2018-07-24 05:30:00	MSFT	Stock	108.64	108.7	108.64	108.7	800.0
2018-07-24 06:00:00	MSFT	Stock	108.74	108.79	108.74	108.79	2415.0
2018-07-24 06:30:00	MSFT	Stock	108.75	108.79	108.5	108.5	6895.0
2018-07-24 07:00:00	MSFT	Stock	108.5	108.6	108.3	108.33	12098.0
2018-07-24 07:30:00	MSFT	Stock	108.22	108.4	108.19	108.39	18024.0
2018-07-24 08:00:00	MSFT	Stock	108.3	108.67	108.2	108.61	15401.0
2018-07-24 08:30:00	MSFT	Stock	108.65	108.65	108.5	108.5	16373.0
2018-07-24 09:00:00	MSFT	Stock	108.37	108.65	108.37	108.4	18157.0
2018-07-24 09:30:00	MSFT	Stock	108.57	108.82	107.94	108.35	3746470.0
2018-07-24 10:00:00	MSFT	Stock	108.36	108.58	108.29	108.46	1827880.0
2018-07-24 10:30:00	MSFT	Stock	108.46	108.51	108.09	108.13	1672375.0
2018-07-24 11:00:00	MSFT	Stock	108.14	108.16	107.71	108.029	2347019.0
2018-07-24 11:30:00	MSFT	Stock	108.025	108.08	107.69	107.98	1499506.0
2018-07-24 12:00:00	MSFT	Stock	107.98	108.077	107.83	107.94	780996.0
2018-07-24 12:30:00	MSFT	Stock	107.945	107.945	107.47	107.54	1020653.0
2018-07-24 13:00:00	MSFT	Stock	107.54	107.69	107.36	107.44	1045314.0

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

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