PREVIEW / stock_30min / 2017-06-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-15.parquet
  size:    1.6 MB
  rows:    81,536
  symbols: 3,029

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
2017-06-15 04:00:00	AAPL	Stock	35.975	35.975	35.8125	35.9025	22620.0
2017-06-15 04:30:00	AAPL	Stock	35.9375	35.9375	35.875	35.9	22620.0
2017-06-15 05:00:00	AAPL	Stock	35.86	35.9	35.8475	35.8625	12828.0
2017-06-15 05:30:00	AAPL	Stock	35.8725	35.875	35.845	35.845	21420.0
2017-06-15 06:00:00	AAPL	Stock	35.8275	35.8825	35.7875	35.85	49176.0
2017-06-15 06:30:00	AAPL	Stock	35.8475	35.8475	35.775	35.8175	41196.0
2017-06-15 07:00:00	AAPL	Stock	35.825	35.85	35.785	35.8025	56224.0
2017-06-15 07:30:00	AAPL	Stock	35.815	35.8625	35.79	35.8125	86620.0
2017-06-15 08:00:00	AAPL	Stock	35.8375	35.9	35.72	35.825	540932.0
2017-06-15 08:30:00	AAPL	Stock	35.795	35.9425	35.7875	35.9425	289644.0
2017-06-15 09:00:00	AAPL	Stock	35.9375	35.9425	35.7575	35.79	276196.0
2017-06-15 09:30:00	AAPL	Stock	35.79	36.045	35.7175	35.9575	20769100.0
2017-06-15 10:00:00	AAPL	Stock	35.9575	36.02	35.5525	35.6538	16227416.0
2017-06-15 10:30:00	AAPL	Stock	35.6525	35.81	35.57	35.805	12028952.0
2017-06-15 11:00:00	AAPL	Stock	35.8025	35.8975	35.745	35.857	7249808.0
2017-06-15 11:30:00	AAPL	Stock	35.8568	35.8625	35.7325	35.775	5327216.0
2017-06-15 12:00:00	AAPL	Stock	35.7775	35.8598	35.7575	35.8598	4862316.0
2017-06-15 12:30:00	AAPL	Stock	35.8588	35.955	35.81	35.935	4897860.0
2017-06-15 13:00:00	AAPL	Stock	35.935	36.005	35.9025	35.915	5111776.0
2017-06-15 13:30:00	AAPL	Stock	35.915	35.94	35.8545	35.9225	3769472.0
2017-06-15 14:00:00	AAPL	Stock	35.92	36.03	35.8775	35.9875	5616952.0
2017-06-15 14:30:00	AAPL	Stock	35.9875	36.0075	35.93	35.95	4524208.0
2017-06-15 15:00:00	AAPL	Stock	35.9475	36.12	35.9325	36.0925	5748308.0
2017-06-15 15:30:00	AAPL	Stock	36.0938	36.115	35.9425	36.075	12486748.0
2017-06-15 16:00:00	AAPL	Stock	36.075	36.08	35.9875	36.05	5329968.0
2017-06-15 16:30:00	AAPL	Stock	36.055	36.0975	35.9975	36.085	171332.0
2017-06-15 17:00:00	AAPL	Stock	36.085	36.095	36.07	36.075	57908.0
2017-06-15 17:30:00	AAPL	Stock	36.07	36.0725	36.0675	36.07	5900.0
2017-06-15 18:00:00	AAPL	Stock	36.0625	36.0825	36.0625	36.0775	52996.0
2017-06-15 18:30:00	AAPL	Stock	36.0825	36.0825	36.05	36.05	6200.0
2017-06-15 19:00:00	AAPL	Stock	36.0725	36.0725	36.05	36.0725	67844.0
2017-06-15 19:30:00	AAPL	Stock	36.07	36.1225	36.06	36.1225	66168.0
2017-06-15 04:00:00	MSFT	Stock	69.25	69.25	69.25	69.25	100.0
2017-06-15 07:00:00	MSFT	Stock	69.65	69.65	69.45	69.45	10300.0
2017-06-15 07:30:00	MSFT	Stock	69.45	69.45	69.42	69.42	1801.0
2017-06-15 08:00:00	MSFT	Stock	69.41	69.45	69.31	69.36	3937.0
2017-06-15 08:30:00	MSFT	Stock	69.36	69.6	69.36	69.6	21019.0
2017-06-15 09:00:00	MSFT	Stock	69.6	69.89	69.18	69.43	32177.0
2017-06-15 09:30:00	MSFT	Stock	69.42	69.642	68.88	69.29	4155709.0
2017-06-15 10:00:00	MSFT	Stock	69.28	69.34	68.8	69.185	2770194.0
2017-06-15 10:30:00	MSFT	Stock	69.19	69.73	69.13	69.73	1902275.0
2017-06-15 11:00:00	MSFT	Stock	69.72	70.07	69.64	69.88	1912681.0
2017-06-15 11:30:00	MSFT	Stock	69.885	69.91	69.73	69.82	1347515.0
2017-06-15 12:00:00	MSFT	Stock	69.83	69.99	69.79	69.835	1330212.0
2017-06-15 12:30:00	MSFT	Stock	69.835	70.07	69.74	70.035	1029727.0
2017-06-15 13:00:00	MSFT	Stock	70.04	70.056	69.88	69.91	672717.0
2017-06-15 13:30:00	MSFT	Stock	69.9	70.0	69.8	69.91	672050.0
2017-06-15 14:00:00	MSFT	Stock	69.91	70.21	69.88	70.1	967491.0
2017-06-15 14:30:00	MSFT	Stock	70.1	70.17	70.0	70.06	1057659.0
2017-06-15 15:00:00	MSFT	Stock	70.06	70.15	69.86	70.085	1397422.0

> showing 50 of 81,536 rows — these rows as CSV

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