PREVIEW / stock_30min / 2016-01-26

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-26.parquet
  size:    1.6 MB
  rows:    82,757
  symbols: 3,361

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-01-26 04:00:00	AAPL	Stock	24.7625	24.7625	24.625	24.6475	9668.0
2016-01-26 04:30:00	AAPL	Stock	24.7125	24.7125	24.7125	24.7125	512.0
2016-01-26 05:00:00	AAPL	Stock	24.7425	24.7625	24.7425	24.76	5600.0
2016-01-26 05:30:00	AAPL	Stock	24.765	24.845	24.765	24.83	16404.0
2016-01-26 06:00:00	AAPL	Stock	24.8125	24.925	24.7925	24.85	27704.0
2016-01-26 06:30:00	AAPL	Stock	24.85	25.0	24.84	24.975	112016.0
2016-01-26 07:00:00	AAPL	Stock	24.975	25.0625	24.97	25.02	123616.0
2016-01-26 07:30:00	AAPL	Stock	25.005	25.0225	24.9625	24.9775	75296.0
2016-01-26 08:00:00	AAPL	Stock	24.9775	25.015	24.8875	24.96	503484.0
2016-01-26 08:30:00	AAPL	Stock	24.9625	25.025	24.95	24.9925	330380.0
2016-01-26 09:00:00	AAPL	Stock	25.0	25.0575	24.875	24.9825	916144.0
2016-01-26 09:30:00	AAPL	Stock	24.98	25.0125	24.5175	24.6225	29523364.0
2016-01-26 10:00:00	AAPL	Stock	24.618	24.8475	24.58	24.8135	19454588.0
2016-01-26 10:30:00	AAPL	Stock	24.815	25.0325	24.7838	24.9325	18329860.0
2016-01-26 11:00:00	AAPL	Stock	24.9325	25.0625	24.9275	25.0278	13595780.0
2016-01-26 11:30:00	AAPL	Stock	25.027	25.1975	24.9982	25.085	14771092.0
2016-01-26 12:00:00	AAPL	Stock	25.0875	25.195	25.075	25.1	10762332.0
2016-01-26 12:30:00	AAPL	Stock	25.1	25.128	25.0525	25.0975	7488292.0
2016-01-26 13:00:00	AAPL	Stock	25.0962	25.125	24.9775	25.0575	10504648.0
2016-01-26 13:30:00	AAPL	Stock	25.055	25.0875	25.0038	25.03	8315368.0
2016-01-26 14:00:00	AAPL	Stock	25.03	25.0512	24.995	25.0312	10926916.0
2016-01-26 14:30:00	AAPL	Stock	25.0312	25.22	25.03	25.09	18821140.0
2016-01-26 15:00:00	AAPL	Stock	25.09	25.1015	24.76	24.8675	22549708.0
2016-01-26 15:30:00	AAPL	Stock	24.867	25.01	24.815	24.995	36489832.0
2016-01-26 16:00:00	AAPL	Stock	24.9988	25.108	24.5	24.6725	8300820.0
2016-01-26 16:30:00	AAPL	Stock	24.7075	25.875	24.2225	24.9025	26086864.0
2016-01-26 17:00:00	AAPL	Stock	24.9025	24.9875	24.65	24.7025	7075584.0
2016-01-26 17:30:00	AAPL	Stock	24.7075	24.7475	24.32	24.4125	5414128.0
2016-01-26 18:00:00	AAPL	Stock	24.4	24.6	24.335	24.4375	2907296.0
2016-01-26 18:30:00	AAPL	Stock	24.4375	24.4625	24.29	24.345	995208.0
2016-01-26 19:00:00	AAPL	Stock	24.33	24.3475	24.2775	24.325	693696.0
2016-01-26 19:30:00	AAPL	Stock	24.32	24.375	24.32	24.355	1053548.0
2016-01-26 04:00:00	MSFT	Stock	51.3	51.3	51.3	51.3	900.0
2016-01-26 06:30:00	MSFT	Stock	51.75	51.77	51.74	51.77	1400.0
2016-01-26 07:30:00	MSFT	Stock	51.9	51.9	51.89	51.9	2200.0
2016-01-26 08:00:00	MSFT	Stock	51.85	51.9	51.75	51.9	28548.0
2016-01-26 08:30:00	MSFT	Stock	51.95	52.0	51.79	51.79	8649.0
2016-01-26 09:00:00	MSFT	Stock	51.9	52.01	51.78	51.86	119846.0
2016-01-26 09:30:00	MSFT	Stock	51.79	52.28	51.55	51.71	4024055.0
2016-01-26 10:00:00	MSFT	Stock	51.72	52.21	51.61	52.08	2752532.0
2016-01-26 10:30:00	MSFT	Stock	52.08	52.277	52.06	52.14	1692244.0
2016-01-26 11:00:00	MSFT	Stock	52.13	52.42	52.12	52.415	1620740.0
2016-01-26 11:30:00	MSFT	Stock	52.415	52.42	52.09	52.14	1440285.0
2016-01-26 12:00:00	MSFT	Stock	52.13	52.44	52.11	52.37	1339765.0
2016-01-26 12:30:00	MSFT	Stock	52.373	52.38	52.16	52.22	1091054.0
2016-01-26 13:00:00	MSFT	Stock	52.22	52.43	52.11	52.345	1157625.0
2016-01-26 13:30:00	MSFT	Stock	52.344	52.37	52.27	52.31	1173109.0
2016-01-26 14:00:00	MSFT	Stock	52.315	52.33	52.09	52.15	1404705.0
2016-01-26 14:30:00	MSFT	Stock	52.15	52.23	52.06	52.13	1240730.0
2016-01-26 15:00:00	MSFT	Stock	52.13	52.21	51.98	52.11	1795159.0

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

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