PREVIEW / stock_30min / 2013-12-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-16.parquet
  size:    1.6 MB
  rows:    83,368
  symbols: 3,554

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-12-16 04:00:00	AAPL	Stock	19.75	19.8107	19.75	19.8107	44240.0
2013-12-16 04:30:00	AAPL	Stock	19.8125	19.8125	19.8125	19.8125	2800.0
2013-12-16 05:00:00	AAPL	Stock	19.8511	19.8857	19.8396	19.8857	88200.0
2013-12-16 05:30:00	AAPL	Stock	19.8771	19.8786	19.8761	19.8761	19824.0
2013-12-16 06:00:00	AAPL	Stock	19.8929	19.8964	19.8482	19.8571	104832.0
2013-12-16 06:30:00	AAPL	Stock	19.8739	19.8739	19.8521	19.8661	35000.0
2013-12-16 07:00:00	AAPL	Stock	19.8661	19.8782	19.8571	19.8664	112420.0
2013-12-16 07:30:00	AAPL	Stock	19.8668	19.9143	19.8664	19.9068	294336.0
2013-12-16 08:00:00	AAPL	Stock	19.9068	19.9068	19.85	19.8804	1022140.0
2013-12-16 08:30:00	AAPL	Stock	19.8814	19.9068	19.875	19.8993	675164.0
2013-12-16 09:00:00	AAPL	Stock	19.8993	19.9118	19.8143	19.8225	1524460.0
2013-12-16 09:30:00	AAPL	Stock	19.8239	20.0486	19.8218	20.0461	53952948.0
2013-12-16 10:00:00	AAPL	Stock	20.0461	20.0843	19.9971	20.0732	27967044.0
2013-12-16 10:30:00	AAPL	Stock	20.0707	20.0857	20.0289	20.0514	19456892.0
2013-12-16 11:00:00	AAPL	Stock	20.0471	20.0861	20.0233	20.0732	14117124.0
2013-12-16 11:30:00	AAPL	Stock	20.0739	20.0893	20.0364	20.0395	9756236.0
2013-12-16 12:00:00	AAPL	Stock	20.0364	20.0425	19.9721	20.0182	11412660.0
2013-12-16 12:30:00	AAPL	Stock	20.0196	20.0386	19.9932	19.9968	8052380.0
2013-12-16 13:00:00	AAPL	Stock	19.9968	19.9991	19.9354	19.9839	13478388.0
2013-12-16 13:30:00	AAPL	Stock	19.9861	20.0164	19.9796	19.9836	6184108.0
2013-12-16 14:00:00	AAPL	Stock	19.9829	19.9893	19.9446	19.9775	7627228.0
2013-12-16 14:30:00	AAPL	Stock	19.9771	19.9971	19.9529	19.9804	5963328.0
2013-12-16 15:00:00	AAPL	Stock	19.9804	19.9811	19.8993	19.9032	12371156.0
2013-12-16 15:30:00	AAPL	Stock	19.9032	19.9211	19.8643	19.9087	21583436.0
2013-12-16 16:00:00	AAPL	Stock	19.9083	19.9915	19.8939	19.9107	24043544.0
2013-12-16 16:30:00	AAPL	Stock	19.9114	19.9232	19.9047	19.9232	358568.0
2013-12-16 17:00:00	AAPL	Stock	19.9243	19.925	19.9164	19.9164	8960.0
2013-12-16 17:30:00	AAPL	Stock	19.9179	19.9246	19.9179	19.9179	14000.0
2013-12-16 18:00:00	AAPL	Stock	19.9179	19.9179	19.9107	19.9107	122584.0
2013-12-16 18:30:00	AAPL	Stock	19.925	19.925	19.9196	19.925	33460.0
2013-12-16 19:00:00	AAPL	Stock	19.9243	19.9246	19.9025	19.9025	61796.0
2013-12-16 19:30:00	AAPL	Stock	19.9104	19.9161	19.9089	19.9161	49840.0
2013-12-16 07:00:00	MSFT	Stock	36.84	36.84	36.84	36.84	100.0
2013-12-16 07:30:00	MSFT	Stock	36.89	36.95	36.87	36.95	5823.0
2013-12-16 08:00:00	MSFT	Stock	36.91	36.94	36.89	36.91	13499.0
2013-12-16 08:30:00	MSFT	Stock	36.91	36.91	36.89	36.89	3858.0
2013-12-16 09:00:00	MSFT	Stock	36.89	36.89	36.55	36.72	245390.0
2013-12-16 09:30:00	MSFT	Stock	36.73	36.93	36.54	36.8	5041983.0
2013-12-16 10:00:00	MSFT	Stock	36.8	36.97	36.78	36.97	5184259.0
2013-12-16 10:30:00	MSFT	Stock	36.97	37.0	36.88	36.93	2193123.0
2013-12-16 11:00:00	MSFT	Stock	36.93	36.96	36.84	36.96	1743259.0
2013-12-16 11:30:00	MSFT	Stock	36.955	36.97	36.88	36.91	1332956.0
2013-12-16 12:00:00	MSFT	Stock	36.91	36.91	36.815	36.9	1349460.0
2013-12-16 12:30:00	MSFT	Stock	36.91	36.959	36.87	36.88	1027663.0
2013-12-16 13:00:00	MSFT	Stock	36.889	36.9	36.79	36.88	1172045.0
2013-12-16 13:30:00	MSFT	Stock	36.87	36.89	36.81	36.86	880039.0
2013-12-16 14:00:00	MSFT	Stock	36.86	36.96	36.84	36.89	1084752.0
2013-12-16 14:30:00	MSFT	Stock	36.89	36.92	36.87	36.876	770220.0
2013-12-16 15:00:00	MSFT	Stock	36.87	36.94	36.84	36.86	902674.0
2013-12-16 15:30:00	MSFT	Stock	36.86	36.93	36.85	36.88	3240693.0

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

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