PREVIEW / stock_30min / 2019-04-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-03.parquet
  size:    1.7 MB
  rows:    85,441
  symbols: 2,630

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-03 04:00:00	AAPL	Stock	48.6775	48.7975	48.675	48.675	12660.0
2019-04-03 04:30:00	AAPL	Stock	48.73	48.735	48.7275	48.7275	3400.0
2019-04-03 05:00:00	AAPL	Stock	48.7175	48.735	48.6775	48.6775	9300.0
2019-04-03 05:30:00	AAPL	Stock	48.6725	48.725	48.665	48.725	33288.0
2019-04-03 06:00:00	AAPL	Stock	48.7125	48.7125	48.56	48.595	26400.0
2019-04-03 06:30:00	AAPL	Stock	48.5675	48.5675	48.475	48.55	29528.0
2019-04-03 07:00:00	AAPL	Stock	48.555	48.595	48.4875	48.5225	114588.0
2019-04-03 07:30:00	AAPL	Stock	48.5025	48.56	48.4125	48.42	121152.0
2019-04-03 08:00:00	AAPL	Stock	48.56	48.595	48.2225	48.305	487420.0
2019-04-03 08:30:00	AAPL	Stock	48.3125	48.3575	48.2525	48.29	143940.0
2019-04-03 09:00:00	AAPL	Stock	48.3125	48.4	48.2875	48.3125	300572.0
2019-04-03 09:30:00	AAPL	Stock	48.3125	48.7975	48.2875	48.7125	14630440.0
2019-04-03 10:00:00	AAPL	Stock	48.7075	49.0	48.6225	48.975	8937240.0
2019-04-03 10:30:00	AAPL	Stock	48.975	49.0188	48.8775	49.0025	5970512.0
2019-04-03 11:00:00	AAPL	Stock	49.005	49.125	48.945	48.9825	6687136.0
2019-04-03 11:30:00	AAPL	Stock	48.9825	49.095	48.9475	49.0725	3793960.0
2019-04-03 12:00:00	AAPL	Stock	49.073	49.1125	48.9975	49.025	3044676.0
2019-04-03 12:30:00	AAPL	Stock	49.025	49.0275	48.89	48.895	2765172.0
2019-04-03 13:00:00	AAPL	Stock	48.8925	48.97	48.889	48.93	2412092.0
2019-04-03 13:30:00	AAPL	Stock	48.9258	48.9425	48.685	48.7375	4602024.0
2019-04-03 14:00:00	AAPL	Stock	48.735	48.87	48.6625	48.8338	3485900.0
2019-04-03 14:30:00	AAPL	Stock	48.8335	48.8635	48.7025	48.72	2935024.0
2019-04-03 15:00:00	AAPL	Stock	48.7225	48.8092	48.59	48.74	5058544.0
2019-04-03 15:30:00	AAPL	Stock	48.7425	48.865	48.6825	48.8375	6968664.0
2019-04-03 16:00:00	AAPL	Stock	48.8375	48.8625	48.77	48.84	9857672.0
2019-04-03 16:30:00	AAPL	Stock	48.8425	48.8625	48.7725	48.8375	29952.0
2019-04-03 17:00:00	AAPL	Stock	48.85	48.875	48.85	48.8625	1736.0
2019-04-03 17:30:00	AAPL	Stock	48.8625	48.8875	48.85	48.85	20284.0
2019-04-03 18:00:00	AAPL	Stock	48.85	48.895	48.85	48.85	46504.0
2019-04-03 18:30:00	AAPL	Stock	48.8525	48.8675	48.8525	48.8675	5556.0
2019-04-03 19:00:00	AAPL	Stock	48.875	48.875	48.8625	48.8625	5240.0
2019-04-03 19:30:00	AAPL	Stock	48.8625	48.895	48.8625	48.895	20684.0
2019-04-03 04:00:00	MSFT	Stock	119.6	119.94	119.6	119.94	1295.0
2019-04-03 05:00:00	MSFT	Stock	119.81	119.88	119.81	119.88	250.0
2019-04-03 05:30:00	MSFT	Stock	119.88	119.89	119.86	119.88	1979.0
2019-04-03 06:30:00	MSFT	Stock	119.87	119.87	119.7	119.7	2191.0
2019-04-03 07:00:00	MSFT	Stock	119.7	119.8	119.66	119.74	11954.0
2019-04-03 07:30:00	MSFT	Stock	119.66	119.7	119.6	119.7	9875.0
2019-04-03 08:00:00	MSFT	Stock	119.8	119.9	119.6	119.7	28193.0
2019-04-03 08:30:00	MSFT	Stock	119.68	119.79	119.6	119.65	7939.0
2019-04-03 09:00:00	MSFT	Stock	119.73	120.01	119.63	119.99	18736.0
2019-04-03 09:30:00	MSFT	Stock	119.99	120.0	119.23	119.49	2810516.0
2019-04-03 10:00:00	MSFT	Stock	119.49	119.72	119.15	119.653	1236048.0
2019-04-03 10:30:00	MSFT	Stock	119.65	119.86	119.54	119.85	1153642.0
2019-04-03 11:00:00	MSFT	Stock	119.85	120.245	119.85	120.2	1769069.0
2019-04-03 11:30:00	MSFT	Stock	120.2	120.43	120.13	120.21	1174442.0
2019-04-03 12:00:00	MSFT	Stock	120.21	120.296	120.1	120.183	686323.0
2019-04-03 12:30:00	MSFT	Stock	120.185	120.23	120.05	120.195	671219.0
2019-04-03 13:00:00	MSFT	Stock	120.195	120.23	120.04	120.135	579689.0
2019-04-03 13:30:00	MSFT	Stock	120.135	120.14	119.63	119.67	928849.0

> showing 50 of 85,441 rows — these rows as CSV

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