PREVIEW / stock_30min / 2017-03-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-07.parquet
  size:    1.6 MB
  rows:    81,375
  symbols: 3,074

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-03-07 05:30:00	AAPL	Stock	34.7625	34.7625	34.7625	34.7625	2156.0
2017-03-07 06:00:00	AAPL	Stock	34.765	34.765	34.765	34.765	432.0
2017-03-07 07:00:00	AAPL	Stock	34.775	34.78	34.765	34.78	45392.0
2017-03-07 07:30:00	AAPL	Stock	34.78	34.78	34.78	34.78	10800.0
2017-03-07 08:00:00	AAPL	Stock	34.8	34.8	34.7525	34.775	49484.0
2017-03-07 08:30:00	AAPL	Stock	34.775	34.785	34.765	34.78	50824.0
2017-03-07 09:00:00	AAPL	Stock	34.78	34.7975	34.7525	34.7775	87980.0
2017-03-07 09:30:00	AAPL	Stock	34.765	34.8775	34.6975	34.7725	10040848.0
2017-03-07 10:00:00	AAPL	Stock	34.771	34.9788	34.76	34.955	6976504.0
2017-03-07 10:30:00	AAPL	Stock	34.9575	34.995	34.9275	34.935	5677456.0
2017-03-07 11:00:00	AAPL	Stock	34.935	34.94	34.8775	34.91	3963188.0
2017-03-07 11:30:00	AAPL	Stock	34.9088	34.9575	34.8802	34.9225	3493876.0
2017-03-07 12:00:00	AAPL	Stock	34.9212	34.9275	34.855	34.8672	2813760.0
2017-03-07 12:30:00	AAPL	Stock	34.865	34.895	34.845	34.895	2480792.0
2017-03-07 13:00:00	AAPL	Stock	34.895	34.94	34.8925	34.9315	2296828.0
2017-03-07 13:30:00	AAPL	Stock	34.9325	34.9353	34.8662	34.8775	2278080.0
2017-03-07 14:00:00	AAPL	Stock	34.8787	34.9175	34.8475	34.904	2505696.0
2017-03-07 14:30:00	AAPL	Stock	34.9045	34.925	34.875	34.9212	2636232.0
2017-03-07 15:00:00	AAPL	Stock	34.9215	34.9225	34.8552	34.8713	2485620.0
2017-03-07 15:30:00	AAPL	Stock	34.8725	34.8812	34.7875	34.8725	8219076.0
2017-03-07 16:00:00	AAPL	Stock	34.88	34.88	34.83	34.8725	5627848.0
2017-03-07 16:30:00	AAPL	Stock	34.8725	34.88	34.8725	34.88	4968.0
2017-03-07 17:00:00	AAPL	Stock	34.88	34.88	34.855	34.855	463056.0
2017-03-07 17:30:00	AAPL	Stock	34.875	34.875	34.875	34.875	3600.0
2017-03-07 18:00:00	AAPL	Stock	34.8575	34.8575	34.8575	34.8575	400.0
2017-03-07 18:30:00	AAPL	Stock	34.8675	34.8675	34.8675	34.8675	800.0
2017-03-07 19:00:00	AAPL	Stock	34.855	34.8575	34.8375	34.85	5388.0
2017-03-07 19:30:00	AAPL	Stock	34.8325	34.85	34.8325	34.84	11684.0
2017-03-07 05:30:00	MSFT	Stock	64.36	64.36	64.36	64.36	1697.0
2017-03-07 07:30:00	MSFT	Stock	64.31	64.31	64.31	64.31	180.0
2017-03-07 08:00:00	MSFT	Stock	64.3	64.35	64.3	64.34	2083.0
2017-03-07 08:30:00	MSFT	Stock	64.3	64.3	64.3	64.3	600.0
2017-03-07 09:00:00	MSFT	Stock	64.26	64.26	64.17	64.21	43159.0
2017-03-07 09:30:00	MSFT	Stock	64.2	64.46	64.19	64.355	1340523.0
2017-03-07 10:00:00	MSFT	Stock	64.355	64.59	64.29	64.585	927603.0
2017-03-07 10:30:00	MSFT	Stock	64.585	64.775	64.58	64.76	1160658.0
2017-03-07 11:00:00	MSFT	Stock	64.75	64.77	64.505	64.525	1409214.0
2017-03-07 11:30:00	MSFT	Stock	64.52	64.525	64.345	64.38	1258232.0
2017-03-07 12:00:00	MSFT	Stock	64.37	64.44	64.25	64.34	988304.0
2017-03-07 12:30:00	MSFT	Stock	64.345	64.37	64.3	64.36	488664.0
2017-03-07 13:00:00	MSFT	Stock	64.37	64.466	64.355	64.45	708052.0
2017-03-07 13:30:00	MSFT	Stock	64.45	64.46	64.35	64.365	524231.0
2017-03-07 14:00:00	MSFT	Stock	64.36	64.38	64.29	64.3	829397.0
2017-03-07 14:30:00	MSFT	Stock	64.3	64.42	64.28	64.4	800242.0
2017-03-07 15:00:00	MSFT	Stock	64.39	64.46	64.38	64.415	898698.0
2017-03-07 15:30:00	MSFT	Stock	64.41	64.42	64.195	64.4	2929709.0
2017-03-07 16:00:00	MSFT	Stock	64.4	64.4	64.263	64.263	2643503.0
2017-03-07 16:30:00	MSFT	Stock	64.4	64.4	64.38	64.38	15433.0
2017-03-07 17:00:00	MSFT	Stock	64.3	64.4	64.28	64.3	94266.0
2017-03-07 18:30:00	MSFT	Stock	64.3	64.3	64.3	64.3	900.0

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

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