PREVIEW / stock_30min / 2015-01-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-28.parquet
  size:    1.6 MB
  rows:    84,148
  symbols: 3,524

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
2015-01-28 04:00:00	AAPL	Stock	28.87	29.1225	28.87	29.025	182152.0
2015-01-28 04:30:00	AAPL	Stock	29.075	29.1	29.025	29.05	114464.0
2015-01-28 05:00:00	AAPL	Stock	29.0275	29.0925	28.9	28.9	52592.0
2015-01-28 05:30:00	AAPL	Stock	28.975	29.025	28.9325	28.975	35348.0
2015-01-28 06:00:00	AAPL	Stock	29.0	29.2875	29.0	29.2625	478444.0
2015-01-28 06:30:00	AAPL	Stock	29.25	29.36	29.1625	29.275	810736.0
2015-01-28 07:00:00	AAPL	Stock	29.2875	29.72	29.2575	29.7125	2823392.0
2015-01-28 07:30:00	AAPL	Stock	29.7125	29.8125	29.5	29.5075	3018304.0
2015-01-28 08:00:00	AAPL	Stock	29.4875	29.81	28.575	29.475	6939548.0
2015-01-28 08:30:00	AAPL	Stock	29.4625	29.585	29.39	29.4625	6004668.0
2015-01-28 09:00:00	AAPL	Stock	29.4625	29.5025	29.25	29.4	8067476.0
2015-01-28 09:30:00	AAPL	Stock	29.4075	29.5	28.96	29.2788	134113156.0
2015-01-28 10:00:00	AAPL	Stock	29.28	29.53	29.2775	29.4525	57664060.0
2015-01-28 10:30:00	AAPL	Stock	29.4525	29.455	29.03	29.0775	49056416.0
2015-01-28 11:00:00	AAPL	Stock	29.0775	29.1475	28.8775	29.0715	41780068.0
2015-01-28 11:30:00	AAPL	Stock	29.07	29.2375	29.05	29.18	20847076.0
2015-01-28 12:00:00	AAPL	Stock	29.1825	29.354	29.175	29.345	19158016.0
2015-01-28 12:30:00	AAPL	Stock	29.345	29.435	29.335	29.4075	31491548.0
2015-01-28 13:00:00	AAPL	Stock	29.4072	29.41	29.2725	29.3438	17138488.0
2015-01-28 13:30:00	AAPL	Stock	29.3425	29.38	29.3225	29.3662	12328468.0
2015-01-28 14:00:00	AAPL	Stock	29.3675	29.4275	29.1525	29.18	28072512.0
2015-01-28 14:30:00	AAPL	Stock	29.1775	29.33	29.1062	29.2625	19860024.0
2015-01-28 15:00:00	AAPL	Stock	29.2612	29.3175	28.965	29.0325	23813664.0
2015-01-28 15:30:00	AAPL	Stock	29.03	29.0375	28.83	28.83	43481776.0
2015-01-28 16:00:00	AAPL	Stock	28.83	29.3975	28.815	28.89	14526408.0
2015-01-28 16:30:00	AAPL	Stock	28.8875	29.257	28.8025	28.8375	2490420.0
2015-01-28 17:00:00	AAPL	Stock	28.8375	28.875	28.8175	28.8275	218948.0
2015-01-28 17:30:00	AAPL	Stock	28.825	28.85	28.815	28.8425	239548.0
2015-01-28 18:00:00	AAPL	Stock	28.845	28.885	28.8275	28.875	280792.0
2015-01-28 18:30:00	AAPL	Stock	28.8625	28.9	28.8625	28.8975	117828.0
2015-01-28 19:00:00	AAPL	Stock	28.895	28.9375	28.8925	28.93	232432.0
2015-01-28 19:30:00	AAPL	Stock	28.9325	28.935	28.9025	28.9325	174200.0
2015-01-28 04:00:00	MSFT	Stock	43.18	43.19	43.1	43.1	4700.0
2015-01-28 04:30:00	MSFT	Stock	43.1	43.2	43.1	43.2	4800.0
2015-01-28 05:00:00	MSFT	Stock	43.17	43.17	43.05	43.05	5600.0
2015-01-28 05:30:00	MSFT	Stock	43.05	43.05	43.05	43.05	100.0
2015-01-28 06:00:00	MSFT	Stock	42.99	43.06	42.99	43.06	1050.0
2015-01-28 06:30:00	MSFT	Stock	43.06	43.1	43.03	43.1	9292.0
2015-01-28 07:00:00	MSFT	Stock	43.03	43.1	42.9	42.93	10199.0
2015-01-28 07:30:00	MSFT	Stock	42.98	43.09	42.97	43.0	16260.0
2015-01-28 08:00:00	MSFT	Stock	43.0	43.1	42.9	42.94	33502.0
2015-01-28 08:30:00	MSFT	Stock	42.93	43.0	42.8	42.8	98954.0
2015-01-28 09:00:00	MSFT	Stock	42.81	42.84	42.7	42.72	212935.0
2015-01-28 09:30:00	MSFT	Stock	42.72	42.79	42.2	42.365	10319610.0
2015-01-28 10:00:00	MSFT	Stock	42.36	42.45	42.26	42.315	4497572.0
2015-01-28 10:30:00	MSFT	Stock	42.315	42.37	42.15	42.18	6024834.0
2015-01-28 11:00:00	MSFT	Stock	42.178	42.3	42.0	42.005	5778077.0
2015-01-28 11:30:00	MSFT	Stock	42.002	42.18	41.9	42.155	4469206.0
2015-01-28 12:00:00	MSFT	Stock	42.155	42.24	42.09	42.17	3072080.0
2015-01-28 12:30:00	MSFT	Stock	42.165	42.3	42.15	42.23	2450755.0

> showing 50 of 84,148 rows — these rows as CSV

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