PREVIEW / stock_30min / 2017-12-29

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-29.parquet
  size:    1.7 MB
  rows:    85,037
  symbols: 2,927

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-12-29 05:00:00	AAPL	Stock	42.7	42.7	42.7	42.7	3600.0
2017-12-29 06:00:00	AAPL	Stock	42.7	42.725	42.7	42.725	4120.0
2017-12-29 06:30:00	AAPL	Stock	42.73	42.7675	42.73	42.735	19412.0
2017-12-29 07:00:00	AAPL	Stock	42.735	42.825	42.735	42.825	58788.0
2017-12-29 07:30:00	AAPL	Stock	42.8175	42.8375	42.795	42.8075	35992.0
2017-12-29 08:00:00	AAPL	Stock	42.8125	42.8125	42.7175	42.7325	139060.0
2017-12-29 08:30:00	AAPL	Stock	42.7375	42.745	42.7	42.7	119124.0
2017-12-29 09:00:00	AAPL	Stock	42.7	42.7375	42.53	42.6775	410672.0
2017-12-29 09:30:00	AAPL	Stock	42.6775	42.6775	42.4275	42.4825	18111676.0
2017-12-29 10:00:00	AAPL	Stock	42.48	42.4825	42.3275	42.46	10458544.0
2017-12-29 10:30:00	AAPL	Stock	42.4625	42.4875	42.38	42.41	6136600.0
2017-12-29 11:00:00	AAPL	Stock	42.4075	42.4925	42.37	42.49	5296832.0
2017-12-29 11:30:00	AAPL	Stock	42.49	42.5225	42.44	42.521	3634204.0
2017-12-29 12:00:00	AAPL	Stock	42.52	42.555	42.4975	42.5175	3645764.0
2017-12-29 12:30:00	AAPL	Stock	42.516	42.54	42.5	42.5325	3068124.0
2017-12-29 13:00:00	AAPL	Stock	42.53	42.565	42.515	42.5398	2443060.0
2017-12-29 13:30:00	AAPL	Stock	42.5375	42.545	42.5	42.5075	2761840.0
2017-12-29 14:00:00	AAPL	Stock	42.51	42.515	42.4875	42.4925	2231176.0
2017-12-29 14:30:00	AAPL	Stock	42.4938	42.5075	42.48	42.4975	2190408.0
2017-12-29 15:00:00	AAPL	Stock	42.495	42.5225	42.48	42.4938	3289240.0
2017-12-29 15:30:00	AAPL	Stock	42.4928	42.495	42.305	42.325	14609600.0
2017-12-29 16:00:00	AAPL	Stock	42.3275	42.4025	42.2575	42.3	14823640.0
2017-12-29 16:30:00	AAPL	Stock	42.2875	42.3075	42.275	42.2825	124792.0
2017-12-29 17:00:00	AAPL	Stock	42.2825	42.305	42.2825	42.2825	60716.0
2017-12-29 17:30:00	AAPL	Stock	42.275	42.3	42.2625	42.2825	30324.0
2017-12-29 18:00:00	AAPL	Stock	42.265	42.2875	42.2625	42.2625	37980.0
2017-12-29 18:30:00	AAPL	Stock	42.2675	42.28	42.2625	42.275	10724.0
2017-12-29 19:00:00	AAPL	Stock	42.2625	42.275	42.2625	42.2625	30896.0
2017-12-29 19:30:00	AAPL	Stock	42.27	42.275	42.2525	42.275	30368.0
2017-12-29 06:30:00	MSFT	Stock	85.99	85.99	85.99	85.99	100.0
2017-12-29 07:00:00	MSFT	Stock	85.97	85.97	85.97	85.97	100.0
2017-12-29 07:30:00	MSFT	Stock	85.97	85.97	85.95	85.95	500.0
2017-12-29 08:00:00	MSFT	Stock	85.77	85.98	85.77	85.95	1400.0
2017-12-29 08:30:00	MSFT	Stock	85.86	85.86	85.8	85.8	3844.0
2017-12-29 09:00:00	MSFT	Stock	85.88	85.88	85.14	85.51	26462.0
2017-12-29 09:30:00	MSFT	Stock	85.6	85.99	85.51	85.932	1551940.0
2017-12-29 10:00:00	MSFT	Stock	85.93	86.0	85.84	85.973	599422.0
2017-12-29 10:30:00	MSFT	Stock	85.97	85.99	85.58	85.72	697118.0
2017-12-29 11:00:00	MSFT	Stock	85.72	85.73	85.54	85.7	561102.0
2017-12-29 11:30:00	MSFT	Stock	85.71	85.76	85.53	85.757	486431.0
2017-12-29 12:00:00	MSFT	Stock	85.76	85.91	85.74	85.78	483604.0
2017-12-29 12:30:00	MSFT	Stock	85.79	85.9	85.77	85.826	343340.0
2017-12-29 13:00:00	MSFT	Stock	85.82	85.88	85.73	85.88	536566.0
2017-12-29 13:30:00	MSFT	Stock	85.88	85.94	85.81	85.93	554959.0
2017-12-29 14:00:00	MSFT	Stock	85.93	85.96	85.84	85.91	443390.0
2017-12-29 14:30:00	MSFT	Stock	85.9	85.99	85.88	85.96	395016.0
2017-12-29 15:00:00	MSFT	Stock	85.955	86.05	85.94	85.965	766536.0
2017-12-29 15:30:00	MSFT	Stock	85.96	85.97	85.5	85.59	3751658.0
2017-12-29 16:00:00	MSFT	Stock	85.54	85.7	85.4	85.47	5414680.0
2017-12-29 16:30:00	MSFT	Stock	85.5	85.54	85.4	85.4	30350.0

> showing 50 of 85,037 rows — these rows as CSV

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