PREVIEW / stock_30min / 2011-08-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-25.parquet
  size:    1.4 MB
  rows:    76,176
  symbols: 3,490

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-25 04:00:00	AAPL	Stock	12.7821	12.8393	12.75	12.8125	454944.0
2011-08-25 04:30:00	AAPL	Stock	12.8125	12.8232	12.7943	12.7943	241640.0
2011-08-25 05:00:00	AAPL	Stock	12.7861	12.8071	12.7857	12.8071	191100.0
2011-08-25 05:30:00	AAPL	Stock	12.8057	12.8268	12.7946	12.8125	408912.0
2011-08-25 06:00:00	AAPL	Stock	12.8218	12.8786	12.8214	12.8575	411040.0
2011-08-25 06:30:00	AAPL	Stock	12.8571	12.9071	12.8482	12.8571	468888.0
2011-08-25 07:00:00	AAPL	Stock	12.8579	13.1029	12.8579	13.0718	8566964.0
2011-08-25 07:30:00	AAPL	Stock	13.0718	13.1379	13.0714	13.1136	7404264.0
2011-08-25 08:00:00	AAPL	Stock	13.0497	13.2457	13.0497	13.15	26983488.0
2011-08-25 08:30:00	AAPL	Stock	13.15	13.1868	13.0643	13.0657	13198500.0
2011-08-25 09:00:00	AAPL	Stock	13.0657	13.1429	13.0357	13.0357	13773788.0
2011-08-25 09:30:00	AAPL	Stock	13.0386	13.3296	13.0357	13.1996	210633304.0
2011-08-25 10:00:00	AAPL	Stock	13.1996	13.2911	13.1589	13.2197	91946288.0
2011-08-25 10:30:00	AAPL	Stock	13.22	13.2482	13.1932	13.2086	49609756.0
2011-08-25 11:00:00	AAPL	Stock	13.2086	13.2993	13.1971	13.27	47662636.0
2011-08-25 11:30:00	AAPL	Stock	13.2704	13.3179	13.25	13.3143	33448520.0
2011-08-25 12:00:00	AAPL	Stock	13.3129	13.3443	13.2796	13.3065	37743272.0
2011-08-25 12:30:00	AAPL	Stock	13.3054	13.3068	13.2146	13.2525	36662444.0
2011-08-25 13:00:00	AAPL	Stock	13.2518	13.3011	13.2443	13.2989	21341544.0
2011-08-25 13:30:00	AAPL	Stock	13.2996	13.3104	13.2604	13.3104	24116988.0
2011-08-25 14:00:00	AAPL	Stock	13.31	13.3918	13.2821	13.3643	47855416.0
2011-08-25 14:30:00	AAPL	Stock	13.3643	13.4089	13.3304	13.3393	55760572.0
2011-08-25 15:00:00	AAPL	Stock	13.3393	13.4014	13.3125	13.3532	45917928.0
2011-08-25 15:30:00	AAPL	Stock	13.35	13.3643	13.3043	13.3468	64936200.0
2011-08-25 16:00:00	AAPL	Stock	13.3464	13.3571	13.26	13.3471	25235476.0
2011-08-25 16:30:00	AAPL	Stock	13.3445	13.3536	13.316	13.3464	457912.0
2011-08-25 17:00:00	AAPL	Stock	13.345	13.3486	13.3429	13.3429	646772.0
2011-08-25 17:30:00	AAPL	Stock	13.3432	13.3432	13.3296	13.3393	185948.0
2011-08-25 18:00:00	AAPL	Stock	13.3393	13.3464	13.3393	13.3429	83244.0
2011-08-25 18:30:00	AAPL	Stock	13.3393	13.3571	13.3329	13.3536	276164.0
2011-08-25 19:00:00	AAPL	Stock	13.3471	13.3571	13.3318	13.35	132076.0
2011-08-25 19:30:00	AAPL	Stock	13.35	13.3675	13.345	13.3675	121940.0
2011-08-25 04:00:00	MSFT	Stock	25.03	25.03	24.9	24.9	600.0
2011-08-25 05:00:00	MSFT	Stock	24.92	24.92	24.92	24.92	200.0
2011-08-25 07:30:00	MSFT	Stock	24.95	24.99	24.95	24.95	4150.0
2011-08-25 08:00:00	MSFT	Stock	24.98	25.0	24.95	25.0	6322.0
2011-08-25 08:30:00	MSFT	Stock	24.95	24.95	24.85	24.87	21300.0
2011-08-25 09:00:00	MSFT	Stock	24.88	25.11	24.79	25.11	61977.0
2011-08-25 09:30:00	MSFT	Stock	25.12	25.16	24.9	25.03	5620274.0
2011-08-25 10:00:00	MSFT	Stock	25.03	25.04	24.76	24.84	4772653.0
2011-08-25 10:30:00	MSFT	Stock	24.841	24.88	24.62	24.64	3958976.0
2011-08-25 11:00:00	MSFT	Stock	24.64	24.835	24.64	24.79	3168016.0
2011-08-25 11:30:00	MSFT	Stock	24.78	24.799	24.68	24.772	2370407.0
2011-08-25 12:00:00	MSFT	Stock	24.77	24.795	24.635	24.68	1830592.0
2011-08-25 12:30:00	MSFT	Stock	24.675	24.688	24.51	24.62	3169675.0
2011-08-25 13:00:00	MSFT	Stock	24.62	24.68	24.58	24.645	2215129.0
2011-08-25 13:30:00	MSFT	Stock	24.65	24.7	24.61	24.67	2944455.0
2011-08-25 14:00:00	MSFT	Stock	24.67	24.695	24.55	24.61	2147932.0
2011-08-25 14:30:00	MSFT	Stock	24.601	24.68	24.54	24.54	2347633.0
2011-08-25 15:00:00	MSFT	Stock	24.54	24.67	24.51	24.59	3242482.0

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

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