PREVIEW / stock_30min / 2017-12-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-22.parquet
  size:    1.6 MB
  rows:    82,886
  symbols: 2,902

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-12-22 04:00:00	AAPL	Stock	43.795	43.795	43.7	43.7	1200.0
2017-12-22 06:00:00	AAPL	Stock	43.74	43.74	43.74	43.74	3036.0
2017-12-22 06:30:00	AAPL	Stock	43.7425	43.7425	43.7225	43.7225	5056.0
2017-12-22 07:00:00	AAPL	Stock	43.73	43.77	43.725	43.77	14904.0
2017-12-22 07:30:00	AAPL	Stock	43.75	43.7525	43.72	43.72	27684.0
2017-12-22 08:00:00	AAPL	Stock	43.73	43.7725	43.6625	43.675	83856.0
2017-12-22 08:30:00	AAPL	Stock	43.68	43.7	43.645	43.6625	110820.0
2017-12-22 09:00:00	AAPL	Stock	43.6875	43.725	43.65	43.6775	71532.0
2017-12-22 09:30:00	AAPL	Stock	43.6775	43.856	43.625	43.8	9654420.0
2017-12-22 10:00:00	AAPL	Stock	43.7988	43.8	43.7125	43.7537	4081020.0
2017-12-22 10:30:00	AAPL	Stock	43.7525	43.83	43.72	43.8175	3308344.0
2017-12-22 11:00:00	AAPL	Stock	43.8175	43.835	43.7525	43.79	2755168.0
2017-12-22 11:30:00	AAPL	Stock	43.79	43.83	43.725	43.7725	2701064.0
2017-12-22 12:00:00	AAPL	Stock	43.7725	43.775	43.725	43.73	2649296.0
2017-12-22 12:30:00	AAPL	Stock	43.7275	43.755	43.71	43.7425	2007076.0
2017-12-22 13:00:00	AAPL	Stock	43.7425	43.7825	43.73	43.7472	2225540.0
2017-12-22 13:30:00	AAPL	Stock	43.7475	43.79	43.745	43.76	1997004.0
2017-12-22 14:00:00	AAPL	Stock	43.7575	43.8013	43.735	43.7825	1894936.0
2017-12-22 14:30:00	AAPL	Stock	43.7825	43.7962	43.75	43.79	2189016.0
2017-12-22 15:00:00	AAPL	Stock	43.7925	43.7925	43.7275	43.7575	2790488.0
2017-12-22 15:30:00	AAPL	Stock	43.7575	43.7688	43.7225	43.7625	6499620.0
2017-12-22 16:00:00	AAPL	Stock	43.7525	43.775	43.7525	43.765	11747348.0
2017-12-22 16:30:00	AAPL	Stock	43.7675	43.7775	43.73	43.7425	858212.0
2017-12-22 17:00:00	AAPL	Stock	43.7425	43.7425	43.7425	43.7425	6400.0
2017-12-22 17:30:00	AAPL	Stock	43.75	43.7625	43.75	43.7625	6864.0
2017-12-22 18:00:00	AAPL	Stock	43.755	43.755	43.75	43.75	4580.0
2017-12-22 18:30:00	AAPL	Stock	43.745	43.75	43.745	43.75	2460.0
2017-12-22 19:00:00	AAPL	Stock	43.755	43.755	43.75	43.75	5316.0
2017-12-22 19:30:00	AAPL	Stock	43.75	43.755	43.75	43.75	13936.0
2017-12-22 07:00:00	MSFT	Stock	85.75	85.79	85.75	85.75	700.0
2017-12-22 07:30:00	MSFT	Stock	85.7	85.7	85.7	85.7	100.0
2017-12-22 08:00:00	MSFT	Stock	85.74	85.74	85.53	85.7	3365.0
2017-12-22 08:30:00	MSFT	Stock	85.72	85.72	85.6	85.7	1091.0
2017-12-22 09:00:00	MSFT	Stock	85.7	85.7	85.21	85.36	21505.0
2017-12-22 09:30:00	MSFT	Stock	85.4	85.595	85.045	85.16	2559537.0
2017-12-22 10:00:00	MSFT	Stock	85.17	85.18	84.92	85.14	1321109.0
2017-12-22 10:30:00	MSFT	Stock	85.14	85.31	85.09	85.25	889768.0
2017-12-22 11:00:00	MSFT	Stock	85.25	85.28	85.1	85.18	673076.0
2017-12-22 11:30:00	MSFT	Stock	85.18	85.28	85.07	85.195	538829.0
2017-12-22 12:00:00	MSFT	Stock	85.19	85.29	85.13	85.225	436878.0
2017-12-22 12:30:00	MSFT	Stock	85.23	85.25	85.14	85.205	281524.0
2017-12-22 13:00:00	MSFT	Stock	85.205	85.3	85.2	85.255	421624.0
2017-12-22 13:30:00	MSFT	Stock	85.26	85.33	85.24	85.3	422212.0
2017-12-22 14:00:00	MSFT	Stock	85.294	85.48	85.27	85.43	436677.0
2017-12-22 14:30:00	MSFT	Stock	85.43	85.51	85.385	85.5	519332.0
2017-12-22 15:00:00	MSFT	Stock	85.5	85.605	85.49	85.59	515111.0
2017-12-22 15:30:00	MSFT	Stock	85.59	85.63	85.46	85.58	1295499.0
2017-12-22 16:00:00	MSFT	Stock	85.51	85.7	85.5	85.55	2919062.0
2017-12-22 16:30:00	MSFT	Stock	85.51	85.55	85.51	85.55	12029.0
2017-12-22 18:30:00	MSFT	Stock	85.57	85.57	85.57	85.57	172.0

> showing 50 of 82,886 rows — these rows as CSV

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