PREVIEW / stock_30min / 2017-05-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-26.parquet
  size:    1.6 MB
  rows:    79,704
  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-05-26 04:00:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-05-26 05:30:00	AAPL	Stock	38.455	38.455	38.455	38.455	400.0
2017-05-26 06:00:00	AAPL	Stock	38.45	38.45	38.45	38.45	896.0
2017-05-26 07:00:00	AAPL	Stock	38.4875	38.5075	38.4575	38.4575	14412.0
2017-05-26 07:30:00	AAPL	Stock	38.425	38.425	38.35	38.35	20452.0
2017-05-26 08:00:00	AAPL	Stock	38.3575	38.3875	38.3125	38.325	102100.0
2017-05-26 08:30:00	AAPL	Stock	38.325	38.375	38.325	38.3575	41952.0
2017-05-26 09:00:00	AAPL	Stock	38.385	38.47	38.3825	38.4575	142872.0
2017-05-26 09:30:00	AAPL	Stock	38.4525	38.56	38.3625	38.475	9296492.0
2017-05-26 10:00:00	AAPL	Stock	38.4725	38.51	38.3978	38.4	4797816.0
2017-05-26 10:30:00	AAPL	Stock	38.4	38.48	38.4	38.4125	2973496.0
2017-05-26 11:00:00	AAPL	Stock	38.415	38.425	38.3775	38.415	3573084.0
2017-05-26 11:30:00	AAPL	Stock	38.415	38.4293	38.365	38.3675	3014380.0
2017-05-26 12:00:00	AAPL	Stock	38.365	38.45	38.3625	38.4263	3003276.0
2017-05-26 12:30:00	AAPL	Stock	38.425	38.43	38.37	38.398	1964900.0
2017-05-26 13:00:00	AAPL	Stock	38.3975	38.4375	38.3775	38.4162	1905892.0
2017-05-26 13:30:00	AAPL	Stock	38.4175	38.4465	38.38	38.4425	2973492.0
2017-05-26 14:00:00	AAPL	Stock	38.44	38.4725	38.4075	38.4462	2833716.0
2017-05-26 14:30:00	AAPL	Stock	38.445	38.48	38.435	38.4412	3213776.0
2017-05-26 15:00:00	AAPL	Stock	38.4415	38.465	38.405	38.4225	2814996.0
2017-05-26 15:30:00	AAPL	Stock	38.425	38.425	38.3275	38.3975	9969916.0
2017-05-26 16:00:00	AAPL	Stock	38.4	38.4375	38.395	38.4	8933792.0
2017-05-26 16:30:00	AAPL	Stock	38.4	38.4025	38.2575	38.355	719556.0
2017-05-26 17:00:00	AAPL	Stock	38.34	38.34	38.3175	38.335	28536.0
2017-05-26 17:30:00	AAPL	Stock	38.3325	38.345	38.325	38.345	18528.0
2017-05-26 18:00:00	AAPL	Stock	38.3475	38.3475	38.325	38.3475	13424.0
2017-05-26 18:30:00	AAPL	Stock	38.3375	38.34	38.33	38.34	3600.0
2017-05-26 19:00:00	AAPL	Stock	38.335	38.3475	38.33	38.33	14332.0
2017-05-26 19:30:00	AAPL	Stock	38.33	38.3475	38.325	38.33	45064.0
2017-05-26 07:30:00	MSFT	Stock	69.54	69.54	69.52	69.52	15218.0
2017-05-26 08:00:00	MSFT	Stock	69.58	69.58	69.44	69.55	20054.0
2017-05-26 08:30:00	MSFT	Stock	69.55	69.72	69.55	69.6	5911.0
2017-05-26 09:00:00	MSFT	Stock	69.7	69.78	69.7	69.78	1848.0
2017-05-26 09:30:00	MSFT	Stock	69.8	69.99	69.52	69.86	2044097.0
2017-05-26 10:00:00	MSFT	Stock	69.86	70.07	69.84	70.07	2099739.0
2017-05-26 10:30:00	MSFT	Stock	70.065	70.22	70.01	70.01	1293705.0
2017-05-26 11:00:00	MSFT	Stock	70.015	70.06	69.88	69.95	1026470.0
2017-05-26 11:30:00	MSFT	Stock	69.95	70.01	69.9	69.915	668970.0
2017-05-26 12:00:00	MSFT	Stock	69.92	70.04	69.85	70.0	863422.0
2017-05-26 12:30:00	MSFT	Stock	70.0	70.085	69.99	70.025	621711.0
2017-05-26 13:00:00	MSFT	Stock	70.025	70.04	69.96	70.01	447909.0
2017-05-26 13:30:00	MSFT	Stock	70.015	70.04	69.97	70.0	953952.0
2017-05-26 14:00:00	MSFT	Stock	70.0	70.03	69.97	70.025	776525.0
2017-05-26 14:30:00	MSFT	Stock	70.025	70.04	69.94	69.995	711729.0
2017-05-26 15:00:00	MSFT	Stock	70.0	70.02	69.92	69.975	1526096.0
2017-05-26 15:30:00	MSFT	Stock	69.98	70.02	69.83	69.96	3757072.0
2017-05-26 16:00:00	MSFT	Stock	69.97	69.97	69.959	69.97	1414520.0
2017-05-26 16:30:00	MSFT	Stock	69.96	69.99	69.96	69.99	19903.0
2017-05-26 17:00:00	MSFT	Stock	69.99	70.02	69.95	70.0	3952.0
2017-05-26 17:30:00	MSFT	Stock	70.02	70.03	70.0	70.03	843.0

> showing 50 of 79,704 rows — these rows as CSV

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