PREVIEW / stock_30min / 2019-07-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-10.parquet
  size:    1.7 MB
  rows:    86,481
  symbols: 2,594

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-07-10 04:30:00	AAPL	Stock	50.145	50.145	50.125	50.125	1200.0
2019-07-10 05:00:00	AAPL	Stock	50.185	50.215	50.185	50.215	14456.0
2019-07-10 05:30:00	AAPL	Stock	50.3275	50.3275	50.185	50.185	9200.0
2019-07-10 06:00:00	AAPL	Stock	50.1275	50.145	50.1275	50.145	820.0
2019-07-10 06:30:00	AAPL	Stock	50.0825	50.1025	50.0825	50.1025	1004.0
2019-07-10 07:00:00	AAPL	Stock	50.1675	50.22	50.125	50.125	19000.0
2019-07-10 07:30:00	AAPL	Stock	50.1625	50.1625	50.0625	50.1525	34956.0
2019-07-10 08:00:00	AAPL	Stock	50.1925	50.435	50.0925	50.195	56764.0
2019-07-10 08:30:00	AAPL	Stock	50.205	50.575	50.205	50.498	495608.0
2019-07-10 09:00:00	AAPL	Stock	50.4875	50.5725	50.4425	50.4925	335464.0
2019-07-10 09:30:00	AAPL	Stock	50.475	50.9325	50.39	50.873	11963492.0
2019-07-10 10:00:00	AAPL	Stock	50.875	50.8975	50.7075	50.71	5067476.0
2019-07-10 10:30:00	AAPL	Stock	50.715	50.86	50.63	50.645	4435876.0
2019-07-10 11:00:00	AAPL	Stock	50.6438	50.715	50.5425	50.565	3661980.0
2019-07-10 11:30:00	AAPL	Stock	50.5675	50.8475	50.5612	50.825	3627620.0
2019-07-10 12:00:00	AAPL	Stock	50.83	50.87	50.715	50.755	2512132.0
2019-07-10 12:30:00	AAPL	Stock	50.7548	50.8325	50.74	50.7975	2214664.0
2019-07-10 13:00:00	AAPL	Stock	50.7988	50.8625	50.7725	50.8485	1730320.0
2019-07-10 13:30:00	AAPL	Stock	50.8475	50.895	50.8252	50.835	2243080.0
2019-07-10 14:00:00	AAPL	Stock	50.84	50.895	50.6775	50.725	3257416.0
2019-07-10 14:30:00	AAPL	Stock	50.725	50.8225	50.7138	50.8025	2299092.0
2019-07-10 15:00:00	AAPL	Stock	50.805	50.865	50.75	50.8585	2906508.0
2019-07-10 15:30:00	AAPL	Stock	50.8575	50.8875	50.7575	50.8025	6721680.0
2019-07-10 16:00:00	AAPL	Stock	50.8075	50.82	50.8	50.81	6601960.0
2019-07-10 16:30:00	AAPL	Stock	50.8122	50.825	50.8075	50.825	38744.0
2019-07-10 17:00:00	AAPL	Stock	50.82	50.825	50.8075	50.825	21708.0
2019-07-10 17:30:00	AAPL	Stock	50.825	50.825	50.805	50.805	4940.0
2019-07-10 18:00:00	AAPL	Stock	50.8425	50.8425	50.82	50.8325	11224.0
2019-07-10 18:30:00	AAPL	Stock	50.8075	50.85	50.8075	50.85	25392.0
2019-07-10 19:30:00	AAPL	Stock	50.8375	50.855	50.8275	50.8275	11532.0
2019-07-10 04:30:00	MSFT	Stock	136.3	136.3	136.3	136.3	400.0
2019-07-10 05:00:00	MSFT	Stock	136.4	136.6	136.4	136.6	500.0
2019-07-10 05:30:00	MSFT	Stock	136.11	136.11	135.8	135.8	2120.0
2019-07-10 06:30:00	MSFT	Stock	135.7	135.75	135.7	135.75	680.0
2019-07-10 07:00:00	MSFT	Stock	136.2	136.2	136.06	136.1	8197.0
2019-07-10 07:30:00	MSFT	Stock	136.1	136.27	135.85	136.05	12129.0
2019-07-10 08:00:00	MSFT	Stock	136.1	136.8	135.96	136.15	14870.0
2019-07-10 08:30:00	MSFT	Stock	136.23	137.5	136.23	137.125	78217.0
2019-07-10 09:00:00	MSFT	Stock	137.25	137.35	137.12	137.225	19613.0
2019-07-10 09:30:00	MSFT	Stock	137.21	138.37	137.02	138.23	2943355.0
2019-07-10 10:00:00	MSFT	Stock	138.23	138.58	138.03	138.22	2015950.0
2019-07-10 10:30:00	MSFT	Stock	138.23	138.38	137.55	137.575	1304126.0
2019-07-10 11:00:00	MSFT	Stock	137.575	137.76	137.27	137.53	1165913.0
2019-07-10 11:30:00	MSFT	Stock	137.52	137.9	137.48	137.843	771721.0
2019-07-10 12:00:00	MSFT	Stock	137.85	137.875	137.43	137.48	802263.0
2019-07-10 12:30:00	MSFT	Stock	137.48	137.6	137.3	137.47	586098.0
2019-07-10 13:00:00	MSFT	Stock	137.48	137.72	137.47	137.64	553380.0
2019-07-10 13:30:00	MSFT	Stock	137.64	137.95	137.63	137.77	703522.0
2019-07-10 14:00:00	MSFT	Stock	137.77	137.9	137.34	137.39	838507.0
2019-07-10 14:30:00	MSFT	Stock	137.386	137.46	137.11	137.35	739547.0

> showing 50 of 86,481 rows — these rows as CSV

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