PREVIEW / stock_30min / 2017-11-29

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-29.parquet
  size:    1.7 MB
  rows:    83,984
  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-11-29 05:30:00	AAPL	Stock	43.185	43.185	43.125	43.125	2372.0
2017-11-29 06:00:00	AAPL	Stock	43.1875	43.2075	43.1875	43.2025	2848.0
2017-11-29 07:00:00	AAPL	Stock	43.27	43.3375	43.27	43.3325	23728.0
2017-11-29 07:30:00	AAPL	Stock	43.3	43.3	43.275	43.275	25500.0
2017-11-29 08:00:00	AAPL	Stock	43.335	43.335	43.2525	43.275	63164.0
2017-11-29 08:30:00	AAPL	Stock	43.255	43.255	43.1775	43.2225	98804.0
2017-11-29 09:00:00	AAPL	Stock	43.2325	43.2375	43.135	43.1375	118408.0
2017-11-29 09:30:00	AAPL	Stock	43.1575	43.23	42.92	42.9505	14461316.0
2017-11-29 10:00:00	AAPL	Stock	42.95	42.9575	42.2325	42.485	20608700.0
2017-11-29 10:30:00	AAPL	Stock	42.4875	42.5875	42.1825	42.2	15298844.0
2017-11-29 11:00:00	AAPL	Stock	42.2012	42.4068	42.1275	42.28	11834428.0
2017-11-29 11:30:00	AAPL	Stock	42.2775	42.38	41.815	41.8475	14567504.0
2017-11-29 12:00:00	AAPL	Stock	41.845	42.16	41.79	42.11	13294792.0
2017-11-29 12:30:00	AAPL	Stock	42.105	42.3375	42.0825	42.1575	8655016.0
2017-11-29 13:00:00	AAPL	Stock	42.1545	42.365	42.0625	42.3362	6326752.0
2017-11-29 13:30:00	AAPL	Stock	42.34	42.3475	42.105	42.1175	6167100.0
2017-11-29 14:00:00	AAPL	Stock	42.115	42.265	42.1	42.175	5415260.0
2017-11-29 14:30:00	AAPL	Stock	42.1775	42.355	42.1375	42.2375	4545852.0
2017-11-29 15:00:00	AAPL	Stock	42.24	42.3025	42.1225	42.2625	5699124.0
2017-11-29 15:30:00	AAPL	Stock	42.2638	42.41	42.235	42.3725	10665116.0
2017-11-29 16:00:00	AAPL	Stock	42.3475	42.37	42.275	42.3325	8449092.0
2017-11-29 16:30:00	AAPL	Stock	42.3	42.3062	42.2875	42.3	109064.0
2017-11-29 17:00:00	AAPL	Stock	42.3	42.3175	42.295	42.3125	35524.0
2017-11-29 17:30:00	AAPL	Stock	42.37	42.37	42.275	42.3075	63800.0
2017-11-29 18:00:00	AAPL	Stock	42.3	42.3125	42.2875	42.31	20600.0
2017-11-29 18:30:00	AAPL	Stock	42.2775	42.31	42.2775	42.31	28156.0
2017-11-29 19:00:00	AAPL	Stock	42.295	42.3075	42.28	42.3075	12972.0
2017-11-29 19:30:00	AAPL	Stock	42.295	42.3125	42.2575	42.275	14736.0
2017-11-29 07:00:00	MSFT	Stock	85.0	85.0	85.0	85.0	838.0
2017-11-29 07:30:00	MSFT	Stock	84.8	84.99	84.78	84.99	1430.0
2017-11-29 08:00:00	MSFT	Stock	84.997	84.997	84.78	84.85	2414.0
2017-11-29 08:30:00	MSFT	Stock	84.95	84.95	84.66	84.78	7324.0
2017-11-29 09:00:00	MSFT	Stock	84.71	84.83	84.71	84.83	8739.0
2017-11-29 09:30:00	MSFT	Stock	84.82	84.917	84.42	84.82	2995794.0
2017-11-29 10:00:00	MSFT	Stock	84.83	84.84	83.97	84.1	2796950.0
2017-11-29 10:30:00	MSFT	Stock	84.09	84.32	83.67	83.805	2194228.0
2017-11-29 11:00:00	MSFT	Stock	83.81	84.07	83.675	83.755	1583601.0
2017-11-29 11:30:00	MSFT	Stock	83.75	83.76	83.38	83.52	1828969.0
2017-11-29 12:00:00	MSFT	Stock	83.51	83.82	83.36	83.69	1759910.0
2017-11-29 12:30:00	MSFT	Stock	83.69	83.81	83.41	83.44	936832.0
2017-11-29 13:00:00	MSFT	Stock	83.44	83.8	83.43	83.785	759879.0
2017-11-29 13:30:00	MSFT	Stock	83.785	83.899	83.47	83.52	903464.0
2017-11-29 14:00:00	MSFT	Stock	83.515	83.67	83.42	83.51	1270809.0
2017-11-29 14:30:00	MSFT	Stock	83.52	83.615	83.42	83.54	933831.0
2017-11-29 15:00:00	MSFT	Stock	83.54	83.54	83.175	83.35	1321641.0
2017-11-29 15:30:00	MSFT	Stock	83.35	83.5	83.29	83.335	2519680.0
2017-11-29 16:00:00	MSFT	Stock	83.34	83.34	83.3	83.3	2411030.0
2017-11-29 16:30:00	MSFT	Stock	83.32	83.32	83.32	83.32	190.0
2017-11-29 17:30:00	MSFT	Stock	83.4	83.43	83.35	83.43	4485.0
2017-11-29 18:00:00	MSFT	Stock	83.35	83.44	83.35	83.44	599.0

> showing 50 of 83,984 rows — these rows as CSV

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