PREVIEW / stock_30min / 2017-09-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-12.parquet
  size:    1.6 MB
  rows:    81,836
  symbols: 2,973

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-12 04:00:00	AAPL	Stock	40.6125	40.6125	40.5525	40.595	5248.0
2017-09-12 04:30:00	AAPL	Stock	40.645	40.645	40.625	40.625	1200.0
2017-09-12 05:00:00	AAPL	Stock	40.625	40.6575	40.625	40.6575	18356.0
2017-09-12 05:30:00	AAPL	Stock	40.74	40.8675	40.74	40.825	15560.0
2017-09-12 06:00:00	AAPL	Stock	40.85	40.87	40.765	40.7875	79516.0
2017-09-12 06:30:00	AAPL	Stock	40.7975	40.8	40.7125	40.725	76588.0
2017-09-12 07:00:00	AAPL	Stock	40.715	40.85	40.68	40.825	192624.0
2017-09-12 07:30:00	AAPL	Stock	40.8225	40.8225	40.7125	40.75	241752.0
2017-09-12 08:00:00	AAPL	Stock	40.7525	40.8475	40.375	40.665	691112.0
2017-09-12 08:30:00	AAPL	Stock	40.665	40.7125	40.63	40.6875	369000.0
2017-09-12 09:00:00	AAPL	Stock	40.6875	40.72	40.63	40.6575	444732.0
2017-09-12 09:30:00	AAPL	Stock	40.6525	40.6975	40.0975	40.1875	25914836.0
2017-09-12 10:00:00	AAPL	Stock	40.1838	40.305	40.0775	40.238	12161348.0
2017-09-12 10:30:00	AAPL	Stock	40.24	40.3025	40.175	40.2425	7174140.0
2017-09-12 11:00:00	AAPL	Stock	40.2408	40.4125	40.2175	40.39	6778356.0
2017-09-12 11:30:00	AAPL	Stock	40.3925	40.4175	40.2375	40.2575	6093216.0
2017-09-12 12:00:00	AAPL	Stock	40.26	40.3225	40.165	40.2325	4971548.0
2017-09-12 12:30:00	AAPL	Stock	40.2325	40.3625	40.2325	40.2925	6361608.0
2017-09-12 13:00:00	AAPL	Stock	40.2925	40.5575	40.2875	40.5525	17938104.0
2017-09-12 13:30:00	AAPL	Stock	40.55	40.99	40.5275	40.7075	39246760.0
2017-09-12 14:00:00	AAPL	Stock	40.7105	40.9175	40.4075	40.49	34215896.0
2017-09-12 14:30:00	AAPL	Stock	40.4855	40.575	39.8675	39.8875	44727552.0
2017-09-12 15:00:00	AAPL	Stock	39.8875	40.1925	39.6925	40.15	27267808.0
2017-09-12 15:30:00	AAPL	Stock	40.15	40.25	40.065	40.2125	20166808.0
2017-09-12 16:00:00	AAPL	Stock	40.2125	40.2425	40.1875	40.225	6314272.0
2017-09-12 16:30:00	AAPL	Stock	40.215	40.2325	40.2	40.2125	164028.0
2017-09-12 17:00:00	AAPL	Stock	40.21	40.225	40.2	40.205	105112.0
2017-09-12 17:30:00	AAPL	Stock	40.2025	40.215	40.1	40.1125	142172.0
2017-09-12 18:00:00	AAPL	Stock	40.125	40.15	40.125	40.14	54100.0
2017-09-12 18:30:00	AAPL	Stock	40.1625	40.1975	40.135	40.1875	28912.0
2017-09-12 19:00:00	AAPL	Stock	40.2	40.24	40.19	40.225	138568.0
2017-09-12 19:30:00	AAPL	Stock	40.2325	40.245	40.215	40.245	123380.0
2017-09-12 06:30:00	MSFT	Stock	75.0	75.0	75.0	75.0	100.0
2017-09-12 07:30:00	MSFT	Stock	74.97	74.97	74.97	74.97	100.0
2017-09-12 08:00:00	MSFT	Stock	74.96	74.96	74.76	74.76	3221.0
2017-09-12 09:00:00	MSFT	Stock	74.92	74.95	74.74	74.74	12120.0
2017-09-12 09:30:00	MSFT	Stock	74.72	75.24	74.72	74.92	2349756.0
2017-09-12 10:00:00	MSFT	Stock	74.91	74.93	74.51	74.64	945113.0
2017-09-12 10:30:00	MSFT	Stock	74.64	74.65	74.46	74.6	820417.0
2017-09-12 11:00:00	MSFT	Stock	74.59	74.79	74.58	74.63	751286.0
2017-09-12 11:30:00	MSFT	Stock	74.64	74.66	74.54	74.59	601074.0
2017-09-12 12:00:00	MSFT	Stock	74.59	74.65	74.52	74.53	495757.0
2017-09-12 12:30:00	MSFT	Stock	74.53	74.6	74.46	74.555	417183.0
2017-09-12 13:00:00	MSFT	Stock	74.55	74.59	74.44	74.47	399837.0
2017-09-12 13:30:00	MSFT	Stock	74.466	74.57	74.44	74.499	409434.0
2017-09-12 14:00:00	MSFT	Stock	74.5	74.61	74.5	74.57	494559.0
2017-09-12 14:30:00	MSFT	Stock	74.56	74.59	74.37	74.51	684157.0
2017-09-12 15:00:00	MSFT	Stock	74.51	74.59	74.48	74.565	646717.0
2017-09-12 15:30:00	MSFT	Stock	74.565	74.68	74.525	74.67	2034414.0
2017-09-12 16:00:00	MSFT	Stock	74.68	74.74	74.68	74.74	1859037.0

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

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