PREVIEW / stock_30min / 2014-09-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-26.parquet
  size:    1.6 MB
  rows:    81,884
  symbols: 3,557

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-09-26 04:00:00	AAPL	Stock	24.6875	24.6875	24.4675	24.475	16008.0
2014-09-26 04:30:00	AAPL	Stock	24.525	24.525	24.52	24.52	21360.0
2014-09-26 05:00:00	AAPL	Stock	24.5175	24.5875	24.4925	24.5875	15488.0
2014-09-26 05:30:00	AAPL	Stock	24.5875	24.69	24.5875	24.6775	35516.0
2014-09-26 06:00:00	AAPL	Stock	24.675	24.675	24.5775	24.6125	71728.0
2014-09-26 06:30:00	AAPL	Stock	24.5975	24.5975	24.5925	24.5925	4000.0
2014-09-26 07:00:00	AAPL	Stock	24.5925	24.7675	24.5675	24.665	261976.0
2014-09-26 07:30:00	AAPL	Stock	24.6775	24.7125	24.6375	24.6375	229572.0
2014-09-26 08:00:00	AAPL	Stock	24.66	24.775	24.575	24.7475	938520.0
2014-09-26 08:30:00	AAPL	Stock	24.74	24.7475	24.6725	24.6875	912008.0
2014-09-26 09:00:00	AAPL	Stock	24.6875	24.7025	24.5975	24.645	801104.0
2014-09-26 09:30:00	AAPL	Stock	24.645	24.9025	24.6	24.8825	43165572.0
2014-09-26 10:00:00	AAPL	Stock	24.885	24.9975	24.8575	24.9435	26841780.0
2014-09-26 10:30:00	AAPL	Stock	24.9408	24.985	24.885	24.93	16059168.0
2014-09-26 11:00:00	AAPL	Stock	24.9242	24.9425	24.8525	24.8758	13579672.0
2014-09-26 11:30:00	AAPL	Stock	24.8775	24.8975	24.8125	24.885	12536096.0
2014-09-26 12:00:00	AAPL	Stock	24.8838	24.93	24.88	24.9237	7176136.0
2014-09-26 12:30:00	AAPL	Stock	24.9235	24.965	24.9075	24.95	8550064.0
2014-09-26 13:00:00	AAPL	Stock	24.9513	24.9825	24.9425	24.965	8984344.0
2014-09-26 13:30:00	AAPL	Stock	24.9625	25.0125	24.94	25.0125	10017900.0
2014-09-26 14:00:00	AAPL	Stock	25.01	25.1375	25.01	25.0875	19232280.0
2014-09-26 14:30:00	AAPL	Stock	25.0875	25.1475	25.0775	25.1162	13652968.0
2014-09-26 15:00:00	AAPL	Stock	25.1162	25.1775	25.1075	25.16	15633352.0
2014-09-26 15:30:00	AAPL	Stock	25.159	25.185	25.1075	25.1825	28564776.0
2014-09-26 16:00:00	AAPL	Stock	25.17	25.1875	24.4675	25.1625	9854428.0
2014-09-26 16:30:00	AAPL	Stock	25.1875	25.1875	24.922	25.1575	682516.0
2014-09-26 17:00:00	AAPL	Stock	25.1575	25.1875	25.1575	25.175	67420.0
2014-09-26 17:30:00	AAPL	Stock	25.1725	25.1825	25.17	25.175	31916.0
2014-09-26 18:00:00	AAPL	Stock	25.175	25.1875	25.165	25.1725	124312.0
2014-09-26 18:30:00	AAPL	Stock	25.1825	25.1825	25.1575	25.1575	45264.0
2014-09-26 19:00:00	AAPL	Stock	25.1575	25.175	25.1525	25.17	76260.0
2014-09-26 19:30:00	AAPL	Stock	25.17	25.175	25.16	25.175	75364.0
2014-09-26 05:00:00	MSFT	Stock	46.06	46.06	46.06	46.06	100.0
2014-09-26 06:00:00	MSFT	Stock	46.2	46.2	46.2	46.2	200.0
2014-09-26 06:30:00	MSFT	Stock	46.23	46.23	46.23	46.23	676.0
2014-09-26 07:00:00	MSFT	Stock	46.2	46.2	46.2	46.2	367.0
2014-09-26 07:30:00	MSFT	Stock	46.35	46.35	46.2	46.2	700.0
2014-09-26 08:00:00	MSFT	Stock	46.2	46.21	46.04	46.04	502700.0
2014-09-26 08:30:00	MSFT	Stock	46.21	46.25	46.12	46.23	7175.0
2014-09-26 09:00:00	MSFT	Stock	46.14	46.16	45.88	45.89	57858.0
2014-09-26 09:30:00	MSFT	Stock	45.9	46.29	45.76	46.155	4144589.0
2014-09-26 10:00:00	MSFT	Stock	46.15	46.31	46.14	46.21	1390577.0
2014-09-26 10:30:00	MSFT	Stock	46.21	46.29	46.11	46.26	1342274.0
2014-09-26 11:00:00	MSFT	Stock	46.233	46.31	46.17	46.17	1040769.0
2014-09-26 11:30:00	MSFT	Stock	46.18	46.19	46.08	46.114	1621207.0
2014-09-26 12:00:00	MSFT	Stock	46.12	46.145	46.07	46.135	1090980.0
2014-09-26 12:30:00	MSFT	Stock	46.14	46.15	46.02	46.13	1049606.0
2014-09-26 13:00:00	MSFT	Stock	46.13	46.195	46.1	46.16	1041029.0
2014-09-26 13:30:00	MSFT	Stock	46.159	46.22	46.1	46.2	871243.0
2014-09-26 14:00:00	MSFT	Stock	46.2	46.515	46.19	46.505	1716212.0

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

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