PREVIEW / stock_30min / 2018-07-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-11.parquet
  size:    1.7 MB
  rows:    83,227
  symbols: 2,816

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-07-11 04:00:00	AAPL	Stock	47.15	47.15	47.125	47.125	9668.0
2018-07-11 04:30:00	AAPL	Stock	47.125	47.125	47.0025	47.0025	12292.0
2018-07-11 05:00:00	AAPL	Stock	47.0075	47.0075	47.0075	47.0075	400.0
2018-07-11 05:30:00	AAPL	Stock	47.0625	47.0625	47.0575	47.0625	15640.0
2018-07-11 06:00:00	AAPL	Stock	47.1175	47.1725	47.1175	47.1725	15200.0
2018-07-11 06:30:00	AAPL	Stock	47.1625	47.1625	47.1375	47.1375	816.0
2018-07-11 07:00:00	AAPL	Stock	47.1475	47.235	47.1475	47.15	57276.0
2018-07-11 07:30:00	AAPL	Stock	47.155	47.1875	47.1375	47.1875	57148.0
2018-07-11 08:00:00	AAPL	Stock	47.2072	47.2875	47.1625	47.1875	387368.0
2018-07-11 08:30:00	AAPL	Stock	47.1875	47.2375	47.1125	47.13	313268.0
2018-07-11 09:00:00	AAPL	Stock	47.1375	47.1775	47.0875	47.1075	205340.0
2018-07-11 09:30:00	AAPL	Stock	47.125	47.445	47.075	47.2375	9174912.0
2018-07-11 10:00:00	AAPL	Stock	47.2375	47.35	47.1575	47.2425	5757212.0
2018-07-11 10:30:00	AAPL	Stock	47.2475	47.2625	47.1625	47.24	3516724.0
2018-07-11 11:00:00	AAPL	Stock	47.2418	47.2745	47.07	47.1025	4427892.0
2018-07-11 11:30:00	AAPL	Stock	47.1025	47.1025	46.98	46.9925	4174188.0
2018-07-11 12:00:00	AAPL	Stock	46.9918	47.05	46.945	47.011	3418796.0
2018-07-11 12:30:00	AAPL	Stock	47.01	47.1088	46.98	46.9988	2280928.0
2018-07-11 13:00:00	AAPL	Stock	47.0025	47.13	46.955	47.1065	2654824.0
2018-07-11 13:30:00	AAPL	Stock	47.11	47.1425	47.0225	47.035	1837084.0
2018-07-11 14:00:00	AAPL	Stock	47.0325	47.085	46.9625	47.0725	2470068.0
2018-07-11 14:30:00	AAPL	Stock	47.075	47.0925	47.0175	47.0525	1907328.0
2018-07-11 15:00:00	AAPL	Stock	47.0525	47.095	46.9625	46.9812	3621312.0
2018-07-11 15:30:00	AAPL	Stock	46.9825	47.02	46.9025	46.9825	9568336.0
2018-07-11 16:00:00	AAPL	Stock	46.97	47.03	46.97	46.9875	10403096.0
2018-07-11 16:30:00	AAPL	Stock	46.97	47.0175	46.97	47.0	59724.0
2018-07-11 17:00:00	AAPL	Stock	47.0025	47.015	46.955	46.9575	45132.0
2018-07-11 17:30:00	AAPL	Stock	46.9675	46.9725	46.9675	46.9725	1600.0
2018-07-11 18:00:00	AAPL	Stock	46.965	46.9825	46.96	46.96	25752.0
2018-07-11 18:30:00	AAPL	Stock	46.9575	46.985	46.95	46.975	28608.0
2018-07-11 19:00:00	AAPL	Stock	46.9875	47.0025	46.9875	46.995	1704.0
2018-07-11 19:30:00	AAPL	Stock	46.9775	47.0	46.9775	47.0	19836.0
2018-07-11 04:30:00	MSFT	Stock	101.25	101.25	101.25	101.25	100.0
2018-07-11 06:30:00	MSFT	Stock	101.35	101.35	101.35	101.35	100.0
2018-07-11 07:00:00	MSFT	Stock	101.35	101.5	101.35	101.4	1851.0
2018-07-11 07:30:00	MSFT	Stock	101.4	101.5	101.36	101.5	400.0
2018-07-11 08:00:00	MSFT	Stock	101.4	101.65	101.36	101.65	3678.0
2018-07-11 08:30:00	MSFT	Stock	101.64	101.69	101.24	101.37	8423.0
2018-07-11 09:00:00	MSFT	Stock	101.5	101.59	101.11	101.11	18036.0
2018-07-11 09:30:00	MSFT	Stock	101.11	101.8	101.1	101.64	1944505.0
2018-07-11 10:00:00	MSFT	Stock	101.64	102.2	101.6	102.13	1375169.0
2018-07-11 10:30:00	MSFT	Stock	102.14	102.25	101.98	102.12	1418143.0
2018-07-11 11:00:00	MSFT	Stock	102.13	102.34	101.95	101.975	1183353.0
2018-07-11 11:30:00	MSFT	Stock	101.975	102.04	101.7	101.795	1081892.0
2018-07-11 12:00:00	MSFT	Stock	101.81	101.86	101.58	101.76	670238.0
2018-07-11 12:30:00	MSFT	Stock	101.765	102.02	101.75	101.92	590680.0
2018-07-11 13:00:00	MSFT	Stock	101.92	102.23	101.821	102.195	806656.0
2018-07-11 13:30:00	MSFT	Stock	102.19	102.27	101.9	101.93	767423.0
2018-07-11 14:00:00	MSFT	Stock	101.93	102.09	101.7	102.065	724692.0
2018-07-11 14:30:00	MSFT	Stock	102.07	102.22	102.06	102.11	623947.0

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

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