PREVIEW / stock_30min / 2013-09-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-05.parquet
  size:    1.5 MB
  rows:    78,954
  symbols: 3,506

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
2013-09-05 04:00:00	AAPL	Stock	17.9107	17.9107	17.8571	17.8571	52640.0
2013-09-05 04:30:00	AAPL	Stock	17.8757	17.8757	17.875	17.875	144396.0
2013-09-05 05:00:00	AAPL	Stock	17.8929	17.8929	17.8929	17.8929	2800.0
2013-09-05 05:30:00	AAPL	Stock	17.8725	17.8929	17.8725	17.8929	11424.0
2013-09-05 06:00:00	AAPL	Stock	17.8607	17.8607	17.8571	17.8571	11200.0
2013-09-05 06:30:00	AAPL	Stock	17.875	17.875	17.875	17.875	8428.0
2013-09-05 07:00:00	AAPL	Stock	17.875	17.9093	17.8607	17.8911	220192.0
2013-09-05 07:30:00	AAPL	Stock	17.8929	17.9204	17.8857	17.9	321804.0
2013-09-05 08:00:00	AAPL	Stock	17.9071	17.9204	17.8761	17.8893	1255324.0
2013-09-05 08:30:00	AAPL	Stock	17.8936	17.9096	17.8682	17.8929	954268.0
2013-09-05 09:00:00	AAPL	Stock	17.8939	17.9032	17.8582	17.8796	526372.0
2013-09-05 09:30:00	AAPL	Stock	17.8671	17.8814	17.7416	17.7679	55702304.0
2013-09-05 10:00:00	AAPL	Stock	17.7679	17.8025	17.7457	17.7736	20236048.0
2013-09-05 10:30:00	AAPL	Stock	17.7741	17.7821	17.7443	17.7511	18154780.0
2013-09-05 11:00:00	AAPL	Stock	17.7507	17.7818	17.7489	17.7667	10141740.0
2013-09-05 11:30:00	AAPL	Stock	17.7646	17.7746	17.7518	17.7621	7539280.0
2013-09-05 12:00:00	AAPL	Stock	17.7636	17.7636	17.6536	17.6886	24216808.0
2013-09-05 12:30:00	AAPL	Stock	17.6918	17.6935	17.63	17.6551	13194356.0
2013-09-05 13:00:00	AAPL	Stock	17.6586	17.7064	17.6525	17.6821	10276224.0
2013-09-05 13:30:00	AAPL	Stock	17.6811	17.6954	17.6625	17.6771	7176792.0
2013-09-05 14:00:00	AAPL	Stock	17.6664	17.6786	17.655	17.6632	6429500.0
2013-09-05 14:30:00	AAPL	Stock	17.6632	17.6786	17.6525	17.6769	6976900.0
2013-09-05 15:00:00	AAPL	Stock	17.6757	17.69	17.6661	17.6743	8578024.0
2013-09-05 15:30:00	AAPL	Stock	17.6761	17.6882	17.6507	17.6879	22493436.0
2013-09-05 16:00:00	AAPL	Stock	17.6832	17.7346	17.6759	17.6893	17495576.0
2013-09-05 16:30:00	AAPL	Stock	17.6882	17.8213	17.6857	17.6882	331128.0
2013-09-05 17:00:00	AAPL	Stock	17.7014	17.7232	17.6882	17.7211	424060.0
2013-09-05 17:30:00	AAPL	Stock	17.7211	17.77	17.7	17.7125	511448.0
2013-09-05 18:00:00	AAPL	Stock	17.7071	17.7089	17.7071	17.7089	28840.0
2013-09-05 18:30:00	AAPL	Stock	17.7107	17.7171	17.7107	17.7143	152208.0
2013-09-05 19:00:00	AAPL	Stock	17.7193	17.745	17.7143	17.7411	373212.0
2013-09-05 19:30:00	AAPL	Stock	17.7339	17.75	17.7321	17.75	160412.0
2013-09-05 04:00:00	MSFT	Stock	31.2	31.2	31.2	31.2	260.0
2013-09-05 04:30:00	MSFT	Stock	31.27	31.27	31.27	31.27	200.0
2013-09-05 05:00:00	MSFT	Stock	31.27	31.31	31.27	31.31	2000.0
2013-09-05 05:30:00	MSFT	Stock	31.3	31.3	31.3	31.3	100.0
2013-09-05 06:00:00	MSFT	Stock	31.21	31.21	31.2	31.2	1000.0
2013-09-05 06:30:00	MSFT	Stock	31.19	31.32	31.19	31.32	4058.0
2013-09-05 07:00:00	MSFT	Stock	31.29	31.29	31.22	31.22	3625.0
2013-09-05 07:30:00	MSFT	Stock	31.22	31.26	31.22	31.26	15914.0
2013-09-05 08:00:00	MSFT	Stock	31.24	31.32	31.19	31.25	55708.0
2013-09-05 08:30:00	MSFT	Stock	31.24	31.25	31.19	31.21	34518.0
2013-09-05 09:00:00	MSFT	Stock	31.21	31.22	31.07	31.09	198467.0
2013-09-05 09:30:00	MSFT	Stock	31.11	31.31	30.95	31.3	15576182.0
2013-09-05 10:00:00	MSFT	Stock	31.3	31.321	31.22	31.305	8316397.0
2013-09-05 10:30:00	MSFT	Stock	31.305	31.32	31.18	31.22	4901905.0
2013-09-05 11:00:00	MSFT	Stock	31.224	31.35	31.22	31.34	4944150.0
2013-09-05 11:30:00	MSFT	Stock	31.33	31.36	31.33	31.35	4592943.0
2013-09-05 12:00:00	MSFT	Stock	31.36	31.38	31.33	31.36	5402846.0
2013-09-05 12:30:00	MSFT	Stock	31.365	31.44	31.36	31.415	4285386.0

> showing 50 of 78,954 rows — these rows as CSV

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