PREVIEW / stock_30min / 2019-07-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-12.parquet
  size:    1.7 MB
  rows:    83,655
  symbols: 2,577

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-12 04:00:00	AAPL	Stock	50.54	50.59	50.54	50.59	1996.0
2019-07-12 04:30:00	AAPL	Stock	50.6	50.6	50.6	50.6	400.0
2019-07-12 05:00:00	AAPL	Stock	50.55	50.5925	50.55	50.55	6280.0
2019-07-12 05:30:00	AAPL	Stock	50.54	50.5675	50.5375	50.5675	5760.0
2019-07-12 06:00:00	AAPL	Stock	50.6	50.6875	50.5975	50.6875	15972.0
2019-07-12 06:30:00	AAPL	Stock	50.65	50.675	50.525	50.55	10116.0
2019-07-12 07:00:00	AAPL	Stock	50.54	50.595	50.53	50.58	61248.0
2019-07-12 07:30:00	AAPL	Stock	50.5575	50.62	50.5325	50.595	44172.0
2019-07-12 08:00:00	AAPL	Stock	50.5918	50.6225	50.5625	50.6	96640.0
2019-07-12 08:30:00	AAPL	Stock	50.57	50.601	50.5375	50.5575	51652.0
2019-07-12 09:00:00	AAPL	Stock	50.5575	50.6325	50.4925	50.6325	80472.0
2019-07-12 09:30:00	AAPL	Stock	50.6325	50.9875	50.55	50.9025	11581088.0
2019-07-12 10:00:00	AAPL	Stock	50.91	50.9875	50.855	50.9348	4390048.0
2019-07-12 10:30:00	AAPL	Stock	50.9338	50.9825	50.8325	50.93	3554184.0
2019-07-12 11:00:00	AAPL	Stock	50.9325	50.9875	50.9	50.9738	2564172.0
2019-07-12 11:30:00	AAPL	Stock	50.975	51.0	50.945	50.9762	2768324.0
2019-07-12 12:00:00	AAPL	Stock	50.975	50.9888	50.91	50.916	2783584.0
2019-07-12 12:30:00	AAPL	Stock	50.9172	50.96	50.885	50.9475	2217072.0
2019-07-12 13:00:00	AAPL	Stock	50.945	50.9575	50.8225	50.88	2381780.0
2019-07-12 13:30:00	AAPL	Stock	50.8787	50.8787	50.7012	50.775	4170764.0
2019-07-12 14:00:00	AAPL	Stock	50.7775	50.8575	50.775	50.825	3193644.0
2019-07-12 14:30:00	AAPL	Stock	50.8275	50.8575	50.7875	50.819	2767464.0
2019-07-12 15:00:00	AAPL	Stock	50.815	50.8225	50.78	50.81	2255076.0
2019-07-12 15:30:00	AAPL	Stock	50.81	50.8675	50.7725	50.81	8016460.0
2019-07-12 16:00:00	AAPL	Stock	50.825	50.9625	50.8	50.815	6294732.0
2019-07-12 16:30:00	AAPL	Stock	50.8125	50.825	50.8025	50.8225	53660.0
2019-07-12 17:00:00	AAPL	Stock	50.825	50.825	50.8125	50.8125	22140.0
2019-07-12 17:30:00	AAPL	Stock	50.8125	50.8175	50.8075	50.8125	4128.0
2019-07-12 18:00:00	AAPL	Stock	50.825	50.825	50.815	50.825	2640.0
2019-07-12 18:30:00	AAPL	Stock	50.82	50.825	50.815	50.825	5168.0
2019-07-12 19:00:00	AAPL	Stock	50.825	50.825	50.8125	50.815	6692.0
2019-07-12 19:30:00	AAPL	Stock	50.825	50.825	50.825	50.825	3060.0
2019-07-12 04:30:00	MSFT	Stock	139.0	139.0	139.0	139.0	100.0
2019-07-12 05:30:00	MSFT	Stock	138.98	139.04	138.98	139.04	900.0
2019-07-12 06:00:00	MSFT	Stock	139.1	139.1	139.1	139.1	600.0
2019-07-12 06:30:00	MSFT	Stock	139.03	139.1	139.0	139.0	1720.0
2019-07-12 07:00:00	MSFT	Stock	138.84	139.03	138.83	138.83	19911.0
2019-07-12 07:30:00	MSFT	Stock	138.83	138.9	138.8	138.86	3000.0
2019-07-12 08:00:00	MSFT	Stock	138.9	139.06	138.74	138.95	19296.0
2019-07-12 08:30:00	MSFT	Stock	138.95	138.95	138.81	138.88	11815.0
2019-07-12 09:00:00	MSFT	Stock	138.82	138.92	138.69	138.86	25473.0
2019-07-12 09:30:00	MSFT	Stock	138.86	139.13	138.7	138.93	2192143.0
2019-07-12 10:00:00	MSFT	Stock	138.94	139.11	138.29	138.37	1430249.0
2019-07-12 10:30:00	MSFT	Stock	138.38	138.44	138.01	138.391	1302290.0
2019-07-12 11:00:00	MSFT	Stock	138.395	138.815	138.33	138.745	900847.0
2019-07-12 11:30:00	MSFT	Stock	138.745	138.78	138.61	138.76	652161.0
2019-07-12 12:00:00	MSFT	Stock	138.765	138.87	138.73	138.745	754699.0
2019-07-12 12:30:00	MSFT	Stock	138.74	138.835	138.65	138.79	614897.0
2019-07-12 13:00:00	MSFT	Stock	138.79	138.826	138.651	138.77	423459.0
2019-07-12 13:30:00	MSFT	Stock	138.78	138.78	138.63	138.7	470430.0

> showing 50 of 83,655 rows — these rows as CSV

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