PREVIEW / stock_30min / 2017-07-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-13.parquet
  size:    1.6 MB
  rows:    80,209
  symbols: 2,992

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-13 04:00:00	AAPL	Stock	36.44	36.44	36.44	36.44	1424.0
2017-07-13 04:30:00	AAPL	Stock	36.4375	36.4375	36.4375	36.4375	1680.0
2017-07-13 05:00:00	AAPL	Stock	36.4675	36.5	36.4675	36.5	6200.0
2017-07-13 05:30:00	AAPL	Stock	36.5	36.5	36.5	36.5	2000.0
2017-07-13 06:00:00	AAPL	Stock	36.48	36.48	36.475	36.475	4136.0
2017-07-13 06:30:00	AAPL	Stock	36.455	36.455	36.45	36.45	13508.0
2017-07-13 07:00:00	AAPL	Stock	36.4175	36.45	36.4	36.4	21896.0
2017-07-13 07:30:00	AAPL	Stock	36.42	36.42	36.38	36.405	23296.0
2017-07-13 08:00:00	AAPL	Stock	36.4275	36.435	36.375	36.435	41808.0
2017-07-13 08:30:00	AAPL	Stock	36.4225	36.45	36.4	36.4	44060.0
2017-07-13 09:00:00	AAPL	Stock	36.4175	36.4175	36.3575	36.3875	108172.0
2017-07-13 09:30:00	AAPL	Stock	36.375	36.78	36.36	36.7525	13250340.0
2017-07-13 10:00:00	AAPL	Stock	36.755	36.8475	36.66	36.675	8963600.0
2017-07-13 10:30:00	AAPL	Stock	36.67	36.79	36.64	36.785	5741880.0
2017-07-13 11:00:00	AAPL	Stock	36.785	36.79	36.695	36.7	3791312.0
2017-07-13 11:30:00	AAPL	Stock	36.7	36.8925	36.6975	36.882	6134676.0
2017-07-13 12:00:00	AAPL	Stock	36.8812	37.01	36.8475	37.0025	5879340.0
2017-07-13 12:30:00	AAPL	Stock	37.0025	37.1225	36.9828	37.091	7543024.0
2017-07-13 13:00:00	AAPL	Stock	37.0912	37.1125	37.0425	37.0915	5372160.0
2017-07-13 13:30:00	AAPL	Stock	37.0875	37.0975	36.93	36.9925	6698560.0
2017-07-13 14:00:00	AAPL	Stock	36.9942	37.0575	36.9075	36.985	5094876.0
2017-07-13 14:30:00	AAPL	Stock	36.985	37.0322	36.94	36.9562	3497604.0
2017-07-13 15:00:00	AAPL	Stock	36.955	36.9675	36.895	36.9362	4395236.0
2017-07-13 15:30:00	AAPL	Stock	36.9375	37.02	36.93	36.945	9209936.0
2017-07-13 16:00:00	AAPL	Stock	36.9425	36.96	36.905	36.9525	6213548.0
2017-07-13 16:30:00	AAPL	Stock	36.945	36.9575	36.9375	36.9575	102748.0
2017-07-13 17:00:00	AAPL	Stock	36.9575	36.9575	36.9525	36.9575	82972.0
2017-07-13 17:30:00	AAPL	Stock	36.9575	36.9625	36.8875	36.9	67648.0
2017-07-13 18:00:00	AAPL	Stock	36.8875	36.9	36.78	36.795	114848.0
2017-07-13 18:30:00	AAPL	Stock	36.7875	36.8375	36.78	36.8025	86508.0
2017-07-13 19:00:00	AAPL	Stock	36.8	36.805	36.78	36.78	66664.0
2017-07-13 19:30:00	AAPL	Stock	36.7875	36.8	36.78	36.785	84280.0
2017-07-13 07:00:00	MSFT	Stock	71.4	71.4	71.4	71.4	4943.0
2017-07-13 07:30:00	MSFT	Stock	71.33	71.39	71.3	71.35	15823.0
2017-07-13 08:00:00	MSFT	Stock	71.4	71.4	71.36	71.39	893.0
2017-07-13 08:30:00	MSFT	Stock	71.4	71.45	71.15	71.4	28499.0
2017-07-13 09:00:00	MSFT	Stock	71.44	71.5	71.2	71.47	28530.0
2017-07-13 09:30:00	MSFT	Stock	71.45	71.95	71.31	71.91	2904515.0
2017-07-13 10:00:00	MSFT	Stock	71.9	72.04	71.71	71.79	2044265.0
2017-07-13 10:30:00	MSFT	Stock	71.78	71.785	71.535	71.7	1023439.0
2017-07-13 11:00:00	MSFT	Stock	71.7	71.76	71.51	71.52	699345.0
2017-07-13 11:30:00	MSFT	Stock	71.515	71.93	71.49	71.93	1234490.0
2017-07-13 12:00:00	MSFT	Stock	71.93	71.995	71.82	71.96	1343471.0
2017-07-13 12:30:00	MSFT	Stock	71.96	71.987	71.859	71.97	657829.0
2017-07-13 13:00:00	MSFT	Stock	71.97	72.02	71.925	71.99	1061972.0
2017-07-13 13:30:00	MSFT	Stock	71.99	72.01	71.74	71.81	1337880.0
2017-07-13 14:00:00	MSFT	Stock	71.8	71.85	71.63	71.8	1114824.0
2017-07-13 14:30:00	MSFT	Stock	71.79	71.82	71.7	71.71	731909.0
2017-07-13 15:00:00	MSFT	Stock	71.7	71.74	71.645	71.695	691681.0
2017-07-13 15:30:00	MSFT	Stock	71.7	71.83	71.67	71.77	1765118.0

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

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