PREVIEW / stock_30min / 2017-09-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-25.parquet
  size:    1.6 MB
  rows:    81,778
  symbols: 2,970

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-09-25 04:00:00	AAPL	Stock	37.7475	37.785	37.7025	37.785	3400.0
2017-09-25 04:30:00	AAPL	Stock	37.75	37.75	37.75	37.75	400.0
2017-09-25 05:00:00	AAPL	Stock	37.8	37.8	37.8	37.8	400.0
2017-09-25 05:30:00	AAPL	Stock	37.7625	37.7625	37.725	37.75	6136.0
2017-09-25 06:00:00	AAPL	Stock	37.725	37.725	37.4125	37.575	76936.0
2017-09-25 06:30:00	AAPL	Stock	37.6	37.6625	37.575	37.6525	14344.0
2017-09-25 07:00:00	AAPL	Stock	37.6725	37.78	37.66	37.675	105780.0
2017-09-25 07:30:00	AAPL	Stock	37.6975	37.7325	37.63	37.6425	121764.0
2017-09-25 08:00:00	AAPL	Stock	37.5	38.05	37.4775	37.4975	725116.0
2017-09-25 08:30:00	AAPL	Stock	37.49	37.565	37.4775	37.4925	544424.0
2017-09-25 09:00:00	AAPL	Stock	37.4925	37.5275	37.425	37.495	1427088.0
2017-09-25 09:30:00	AAPL	Stock	37.495	37.8125	37.29	37.785	39607576.0
2017-09-25 10:00:00	AAPL	Stock	37.785	37.9575	37.65	37.7325	15970692.0
2017-09-25 10:30:00	AAPL	Stock	37.7275	37.7475	37.475	37.5135	13518864.0
2017-09-25 11:00:00	AAPL	Stock	37.5175	37.645	37.4225	37.61	11153468.0
2017-09-25 11:30:00	AAPL	Stock	37.6125	37.64	37.48	37.62	7539520.0
2017-09-25 12:00:00	AAPL	Stock	37.62	37.645	37.4805	37.5775	8929324.0
2017-09-25 12:30:00	AAPL	Stock	37.5725	37.7235	37.5425	37.6925	6855188.0
2017-09-25 13:00:00	AAPL	Stock	37.6925	37.7075	37.6275	37.6375	4629120.0
2017-09-25 13:30:00	AAPL	Stock	37.6375	37.71	37.615	37.6625	5047412.0
2017-09-25 14:00:00	AAPL	Stock	37.665	37.705	37.5125	37.5522	5668396.0
2017-09-25 14:30:00	AAPL	Stock	37.55	37.58	37.49	37.565	6350648.0
2017-09-25 15:00:00	AAPL	Stock	37.5675	37.6125	37.5	37.58	8285480.0
2017-09-25 15:30:00	AAPL	Stock	37.5788	37.6475	37.5362	37.64	13190588.0
2017-09-25 16:00:00	AAPL	Stock	37.6325	37.6875	37.6275	37.66	10232464.0
2017-09-25 16:30:00	AAPL	Stock	37.65	37.7025	37.65	37.685	68192.0
2017-09-25 17:00:00	AAPL	Stock	37.685	37.7	37.6375	37.675	238240.0
2017-09-25 17:30:00	AAPL	Stock	37.6525	37.6875	37.6525	37.6875	5872.0
2017-09-25 18:00:00	AAPL	Stock	37.6525	37.675	37.6525	37.675	3960.0
2017-09-25 18:30:00	AAPL	Stock	37.675	37.675	37.6525	37.675	15412.0
2017-09-25 19:00:00	AAPL	Stock	37.6625	37.675	37.6375	37.65	21792.0
2017-09-25 19:30:00	AAPL	Stock	37.6425	37.6725	37.6425	37.6425	17944.0
2017-09-25 07:30:00	MSFT	Stock	74.21	74.21	74.21	74.21	420.0
2017-09-25 08:00:00	MSFT	Stock	74.35	74.35	74.14	74.14	394.0
2017-09-25 08:30:00	MSFT	Stock	74.25	74.25	74.25	74.25	100.0
2017-09-25 09:00:00	MSFT	Stock	74.14	74.24	74.06	74.24	5832.0
2017-09-25 09:30:00	MSFT	Stock	74.09	74.25	73.82	73.86	1548975.0
2017-09-25 10:00:00	MSFT	Stock	73.86	74.0	73.71	73.75	1131771.0
2017-09-25 10:30:00	MSFT	Stock	73.755	73.76	73.1	73.17	1673316.0
2017-09-25 11:00:00	MSFT	Stock	73.17	73.43	73.04	73.33	1313700.0
2017-09-25 11:30:00	MSFT	Stock	73.33	73.38	73.05	73.11	1297044.0
2017-09-25 12:00:00	MSFT	Stock	73.105	73.13	72.92	72.985	1198866.0
2017-09-25 12:30:00	MSFT	Stock	72.99	73.09	72.93	73.033	812389.0
2017-09-25 13:00:00	MSFT	Stock	73.03	73.075	72.97	73.0	856624.0
2017-09-25 13:30:00	MSFT	Stock	73.009	73.15	72.93	73.125	735371.0
2017-09-25 14:00:00	MSFT	Stock	73.125	73.17	72.96	73.0	931567.0
2017-09-25 14:30:00	MSFT	Stock	73.0	73.06	72.92	73.025	970813.0
2017-09-25 15:00:00	MSFT	Stock	73.03	73.19	72.93	73.19	1578793.0
2017-09-25 15:30:00	MSFT	Stock	73.185	73.32	73.04	73.27	3290814.0
2017-09-25 16:00:00	MSFT	Stock	73.26	73.43	73.23	73.3	4802729.0

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

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