PREVIEW / stock_30min / 2018-06-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-04.parquet
  size:    1.7 MB
  rows:    84,470
  symbols: 2,835

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-06-04 04:00:00	AAPL	Stock	47.69	47.8075	47.69	47.8075	11980.0
2018-06-04 04:30:00	AAPL	Stock	47.7875	47.86	47.7875	47.86	5844.0
2018-06-04 05:00:00	AAPL	Stock	47.805	47.8475	47.805	47.8475	5272.0
2018-06-04 05:30:00	AAPL	Stock	47.86	47.8625	47.845	47.845	2400.0
2018-06-04 06:00:00	AAPL	Stock	47.825	47.825	47.7875	47.8125	13940.0
2018-06-04 06:30:00	AAPL	Stock	47.8	47.8	47.75	47.75	46216.0
2018-06-04 07:00:00	AAPL	Stock	47.685	47.75	47.67	47.7375	96748.0
2018-06-04 07:30:00	AAPL	Stock	47.7375	47.8075	47.735	47.7975	238124.0
2018-06-04 08:00:00	AAPL	Stock	47.7	47.9475	47.6875	47.89	455068.0
2018-06-04 08:30:00	AAPL	Stock	47.8925	47.9375	47.8625	47.915	188148.0
2018-06-04 09:00:00	AAPL	Stock	47.905	47.975	47.8225	47.9	514124.0
2018-06-04 09:30:00	AAPL	Stock	47.9	48.2275	47.8375	48.0575	18544328.0
2018-06-04 10:00:00	AAPL	Stock	48.06	48.1225	47.95	48.0175	7299216.0
2018-06-04 10:30:00	AAPL	Stock	48.0175	48.07	47.9025	48.0375	5769832.0
2018-06-04 11:00:00	AAPL	Stock	48.04	48.0825	47.965	48.035	3715520.0
2018-06-04 11:30:00	AAPL	Stock	48.0325	48.12	48.0275	48.1093	3487424.0
2018-06-04 12:00:00	AAPL	Stock	48.11	48.355	48.105	48.33	9062828.0
2018-06-04 12:30:00	AAPL	Stock	48.3288	48.33	48.17	48.2075	5122892.0
2018-06-04 13:00:00	AAPL	Stock	48.2062	48.2975	48.205	48.24	4347932.0
2018-06-04 13:30:00	AAPL	Stock	48.24	48.25	48.0025	48.06	5713092.0
2018-06-04 14:00:00	AAPL	Stock	48.0575	48.085	47.92	47.9425	5373960.0
2018-06-04 14:30:00	AAPL	Stock	47.9425	48.025	47.91	48.0175	4329004.0
2018-06-04 15:00:00	AAPL	Stock	48.0155	48.055	47.86	47.8785	5560180.0
2018-06-04 15:30:00	AAPL	Stock	47.88	48.005	47.8625	47.9525	7174892.0
2018-06-04 16:00:00	AAPL	Stock	47.9575	47.985	47.95	47.975	4894156.0
2018-06-04 16:30:00	AAPL	Stock	47.9675	47.9825	47.9575	47.98	69632.0
2018-06-04 17:00:00	AAPL	Stock	47.98	48.0625	47.98	48.0625	137212.0
2018-06-04 17:30:00	AAPL	Stock	48.0625	48.07	48.0375	48.06	48384.0
2018-06-04 18:00:00	AAPL	Stock	48.06	48.1075	48.06	48.0925	113040.0
2018-06-04 18:30:00	AAPL	Stock	48.1025	48.1075	48.075	48.0875	18564.0
2018-06-04 19:00:00	AAPL	Stock	48.0925	48.0975	48.0875	48.095	6248.0
2018-06-04 19:30:00	AAPL	Stock	48.0975	48.1075	48.0675	48.0875	40684.0
2018-06-04 04:00:00	MSFT	Stock	101.0	102.0	101.0	101.6	2047.0
2018-06-04 04:30:00	MSFT	Stock	101.62	101.62	101.62	101.62	100.0
2018-06-04 05:00:00	MSFT	Stock	101.4	101.4	101.39	101.39	1300.0
2018-06-04 06:00:00	MSFT	Stock	101.66	101.66	101.66	101.66	100.0
2018-06-04 06:30:00	MSFT	Stock	101.6	101.6	101.56	101.6	748.0
2018-06-04 07:00:00	MSFT	Stock	101.59	101.59	101.37	101.5	2794.0
2018-06-04 07:30:00	MSFT	Stock	101.56	101.6	101.21	101.39	14937.0
2018-06-04 08:00:00	MSFT	Stock	101.37	101.69	101.0	101.46	26656.0
2018-06-04 08:30:00	MSFT	Stock	101.4	101.64	101.39	101.47	10536.0
2018-06-04 09:00:00	MSFT	Stock	101.47	101.96	101.26	101.26	121262.0
2018-06-04 09:30:00	MSFT	Stock	101.26	101.78	101.05	101.37	4328160.0
2018-06-04 10:00:00	MSFT	Stock	101.37	101.52	100.851	101.22	2445244.0
2018-06-04 10:30:00	MSFT	Stock	101.23	101.49	100.985	101.45	1452117.0
2018-06-04 11:00:00	MSFT	Stock	101.46	101.69	101.175	101.3	1613945.0
2018-06-04 11:30:00	MSFT	Stock	101.29	101.34	101.08	101.31	811229.0
2018-06-04 12:00:00	MSFT	Stock	101.315	101.79	101.24	101.75	1592187.0
2018-06-04 12:30:00	MSFT	Stock	101.75	101.86	101.66	101.68	945675.0
2018-06-04 13:00:00	MSFT	Stock	101.676	101.72	101.58	101.694	1078593.0

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

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