PREVIEW / stock_30min / 2015-03-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-09.parquet
  size:    1.6 MB
  rows:    82,447
  symbols: 3,517

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
2015-03-09 04:00:00	AAPL	Stock	32.0025	32.0025	31.9	31.945	18560.0
2015-03-09 04:30:00	AAPL	Stock	31.9675	31.97	31.955	31.955	13728.0
2015-03-09 05:00:00	AAPL	Stock	31.9725	32.0	31.95	32.0	16332.0
2015-03-09 05:30:00	AAPL	Stock	31.9875	32.0225	31.955	31.955	41520.0
2015-03-09 06:00:00	AAPL	Stock	31.9475	31.9975	31.9325	31.9925	56788.0
2015-03-09 06:30:00	AAPL	Stock	31.9975	32.0	31.955	31.955	55860.0
2015-03-09 07:00:00	AAPL	Stock	31.95	31.955	31.915	31.915	87736.0
2015-03-09 07:30:00	AAPL	Stock	31.915	31.925	31.875	31.9125	175464.0
2015-03-09 08:00:00	AAPL	Stock	31.9125	31.98	31.8625	31.935	893240.0
2015-03-09 08:30:00	AAPL	Stock	31.935	32.025	31.9125	31.9625	703676.0
2015-03-09 09:00:00	AAPL	Stock	31.9575	32.0575	31.8925	32.05	913224.0
2015-03-09 09:30:00	AAPL	Stock	31.995	32.04	31.8025	31.8825	23479064.0
2015-03-09 10:00:00	AAPL	Stock	31.88	31.97	31.83	31.8872	15486744.0
2015-03-09 10:30:00	AAPL	Stock	31.885	32.025	31.8625	31.9875	14082984.0
2015-03-09 11:00:00	AAPL	Stock	31.9875	31.9925	31.93	31.97	8943624.0
2015-03-09 11:30:00	AAPL	Stock	31.9642	31.975	31.8675	31.8975	8128336.0
2015-03-09 12:00:00	AAPL	Stock	31.8975	31.9075	31.8025	31.8762	9987528.0
2015-03-09 12:30:00	AAPL	Stock	31.875	31.8775	31.7875	31.79	9640668.0
2015-03-09 13:00:00	AAPL	Stock	31.7925	32.01	31.77	31.9315	24475068.0
2015-03-09 13:30:00	AAPL	Stock	31.93	32.3925	31.925	32.1425	50781172.0
2015-03-09 14:00:00	AAPL	Stock	32.14	32.21	31.7025	31.74	47584500.0
2015-03-09 14:30:00	AAPL	Stock	31.7425	31.8388	31.265	31.6125	56304012.0
2015-03-09 15:00:00	AAPL	Stock	31.6125	31.895	31.5875	31.7625	26625492.0
2015-03-09 15:30:00	AAPL	Stock	31.76	31.8925	31.6575	31.7775	25158232.0
2015-03-09 16:00:00	AAPL	Stock	31.785	31.9572	31.6738	31.8425	9491608.0
2015-03-09 16:30:00	AAPL	Stock	31.8422	31.8625	31.8375	31.8375	117240.0
2015-03-09 17:00:00	AAPL	Stock	31.8375	31.8902	31.785	31.83	139544.0
2015-03-09 17:30:00	AAPL	Stock	31.82	31.82	31.785	31.81	75516.0
2015-03-09 18:00:00	AAPL	Stock	31.8	31.82	31.79	31.7925	73584.0
2015-03-09 18:30:00	AAPL	Stock	31.795	31.8	31.775	31.7875	65496.0
2015-03-09 19:00:00	AAPL	Stock	31.7872	31.8025	31.7725	31.7725	114896.0
2015-03-09 19:30:00	AAPL	Stock	31.7725	31.7775	31.7525	31.77	98956.0
2015-03-09 07:30:00	MSFT	Stock	42.29	42.33	42.29	42.33	1100.0
2015-03-09 08:00:00	MSFT	Stock	42.15	42.41	42.15	42.41	2400.0
2015-03-09 08:30:00	MSFT	Stock	42.41	42.41	42.36	42.36	4579.0
2015-03-09 09:00:00	MSFT	Stock	42.361	42.4	42.23	42.23	33615.0
2015-03-09 09:30:00	MSFT	Stock	42.24	42.48	42.19	42.445	3710793.0
2015-03-09 10:00:00	MSFT	Stock	42.44	42.49	42.31	42.36	2173862.0
2015-03-09 10:30:00	MSFT	Stock	42.365	42.42	42.24	42.38	2320147.0
2015-03-09 11:00:00	MSFT	Stock	42.37	42.56	42.34	42.535	2306330.0
2015-03-09 11:30:00	MSFT	Stock	42.534	42.6	42.49	42.565	1428376.0
2015-03-09 12:00:00	MSFT	Stock	42.57	42.63	42.54	42.62	986087.0
2015-03-09 12:30:00	MSFT	Stock	42.625	42.82	42.62	42.805	1309935.0
2015-03-09 13:00:00	MSFT	Stock	42.8	43.02	42.8	42.979	2040970.0
2015-03-09 13:30:00	MSFT	Stock	42.98	43.125	42.97	43.05	1838882.0
2015-03-09 14:00:00	MSFT	Stock	43.05	43.1	43.03	43.06	1618763.0
2015-03-09 14:30:00	MSFT	Stock	43.06	43.1	42.93	43.09	2130201.0
2015-03-09 15:00:00	MSFT	Stock	43.095	43.1	42.921	42.99	2349183.0
2015-03-09 15:30:00	MSFT	Stock	42.99	43.01	42.82	42.83	3774565.0
2015-03-09 16:00:00	MSFT	Stock	42.85	42.888	42.7	42.85	2401574.0

> showing 50 of 82,447 rows — these rows as CSV

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