PREVIEW / stock_30min / 2017-12-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-19.parquet
  size:    1.7 MB
  rows:    84,459
  symbols: 2,949

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
2017-12-19 04:00:00	AAPL	Stock	43.845	43.845	43.59	43.7075	30260.0
2017-12-19 05:00:00	AAPL	Stock	43.6975	43.7125	43.6975	43.7125	26044.0
2017-12-19 05:30:00	AAPL	Stock	43.675	43.675	43.6625	43.6625	4000.0
2017-12-19 06:00:00	AAPL	Stock	43.69	43.7475	43.645	43.645	45308.0
2017-12-19 06:30:00	AAPL	Stock	43.625	43.66	43.57	43.66	64992.0
2017-12-19 07:00:00	AAPL	Stock	43.66	43.7825	43.65	43.75	249748.0
2017-12-19 07:30:00	AAPL	Stock	43.7625	43.785	43.7	43.745	121488.0
2017-12-19 08:00:00	AAPL	Stock	43.745	43.795	43.65	43.725	406192.0
2017-12-19 08:30:00	AAPL	Stock	43.7375	43.75	43.675	43.7	374124.0
2017-12-19 09:00:00	AAPL	Stock	43.69	43.7175	43.5875	43.6625	658304.0
2017-12-19 09:30:00	AAPL	Stock	43.7575	43.8475	43.5225	43.7325	21370328.0
2017-12-19 10:00:00	AAPL	Stock	43.7325	43.775	43.61	43.67	7924120.0
2017-12-19 10:30:00	AAPL	Stock	43.665	43.7175	43.555	43.605	7424452.0
2017-12-19 11:00:00	AAPL	Stock	43.605	43.7375	43.565	43.735	6735544.0
2017-12-19 11:30:00	AAPL	Stock	43.735	43.744	43.605	43.6287	3766868.0
2017-12-19 12:00:00	AAPL	Stock	43.63	43.6425	43.5525	43.5775	4540888.0
2017-12-19 12:30:00	AAPL	Stock	43.5788	43.675	43.57	43.6525	3531664.0
2017-12-19 13:00:00	AAPL	Stock	43.6538	43.7475	43.6452	43.72	3527708.0
2017-12-19 13:30:00	AAPL	Stock	43.72	43.7685	43.685	43.69	2948148.0
2017-12-19 14:00:00	AAPL	Stock	43.69	43.725	43.635	43.7162	3376716.0
2017-12-19 14:30:00	AAPL	Stock	43.715	43.7165	43.605	43.6175	3239944.0
2017-12-19 15:00:00	AAPL	Stock	43.617	43.67	43.5575	43.6262	5223656.0
2017-12-19 15:30:00	AAPL	Stock	43.6275	43.6525	43.555	43.6325	11606836.0
2017-12-19 16:00:00	AAPL	Stock	43.6325	43.645	43.575	43.6	6923720.0
2017-12-19 16:30:00	AAPL	Stock	43.6	43.635	43.59	43.59	280252.0
2017-12-19 17:00:00	AAPL	Stock	43.5975	43.6	43.585	43.59	16656.0
2017-12-19 17:30:00	AAPL	Stock	43.6	43.6	43.5875	43.5875	9024.0
2017-12-19 18:00:00	AAPL	Stock	43.5825	43.59	43.5675	43.57	26672.0
2017-12-19 18:30:00	AAPL	Stock	43.57	43.6	43.57	43.6	29840.0
2017-12-19 19:00:00	AAPL	Stock	43.5925	43.65	43.5925	43.6425	44668.0
2017-12-19 19:30:00	AAPL	Stock	43.6475	43.67	43.6425	43.66	45820.0
2017-12-19 07:00:00	MSFT	Stock	86.5	86.5	86.45	86.49	1155.0
2017-12-19 08:00:00	MSFT	Stock	86.48	86.51	86.43	86.43	2980.0
2017-12-19 08:30:00	MSFT	Stock	86.44	86.44	86.35	86.39	15953.0
2017-12-19 09:00:00	MSFT	Stock	86.3	86.42	86.12	86.25	9254.0
2017-12-19 09:30:00	MSFT	Stock	86.34	86.35	85.79	85.935	3037193.0
2017-12-19 10:00:00	MSFT	Stock	85.935	86.06	85.54	85.59	1406583.0
2017-12-19 10:30:00	MSFT	Stock	85.59	85.65	85.33	85.545	1690435.0
2017-12-19 11:00:00	MSFT	Stock	85.545	85.74	85.474	85.73	985019.0
2017-12-19 11:30:00	MSFT	Stock	85.73	85.74	85.29	85.313	1142534.0
2017-12-19 12:00:00	MSFT	Stock	85.31	85.547	85.27	85.547	965564.0
2017-12-19 12:30:00	MSFT	Stock	85.545	85.75	85.5	85.75	707814.0
2017-12-19 13:00:00	MSFT	Stock	85.742	85.77	85.62	85.67	709902.0
2017-12-19 13:30:00	MSFT	Stock	85.66	85.74	85.64	85.715	662202.0
2017-12-19 14:00:00	MSFT	Stock	85.725	85.74	85.58	85.665	951124.0
2017-12-19 14:30:00	MSFT	Stock	85.67	85.67	85.47	85.52	901446.0
2017-12-19 15:00:00	MSFT	Stock	85.53	85.79	85.425	85.753	1277727.0
2017-12-19 15:30:00	MSFT	Stock	85.76	85.92	85.75	85.83	2543983.0
2017-12-19 16:00:00	MSFT	Stock	85.83	85.83	85.61	85.82	3465381.0
2017-12-19 16:30:00	MSFT	Stock	85.82	85.82	85.76	85.76	1111.0

> showing 50 of 84,459 rows — these rows as CSV

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