PREVIEW / stock_30min / 2018-01-31

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-31.parquet
  size:    1.7 MB
  rows:    85,926
  symbols: 2,914

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-31 04:00:00	AAPL	Stock	41.625	41.625	41.4125	41.4575	107596.0
2018-01-31 04:30:00	AAPL	Stock	41.4425	41.4425	41.3875	41.4275	9476.0
2018-01-31 05:00:00	AAPL	Stock	41.415	41.495	41.415	41.475	39224.0
2018-01-31 05:30:00	AAPL	Stock	41.4825	41.4875	41.455	41.455	8972.0
2018-01-31 06:00:00	AAPL	Stock	41.475	41.475	41.4375	41.45	55164.0
2018-01-31 06:30:00	AAPL	Stock	41.4425	41.4625	41.4	41.4625	69452.0
2018-01-31 07:00:00	AAPL	Stock	41.4625	41.5	41.4375	41.5	187316.0
2018-01-31 07:30:00	AAPL	Stock	41.5	41.6225	41.5	41.5675	356140.0
2018-01-31 08:00:00	AAPL	Stock	41.4625	41.9975	41.45	41.6375	915756.0
2018-01-31 08:30:00	AAPL	Stock	41.6375	41.755	41.59	41.6725	320864.0
2018-01-31 09:00:00	AAPL	Stock	41.69	41.7525	41.6625	41.7175	401812.0
2018-01-31 09:30:00	AAPL	Stock	41.7175	42.1105	41.69	41.8975	19694936.0
2018-01-31 10:00:00	AAPL	Stock	41.8925	42.02	41.8478	41.99	8486860.0
2018-01-31 10:30:00	AAPL	Stock	41.99	42.0575	41.84	41.885	6570484.0
2018-01-31 11:00:00	AAPL	Stock	41.8875	41.9275	41.7225	41.725	5840340.0
2018-01-31 11:30:00	AAPL	Stock	41.7225	41.845	41.68	41.6948	4435540.0
2018-01-31 12:00:00	AAPL	Stock	41.6975	41.8125	41.6625	41.76	4623188.0
2018-01-31 12:30:00	AAPL	Stock	41.76	41.7918	41.6725	41.6765	4716908.0
2018-01-31 13:00:00	AAPL	Stock	41.6775	41.775	41.67	41.7665	4367680.0
2018-01-31 13:30:00	AAPL	Stock	41.765	41.79	41.73	41.7572	3101176.0
2018-01-31 14:00:00	AAPL	Stock	41.7575	41.8475	41.625	41.7025	7012260.0
2018-01-31 14:30:00	AAPL	Stock	41.7025	41.792	41.6875	41.7225	6269996.0
2018-01-31 15:00:00	AAPL	Stock	41.7225	41.8675	41.6875	41.8625	6902336.0
2018-01-31 15:30:00	AAPL	Stock	41.8625	41.9138	41.7675	41.8675	14518120.0
2018-01-31 16:00:00	AAPL	Stock	41.8675	41.875	41.68	41.6825	13657144.0
2018-01-31 16:30:00	AAPL	Stock	41.6825	41.8575	41.625	41.6375	303628.0
2018-01-31 17:00:00	AAPL	Stock	41.67	41.6875	41.6375	41.6725	96284.0
2018-01-31 17:30:00	AAPL	Stock	41.675	41.7975	41.67	41.725	287160.0
2018-01-31 18:00:00	AAPL	Stock	41.735	41.8	41.675	41.675	172228.0
2018-01-31 18:30:00	AAPL	Stock	41.675	41.675	41.5825	41.665	81448.0
2018-01-31 19:00:00	AAPL	Stock	41.675	41.6825	41.6	41.625	159344.0
2018-01-31 19:30:00	AAPL	Stock	41.6575	41.715	41.6125	41.715	123672.0
2018-01-31 04:00:00	MSFT	Stock	93.48	93.48	93.4	93.4	2310.0
2018-01-31 04:30:00	MSFT	Stock	93.49	93.55	93.49	93.54	3331.0
2018-01-31 05:00:00	MSFT	Stock	93.53	93.53	93.4	93.4	2796.0
2018-01-31 05:30:00	MSFT	Stock	93.4	93.55	93.4	93.55	2935.0
2018-01-31 06:00:00	MSFT	Stock	93.66	93.82	93.63	93.7	4806.0
2018-01-31 06:30:00	MSFT	Stock	93.62	93.62	93.45	93.49	6541.0
2018-01-31 07:00:00	MSFT	Stock	93.55	93.65	93.45	93.63	6134.0
2018-01-31 07:30:00	MSFT	Stock	93.65	93.7	93.52	93.7	44751.0
2018-01-31 08:00:00	MSFT	Stock	93.55	93.85	92.94	93.64	138746.0
2018-01-31 08:30:00	MSFT	Stock	93.63	93.65	93.5	93.62	30435.0
2018-01-31 09:00:00	MSFT	Stock	93.6	93.94	93.4	93.8	67621.0
2018-01-31 09:30:00	MSFT	Stock	93.75	94.0	93.55	93.751	3597316.0
2018-01-31 10:00:00	MSFT	Stock	93.75	94.0	93.51	93.98	2109982.0
2018-01-31 10:30:00	MSFT	Stock	93.99	94.48	93.96	94.09	2661270.0
2018-01-31 11:00:00	MSFT	Stock	94.09	94.32	93.98	94.03	2024347.0
2018-01-31 11:30:00	MSFT	Stock	94.03	94.18	93.81	93.846	1559715.0
2018-01-31 12:00:00	MSFT	Stock	93.85	94.05	93.81	93.95	1409934.0
2018-01-31 12:30:00	MSFT	Stock	93.95	94.35	93.92	94.25	2077398.0

> showing 50 of 85,926 rows — these rows as CSV

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