PREVIEW / stock_30min / 2014-11-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-07.parquet
  size:    1.6 MB
  rows:    81,796
  symbols: 3,553

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
2014-11-07 04:00:00	AAPL	Stock	27.1925	27.2	27.175	27.1875	7200.0
2014-11-07 04:30:00	AAPL	Stock	27.2	27.205	27.2	27.205	11512.0
2014-11-07 05:00:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	5480.0
2014-11-07 05:30:00	AAPL	Stock	27.2125	27.2475	27.2125	27.2425	15512.0
2014-11-07 06:00:00	AAPL	Stock	27.2425	27.2475	27.2375	27.24	3200.0
2014-11-07 06:30:00	AAPL	Stock	27.2375	27.24	27.225	27.225	21284.0
2014-11-07 07:00:00	AAPL	Stock	27.225	27.225	27.1875	27.1875	61988.0
2014-11-07 07:30:00	AAPL	Stock	27.175	27.1825	27.1625	27.175	33744.0
2014-11-07 08:00:00	AAPL	Stock	27.175	27.225	26.93	27.1725	193080.0
2014-11-07 08:30:00	AAPL	Stock	27.1725	27.23	27.165	27.2	251932.0
2014-11-07 09:00:00	AAPL	Stock	27.205	27.2175	27.14	27.1775	393292.0
2014-11-07 09:30:00	AAPL	Stock	27.1875	27.3275	27.1375	27.3232	22945232.0
2014-11-07 10:00:00	AAPL	Stock	27.3225	27.33	27.1875	27.191	12897224.0
2014-11-07 10:30:00	AAPL	Stock	27.1922	27.265	27.1525	27.244	10402848.0
2014-11-07 11:00:00	AAPL	Stock	27.245	27.245	27.1778	27.2275	5982276.0
2014-11-07 11:30:00	AAPL	Stock	27.2275	27.235	27.175	27.2018	5000340.0
2014-11-07 12:00:00	AAPL	Stock	27.2	27.22	27.1825	27.22	4120392.0
2014-11-07 12:30:00	AAPL	Stock	27.2175	27.2225	27.1975	27.205	3025824.0
2014-11-07 13:00:00	AAPL	Stock	27.205	27.2525	27.195	27.25	5281640.0
2014-11-07 13:30:00	AAPL	Stock	27.25	27.2725	27.2425	27.2475	5152492.0
2014-11-07 14:00:00	AAPL	Stock	27.2475	27.2575	27.2125	27.23	4168924.0
2014-11-07 14:30:00	AAPL	Stock	27.2288	27.2525	27.2175	27.2362	4171180.0
2014-11-07 15:00:00	AAPL	Stock	27.235	27.2525	27.2025	27.2062	5693404.0
2014-11-07 15:30:00	AAPL	Stock	27.2075	27.25	27.205	27.25	15524332.0
2014-11-07 16:00:00	AAPL	Stock	27.2525	27.26	27.2202	27.2525	7565092.0
2014-11-07 16:30:00	AAPL	Stock	27.25	27.255	27.245	27.2525	82828.0
2014-11-07 17:00:00	AAPL	Stock	27.25	27.2675	27.235	27.2675	102124.0
2014-11-07 17:30:00	AAPL	Stock	27.255	27.265	27.2525	27.255	30476.0
2014-11-07 18:00:00	AAPL	Stock	27.255	27.26	27.2525	27.2525	13984.0
2014-11-07 18:30:00	AAPL	Stock	27.2525	27.2575	27.25	27.2575	45168.0
2014-11-07 19:00:00	AAPL	Stock	27.255	27.2575	27.2525	27.2575	23352.0
2014-11-07 19:30:00	AAPL	Stock	27.2575	27.26	27.2425	27.26	22164.0
2014-11-07 04:00:00	MSFT	Stock	48.85	48.85	48.85	48.85	100.0
2014-11-07 04:30:00	MSFT	Stock	48.85	48.85	48.85	48.85	100.0
2014-11-07 05:00:00	MSFT	Stock	48.85	48.85	48.85	48.85	914.0
2014-11-07 07:00:00	MSFT	Stock	48.73	48.73	48.73	48.73	100.0
2014-11-07 07:30:00	MSFT	Stock	48.67	48.7	48.64	48.7	3500.0
2014-11-07 08:00:00	MSFT	Stock	48.85	48.85	48.66	48.72	8730.0
2014-11-07 08:30:00	MSFT	Stock	48.7	48.97	48.7	48.8	30744.0
2014-11-07 09:00:00	MSFT	Stock	48.79	48.96	48.7	48.92	80015.0
2014-11-07 09:30:00	MSFT	Stock	48.92	48.92	48.29	48.45	3811250.0
2014-11-07 10:00:00	MSFT	Stock	48.455	48.455	48.3	48.39	2572254.0
2014-11-07 10:30:00	MSFT	Stock	48.39	48.52	48.31	48.41	3122101.0
2014-11-07 11:00:00	MSFT	Stock	48.41	48.52	48.32	48.51	1764560.0
2014-11-07 11:30:00	MSFT	Stock	48.51	48.56	48.395	48.4	1249805.0
2014-11-07 12:00:00	MSFT	Stock	48.405	48.49	48.385	48.43	867409.0
2014-11-07 12:30:00	MSFT	Stock	48.44	48.46	48.41	48.41	813384.0
2014-11-07 13:00:00	MSFT	Stock	48.41	48.54	48.4	48.52	914111.0
2014-11-07 13:30:00	MSFT	Stock	48.53	48.66	48.52	48.53	2064131.0
2014-11-07 14:00:00	MSFT	Stock	48.53	48.57	48.48	48.53	964085.0

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

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