PREVIEW / stock_30min / 2018-04-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-06.parquet
  size:    1.6 MB
  rows:    81,293
  symbols: 2,840

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-04-06 04:00:00	AAPL	Stock	42.7025	42.7525	42.6275	42.735	16372.0
2018-04-06 04:30:00	AAPL	Stock	42.7875	42.7875	42.75	42.75	3200.0
2018-04-06 05:00:00	AAPL	Stock	42.75	42.75	42.7	42.75	8716.0
2018-04-06 05:30:00	AAPL	Stock	42.8075	42.8075	42.8075	42.8075	780.0
2018-04-06 06:00:00	AAPL	Stock	42.825	42.85	42.825	42.85	5604.0
2018-04-06 06:30:00	AAPL	Stock	42.85	42.85	42.755	42.755	25568.0
2018-04-06 07:00:00	AAPL	Stock	42.76	42.8	42.5175	42.6625	201768.0
2018-04-06 07:30:00	AAPL	Stock	42.625	42.65	42.5375	42.5525	55000.0
2018-04-06 08:00:00	AAPL	Stock	42.575	42.775	42.5375	42.7525	211668.0
2018-04-06 08:30:00	AAPL	Stock	42.775	42.8675	42.6075	42.8	448560.0
2018-04-06 09:00:00	AAPL	Stock	42.8	42.8225	42.6	42.74	288836.0
2018-04-06 09:30:00	AAPL	Stock	42.7225	43.12	42.665	43.0275	13823852.0
2018-04-06 10:00:00	AAPL	Stock	43.0275	43.06	42.775	42.91	7859216.0
2018-04-06 10:30:00	AAPL	Stock	42.91	42.9875	42.58	42.6682	8094432.0
2018-04-06 11:00:00	AAPL	Stock	42.665	42.7125	42.4325	42.625	8012116.0
2018-04-06 11:30:00	AAPL	Stock	42.635	42.7645	42.5175	42.72	5466128.0
2018-04-06 12:00:00	AAPL	Stock	42.7225	42.8	42.495	42.5092	4135348.0
2018-04-06 12:30:00	AAPL	Stock	42.5125	42.8225	42.4875	42.805	4591960.0
2018-04-06 13:00:00	AAPL	Stock	42.7975	42.7975	42.545	42.6325	3813932.0
2018-04-06 13:30:00	AAPL	Stock	42.64	42.685	42.27	42.28	6952904.0
2018-04-06 14:00:00	AAPL	Stock	42.275	42.395	42.205	42.225	7821896.0
2018-04-06 14:30:00	AAPL	Stock	42.2275	42.3787	42.1	42.185	9244188.0
2018-04-06 15:00:00	AAPL	Stock	42.19	42.3075	42.06	42.17	9005020.0
2018-04-06 15:30:00	AAPL	Stock	42.1625	42.305	42.05	42.0875	18420860.0
2018-04-06 16:00:00	AAPL	Stock	42.095	42.1375	42.0925	42.135	12759328.0
2018-04-06 16:30:00	AAPL	Stock	42.1275	42.17	42.095	42.1625	69672.0
2018-04-06 17:00:00	AAPL	Stock	42.16	42.17	42.1125	42.13	46572.0
2018-04-06 17:30:00	AAPL	Stock	42.125	42.145	42.105	42.1175	40140.0
2018-04-06 18:00:00	AAPL	Stock	42.1325	42.1325	42.075	42.09	44652.0
2018-04-06 18:30:00	AAPL	Stock	42.1	42.12	42.0625	42.1125	61816.0
2018-04-06 19:00:00	AAPL	Stock	42.095	42.145	42.0925	42.1	26764.0
2018-04-06 19:30:00	AAPL	Stock	42.1025	42.1375	42.1	42.1225	21560.0
2018-04-06 04:00:00	MSFT	Stock	90.8	91.4	90.8	91.4	300.0
2018-04-06 05:00:00	MSFT	Stock	91.5	91.5	91.5	91.5	373.0
2018-04-06 06:00:00	MSFT	Stock	91.75	91.89	91.75	91.89	1273.0
2018-04-06 07:00:00	MSFT	Stock	91.65	91.65	91.29	91.55	3762.0
2018-04-06 07:30:00	MSFT	Stock	91.5	91.5	91.3	91.3	550.0
2018-04-06 08:00:00	MSFT	Stock	91.7	91.79	91.15	91.65	18437.0
2018-04-06 08:30:00	MSFT	Stock	91.7	91.95	91.3	91.78	37941.0
2018-04-06 09:00:00	MSFT	Stock	91.78	91.78	91.36	91.47	16814.0
2018-04-06 09:30:00	MSFT	Stock	91.49	92.46	91.17	92.22	2361452.0
2018-04-06 10:00:00	MSFT	Stock	92.22	92.41	92.03	92.12	1424838.0
2018-04-06 10:30:00	MSFT	Stock	92.12	92.19	91.39	91.58	1782023.0
2018-04-06 11:00:00	MSFT	Stock	91.58	91.75	91.185	91.65	1718180.0
2018-04-06 11:30:00	MSFT	Stock	91.65	92.06	91.54	91.955	1276080.0
2018-04-06 12:00:00	MSFT	Stock	91.95	92.04	91.2	91.249	1141785.0
2018-04-06 12:30:00	MSFT	Stock	91.244	92.03	91.16	91.98	1194065.0
2018-04-06 13:00:00	MSFT	Stock	91.97	91.975	91.22	91.57	1445632.0
2018-04-06 13:30:00	MSFT	Stock	91.58	91.669	90.1	90.4	1756540.0
2018-04-06 14:00:00	MSFT	Stock	90.4	90.58	89.92	90.03	1991616.0

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

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