PREVIEW / stock_30min / 2015-03-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-13.parquet
  size:    1.6 MB
  rows:    81,873
  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-03-13 04:00:00	AAPL	Stock	31.2	31.2	31.17	31.17	8400.0
2015-03-13 04:30:00	AAPL	Stock	31.21	31.2125	31.17	31.1875	12800.0
2015-03-13 05:00:00	AAPL	Stock	31.1925	31.1925	31.1875	31.1875	2400.0
2015-03-13 05:30:00	AAPL	Stock	31.1975	31.3	31.195	31.3	35520.0
2015-03-13 06:00:00	AAPL	Stock	31.2325	31.2475	31.185	31.2	39768.0
2015-03-13 06:30:00	AAPL	Stock	31.215	31.25	31.215	31.225	44400.0
2015-03-13 07:00:00	AAPL	Stock	31.225	31.25	31.2125	31.2125	64428.0
2015-03-13 07:30:00	AAPL	Stock	31.2125	31.2275	31.135	31.1375	97492.0
2015-03-13 08:00:00	AAPL	Stock	31.1625	31.25	31.0575	31.08	382904.0
2015-03-13 08:30:00	AAPL	Stock	31.0575	31.125	31.0375	31.07	211272.0
2015-03-13 09:00:00	AAPL	Stock	31.0775	31.1225	31.0275	31.1075	422444.0
2015-03-13 09:30:00	AAPL	Stock	31.1	31.3488	30.975	31.1945	30407228.0
2015-03-13 10:00:00	AAPL	Stock	31.1925	31.2275	31.0525	31.1	19561932.0
2015-03-13 10:30:00	AAPL	Stock	31.1	31.22	30.9475	30.949	13873952.0
2015-03-13 11:00:00	AAPL	Stock	30.95	31.0575	30.9275	30.9325	11562344.0
2015-03-13 11:30:00	AAPL	Stock	30.93	30.995	30.8925	30.9365	10303108.0
2015-03-13 12:00:00	AAPL	Stock	30.9375	30.945	30.73	30.8528	14541280.0
2015-03-13 12:30:00	AAPL	Stock	30.855	30.91	30.7675	30.84	8814248.0
2015-03-13 13:00:00	AAPL	Stock	30.8375	30.879	30.68	30.6925	11845752.0
2015-03-13 13:30:00	AAPL	Stock	30.6912	30.785	30.6912	30.7575	8263276.0
2015-03-13 14:00:00	AAPL	Stock	30.76	30.775	30.645	30.7575	8516804.0
2015-03-13 14:30:00	AAPL	Stock	30.7562	30.825	30.69	30.81	10554916.0
2015-03-13 15:00:00	AAPL	Stock	30.8125	30.825	30.7288	30.8075	10308040.0
2015-03-13 15:30:00	AAPL	Stock	30.805	30.91	30.7525	30.8975	21235428.0
2015-03-13 16:00:00	AAPL	Stock	30.89	30.9388	30.7865	30.8675	9418712.0
2015-03-13 16:30:00	AAPL	Stock	30.875	31.1038	30.8342	30.91	145344.0
2015-03-13 17:00:00	AAPL	Stock	30.9025	30.9025	30.865	30.875	126384.0
2015-03-13 17:30:00	AAPL	Stock	30.865	30.875	30.8625	30.865	24220.0
2015-03-13 18:00:00	AAPL	Stock	30.865	30.8975	30.8625	30.865	49048.0
2015-03-13 18:30:00	AAPL	Stock	30.8975	30.8975	30.86	30.875	130980.0
2015-03-13 19:00:00	AAPL	Stock	30.875	30.875	30.8475	30.865	52100.0
2015-03-13 19:30:00	AAPL	Stock	30.87	30.875	30.8525	30.865	49484.0
2015-03-13 05:30:00	MSFT	Stock	41.1	41.1	41.1	41.1	1000.0
2015-03-13 06:00:00	MSFT	Stock	41.2	41.2	41.07	41.12	3201.0
2015-03-13 06:30:00	MSFT	Stock	41.12	41.12	41.12	41.12	1561.0
2015-03-13 07:00:00	MSFT	Stock	41.1	41.1	41.04	41.04	589.0
2015-03-13 07:30:00	MSFT	Stock	41.09	41.1	40.99	40.99	2500.0
2015-03-13 08:00:00	MSFT	Stock	40.99	41.01	40.79	40.8	25868.0
2015-03-13 08:30:00	MSFT	Stock	40.8	40.87	40.79	40.83	16820.0
2015-03-13 09:00:00	MSFT	Stock	40.85	40.92	40.72	40.74	49627.0
2015-03-13 09:30:00	MSFT	Stock	40.7	41.039	40.61	41.02	9368946.0
2015-03-13 10:00:00	MSFT	Stock	41.02	41.09	40.8	40.84	5041889.0
2015-03-13 10:30:00	MSFT	Stock	40.835	40.95	40.808	40.84	4558819.0
2015-03-13 11:00:00	MSFT	Stock	40.83	40.92	40.77	40.86	3528784.0
2015-03-13 11:30:00	MSFT	Stock	40.865	40.87	40.755	40.843	3290566.0
2015-03-13 12:00:00	MSFT	Stock	40.85	41.0	40.78	40.98	3789621.0
2015-03-13 12:30:00	MSFT	Stock	40.98	41.09	40.93	40.99	2288823.0
2015-03-13 13:00:00	MSFT	Stock	41.0	41.02	40.95	41.01	2056826.0
2015-03-13 13:30:00	MSFT	Stock	41.0	41.21	41.0	41.12	2059308.0
2015-03-13 14:00:00	MSFT	Stock	41.124	41.2	41.1	41.2	2028982.0

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

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