PREVIEW / stock_30min / 2017-12-05

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-05.parquet
  size:    1.7 MB
  rows:    85,455
  symbols: 2,936

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-05 04:00:00	AAPL	Stock	42.3625	42.3625	42.255	42.255	13628.0
2017-12-05 04:30:00	AAPL	Stock	42.295	42.34	42.295	42.34	14412.0
2017-12-05 05:00:00	AAPL	Stock	42.3	42.3	42.19	42.19	19196.0
2017-12-05 05:30:00	AAPL	Stock	42.225	42.225	42.1475	42.1475	18064.0
2017-12-05 06:00:00	AAPL	Stock	42.15	42.15	42.1125	42.1475	10888.0
2017-12-05 06:30:00	AAPL	Stock	42.1775	42.25	42.1775	42.25	14232.0
2017-12-05 07:00:00	AAPL	Stock	42.2875	42.37	42.265	42.3125	100548.0
2017-12-05 07:30:00	AAPL	Stock	42.335	42.525	42.335	42.5225	91520.0
2017-12-05 08:00:00	AAPL	Stock	42.25	42.5775	42.25	42.4725	181952.0
2017-12-05 08:30:00	AAPL	Stock	42.4825	42.565	42.415	42.44	102040.0
2017-12-05 09:00:00	AAPL	Stock	42.4375	42.495	42.26	42.305	164832.0
2017-12-05 09:30:00	AAPL	Stock	42.3325	42.5675	42.1	42.505	17820704.0
2017-12-05 10:00:00	AAPL	Stock	42.5125	42.6475	42.45	42.5925	9317868.0
2017-12-05 10:30:00	AAPL	Stock	42.59	42.835	42.5525	42.721	9553324.0
2017-12-05 11:00:00	AAPL	Stock	42.7222	42.88	42.7222	42.815	5874284.0
2017-12-05 11:30:00	AAPL	Stock	42.815	42.8535	42.7075	42.7158	4915744.0
2017-12-05 12:00:00	AAPL	Stock	42.7125	42.74	42.64	42.6775	4150608.0
2017-12-05 12:30:00	AAPL	Stock	42.6775	42.74	42.565	42.6025	3162640.0
2017-12-05 13:00:00	AAPL	Stock	42.6	42.755	42.5625	42.735	3426928.0
2017-12-05 13:30:00	AAPL	Stock	42.7375	42.7885	42.705	42.728	2346204.0
2017-12-05 14:00:00	AAPL	Stock	42.729	42.7325	42.4925	42.5505	4888100.0
2017-12-05 14:30:00	AAPL	Stock	42.5525	42.5525	42.3925	42.4382	5119392.0
2017-12-05 15:00:00	AAPL	Stock	42.435	42.575	42.4275	42.525	5624168.0
2017-12-05 15:30:00	AAPL	Stock	42.525	42.54	42.3925	42.4125	9310708.0
2017-12-05 16:00:00	AAPL	Stock	42.41	42.465	42.375	42.375	7979352.0
2017-12-05 16:30:00	AAPL	Stock	42.375	42.4125	42.375	42.4	24964.0
2017-12-05 17:00:00	AAPL	Stock	42.4	42.4075	42.38	42.38	22500.0
2017-12-05 17:30:00	AAPL	Stock	42.3825	42.4625	42.3825	42.4625	75944.0
2017-12-05 18:00:00	AAPL	Stock	42.475	42.4975	42.4325	42.4975	8736.0
2017-12-05 18:30:00	AAPL	Stock	42.4875	42.5	42.4725	42.4725	11160.0
2017-12-05 19:00:00	AAPL	Stock	42.5	42.5125	42.475	42.49	12188.0
2017-12-05 19:30:00	AAPL	Stock	42.5	42.515	42.5	42.5025	9404.0
2017-12-05 04:00:00	MSFT	Stock	81.08	81.08	81.0	81.0	215.0
2017-12-05 04:30:00	MSFT	Stock	80.99	80.99	80.99	80.99	120.0
2017-12-05 06:00:00	MSFT	Stock	80.6	80.67	80.52	80.52	2813.0
2017-12-05 06:30:00	MSFT	Stock	80.53	80.88	80.53	80.88	448.0
2017-12-05 07:00:00	MSFT	Stock	80.9	81.1	80.8	81.1	6100.0
2017-12-05 07:30:00	MSFT	Stock	81.08	81.27	81.08	81.27	1298.0
2017-12-05 08:00:00	MSFT	Stock	81.2	81.5	80.88	81.43	16820.0
2017-12-05 08:30:00	MSFT	Stock	81.38	81.4	81.24	81.25	6063.0
2017-12-05 09:00:00	MSFT	Stock	81.21	81.5	81.02	81.38	50441.0
2017-12-05 09:30:00	MSFT	Stock	81.38	82.19	80.98	82.04	4799512.0
2017-12-05 10:00:00	MSFT	Stock	82.02	82.19	81.591	81.98	2130135.0
2017-12-05 10:30:00	MSFT	Stock	81.98	82.178	81.92	82.145	1616337.0
2017-12-05 11:00:00	MSFT	Stock	82.15	82.68	82.15	82.54	1626517.0
2017-12-05 11:30:00	MSFT	Stock	82.55	82.67	82.12	82.137	1378109.0
2017-12-05 12:00:00	MSFT	Stock	82.138	82.235	82.06	82.18	811716.0
2017-12-05 12:30:00	MSFT	Stock	82.18	82.31	81.94	82.0	722259.0
2017-12-05 13:00:00	MSFT	Stock	82.005	82.15	81.77	82.09	868418.0
2017-12-05 13:30:00	MSFT	Stock	82.1	82.207	82.015	82.14	518243.0

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

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