PREVIEW / stock_30min / 2016-06-03

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-03.parquet
  size:    1.6 MB
  rows:    82,038
  symbols: 3,298

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-06-03 05:30:00	AAPL	Stock	24.4875	24.4875	24.4875	24.4875	400.0
2016-06-03 06:00:00	AAPL	Stock	24.5	24.5	24.5	24.5	800.0
2016-06-03 06:30:00	AAPL	Stock	24.475	24.495	24.475	24.495	1660.0
2016-06-03 07:00:00	AAPL	Stock	24.475	24.475	24.475	24.475	1200.0
2016-06-03 07:30:00	AAPL	Stock	24.49	24.495	24.485	24.4875	17808.0
2016-06-03 08:00:00	AAPL	Stock	24.4875	24.515	24.475	24.49	113448.0
2016-06-03 08:30:00	AAPL	Stock	24.49	24.52	24.3575	24.36	582992.0
2016-06-03 09:00:00	AAPL	Stock	24.365	24.455	24.335	24.455	520204.0
2016-06-03 09:30:00	AAPL	Stock	24.455	24.5675	24.4225	24.4675	18344360.0
2016-06-03 10:00:00	AAPL	Stock	24.4675	24.5125	24.3625	24.4325	12204748.0
2016-06-03 10:30:00	AAPL	Stock	24.43	24.5125	24.405	24.44	9199288.0
2016-06-03 11:00:00	AAPL	Stock	24.44	24.4675	24.4	24.4425	6137992.0
2016-06-03 11:30:00	AAPL	Stock	24.445	24.541	24.4375	24.5275	6725284.0
2016-06-03 12:00:00	AAPL	Stock	24.53	24.55	24.5025	24.5188	4811828.0
2016-06-03 12:30:00	AAPL	Stock	24.5175	24.53	24.4645	24.466	3745912.0
2016-06-03 13:00:00	AAPL	Stock	24.465	24.4975	24.445	24.4638	3577792.0
2016-06-03 13:30:00	AAPL	Stock	24.4675	24.509	24.455	24.5	2979752.0
2016-06-03 14:00:00	AAPL	Stock	24.5	24.5	24.425	24.475	4651896.0
2016-06-03 14:30:00	AAPL	Stock	24.475	24.515	24.45	24.485	4910732.0
2016-06-03 15:00:00	AAPL	Stock	24.4825	24.512	24.4825	24.505	4972496.0
2016-06-03 15:30:00	AAPL	Stock	24.505	24.525	24.46	24.4775	9544036.0
2016-06-03 16:00:00	AAPL	Stock	24.48	24.495	24.475	24.48	5916332.0
2016-06-03 16:30:00	AAPL	Stock	24.48	24.5	24.4775	24.5	85656.0
2016-06-03 17:00:00	AAPL	Stock	24.4975	24.4975	24.48	24.48	21576.0
2016-06-03 17:30:00	AAPL	Stock	24.4775	24.48	24.4775	24.48	10432.0
2016-06-03 18:00:00	AAPL	Stock	24.49	24.5	24.485	24.485	11788.0
2016-06-03 18:30:00	AAPL	Stock	24.4875	24.4875	24.48	24.48	1600.0
2016-06-03 19:00:00	AAPL	Stock	24.48	24.49	24.48	24.48	6400.0
2016-06-03 19:30:00	AAPL	Stock	24.4775	24.48	24.4775	24.48	4192.0
2016-06-03 08:00:00	MSFT	Stock	52.43	52.43	52.43	52.43	100.0
2016-06-03 08:30:00	MSFT	Stock	52.3	52.3	52.1	52.15	8198.0
2016-06-03 09:00:00	MSFT	Stock	52.16	52.38	52.1	52.38	138830.0
2016-06-03 09:30:00	MSFT	Stock	52.31	52.42	51.89	51.89	2636957.0
2016-06-03 10:00:00	MSFT	Stock	51.89	51.89	51.6	51.75	2396268.0
2016-06-03 10:30:00	MSFT	Stock	51.75	51.92	51.715	51.83	1200911.0
2016-06-03 11:00:00	MSFT	Stock	51.84	51.875	51.7	51.76	1001766.0
2016-06-03 11:30:00	MSFT	Stock	51.76	51.995	51.74	51.955	1239641.0
2016-06-03 12:00:00	MSFT	Stock	51.96	51.985	51.78	51.875	734720.0
2016-06-03 12:30:00	MSFT	Stock	51.87	51.93	51.73	51.74	756508.0
2016-06-03 13:00:00	MSFT	Stock	51.74	51.82	51.68	51.74	786416.0
2016-06-03 13:30:00	MSFT	Stock	51.75	51.82	51.71	51.76	848970.0
2016-06-03 14:00:00	MSFT	Stock	51.76	51.81	51.71	51.785	803497.0
2016-06-03 14:30:00	MSFT	Stock	51.78	51.92	51.765	51.865	1419184.0
2016-06-03 15:00:00	MSFT	Stock	51.86	51.93	51.85	51.895	1189633.0
2016-06-03 15:30:00	MSFT	Stock	51.895	51.9	51.7	51.79	3622722.0
2016-06-03 16:00:00	MSFT	Stock	51.79	51.9	51.75	51.78	2982475.0
2016-06-03 16:30:00	MSFT	Stock	51.78	51.78	51.7	51.75	6236.0
2016-06-03 17:00:00	MSFT	Stock	51.79	51.79	51.71	51.71	142401.0
2016-06-03 17:30:00	MSFT	Stock	51.75	51.75	51.74	51.74	800.0
2016-06-03 19:00:00	MSFT	Stock	51.72	51.74	51.72	51.74	514.0

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

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