PREVIEW / stock_30min / 2017-01-30

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-30.parquet
  size:    1.6 MB
  rows:    81,909
  symbols: 3,134

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-01-30 04:00:00	AAPL	Stock	30.2575	30.2575	30.245	30.245	9044.0
2017-01-30 04:30:00	AAPL	Stock	30.25	30.2575	30.2325	30.2375	13696.0
2017-01-30 05:30:00	AAPL	Stock	30.25	30.2575	30.25	30.2575	5780.0
2017-01-30 06:00:00	AAPL	Stock	30.2625	30.295	30.2625	30.27	11340.0
2017-01-30 06:30:00	AAPL	Stock	30.27	30.3	30.2675	30.2675	3948.0
2017-01-30 07:00:00	AAPL	Stock	30.29	30.3	30.2625	30.2875	45480.0
2017-01-30 07:30:00	AAPL	Stock	30.27	30.2975	30.2625	30.2975	14716.0
2017-01-30 08:00:00	AAPL	Stock	30.2775	30.425	30.2275	30.23	185992.0
2017-01-30 08:30:00	AAPL	Stock	30.23	30.2875	30.23	30.265	97516.0
2017-01-30 09:00:00	AAPL	Stock	30.265	30.2875	30.225	30.2725	256644.0
2017-01-30 09:30:00	AAPL	Stock	30.2325	30.34	30.165	30.2425	24268868.0
2017-01-30 10:00:00	AAPL	Stock	30.2412	30.2975	30.2275	30.265	9591344.0
2017-01-30 10:30:00	AAPL	Stock	30.265	30.29	30.2425	30.2838	8775440.0
2017-01-30 11:00:00	AAPL	Stock	30.2838	30.325	30.26	30.315	7076624.0
2017-01-30 11:30:00	AAPL	Stock	30.315	30.32	30.28	30.3125	5914020.0
2017-01-30 12:00:00	AAPL	Stock	30.3135	30.3225	30.2875	30.314	5123444.0
2017-01-30 12:30:00	AAPL	Stock	30.3135	30.32	30.28	30.295	4095208.0
2017-01-30 13:00:00	AAPL	Stock	30.2925	30.315	30.2875	30.2975	4138464.0
2017-01-30 13:30:00	AAPL	Stock	30.299	30.3075	30.275	30.2905	3643528.0
2017-01-30 14:00:00	AAPL	Stock	30.2908	30.3125	30.28	30.303	4703824.0
2017-01-30 14:30:00	AAPL	Stock	30.3038	30.3188	30.2975	30.3125	4268976.0
2017-01-30 15:00:00	AAPL	Stock	30.3148	30.32	30.2825	30.285	5433976.0
2017-01-30 15:30:00	AAPL	Stock	30.285	30.405	30.2725	30.39	16431648.0
2017-01-30 16:00:00	AAPL	Stock	30.3925	30.4375	30.3138	30.4275	8415368.0
2017-01-30 16:30:00	AAPL	Stock	30.425	30.43	30.4075	30.41	101636.0
2017-01-30 17:00:00	AAPL	Stock	30.41	30.43	30.4075	30.4275	31964.0
2017-01-30 17:30:00	AAPL	Stock	30.415	30.47	30.415	30.4575	53748.0
2017-01-30 18:00:00	AAPL	Stock	30.45	30.475	30.445	30.4725	32308.0
2017-01-30 18:30:00	AAPL	Stock	30.4625	30.4625	30.4375	30.4375	39416.0
2017-01-30 19:00:00	AAPL	Stock	30.44	30.45	30.4375	30.45	13596.0
2017-01-30 19:30:00	AAPL	Stock	30.44	30.4675	30.4225	30.4625	25864.0
2017-01-30 04:00:00	MSFT	Stock	65.12	65.45	65.12	65.45	411.0
2017-01-30 04:30:00	MSFT	Stock	65.48	65.5	65.38	65.38	6303.0
2017-01-30 05:00:00	MSFT	Stock	65.38	65.38	65.38	65.38	165.0
2017-01-30 05:30:00	MSFT	Stock	65.3	65.3	65.3	65.3	1468.0
2017-01-30 06:30:00	MSFT	Stock	65.41	65.41	65.41	65.41	448.0
2017-01-30 07:00:00	MSFT	Stock	65.4	65.48	65.4	65.45	3008.0
2017-01-30 07:30:00	MSFT	Stock	65.41	65.43	65.35	65.43	6507.0
2017-01-30 08:00:00	MSFT	Stock	65.41	65.49	65.35	65.39	15217.0
2017-01-30 08:30:00	MSFT	Stock	65.4	65.65	65.4	65.59	24905.0
2017-01-30 09:00:00	MSFT	Stock	65.51	65.65	65.51	65.65	18050.0
2017-01-30 09:30:00	MSFT	Stock	65.69	65.79	65.365	65.61	4482037.0
2017-01-30 10:00:00	MSFT	Stock	65.61	65.62	65.0	65.035	2773558.0
2017-01-30 10:30:00	MSFT	Stock	65.04	65.06	64.87	64.955	1842992.0
2017-01-30 11:00:00	MSFT	Stock	64.96	65.15	64.87	65.09	2080678.0
2017-01-30 11:30:00	MSFT	Stock	65.08	65.21	65.01	65.17	1672767.0
2017-01-30 12:00:00	MSFT	Stock	65.165	65.19	65.03	65.044	1377202.0
2017-01-30 12:30:00	MSFT	Stock	65.04	65.05	64.9	64.97	1381356.0
2017-01-30 13:00:00	MSFT	Stock	64.96	65.08	64.945	65.04	979323.0
2017-01-30 13:30:00	MSFT	Stock	65.035	65.045	64.9	64.935	1077797.0

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

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