PREVIEW / stock_30min / 2013-09-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-17.parquet
  size:    1.5 MB
  rows:    80,200
  symbols: 3,535

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-09-17 04:00:00	AAPL	Stock	15.8857	15.9739	15.8714	15.9461	124012.0
2013-09-17 04:30:00	AAPL	Stock	15.9443	15.9679	15.9329	15.9679	24920.0
2013-09-17 05:00:00	AAPL	Stock	15.9679	15.9821	15.9564	15.9589	38080.0
2013-09-17 05:30:00	AAPL	Stock	15.95	15.95	15.9429	15.9432	8400.0
2013-09-17 06:00:00	AAPL	Stock	15.9375	15.9429	15.9368	15.9429	11200.0
2013-09-17 06:30:00	AAPL	Stock	15.9286	15.9286	15.9068	15.9143	24640.0
2013-09-17 07:00:00	AAPL	Stock	15.9089	16.0093	15.9089	15.965	527884.0
2013-09-17 07:30:00	AAPL	Stock	15.9818	15.9843	15.9204	15.95	730520.0
2013-09-17 08:00:00	AAPL	Stock	15.9554	16.0171	15.9018	15.9846	1469468.0
2013-09-17 08:30:00	AAPL	Stock	15.9925	15.9993	15.9471	15.9671	1298920.0
2013-09-17 09:00:00	AAPL	Stock	15.9682	16.0429	15.9614	15.9996	3691128.0
2013-09-17 09:30:00	AAPL	Stock	15.9939	16.265	15.9821	16.2441	92423968.0
2013-09-17 10:00:00	AAPL	Stock	16.245	16.3321	16.1904	16.3089	54239304.0
2013-09-17 10:30:00	AAPL	Stock	16.3076	16.4125	16.2954	16.4015	36359484.0
2013-09-17 11:00:00	AAPL	Stock	16.4036	16.4182	16.3475	16.4025	27231484.0
2013-09-17 11:30:00	AAPL	Stock	16.4031	16.4104	16.2861	16.3118	28287812.0
2013-09-17 12:00:00	AAPL	Stock	16.3139	16.3796	16.3086	16.3641	15655892.0
2013-09-17 12:30:00	AAPL	Stock	16.3654	16.3836	16.3179	16.3586	12566596.0
2013-09-17 13:00:00	AAPL	Stock	16.3575	16.3679	16.3261	16.3429	7888440.0
2013-09-17 13:30:00	AAPL	Stock	16.3457	16.3918	16.3404	16.3534	12328848.0
2013-09-17 14:00:00	AAPL	Stock	16.3515	16.3689	16.3271	16.3289	10842160.0
2013-09-17 14:30:00	AAPL	Stock	16.3329	16.3511	16.2336	16.2607	26966772.0
2013-09-17 15:00:00	AAPL	Stock	16.2607	16.3014	16.2418	16.2704	17164840.0
2013-09-17 15:30:00	AAPL	Stock	16.2704	16.2829	16.2336	16.2564	33760160.0
2013-09-17 16:00:00	AAPL	Stock	16.2564	16.39	16.0556	16.2564	12547164.0
2013-09-17 16:30:00	AAPL	Stock	16.2393	16.2486	16.2393	16.2439	124824.0
2013-09-17 17:00:00	AAPL	Stock	16.2457	16.2507	16.2357	16.2357	184576.0
2013-09-17 17:30:00	AAPL	Stock	16.2464	16.2564	16.2321	16.2564	153412.0
2013-09-17 18:00:00	AAPL	Stock	16.2414	16.2564	16.2414	16.2493	109228.0
2013-09-17 18:30:00	AAPL	Stock	16.2429	16.2468	16.2429	16.2468	8400.0
2013-09-17 19:00:00	AAPL	Stock	16.2425	16.2475	16.2407	16.2464	61852.0
2013-09-17 19:30:00	AAPL	Stock	16.2496	16.2614	16.2496	16.2571	173656.0
2013-09-17 08:00:00	MSFT	Stock	32.8	32.8	32.73	32.73	2200.0
2013-09-17 08:30:00	MSFT	Stock	32.76	32.79	32.74	32.74	2644.0
2013-09-17 09:00:00	MSFT	Stock	32.74	34.49	32.74	33.42	11320417.0
2013-09-17 09:30:00	MSFT	Stock	33.44	33.47	32.96	32.97	20322974.0
2013-09-17 10:00:00	MSFT	Stock	32.96	33.11	32.91	32.94	10469247.0
2013-09-17 10:30:00	MSFT	Stock	32.95	33.05	32.9	33.035	5009161.0
2013-09-17 11:00:00	MSFT	Stock	33.04	33.13	33.03	33.1	4839488.0
2013-09-17 11:30:00	MSFT	Stock	33.1	33.13	32.96	33.035	5297948.0
2013-09-17 12:00:00	MSFT	Stock	33.04	33.1	33.03	33.03	2176069.0
2013-09-17 12:30:00	MSFT	Stock	33.035	33.06	32.99	33.005	2565795.0
2013-09-17 13:00:00	MSFT	Stock	33.01	33.045	32.92	33.01	2227860.0
2013-09-17 13:30:00	MSFT	Stock	33.01	33.05	32.97	32.97	1784095.0
2013-09-17 14:00:00	MSFT	Stock	32.973	33.0	32.93	32.96	2814126.0
2013-09-17 14:30:00	MSFT	Stock	32.955	33.01	32.94	32.998	1988124.0
2013-09-17 15:00:00	MSFT	Stock	32.99	33.03	32.95	33.01	2972613.0
2013-09-17 15:30:00	MSFT	Stock	33.01	33.01	32.91	32.94	6142284.0
2013-09-17 16:00:00	MSFT	Stock	32.935	33.13	32.831	32.96	2952071.0
2013-09-17 16:30:00	MSFT	Stock	32.986	32.986	32.93	32.93	22567.0

> showing 50 of 80,200 rows — these rows as CSV

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