PREVIEW / stock_30min / 2015-07-15

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-15.parquet
  size:    1.6 MB
  rows:    82,302
  symbols: 3,489

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-07-15 04:00:00	AAPL	Stock	31.4825	31.505	31.4825	31.505	3200.0
2015-07-15 04:30:00	AAPL	Stock	31.5875	31.5875	31.5075	31.5075	3600.0
2015-07-15 05:00:00	AAPL	Stock	31.505	31.505	31.505	31.505	2400.0
2015-07-15 05:30:00	AAPL	Stock	31.505	31.505	31.4725	31.4725	852.0
2015-07-15 06:00:00	AAPL	Stock	31.4075	31.4875	31.4075	31.42	5052.0
2015-07-15 07:00:00	AAPL	Stock	31.4875	31.4875	31.45	31.45	18920.0
2015-07-15 07:30:00	AAPL	Stock	31.465	31.5025	31.465	31.5	53284.0
2015-07-15 08:00:00	AAPL	Stock	31.4975	31.505	31.4075	31.5	217628.0
2015-07-15 08:30:00	AAPL	Stock	31.4925	31.5	31.475	31.4775	114504.0
2015-07-15 09:00:00	AAPL	Stock	31.475	31.485	31.4175	31.43	174744.0
2015-07-15 09:30:00	AAPL	Stock	31.43	31.5475	31.395	31.504	19677864.0
2015-07-15 10:00:00	AAPL	Stock	31.505	31.6725	31.4925	31.59	13774288.0
2015-07-15 10:30:00	AAPL	Stock	31.589	31.735	31.5875	31.73	12637816.0
2015-07-15 11:00:00	AAPL	Stock	31.7302	31.7875	31.7	31.7162	12538696.0
2015-07-15 11:30:00	AAPL	Stock	31.7175	31.745	31.6275	31.6775	7258352.0
2015-07-15 12:00:00	AAPL	Stock	31.6775	31.71	31.65	31.695	3899296.0
2015-07-15 12:30:00	AAPL	Stock	31.6962	31.7275	31.6538	31.6775	4245080.0
2015-07-15 13:00:00	AAPL	Stock	31.6758	31.7025	31.6525	31.6975	3309760.0
2015-07-15 13:30:00	AAPL	Stock	31.7	31.7	31.6525	31.6948	3553116.0
2015-07-15 14:00:00	AAPL	Stock	31.6948	31.7675	31.6875	31.74	6416768.0
2015-07-15 14:30:00	AAPL	Stock	31.7415	31.7425	31.6025	31.659	10305304.0
2015-07-15 15:00:00	AAPL	Stock	31.6575	31.7075	31.635	31.701	7182176.0
2015-07-15 15:30:00	AAPL	Stock	31.7	31.7225	31.66	31.7075	11594400.0
2015-07-15 16:00:00	AAPL	Stock	31.705	31.7675	31.695	31.765	8046108.0
2015-07-15 16:30:00	AAPL	Stock	31.7675	31.7875	31.75	31.7592	116956.0
2015-07-15 17:00:00	AAPL	Stock	31.75	31.7775	31.75	31.7725	38696.0
2015-07-15 17:30:00	AAPL	Stock	31.7675	31.7675	31.75	31.75	22740.0
2015-07-15 18:00:00	AAPL	Stock	31.7625	31.7625	31.74	31.75	60000.0
2015-07-15 18:30:00	AAPL	Stock	31.75	31.795	31.7375	31.795	94212.0
2015-07-15 19:00:00	AAPL	Stock	31.8075	31.835	31.795	31.825	91172.0
2015-07-15 19:30:00	AAPL	Stock	31.835	31.835	31.8125	31.825	55672.0
2015-07-15 08:00:00	MSFT	Stock	45.8	45.8	45.74	45.74	1700.0
2015-07-15 09:00:00	MSFT	Stock	45.72	45.72	45.65	45.69	3430.0
2015-07-15 09:30:00	MSFT	Stock	45.69	45.74	45.43	45.655	2921815.0
2015-07-15 10:00:00	MSFT	Stock	45.66	45.826	45.6	45.72	1722025.0
2015-07-15 10:30:00	MSFT	Stock	45.725	45.81	45.7	45.78	1155586.0
2015-07-15 11:00:00	MSFT	Stock	45.78	45.82	45.7	45.73	908408.0
2015-07-15 11:30:00	MSFT	Stock	45.73	45.81	45.66	45.74	1210118.0
2015-07-15 12:00:00	MSFT	Stock	45.73	45.82	45.73	45.805	1052721.0
2015-07-15 12:30:00	MSFT	Stock	45.805	45.835	45.74	45.82	1226973.0
2015-07-15 13:00:00	MSFT	Stock	45.82	45.89	45.78	45.83	1035839.0
2015-07-15 13:30:00	MSFT	Stock	45.835	45.89	45.79	45.81	908353.0
2015-07-15 14:00:00	MSFT	Stock	45.82	45.89	45.78	45.865	1292379.0
2015-07-15 14:30:00	MSFT	Stock	45.861	45.87	45.7	45.78	1862413.0
2015-07-15 15:00:00	MSFT	Stock	45.785	45.82	45.705	45.78	1282678.0
2015-07-15 15:30:00	MSFT	Stock	45.78	45.85	45.7	45.77	2989927.0
2015-07-15 16:00:00	MSFT	Stock	45.76	46.317	45.76	46.16	2143560.0
2015-07-15 16:30:00	MSFT	Stock	46.2	46.26	46.15	46.2	16151.0
2015-07-15 17:00:00	MSFT	Stock	46.13	46.15	46.0	46.0	37960.0
2015-07-15 17:30:00	MSFT	Stock	46.1	46.1	46.1	46.1	300.0

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

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