PREVIEW / stock_30min / 2013-05-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-01.parquet
  size:    1.5 MB
  rows:    78,919
  symbols: 3,479

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-05-01 05:30:00	AAPL	Stock	15.8332	15.8332	15.8332	15.8332	12180.0
2013-05-01 06:30:00	AAPL	Stock	15.855	15.855	15.855	15.855	2800.0
2013-05-01 07:00:00	AAPL	Stock	15.8429	15.9107	15.8429	15.9046	391328.0
2013-05-01 07:30:00	AAPL	Stock	15.9118	15.9421	15.8693	15.9086	740012.0
2013-05-01 08:00:00	AAPL	Stock	15.9107	15.9286	15.8693	15.8986	1912624.0
2013-05-01 08:30:00	AAPL	Stock	15.8989	15.9082	15.8196	15.8279	2259460.0
2013-05-01 09:00:00	AAPL	Stock	15.8321	15.8821	15.8043	15.875	2871512.0
2013-05-01 09:30:00	AAPL	Stock	15.875	15.8904	15.6575	15.7054	97138300.0
2013-05-01 10:00:00	AAPL	Stock	15.7054	15.75	15.5429	15.6071	66767204.0
2013-05-01 10:30:00	AAPL	Stock	15.6041	15.7071	15.5139	15.6971	61362000.0
2013-05-01 11:00:00	AAPL	Stock	15.695	15.7018	15.63	15.6793	30847404.0
2013-05-01 11:30:00	AAPL	Stock	15.6829	15.725	15.6107	15.6582	21586432.0
2013-05-01 12:00:00	AAPL	Stock	15.6564	15.6911	15.6456	15.6699	13478556.0
2013-05-01 12:30:00	AAPL	Stock	15.6704	15.6893	15.6198	15.6336	12835284.0
2013-05-01 13:00:00	AAPL	Stock	15.6332	15.6425	15.5889	15.6279	17820908.0
2013-05-01 13:30:00	AAPL	Stock	15.6279	15.6321	15.5682	15.6175	16521764.0
2013-05-01 14:00:00	AAPL	Stock	15.6161	15.7143	15.6145	15.7032	31451672.0
2013-05-01 14:30:00	AAPL	Stock	15.7071	15.7857	15.6504	15.7796	36025780.0
2013-05-01 15:00:00	AAPL	Stock	15.7761	15.7814	15.6536	15.6854	35835380.0
2013-05-01 15:30:00	AAPL	Stock	15.6821	15.7143	15.6461	15.6939	33687724.0
2013-05-01 16:00:00	AAPL	Stock	15.6939	15.6939	15.6671	15.6714	14641620.0
2013-05-01 16:30:00	AAPL	Stock	15.6732	15.6854	15.6671	15.6818	268072.0
2013-05-01 17:00:00	AAPL	Stock	15.6889	15.6889	15.6779	15.6786	179620.0
2013-05-01 17:30:00	AAPL	Stock	15.6789	15.6875	15.6789	15.6875	99960.0
2013-05-01 18:00:00	AAPL	Stock	15.6943	15.6943	15.69	15.6929	34440.0
2013-05-01 18:30:00	AAPL	Stock	15.6914	15.6914	15.6807	15.6875	74340.0
2013-05-01 19:00:00	AAPL	Stock	15.6836	15.6907	15.6836	15.6904	28000.0
2013-05-01 19:30:00	AAPL	Stock	15.69	15.6946	15.6821	15.6943	137060.0
2013-05-01 07:00:00	MSFT	Stock	33.0	33.0	33.0	33.0	2500.0
2013-05-01 08:00:00	MSFT	Stock	32.99	33.08	32.96	32.96	5300.0
2013-05-01 08:30:00	MSFT	Stock	32.96	32.98	32.95	32.95	9225.0
2013-05-01 09:00:00	MSFT	Stock	32.94	33.1	32.85	32.93	49052.0
2013-05-01 09:30:00	MSFT	Stock	32.91	33.08	32.6	32.748	10725047.0
2013-05-01 10:00:00	MSFT	Stock	32.76	32.86	32.67	32.74	5468723.0
2013-05-01 10:30:00	MSFT	Stock	32.74	32.85	32.61	32.705	4562513.0
2013-05-01 11:00:00	MSFT	Stock	32.7	32.72	32.63	32.705	2066531.0
2013-05-01 11:30:00	MSFT	Stock	32.71	32.95	32.7	32.92	3464878.0
2013-05-01 12:00:00	MSFT	Stock	32.913	32.95	32.81	32.91	2313514.0
2013-05-01 12:30:00	MSFT	Stock	32.905	32.91	32.8	32.811	1959245.0
2013-05-01 13:00:00	MSFT	Stock	32.81	32.83	32.72	32.765	2371432.0
2013-05-01 13:30:00	MSFT	Stock	32.75	32.805	32.73	32.76	1707538.0
2013-05-01 14:00:00	MSFT	Stock	32.764	32.94	32.76	32.94	3175671.0
2013-05-01 14:30:00	MSFT	Stock	32.94	32.94	32.77	32.83	2607241.0
2013-05-01 15:00:00	MSFT	Stock	32.83	32.875	32.635	32.66	3357914.0
2013-05-01 15:30:00	MSFT	Stock	32.66	32.76	32.6	32.74	7222031.0
2013-05-01 16:00:00	MSFT	Stock	32.72	32.845	32.64	32.72	1752129.0
2013-05-01 16:30:00	MSFT	Stock	32.66	33.1	32.65	32.69	231669.0
2013-05-01 17:00:00	MSFT	Stock	32.69	32.72	32.66	32.66	3580.0
2013-05-01 17:30:00	MSFT	Stock	32.66	32.66	32.65	32.66	626.0
2013-05-01 18:00:00	MSFT	Stock	32.69	32.7	32.67	32.7	2724.0

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

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