PREVIEW / stock_30min / 2010-08-13

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-13.parquet
  size:    1.3 MB
  rows:    72,798
  symbols: 3,451

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
2010-08-13 05:30:00	AAPL	Stock	8.9975	8.9975	8.9975	8.9975	5600.0
2010-08-13 06:00:00	AAPL	Stock	8.9725	8.9725	8.9696	8.9696	9408.0
2010-08-13 07:00:00	AAPL	Stock	8.9714	8.9757	8.9439	8.9579	25200.0
2010-08-13 07:30:00	AAPL	Stock	8.95	8.9596	8.95	8.9596	62440.0
2010-08-13 08:00:00	AAPL	Stock	8.9636	8.9821	8.9596	8.9643	618632.0
2010-08-13 08:30:00	AAPL	Stock	8.9675	9.0061	8.9554	8.9875	2529828.0
2010-08-13 09:00:00	AAPL	Stock	8.9925	8.9964	8.9686	8.9696	1006124.0
2010-08-13 09:30:00	AAPL	Stock	8.9696	8.9957	8.9089	8.9461	74375672.0
2010-08-13 10:00:00	AAPL	Stock	8.9482	8.9621	8.9186	8.9404	40108544.0
2010-08-13 10:30:00	AAPL	Stock	8.9402	8.945	8.9054	8.9239	32800180.0
2010-08-13 11:00:00	AAPL	Stock	8.9243	8.9289	8.9089	8.9162	18866204.0
2010-08-13 11:30:00	AAPL	Stock	8.9154	8.9321	8.8961	8.9264	21778456.0
2010-08-13 12:00:00	AAPL	Stock	8.9267	8.9418	8.9239	8.9375	14127064.0
2010-08-13 12:30:00	AAPL	Stock	8.9391	8.9404	8.9268	8.94	9142056.0
2010-08-13 13:00:00	AAPL	Stock	8.94	8.9543	8.93	8.9382	13654480.0
2010-08-13 13:30:00	AAPL	Stock	8.9389	8.9511	8.9279	8.9314	10593100.0
2010-08-13 14:00:00	AAPL	Stock	8.9311	8.9336	8.9179	8.9254	12723508.0
2010-08-13 14:30:00	AAPL	Stock	8.925	8.9321	8.9143	8.9214	16081632.0
2010-08-13 15:00:00	AAPL	Stock	8.9232	8.9321	8.9186	8.9254	19303648.0
2010-08-13 15:30:00	AAPL	Stock	8.925	8.9321	8.8964	8.8964	51057020.0
2010-08-13 16:00:00	AAPL	Stock	8.8964	8.9925	8.8868	8.8929	12210800.0
2010-08-13 16:30:00	AAPL	Stock	8.8925	8.9232	8.8857	8.8904	338548.0
2010-08-13 17:00:00	AAPL	Stock	8.8893	8.8929	8.8868	8.8929	117544.0
2010-08-13 17:30:00	AAPL	Stock	8.8921	8.8929	8.8879	8.8879	67956.0
2010-08-13 18:00:00	AAPL	Stock	8.8893	8.8964	8.8857	8.89	281176.0
2010-08-13 18:30:00	AAPL	Stock	8.8904	8.8904	8.8864	8.8893	49140.0
2010-08-13 19:00:00	AAPL	Stock	8.8882	8.8882	8.8804	8.8875	85596.0
2010-08-13 19:30:00	AAPL	Stock	8.8839	8.8871	8.8786	8.8857	99792.0
2010-08-13 07:00:00	MSFT	Stock	24.48	24.48	24.48	24.48	150.0
2010-08-13 07:30:00	MSFT	Stock	24.48	24.48	24.48	24.48	1850.0
2010-08-13 08:00:00	MSFT	Stock	24.48	24.52	24.4	24.48	11795.0
2010-08-13 08:30:00	MSFT	Stock	24.48	24.55	24.48	24.55	4700.0
2010-08-13 09:00:00	MSFT	Stock	24.59	24.59	24.34	24.35	97238.0
2010-08-13 09:30:00	MSFT	Stock	24.35	24.41	24.24	24.4	5870324.0
2010-08-13 10:00:00	MSFT	Stock	24.4	24.4	24.28	24.36	3116646.0
2010-08-13 10:30:00	MSFT	Stock	24.37	24.41	24.33	24.38	3321374.0
2010-08-13 11:00:00	MSFT	Stock	24.389	24.43	24.36	24.43	2634465.0
2010-08-13 11:30:00	MSFT	Stock	24.42	24.46	24.35	24.45	2903204.0
2010-08-13 12:00:00	MSFT	Stock	24.445	24.5	24.43	24.465	2259184.0
2010-08-13 12:30:00	MSFT	Stock	24.47	24.5	24.42	24.495	1612591.0
2010-08-13 13:00:00	MSFT	Stock	24.492	24.61	24.49	24.58	2756320.0
2010-08-13 13:30:00	MSFT	Stock	24.58	24.6	24.54	24.59	2131788.0
2010-08-13 14:00:00	MSFT	Stock	24.59	24.67	24.57	24.63	3091965.0
2010-08-13 14:30:00	MSFT	Stock	24.62	24.66	24.56	24.59	2377184.0
2010-08-13 15:00:00	MSFT	Stock	24.59	24.61	24.52	24.52	2900868.0
2010-08-13 15:30:00	MSFT	Stock	24.52	24.54	24.39	24.4	5982677.0
2010-08-13 16:00:00	MSFT	Stock	24.4	24.496	24.38	24.395	2665419.0
2010-08-13 16:30:00	MSFT	Stock	24.37	24.53	24.35	24.36	9818.0
2010-08-13 17:00:00	MSFT	Stock	24.4	24.41	24.4	24.4	29750.0
2010-08-13 17:30:00	MSFT	Stock	24.4	24.4	24.4	24.4	953.0

> showing 50 of 72,798 rows — these rows as CSV

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