PREVIEW / stock_30min / 2018-01-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-23.parquet
  size:    1.7 MB
  rows:    84,461
  symbols: 2,894

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-01-23 04:00:00	AAPL	Stock	44.45	44.5	44.4475	44.45	32012.0
2018-01-23 04:30:00	AAPL	Stock	44.48	44.48	44.475	44.475	2172.0
2018-01-23 05:00:00	AAPL	Stock	44.4325	44.45	44.4325	44.45	1600.0
2018-01-23 05:30:00	AAPL	Stock	44.45	44.475	44.4125	44.4125	11144.0
2018-01-23 06:00:00	AAPL	Stock	44.47	44.475	44.325	44.325	34792.0
2018-01-23 06:30:00	AAPL	Stock	44.35	44.3875	44.315	44.3875	10000.0
2018-01-23 07:00:00	AAPL	Stock	44.35	44.45	44.35	44.42	50624.0
2018-01-23 07:30:00	AAPL	Stock	44.45	44.495	44.4375	44.44	57996.0
2018-01-23 08:00:00	AAPL	Stock	44.4375	44.4875	44.345	44.4125	190192.0
2018-01-23 08:30:00	AAPL	Stock	44.415	44.4375	44.365	44.365	205364.0
2018-01-23 09:00:00	AAPL	Stock	44.38	44.415	44.285	44.3025	227968.0
2018-01-23 09:30:00	AAPL	Stock	44.325	44.635	44.2075	44.495	16270652.0
2018-01-23 10:00:00	AAPL	Stock	44.4975	44.5625	44.4375	44.525	8644528.0
2018-01-23 10:30:00	AAPL	Stock	44.525	44.6875	44.4875	44.6475	7400736.0
2018-01-23 11:00:00	AAPL	Stock	44.6475	44.71	44.635	44.6862	5321252.0
2018-01-23 11:30:00	AAPL	Stock	44.6888	44.755	44.62	44.625	5428068.0
2018-01-23 12:00:00	AAPL	Stock	44.625	44.7125	44.6175	44.6948	3070768.0
2018-01-23 12:30:00	AAPL	Stock	44.6948	44.745	44.6875	44.704	2702724.0
2018-01-23 13:00:00	AAPL	Stock	44.7038	44.7822	44.6825	44.775	2985508.0
2018-01-23 13:30:00	AAPL	Stock	44.777	44.8428	44.7735	44.83	4039120.0
2018-01-23 14:00:00	AAPL	Stock	44.837	44.86	44.375	44.5875	14950724.0
2018-01-23 14:30:00	AAPL	Stock	44.5848	44.6125	44.255	44.2625	12744264.0
2018-01-23 15:00:00	AAPL	Stock	44.265	44.43	44.205	44.425	9442096.0
2018-01-23 15:30:00	AAPL	Stock	44.425	44.4375	44.2175	44.24	13107228.0
2018-01-23 16:00:00	AAPL	Stock	44.2425	44.2675	44.175	44.2075	9771456.0
2018-01-23 16:30:00	AAPL	Stock	44.2	44.26	44.125	44.175	449632.0
2018-01-23 17:00:00	AAPL	Stock	44.1725	44.1925	44.15	44.155	43204.0
2018-01-23 17:30:00	AAPL	Stock	44.175	44.1925	44.145	44.175	31896.0
2018-01-23 18:00:00	AAPL	Stock	44.18	44.2	44.18	44.2	26680.0
2018-01-23 18:30:00	AAPL	Stock	44.2	44.2475	44.2	44.2075	41300.0
2018-01-23 19:00:00	AAPL	Stock	44.225	44.2475	44.225	44.2425	34720.0
2018-01-23 19:30:00	AAPL	Stock	44.2475	44.3	44.23	44.3	41140.0
2018-01-23 04:00:00	MSFT	Stock	91.94	91.94	91.94	91.94	119.0
2018-01-23 05:00:00	MSFT	Stock	91.94	92.0	91.9	92.0	3494.0
2018-01-23 05:30:00	MSFT	Stock	92.0	92.0	92.0	92.0	1816.0
2018-01-23 06:00:00	MSFT	Stock	91.9	91.9	91.81	91.81	4466.0
2018-01-23 07:00:00	MSFT	Stock	91.98	92.01	91.98	92.0	635.0
2018-01-23 07:30:00	MSFT	Stock	92.0	92.09	91.9	92.0	9768.0
2018-01-23 08:00:00	MSFT	Stock	92.0	92.05	91.75	91.8	12976.0
2018-01-23 08:30:00	MSFT	Stock	91.78	91.97	91.67	91.67	23527.0
2018-01-23 09:00:00	MSFT	Stock	91.65	91.9	91.65	91.84	5541.0
2018-01-23 09:30:00	MSFT	Stock	91.9	92.3	91.64	91.83	3275719.0
2018-01-23 10:00:00	MSFT	Stock	91.83	91.95	91.54	91.93	1764679.0
2018-01-23 10:30:00	MSFT	Stock	91.94	92.07	91.89	92.0	1147353.0
2018-01-23 11:00:00	MSFT	Stock	92.0	92.07	91.85	91.92	1298895.0
2018-01-23 11:30:00	MSFT	Stock	91.93	91.99	91.79	91.81	860995.0
2018-01-23 12:00:00	MSFT	Stock	91.816	91.865	91.575	91.74	1070146.0
2018-01-23 12:30:00	MSFT	Stock	91.73	91.78	91.61	91.64	704469.0
2018-01-23 13:00:00	MSFT	Stock	91.64	91.84	91.63	91.825	630435.0
2018-01-23 13:30:00	MSFT	Stock	91.83	91.99	91.83	91.96	683969.0

> showing 50 of 84,461 rows — these rows as CSV

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