PREVIEW / stock_30min / 2016-05-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-18.parquet
  size:    1.6 MB
  rows:    81,521
  symbols: 3,302

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-05-18 04:00:00	AAPL	Stock	23.4625	23.4625	23.4625	23.4625	924.0
2016-05-18 04:30:00	AAPL	Stock	23.4225	23.475	23.4225	23.45	13432.0
2016-05-18 05:00:00	AAPL	Stock	23.4375	23.45	23.4375	23.45	2768.0
2016-05-18 05:30:00	AAPL	Stock	23.475	23.505	23.475	23.505	17288.0
2016-05-18 06:00:00	AAPL	Stock	23.505	23.505	23.505	23.505	1180.0
2016-05-18 06:30:00	AAPL	Stock	23.4925	23.52	23.475	23.475	5860.0
2016-05-18 07:00:00	AAPL	Stock	23.4575	23.4925	23.4375	23.4875	27668.0
2016-05-18 07:30:00	AAPL	Stock	23.475	23.475	23.45	23.4625	38740.0
2016-05-18 08:00:00	AAPL	Stock	23.4625	23.4875	23.395	23.44	161628.0
2016-05-18 08:30:00	AAPL	Stock	23.4275	23.4375	23.405	23.43	116324.0
2016-05-18 09:00:00	AAPL	Stock	23.4275	23.54	23.375	23.5375	552572.0
2016-05-18 09:30:00	AAPL	Stock	23.54	23.67	23.4725	23.5875	25051932.0
2016-05-18 10:00:00	AAPL	Stock	23.5875	23.7175	23.5485	23.6915	12401108.0
2016-05-18 10:30:00	AAPL	Stock	23.6925	23.755	23.6375	23.655	12634724.0
2016-05-18 11:00:00	AAPL	Stock	23.6575	23.7075	23.6275	23.6812	8821540.0
2016-05-18 11:30:00	AAPL	Stock	23.68	23.7275	23.655	23.685	7232256.0
2016-05-18 12:00:00	AAPL	Stock	23.6875	23.6975	23.615	23.645	7476960.0
2016-05-18 12:30:00	AAPL	Stock	23.645	23.7225	23.6425	23.7202	6140044.0
2016-05-18 13:00:00	AAPL	Stock	23.7225	23.8025	23.7175	23.79	8853560.0
2016-05-18 13:30:00	AAPL	Stock	23.79	23.795	23.735	23.7475	5994332.0
2016-05-18 14:00:00	AAPL	Stock	23.7475	23.75	23.5225	23.5325	16931916.0
2016-05-18 14:30:00	AAPL	Stock	23.5312	23.6675	23.5125	23.6175	10586920.0
2016-05-18 15:00:00	AAPL	Stock	23.6175	23.695	23.5575	23.562	10071640.0
2016-05-18 15:30:00	AAPL	Stock	23.5625	23.65	23.5475	23.6425	13605668.0
2016-05-18 16:00:00	AAPL	Stock	23.64	23.6575	23.6275	23.65	9408156.0
2016-05-18 16:30:00	AAPL	Stock	23.6475	23.6875	23.64	23.68	174720.0
2016-05-18 17:00:00	AAPL	Stock	23.675	23.675	23.65	23.6525	13856.0
2016-05-18 17:30:00	AAPL	Stock	23.6525	23.6825	23.6525	23.675	29172.0
2016-05-18 18:00:00	AAPL	Stock	23.675	23.6825	23.66	23.6825	40864.0
2016-05-18 18:30:00	AAPL	Stock	23.685	23.695	23.6725	23.68	41016.0
2016-05-18 19:00:00	AAPL	Stock	23.68	23.6975	23.68	23.6875	15604.0
2016-05-18 19:30:00	AAPL	Stock	23.68	23.7	23.68	23.6925	41584.0
2016-05-18 06:30:00	MSFT	Stock	50.48	50.48	50.48	50.48	2600.0
2016-05-18 07:00:00	MSFT	Stock	50.48	50.5	50.48	50.5	900.0
2016-05-18 07:30:00	MSFT	Stock	50.5	50.5	50.48	50.48	1200.0
2016-05-18 08:00:00	MSFT	Stock	50.48	50.48	50.38	50.38	2040.0
2016-05-18 08:30:00	MSFT	Stock	50.38	50.38	50.3	50.3	4248.0
2016-05-18 09:00:00	MSFT	Stock	50.3	50.51	50.26	50.5	18699.0
2016-05-18 09:30:00	MSFT	Stock	50.48	50.55	50.3	50.385	1874543.0
2016-05-18 10:00:00	MSFT	Stock	50.385	50.95	50.36	50.924	1719923.0
2016-05-18 10:30:00	MSFT	Stock	50.92	50.96	50.79	50.81	1130628.0
2016-05-18 11:00:00	MSFT	Stock	50.81	51.0	50.79	50.97	1095527.0
2016-05-18 11:30:00	MSFT	Stock	50.97	51.04	50.86	50.885	1167820.0
2016-05-18 12:00:00	MSFT	Stock	50.885	50.92	50.75	50.78	641700.0
2016-05-18 12:30:00	MSFT	Stock	50.77	50.89	50.73	50.89	542522.0
2016-05-18 13:00:00	MSFT	Stock	50.9	51.1	50.9	51.037	672000.0
2016-05-18 13:30:00	MSFT	Stock	51.035	51.14	51.0	51.04	795519.0
2016-05-18 14:00:00	MSFT	Stock	51.03	51.03	50.45	50.48	2154305.0
2016-05-18 14:30:00	MSFT	Stock	50.47	50.735	50.39	50.685	1876153.0
2016-05-18 15:00:00	MSFT	Stock	50.7	50.83	50.51	50.54	1158864.0

> showing 50 of 81,521 rows — these rows as CSV

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