PREVIEW / stock_30min / 2011-08-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-29.parquet
  size:    1.4 MB
  rows:    75,593
  symbols: 3,537

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
2011-08-29 04:00:00	AAPL	Stock	13.8086	13.8546	13.8086	13.825	27440.0
2011-08-29 04:30:00	AAPL	Stock	13.8136	13.8136	13.8136	13.8136	2800.0
2011-08-29 05:00:00	AAPL	Stock	13.8571	13.8571	13.8493	13.8493	11200.0
2011-08-29 06:00:00	AAPL	Stock	13.8393	13.8393	13.8204	13.8204	8400.0
2011-08-29 06:30:00	AAPL	Stock	13.8204	13.8204	13.8204	13.8204	28000.0
2011-08-29 07:00:00	AAPL	Stock	13.8079	13.8482	13.8079	13.8432	569744.0
2011-08-29 07:30:00	AAPL	Stock	13.8429	13.8679	13.8286	13.8286	484848.0
2011-08-29 08:00:00	AAPL	Stock	13.8461	13.8839	13.8171	13.8804	2128896.0
2011-08-29 08:30:00	AAPL	Stock	13.8804	13.8875	13.8661	13.8757	1028664.0
2011-08-29 09:00:00	AAPL	Stock	13.875	13.8929	13.8482	13.8596	1565788.0
2011-08-29 09:30:00	AAPL	Stock	13.8636	13.9821	13.8571	13.9511	89490800.0
2011-08-29 10:00:00	AAPL	Stock	13.9482	13.9632	13.9218	13.9397	37680944.0
2011-08-29 10:30:00	AAPL	Stock	13.9371	13.9475	13.9043	13.9221	27224036.0
2011-08-29 11:00:00	AAPL	Stock	13.9207	13.9375	13.8957	13.9311	21301392.0
2011-08-29 11:30:00	AAPL	Stock	13.9289	13.9625	13.9229	13.9429	22012564.0
2011-08-29 12:00:00	AAPL	Stock	13.9433	13.9682	13.9386	13.9418	20082720.0
2011-08-29 12:30:00	AAPL	Stock	13.9418	13.9554	13.9289	13.9339	18489492.0
2011-08-29 13:00:00	AAPL	Stock	13.9361	13.9464	13.895	13.8961	24428768.0
2011-08-29 13:30:00	AAPL	Stock	13.8964	13.9143	13.8714	13.9036	26269852.0
2011-08-29 14:00:00	AAPL	Stock	13.9025	13.9196	13.8839	13.9125	16168320.0
2011-08-29 14:30:00	AAPL	Stock	13.9142	13.9339	13.8993	13.9204	20325340.0
2011-08-29 15:00:00	AAPL	Stock	13.9204	13.9332	13.9093	13.9294	19885544.0
2011-08-29 15:30:00	AAPL	Stock	13.9286	13.9318	13.9068	13.9248	40285560.0
2011-08-29 16:00:00	AAPL	Stock	13.9261	13.9371	13.9111	13.925	7953120.0
2011-08-29 16:30:00	AAPL	Stock	13.925	13.9293	13.8969	13.9286	242452.0
2011-08-29 17:00:00	AAPL	Stock	13.9275	13.9293	13.925	13.9257	476364.0
2011-08-29 17:30:00	AAPL	Stock	13.9275	13.9279	13.925	13.925	149380.0
2011-08-29 18:00:00	AAPL	Stock	13.925	13.9275	13.9143	13.9146	77448.0
2011-08-29 18:30:00	AAPL	Stock	13.9143	13.9143	13.8961	13.9018	81564.0
2011-08-29 19:00:00	AAPL	Stock	13.8957	13.9021	13.8929	13.9018	88564.0
2011-08-29 19:30:00	AAPL	Stock	13.9036	13.9318	13.8968	13.9214	317856.0
2011-08-29 07:30:00	MSFT	Stock	25.5	25.5	25.42	25.42	600.0
2011-08-29 08:00:00	MSFT	Stock	25.41	25.55	25.41	25.54	7795.0
2011-08-29 08:30:00	MSFT	Stock	25.53	25.55	25.42	25.53	10685.0
2011-08-29 09:00:00	MSFT	Stock	25.56	25.57	25.48	25.51	25271.0
2011-08-29 09:30:00	MSFT	Stock	25.52	25.64	25.37	25.635	4099076.0
2011-08-29 10:00:00	MSFT	Stock	25.63	25.7	25.57	25.68	3010665.0
2011-08-29 10:30:00	MSFT	Stock	25.68	25.7	25.63	25.7	2482399.0
2011-08-29 11:00:00	MSFT	Stock	25.695	25.7	25.59	25.62	2387198.0
2011-08-29 11:30:00	MSFT	Stock	25.62	25.67	25.58	25.6	1671112.0
2011-08-29 12:00:00	MSFT	Stock	25.6	25.66	25.59	25.62	1724633.0
2011-08-29 12:30:00	MSFT	Stock	25.621	25.655	25.6	25.643	1820764.0
2011-08-29 13:00:00	MSFT	Stock	25.64	25.71	25.625	25.65	1564707.0
2011-08-29 13:30:00	MSFT	Stock	25.655	25.71	25.64	25.69	1465179.0
2011-08-29 14:00:00	MSFT	Stock	25.69	25.77	25.68	25.76	2184902.0
2011-08-29 14:30:00	MSFT	Stock	25.77	25.795	25.65	25.684	2022660.0
2011-08-29 15:00:00	MSFT	Stock	25.68	25.8	25.66	25.796	2338719.0
2011-08-29 15:30:00	MSFT	Stock	25.8	25.86	25.72	25.85	7632602.0
2011-08-29 16:00:00	MSFT	Stock	25.84	25.855	25.675	25.84	3190415.0
2011-08-29 16:30:00	MSFT	Stock	25.79	25.79	25.674	25.76	60300.0

> showing 50 of 75,593 rows — these rows as CSV

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