PREVIEW / stock_30min / 2016-03-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-14.parquet
  size:    1.6 MB
  rows:    81,141
  symbols: 3,335

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-03-14 04:00:00	AAPL	Stock	25.59	25.59	25.59	25.59	2840.0
2016-03-14 04:30:00	AAPL	Stock	25.575	25.575	25.575	25.575	504.0
2016-03-14 05:00:00	AAPL	Stock	25.565	25.565	25.565	25.565	1200.0
2016-03-14 05:30:00	AAPL	Stock	25.545	25.545	25.545	25.545	400.0
2016-03-14 06:00:00	AAPL	Stock	25.525	25.525	25.525	25.525	10000.0
2016-03-14 06:30:00	AAPL	Stock	25.5425	25.5425	25.5125	25.5125	2560.0
2016-03-14 07:00:00	AAPL	Stock	25.505	25.525	25.505	25.5075	9548.0
2016-03-14 07:30:00	AAPL	Stock	25.5125	25.525	25.5	25.525	21520.0
2016-03-14 08:00:00	AAPL	Stock	25.5	25.525	25.5	25.5075	31540.0
2016-03-14 08:30:00	AAPL	Stock	25.5075	25.5125	25.4825	25.495	82068.0
2016-03-14 09:00:00	AAPL	Stock	25.48	25.525	25.4675	25.4925	96040.0
2016-03-14 09:30:00	AAPL	Stock	25.4775	25.6575	25.445	25.561	12886732.0
2016-03-14 10:00:00	AAPL	Stock	25.56	25.645	25.525	25.64	7499324.0
2016-03-14 10:30:00	AAPL	Stock	25.6425	25.7275	25.6275	25.6575	10027020.0
2016-03-14 11:00:00	AAPL	Stock	25.6575	25.6862	25.5925	25.5948	6322440.0
2016-03-14 11:30:00	AAPL	Stock	25.595	25.6365	25.5325	25.5462	6044448.0
2016-03-14 12:00:00	AAPL	Stock	25.5425	25.629	25.535	25.6	4314128.0
2016-03-14 12:30:00	AAPL	Stock	25.6025	25.67	25.5975	25.6652	3919204.0
2016-03-14 13:00:00	AAPL	Stock	25.665	25.6825	25.6225	25.6625	3645764.0
2016-03-14 13:30:00	AAPL	Stock	25.6625	25.6675	25.61	25.615	3255012.0
2016-03-14 14:00:00	AAPL	Stock	25.6125	25.615	25.545	25.5675	4935024.0
2016-03-14 14:30:00	AAPL	Stock	25.5655	25.6075	25.555	25.5712	4037564.0
2016-03-14 15:00:00	AAPL	Stock	25.572	25.65	25.555	25.632	4861484.0
2016-03-14 15:30:00	AAPL	Stock	25.6325	25.685	25.6	25.63	10013428.0
2016-03-14 16:00:00	AAPL	Stock	25.63	25.6425	25.4935	25.63	9341824.0
2016-03-14 16:30:00	AAPL	Stock	25.63	25.6375	25.6175	25.6375	16912.0
2016-03-14 17:00:00	AAPL	Stock	25.635	25.6475	25.625	25.6475	17460.0
2016-03-14 17:30:00	AAPL	Stock	25.63	25.6475	25.625	25.625	10712.0
2016-03-14 18:00:00	AAPL	Stock	25.6375	25.6375	25.6375	25.6375	1820.0
2016-03-14 18:30:00	AAPL	Stock	25.6375	25.6375	25.6375	25.6375	2140.0
2016-03-14 19:00:00	AAPL	Stock	25.64	25.6475	25.64	25.6475	3032.0
2016-03-14 19:30:00	AAPL	Stock	25.6475	25.65	25.625	25.65	6408.0
2016-03-14 08:00:00	MSFT	Stock	52.8	52.98	52.8	52.82	836.0
2016-03-14 08:30:00	MSFT	Stock	52.83	52.83	52.81	52.81	43077.0
2016-03-14 09:00:00	MSFT	Stock	52.8	52.88	52.71	52.81	37221.0
2016-03-14 09:30:00	MSFT	Stock	52.71	53.03	52.63	52.86	2696727.0
2016-03-14 10:00:00	MSFT	Stock	52.86	52.954	52.75	52.84	1103459.0
2016-03-14 10:30:00	MSFT	Stock	52.835	53.13	52.78	52.97	1768272.0
2016-03-14 11:00:00	MSFT	Stock	52.97	53.39	52.96	53.34	1577813.0
2016-03-14 11:30:00	MSFT	Stock	53.34	53.41	53.28	53.31	1387307.0
2016-03-14 12:00:00	MSFT	Stock	53.309	53.59	53.27	53.485	1483196.0
2016-03-14 12:30:00	MSFT	Stock	53.485	53.525	53.33	53.375	979309.0
2016-03-14 13:00:00	MSFT	Stock	53.38	53.395	53.26	53.305	908967.0
2016-03-14 13:30:00	MSFT	Stock	53.3	53.38	53.19	53.22	702284.0
2016-03-14 14:00:00	MSFT	Stock	53.21	53.216	53.08	53.185	780371.0
2016-03-14 14:30:00	MSFT	Stock	53.185	53.35	53.164	53.255	1078603.0
2016-03-14 15:00:00	MSFT	Stock	53.25	53.35	53.17	53.305	1092683.0
2016-03-14 15:30:00	MSFT	Stock	53.31	53.44	53.16	53.17	2706891.0
2016-03-14 16:00:00	MSFT	Stock	53.17	53.21	53.17	53.17	3944021.0
2016-03-14 16:30:00	MSFT	Stock	53.17	53.17	53.17	53.17	400.0

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

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