PREVIEW / stock_30min / 2015-07-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-09.parquet
  size:    1.6 MB
  rows:    83,063
  symbols: 3,474

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-09 04:00:00	AAPL	Stock	30.86	30.975	30.86	30.9	28212.0
2015-07-09 04:30:00	AAPL	Stock	30.945	30.945	30.9	30.9075	7780.0
2015-07-09 05:00:00	AAPL	Stock	30.9075	30.9225	30.895	30.9225	6520.0
2015-07-09 05:30:00	AAPL	Stock	30.9575	30.975	30.9575	30.965	47348.0
2015-07-09 06:00:00	AAPL	Stock	30.96	30.96	30.9475	30.9525	15932.0
2015-07-09 06:30:00	AAPL	Stock	30.9525	31.0	30.9525	30.9725	103232.0
2015-07-09 07:00:00	AAPL	Stock	30.97	31.0925	30.945	30.975	237764.0
2015-07-09 07:30:00	AAPL	Stock	30.965	30.9875	30.92	30.9875	198624.0
2015-07-09 08:00:00	AAPL	Stock	30.995	31.05	30.925	30.95	699844.0
2015-07-09 08:30:00	AAPL	Stock	30.95	30.9825	30.945	30.98	320608.0
2015-07-09 09:00:00	AAPL	Stock	30.9825	31.0125	30.9525	30.98	814648.0
2015-07-09 09:30:00	AAPL	Stock	30.9625	31.015	30.825	30.9825	32509140.0
2015-07-09 10:00:00	AAPL	Stock	30.98	31.0	30.83	30.8375	15655396.0
2015-07-09 10:30:00	AAPL	Stock	30.8382	30.915	30.83	30.8775	9660480.0
2015-07-09 11:00:00	AAPL	Stock	30.8775	30.885	30.7675	30.771	11126316.0
2015-07-09 11:30:00	AAPL	Stock	30.771	30.7875	30.6525	30.725	14639280.0
2015-07-09 12:00:00	AAPL	Stock	30.7275	30.77	30.7025	30.7125	8674748.0
2015-07-09 12:30:00	AAPL	Stock	30.71	30.725	30.655	30.6762	10157116.0
2015-07-09 13:00:00	AAPL	Stock	30.6738	30.6825	30.405	30.4388	18403060.0
2015-07-09 13:30:00	AAPL	Stock	30.44	30.5222	30.3275	30.3642	17940260.0
2015-07-09 14:00:00	AAPL	Stock	30.364	30.4	30.0625	30.116	33941688.0
2015-07-09 14:30:00	AAPL	Stock	30.1175	30.145	29.805	30.1252	51353840.0
2015-07-09 15:00:00	AAPL	Stock	30.125	30.2702	30.0875	30.0975	27274688.0
2015-07-09 15:30:00	AAPL	Stock	30.0988	30.1575	30.0025	30.0075	34063272.0
2015-07-09 16:00:00	AAPL	Stock	30.0175	30.941	29.9775	30.0325	5206008.0
2015-07-09 16:30:00	AAPL	Stock	30.04	30.0575	29.9875	30.0542	196252.0
2015-07-09 17:00:00	AAPL	Stock	30.05	30.07	30.0175	30.0175	155712.0
2015-07-09 17:30:00	AAPL	Stock	30.02	30.1	30.02	30.0875	296192.0
2015-07-09 18:00:00	AAPL	Stock	30.1075	30.2475	30.0875	30.22	217308.0
2015-07-09 18:30:00	AAPL	Stock	30.2225	30.315	30.2125	30.275	286192.0
2015-07-09 19:00:00	AAPL	Stock	30.27	30.275	30.175	30.23	132576.0
2015-07-09 19:30:00	AAPL	Stock	30.225	30.2708	30.2025	30.2625	138064.0
2015-07-09 04:00:00	MSFT	Stock	44.6	44.6	44.6	44.6	100.0
2015-07-09 06:30:00	MSFT	Stock	44.7	44.75	44.7	44.75	3662.0
2015-07-09 07:00:00	MSFT	Stock	44.73	44.75	44.65	44.65	6340.0
2015-07-09 07:30:00	MSFT	Stock	44.67	44.7	44.6	44.65	12607.0
2015-07-09 08:00:00	MSFT	Stock	44.6	44.7	44.6	44.7	11190.0
2015-07-09 08:30:00	MSFT	Stock	44.75	44.847	44.75	44.79	5853.0
2015-07-09 09:00:00	MSFT	Stock	44.787	44.8	44.75	44.75	17362.0
2015-07-09 09:30:00	MSFT	Stock	44.76	44.98	44.65	44.88	6034586.0
2015-07-09 10:00:00	MSFT	Stock	44.88	44.99	44.75	44.786	3301061.0
2015-07-09 10:30:00	MSFT	Stock	44.78	44.97	44.774	44.941	2314450.0
2015-07-09 11:00:00	MSFT	Stock	44.945	45.22	44.9	45.06	2418279.0
2015-07-09 11:30:00	MSFT	Stock	45.07	45.16	44.94	44.964	1567640.0
2015-07-09 12:00:00	MSFT	Stock	44.965	45.04	44.79	44.954	1670481.0
2015-07-09 12:30:00	MSFT	Stock	44.95	45.01	44.9	44.96	1683351.0
2015-07-09 13:00:00	MSFT	Stock	44.96	44.98	44.822	44.85	1314419.0
2015-07-09 13:30:00	MSFT	Stock	44.86	44.92	44.775	44.835	975860.0
2015-07-09 14:00:00	MSFT	Stock	44.83	44.88	44.7	44.76	1361568.0
2015-07-09 14:30:00	MSFT	Stock	44.76	44.82	44.71	44.775	2146363.0

> showing 50 of 83,063 rows — these rows as CSV

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