PREVIEW / stock_30min / 2016-02-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-04.parquet
  size:    1.6 MB
  rows:    82,552
  symbols: 3,360

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-02-04 04:00:00	AAPL	Stock	24.0025	24.0025	23.97	23.97	6376.0
2016-02-04 04:30:00	AAPL	Stock	24.02	24.1	24.0	24.0975	5160.0
2016-02-04 05:00:00	AAPL	Stock	24.06	24.06	24.06	24.06	400.0
2016-02-04 06:00:00	AAPL	Stock	24.06	24.06	24.06	24.06	3600.0
2016-02-04 06:30:00	AAPL	Stock	24.0075	24.01	24.0075	24.01	4000.0
2016-02-04 07:00:00	AAPL	Stock	23.975	24.0	23.915	23.915	16892.0
2016-02-04 07:30:00	AAPL	Stock	23.95	23.95	23.91	23.91	6204.0
2016-02-04 08:00:00	AAPL	Stock	23.9575	23.9875	23.785	23.82	214916.0
2016-02-04 08:30:00	AAPL	Stock	23.825	23.9575	23.7625	23.785	351824.0
2016-02-04 09:00:00	AAPL	Stock	23.8	23.985	23.8	23.97	251248.0
2016-02-04 09:30:00	AAPL	Stock	23.965	24.0925	23.7975	23.9725	16293792.0
2016-02-04 10:00:00	AAPL	Stock	23.9675	24.3325	23.8575	24.2625	17998204.0
2016-02-04 10:30:00	AAPL	Stock	24.2638	24.3312	24.2025	24.285	12305588.0
2016-02-04 11:00:00	AAPL	Stock	24.2825	24.2925	24.0125	24.0125	11931708.0
2016-02-04 11:30:00	AAPL	Stock	24.0125	24.075	23.865	23.91	10419864.0
2016-02-04 12:00:00	AAPL	Stock	23.9078	24.1225	23.8875	24.02	8709552.0
2016-02-04 12:30:00	AAPL	Stock	24.02	24.1775	23.97	24.09	6825148.0
2016-02-04 13:00:00	AAPL	Stock	24.0925	24.1528	24.0575	24.0688	7003680.0
2016-02-04 13:30:00	AAPL	Stock	24.07	24.13	23.9675	24.0318	6602200.0
2016-02-04 14:00:00	AAPL	Stock	24.035	24.045	23.95	23.9773	6276760.0
2016-02-04 14:30:00	AAPL	Stock	23.975	24.0975	23.935	24.09	7452404.0
2016-02-04 15:00:00	AAPL	Stock	24.0875	24.115	23.9675	24.041	10428068.0
2016-02-04 15:30:00	AAPL	Stock	24.0425	24.175	24.0	24.15	15569748.0
2016-02-04 16:00:00	AAPL	Stock	24.15	24.17	24.1	24.1	7813224.0
2016-02-04 16:30:00	AAPL	Stock	24.1	24.1625	24.0672	24.125	465468.0
2016-02-04 17:00:00	AAPL	Stock	24.1125	24.125	24.0875	24.1025	36516.0
2016-02-04 17:30:00	AAPL	Stock	24.105	24.14	24.105	24.13	37804.0
2016-02-04 18:00:00	AAPL	Stock	24.125	24.125	24.1025	24.1025	35800.0
2016-02-04 18:30:00	AAPL	Stock	24.1025	24.1225	24.1025	24.1225	6400.0
2016-02-04 19:00:00	AAPL	Stock	24.125	24.1375	24.12	24.1375	25024.0
2016-02-04 19:30:00	AAPL	Stock	24.1375	24.1375	24.12	24.125	20052.0
2016-02-04 06:30:00	MSFT	Stock	52.26	52.26	52.26	52.26	500.0
2016-02-04 07:00:00	MSFT	Stock	52.26	52.26	52.26	52.26	400.0
2016-02-04 07:30:00	MSFT	Stock	52.05	52.05	52.04	52.05	1200.0
2016-02-04 08:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	215.0
2016-02-04 08:30:00	MSFT	Stock	51.81	51.92	51.66	51.75	17492.0
2016-02-04 09:00:00	MSFT	Stock	51.88	52.03	51.87	52.03	15622.0
2016-02-04 09:30:00	MSFT	Stock	52.03	52.1	51.4	51.63	5159110.0
2016-02-04 10:00:00	MSFT	Stock	51.64	52.42	51.37	52.4	4903340.0
2016-02-04 10:30:00	MSFT	Stock	52.407	52.81	52.32	52.5	5661354.0
2016-02-04 11:00:00	MSFT	Stock	52.5	52.52	51.77	51.87	2432401.0
2016-02-04 11:30:00	MSFT	Stock	51.88	52.02	51.48	51.53	2514993.0
2016-02-04 12:00:00	MSFT	Stock	51.535	52.02	51.5	51.73	1986838.0
2016-02-04 12:30:00	MSFT	Stock	51.73	52.01	51.64	51.805	1530961.0
2016-02-04 13:00:00	MSFT	Stock	51.8	52.055	51.76	51.94	1464874.0
2016-02-04 13:30:00	MSFT	Stock	51.94	52.03	51.64	51.67	1642108.0
2016-02-04 14:00:00	MSFT	Stock	51.68	51.79	51.46	51.51	2548529.0
2016-02-04 14:30:00	MSFT	Stock	51.505	51.87	51.41	51.85	2812492.0
2016-02-04 15:00:00	MSFT	Stock	51.859	52.025	51.561	51.815	2620695.0
2016-02-04 15:30:00	MSFT	Stock	51.82	52.02	51.74	52.0	3893568.0

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

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