PREVIEW / stock_30min / 2020-01-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-28.parquet
  size:    1.8 MB
  rows:    85,768
  symbols: 2,430

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
2020-01-28 04:00:00	AAPL	Stock	77.8375	77.9225	77.515	77.74	30736.0
2020-01-28 04:30:00	AAPL	Stock	77.73	77.925	77.73	77.8	23776.0
2020-01-28 05:00:00	AAPL	Stock	77.895	77.9275	77.8625	77.92	13920.0
2020-01-28 05:30:00	AAPL	Stock	77.87	77.9125	77.87	77.875	7884.0
2020-01-28 06:00:00	AAPL	Stock	77.8275	77.8275	77.6375	77.7875	8272.0
2020-01-28 06:30:00	AAPL	Stock	77.775	77.9725	77.745	77.9725	30048.0
2020-01-28 07:00:00	AAPL	Stock	77.9575	78.1375	77.805	78.1375	294340.0
2020-01-28 07:30:00	AAPL	Stock	78.125	78.225	78.0275	78.0675	253064.0
2020-01-28 08:00:00	AAPL	Stock	77.975	78.225	77.8	78.1875	627200.0
2020-01-28 08:30:00	AAPL	Stock	78.1575	78.2375	78.0775	78.1002	329592.0
2020-01-28 09:00:00	AAPL	Stock	78.125	78.2092	78.0525	78.12	277988.0
2020-01-28 09:30:00	AAPL	Stock	78.095	78.5075	78.0475	78.2425	16564124.0
2020-01-28 10:00:00	AAPL	Stock	78.25	78.425	78.105	78.3925	8508940.0
2020-01-28 10:30:00	AAPL	Stock	78.398	78.96	78.395	78.9538	11421792.0
2020-01-28 11:00:00	AAPL	Stock	78.954	79.055	78.75	78.9915	8265196.0
2020-01-28 11:30:00	AAPL	Stock	78.9912	79.1925	78.9025	79.133	5474564.0
2020-01-28 12:00:00	AAPL	Stock	79.14	79.235	79.0825	79.2018	4727352.0
2020-01-28 12:30:00	AAPL	Stock	79.2	79.2925	79.0025	79.175	5479976.0
2020-01-28 13:00:00	AAPL	Stock	79.1775	79.1875	79.0275	79.1425	4067956.0
2020-01-28 13:30:00	AAPL	Stock	79.1475	79.235	79.0325	79.21	3697052.0
2020-01-28 14:00:00	AAPL	Stock	79.21	79.4175	79.2025	79.28	5464692.0
2020-01-28 14:30:00	AAPL	Stock	79.2792	79.5925	79.255	79.5875	6010428.0
2020-01-28 15:00:00	AAPL	Stock	79.58	79.6	79.41	79.5	7307368.0
2020-01-28 15:30:00	AAPL	Stock	79.5	79.515	79.2275	79.44	15819692.0
2020-01-28 16:00:00	AAPL	Stock	79.4225	79.805	79.365	79.6	11293068.0
2020-01-28 16:30:00	AAPL	Stock	79.6125	81.975	79.6125	80.4	12385416.0
2020-01-28 17:00:00	AAPL	Stock	80.4175	81.2025	79.4225	80.82	6289016.0
2020-01-28 17:30:00	AAPL	Stock	80.7625	80.95	80.4175	80.58	719000.0
2020-01-28 18:00:00	AAPL	Stock	80.58	80.72	80.2675	80.375	718500.0
2020-01-28 18:30:00	AAPL	Stock	80.2775	80.6225	80.2775	80.45	272464.0
2020-01-28 19:00:00	AAPL	Stock	80.45	80.51	80.4025	80.435	177660.0
2020-01-28 19:30:00	AAPL	Stock	80.425	80.6475	80.4	80.625	287152.0
2020-01-28 04:00:00	MSFT	Stock	163.01	163.04	162.76	162.88	1355.0
2020-01-28 04:30:00	MSFT	Stock	162.78	162.78	162.78	162.78	112.0
2020-01-28 05:00:00	MSFT	Stock	162.94	163.25	162.83	163.0	5066.0
2020-01-28 05:30:00	MSFT	Stock	163.0	163.01	162.99	162.99	581.0
2020-01-28 06:00:00	MSFT	Stock	162.99	162.99	162.7	162.7	2715.0
2020-01-28 06:30:00	MSFT	Stock	162.94	163.25	162.94	163.25	1384.0
2020-01-28 07:00:00	MSFT	Stock	163.27	163.87	163.27	163.67	12164.0
2020-01-28 07:30:00	MSFT	Stock	163.8	164.06	163.75	163.85	35744.0
2020-01-28 08:00:00	MSFT	Stock	163.4	164.13	163.27	164.0	43382.0
2020-01-28 08:30:00	MSFT	Stock	164.0	164.21	163.81	163.81	18194.0
2020-01-28 09:00:00	MSFT	Stock	164.0	164.1	163.7	163.78	28475.0
2020-01-28 09:30:00	MSFT	Stock	163.78	164.14	163.073	163.89	2510182.0
2020-01-28 10:00:00	MSFT	Stock	163.9	164.97	163.88	164.81	1723304.0
2020-01-28 10:30:00	MSFT	Stock	164.82	165.28	164.73	165.04	1269574.0
2020-01-28 11:00:00	MSFT	Stock	165.04	165.43	164.76	165.39	1213926.0
2020-01-28 11:30:00	MSFT	Stock	165.4	165.595	165.16	165.4	791188.0
2020-01-28 12:00:00	MSFT	Stock	165.4	165.59	165.26	165.409	771655.0
2020-01-28 12:30:00	MSFT	Stock	165.41	165.54	165.13	165.29	571770.0

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

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