PREVIEW / stock_30min / 2010-09-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-28.parquet
  size:    1.4 MB
  rows:    76,264
  symbols: 3,480

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-09-28 05:30:00	AAPL	Stock	10.4196	10.4196	10.4196	10.4196	14000.0
2010-09-28 06:00:00	AAPL	Stock	10.4393	10.4393	10.4321	10.4321	5600.0
2010-09-28 06:30:00	AAPL	Stock	10.4211	10.4211	10.4211	10.4211	10500.0
2010-09-28 07:00:00	AAPL	Stock	10.4286	10.4393	10.4018	10.4018	104020.0
2010-09-28 07:30:00	AAPL	Stock	10.4054	10.4096	10.3939	10.4018	84000.0
2010-09-28 08:00:00	AAPL	Stock	10.4121	10.4329	10.4071	10.4186	1699208.0
2010-09-28 08:30:00	AAPL	Stock	10.4186	10.4375	10.4054	10.4268	1079988.0
2010-09-28 09:00:00	AAPL	Stock	10.425	10.4282	10.4179	10.4179	1078112.0
2010-09-28 09:30:00	AAPL	Stock	10.4182	10.4204	9.8214	10.1796	297823540.0
2010-09-28 10:00:00	AAPL	Stock	10.1782	10.2021	10.0875	10.1891	123738440.0
2010-09-28 10:30:00	AAPL	Stock	10.1882	10.3157	10.1786	10.3154	96437068.0
2010-09-28 11:00:00	AAPL	Stock	10.3139	10.3454	10.2618	10.3296	77301168.0
2010-09-28 11:30:00	AAPL	Stock	10.3307	10.3589	10.2679	10.2932	58473632.0
2010-09-28 12:00:00	AAPL	Stock	10.2929	10.3032	10.0811	10.2336	77958860.0
2010-09-28 12:30:00	AAPL	Stock	10.2316	10.2939	10.2225	10.2857	51430288.0
2010-09-28 13:00:00	AAPL	Stock	10.2844	10.2929	10.2557	10.2694	28326508.0
2010-09-28 13:30:00	AAPL	Stock	10.2721	10.3146	10.2654	10.3125	29689856.0
2010-09-28 14:00:00	AAPL	Stock	10.3121	10.3143	10.2571	10.2586	29659448.0
2010-09-28 14:30:00	AAPL	Stock	10.2571	10.2814	10.2418	10.2582	41664672.0
2010-09-28 15:00:00	AAPL	Stock	10.2582	10.2821	10.2346	10.2611	30321172.0
2010-09-28 15:30:00	AAPL	Stock	10.2621	10.3018	10.2339	10.2446	65945656.0
2010-09-28 16:00:00	AAPL	Stock	10.2446	10.2795	10.1635	10.25	11957932.0
2010-09-28 16:30:00	AAPL	Stock	10.2493	10.2952	10.245	10.2539	883456.0
2010-09-28 17:00:00	AAPL	Stock	10.2536	10.2661	10.2471	10.2596	480368.0
2010-09-28 17:30:00	AAPL	Stock	10.2596	10.2632	10.2571	10.2632	55832.0
2010-09-28 18:00:00	AAPL	Stock	10.2593	10.2679	10.245	10.265	361368.0
2010-09-28 18:30:00	AAPL	Stock	10.2636	10.2643	10.2596	10.2625	62160.0
2010-09-28 19:00:00	AAPL	Stock	10.2621	10.2621	10.2554	10.2607	244636.0
2010-09-28 19:30:00	AAPL	Stock	10.2625	10.2625	10.2568	10.2607	159236.0
2010-09-28 07:00:00	MSFT	Stock	24.75	24.75	24.75	24.75	200.0
2010-09-28 07:30:00	MSFT	Stock	24.75	24.75	24.75	24.75	700.0
2010-09-28 08:00:00	MSFT	Stock	24.77	24.79	24.74	24.75	5029.0
2010-09-28 08:30:00	MSFT	Stock	24.75	24.84	24.75	24.78	7922.0
2010-09-28 09:00:00	MSFT	Stock	24.78	24.87	24.73	24.83	44307.0
2010-09-28 09:30:00	MSFT	Stock	24.8	24.9	24.53	24.53	6512197.0
2010-09-28 10:00:00	MSFT	Stock	24.53	24.56	24.35	24.482	6923381.0
2010-09-28 10:30:00	MSFT	Stock	24.485	24.57	24.48	24.54	4114747.0
2010-09-28 11:00:00	MSFT	Stock	24.54	24.63	24.52	24.605	3664306.0
2010-09-28 11:30:00	MSFT	Stock	24.61	24.69	24.59	24.63	2896139.0
2010-09-28 12:00:00	MSFT	Stock	24.637	24.69	24.58	24.65	3034678.0
2010-09-28 12:30:00	MSFT	Stock	24.66	24.69	24.62	24.63	1802207.0
2010-09-28 13:00:00	MSFT	Stock	24.625	24.68	24.61	24.667	3665073.0
2010-09-28 13:30:00	MSFT	Stock	24.67	24.77	24.66	24.76	3048455.0
2010-09-28 14:00:00	MSFT	Stock	24.755	24.76	24.58	24.58	2471806.0
2010-09-28 14:30:00	MSFT	Stock	24.585	24.627	24.52	24.54	2732026.0
2010-09-28 15:00:00	MSFT	Stock	24.545	24.6	24.51	24.598	2588455.0
2010-09-28 15:30:00	MSFT	Stock	24.592	24.75	24.59	24.68	8136504.0
2010-09-28 16:00:00	MSFT	Stock	24.68	24.69	24.53	24.675	2562309.0
2010-09-28 16:30:00	MSFT	Stock	24.68	24.7	24.6	24.68	85698.0
2010-09-28 17:00:00	MSFT	Stock	24.67	24.72	24.66	24.72	948.0

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

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