PREVIEW / stock_30min / 2015-04-15

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-15.parquet
  size:    1.6 MB
  rows:    82,991
  symbols: 3,519

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-04-15 04:30:00	AAPL	Stock	31.68	31.705	31.68	31.705	4708.0
2015-04-15 05:30:00	AAPL	Stock	31.6875	31.6875	31.6875	31.6875	4000.0
2015-04-15 06:00:00	AAPL	Stock	31.655	31.6875	31.6525	31.675	3676.0
2015-04-15 06:30:00	AAPL	Stock	31.675	31.75	31.675	31.7075	36768.0
2015-04-15 07:00:00	AAPL	Stock	31.7075	31.7075	31.6525	31.6875	7116.0
2015-04-15 07:30:00	AAPL	Stock	31.6725	31.6725	31.63	31.645	19560.0
2015-04-15 08:00:00	AAPL	Stock	31.6425	31.6875	31.625	31.6448	245324.0
2015-04-15 08:30:00	AAPL	Stock	31.635	31.675	31.6075	31.66	99096.0
2015-04-15 09:00:00	AAPL	Stock	31.6675	31.7125	31.6075	31.6175	229660.0
2015-04-15 09:30:00	AAPL	Stock	31.6025	31.705	31.5275	31.59	16060756.0
2015-04-15 10:00:00	AAPL	Stock	31.585	31.64	31.5525	31.59	7156596.0
2015-04-15 10:30:00	AAPL	Stock	31.59	31.6325	31.53	31.579	7471080.0
2015-04-15 11:00:00	AAPL	Stock	31.58	31.6025	31.5325	31.55	6526116.0
2015-04-15 11:30:00	AAPL	Stock	31.5525	31.5975	31.5025	31.5725	6388600.0
2015-04-15 12:00:00	AAPL	Stock	31.5725	31.5775	31.53	31.5392	3318208.0
2015-04-15 12:30:00	AAPL	Stock	31.5375	31.556	31.505	31.5425	4354240.0
2015-04-15 13:00:00	AAPL	Stock	31.5425	31.625	31.5225	31.6125	5489156.0
2015-04-15 13:30:00	AAPL	Stock	31.615	31.645	31.595	31.62	6288364.0
2015-04-15 14:00:00	AAPL	Stock	31.6175	31.705	31.6075	31.68	8302372.0
2015-04-15 14:30:00	AAPL	Stock	31.6848	31.7805	31.6802	31.7725	9404472.0
2015-04-15 15:00:00	AAPL	Stock	31.7715	31.7825	31.6925	31.7375	7561492.0
2015-04-15 15:30:00	AAPL	Stock	31.735	31.74	31.6625	31.695	11129796.0
2015-04-15 16:00:00	AAPL	Stock	31.695	31.735	31.6875	31.7225	6528560.0
2015-04-15 16:30:00	AAPL	Stock	31.7225	31.725	31.715	31.7225	35144.0
2015-04-15 17:00:00	AAPL	Stock	31.715	31.72	31.7025	31.72	24612.0
2015-04-15 17:30:00	AAPL	Stock	31.7125	31.7225	31.695	31.7125	32980.0
2015-04-15 18:00:00	AAPL	Stock	31.7125	31.72	31.7002	31.72	25728.0
2015-04-15 18:30:00	AAPL	Stock	31.705	31.7275	31.705	31.715	33424.0
2015-04-15 19:00:00	AAPL	Stock	31.7225	31.725	31.705	31.705	19304.0
2015-04-15 19:30:00	AAPL	Stock	31.7075	31.72	31.695	31.72	23252.0
2015-04-15 05:00:00	MSFT	Stock	41.74	41.74	41.74	41.74	200.0
2015-04-15 05:30:00	MSFT	Stock	41.89	41.89	41.89	41.89	190.0
2015-04-15 06:00:00	MSFT	Stock	41.82	41.82	41.78	41.78	2200.0
2015-04-15 07:00:00	MSFT	Stock	41.94	42.0	41.9	42.0	2800.0
2015-04-15 07:30:00	MSFT	Stock	42.0	42.0	41.83	41.93	14670.0
2015-04-15 08:00:00	MSFT	Stock	41.97	41.97	41.88	41.88	600.0
2015-04-15 08:30:00	MSFT	Stock	41.88	41.91	41.83	41.84	9555.0
2015-04-15 09:00:00	MSFT	Stock	41.83	41.86	41.77	41.77	15915.0
2015-04-15 09:30:00	MSFT	Stock	41.76	42.04	41.68	41.91	3439577.0
2015-04-15 10:00:00	MSFT	Stock	41.91	41.96	41.83	41.85	1697288.0
2015-04-15 10:30:00	MSFT	Stock	41.86	41.94	41.8	41.91	1720206.0
2015-04-15 11:00:00	MSFT	Stock	41.91	41.99	41.9	41.95	1520489.0
2015-04-15 11:30:00	MSFT	Stock	41.94	42.04	41.87	42.04	815390.0
2015-04-15 12:00:00	MSFT	Stock	42.035	42.13	42.03	42.125	1052321.0
2015-04-15 12:30:00	MSFT	Stock	42.125	42.14	42.015	42.08	1382952.0
2015-04-15 13:00:00	MSFT	Stock	42.07	42.205	42.05	42.195	1444801.0
2015-04-15 13:30:00	MSFT	Stock	42.195	42.21	42.13	42.201	1190089.0
2015-04-15 14:00:00	MSFT	Stock	42.205	42.4	42.18	42.4	2074434.0
2015-04-15 14:30:00	MSFT	Stock	42.4	42.45	42.34	42.45	1656448.0
2015-04-15 15:00:00	MSFT	Stock	42.445	42.46	42.38	42.415	1567258.0

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

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