PREVIEW / stock_30min / 2017-11-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-03.parquet
  size:    1.6 MB
  rows:    81,390
  symbols: 2,948

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-11-03 04:00:00	AAPL	Stock	43.3875	43.4925	43.375	43.4175	75596.0
2017-11-03 04:30:00	AAPL	Stock	43.4125	43.4475	43.35	43.4475	32600.0
2017-11-03 05:00:00	AAPL	Stock	43.4375	43.4525	43.375	43.375	43008.0
2017-11-03 05:30:00	AAPL	Stock	43.3975	43.4075	43.2	43.245	99300.0
2017-11-03 06:00:00	AAPL	Stock	43.255	43.3	43.215	43.3	70828.0
2017-11-03 06:30:00	AAPL	Stock	43.2975	43.52	43.25	43.5125	175608.0
2017-11-03 07:00:00	AAPL	Stock	43.5125	43.7275	43.4525	43.6725	1066372.0
2017-11-03 07:30:00	AAPL	Stock	43.65	43.725	43.4625	43.65	892240.0
2017-11-03 08:00:00	AAPL	Stock	43.65	43.8575	43.25	43.855	3893076.0
2017-11-03 08:30:00	AAPL	Stock	43.855	43.9875	43.69	43.7	3326952.0
2017-11-03 09:00:00	AAPL	Stock	43.7	43.7875	43.5	43.5	2631260.0
2017-11-03 09:30:00	AAPL	Stock	43.5	43.565	42.78	42.94	55892544.0
2017-11-03 10:00:00	AAPL	Stock	42.94	43.1725	42.7952	42.8375	25518068.0
2017-11-03 10:30:00	AAPL	Stock	42.8325	43.075	42.8125	43.0025	14243068.0
2017-11-03 11:00:00	AAPL	Stock	43.0075	43.125	42.9482	43.0595	13250220.0
2017-11-03 11:30:00	AAPL	Stock	43.0625	43.2375	43.035	43.2285	11387396.0
2017-11-03 12:00:00	AAPL	Stock	43.235	43.31	43.1925	43.275	13291652.0
2017-11-03 12:30:00	AAPL	Stock	43.2825	43.3175	43.155	43.2692	6935592.0
2017-11-03 13:00:00	AAPL	Stock	43.27	43.3625	43.2425	43.35	7137532.0
2017-11-03 13:30:00	AAPL	Stock	43.349	43.4525	43.3475	43.37	9083516.0
2017-11-03 14:00:00	AAPL	Stock	43.37	43.3725	43.1375	43.2775	9247892.0
2017-11-03 14:30:00	AAPL	Stock	43.2752	43.2805	43.16	43.2075	6443528.0
2017-11-03 15:00:00	AAPL	Stock	43.2062	43.228	43.0775	43.1015	6567140.0
2017-11-03 15:30:00	AAPL	Stock	43.1025	43.1825	43.0912	43.12	16635780.0
2017-11-03 16:00:00	AAPL	Stock	43.125	43.2788	43.0625	43.1	6916940.0
2017-11-03 16:30:00	AAPL	Stock	43.1	43.125	43.0825	43.1125	512884.0
2017-11-03 17:00:00	AAPL	Stock	43.105	43.125	43.0875	43.115	403580.0
2017-11-03 17:30:00	AAPL	Stock	43.11	43.1175	43.0825	43.1	96568.0
2017-11-03 18:00:00	AAPL	Stock	43.1125	43.1125	43.1	43.1125	57392.0
2017-11-03 18:30:00	AAPL	Stock	43.1125	43.1175	43.1025	43.105	42984.0
2017-11-03 19:00:00	AAPL	Stock	43.1025	43.115	43.1025	43.11	15856.0
2017-11-03 19:30:00	AAPL	Stock	43.1075	43.12	43.1	43.1	26552.0
2017-11-03 04:00:00	MSFT	Stock	84.2	84.2	84.2	84.2	180.0
2017-11-03 05:00:00	MSFT	Stock	84.4	84.4	84.4	84.4	100.0
2017-11-03 05:30:00	MSFT	Stock	84.37	84.37	84.37	84.37	600.0
2017-11-03 06:00:00	MSFT	Stock	84.37	84.37	84.37	84.37	685.0
2017-11-03 06:30:00	MSFT	Stock	84.39	84.39	84.26	84.35	524.0
2017-11-03 07:00:00	MSFT	Stock	84.3	84.39	84.3	84.39	1270.0
2017-11-03 07:30:00	MSFT	Stock	84.42	84.42	84.4	84.4	2422.0
2017-11-03 08:00:00	MSFT	Stock	84.37	84.42	84.37	84.41	11064.0
2017-11-03 08:30:00	MSFT	Stock	84.33	84.45	84.2	84.3	14108.0
2017-11-03 09:00:00	MSFT	Stock	84.34	84.35	84.03	84.16	26593.0
2017-11-03 09:30:00	MSFT	Stock	84.13	84.18	83.4	83.53	2891016.0
2017-11-03 10:00:00	MSFT	Stock	83.53	83.85	83.475	83.78	1213874.0
2017-11-03 10:30:00	MSFT	Stock	83.78	83.98	83.775	83.98	1264172.0
2017-11-03 11:00:00	MSFT	Stock	83.97	83.98	83.845	83.965	695848.0
2017-11-03 11:30:00	MSFT	Stock	83.96	84.275	83.95	84.27	925095.0
2017-11-03 12:00:00	MSFT	Stock	84.28	84.36	84.21	84.327	820378.0
2017-11-03 12:30:00	MSFT	Stock	84.33	84.54	84.27	84.37	887417.0
2017-11-03 13:00:00	MSFT	Stock	84.37	84.44	84.11	84.14	829086.0

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

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