PREVIEW / stock_30min / 2012-07-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-18.parquet
  size:    1.4 MB
  rows:    76,133
  symbols: 3,480

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
2012-07-18 05:00:00	AAPL	Stock	21.6289	21.6289	21.6289	21.6289	2800.0
2012-07-18 05:30:00	AAPL	Stock	21.625	21.6286	21.625	21.6286	15400.0
2012-07-18 06:00:00	AAPL	Stock	21.6214	21.6214	21.6214	21.6214	11200.0
2012-07-18 07:00:00	AAPL	Stock	21.6429	21.6429	21.6071	21.625	73052.0
2012-07-18 07:30:00	AAPL	Stock	21.6364	21.6607	21.6364	21.6607	107940.0
2012-07-18 08:00:00	AAPL	Stock	21.6511	21.6729	21.6375	21.6714	199584.0
2012-07-18 08:30:00	AAPL	Stock	21.6757	21.7	21.6564	21.6664	886704.0
2012-07-18 09:00:00	AAPL	Stock	21.6607	21.6696	21.6232	21.6679	551180.0
2012-07-18 09:30:00	AAPL	Stock	21.67	21.7264	21.5993	21.6318	41293644.0
2012-07-18 10:00:00	AAPL	Stock	21.6336	21.7143	21.6323	21.6432	26292588.0
2012-07-18 10:30:00	AAPL	Stock	21.6446	21.6693	21.6114	21.6554	20604780.0
2012-07-18 11:00:00	AAPL	Stock	21.6518	21.6682	21.6186	21.6546	13211744.0
2012-07-18 11:30:00	AAPL	Stock	21.655	21.6786	21.6357	21.6561	14015400.0
2012-07-18 12:00:00	AAPL	Stock	21.6586	21.6989	21.6486	21.6743	15692684.0
2012-07-18 12:30:00	AAPL	Stock	21.6779	21.6907	21.6307	21.6321	10605476.0
2012-07-18 13:00:00	AAPL	Stock	21.6321	21.6475	21.6107	21.6361	10088540.0
2012-07-18 13:30:00	AAPL	Stock	21.6336	21.6564	21.6071	21.6211	10892504.0
2012-07-18 14:00:00	AAPL	Stock	21.6261	21.6525	21.6186	21.6321	6824048.0
2012-07-18 14:30:00	AAPL	Stock	21.6317	21.6334	21.5557	21.5896	17935344.0
2012-07-18 15:00:00	AAPL	Stock	21.5921	21.6196	21.5743	21.6092	16656612.0
2012-07-18 15:30:00	AAPL	Stock	21.6068	21.6507	21.6014	21.6486	30276064.0
2012-07-18 16:00:00	AAPL	Stock	21.6491	21.6614	21.5032	21.6371	9576672.0
2012-07-18 16:30:00	AAPL	Stock	21.6286	21.7071	21.6017	21.6964	1440572.0
2012-07-18 17:00:00	AAPL	Stock	21.7007	21.7643	21.6521	21.7536	1902208.0
2012-07-18 17:30:00	AAPL	Stock	21.7514	21.7671	21.7368	21.7536	679196.0
2012-07-18 18:00:00	AAPL	Stock	21.7568	21.7568	21.7361	21.7432	488068.0
2012-07-18 18:30:00	AAPL	Stock	21.745	21.7479	21.7321	21.7321	77840.0
2012-07-18 19:00:00	AAPL	Stock	21.7318	21.7357	21.7232	21.7232	108836.0
2012-07-18 19:30:00	AAPL	Stock	21.7221	21.7321	21.7179	21.7321	284312.0
2012-07-18 07:00:00	MSFT	Stock	29.7	29.7	29.7	29.7	1000.0
2012-07-18 08:00:00	MSFT	Stock	29.68	29.73	29.67	29.7	7350.0
2012-07-18 08:30:00	MSFT	Stock	29.75	29.78	29.66	29.67	25910.0
2012-07-18 09:00:00	MSFT	Stock	29.69	29.72	29.58	29.58	23460.0
2012-07-18 09:30:00	MSFT	Stock	29.6	30.01	29.46	30.01	4008439.0
2012-07-18 10:00:00	MSFT	Stock	30.01	30.06	29.93	30.02	4206834.0
2012-07-18 10:30:00	MSFT	Stock	30.01	30.2	30.0	30.19	3025022.0
2012-07-18 11:00:00	MSFT	Stock	30.19	30.23	30.085	30.105	2473999.0
2012-07-18 11:30:00	MSFT	Stock	30.11	30.23	30.105	30.205	2168027.0
2012-07-18 12:00:00	MSFT	Stock	30.2	30.34	30.2	30.285	2305402.0
2012-07-18 12:30:00	MSFT	Stock	30.28	30.36	30.21	30.341	1829201.0
2012-07-18 13:00:00	MSFT	Stock	30.35	30.38	30.3	30.32	1484888.0
2012-07-18 13:30:00	MSFT	Stock	30.321	30.33	30.27	30.315	1963386.0
2012-07-18 14:00:00	MSFT	Stock	30.315	30.35	30.25	30.303	1810881.0
2012-07-18 14:30:00	MSFT	Stock	30.3	30.32	30.2	30.248	2079665.0
2012-07-18 15:00:00	MSFT	Stock	30.242	30.36	30.242	30.325	2717208.0
2012-07-18 15:30:00	MSFT	Stock	30.326	30.45	30.32	30.44	7210657.0
2012-07-18 16:00:00	MSFT	Stock	30.45	30.47	30.176	30.39	2620724.0
2012-07-18 16:30:00	MSFT	Stock	30.43	30.53	30.31	30.53	112983.0
2012-07-18 17:00:00	MSFT	Stock	30.51	30.55	30.45	30.55	46861.0
2012-07-18 17:30:00	MSFT	Stock	30.6	30.6	30.54	30.54	2137.0

> showing 50 of 76,133 rows — these rows as CSV

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