PREVIEW / stock_30min / 2017-11-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-07.parquet
  size:    1.7 MB
  rows:    83,375
  symbols: 2,949

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-07 04:00:00	AAPL	Stock	43.55	43.625	43.55	43.6125	3200.0
2017-11-07 04:30:00	AAPL	Stock	43.6	43.6	43.575	43.5875	12132.0
2017-11-07 05:00:00	AAPL	Stock	43.595	43.595	43.595	43.595	800.0
2017-11-07 05:30:00	AAPL	Stock	43.4675	43.4675	43.4675	43.4675	1200.0
2017-11-07 06:00:00	AAPL	Stock	43.5	43.575	43.5	43.5275	5460.0
2017-11-07 06:30:00	AAPL	Stock	43.525	43.55	43.525	43.55	20868.0
2017-11-07 07:00:00	AAPL	Stock	43.5125	43.5625	43.5075	43.55	45996.0
2017-11-07 07:30:00	AAPL	Stock	43.55	43.5625	43.4725	43.485	78908.0
2017-11-07 08:00:00	AAPL	Stock	43.485	43.75	43.4775	43.5475	352520.0
2017-11-07 08:30:00	AAPL	Stock	43.55	43.55	43.5	43.5325	122428.0
2017-11-07 09:00:00	AAPL	Stock	43.515	43.525	43.45	43.4775	228304.0
2017-11-07 09:30:00	AAPL	Stock	43.4775	43.8125	43.4	43.7225	21100244.0
2017-11-07 10:00:00	AAPL	Stock	43.725	43.7975	43.505	43.675	9825156.0
2017-11-07 10:30:00	AAPL	Stock	43.675	43.725	43.5525	43.6475	6488304.0
2017-11-07 11:00:00	AAPL	Stock	43.65	43.77	43.605	43.6448	5261852.0
2017-11-07 11:30:00	AAPL	Stock	43.645	43.785	43.59	43.6158	5543884.0
2017-11-07 12:00:00	AAPL	Stock	43.6248	43.675	43.5075	43.6025	5528244.0
2017-11-07 12:30:00	AAPL	Stock	43.6	43.6825	43.5725	43.6805	3401604.0
2017-11-07 13:00:00	AAPL	Stock	43.6775	43.7425	43.6475	43.67	3748896.0
2017-11-07 13:30:00	AAPL	Stock	43.675	43.69	43.6125	43.6375	2785100.0
2017-11-07 14:00:00	AAPL	Stock	43.635	43.6425	43.565	43.621	2973020.0
2017-11-07 14:30:00	AAPL	Stock	43.621	43.6675	43.5975	43.646	2531396.0
2017-11-07 15:00:00	AAPL	Stock	43.6462	43.6662	43.6025	43.63	2653236.0
2017-11-07 15:30:00	AAPL	Stock	43.63	43.7025	43.63	43.6975	6883476.0
2017-11-07 16:00:00	AAPL	Stock	43.7025	43.72	43.6612	43.705	7595272.0
2017-11-07 16:30:00	AAPL	Stock	43.6975	43.71	43.6775	43.6825	42708.0
2017-11-07 17:00:00	AAPL	Stock	43.6875	43.7	43.675	43.69	32364.0
2017-11-07 17:30:00	AAPL	Stock	43.6825	43.6825	43.655	43.655	14356.0
2017-11-07 18:00:00	AAPL	Stock	43.6525	43.6625	43.6325	43.6475	17488.0
2017-11-07 18:30:00	AAPL	Stock	43.6375	43.6575	43.58	43.58	31908.0
2017-11-07 19:00:00	AAPL	Stock	43.59	43.625	43.5825	43.6025	12200.0
2017-11-07 19:30:00	AAPL	Stock	43.62	43.62	43.59	43.6	10876.0
2017-11-07 05:30:00	MSFT	Stock	84.89	84.93	84.89	84.93	2432.0
2017-11-07 06:00:00	MSFT	Stock	85.0	85.0	84.8	84.97	3871.0
2017-11-07 06:30:00	MSFT	Stock	84.81	84.81	84.81	84.81	355.0
2017-11-07 07:00:00	MSFT	Stock	84.82	84.82	84.8	84.8	4892.0
2017-11-07 07:30:00	MSFT	Stock	84.75	84.75	84.7	84.7	2265.0
2017-11-07 08:00:00	MSFT	Stock	84.81	84.81	84.62	84.8	6437.0
2017-11-07 08:30:00	MSFT	Stock	84.75	84.8	84.75	84.8	2550.0
2017-11-07 09:00:00	MSFT	Stock	84.75	84.8	84.75	84.77	9088.0
2017-11-07 09:30:00	MSFT	Stock	84.76	84.9	84.33	84.33	1921315.0
2017-11-07 10:00:00	MSFT	Stock	84.33	84.48	84.21	84.21	1330541.0
2017-11-07 10:30:00	MSFT	Stock	84.21	84.3	84.07	84.13	969370.0
2017-11-07 11:00:00	MSFT	Stock	84.14	84.24	84.07	84.11	711657.0
2017-11-07 11:30:00	MSFT	Stock	84.105	84.17	83.98	84.0	1002384.0
2017-11-07 12:00:00	MSFT	Stock	84.0	84.11	83.93	84.037	811813.0
2017-11-07 12:30:00	MSFT	Stock	84.035	84.175	84.01	84.14	484384.0
2017-11-07 13:00:00	MSFT	Stock	84.14	84.276	84.1	84.165	681562.0
2017-11-07 13:30:00	MSFT	Stock	84.162	84.19	84.02	84.027	449817.0
2017-11-07 14:00:00	MSFT	Stock	84.025	84.125	83.97	84.01	802504.0

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

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