PREVIEW / stock_30min / 2016-08-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-15.parquet
  size:    1.6 MB
  rows:    82,429
  symbols: 3,280

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
2016-08-15 04:30:00	AAPL	Stock	27.1175	27.12	27.1175	27.12	4000.0
2016-08-15 05:00:00	AAPL	Stock	27.1025	27.1025	27.0825	27.0825	2256.0
2016-08-15 06:30:00	AAPL	Stock	27.1075	27.1075	27.1025	27.1025	4144.0
2016-08-15 07:00:00	AAPL	Stock	27.12	27.12	27.1025	27.1025	5600.0
2016-08-15 07:30:00	AAPL	Stock	27.1075	27.1175	27.1075	27.1125	8400.0
2016-08-15 08:00:00	AAPL	Stock	27.12	27.12	27.1	27.1	117212.0
2016-08-15 08:30:00	AAPL	Stock	27.1	27.125	27.1	27.1125	111276.0
2016-08-15 09:00:00	AAPL	Stock	27.1075	27.115	27.0375	27.0375	155716.0
2016-08-15 09:30:00	AAPL	Stock	27.035	27.2925	27.02	27.2375	20635420.0
2016-08-15 10:00:00	AAPL	Stock	27.2398	27.3625	27.2375	27.33	10378716.0
2016-08-15 10:30:00	AAPL	Stock	27.33	27.3548	27.295	27.3188	6149888.0
2016-08-15 11:00:00	AAPL	Stock	27.3178	27.385	27.3025	27.3788	5694624.0
2016-08-15 11:30:00	AAPL	Stock	27.3788	27.3788	27.32	27.3298	4487752.0
2016-08-15 12:00:00	AAPL	Stock	27.33	27.35	27.3175	27.34	2935500.0
2016-08-15 12:30:00	AAPL	Stock	27.3388	27.36	27.325	27.3462	2417816.0
2016-08-15 13:00:00	AAPL	Stock	27.3475	27.35	27.3225	27.3258	2789052.0
2016-08-15 13:30:00	AAPL	Stock	27.3275	27.3375	27.2975	27.3188	3569472.0
2016-08-15 14:00:00	AAPL	Stock	27.3175	27.335	27.305	27.3188	3180980.0
2016-08-15 14:30:00	AAPL	Stock	27.3188	27.355	27.3075	27.345	3638116.0
2016-08-15 15:00:00	AAPL	Stock	27.345	27.3625	27.3275	27.361	5678312.0
2016-08-15 15:30:00	AAPL	Stock	27.3612	27.3825	27.3525	27.3775	14621696.0
2016-08-15 16:00:00	AAPL	Stock	27.3775	27.455	27.37	27.4475	7436148.0
2016-08-15 16:30:00	AAPL	Stock	27.4475	27.4525	27.37	27.45	543764.0
2016-08-15 17:00:00	AAPL	Stock	27.45	27.455	27.4325	27.445	87996.0
2016-08-15 17:30:00	AAPL	Stock	27.45	27.45	27.43	27.4425	38320.0
2016-08-15 18:00:00	AAPL	Stock	27.445	27.4875	27.4375	27.4875	61400.0
2016-08-15 18:30:00	AAPL	Stock	27.49	27.4975	27.4825	27.4875	160456.0
2016-08-15 19:00:00	AAPL	Stock	27.4875	27.495	27.4775	27.4825	77732.0
2016-08-15 19:30:00	AAPL	Stock	27.4875	27.4925	27.4775	27.4925	89132.0
2016-08-15 04:00:00	MSFT	Stock	57.94	57.94	57.94	57.94	100.0
2016-08-15 04:30:00	MSFT	Stock	57.97	58.0	57.97	58.0	550.0
2016-08-15 05:00:00	MSFT	Stock	58.03	58.03	58.03	58.03	100.0
2016-08-15 06:00:00	MSFT	Stock	58.06	58.28	58.06	58.28	600.0
2016-08-15 07:00:00	MSFT	Stock	58.02	58.02	58.02	58.02	1000.0
2016-08-15 08:00:00	MSFT	Stock	58.02	58.06	58.02	58.06	790.0
2016-08-15 09:00:00	MSFT	Stock	58.05	58.07	58.02	58.02	9690.0
2016-08-15 09:30:00	MSFT	Stock	58.01	58.3	57.96	58.3	1734642.0
2016-08-15 10:00:00	MSFT	Stock	58.295	58.3	58.11	58.195	1213655.0
2016-08-15 10:30:00	MSFT	Stock	58.195	58.37	58.195	58.365	997134.0
2016-08-15 11:00:00	MSFT	Stock	58.361	58.39	58.305	58.38	1465134.0
2016-08-15 11:30:00	MSFT	Stock	58.38	58.49	58.37	58.475	988538.0
2016-08-15 12:00:00	MSFT	Stock	58.47	58.5	58.44	58.495	777333.0
2016-08-15 12:30:00	MSFT	Stock	58.491	58.5	58.45	58.495	766928.0
2016-08-15 13:00:00	MSFT	Stock	58.49	58.5	58.45	58.484	510748.0
2016-08-15 13:30:00	MSFT	Stock	58.49	58.5	58.43	58.43	535708.0
2016-08-15 14:00:00	MSFT	Stock	58.434	58.44	58.29	58.315	949810.0
2016-08-15 14:30:00	MSFT	Stock	58.315	58.35	58.3	58.33	738363.0
2016-08-15 15:00:00	MSFT	Stock	58.335	58.36	58.2	58.225	1113687.0
2016-08-15 15:30:00	MSFT	Stock	58.23	58.295	58.12	58.13	4018456.0
2016-08-15 16:00:00	MSFT	Stock	58.125	58.21	58.07	58.15	1853881.0

> showing 50 of 82,429 rows — these rows as CSV

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