PREVIEW / stock_30min / 2019-06-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-27.parquet
  size:    1.7 MB
  rows:    85,224
  symbols: 2,621

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
2019-06-27 04:00:00	AAPL	Stock	50.2275	50.305	50.1875	50.305	4840.0
2019-06-27 04:30:00	AAPL	Stock	50.275	50.3125	50.22	50.245	7564.0
2019-06-27 05:00:00	AAPL	Stock	50.2375	50.3075	50.2	50.2525	4680.0
2019-06-27 05:30:00	AAPL	Stock	50.325	50.43	50.175	50.1825	53784.0
2019-06-27 06:00:00	AAPL	Stock	50.165	50.165	50.0	50.125	30480.0
2019-06-27 06:30:00	AAPL	Stock	50.1425	50.1425	50.0425	50.1175	40080.0
2019-06-27 07:00:00	AAPL	Stock	50.1025	50.1175	50.07	50.07	88336.0
2019-06-27 07:30:00	AAPL	Stock	50.0625	50.0825	50.0075	50.0325	59196.0
2019-06-27 08:00:00	AAPL	Stock	50.1	50.175	50.0375	50.1625	331172.0
2019-06-27 08:30:00	AAPL	Stock	50.1725	50.205	50.1	50.1375	176916.0
2019-06-27 09:00:00	AAPL	Stock	50.15	50.15	50.0275	50.0475	162784.0
2019-06-27 09:30:00	AAPL	Stock	50.0725	50.3925	50.03	50.3125	11692704.0
2019-06-27 10:00:00	AAPL	Stock	50.305	50.3375	50.17	50.205	4839608.0
2019-06-27 10:30:00	AAPL	Stock	50.205	50.2212	50.03	50.145	3884048.0
2019-06-27 11:00:00	AAPL	Stock	50.1425	50.1925	49.9778	50.03	4939168.0
2019-06-27 11:30:00	AAPL	Stock	50.0325	50.0325	49.8925	49.95	3933492.0
2019-06-27 12:00:00	AAPL	Stock	49.95	50.0925	49.9325	50.0275	3233380.0
2019-06-27 12:30:00	AAPL	Stock	50.03	50.1	49.975	49.9775	2107264.0
2019-06-27 13:00:00	AAPL	Stock	49.9775	50.02	49.9775	50.0125	1746548.0
2019-06-27 13:30:00	AAPL	Stock	50.0148	50.0625	49.9825	49.9975	1996188.0
2019-06-27 14:00:00	AAPL	Stock	49.99	50.035	49.9675	50.03	2246196.0
2019-06-27 14:30:00	AAPL	Stock	50.03	50.045	49.97	49.995	2088920.0
2019-06-27 15:00:00	AAPL	Stock	49.995	50.005	49.97	50.003	2175648.0
2019-06-27 15:30:00	AAPL	Stock	50.0025	50.0175	49.915	49.9325	6260116.0
2019-06-27 16:00:00	AAPL	Stock	49.935	49.9725	49.89	49.935	10813924.0
2019-06-27 16:30:00	AAPL	Stock	49.93	50.01	49.2525	49.495	789520.0
2019-06-27 17:00:00	AAPL	Stock	49.4975	49.935	49.315	49.4925	1047772.0
2019-06-27 17:30:00	AAPL	Stock	49.4925	49.6125	49.35	49.375	490076.0
2019-06-27 18:00:00	AAPL	Stock	49.44	49.5	49.3625	49.4775	214392.0
2019-06-27 18:30:00	AAPL	Stock	49.48	49.5625	49.48	49.5275	87584.0
2019-06-27 19:00:00	AAPL	Stock	49.525	49.6	49.5125	49.5775	104620.0
2019-06-27 19:30:00	AAPL	Stock	49.575	49.6625	49.575	49.6	96188.0
2019-06-27 04:30:00	MSFT	Stock	134.9	134.9	134.68	134.68	721.0
2019-06-27 05:30:00	MSFT	Stock	134.61	134.61	134.46	134.46	900.0
2019-06-27 06:00:00	MSFT	Stock	134.23	134.23	134.06	134.1	1262.0
2019-06-27 06:30:00	MSFT	Stock	134.29	134.29	134.24	134.24	1250.0
2019-06-27 07:00:00	MSFT	Stock	134.45	134.5	134.21	134.49	4012.0
2019-06-27 07:30:00	MSFT	Stock	134.27	134.33	134.15	134.33	2225.0
2019-06-27 08:00:00	MSFT	Stock	134.4	134.8	134.34	134.61	9168.0
2019-06-27 08:30:00	MSFT	Stock	134.6	134.612	134.34	134.612	7324.0
2019-06-27 09:00:00	MSFT	Stock	134.63	134.63	134.15	134.25	11301.0
2019-06-27 09:30:00	MSFT	Stock	134.25	134.71	133.51	133.989	1892369.0
2019-06-27 10:00:00	MSFT	Stock	133.99	134.34	133.805	134.29	953547.0
2019-06-27 10:30:00	MSFT	Stock	134.3	134.57	134.2	134.247	849988.0
2019-06-27 11:00:00	MSFT	Stock	134.245	134.31	133.67	133.69	1152907.0
2019-06-27 11:30:00	MSFT	Stock	133.7	133.942	133.58	133.93	889275.0
2019-06-27 12:00:00	MSFT	Stock	133.93	134.23	133.91	134.12	742347.0
2019-06-27 12:30:00	MSFT	Stock	134.13	134.23	133.94	133.99	534076.0
2019-06-27 13:00:00	MSFT	Stock	133.99	134.19	133.95	134.16	411901.0
2019-06-27 13:30:00	MSFT	Stock	134.17	134.44	134.138	134.33	564460.0

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

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