PREVIEW / stock_30min / 2011-01-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-04.parquet
  size:    1.4 MB
  rows:    75,858
  symbols: 3,506

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-01-04 05:00:00	AAPL	Stock	11.7964	11.8332	11.7964	11.8332	5600.0
2011-01-04 06:30:00	AAPL	Stock	11.8157	11.8243	11.8157	11.8243	14000.0
2011-01-04 07:00:00	AAPL	Stock	11.825	11.8786	11.825	11.8786	1054452.0
2011-01-04 07:30:00	AAPL	Stock	11.8768	11.8875	11.8582	11.8682	356356.0
2011-01-04 08:00:00	AAPL	Stock	11.8654	11.8968	11.8489	11.875	2207268.0
2011-01-04 08:30:00	AAPL	Stock	11.8771	11.8829	11.8682	11.8739	1177120.0
2011-01-04 09:00:00	AAPL	Stock	11.8736	11.8821	11.8621	11.8739	1958488.0
2011-01-04 09:30:00	AAPL	Stock	11.8736	11.8761	11.8089	11.8282	52316096.0
2011-01-04 10:00:00	AAPL	Stock	11.8286	11.8421	11.7957	11.8141	33177144.0
2011-01-04 10:30:00	AAPL	Stock	11.8139	11.8196	11.7929	11.8161	19982116.0
2011-01-04 11:00:00	AAPL	Stock	11.8161	11.8216	11.7721	11.7782	27756456.0
2011-01-04 11:30:00	AAPL	Stock	11.7786	11.7964	11.7607	11.7611	17788512.0
2011-01-04 12:00:00	AAPL	Stock	11.7607	11.7729	11.7196	11.7354	23804228.0
2011-01-04 12:30:00	AAPL	Stock	11.7336	11.7625	11.7218	11.7589	15130584.0
2011-01-04 13:00:00	AAPL	Stock	11.7589	11.7814	11.7564	11.7743	12265064.0
2011-01-04 13:30:00	AAPL	Stock	11.775	11.7761	11.7625	11.7706	8441188.0
2011-01-04 14:00:00	AAPL	Stock	11.7707	11.8211	11.7686	11.815	22522220.0
2011-01-04 14:30:00	AAPL	Stock	11.8146	11.8179	11.7892	11.7996	13123908.0
2011-01-04 15:00:00	AAPL	Stock	11.8	11.8243	11.7811	11.8171	14782040.0
2011-01-04 15:30:00	AAPL	Stock	11.8171	11.8354	11.795	11.8321	28907060.0
2011-01-04 16:00:00	AAPL	Stock	11.8318	11.8319	11.8009	11.8317	6960548.0
2011-01-04 16:30:00	AAPL	Stock	11.8218	11.8831	11.7899	11.8282	310856.0
2011-01-04 17:00:00	AAPL	Stock	11.8279	11.8304	11.8168	11.8214	247072.0
2011-01-04 17:30:00	AAPL	Stock	11.8214	11.8218	11.8189	11.8189	141372.0
2011-01-04 18:00:00	AAPL	Stock	11.8214	11.8318	11.8186	11.8214	101724.0
2011-01-04 18:30:00	AAPL	Stock	11.8214	11.8214	11.8196	11.8214	28756.0
2011-01-04 19:00:00	AAPL	Stock	11.8214	11.8214	11.8196	11.82	79100.0
2011-01-04 19:30:00	AAPL	Stock	11.8214	11.8286	11.8214	11.8254	145740.0
2011-01-04 06:30:00	MSFT	Stock	28.03	28.03	28.03	28.03	100.0
2011-01-04 07:00:00	MSFT	Stock	28.03	28.03	28.03	28.03	700.0
2011-01-04 07:30:00	MSFT	Stock	28.02	28.03	28.02	28.03	5100.0
2011-01-04 08:00:00	MSFT	Stock	28.03	28.03	27.98	27.98	14300.0
2011-01-04 08:30:00	MSFT	Stock	27.98	27.98	27.95	27.98	1850.0
2011-01-04 09:00:00	MSFT	Stock	28.0	28.14	27.93	27.93	365555.0
2011-01-04 09:30:00	MSFT	Stock	27.94	28.01	27.85	27.96	4732636.0
2011-01-04 10:00:00	MSFT	Stock	27.97	28.05	27.95	28.01	5531570.0
2011-01-04 10:30:00	MSFT	Stock	28.01	28.055	27.95	27.96	2893580.0
2011-01-04 11:00:00	MSFT	Stock	27.96	27.99	27.92	27.955	2564233.0
2011-01-04 11:30:00	MSFT	Stock	27.95	27.99	27.95	27.96	3181417.0
2011-01-04 12:00:00	MSFT	Stock	27.96	28.005	27.95	27.99	3199022.0
2011-01-04 12:30:00	MSFT	Stock	27.99	28.02	27.94	28.015	3447136.0
2011-01-04 13:00:00	MSFT	Stock	28.015	28.04	27.99	28.005	2127020.0
2011-01-04 13:30:00	MSFT	Stock	28.01	28.06	28.0	28.04	3188341.0
2011-01-04 14:00:00	MSFT	Stock	28.03	28.05	28.0	28.03	2950044.0
2011-01-04 14:30:00	MSFT	Stock	28.03	28.1	28.02	28.08	3744765.0
2011-01-04 15:00:00	MSFT	Stock	28.08	28.17	28.07	28.11	4458007.0
2011-01-04 15:30:00	MSFT	Stock	28.12	28.12	28.035	28.05	6653077.0
2011-01-04 16:00:00	MSFT	Stock	28.08	28.1	28.015	28.042	2363728.0
2011-01-04 16:30:00	MSFT	Stock	28.05	28.117	28.0	28.05	259282.0
2011-01-04 17:00:00	MSFT	Stock	28.05	28.05	28.04	28.04	1428.0

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

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