PREVIEW / stock_30min / 2013-06-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-05.parquet
  size:    1.5 MB
  rows:    77,804
  symbols: 3,515

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-06-05 04:00:00	AAPL	Stock	15.9471	15.9471	15.9471	15.9471	3640.0
2013-06-05 04:30:00	AAPL	Stock	15.9686	15.9686	15.9686	15.9686	5600.0
2013-06-05 05:30:00	AAPL	Stock	15.9664	15.9664	15.9575	15.9575	58576.0
2013-06-05 06:00:00	AAPL	Stock	15.9511	15.9511	15.9511	15.9511	2800.0
2013-06-05 06:30:00	AAPL	Stock	15.9332	15.9332	15.8946	15.9286	84000.0
2013-06-05 07:00:00	AAPL	Stock	15.9136	15.9443	15.8768	15.9443	202020.0
2013-06-05 07:30:00	AAPL	Stock	15.9396	15.9396	15.9107	15.9196	221676.0
2013-06-05 08:00:00	AAPL	Stock	15.9143	16.0357	15.8768	15.9554	1443484.0
2013-06-05 08:30:00	AAPL	Stock	15.9589	15.9643	15.9446	15.95	314216.0
2013-06-05 09:00:00	AAPL	Stock	15.9539	15.975	15.9107	15.9118	1366820.0
2013-06-05 09:30:00	AAPL	Stock	15.9161	16.0971	15.8957	16.0209	55345528.0
2013-06-05 10:00:00	AAPL	Stock	16.0214	16.0525	15.9107	15.9836	36585948.0
2013-06-05 10:30:00	AAPL	Stock	15.9787	15.9904	15.8929	15.9239	24687208.0
2013-06-05 11:00:00	AAPL	Stock	15.9209	15.9257	15.8468	15.8989	26982172.0
2013-06-05 11:30:00	AAPL	Stock	15.9029	15.9536	15.8843	15.898	13518260.0
2013-06-05 12:00:00	AAPL	Stock	15.9011	15.925	15.8836	15.9125	10893120.0
2013-06-05 12:30:00	AAPL	Stock	15.9096	15.9182	15.8596	15.8771	10097304.0
2013-06-05 13:00:00	AAPL	Stock	15.8707	15.9682	15.8679	15.9507	18779544.0
2013-06-05 13:30:00	AAPL	Stock	15.9511	15.9643	15.8964	15.9141	12039384.0
2013-06-05 14:00:00	AAPL	Stock	15.9089	15.9321	15.8893	15.8993	11007640.0
2013-06-05 14:30:00	AAPL	Stock	15.9011	15.9382	15.8975	15.9225	13254192.0
2013-06-05 15:00:00	AAPL	Stock	15.9179	15.9379	15.8771	15.9072	16363060.0
2013-06-05 15:30:00	AAPL	Stock	15.9118	15.9228	15.8764	15.8982	23376444.0
2013-06-05 16:00:00	AAPL	Stock	15.8968	16.0257	15.8875	15.9	5358472.0
2013-06-05 16:30:00	AAPL	Stock	15.8968	15.9125	15.8968	15.9	242284.0
2013-06-05 17:00:00	AAPL	Stock	15.9089	15.9164	15.9036	15.9164	90860.0
2013-06-05 17:30:00	AAPL	Stock	15.9146	15.9146	15.9036	15.9043	55580.0
2013-06-05 18:00:00	AAPL	Stock	15.9089	15.9107	15.9071	15.9071	34160.0
2013-06-05 18:30:00	AAPL	Stock	15.9107	15.9107	15.9075	15.9107	69468.0
2013-06-05 19:00:00	AAPL	Stock	15.9139	15.9139	15.9107	15.9107	19600.0
2013-06-05 19:30:00	AAPL	Stock	15.9093	15.9143	15.9071	15.9143	283080.0
2013-06-05 07:00:00	MSFT	Stock	34.98	34.99	34.84	34.89	1400.0
2013-06-05 07:30:00	MSFT	Stock	34.97	34.97	34.65	34.71	110176.0
2013-06-05 08:00:00	MSFT	Stock	34.73	34.79	34.7	34.76	10239.0
2013-06-05 08:30:00	MSFT	Stock	34.76	34.8	34.76	34.8	16900.0
2013-06-05 09:00:00	MSFT	Stock	34.81	34.81	34.57	34.59	110964.0
2013-06-05 09:30:00	MSFT	Stock	34.58	34.83	34.43	34.8	5858018.0
2013-06-05 10:00:00	MSFT	Stock	34.805	34.89	34.68	34.765	5552955.0
2013-06-05 10:30:00	MSFT	Stock	34.765	34.885	34.66	34.77	4629022.0
2013-06-05 11:00:00	MSFT	Stock	34.765	34.79	34.6	34.775	2750848.0
2013-06-05 11:30:00	MSFT	Stock	34.77	34.78	34.58	34.71	3219882.0
2013-06-05 12:00:00	MSFT	Stock	34.715	34.755	34.662	34.68	2090465.0
2013-06-05 12:30:00	MSFT	Stock	34.68	34.716	34.59	34.64	2517918.0
2013-06-05 13:00:00	MSFT	Stock	34.645	34.74	34.62	34.68	2184451.0
2013-06-05 13:30:00	MSFT	Stock	34.675	34.81	34.635	34.685	1967213.0
2013-06-05 14:00:00	MSFT	Stock	34.685	34.75	34.66	34.69	2139751.0
2013-06-05 14:30:00	MSFT	Stock	34.695	34.72	34.64	34.68	1757093.0
2013-06-05 15:00:00	MSFT	Stock	34.675	34.8	34.64	34.79	2518292.0
2013-06-05 15:30:00	MSFT	Stock	34.785	34.85	34.745	34.78	5470353.0
2013-06-05 16:00:00	MSFT	Stock	34.78	34.82	34.697	34.737	1646982.0

> showing 50 of 77,804 rows — these rows as CSV

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