PREVIEW / stock_30min / 2017-08-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-14.parquet
  size:    1.6 MB
  rows:    81,227
  symbols: 2,994

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-08-14 04:00:00	AAPL	Stock	39.65	39.6625	39.65	39.65	29984.0
2017-08-14 04:30:00	AAPL	Stock	39.65	39.65	39.5875	39.65	38856.0
2017-08-14 05:00:00	AAPL	Stock	39.6525	39.6725	39.65	39.6625	13488.0
2017-08-14 05:30:00	AAPL	Stock	39.675	39.725	39.675	39.7075	18340.0
2017-08-14 06:00:00	AAPL	Stock	39.7	39.7325	39.6725	39.6875	34924.0
2017-08-14 06:30:00	AAPL	Stock	39.7	39.72	39.7	39.705	15016.0
2017-08-14 07:00:00	AAPL	Stock	39.7125	39.785	39.7125	39.785	132036.0
2017-08-14 07:30:00	AAPL	Stock	39.75	39.75	39.69	39.72	63052.0
2017-08-14 08:00:00	AAPL	Stock	39.7175	39.7875	39.6275	39.7625	330188.0
2017-08-14 08:30:00	AAPL	Stock	39.7575	39.765	39.72	39.7375	203856.0
2017-08-14 09:00:00	AAPL	Stock	39.75	39.865	39.725	39.8475	394296.0
2017-08-14 09:30:00	AAPL	Stock	39.8325	39.9075	39.6875	39.816	15606680.0
2017-08-14 10:00:00	AAPL	Stock	39.815	39.9325	39.8013	39.815	6599148.0
2017-08-14 10:30:00	AAPL	Stock	39.815	39.9	39.8125	39.875	4478160.0
2017-08-14 11:00:00	AAPL	Stock	39.8755	39.8768	39.7875	39.86	4056420.0
2017-08-14 11:30:00	AAPL	Stock	39.8625	39.875	39.8	39.8295	2855816.0
2017-08-14 12:00:00	AAPL	Stock	39.83	39.855	39.77	39.7905	2527176.0
2017-08-14 12:30:00	AAPL	Stock	39.7895	39.8425	39.7625	39.835	2311732.0
2017-08-14 13:00:00	AAPL	Stock	39.8375	39.984	39.8075	39.9725	6561936.0
2017-08-14 13:30:00	AAPL	Stock	39.9725	40.01	39.935	39.975	5153524.0
2017-08-14 14:00:00	AAPL	Stock	39.975	40.0375	39.9575	39.9775	4041292.0
2017-08-14 14:30:00	AAPL	Stock	39.975	39.9963	39.865	39.9012	3819856.0
2017-08-14 15:00:00	AAPL	Stock	39.9002	39.974	39.8875	39.9725	3578336.0
2017-08-14 15:30:00	AAPL	Stock	39.9725	40.0525	39.935	39.945	10180180.0
2017-08-14 16:00:00	AAPL	Stock	39.9475	40.025	39.9475	40.0	7974980.0
2017-08-14 16:30:00	AAPL	Stock	39.9875	40.02	39.9625	40.0	116768.0
2017-08-14 17:00:00	AAPL	Stock	40.0175	40.025	40.0125	40.025	58696.0
2017-08-14 17:30:00	AAPL	Stock	40.015	40.0225	40.0025	40.005	22444.0
2017-08-14 18:00:00	AAPL	Stock	40.0	40.0125	39.975	39.975	34404.0
2017-08-14 18:30:00	AAPL	Stock	39.975	40.0	39.975	39.975	31976.0
2017-08-14 19:00:00	AAPL	Stock	39.975	40.0	39.975	39.9875	22616.0
2017-08-14 19:30:00	AAPL	Stock	39.9925	40.035	39.9775	40.035	55444.0
2017-08-14 04:00:00	MSFT	Stock	72.71	73.13	72.71	73.13	200.0
2017-08-14 07:00:00	MSFT	Stock	73.0	73.0	73.0	73.0	1925.0
2017-08-14 07:30:00	MSFT	Stock	73.0	73.06	72.95	73.06	2046.0
2017-08-14 08:00:00	MSFT	Stock	73.14	73.18	73.02	73.06	6080.0
2017-08-14 08:30:00	MSFT	Stock	73.06	73.15	73.02	73.1	7836.0
2017-08-14 09:00:00	MSFT	Stock	73.1	73.15	73.06	73.15	5423.0
2017-08-14 09:30:00	MSFT	Stock	73.06	73.54	72.95	73.32	2776627.0
2017-08-14 10:00:00	MSFT	Stock	73.32	73.54	73.32	73.444	1254353.0
2017-08-14 10:30:00	MSFT	Stock	73.44	73.67	73.41	73.535	1121400.0
2017-08-14 11:00:00	MSFT	Stock	73.53	73.61	73.49	73.555	780463.0
2017-08-14 11:30:00	MSFT	Stock	73.56	73.6	73.47	73.5	784443.0
2017-08-14 12:00:00	MSFT	Stock	73.5	73.6	73.48	73.535	590678.0
2017-08-14 12:30:00	MSFT	Stock	73.53	73.585	73.49	73.56	596861.0
2017-08-14 13:00:00	MSFT	Stock	73.57	73.7	73.57	73.62	589474.0
2017-08-14 13:30:00	MSFT	Stock	73.62	73.67	73.56	73.63	742870.0
2017-08-14 14:00:00	MSFT	Stock	73.625	73.72	73.58	73.605	816126.0
2017-08-14 14:30:00	MSFT	Stock	73.6	73.665	73.525	73.59	997178.0
2017-08-14 15:00:00	MSFT	Stock	73.6	73.61	73.47	73.575	868931.0

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

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