PREVIEW / stock_30min / 2016-03-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-04.parquet
  size:    1.6 MB
  rows:    82,960
  symbols: 3,350

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-03-04 04:00:00	AAPL	Stock	25.4	25.4	25.4	25.4	3600.0
2016-03-04 05:00:00	AAPL	Stock	25.4125	25.4125	25.4125	25.4125	7688.0
2016-03-04 05:30:00	AAPL	Stock	25.4375	25.475	25.39	25.445	23828.0
2016-03-04 06:30:00	AAPL	Stock	25.4725	25.475	25.4575	25.475	4600.0
2016-03-04 07:00:00	AAPL	Stock	25.475	25.52	25.475	25.5125	36824.0
2016-03-04 07:30:00	AAPL	Stock	25.5	25.5	25.4725	25.4725	27148.0
2016-03-04 08:00:00	AAPL	Stock	25.475	25.5	25.4	25.4675	196872.0
2016-03-04 08:30:00	AAPL	Stock	25.455	25.6225	25.43	25.4975	738376.0
2016-03-04 09:00:00	AAPL	Stock	25.4875	25.5925	25.4625	25.59	876044.0
2016-03-04 09:30:00	AAPL	Stock	25.5925	25.595	25.3425	25.45	22428700.0
2016-03-04 10:00:00	AAPL	Stock	25.45	25.5175	25.3475	25.49	10260444.0
2016-03-04 10:30:00	AAPL	Stock	25.49	25.6675	25.46	25.6475	14017788.0
2016-03-04 11:00:00	AAPL	Stock	25.645	25.7725	25.6375	25.725	15596560.0
2016-03-04 11:30:00	AAPL	Stock	25.7275	25.745	25.6275	25.741	10858948.0
2016-03-04 12:00:00	AAPL	Stock	25.74	25.7575	25.68	25.7205	6546972.0
2016-03-04 12:30:00	AAPL	Stock	25.72	25.8625	25.71	25.8475	12554856.0
2016-03-04 13:00:00	AAPL	Stock	25.8475	25.8512	25.7775	25.8425	9153792.0
2016-03-04 13:30:00	AAPL	Stock	25.845	25.9375	25.82	25.8825	9065144.0
2016-03-04 14:00:00	AAPL	Stock	25.8838	25.8975	25.7138	25.7535	9643624.0
2016-03-04 14:30:00	AAPL	Stock	25.7548	25.7825	25.6175	25.6858	12742368.0
2016-03-04 15:00:00	AAPL	Stock	25.685	25.795	25.645	25.7325	11779428.0
2016-03-04 15:30:00	AAPL	Stock	25.7325	25.77	25.72	25.7525	16482392.0
2016-03-04 16:00:00	AAPL	Stock	25.7525	25.7525	25.457	25.7425	7193352.0
2016-03-04 16:30:00	AAPL	Stock	25.7425	25.7475	25.74	25.7425	97824.0
2016-03-04 17:00:00	AAPL	Stock	25.7425	25.75	25.73	25.73	47232.0
2016-03-04 17:30:00	AAPL	Stock	25.7275	25.7375	25.725	25.7275	18984.0
2016-03-04 18:00:00	AAPL	Stock	25.74	25.745	25.7275	25.745	8400.0
2016-03-04 18:30:00	AAPL	Stock	25.73	25.745	25.73	25.73	8028.0
2016-03-04 19:00:00	AAPL	Stock	25.7475	25.7475	25.735	25.74	9888.0
2016-03-04 19:30:00	AAPL	Stock	25.745	25.7475	25.7375	25.7475	17096.0
2016-03-04 05:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	300.0
2016-03-04 05:30:00	MSFT	Stock	52.3	52.3	52.3	52.3	100.0
2016-03-04 07:00:00	MSFT	Stock	52.4	52.4	52.4	52.4	1000.0
2016-03-04 08:00:00	MSFT	Stock	52.32	52.4	52.32	52.4	5350.0
2016-03-04 08:30:00	MSFT	Stock	52.38	52.65	52.38	52.4	23197.0
2016-03-04 09:00:00	MSFT	Stock	52.31	52.43	52.2	52.43	116694.0
2016-03-04 09:30:00	MSFT	Stock	52.4	52.45	51.71	51.935	3850591.0
2016-03-04 10:00:00	MSFT	Stock	51.94	52.05	51.75	51.82	1996563.0
2016-03-04 10:30:00	MSFT	Stock	51.82	52.14	51.79	51.99	2302420.0
2016-03-04 11:00:00	MSFT	Stock	51.99	52.14	51.895	51.906	2060399.0
2016-03-04 11:30:00	MSFT	Stock	51.9	52.04	51.83	51.965	2306668.0
2016-03-04 12:00:00	MSFT	Stock	51.97	52.07	51.91	51.935	1463390.0
2016-03-04 12:30:00	MSFT	Stock	51.935	52.065	51.86	52.03	1533353.0
2016-03-04 13:00:00	MSFT	Stock	52.02	52.045	51.944	52.005	1408694.0
2016-03-04 13:30:00	MSFT	Stock	52.0	52.2	51.94	52.155	2031117.0
2016-03-04 14:00:00	MSFT	Stock	52.153	52.24	52.11	52.2	1246944.0
2016-03-04 14:30:00	MSFT	Stock	52.2	52.24	51.91	51.94	1186957.0
2016-03-04 15:00:00	MSFT	Stock	51.94	52.03	51.8	51.99	2232165.0
2016-03-04 15:30:00	MSFT	Stock	51.985	52.06	51.925	52.03	3145697.0
2016-03-04 16:00:00	MSFT	Stock	52.03	52.03	51.93	52.03	3841447.0

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

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