PREVIEW / stock_30min / 2018-12-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-11.parquet
  size:    1.7 MB
  rows:    84,423
  symbols: 2,730

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-12-11 04:00:00	AAPL	Stock	42.375	42.5125	42.2875	42.485	10884.0
2018-12-11 04:30:00	AAPL	Stock	42.5	42.6425	42.45	42.6425	2500.0
2018-12-11 05:00:00	AAPL	Stock	42.6425	42.85	42.6425	42.85	8144.0
2018-12-11 05:30:00	AAPL	Stock	42.805	42.845	42.775	42.845	27140.0
2018-12-11 06:00:00	AAPL	Stock	42.7575	42.82	42.75	42.7975	45992.0
2018-12-11 06:30:00	AAPL	Stock	42.8	42.895	42.775	42.78	45568.0
2018-12-11 07:00:00	AAPL	Stock	42.84	42.95	42.795	42.8625	163380.0
2018-12-11 07:30:00	AAPL	Stock	42.8425	42.8575	42.7775	42.8025	158156.0
2018-12-11 08:00:00	AAPL	Stock	42.8962	42.96	42.4	42.925	518532.0
2018-12-11 08:30:00	AAPL	Stock	42.925	42.995	42.8975	42.935	558684.0
2018-12-11 09:00:00	AAPL	Stock	42.9275	42.9675	42.82	42.9225	443496.0
2018-12-11 09:30:00	AAPL	Stock	42.9175	42.9475	42.03	42.0375	24758660.0
2018-12-11 10:00:00	AAPL	Stock	42.0475	42.4475	41.935	42.43	18723640.0
2018-12-11 10:30:00	AAPL	Stock	42.4275	42.4625	42.0375	42.1243	11623440.0
2018-12-11 11:00:00	AAPL	Stock	42.12	42.395	42.0375	42.3338	9136812.0
2018-12-11 11:30:00	AAPL	Stock	42.335	42.5875	42.205	42.5575	10515924.0
2018-12-11 12:00:00	AAPL	Stock	42.555	42.555	42.15	42.2425	8431732.0
2018-12-11 12:30:00	AAPL	Stock	42.25	42.3325	42.0925	42.1	5921048.0
2018-12-11 13:00:00	AAPL	Stock	42.0975	42.26	42.06	42.1825	5896804.0
2018-12-11 13:30:00	AAPL	Stock	42.1808	42.22	41.8425	41.8975	6925616.0
2018-12-11 14:00:00	AAPL	Stock	41.895	42.09	41.75	42.0785	8842804.0
2018-12-11 14:30:00	AAPL	Stock	42.0825	42.2675	42.075	42.1175	10111384.0
2018-12-11 15:00:00	AAPL	Stock	42.1275	42.3925	41.9925	42.31	9195152.0
2018-12-11 15:30:00	AAPL	Stock	42.3125	42.4725	42.1375	42.1575	12503908.0
2018-12-11 16:00:00	AAPL	Stock	42.1575	42.1875	42.1425	42.175	17614092.0
2018-12-11 16:30:00	AAPL	Stock	42.175	42.175	42.015	42.06	98328.0
2018-12-11 17:00:00	AAPL	Stock	42.05	42.085	41.8875	41.9525	78860.0
2018-12-11 17:30:00	AAPL	Stock	42.0	42.05	41.995	42.0475	15148.0
2018-12-11 18:00:00	AAPL	Stock	42.0475	42.22	42.0475	42.085	105744.0
2018-12-11 18:30:00	AAPL	Stock	42.095	42.1825	42.095	42.1725	15416.0
2018-12-11 19:00:00	AAPL	Stock	42.15	42.22	42.0975	42.22	22448.0
2018-12-11 19:30:00	AAPL	Stock	42.2	42.43	42.2	42.43	88432.0
2018-12-11 04:30:00	MSFT	Stock	107.39	107.7	107.39	107.7	800.0
2018-12-11 05:00:00	MSFT	Stock	108.07	108.11	108.07	108.11	400.0
2018-12-11 06:00:00	MSFT	Stock	108.09	108.3	108.02	108.3	1809.0
2018-12-11 06:30:00	MSFT	Stock	108.5	108.8	108.5	108.8	2222.0
2018-12-11 07:00:00	MSFT	Stock	108.8	109.0	108.8	108.95	14936.0
2018-12-11 07:30:00	MSFT	Stock	108.9	108.99	108.69	108.71	21743.0
2018-12-11 08:00:00	MSFT	Stock	109.05	109.07	108.55	109.0	31713.0
2018-12-11 08:30:00	MSFT	Stock	108.96	109.69	108.93	109.45	81024.0
2018-12-11 09:00:00	MSFT	Stock	109.41	109.88	109.1	109.84	85942.0
2018-12-11 09:30:00	MSFT	Stock	109.84	110.922	109.65	110.731	6038231.0
2018-12-11 10:00:00	MSFT	Stock	110.74	110.95	109.53	110.55	4377015.0
2018-12-11 10:30:00	MSFT	Stock	110.55	110.69	109.61	109.825	2992731.0
2018-12-11 11:00:00	MSFT	Stock	109.83	109.91	109.29	109.54	2415465.0
2018-12-11 11:30:00	MSFT	Stock	109.52	109.6	108.831	109.48	2045956.0
2018-12-11 12:00:00	MSFT	Stock	109.48	109.48	108.17	108.56	2188502.0
2018-12-11 12:30:00	MSFT	Stock	108.57	108.85	108.23	108.55	1741889.0
2018-12-11 13:00:00	MSFT	Stock	108.546	108.68	108.12	108.42	1309697.0
2018-12-11 13:30:00	MSFT	Stock	108.42	108.42	107.44	107.57	1847201.0

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

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