PREVIEW / stock_30min / 2017-10-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-09.parquet
  size:    1.6 MB
  rows:    80,341
  symbols: 2,930

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-10-09 04:00:00	AAPL	Stock	38.7675	38.7675	38.7625	38.7625	7280.0
2017-10-09 04:30:00	AAPL	Stock	38.7575	38.7575	38.7575	38.7575	512.0
2017-10-09 05:00:00	AAPL	Stock	38.8125	38.8375	38.8125	38.8375	2196.0
2017-10-09 05:30:00	AAPL	Stock	38.835	38.95	38.835	38.9	12720.0
2017-10-09 06:00:00	AAPL	Stock	38.9	38.915	38.9	38.9	16544.0
2017-10-09 06:30:00	AAPL	Stock	38.9	38.9375	38.9	38.9375	5540.0
2017-10-09 07:00:00	AAPL	Stock	38.9	38.9575	38.8875	38.9575	61600.0
2017-10-09 07:30:00	AAPL	Stock	38.955	38.9975	38.9275	38.975	83624.0
2017-10-09 08:00:00	AAPL	Stock	38.95	38.9975	38.9	38.97	82896.0
2017-10-09 08:30:00	AAPL	Stock	38.965	38.9875	38.9425	38.9575	111796.0
2017-10-09 09:00:00	AAPL	Stock	38.9725	38.98	38.94	38.965	107812.0
2017-10-09 09:30:00	AAPL	Stock	38.955	39.07	38.8713	39.0518	10106072.0
2017-10-09 10:00:00	AAPL	Stock	39.0538	39.1825	39.045	39.1175	8304768.0
2017-10-09 10:30:00	AAPL	Stock	39.12	39.1375	38.965	39.0075	5068408.0
2017-10-09 11:00:00	AAPL	Stock	39.01	39.05	38.9425	38.965	3189228.0
2017-10-09 11:30:00	AAPL	Stock	38.96	39.0425	38.955	39.0175	2693812.0
2017-10-09 12:00:00	AAPL	Stock	39.0198	39.03	38.96	38.965	2158784.0
2017-10-09 12:30:00	AAPL	Stock	38.965	39.0322	38.9475	39.0125	2465928.0
2017-10-09 13:00:00	AAPL	Stock	39.0102	39.025	38.9782	38.9988	1420528.0
2017-10-09 13:30:00	AAPL	Stock	39.0	39.02	38.9825	38.9942	1707040.0
2017-10-09 14:00:00	AAPL	Stock	38.995	39.01	38.96	38.971	1808868.0
2017-10-09 14:30:00	AAPL	Stock	38.9712	38.985	38.94	38.9552	1704748.0
2017-10-09 15:00:00	AAPL	Stock	38.955	38.99	38.925	38.9775	3325932.0
2017-10-09 15:30:00	AAPL	Stock	38.9775	38.99	38.9002	38.955	6788408.0
2017-10-09 16:00:00	AAPL	Stock	38.96	38.975	38.9125	38.96	6125928.0
2017-10-09 16:30:00	AAPL	Stock	38.9225	38.9375	38.915	38.9175	14264.0
2017-10-09 17:00:00	AAPL	Stock	38.92	38.96	38.92	38.95	6080.0
2017-10-09 17:30:00	AAPL	Stock	38.92	38.935	38.9125	38.9125	12436.0
2017-10-09 18:00:00	AAPL	Stock	38.9325	38.9325	38.9125	38.9125	21084.0
2017-10-09 18:30:00	AAPL	Stock	38.915	38.9375	38.915	38.9325	3800.0
2017-10-09 19:00:00	AAPL	Stock	38.9175	38.925	38.9125	38.925	18488.0
2017-10-09 19:30:00	AAPL	Stock	38.93	38.9375	38.9125	38.9125	17328.0
2017-10-09 07:00:00	MSFT	Stock	76.0	76.0	76.0	76.0	1000.0
2017-10-09 07:30:00	MSFT	Stock	76.09	76.09	76.09	76.09	200.0
2017-10-09 08:00:00	MSFT	Stock	76.0	76.05	76.0	76.05	550.0
2017-10-09 09:00:00	MSFT	Stock	76.07	76.08	75.92	76.0	18362.0
2017-10-09 09:30:00	MSFT	Stock	75.97	76.28	75.86	76.25	1433693.0
2017-10-09 10:00:00	MSFT	Stock	76.25	76.385	76.181	76.215	575101.0
2017-10-09 10:30:00	MSFT	Stock	76.22	76.25	76.1	76.176	488046.0
2017-10-09 11:00:00	MSFT	Stock	76.175	76.23	76.045	76.21	440100.0
2017-10-09 11:30:00	MSFT	Stock	76.215	76.35	76.21	76.284	422310.0
2017-10-09 12:00:00	MSFT	Stock	76.29	76.44	76.27	76.39	461309.0
2017-10-09 12:30:00	MSFT	Stock	76.395	76.55	76.39	76.54	598770.0
2017-10-09 13:00:00	MSFT	Stock	76.535	76.55	76.41	76.43	378507.0
2017-10-09 13:30:00	MSFT	Stock	76.43	76.47	76.39	76.43	421628.0
2017-10-09 14:00:00	MSFT	Stock	76.425	76.51	76.39	76.43	527480.0
2017-10-09 14:30:00	MSFT	Stock	76.43	76.45	76.29	76.29	482617.0
2017-10-09 15:00:00	MSFT	Stock	76.29	76.35	76.225	76.34	592063.0
2017-10-09 15:30:00	MSFT	Stock	76.345	76.35	76.18	76.3	1830903.0
2017-10-09 16:00:00	MSFT	Stock	76.3	76.32	76.28	76.28	1345313.0

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

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