PREVIEW / stock_30min / 2017-06-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-12.parquet
  size:    1.6 MB
  rows:    82,001
  symbols: 3,033

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-12 04:00:00	AAPL	Stock	36.9725	36.9825	36.5625	36.5625	114796.0
2017-06-12 04:30:00	AAPL	Stock	36.525	36.5625	36.275	36.325	107148.0
2017-06-12 05:00:00	AAPL	Stock	36.3425	36.4475	36.325	36.4475	39340.0
2017-06-12 05:30:00	AAPL	Stock	36.4475	36.4475	36.41	36.4275	29500.0
2017-06-12 06:00:00	AAPL	Stock	36.4275	36.56	36.425	36.56	46084.0
2017-06-12 06:30:00	AAPL	Stock	36.56	36.6125	36.515	36.515	15732.0
2017-06-12 07:00:00	AAPL	Stock	36.5375	36.6075	36.46	36.52	234808.0
2017-06-12 07:30:00	AAPL	Stock	36.5175	36.5175	36.375	36.42	200844.0
2017-06-12 08:00:00	AAPL	Stock	36.42	36.575	36.3325	36.46	989808.0
2017-06-12 08:30:00	AAPL	Stock	36.4525	36.7475	36.4525	36.5975	601828.0
2017-06-12 09:00:00	AAPL	Stock	36.58	36.8	36.4075	36.4075	1037272.0
2017-06-12 09:30:00	AAPL	Stock	36.4	36.435	35.6275	35.8775	75441300.0
2017-06-12 10:00:00	AAPL	Stock	35.8825	36.1775	35.735	36.0125	30270308.0
2017-06-12 10:30:00	AAPL	Stock	36.0138	36.315	35.9175	36.2275	20375632.0
2017-06-12 11:00:00	AAPL	Stock	36.2275	36.5225	36.175	36.365	18188220.0
2017-06-12 11:30:00	AAPL	Stock	36.365	36.4125	36.2075	36.265	13489324.0
2017-06-12 12:00:00	AAPL	Stock	36.265	36.315	35.9775	36.0325	11640116.0
2017-06-12 12:30:00	AAPL	Stock	36.0335	36.1375	35.9	35.9125	8957792.0
2017-06-12 13:00:00	AAPL	Stock	35.9125	36.059	35.8425	36.0375	9492300.0
2017-06-12 13:30:00	AAPL	Stock	36.04	36.06	35.855	35.8725	7657124.0
2017-06-12 14:00:00	AAPL	Stock	35.8725	35.975	35.85	35.9025	8341040.0
2017-06-12 14:30:00	AAPL	Stock	35.9075	36.1425	35.8775	36.0325	10339416.0
2017-06-12 15:00:00	AAPL	Stock	36.0325	36.165	36.0162	36.0625	10065628.0
2017-06-12 15:30:00	AAPL	Stock	36.0625	36.365	35.99	36.35	21247720.0
2017-06-12 16:00:00	AAPL	Stock	36.355	36.365	36.2825	36.335	10643984.0
2017-06-12 16:30:00	AAPL	Stock	36.3475	36.355	36.3125	36.3475	373772.0
2017-06-12 17:00:00	AAPL	Stock	36.3475	36.355	36.3375	36.34	89252.0
2017-06-12 17:30:00	AAPL	Stock	36.3475	36.355	36.3425	36.3525	75700.0
2017-06-12 18:00:00	AAPL	Stock	36.3525	36.3625	36.3275	36.3625	64860.0
2017-06-12 18:30:00	AAPL	Stock	36.3625	36.3775	36.3525	36.3725	53548.0
2017-06-12 19:00:00	AAPL	Stock	36.37	36.425	36.37	36.4	29164.0
2017-06-12 19:30:00	AAPL	Stock	36.4125	36.4125	36.385	36.4	33936.0
2017-06-12 04:00:00	MSFT	Stock	69.53	69.53	69.53	69.53	1358.0
2017-06-12 05:00:00	MSFT	Stock	69.62	69.62	69.62	69.62	100.0
2017-06-12 05:30:00	MSFT	Stock	69.62	69.62	69.62	69.62	539.0
2017-06-12 06:00:00	MSFT	Stock	69.62	69.62	69.6	69.6	331.0
2017-06-12 06:30:00	MSFT	Stock	69.6	69.75	69.6	69.75	1553.0
2017-06-12 07:00:00	MSFT	Stock	69.66	69.66	69.29	69.29	13969.0
2017-06-12 07:30:00	MSFT	Stock	69.26	69.29	69.13	69.2	5844.0
2017-06-12 08:00:00	MSFT	Stock	69.66	69.66	69.03	69.2	24148.0
2017-06-12 08:30:00	MSFT	Stock	69.24	69.76	69.21	69.76	25835.0
2017-06-12 09:00:00	MSFT	Stock	69.5	70.19	69.24	69.28	97905.0
2017-06-12 09:30:00	MSFT	Stock	69.25	69.35	68.13	68.55	10841710.0
2017-06-12 10:00:00	MSFT	Stock	68.55	69.26	68.45	68.965	5336783.0
2017-06-12 10:30:00	MSFT	Stock	68.96	69.31	68.91	69.205	4001488.0
2017-06-12 11:00:00	MSFT	Stock	69.2	69.53	69.02	69.3	3157770.0
2017-06-12 11:30:00	MSFT	Stock	69.31	69.56	69.26	69.36	2772637.0
2017-06-12 12:00:00	MSFT	Stock	69.36	69.4	69.03	69.084	2189606.0
2017-06-12 12:30:00	MSFT	Stock	69.08	69.37	69.045	69.33	1670777.0
2017-06-12 13:00:00	MSFT	Stock	69.33	69.55	69.19	69.52	1468404.0

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

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