PREVIEW / stock_30min / 2017-09-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-14.parquet
  size:    1.6 MB
  rows:    81,886
  symbols: 2,967

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-14 04:00:00	AAPL	Stock	39.8725	39.9225	39.85	39.85	14532.0
2017-09-14 04:30:00	AAPL	Stock	39.85	39.85	39.85	39.85	3540.0
2017-09-14 05:00:00	AAPL	Stock	39.85	39.85	39.85	39.85	2516.0
2017-09-14 05:30:00	AAPL	Stock	39.85	39.85	39.85	39.85	2360.0
2017-09-14 06:00:00	AAPL	Stock	39.85	39.895	39.85	39.85	7124.0
2017-09-14 06:30:00	AAPL	Stock	39.825	39.845	39.825	39.845	3976.0
2017-09-14 07:00:00	AAPL	Stock	39.83	39.83	39.815	39.815	17136.0
2017-09-14 07:30:00	AAPL	Stock	39.8125	39.825	39.7475	39.75	62964.0
2017-09-14 08:00:00	AAPL	Stock	39.8025	39.8425	39.725	39.75	326892.0
2017-09-14 08:30:00	AAPL	Stock	39.75	39.8025	39.715	39.765	260476.0
2017-09-14 09:00:00	AAPL	Stock	39.7825	39.8075	39.75	39.755	237764.0
2017-09-14 09:30:00	AAPL	Stock	39.7475	39.85	39.62	39.7975	14481640.0
2017-09-14 10:00:00	AAPL	Stock	39.7962	39.8472	39.7025	39.74	7104180.0
2017-09-14 10:30:00	AAPL	Stock	39.74	39.7625	39.6975	39.75	4539024.0
2017-09-14 11:00:00	AAPL	Stock	39.75	39.8325	39.7425	39.7825	5141048.0
2017-09-14 11:30:00	AAPL	Stock	39.7812	39.8025	39.72	39.7475	3442352.0
2017-09-14 12:00:00	AAPL	Stock	39.75	39.76	39.6	39.6525	5280792.0
2017-09-14 12:30:00	AAPL	Stock	39.65	39.71	39.605	39.7062	3836568.0
2017-09-14 13:00:00	AAPL	Stock	39.7068	39.7125	39.6675	39.7102	2426124.0
2017-09-14 13:30:00	AAPL	Stock	39.7125	39.73	39.6725	39.685	2708284.0
2017-09-14 14:00:00	AAPL	Stock	39.6875	39.73	39.675	39.6875	2376348.0
2017-09-14 14:30:00	AAPL	Stock	39.69	39.7025	39.65	39.6788	2828244.0
2017-09-14 15:00:00	AAPL	Stock	39.6788	39.6888	39.6125	39.645	4599624.0
2017-09-14 15:30:00	AAPL	Stock	39.6475	39.665	39.5225	39.5675	12421960.0
2017-09-14 16:00:00	AAPL	Stock	39.57	39.575	39.5225	39.56	9650756.0
2017-09-14 16:30:00	AAPL	Stock	39.5525	39.5575	39.5375	39.5375	41980.0
2017-09-14 17:00:00	AAPL	Stock	39.545	39.55	39.5075	39.5125	24752.0
2017-09-14 17:30:00	AAPL	Stock	39.515	39.5275	39.5125	39.515	12872.0
2017-09-14 18:00:00	AAPL	Stock	39.515	39.515	39.4375	39.45	193720.0
2017-09-14 18:30:00	AAPL	Stock	39.4725	39.4725	39.425	39.425	53992.0
2017-09-14 19:00:00	AAPL	Stock	39.4275	39.445	39.42	39.42	30324.0
2017-09-14 19:30:00	AAPL	Stock	39.4375	39.455	39.415	39.4375	100420.0
2017-09-14 07:00:00	MSFT	Stock	75.29	75.29	75.29	75.29	400.0
2017-09-14 07:30:00	MSFT	Stock	75.17	75.17	75.17	75.17	200.0
2017-09-14 08:00:00	MSFT	Stock	75.2	75.2	75.2	75.2	155.0
2017-09-14 08:30:00	MSFT	Stock	75.0	75.0	74.8	74.94	14361.0
2017-09-14 09:00:00	MSFT	Stock	74.93	74.99	74.84	74.99	14313.0
2017-09-14 09:30:00	MSFT	Stock	74.99	75.0	74.52	74.94	1866706.0
2017-09-14 10:00:00	MSFT	Stock	74.935	75.13	74.89	75.08	1273575.0
2017-09-14 10:30:00	MSFT	Stock	75.08	75.42	75.08	75.39	870528.0
2017-09-14 11:00:00	MSFT	Stock	75.385	75.49	75.3	75.37	1000357.0
2017-09-14 11:30:00	MSFT	Stock	75.38	75.42	75.26	75.315	483718.0
2017-09-14 12:00:00	MSFT	Stock	75.315	75.34	75.1	75.155	373664.0
2017-09-14 12:30:00	MSFT	Stock	75.15	75.185	75.08	75.15	390042.0
2017-09-14 13:00:00	MSFT	Stock	75.15	75.155	75.02	75.04	380683.0
2017-09-14 13:30:00	MSFT	Stock	75.04	75.04	74.9	74.91	568537.0
2017-09-14 14:00:00	MSFT	Stock	74.915	75.03	74.895	74.95	454718.0
2017-09-14 14:30:00	MSFT	Stock	74.95	75.04	74.945	74.96	509670.0
2017-09-14 15:00:00	MSFT	Stock	74.96	74.98	74.83	74.865	791624.0
2017-09-14 15:30:00	MSFT	Stock	74.865	74.87	74.7	74.77	2210335.0

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

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