PREVIEW / stock_30min / 2018-09-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-14.parquet
  size:    1.7 MB
  rows:    85,133
  symbols: 2,782

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-09-14 04:00:00	AAPL	Stock	56.7625	56.9425	56.7625	56.9425	14788.0
2018-09-14 04:30:00	AAPL	Stock	56.965	56.975	56.8375	56.8375	8188.0
2018-09-14 05:00:00	AAPL	Stock	56.9375	56.975	56.9375	56.9625	1400.0
2018-09-14 05:30:00	AAPL	Stock	56.95	56.95	56.9475	56.9475	1600.0
2018-09-14 06:00:00	AAPL	Stock	56.915	56.915	56.8625	56.8625	12420.0
2018-09-14 06:30:00	AAPL	Stock	56.825	56.8625	56.75	56.82	26424.0
2018-09-14 07:00:00	AAPL	Stock	56.825	56.8325	56.765	56.8175	64296.0
2018-09-14 07:30:00	AAPL	Stock	56.8075	56.85	56.7925	56.8425	127756.0
2018-09-14 08:00:00	AAPL	Stock	56.8125	56.845	56.75	56.75	301604.0
2018-09-14 08:30:00	AAPL	Stock	56.7625	56.775	56.315	56.4225	650248.0
2018-09-14 09:00:00	AAPL	Stock	56.4225	56.5875	56.075	56.4375	946092.0
2018-09-14 09:30:00	AAPL	Stock	56.4375	56.71	56.0175	56.46	18984316.0
2018-09-14 10:00:00	AAPL	Stock	56.46	56.4875	56.195	56.4675	9131136.0
2018-09-14 10:30:00	AAPL	Stock	56.4675	56.56	56.22	56.2625	6656808.0
2018-09-14 11:00:00	AAPL	Stock	56.2675	56.365	56.1025	56.185	7193896.0
2018-09-14 11:30:00	AAPL	Stock	56.19	56.2335	56.0625	56.125	4926056.0
2018-09-14 12:00:00	AAPL	Stock	56.125	56.15	55.6305	55.7175	13050188.0
2018-09-14 12:30:00	AAPL	Stock	55.7175	55.9125	55.675	55.8478	5116968.0
2018-09-14 13:00:00	AAPL	Stock	55.8475	56.0248	55.695	56.005	4566160.0
2018-09-14 13:30:00	AAPL	Stock	56.0068	56.0775	55.9275	56.0215	3585936.0
2018-09-14 14:00:00	AAPL	Stock	56.0225	56.0375	55.8175	55.9225	4286860.0
2018-09-14 14:30:00	AAPL	Stock	55.9225	55.9775	55.8625	55.9575	2967448.0
2018-09-14 15:00:00	AAPL	Stock	55.9575	56.0	55.8325	55.8825	4145460.0
2018-09-14 15:30:00	AAPL	Stock	55.885	56.0175	55.875	55.91	9605300.0
2018-09-14 16:00:00	AAPL	Stock	55.905	55.9875	55.8775	55.925	9274708.0
2018-09-14 16:30:00	AAPL	Stock	55.9175	56.0	55.9175	55.955	133452.0
2018-09-14 17:00:00	AAPL	Stock	55.945	55.955	55.9275	55.95	36212.0
2018-09-14 17:30:00	AAPL	Stock	55.96	55.9625	55.925	55.925	59960.0
2018-09-14 18:00:00	AAPL	Stock	55.905	55.905	55.8375	55.875	41740.0
2018-09-14 18:30:00	AAPL	Stock	55.875	55.875	55.8375	55.8625	18556.0
2018-09-14 19:00:00	AAPL	Stock	55.875	55.8875	55.8525	55.875	15932.0
2018-09-14 19:30:00	AAPL	Stock	55.875	55.875	55.845	55.8625	19936.0
2018-09-14 04:00:00	MSFT	Stock	113.25	113.25	113.2	113.24	390.0
2018-09-14 04:30:00	MSFT	Stock	113.25	113.25	113.25	113.25	1548.0
2018-09-14 05:30:00	MSFT	Stock	113.25	113.29	113.25	113.29	600.0
2018-09-14 06:00:00	MSFT	Stock	113.29	113.29	113.29	113.29	100.0
2018-09-14 07:00:00	MSFT	Stock	113.25	113.38	113.11	113.38	4908.0
2018-09-14 07:30:00	MSFT	Stock	113.3	113.3	113.28	113.28	258.0
2018-09-14 08:00:00	MSFT	Stock	113.28	113.37	113.13	113.13	17876.0
2018-09-14 08:30:00	MSFT	Stock	113.13	113.23	113.03	113.17	5598.0
2018-09-14 09:00:00	MSFT	Stock	113.1	113.37	113.05	113.37	6405.0
2018-09-14 09:30:00	MSFT	Stock	113.36	113.58	112.89	113.24	1765324.0
2018-09-14 10:00:00	MSFT	Stock	113.245	113.595	113.13	113.4	1499320.0
2018-09-14 10:30:00	MSFT	Stock	113.405	113.73	113.405	113.605	1360379.0
2018-09-14 11:00:00	MSFT	Stock	113.605	113.608	113.03	113.24	1533253.0
2018-09-14 11:30:00	MSFT	Stock	113.25	113.48	113.23	113.47	624950.0
2018-09-14 12:00:00	MSFT	Stock	113.47	113.49	112.59	112.64	1905945.0
2018-09-14 12:30:00	MSFT	Stock	112.65	113.04	112.57	112.825	709782.0
2018-09-14 13:00:00	MSFT	Stock	112.822	112.97	112.44	112.925	674314.0
2018-09-14 13:30:00	MSFT	Stock	112.93	113.29	112.93	113.23	609443.0

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

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