PREVIEW / stock_30min / 2011-04-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-01.parquet
  size:    1.5 MB
  rows:    76,861
  symbols: 3,534

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-04-01 05:00:00	AAPL	Stock	12.4786	12.4786	12.4786	12.4786	2800.0
2011-04-01 06:00:00	AAPL	Stock	12.4707	12.4707	12.4707	12.4707	2800.0
2011-04-01 07:00:00	AAPL	Stock	12.4796	12.5179	12.4796	12.4968	131180.0
2011-04-01 07:30:00	AAPL	Stock	12.4968	12.4996	12.4732	12.4907	124348.0
2011-04-01 08:00:00	AAPL	Stock	12.4893	12.5	12.4446	12.4857	1027880.0
2011-04-01 08:30:00	AAPL	Stock	12.4907	12.5536	12.4875	12.5332	2262372.0
2011-04-01 09:00:00	AAPL	Stock	12.5329	12.5482	12.4446	12.5396	1389556.0
2011-04-01 09:30:00	AAPL	Stock	12.5396	12.5567	12.4336	12.4529	65824696.0
2011-04-01 10:00:00	AAPL	Stock	12.4545	12.4893	12.4511	12.478	28967932.0
2011-04-01 10:30:00	AAPL	Stock	12.4779	12.4929	12.44	12.4643	24331328.0
2011-04-01 11:00:00	AAPL	Stock	12.4639	12.4729	12.4575	12.4691	14763420.0
2011-04-01 11:30:00	AAPL	Stock	12.4704	12.4875	12.4664	12.4732	14295120.0
2011-04-01 12:00:00	AAPL	Stock	12.4739	12.4793	12.4621	12.4668	9135868.0
2011-04-01 12:30:00	AAPL	Stock	12.4671	12.4732	12.4546	12.4636	9378740.0
2011-04-01 13:00:00	AAPL	Stock	12.4625	12.4664	12.4482	12.4536	9319828.0
2011-04-01 13:30:00	AAPL	Stock	12.4536	12.4625	12.4225	12.4407	19531260.0
2011-04-01 14:00:00	AAPL	Stock	12.4411	12.4479	12.4339	12.4446	9551780.0
2011-04-01 14:30:00	AAPL	Stock	12.445	12.4461	12.3379	12.3621	46158392.0
2011-04-01 15:00:00	AAPL	Stock	12.3604	12.3693	12.2607	12.3071	76913592.0
2011-04-01 15:30:00	AAPL	Stock	12.3071	12.3186	12.28	12.3054	62197296.0
2011-04-01 16:00:00	AAPL	Stock	12.3054	12.4746	12.2861	12.2896	17840032.0
2011-04-01 16:30:00	AAPL	Stock	12.2896	12.5461	12.2875	12.2964	368676.0
2011-04-01 17:00:00	AAPL	Stock	12.2996	12.3	12.2911	12.2936	143500.0
2011-04-01 17:30:00	AAPL	Stock	12.2982	12.2993	12.2946	12.2989	49840.0
2011-04-01 18:00:00	AAPL	Stock	12.3	12.3057	12.2982	12.2982	237188.0
2011-04-01 18:30:00	AAPL	Stock	12.2982	12.3025	12.2964	12.2986	53872.0
2011-04-01 19:00:00	AAPL	Stock	12.3021	12.3032	12.2986	12.3021	154224.0
2011-04-01 19:30:00	AAPL	Stock	12.3021	12.3107	12.3	12.3107	155008.0
2011-04-01 06:00:00	MSFT	Stock	25.49	25.49	25.49	25.49	100.0
2011-04-01 07:00:00	MSFT	Stock	25.54	25.54	25.53	25.53	600.0
2011-04-01 07:30:00	MSFT	Stock	25.54	25.54	25.5	25.5	1400.0
2011-04-01 08:00:00	MSFT	Stock	25.5	25.54	25.36	25.5	42121.0
2011-04-01 08:30:00	MSFT	Stock	25.5	25.54	25.48	25.52	20288.0
2011-04-01 09:00:00	MSFT	Stock	25.52	25.56	25.39	25.56	33424.0
2011-04-01 09:30:00	MSFT	Stock	25.55	25.55	25.33	25.35	6114339.0
2011-04-01 10:00:00	MSFT	Stock	25.345	25.455	25.34	25.385	3735764.0
2011-04-01 10:30:00	MSFT	Stock	25.39	25.39	25.31	25.35	5978502.0
2011-04-01 11:00:00	MSFT	Stock	25.35	25.44	25.31	25.44	7867641.0
2011-04-01 11:30:00	MSFT	Stock	25.44	25.47	25.39	25.445	5717662.0
2011-04-01 12:00:00	MSFT	Stock	25.45	25.47	25.41	25.44	2158345.0
2011-04-01 12:30:00	MSFT	Stock	25.44	25.445	25.4	25.42	2562646.0
2011-04-01 13:00:00	MSFT	Stock	25.42	25.43	25.395	25.42	4606759.0
2011-04-01 13:30:00	MSFT	Stock	25.422	25.445	25.41	25.432	3565460.0
2011-04-01 14:00:00	MSFT	Stock	25.44	25.45	25.42	25.442	2304564.0
2011-04-01 14:30:00	MSFT	Stock	25.445	25.47	25.395	25.46	3762343.0
2011-04-01 15:00:00	MSFT	Stock	25.46	25.46	25.34	25.39	5327259.0
2011-04-01 15:30:00	MSFT	Stock	25.39	25.48	25.35	25.47	5679314.0
2011-04-01 16:00:00	MSFT	Stock	25.47	25.49	25.389	25.48	2619928.0
2011-04-01 16:30:00	MSFT	Stock	25.4	25.45	25.392	25.45	19300.0
2011-04-01 17:30:00	MSFT	Stock	25.47	25.47	25.47	25.47	1000.0

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

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