PREVIEW / stock_30min / 2018-05-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-29.parquet
  size:    1.7 MB
  rows:    84,553
  symbols: 2,833

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-05-29 04:00:00	AAPL	Stock	47.0775	47.0775	46.95	46.95	16324.0
2018-05-29 04:30:00	AAPL	Stock	46.8125	46.8125	46.6875	46.725	15460.0
2018-05-29 05:00:00	AAPL	Stock	46.695	46.7375	46.675	46.7275	10244.0
2018-05-29 05:30:00	AAPL	Stock	46.7625	46.7625	46.7625	46.7625	524.0
2018-05-29 06:30:00	AAPL	Stock	46.7875	46.875	46.7875	46.875	800.0
2018-05-29 07:00:00	AAPL	Stock	46.8375	46.9125	46.75	46.825	153860.0
2018-05-29 07:30:00	AAPL	Stock	46.825	46.9125	46.825	46.9	36296.0
2018-05-29 08:00:00	AAPL	Stock	46.755	47.0	46.755	47.0	298832.0
2018-05-29 08:30:00	AAPL	Stock	47.0	47.0125	46.9625	46.975	99184.0
2018-05-29 09:00:00	AAPL	Stock	46.9625	46.9925	46.89	46.8975	116812.0
2018-05-29 09:30:00	AAPL	Stock	46.9	47.1075	46.7175	47.0875	11004020.0
2018-05-29 10:00:00	AAPL	Stock	47.0875	47.1875	47.01	47.05	6600548.0
2018-05-29 10:30:00	AAPL	Stock	47.05	47.155	46.9575	47.035	5189364.0
2018-05-29 11:00:00	AAPL	Stock	47.035	47.045	46.9325	46.9625	4796688.0
2018-05-29 11:30:00	AAPL	Stock	46.96	46.9675	46.7575	46.8075	4835540.0
2018-05-29 12:00:00	AAPL	Stock	46.805	46.85	46.735	46.8025	4623116.0
2018-05-29 12:30:00	AAPL	Stock	46.8025	46.95	46.7942	46.915	3745796.0
2018-05-29 13:00:00	AAPL	Stock	46.9125	46.915	46.785	46.83	2955016.0
2018-05-29 13:30:00	AAPL	Stock	46.8325	46.9125	46.7725	46.825	3102276.0
2018-05-29 14:00:00	AAPL	Stock	46.825	46.89	46.75	46.8815	3497440.0
2018-05-29 14:30:00	AAPL	Stock	46.8825	46.96	46.7725	46.785	4377144.0
2018-05-29 15:00:00	AAPL	Stock	46.785	46.85	46.7525	46.8165	4304408.0
2018-05-29 15:30:00	AAPL	Stock	46.8162	47.0375	46.7925	46.965	9215704.0
2018-05-29 16:00:00	AAPL	Stock	46.975	47.0	46.8675	47.0	11444260.0
2018-05-29 16:30:00	AAPL	Stock	47.0	47.0175	46.7015	47.0075	108280.0
2018-05-29 17:00:00	AAPL	Stock	47.01	47.0225	47.0025	47.0025	9952.0
2018-05-29 17:30:00	AAPL	Stock	47.0175	47.0225	47.0025	47.0175	12460.0
2018-05-29 18:00:00	AAPL	Stock	47.0125	47.0175	47.005	47.0075	10552.0
2018-05-29 18:30:00	AAPL	Stock	47.005	47.0175	46.9925	46.9925	4320.0
2018-05-29 19:00:00	AAPL	Stock	46.9825	46.9825	46.975	46.98	8784.0
2018-05-29 19:30:00	AAPL	Stock	46.975	46.975	46.925	46.925	14712.0
2018-05-29 04:00:00	MSFT	Stock	97.99	98.0	97.7	97.7	974.0
2018-05-29 04:30:00	MSFT	Stock	97.6	97.6	97.6	97.6	162.0
2018-05-29 05:00:00	MSFT	Stock	97.47	97.47	97.47	97.47	100.0
2018-05-29 05:30:00	MSFT	Stock	97.73	97.76	97.71	97.76	426.0
2018-05-29 06:00:00	MSFT	Stock	97.77	97.77	97.77	97.77	100.0
2018-05-29 06:30:00	MSFT	Stock	97.8	97.8	97.8	97.8	500.0
2018-05-29 07:00:00	MSFT	Stock	97.84	97.84	97.73	97.73	917.0
2018-05-29 07:30:00	MSFT	Stock	97.8	97.8	97.75	97.75	1819.0
2018-05-29 08:00:00	MSFT	Stock	97.72	97.9	97.56	97.9	6488.0
2018-05-29 08:30:00	MSFT	Stock	98.01	98.06	97.82	98.03	7374.0
2018-05-29 09:00:00	MSFT	Stock	98.03	98.04	97.75	97.81	13101.0
2018-05-29 09:30:00	MSFT	Stock	97.84	98.45	97.38	98.32	2498713.0
2018-05-29 10:00:00	MSFT	Stock	98.31	98.877	98.26	98.55	1628911.0
2018-05-29 10:30:00	MSFT	Stock	98.55	98.88	98.22	98.25	1856683.0
2018-05-29 11:00:00	MSFT	Stock	98.25	98.48	98.12	98.34	1920721.0
2018-05-29 11:30:00	MSFT	Stock	98.34	98.41	97.53	97.54	1536231.0
2018-05-29 12:00:00	MSFT	Stock	97.545	97.624	97.23	97.53	1555196.0
2018-05-29 12:30:00	MSFT	Stock	97.53	97.955	97.5	97.9	1127044.0
2018-05-29 13:00:00	MSFT	Stock	97.9	97.92	97.5	97.84	881463.0

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

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