PREVIEW / stock_30min / 2017-07-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-14.parquet
  size:    1.6 MB
  rows:    80,291
  symbols: 3,003

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-07-14 04:00:00	AAPL	Stock	36.8625	36.8625	36.75	36.75	15676.0
2017-07-14 05:00:00	AAPL	Stock	36.7275	36.745	36.7	36.745	7496.0
2017-07-14 05:30:00	AAPL	Stock	36.745	36.745	36.7	36.7425	12020.0
2017-07-14 06:00:00	AAPL	Stock	36.725	36.7475	36.725	36.7475	18652.0
2017-07-14 06:30:00	AAPL	Stock	36.7275	36.7825	36.7275	36.765	34600.0
2017-07-14 07:00:00	AAPL	Stock	36.7825	36.8	36.7825	36.8	27956.0
2017-07-14 07:30:00	AAPL	Stock	36.81	36.825	36.81	36.8225	35488.0
2017-07-14 08:00:00	AAPL	Stock	36.805	37.025	36.7825	36.8625	225264.0
2017-07-14 08:30:00	AAPL	Stock	36.8625	36.97	36.8625	36.97	328264.0
2017-07-14 09:00:00	AAPL	Stock	36.97	37.01	36.925	36.995	308992.0
2017-07-14 09:30:00	AAPL	Stock	36.9875	37.025	36.8362	36.865	10241632.0
2017-07-14 10:00:00	AAPL	Stock	36.865	36.965	36.8325	36.925	4867836.0
2017-07-14 10:30:00	AAPL	Stock	36.9225	36.93	36.8525	36.9025	3984876.0
2017-07-14 11:00:00	AAPL	Stock	36.9025	36.9325	36.855	36.925	3335400.0
2017-07-14 11:30:00	AAPL	Stock	36.925	36.95	36.9038	36.9462	2835800.0
2017-07-14 12:00:00	AAPL	Stock	36.9462	37.12	36.9375	37.1198	4422688.0
2017-07-14 12:30:00	AAPL	Stock	37.1188	37.2025	37.085	37.1755	5475240.0
2017-07-14 13:00:00	AAPL	Stock	37.1755	37.1912	37.125	37.19	3472664.0
2017-07-14 13:30:00	AAPL	Stock	37.19	37.2725	37.18	37.251	4647200.0
2017-07-14 14:00:00	AAPL	Stock	37.2542	37.2788	37.2275	37.2512	4102808.0
2017-07-14 14:30:00	AAPL	Stock	37.25	37.2775	37.2125	37.215	3004712.0
2017-07-14 15:00:00	AAPL	Stock	37.2175	37.2625	37.215	37.2575	3693828.0
2017-07-14 15:30:00	AAPL	Stock	37.2575	37.3325	37.255	37.26	12081932.0
2017-07-14 16:00:00	AAPL	Stock	37.265	37.295	37.26	37.26	6115076.0
2017-07-14 16:30:00	AAPL	Stock	37.2612	37.275	37.25	37.2575	51324.0
2017-07-14 17:00:00	AAPL	Stock	37.275	37.275	37.26	37.26	19884.0
2017-07-14 17:30:00	AAPL	Stock	37.2525	37.26	37.2525	37.2525	2368.0
2017-07-14 18:00:00	AAPL	Stock	37.26	37.275	37.2575	37.275	14960.0
2017-07-14 18:30:00	AAPL	Stock	37.2575	37.26	37.25	37.26	6332.0
2017-07-14 19:00:00	AAPL	Stock	37.2575	37.2575	37.25	37.2575	4256.0
2017-07-14 19:30:00	AAPL	Stock	37.255	37.2625	37.255	37.26	15068.0
2017-07-14 08:30:00	MSFT	Stock	71.9	72.18	71.9	72.18	2811.0
2017-07-14 09:00:00	MSFT	Stock	72.19	72.29	72.08	72.23	24172.0
2017-07-14 09:30:00	MSFT	Stock	72.24	72.39	71.96	72.095	2310165.0
2017-07-14 10:00:00	MSFT	Stock	72.095	72.26	72.08	72.2	1421400.0
2017-07-14 10:30:00	MSFT	Stock	72.2	72.22	72.11	72.19	959866.0
2017-07-14 11:00:00	MSFT	Stock	72.19	72.43	72.12	72.42	989539.0
2017-07-14 11:30:00	MSFT	Stock	72.425	72.43	72.205	72.225	789108.0
2017-07-14 12:00:00	MSFT	Stock	72.22	72.45	72.214	72.444	728892.0
2017-07-14 12:30:00	MSFT	Stock	72.445	72.83	72.43	72.75	1902522.0
2017-07-14 13:00:00	MSFT	Stock	72.755	72.98	72.74	72.93	1333972.0
2017-07-14 13:30:00	MSFT	Stock	72.925	72.99	72.76	72.955	1394268.0
2017-07-14 14:00:00	MSFT	Stock	72.95	73.06	72.94	73.045	1360717.0
2017-07-14 14:30:00	MSFT	Stock	73.05	73.12	73.039	73.08	1724702.0
2017-07-14 15:00:00	MSFT	Stock	73.08	73.27	73.07	73.165	2047627.0
2017-07-14 15:30:00	MSFT	Stock	73.161	73.26	72.75	72.77	4913725.0
2017-07-14 16:00:00	MSFT	Stock	72.78	72.9	72.78	72.78	1787238.0
2017-07-14 16:30:00	MSFT	Stock	72.8	72.8	72.74	72.74	9858.0
2017-07-14 17:00:00	MSFT	Stock	72.74	72.87	72.74	72.87	4267.0
2017-07-14 17:30:00	MSFT	Stock	72.75	72.78	72.75	72.78	81033.0

> showing 50 of 80,291 rows — these rows as CSV

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