PREVIEW / stock_30min / 2018-01-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-10.parquet
  size:    1.7 MB
  rows:    84,715
  symbols: 2,903

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-01-10 04:00:00	AAPL	Stock	43.475	43.475	43.45	43.47	7600.0
2018-01-10 04:30:00	AAPL	Stock	43.4625	43.4625	43.3575	43.3625	8548.0
2018-01-10 05:30:00	AAPL	Stock	43.3325	43.3325	43.27	43.2875	19632.0
2018-01-10 06:00:00	AAPL	Stock	43.245	43.245	43.15	43.2075	48652.0
2018-01-10 06:30:00	AAPL	Stock	43.175	43.2075	43.175	43.175	12228.0
2018-01-10 07:00:00	AAPL	Stock	43.1825	43.225	43.125	43.225	157152.0
2018-01-10 07:30:00	AAPL	Stock	43.2375	43.27	43.2025	43.2025	110740.0
2018-01-10 08:00:00	AAPL	Stock	43.205	43.3125	43.1425	43.3075	248384.0
2018-01-10 08:30:00	AAPL	Stock	43.31	43.45	43.275	43.31	153704.0
2018-01-10 09:00:00	AAPL	Stock	43.3	43.35	43.255	43.31	147384.0
2018-01-10 09:30:00	AAPL	Stock	43.29	43.4775	43.25	43.33	13025412.0
2018-01-10 10:00:00	AAPL	Stock	43.34	43.5525	43.2578	43.394	8542228.0
2018-01-10 10:30:00	AAPL	Stock	43.3925	43.465	43.33	43.395	5496328.0
2018-01-10 11:00:00	AAPL	Stock	43.394	43.4775	43.35	43.354	4352316.0
2018-01-10 11:30:00	AAPL	Stock	43.354	43.3875	43.295	43.3025	4286128.0
2018-01-10 12:00:00	AAPL	Stock	43.3	43.3325	43.25	43.2775	4036656.0
2018-01-10 12:30:00	AAPL	Stock	43.275	43.3625	43.2738	43.3438	2383600.0
2018-01-10 13:00:00	AAPL	Stock	43.3438	43.3625	43.26	43.2985	2913912.0
2018-01-10 13:30:00	AAPL	Stock	43.2975	43.4325	43.2825	43.4238	3349464.0
2018-01-10 14:00:00	AAPL	Stock	43.425	43.4775	43.3825	43.3938	12062680.0
2018-01-10 14:30:00	AAPL	Stock	43.3925	43.4588	43.3575	43.4308	3702704.0
2018-01-10 15:00:00	AAPL	Stock	43.43	43.455	43.3825	43.4525	3302484.0
2018-01-10 15:30:00	AAPL	Stock	43.4515	43.575	43.45	43.5612	8608756.0
2018-01-10 16:00:00	AAPL	Stock	43.5725	43.5725	43.3755	43.5375	6650808.0
2018-01-10 16:30:00	AAPL	Stock	43.5575	43.5725	43.55	43.56	14424.0
2018-01-10 17:00:00	AAPL	Stock	43.56	43.5725	43.55	43.5725	661648.0
2018-01-10 17:30:00	AAPL	Stock	43.55	43.575	43.55	43.575	161836.0
2018-01-10 18:00:00	AAPL	Stock	43.5825	43.5825	43.55	43.55	2060.0
2018-01-10 18:30:00	AAPL	Stock	43.5625	43.5725	43.55	43.5725	2000.0
2018-01-10 19:00:00	AAPL	Stock	43.5725	43.5725	43.5725	43.5725	400.0
2018-01-10 19:30:00	AAPL	Stock	43.5675	43.6125	43.5675	43.6125	21136.0
2018-01-10 05:00:00	MSFT	Stock	88.0	88.0	88.0	88.0	801.0
2018-01-10 06:00:00	MSFT	Stock	87.89	87.89	87.11	87.15	700.0
2018-01-10 07:00:00	MSFT	Stock	87.82	87.84	87.45	87.5	4338.0
2018-01-10 07:30:00	MSFT	Stock	87.55	87.6	87.51	87.55	1105.0
2018-01-10 08:00:00	MSFT	Stock	87.75	87.87	87.45	87.62	5794.0
2018-01-10 08:30:00	MSFT	Stock	87.84	87.99	87.77	87.77	4132.0
2018-01-10 09:00:00	MSFT	Stock	87.79	87.8	87.65	87.75	14389.0
2018-01-10 09:30:00	MSFT	Stock	87.86	88.19	87.58	87.86	2313262.0
2018-01-10 10:00:00	MSFT	Stock	87.855	87.94	87.71	87.71	1485116.0
2018-01-10 10:30:00	MSFT	Stock	87.715	87.86	87.56	87.69	1178842.0
2018-01-10 11:00:00	MSFT	Stock	87.69	87.88	87.61	87.62	742053.0
2018-01-10 11:30:00	MSFT	Stock	87.62	87.71	87.52	87.56	796971.0
2018-01-10 12:00:00	MSFT	Stock	87.55	87.72	87.455	87.65	978808.0
2018-01-10 12:30:00	MSFT	Stock	87.65	87.78	87.63	87.74	524530.0
2018-01-10 13:00:00	MSFT	Stock	87.732	87.87	87.59	87.595	729194.0
2018-01-10 13:30:00	MSFT	Stock	87.59	87.81	87.52	87.8	809726.0
2018-01-10 14:00:00	MSFT	Stock	87.8	87.809	87.46	87.495	664588.0
2018-01-10 14:30:00	MSFT	Stock	87.495	87.75	87.41	87.715	905062.0
2018-01-10 15:00:00	MSFT	Stock	87.71	87.82	87.69	87.77	867493.0

> showing 50 of 84,715 rows — these rows as CSV

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