PREVIEW / stock_30min / 2014-03-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-18.parquet
  size:    1.6 MB
  rows:    83,532
  symbols: 3,560

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-03-18 04:00:00	AAPL	Stock	18.8054	18.8054	18.8032	18.8032	5600.0
2014-03-18 04:30:00	AAPL	Stock	18.7857	18.7857	18.7857	18.7857	2800.0
2014-03-18 05:30:00	AAPL	Stock	18.765	18.7671	18.7293	18.7671	14000.0
2014-03-18 06:00:00	AAPL	Stock	18.7714	18.7714	18.7714	18.7714	2800.0
2014-03-18 06:30:00	AAPL	Stock	18.7732	18.7732	18.7732	18.7732	11452.0
2014-03-18 07:30:00	AAPL	Stock	18.8143	18.8929	18.8143	18.8396	157528.0
2014-03-18 08:00:00	AAPL	Stock	18.8454	18.8675	18.7593	18.84	222824.0
2014-03-18 08:30:00	AAPL	Stock	18.8393	18.8929	18.8371	18.8593	870548.0
2014-03-18 09:00:00	AAPL	Stock	18.8593	18.8593	18.7696	18.7779	3621240.0
2014-03-18 09:30:00	AAPL	Stock	18.7832	18.9071	18.7571	18.8752	26547360.0
2014-03-18 10:00:00	AAPL	Stock	18.8754	18.8996	18.8579	18.8861	11412016.0
2014-03-18 10:30:00	AAPL	Stock	18.8815	18.9032	18.8482	18.8576	10153836.0
2014-03-18 11:00:00	AAPL	Stock	18.8598	18.9186	18.8546	18.9132	8430408.0
2014-03-18 11:30:00	AAPL	Stock	18.9171	18.9189	18.8761	18.8779	8234156.0
2014-03-18 12:00:00	AAPL	Stock	18.8775	18.9068	18.8696	18.8842	5222728.0
2014-03-18 12:30:00	AAPL	Stock	18.8868	18.9107	18.8821	18.9107	4617788.0
2014-03-18 13:00:00	AAPL	Stock	18.91	18.9189	18.885	18.9132	4957652.0
2014-03-18 13:30:00	AAPL	Stock	18.9132	18.9693	18.9075	18.9618	12173532.0
2014-03-18 14:00:00	AAPL	Stock	18.9611	18.9714	18.9332	18.9704	8485148.0
2014-03-18 14:30:00	AAPL	Stock	18.9704	18.9989	18.9659	18.9732	9438436.0
2014-03-18 15:00:00	AAPL	Stock	18.9739	18.9929	18.9611	18.9807	7522592.0
2014-03-18 15:30:00	AAPL	Stock	18.9807	18.9857	18.9482	18.9757	18169200.0
2014-03-18 16:00:00	AAPL	Stock	18.9786	18.9829	18.9111	18.9786	12176304.0
2014-03-18 16:30:00	AAPL	Stock	18.9786	18.9786	18.9607	18.9768	41468.0
2014-03-18 17:00:00	AAPL	Stock	18.9775	18.9782	18.9679	18.9729	45444.0
2014-03-18 17:30:00	AAPL	Stock	18.9786	18.9786	18.9711	18.9725	266980.0
2014-03-18 18:00:00	AAPL	Stock	18.9732	18.9732	18.9732	18.9732	4340.0
2014-03-18 18:30:00	AAPL	Stock	18.9743	18.975	18.9743	18.975	11060.0
2014-03-18 19:00:00	AAPL	Stock	18.9779	18.9779	18.9679	18.9707	23240.0
2014-03-18 19:30:00	AAPL	Stock	18.9714	18.9804	18.9714	18.9786	166376.0
2014-03-18 04:30:00	MSFT	Stock	38.05	38.05	38.05	38.05	100.0
2014-03-18 07:30:00	MSFT	Stock	38.38	38.4	38.38	38.4	4900.0
2014-03-18 08:00:00	MSFT	Stock	38.34	38.34	38.2	38.2	3650.0
2014-03-18 08:30:00	MSFT	Stock	38.3	38.3	38.25	38.26	7650.0
2014-03-18 09:00:00	MSFT	Stock	38.26	38.26	38.23	38.23	8950.0
2014-03-18 09:30:00	MSFT	Stock	38.26	39.12	38.22	39.1	8345501.0
2014-03-18 10:00:00	MSFT	Stock	39.1	39.55	39.02	39.414	7811397.0
2014-03-18 10:30:00	MSFT	Stock	39.41	39.9	39.37	39.64	8195196.0
2014-03-18 11:00:00	MSFT	Stock	39.64	39.69	39.46	39.63	5363583.0
2014-03-18 11:30:00	MSFT	Stock	39.64	39.69	39.51	39.61	3027513.0
2014-03-18 12:00:00	MSFT	Stock	39.61	39.72	39.46	39.54	3468768.0
2014-03-18 12:30:00	MSFT	Stock	39.543	39.55	39.42	39.446	2044159.0
2014-03-18 13:00:00	MSFT	Stock	39.45	39.56	39.36	39.549	1854448.0
2014-03-18 13:30:00	MSFT	Stock	39.54	39.66	39.52	39.575	1746429.0
2014-03-18 14:00:00	MSFT	Stock	39.575	39.63	39.5	39.58	2438743.0
2014-03-18 14:30:00	MSFT	Stock	39.58	39.64	39.5	39.584	1934027.0
2014-03-18 15:00:00	MSFT	Stock	39.59	39.7	39.56	39.605	2898257.0
2014-03-18 15:30:00	MSFT	Stock	39.605	39.62	39.41	39.55	6438500.0
2014-03-18 16:00:00	MSFT	Stock	39.56	39.568	39.44	39.56	5993197.0
2014-03-18 16:30:00	MSFT	Stock	39.49	39.615	39.47	39.47	89211.0

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

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