PREVIEW / stock_30min / 2018-11-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-08.parquet
  size:    1.7 MB
  rows:    83,772
  symbols: 2,748

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
2018-11-08 04:00:00	AAPL	Stock	52.595	52.595	52.3775	52.3775	14656.0
2018-11-08 04:30:00	AAPL	Stock	52.3	52.35	52.26	52.275	32380.0
2018-11-08 05:00:00	AAPL	Stock	52.2775	52.34	52.15	52.16	52576.0
2018-11-08 05:30:00	AAPL	Stock	52.125	52.175	52.105	52.13	14212.0
2018-11-08 06:00:00	AAPL	Stock	52.17	52.275	52.105	52.245	58316.0
2018-11-08 06:30:00	AAPL	Stock	52.2	52.2725	52.155	52.2725	107460.0
2018-11-08 07:00:00	AAPL	Stock	52.25	52.335	52.2375	52.295	92468.0
2018-11-08 07:30:00	AAPL	Stock	52.275	52.4025	52.275	52.395	87704.0
2018-11-08 08:00:00	AAPL	Stock	52.2675	52.4	52.2348	52.295	209480.0
2018-11-08 08:30:00	AAPL	Stock	52.32	52.385	52.275	52.35	264440.0
2018-11-08 09:00:00	AAPL	Stock	52.3325	52.4975	52.275	52.4975	513444.0
2018-11-08 09:30:00	AAPL	Stock	52.485	52.53	51.945	52.1338	17864896.0
2018-11-08 10:00:00	AAPL	Stock	52.13	52.205	51.8625	51.9325	7321364.0
2018-11-08 10:30:00	AAPL	Stock	51.93	52.0525	51.785	51.908	6001644.0
2018-11-08 11:00:00	AAPL	Stock	51.9175	51.9742	51.7975	51.8705	4613488.0
2018-11-08 11:30:00	AAPL	Stock	51.8725	51.93	51.6875	51.82	6003284.0
2018-11-08 12:00:00	AAPL	Stock	51.8225	51.99	51.76	51.905	4203056.0
2018-11-08 12:30:00	AAPL	Stock	51.905	51.978	51.885	51.9225	2295168.0
2018-11-08 13:00:00	AAPL	Stock	51.9225	52.0125	51.8875	51.8975	2468112.0
2018-11-08 13:30:00	AAPL	Stock	51.8948	52.03	51.8382	52.0265	2324028.0
2018-11-08 14:00:00	AAPL	Stock	52.0275	52.1875	51.875	51.985	5735064.0
2018-11-08 14:30:00	AAPL	Stock	51.9875	52.035	51.8475	51.98	4766172.0
2018-11-08 15:00:00	AAPL	Stock	51.98	52.06	51.8775	51.975	4244648.0
2018-11-08 15:30:00	AAPL	Stock	51.9825	52.14	51.9275	52.1225	9024408.0
2018-11-08 16:00:00	AAPL	Stock	52.1225	52.125	51.905	51.965	8141240.0
2018-11-08 16:30:00	AAPL	Stock	51.9875	52.1225	51.9575	51.975	152184.0
2018-11-08 17:00:00	AAPL	Stock	51.96	51.975	51.8875	51.94	52704.0
2018-11-08 17:30:00	AAPL	Stock	51.9475	51.95	51.895	51.9125	18448.0
2018-11-08 18:00:00	AAPL	Stock	51.9325	51.9625	51.9025	51.9125	23616.0
2018-11-08 18:30:00	AAPL	Stock	51.9025	51.9375	51.85	51.915	74648.0
2018-11-08 19:00:00	AAPL	Stock	51.915	51.975	51.8825	51.975	30572.0
2018-11-08 19:30:00	AAPL	Stock	51.975	52.05	51.75	51.8125	115108.0
2018-11-08 04:00:00	MSFT	Stock	112.1	112.1	112.1	112.1	200.0
2018-11-08 04:30:00	MSFT	Stock	112.0	112.0	111.76	111.76	500.0
2018-11-08 05:00:00	MSFT	Stock	111.5	111.5	111.5	111.5	1689.0
2018-11-08 05:30:00	MSFT	Stock	111.42	111.45	111.42	111.42	500.0
2018-11-08 06:00:00	MSFT	Stock	111.22	111.45	111.22	111.45	2369.0
2018-11-08 06:30:00	MSFT	Stock	111.22	111.4	111.22	111.35	2576.0
2018-11-08 07:00:00	MSFT	Stock	111.36	111.5	111.21	111.5	890.0
2018-11-08 07:30:00	MSFT	Stock	111.68	111.82	111.6	111.69	13873.0
2018-11-08 08:00:00	MSFT	Stock	111.4	111.75	111.23	111.51	9616.0
2018-11-08 08:30:00	MSFT	Stock	111.53	111.74	111.51	111.74	11026.0
2018-11-08 09:00:00	MSFT	Stock	111.61	111.8	111.49	111.8	8732.0
2018-11-08 09:30:00	MSFT	Stock	111.79	112.12	110.98	111.91	3427404.0
2018-11-08 10:00:00	MSFT	Stock	111.91	112.21	111.325	111.395	2192689.0
2018-11-08 10:30:00	MSFT	Stock	111.39	111.77	111.27	111.7	1374328.0
2018-11-08 11:00:00	MSFT	Stock	111.71	111.82	111.22	111.463	1688092.0
2018-11-08 11:30:00	MSFT	Stock	111.47	111.815	111.4	111.515	1098964.0
2018-11-08 12:00:00	MSFT	Stock	111.52	111.56	111.17	111.18	992122.0
2018-11-08 12:30:00	MSFT	Stock	111.185	111.42	111.11	111.35	778775.0

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

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