PREVIEW / stock_30min / 2017-05-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-09.parquet
  size:    1.6 MB
  rows:    82,364
  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-09 04:00:00	AAPL	Stock	38.3125	38.375	38.3	38.3	14172.0
2017-05-09 04:30:00	AAPL	Stock	38.35	38.375	38.325	38.375	12644.0
2017-05-09 05:00:00	AAPL	Stock	38.37	38.3925	38.35	38.375	19740.0
2017-05-09 05:30:00	AAPL	Stock	38.3975	38.4375	38.3975	38.425	12140.0
2017-05-09 06:00:00	AAPL	Stock	38.42	38.42	38.375	38.3875	21032.0
2017-05-09 06:30:00	AAPL	Stock	38.3875	38.3975	38.355	38.37	19844.0
2017-05-09 07:00:00	AAPL	Stock	38.3675	38.385	38.35	38.3625	60720.0
2017-05-09 07:30:00	AAPL	Stock	38.375	38.375	38.3325	38.345	30884.0
2017-05-09 08:00:00	AAPL	Stock	38.3375	38.4125	38.1675	38.41	442556.0
2017-05-09 08:30:00	AAPL	Stock	38.41	38.48	38.3975	38.48	849024.0
2017-05-09 09:00:00	AAPL	Stock	38.4825	38.485	38.3975	38.475	930748.0
2017-05-09 09:30:00	AAPL	Stock	38.4675	38.67	38.3775	38.52	32780232.0
2017-05-09 10:00:00	AAPL	Stock	38.52	38.72	38.515	38.594	16685944.0
2017-05-09 10:30:00	AAPL	Stock	38.594	38.685	38.5775	38.644	9016468.0
2017-05-09 11:00:00	AAPL	Stock	38.6428	38.6475	38.5075	38.585	9024468.0
2017-05-09 11:30:00	AAPL	Stock	38.585	38.5898	38.429	38.485	8919364.0
2017-05-09 12:00:00	AAPL	Stock	38.4868	38.585	38.4825	38.565	6145672.0
2017-05-09 12:30:00	AAPL	Stock	38.5638	38.6325	38.5625	38.5875	5125520.0
2017-05-09 13:00:00	AAPL	Stock	38.5865	38.6125	38.4825	38.492	3928300.0
2017-05-09 13:30:00	AAPL	Stock	38.49	38.5145	38.435	38.47	5284208.0
2017-05-09 14:00:00	AAPL	Stock	38.4725	38.4875	38.3625	38.3875	6427356.0
2017-05-09 14:30:00	AAPL	Stock	38.3875	38.465	38.375	38.4325	4182288.0
2017-05-09 15:00:00	AAPL	Stock	38.4312	38.525	38.43	38.4963	5725400.0
2017-05-09 15:30:00	AAPL	Stock	38.495	38.5125	38.405	38.495	10877492.0
2017-05-09 16:00:00	AAPL	Stock	38.4925	38.5	38.465	38.4925	11597496.0
2017-05-09 16:30:00	AAPL	Stock	38.49	38.5225	38.49	38.4925	116952.0
2017-05-09 17:00:00	AAPL	Stock	38.4925	38.52	38.4925	38.52	57224.0
2017-05-09 17:30:00	AAPL	Stock	38.515	38.5175	38.4825	38.4875	523816.0
2017-05-09 18:00:00	AAPL	Stock	38.47	38.4875	38.4125	38.42	55088.0
2017-05-09 18:30:00	AAPL	Stock	38.415	38.425	38.375	38.375	56984.0
2017-05-09 19:00:00	AAPL	Stock	38.395	38.4	38.375	38.3825	45716.0
2017-05-09 19:30:00	AAPL	Stock	38.375	38.3875	38.325	38.325	134968.0
2017-05-09 04:30:00	MSFT	Stock	68.97	68.97	68.97	68.97	200.0
2017-05-09 06:30:00	MSFT	Stock	68.97	68.97	68.97	68.97	135.0
2017-05-09 07:30:00	MSFT	Stock	68.98	69.01	68.98	69.01	4435.0
2017-05-09 08:00:00	MSFT	Stock	69.04	69.04	69.03	69.03	610.0
2017-05-09 08:30:00	MSFT	Stock	69.02	69.02	68.94	68.94	3040.0
2017-05-09 09:00:00	MSFT	Stock	68.95	69.01	68.79	68.79	12736.0
2017-05-09 09:30:00	MSFT	Stock	68.86	69.07	68.68	69.07	2287432.0
2017-05-09 10:00:00	MSFT	Stock	69.07	69.28	69.06	69.154	1959603.0
2017-05-09 10:30:00	MSFT	Stock	69.16	69.25	69.1	69.125	1406107.0
2017-05-09 11:00:00	MSFT	Stock	69.125	69.15	68.96	69.075	914165.0
2017-05-09 11:30:00	MSFT	Stock	69.075	69.1	68.93	68.97	1037926.0
2017-05-09 12:00:00	MSFT	Stock	68.97	69.005	68.93	68.94	555192.0
2017-05-09 12:30:00	MSFT	Stock	68.935	68.98	68.88	68.95	500615.0
2017-05-09 13:00:00	MSFT	Stock	68.95	68.97	68.88	68.9	712529.0
2017-05-09 13:30:00	MSFT	Stock	68.9	68.94	68.88	68.915	576687.0
2017-05-09 14:00:00	MSFT	Stock	68.92	69.015	68.86	69.0	1324033.0
2017-05-09 14:30:00	MSFT	Stock	69.0	69.07	68.99	69.005	1229933.0
2017-05-09 15:00:00	MSFT	Stock	69.01	69.065	68.991	69.06	1024874.0

> showing 50 of 82,364 rows — these rows as CSV

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