PREVIEW / stock_30min / 2016-04-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-27.parquet
  size:    1.6 MB
  rows:    82,265
  symbols: 3,327

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-04-27 04:00:00	AAPL	Stock	24.6875	24.6875	24.185	24.25	249052.0
2016-04-27 04:30:00	AAPL	Stock	24.2525	24.2875	24.25	24.28	164332.0
2016-04-27 05:00:00	AAPL	Stock	24.2725	24.275	24.2	24.2	118424.0
2016-04-27 05:30:00	AAPL	Stock	24.225	24.225	24.1675	24.1875	88592.0
2016-04-27 06:00:00	AAPL	Stock	24.18	24.1975	24.0875	24.105	373684.0
2016-04-27 06:30:00	AAPL	Stock	24.0875	24.185	24.05	24.145	404480.0
2016-04-27 07:00:00	AAPL	Stock	24.1375	24.1725	24.07	24.09	395120.0
2016-04-27 07:30:00	AAPL	Stock	24.09	24.155	23.895	23.95	2495652.0
2016-04-27 08:00:00	AAPL	Stock	23.95	24.1875	23.9125	23.995	3853180.0
2016-04-27 08:30:00	AAPL	Stock	23.9975	24.0275	23.92	24.0225	4189048.0
2016-04-27 09:00:00	AAPL	Stock	24.015	24.1375	23.9775	23.995	5523080.0
2016-04-27 09:30:00	AAPL	Stock	24.0	24.6775	23.92	24.1575	111632624.0
2016-04-27 10:00:00	AAPL	Stock	24.1592	24.295	24.135	24.2225	41665420.0
2016-04-27 10:30:00	AAPL	Stock	24.2225	24.4925	24.2025	24.45	38953392.0
2016-04-27 11:00:00	AAPL	Stock	24.4513	24.625	24.41	24.6248	31413784.0
2016-04-27 11:30:00	AAPL	Stock	24.6225	24.675	24.5125	24.5975	27263368.0
2016-04-27 12:00:00	AAPL	Stock	24.5975	24.6075	24.425	24.5262	20056388.0
2016-04-27 12:30:00	AAPL	Stock	24.5275	24.54	24.4375	24.445	12311192.0
2016-04-27 13:00:00	AAPL	Stock	24.445	24.45	24.3638	24.425	15116332.0
2016-04-27 13:30:00	AAPL	Stock	24.4225	24.495	24.42	24.44	10107040.0
2016-04-27 14:00:00	AAPL	Stock	24.4422	24.5475	24.3775	24.4625	18894200.0
2016-04-27 14:30:00	AAPL	Stock	24.465	24.465	24.3575	24.3875	14266896.0
2016-04-27 15:00:00	AAPL	Stock	24.385	24.4925	24.375	24.4338	17416736.0
2016-04-27 15:30:00	AAPL	Stock	24.4338	24.455	24.36	24.4525	25296488.0
2016-04-27 16:00:00	AAPL	Stock	24.455	24.558	24.385	24.4375	15468964.0
2016-04-27 16:30:00	AAPL	Stock	24.4375	24.4575	24.4225	24.45	272696.0
2016-04-27 17:00:00	AAPL	Stock	24.4525	24.4925	24.445	24.47	216796.0
2016-04-27 17:30:00	AAPL	Stock	24.475	24.475	24.465	24.475	132176.0
2016-04-27 18:00:00	AAPL	Stock	24.475	24.4925	24.475	24.485	138484.0
2016-04-27 18:30:00	AAPL	Stock	24.485	24.4925	24.475	24.475	25592.0
2016-04-27 19:00:00	AAPL	Stock	24.485	24.4925	24.48	24.48	34996.0
2016-04-27 19:30:00	AAPL	Stock	24.48	24.5	24.475	24.5	75904.0
2016-04-27 05:00:00	MSFT	Stock	51.31	51.31	51.31	51.31	900.0
2016-04-27 06:30:00	MSFT	Stock	51.2	51.2	51.2	51.2	100.0
2016-04-27 07:00:00	MSFT	Stock	51.29	51.3	51.29	51.3	5800.0
2016-04-27 07:30:00	MSFT	Stock	51.22	51.28	51.22	51.24	1300.0
2016-04-27 08:00:00	MSFT	Stock	51.22	51.32	51.2	51.32	3600.0
2016-04-27 08:30:00	MSFT	Stock	52.12	52.12	51.22	51.35	4882.0
2016-04-27 09:00:00	MSFT	Stock	51.34	51.49	51.28	51.48	42943.0
2016-04-27 09:30:00	MSFT	Stock	51.48	51.5	51.07	51.109	4433784.0
2016-04-27 10:00:00	MSFT	Stock	51.1	51.15	50.75	50.766	3873966.0
2016-04-27 10:30:00	MSFT	Stock	50.76	50.96	50.55	50.805	3769724.0
2016-04-27 11:00:00	MSFT	Stock	50.81	51.035	50.69	50.975	2511487.0
2016-04-27 11:30:00	MSFT	Stock	50.98	51.005	50.89	50.97	1876191.0
2016-04-27 12:00:00	MSFT	Stock	50.97	50.97	50.7	50.935	1904452.0
2016-04-27 12:30:00	MSFT	Stock	50.94	50.96	50.79	50.873	1486402.0
2016-04-27 13:00:00	MSFT	Stock	50.875	50.9	50.58	50.665	2116330.0
2016-04-27 13:30:00	MSFT	Stock	50.66	50.85	50.64	50.7	1689571.0
2016-04-27 14:00:00	MSFT	Stock	50.715	50.94	50.56	50.76	3052812.0
2016-04-27 14:30:00	MSFT	Stock	50.77	50.785	50.62	50.7	2516231.0

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

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