PREVIEW / stock_30min / 2018-11-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-07.parquet
  size:    1.7 MB
  rows:    84,796
  symbols: 2,750

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-11-07 04:00:00	AAPL	Stock	51.58	51.75	51.5525	51.72	46072.0
2018-11-07 04:30:00	AAPL	Stock	51.72	51.8	51.675	51.75	56648.0
2018-11-07 05:00:00	AAPL	Stock	51.7525	51.7525	51.655	51.675	8260.0
2018-11-07 05:30:00	AAPL	Stock	51.655	51.675	51.625	51.6625	28720.0
2018-11-07 06:00:00	AAPL	Stock	51.6625	51.6625	51.5	51.59	45908.0
2018-11-07 06:30:00	AAPL	Stock	51.59	51.63	51.5	51.525	60496.0
2018-11-07 07:00:00	AAPL	Stock	51.5	51.635	51.4775	51.6175	266552.0
2018-11-07 07:30:00	AAPL	Stock	51.62	51.6725	51.45	51.4725	360220.0
2018-11-07 08:00:00	AAPL	Stock	51.5475	51.6625	51.3125	51.5175	683168.0
2018-11-07 08:30:00	AAPL	Stock	51.5225	51.525	51.355	51.4075	285844.0
2018-11-07 09:00:00	AAPL	Stock	51.3925	51.5	51.3275	51.4625	571184.0
2018-11-07 09:30:00	AAPL	Stock	51.4725	51.5475	51.0325	51.2075	17293624.0
2018-11-07 10:00:00	AAPL	Stock	51.2075	51.4825	51.15	51.3505	9412272.0
2018-11-07 10:30:00	AAPL	Stock	51.3575	51.615	51.2925	51.535	9990344.0
2018-11-07 11:00:00	AAPL	Stock	51.5425	51.66	51.4475	51.61	6555652.0
2018-11-07 11:30:00	AAPL	Stock	51.6075	51.885	51.6	51.8638	7275216.0
2018-11-07 12:00:00	AAPL	Stock	51.87	51.9075	51.775	51.83	6085616.0
2018-11-07 12:30:00	AAPL	Stock	51.83	51.975	51.82	51.9125	4366352.0
2018-11-07 13:00:00	AAPL	Stock	51.92	51.9625	51.815	51.933	4046816.0
2018-11-07 13:30:00	AAPL	Stock	51.9325	51.99	51.815	51.8725	4226608.0
2018-11-07 14:00:00	AAPL	Stock	51.8775	51.9425	51.835	51.905	4370740.0
2018-11-07 14:30:00	AAPL	Stock	51.9	52.0475	51.8875	51.9875	5555168.0
2018-11-07 15:00:00	AAPL	Stock	51.9903	52.14	51.97	52.13	6035432.0
2018-11-07 15:30:00	AAPL	Stock	52.13	52.515	52.1225	52.49	16343576.0
2018-11-07 16:00:00	AAPL	Stock	52.4875	52.4925	52.4275	52.47	11541820.0
2018-11-07 16:30:00	AAPL	Stock	52.4725	52.4875	52.4075	52.4102	309688.0
2018-11-07 17:00:00	AAPL	Stock	52.415	52.4875	52.375	52.4	99104.0
2018-11-07 17:30:00	AAPL	Stock	52.4	52.48	52.3925	52.46	60028.0
2018-11-07 18:00:00	AAPL	Stock	52.4475	52.585	52.4375	52.5125	212356.0
2018-11-07 18:30:00	AAPL	Stock	52.53	52.5625	52.5	52.5075	71552.0
2018-11-07 19:00:00	AAPL	Stock	52.525	52.56	52.5175	52.54	31880.0
2018-11-07 19:30:00	AAPL	Stock	52.55	52.6125	52.55	52.5625	84624.0
2018-11-07 04:00:00	MSFT	Stock	109.0	109.0	109.0	109.0	300.0
2018-11-07 04:30:00	MSFT	Stock	109.3	109.3	109.3	109.3	100.0
2018-11-07 05:30:00	MSFT	Stock	109.15	109.29	109.15	109.2	1399.0
2018-11-07 06:00:00	MSFT	Stock	109.14	109.14	109.08	109.09	7211.0
2018-11-07 06:30:00	MSFT	Stock	109.1	109.19	109.0	109.14	6665.0
2018-11-07 07:00:00	MSFT	Stock	109.14	109.48	108.8	109.3	17127.0
2018-11-07 07:30:00	MSFT	Stock	109.34	109.46	108.95	109.03	15419.0
2018-11-07 08:00:00	MSFT	Stock	109.1	109.48	108.8	109.18	32633.0
2018-11-07 08:30:00	MSFT	Stock	109.19	109.23	108.86	108.86	26791.0
2018-11-07 09:00:00	MSFT	Stock	108.83	109.4	108.31	109.4	64154.0
2018-11-07 09:30:00	MSFT	Stock	109.44	110.75	109.4	110.38	5622446.0
2018-11-07 10:00:00	MSFT	Stock	110.38	111.34	110.32	111.245	3537334.0
2018-11-07 10:30:00	MSFT	Stock	111.24	112.02	111.23	111.73	2899280.0
2018-11-07 11:00:00	MSFT	Stock	111.74	112.015	111.23	111.46	2214426.0
2018-11-07 11:30:00	MSFT	Stock	111.455	111.95	111.36	111.9	1620360.0
2018-11-07 12:00:00	MSFT	Stock	111.91	111.985	111.72	111.77	1118414.0
2018-11-07 12:30:00	MSFT	Stock	111.78	111.98	111.724	111.83	1053163.0
2018-11-07 13:00:00	MSFT	Stock	111.83	111.98	111.72	111.92	979496.0

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

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