PREVIEW / stock_30min / 2016-04-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-04.parquet
  size:    1.6 MB
  rows:    81,719
  symbols: 3,346

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-04-04 04:00:00	AAPL	Stock	27.6175	27.6175	27.6175	27.6175	1328.0
2016-04-04 04:30:00	AAPL	Stock	27.6175	27.6175	27.6175	27.6175	5600.0
2016-04-04 05:30:00	AAPL	Stock	27.6	27.6	27.59	27.59	9200.0
2016-04-04 06:00:00	AAPL	Stock	27.5625	27.6	27.5625	27.5625	16000.0
2016-04-04 06:30:00	AAPL	Stock	27.5625	27.68	27.5625	27.6725	64176.0
2016-04-04 07:00:00	AAPL	Stock	27.6575	27.72	27.65	27.69	104644.0
2016-04-04 07:30:00	AAPL	Stock	27.7	27.7825	27.7	27.7425	217932.0
2016-04-04 08:00:00	AAPL	Stock	27.75	27.775	27.655	27.7125	370596.0
2016-04-04 08:30:00	AAPL	Stock	27.725	27.7325	27.7	27.7	147472.0
2016-04-04 09:00:00	AAPL	Stock	27.7025	27.7025	27.4375	27.605	507012.0
2016-04-04 09:30:00	AAPL	Stock	27.61	27.93	27.5675	27.93	24102124.0
2016-04-04 10:00:00	AAPL	Stock	27.9312	28.035	27.8625	28.0125	19164612.0
2016-04-04 10:30:00	AAPL	Stock	28.0125	28.0475	27.85	27.8725	11490108.0
2016-04-04 11:00:00	AAPL	Stock	27.8712	27.8925	27.7775	27.7875	9895564.0
2016-04-04 11:30:00	AAPL	Stock	27.7925	27.905	27.7875	27.895	6338752.0
2016-04-04 12:00:00	AAPL	Stock	27.895	27.96	27.88	27.9012	6222640.0
2016-04-04 12:30:00	AAPL	Stock	27.9	27.9925	27.895	27.9912	5497200.0
2016-04-04 13:00:00	AAPL	Stock	27.9925	27.9975	27.9175	27.935	5754532.0
2016-04-04 13:30:00	AAPL	Stock	27.9325	27.9425	27.8275	27.8575	6998236.0
2016-04-04 14:00:00	AAPL	Stock	27.855	27.8625	27.78	27.8425	6114008.0
2016-04-04 14:30:00	AAPL	Stock	27.8425	27.8775	27.81	27.8225	6424384.0
2016-04-04 15:00:00	AAPL	Stock	27.8232	27.85	27.7425	27.7625	7401988.0
2016-04-04 15:30:00	AAPL	Stock	27.765	27.8325	27.755	27.7825	12146780.0
2016-04-04 16:00:00	AAPL	Stock	27.78	27.7875	27.6855	27.75	6969604.0
2016-04-04 16:30:00	AAPL	Stock	27.7475	27.76	27.74	27.75	46232.0
2016-04-04 17:00:00	AAPL	Stock	27.74	27.7475	27.7175	27.7275	46448.0
2016-04-04 17:30:00	AAPL	Stock	27.75	27.76	27.7175	27.7175	24580.0
2016-04-04 18:00:00	AAPL	Stock	27.725	27.725	27.7125	27.715	24972.0
2016-04-04 18:30:00	AAPL	Stock	27.7225	27.7375	27.7175	27.7375	12100.0
2016-04-04 19:00:00	AAPL	Stock	27.745	27.75	27.7325	27.7425	24400.0
2016-04-04 19:30:00	AAPL	Stock	27.7475	27.75	27.725	27.75	32748.0
2016-04-04 05:30:00	MSFT	Stock	55.77	55.77	55.77	55.77	1000.0
2016-04-04 06:30:00	MSFT	Stock	55.73	55.73	55.73	55.73	500.0
2016-04-04 07:00:00	MSFT	Stock	55.6	55.73	55.6	55.73	991.0
2016-04-04 07:30:00	MSFT	Stock	55.73	55.73	55.73	55.73	300.0
2016-04-04 08:00:00	MSFT	Stock	55.65	55.65	55.55	55.56	1700.0
2016-04-04 08:30:00	MSFT	Stock	55.54	55.54	55.5	55.54	2096.0
2016-04-04 09:00:00	MSFT	Stock	55.5	55.52	55.36	55.4	2700.0
2016-04-04 09:30:00	MSFT	Stock	55.43	55.66	55.2	55.284	2640759.0
2016-04-04 10:00:00	MSFT	Stock	55.28	55.54	55.17	55.25	1433957.0
2016-04-04 10:30:00	MSFT	Stock	55.24	55.275	55.0	55.13	1168233.0
2016-04-04 11:00:00	MSFT	Stock	55.12	55.39	55.1	55.33	898665.0
2016-04-04 11:30:00	MSFT	Stock	55.33	55.49	55.32	55.445	1298804.0
2016-04-04 12:00:00	MSFT	Stock	55.45	55.505	55.394	55.434	683715.0
2016-04-04 12:30:00	MSFT	Stock	55.431	55.5	55.315	55.42	429516.0
2016-04-04 13:00:00	MSFT	Stock	55.42	55.42	55.335	55.375	436021.0
2016-04-04 13:30:00	MSFT	Stock	55.38	55.38	55.26	55.265	485685.0
2016-04-04 14:00:00	MSFT	Stock	55.28	55.3	55.16	55.24	941580.0
2016-04-04 14:30:00	MSFT	Stock	55.249	55.294	55.18	55.27	880542.0
2016-04-04 15:00:00	MSFT	Stock	55.27	55.42	55.212	55.25	993434.0

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

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