PREVIEW / stock_30min / 2014-01-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-30.parquet
  size:    1.6 MB
  rows:    83,244
  symbols: 3,526

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-01-30 04:00:00	AAPL	Stock	17.8232	17.8289	17.8232	17.8289	8400.0
2014-01-30 04:30:00	AAPL	Stock	17.8346	17.8346	17.7857	17.7857	30072.0
2014-01-30 05:00:00	AAPL	Stock	17.7893	17.7993	17.7764	17.7886	53480.0
2014-01-30 05:30:00	AAPL	Stock	17.7989	17.8282	17.7989	17.8282	38416.0
2014-01-30 06:00:00	AAPL	Stock	17.8164	17.8496	17.8036	17.8214	39312.0
2014-01-30 06:30:00	AAPL	Stock	17.8543	17.8839	17.8543	17.8839	31696.0
2014-01-30 07:00:00	AAPL	Stock	17.8857	17.9229	17.8857	17.8929	252756.0
2014-01-30 07:30:00	AAPL	Stock	17.8968	17.91	17.8625	17.8818	165620.0
2014-01-30 08:00:00	AAPL	Stock	17.9096	17.9096	17.7893	17.8036	1800624.0
2014-01-30 08:30:00	AAPL	Stock	17.7954	17.8643	17.7918	17.8479	1547896.0
2014-01-30 09:00:00	AAPL	Stock	17.8439	17.9786	17.8318	17.9325	2631188.0
2014-01-30 09:30:00	AAPL	Stock	17.9479	18.0893	17.9107	17.9557	81051208.0
2014-01-30 10:00:00	AAPL	Stock	17.9568	17.9568	17.8121	17.8125	44599016.0
2014-01-30 10:30:00	AAPL	Stock	17.8129	17.8625	17.7682	17.8068	32456060.0
2014-01-30 11:00:00	AAPL	Stock	17.8082	17.8446	17.7393	17.7957	30273936.0
2014-01-30 11:30:00	AAPL	Stock	17.8	17.9139	17.7936	17.8889	25501560.0
2014-01-30 12:00:00	AAPL	Stock	17.8871	17.9132	17.8775	17.8896	14644252.0
2014-01-30 12:30:00	AAPL	Stock	17.8914	17.9729	17.8811	17.9441	18816336.0
2014-01-30 13:00:00	AAPL	Stock	17.945	17.9596	17.8764	17.8786	19569984.0
2014-01-30 13:30:00	AAPL	Stock	17.8804	17.9014	17.8571	17.86	13031368.0
2014-01-30 14:00:00	AAPL	Stock	17.8621	17.8711	17.8357	17.8627	14689640.0
2014-01-30 14:30:00	AAPL	Stock	17.8636	17.8693	17.8393	17.8514	12572672.0
2014-01-30 15:00:00	AAPL	Stock	17.8489	17.8811	17.8432	17.8529	16137212.0
2014-01-30 15:30:00	AAPL	Stock	17.8518	17.8621	17.8196	17.8312	37085888.0
2014-01-30 16:00:00	AAPL	Stock	17.8371	17.8916	17.8089	17.8325	51028432.0
2014-01-30 16:30:00	AAPL	Stock	17.8371	17.8386	17.8214	17.8268	155260.0
2014-01-30 17:00:00	AAPL	Stock	17.825	17.8371	17.8214	17.8354	810628.0
2014-01-30 17:30:00	AAPL	Stock	17.8357	17.8464	17.8214	17.8346	194516.0
2014-01-30 18:00:00	AAPL	Stock	17.8368	17.8464	17.8339	17.8357	84364.0
2014-01-30 18:30:00	AAPL	Stock	17.8343	17.8393	17.8318	17.835	39256.0
2014-01-30 19:00:00	AAPL	Stock	17.8393	17.8393	17.8239	17.8239	12656.0
2014-01-30 19:30:00	AAPL	Stock	17.8304	17.8493	17.8304	17.8414	103656.0
2014-01-30 04:00:00	MSFT	Stock	36.26	36.26	36.26	36.26	100.0
2014-01-30 04:30:00	MSFT	Stock	36.66	36.66	36.66	36.66	100.0
2014-01-30 06:00:00	MSFT	Stock	36.48	36.48	36.48	36.48	306.0
2014-01-30 07:00:00	MSFT	Stock	36.69	36.69	36.69	36.69	500.0
2014-01-30 07:30:00	MSFT	Stock	36.67	36.67	36.48	36.48	7538.0
2014-01-30 08:00:00	MSFT	Stock	36.49	36.55	36.49	36.52	17139.0
2014-01-30 08:30:00	MSFT	Stock	36.54	36.65	36.52	36.65	18844.0
2014-01-30 09:00:00	MSFT	Stock	36.66	36.92	36.61	36.78	88267.0
2014-01-30 09:30:00	MSFT	Stock	36.75	36.87	36.415	36.477	5643282.0
2014-01-30 10:00:00	MSFT	Stock	36.47	36.52	36.23	36.24	2449234.0
2014-01-30 10:30:00	MSFT	Stock	36.24	36.46	36.235	36.46	2203655.0
2014-01-30 11:00:00	MSFT	Stock	36.44	36.62	36.41	36.54	1678295.0
2014-01-30 11:30:00	MSFT	Stock	36.55	36.79	36.53	36.73	2272889.0
2014-01-30 12:00:00	MSFT	Stock	36.74	36.76	36.67	36.71	1488058.0
2014-01-30 12:30:00	MSFT	Stock	36.72	36.8	36.7	36.785	1638154.0
2014-01-30 13:00:00	MSFT	Stock	36.78	36.8	36.76	36.77	1131184.0
2014-01-30 13:30:00	MSFT	Stock	36.77	36.795	36.72	36.725	1300202.0
2014-01-30 14:00:00	MSFT	Stock	36.72	36.725	36.59	36.705	1072330.0

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

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