PREVIEW / stock_30min / 2016-07-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-22.parquet
  size:    1.6 MB
  rows:    80,030
  symbols: 3,265

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-22 04:00:00	AAPL	Stock	24.8125	24.8125	24.8125	24.8125	6000.0
2016-07-22 05:30:00	AAPL	Stock	24.8575	24.86	24.8575	24.86	9740.0
2016-07-22 06:30:00	AAPL	Stock	24.82	24.82	24.79	24.79	3916.0
2016-07-22 07:00:00	AAPL	Stock	24.7925	24.795	24.7475	24.7475	44272.0
2016-07-22 07:30:00	AAPL	Stock	24.7625	24.7625	24.7475	24.76	14816.0
2016-07-22 08:00:00	AAPL	Stock	24.7725	24.7725	24.7375	24.77	190192.0
2016-07-22 08:30:00	AAPL	Stock	24.76	24.77	24.7475	24.76	80476.0
2016-07-22 09:00:00	AAPL	Stock	24.76	24.81	24.75	24.81	175660.0
2016-07-22 09:30:00	AAPL	Stock	24.815	24.825	24.5775	24.665	23676740.0
2016-07-22 10:00:00	AAPL	Stock	24.665	24.75	24.6477	24.7075	8463328.0
2016-07-22 10:30:00	AAPL	Stock	24.7075	24.74	24.655	24.662	6583812.0
2016-07-22 11:00:00	AAPL	Stock	24.6625	24.675	24.6375	24.6728	5750472.0
2016-07-22 11:30:00	AAPL	Stock	24.675	24.7275	24.666	24.7225	4787124.0
2016-07-22 12:00:00	AAPL	Stock	24.7225	24.7625	24.7125	24.755	4906296.0
2016-07-22 12:30:00	AAPL	Stock	24.755	24.7625	24.7	24.7	4061812.0
2016-07-22 13:00:00	AAPL	Stock	24.7	24.7025	24.6625	24.6693	3996820.0
2016-07-22 13:30:00	AAPL	Stock	24.67	24.69	24.645	24.6635	4225412.0
2016-07-22 14:00:00	AAPL	Stock	24.6638	24.6775	24.655	24.66	3504588.0
2016-07-22 14:30:00	AAPL	Stock	24.6625	24.67	24.64	24.6625	3640652.0
2016-07-22 15:00:00	AAPL	Stock	24.6648	24.6675	24.63	24.65	6033412.0
2016-07-22 15:30:00	AAPL	Stock	24.65	24.665	24.6175	24.665	15420352.0
2016-07-22 16:00:00	AAPL	Stock	24.665	24.665	24.6025	24.625	9717544.0
2016-07-22 16:30:00	AAPL	Stock	24.62	24.731	24.6175	24.625	131500.0
2016-07-22 17:00:00	AAPL	Stock	24.62	24.665	24.62	24.63	219828.0
2016-07-22 17:30:00	AAPL	Stock	24.63	24.635	24.625	24.63	27736.0
2016-07-22 18:00:00	AAPL	Stock	24.635	24.66	24.5875	24.6	93484.0
2016-07-22 18:30:00	AAPL	Stock	24.595	24.6125	24.59	24.605	24888.0
2016-07-22 19:00:00	AAPL	Stock	24.605	24.61	24.5975	24.6025	17212.0
2016-07-22 19:30:00	AAPL	Stock	24.61	24.61	24.5875	24.595	43120.0
2016-07-22 06:30:00	MSFT	Stock	55.75	55.75	55.75	55.75	600.0
2016-07-22 07:00:00	MSFT	Stock	55.76	55.76	55.76	55.76	2993.0
2016-07-22 07:30:00	MSFT	Stock	55.76	55.76	55.76	55.76	1193.0
2016-07-22 08:00:00	MSFT	Stock	55.7	55.8	55.7	55.78	10767.0
2016-07-22 08:30:00	MSFT	Stock	55.79	55.84	55.79	55.84	1895.0
2016-07-22 09:00:00	MSFT	Stock	55.83	56.07	55.82	56.07	88305.0
2016-07-22 09:30:00	MSFT	Stock	56.07	56.19	55.78	56.175	3740847.0
2016-07-22 10:00:00	MSFT	Stock	56.18	56.59	56.15	56.485	3520069.0
2016-07-22 10:30:00	MSFT	Stock	56.49	56.5	56.36	56.39	1858507.0
2016-07-22 11:00:00	MSFT	Stock	56.39	56.4	56.28	56.335	1318612.0
2016-07-22 11:30:00	MSFT	Stock	56.34	56.5	56.295	56.46	1590767.0
2016-07-22 12:00:00	MSFT	Stock	56.46	56.5	56.44	56.48	1202300.0
2016-07-22 12:30:00	MSFT	Stock	56.49	56.51	56.425	56.45	993432.0
2016-07-22 13:00:00	MSFT	Stock	56.452	56.46	56.31	56.38	1043200.0
2016-07-22 13:30:00	MSFT	Stock	56.375	56.42	56.285	56.405	1127736.0
2016-07-22 14:00:00	MSFT	Stock	56.405	56.52	56.345	56.515	1425327.0
2016-07-22 14:30:00	MSFT	Stock	56.51	56.625	56.43	56.59	1554329.0
2016-07-22 15:00:00	MSFT	Stock	56.59	56.59	56.48	56.555	1658856.0
2016-07-22 15:30:00	MSFT	Stock	56.555	56.628	56.465	56.57	6028982.0
2016-07-22 16:00:00	MSFT	Stock	56.57	56.61	56.48	56.52	3474712.0
2016-07-22 16:30:00	MSFT	Stock	56.52	56.57	56.49	56.49	78253.0

> showing 50 of 80,030 rows — these rows as CSV

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