PREVIEW / stock_30min / 2013-06-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-24.parquet
  size:    1.5 MB
  rows:    81,574
  symbols: 3,521

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-06-24 04:00:00	AAPL	Stock	14.7143	14.7304	14.6786	14.6825	16800.0
2013-06-24 04:30:00	AAPL	Stock	14.6589	14.6589	14.6536	14.6589	16912.0
2013-06-24 05:00:00	AAPL	Stock	14.6432	14.6432	14.6429	14.6429	21336.0
2013-06-24 06:00:00	AAPL	Stock	14.6429	14.6429	14.6429	14.6429	5600.0
2013-06-24 06:30:00	AAPL	Stock	14.6321	14.6321	14.5896	14.6	53368.0
2013-06-24 07:00:00	AAPL	Stock	14.6107	14.6196	14.5964	14.5968	141484.0
2013-06-24 07:30:00	AAPL	Stock	14.5957	14.5957	14.5271	14.5689	375872.0
2013-06-24 08:00:00	AAPL	Stock	14.5714	14.75	14.5357	14.5429	878136.0
2013-06-24 08:30:00	AAPL	Stock	14.5443	14.6129	14.5393	14.6032	1548176.0
2013-06-24 09:00:00	AAPL	Stock	14.6	14.6014	14.5461	14.5504	1427132.0
2013-06-24 09:30:00	AAPL	Stock	14.55	14.595	14.3336	14.3696	77049784.0
2013-06-24 10:00:00	AAPL	Stock	14.3682	14.4167	14.3321	14.3551	46568172.0
2013-06-24 10:30:00	AAPL	Stock	14.3543	14.4089	14.3096	14.3571	37380588.0
2013-06-24 11:00:00	AAPL	Stock	14.36	14.3709	14.2161	14.2304	46477872.0
2013-06-24 11:30:00	AAPL	Stock	14.2311	14.3182	14.2307	14.2686	30318876.0
2013-06-24 12:00:00	AAPL	Stock	14.2687	14.2946	14.2554	14.2836	16297148.0
2013-06-24 12:30:00	AAPL	Stock	14.2857	14.3211	14.25	14.2789	18479104.0
2013-06-24 13:00:00	AAPL	Stock	14.2839	14.3457	14.2679	14.3325	20947220.0
2013-06-24 13:30:00	AAPL	Stock	14.3293	14.3561	14.2939	14.3464	15592360.0
2013-06-24 14:00:00	AAPL	Stock	14.3464	14.4104	14.3239	14.3875	24246348.0
2013-06-24 14:30:00	AAPL	Stock	14.3886	14.4546	14.3786	14.4325	25200224.0
2013-06-24 15:00:00	AAPL	Stock	14.4325	14.4911	14.3839	14.4086	32580408.0
2013-06-24 15:30:00	AAPL	Stock	14.4139	14.4679	14.3568	14.3621	42541716.0
2013-06-24 16:00:00	AAPL	Stock	14.3694	14.3857	14.3587	14.3596	10792012.0
2013-06-24 16:30:00	AAPL	Stock	14.3661	14.3825	14.2733	14.3714	1076404.0
2013-06-24 17:00:00	AAPL	Stock	14.3721	14.3857	14.3686	14.3768	129948.0
2013-06-24 17:30:00	AAPL	Stock	14.3754	14.3964	14.3675	14.3675	223468.0
2013-06-24 18:00:00	AAPL	Stock	14.375	14.375	14.3736	14.3736	39648.0
2013-06-24 18:30:00	AAPL	Stock	14.3743	14.3946	14.3743	14.3925	94976.0
2013-06-24 19:00:00	AAPL	Stock	14.3839	14.3839	14.3721	14.3721	88284.0
2013-06-24 19:30:00	AAPL	Stock	14.375	14.3918	14.375	14.3761	105756.0
2013-06-24 04:00:00	MSFT	Stock	33.06	33.06	33.06	33.06	100.0
2013-06-24 04:30:00	MSFT	Stock	33.06	33.06	33.06	33.06	100.0
2013-06-24 05:00:00	MSFT	Stock	32.97	32.97	32.97	32.97	100.0
2013-06-24 06:30:00	MSFT	Stock	32.99	32.99	32.99	32.99	100.0
2013-06-24 07:00:00	MSFT	Stock	32.96	32.96	32.96	32.96	1900.0
2013-06-24 07:30:00	MSFT	Stock	32.94	33.04	32.91	32.93	5100.0
2013-06-24 08:00:00	MSFT	Stock	33.0	33.05	32.94	33.0	117196.0
2013-06-24 08:30:00	MSFT	Stock	32.96	33.1	32.96	33.09	15326.0
2013-06-24 09:00:00	MSFT	Stock	33.04	33.09	32.95	32.95	77983.0
2013-06-24 09:30:00	MSFT	Stock	32.93	33.11	32.57	33.01	7486380.0
2013-06-24 10:00:00	MSFT	Stock	33.0	33.38	32.83	33.29	6238241.0
2013-06-24 10:30:00	MSFT	Stock	33.295	33.45	33.21	33.365	3406545.0
2013-06-24 11:00:00	MSFT	Stock	33.365	33.45	33.27	33.275	3153754.0
2013-06-24 11:30:00	MSFT	Stock	33.275	33.41	33.27	33.39	3163281.0
2013-06-24 12:00:00	MSFT	Stock	33.395	33.455	33.32	33.44	2586855.0
2013-06-24 12:30:00	MSFT	Stock	33.43	33.72	33.43	33.7	3239604.0
2013-06-24 13:00:00	MSFT	Stock	33.7	33.85	33.63	33.84	3275799.0
2013-06-24 13:30:00	MSFT	Stock	33.835	34.05	33.825	34.02	3446875.0
2013-06-24 14:00:00	MSFT	Stock	34.025	34.135	33.95	34.1	3096823.0

> showing 50 of 81,574 rows — these rows as CSV

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