PREVIEW / stock_30min / 2016-07-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-19.parquet
  size:    1.6 MB
  rows:    81,312
  symbols: 3,272

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-07-19 04:00:00	AAPL	Stock	24.8625	24.8625	24.8075	24.8075	13176.0
2016-07-19 05:00:00	AAPL	Stock	24.8	24.8	24.8	24.8	400.0
2016-07-19 05:30:00	AAPL	Stock	24.8475	24.8475	24.8475	24.8475	1120.0
2016-07-19 06:00:00	AAPL	Stock	24.8475	24.8475	24.8275	24.8275	7120.0
2016-07-19 07:00:00	AAPL	Stock	24.8625	24.8775	24.8625	24.8625	18300.0
2016-07-19 07:30:00	AAPL	Stock	24.88	24.88	24.8525	24.8525	12976.0
2016-07-19 08:00:00	AAPL	Stock	24.8525	24.8875	24.85	24.875	109548.0
2016-07-19 08:30:00	AAPL	Stock	24.87	24.8825	24.865	24.8825	40824.0
2016-07-19 09:00:00	AAPL	Stock	24.88	24.89	24.875	24.875	96200.0
2016-07-19 09:30:00	AAPL	Stock	24.89	24.9925	24.835	24.93	14141796.0
2016-07-19 10:00:00	AAPL	Stock	24.9275	25.0	24.9	24.98	9082792.0
2016-07-19 10:30:00	AAPL	Stock	24.9798	24.9988	24.935	24.9775	6522400.0
2016-07-19 11:00:00	AAPL	Stock	24.9775	24.995	24.9138	24.9288	6626260.0
2016-07-19 11:30:00	AAPL	Stock	24.9275	24.941	24.8875	24.905	5899572.0
2016-07-19 12:00:00	AAPL	Stock	24.905	24.9325	24.8975	24.9262	3154848.0
2016-07-19 12:30:00	AAPL	Stock	24.925	24.96	24.92	24.955	4973344.0
2016-07-19 13:00:00	AAPL	Stock	24.9538	24.9587	24.9375	24.9462	3687392.0
2016-07-19 13:30:00	AAPL	Stock	24.9475	24.98	24.9375	24.955	4068728.0
2016-07-19 14:00:00	AAPL	Stock	24.9575	24.965	24.945	24.9582	2747040.0
2016-07-19 14:30:00	AAPL	Stock	24.9575	24.985	24.9525	24.9662	3929324.0
2016-07-19 15:00:00	AAPL	Stock	24.9675	24.9838	24.94	24.9475	4817580.0
2016-07-19 15:30:00	AAPL	Stock	24.9475	24.9875	24.9475	24.9675	9067488.0
2016-07-19 16:00:00	AAPL	Stock	24.97	25.0025	24.95	24.9825	8932228.0
2016-07-19 16:30:00	AAPL	Stock	24.9825	24.985	24.9675	24.975	42912.0
2016-07-19 17:00:00	AAPL	Stock	24.97	24.9825	24.955	24.9825	21976.0
2016-07-19 17:30:00	AAPL	Stock	24.97	24.975	24.9675	24.975	10600.0
2016-07-19 18:00:00	AAPL	Stock	24.975	24.985	24.975	24.98	13056.0
2016-07-19 18:30:00	AAPL	Stock	24.98	24.985	24.975	24.975	4648.0
2016-07-19 19:00:00	AAPL	Stock	24.985	24.985	24.985	24.985	1800.0
2016-07-19 19:30:00	AAPL	Stock	24.9775	24.985	24.9775	24.985	14000.0
2016-07-19 05:30:00	MSFT	Stock	53.91	53.91	53.91	53.91	401.0
2016-07-19 06:00:00	MSFT	Stock	53.86	53.86	53.86	53.86	500.0
2016-07-19 07:00:00	MSFT	Stock	53.98	53.98	53.98	53.98	500.0
2016-07-19 07:30:00	MSFT	Stock	53.91	53.96	53.91	53.92	800.0
2016-07-19 08:00:00	MSFT	Stock	53.91	54.0	53.91	54.0	17165.0
2016-07-19 08:30:00	MSFT	Stock	54.01	54.08	54.0	54.0	11892.0
2016-07-19 09:00:00	MSFT	Stock	54.0	54.0	53.71	53.72	15936.0
2016-07-19 09:30:00	MSFT	Stock	53.72	53.9	53.375	53.41	5449105.0
2016-07-19 10:00:00	MSFT	Stock	53.41	53.66	53.41	53.455	2824808.0
2016-07-19 10:30:00	MSFT	Stock	53.46	53.6	53.455	53.56	2629446.0
2016-07-19 11:00:00	MSFT	Stock	53.567	53.62	53.41	53.501	2143353.0
2016-07-19 11:30:00	MSFT	Stock	53.5	53.57	53.38	53.495	1560445.0
2016-07-19 12:00:00	MSFT	Stock	53.49	53.51	53.45	53.47	1163203.0
2016-07-19 12:30:00	MSFT	Stock	53.48	53.6	53.475	53.54	1881105.0
2016-07-19 13:00:00	MSFT	Stock	53.545	53.547	53.315	53.325	2185534.0
2016-07-19 13:30:00	MSFT	Stock	53.32	53.37	53.1	53.145	2714128.0
2016-07-19 14:00:00	MSFT	Stock	53.15	53.24	53.11	53.14	2793058.0
2016-07-19 14:30:00	MSFT	Stock	53.14	53.22	53.11	53.207	2121379.0
2016-07-19 15:00:00	MSFT	Stock	53.205	53.205	52.97	53.03	4177810.0
2016-07-19 15:30:00	MSFT	Stock	53.03	53.09	52.93	53.056	9665599.0

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

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