PREVIEW / stock_30min / 2019-04-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-11.parquet
  size:    1.7 MB
  rows:    82,727
  symbols: 2,625

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-04-11 04:00:00	AAPL	Stock	50.0975	50.0975	50.0975	50.0975	408.0
2019-04-11 04:30:00	AAPL	Stock	50.1225	50.125	50.1225	50.125	4012.0
2019-04-11 05:00:00	AAPL	Stock	50.125	50.15	50.125	50.15	4068.0
2019-04-11 05:30:00	AAPL	Stock	50.125	50.125	50.09	50.09	12804.0
2019-04-11 06:00:00	AAPL	Stock	50.1525	50.175	50.1525	50.175	2012.0
2019-04-11 06:30:00	AAPL	Stock	50.15	50.175	50.125	50.125	4464.0
2019-04-11 07:00:00	AAPL	Stock	50.1875	50.2875	50.155	50.25	95672.0
2019-04-11 07:30:00	AAPL	Stock	50.3	50.32	50.2375	50.25	113244.0
2019-04-11 08:00:00	AAPL	Stock	50.2242	50.32	50.1475	50.25	136744.0
2019-04-11 08:30:00	AAPL	Stock	50.2775	50.2775	50.2	50.2075	115256.0
2019-04-11 09:00:00	AAPL	Stock	50.2125	50.2875	50.165	50.195	140120.0
2019-04-11 09:30:00	AAPL	Stock	50.2125	50.25	49.94	50.12	13316096.0
2019-04-11 10:00:00	AAPL	Stock	50.125	50.23	50.0075	50.175	5916708.0
2019-04-11 10:30:00	AAPL	Stock	50.1775	50.2075	50.0975	50.12	4404916.0
2019-04-11 11:00:00	AAPL	Stock	50.1225	50.155	50.055	50.075	3267168.0
2019-04-11 11:30:00	AAPL	Stock	50.0732	50.0775	49.905	50.017	4822944.0
2019-04-11 12:00:00	AAPL	Stock	50.015	50.1015	49.9825	50.0525	2663436.0
2019-04-11 12:30:00	AAPL	Stock	50.0525	50.0775	49.9975	50.05	2201496.0
2019-04-11 13:00:00	AAPL	Stock	50.051	50.0725	49.9625	49.965	2772456.0
2019-04-11 13:30:00	AAPL	Stock	49.965	49.9775	49.7825	49.8125	4317384.0
2019-04-11 14:00:00	AAPL	Stock	49.8125	49.84	49.6875	49.7	4441248.0
2019-04-11 14:30:00	AAPL	Stock	49.7	49.825	49.6925	49.795	2991344.0
2019-04-11 15:00:00	AAPL	Stock	49.795	49.83	49.735	49.74	2856296.0
2019-04-11 15:30:00	AAPL	Stock	49.7425	49.7812	49.6108	49.735	9539000.0
2019-04-11 16:00:00	AAPL	Stock	49.7375	49.75	49.7	49.72	9179868.0
2019-04-11 16:30:00	AAPL	Stock	49.7025	49.73	49.6925	49.7	38268.0
2019-04-11 17:00:00	AAPL	Stock	49.7	49.7375	49.7	49.7375	24060.0
2019-04-11 17:30:00	AAPL	Stock	49.7125	49.7325	49.7025	49.7075	29476.0
2019-04-11 18:00:00	AAPL	Stock	49.7325	49.75	49.7075	49.75	27820.0
2019-04-11 18:30:00	AAPL	Stock	49.7375	49.7375	49.7	49.725	8552.0
2019-04-11 19:00:00	AAPL	Stock	49.7125	49.72	49.7	49.7175	10844.0
2019-04-11 19:30:00	AAPL	Stock	49.72	49.72	49.6925	49.7125	32156.0
2019-04-11 04:00:00	MSFT	Stock	120.52	120.61	120.46	120.48	700.0
2019-04-11 05:00:00	MSFT	Stock	120.57	120.57	120.57	120.57	290.0
2019-04-11 05:30:00	MSFT	Stock	120.57	120.57	120.57	120.57	100.0
2019-04-11 06:00:00	MSFT	Stock	120.57	120.62	120.57	120.62	700.0
2019-04-11 06:30:00	MSFT	Stock	120.61	120.68	120.6	120.68	1004.0
2019-04-11 07:00:00	MSFT	Stock	120.7	120.7	120.65	120.65	600.0
2019-04-11 07:30:00	MSFT	Stock	120.54	120.54	120.5	120.5	999.0
2019-04-11 08:00:00	MSFT	Stock	120.6	120.739	120.19	120.525	18136.0
2019-04-11 08:30:00	MSFT	Stock	120.53	120.53	120.39	120.4	28469.0
2019-04-11 09:00:00	MSFT	Stock	120.4	120.55	120.4	120.5	11706.0
2019-04-11 09:30:00	MSFT	Stock	120.54	120.85	119.92	120.01	2149183.0
2019-04-11 10:00:00	MSFT	Stock	120.01	120.305	119.98	120.2	1069786.0
2019-04-11 10:30:00	MSFT	Stock	120.2	120.36	120.1	120.36	680563.0
2019-04-11 11:00:00	MSFT	Stock	120.36	120.47	120.27	120.38	620433.0
2019-04-11 11:30:00	MSFT	Stock	120.38	120.385	120.05	120.095	813678.0
2019-04-11 12:00:00	MSFT	Stock	120.1	120.25	120.07	120.245	643004.0
2019-04-11 12:30:00	MSFT	Stock	120.245	120.35	120.22	120.29	422440.0
2019-04-11 13:00:00	MSFT	Stock	120.286	120.35	120.23	120.25	426978.0

> showing 50 of 82,727 rows — these rows as CSV

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