PREVIEW / stock_30min / 2011-08-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-18.parquet
  size:    1.5 MB
  rows:    78,842
  symbols: 3,548

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-18 04:00:00	AAPL	Stock	13.5154	13.5154	13.4457	13.4457	5600.0
2011-08-18 04:30:00	AAPL	Stock	13.4114	13.4114	13.4114	13.4114	2800.0
2011-08-18 05:00:00	AAPL	Stock	13.3825	13.3825	13.2682	13.3736	64372.0
2011-08-18 05:30:00	AAPL	Stock	13.3736	13.3921	13.3721	13.3921	25200.0
2011-08-18 06:00:00	AAPL	Stock	13.3875	13.3929	13.3875	13.3929	11200.0
2011-08-18 06:30:00	AAPL	Stock	13.3804	13.3868	13.3804	13.3846	16800.0
2011-08-18 07:00:00	AAPL	Stock	13.4032	13.4354	13.3839	13.4014	366268.0
2011-08-18 07:30:00	AAPL	Stock	13.4082	13.4082	13.3536	13.3714	409108.0
2011-08-18 08:00:00	AAPL	Stock	13.3786	13.425	13.3643	13.3654	1728776.0
2011-08-18 08:30:00	AAPL	Stock	13.3654	13.3714	13.3236	13.325	2287852.0
2011-08-18 09:00:00	AAPL	Stock	13.3239	13.3321	13.2232	13.245	4883284.0
2011-08-18 09:30:00	AAPL	Stock	13.24	13.3089	13.0761	13.1668	145138560.0
2011-08-18 10:00:00	AAPL	Stock	13.1661	13.1661	13.0536	13.1365	88356436.0
2011-08-18 10:30:00	AAPL	Stock	13.1389	13.1571	13.09	13.145	51137240.0
2011-08-18 11:00:00	AAPL	Stock	13.1491	13.1686	13.1161	13.135	43045520.0
2011-08-18 11:30:00	AAPL	Stock	13.1337	13.1864	13.125	13.1741	46902856.0
2011-08-18 12:00:00	AAPL	Stock	13.1746	13.2028	13.1361	13.1753	38222044.0
2011-08-18 12:30:00	AAPL	Stock	13.1788	13.1911	13.16	13.1621	23364628.0
2011-08-18 13:00:00	AAPL	Stock	13.1607	13.1689	13.1071	13.1339	35920696.0
2011-08-18 13:30:00	AAPL	Stock	13.1346	13.14	13.0082	13.0236	58292444.0
2011-08-18 14:00:00	AAPL	Stock	13.0246	13.0996	13.017	13.0321	43869476.0
2011-08-18 14:30:00	AAPL	Stock	13.0325	13.0629	12.9432	12.9486	53680368.0
2011-08-18 15:00:00	AAPL	Stock	12.9525	12.9836	12.9061	12.9782	64222620.0
2011-08-18 15:30:00	AAPL	Stock	12.9782	13.1214	12.95	13.0661	124433148.0
2011-08-18 16:00:00	AAPL	Stock	13.1144	13.116	13.0416	13.0818	14672364.0
2011-08-18 16:30:00	AAPL	Stock	13.0807	13.1096	12.9548	13.0964	3945284.0
2011-08-18 17:00:00	AAPL	Stock	13.0946	13.1107	13.0932	13.1107	300888.0
2011-08-18 17:30:00	AAPL	Stock	13.1114	13.1246	13.0732	13.1071	363020.0
2011-08-18 18:00:00	AAPL	Stock	13.1107	13.1132	13.0732	13.0964	290192.0
2011-08-18 18:30:00	AAPL	Stock	13.1007	13.1107	13.1004	13.1071	132132.0
2011-08-18 19:00:00	AAPL	Stock	13.1029	13.1139	13.0954	13.0954	121800.0
2011-08-18 19:30:00	AAPL	Stock	13.1025	13.1357	13.1018	13.1018	402220.0
2011-08-18 04:00:00	MSFT	Stock	25.05	25.05	24.93	24.93	200.0
2011-08-18 05:00:00	MSFT	Stock	24.81	24.81	24.75	24.75	1000.0
2011-08-18 05:30:00	MSFT	Stock	24.69	24.74	24.69	24.74	2000.0
2011-08-18 06:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	2000.0
2011-08-18 07:00:00	MSFT	Stock	24.75	24.75	24.67	24.72	1250.0
2011-08-18 07:30:00	MSFT	Stock	24.79	24.79	24.66	24.7	7646.0
2011-08-18 08:00:00	MSFT	Stock	24.71	24.75	24.59	24.63	29293.0
2011-08-18 08:30:00	MSFT	Stock	24.61	24.7	24.58	24.6	27300.0
2011-08-18 09:00:00	MSFT	Stock	24.6	24.6	24.54	24.58	44548.0
2011-08-18 09:30:00	MSFT	Stock	24.58	24.88	24.5	24.51	10928940.0
2011-08-18 10:00:00	MSFT	Stock	24.51	24.515	24.03	24.39	13397365.0
2011-08-18 10:30:00	MSFT	Stock	24.38	24.47	24.25	24.41	5079613.0
2011-08-18 11:00:00	MSFT	Stock	24.41	24.42	24.25	24.405	3838897.0
2011-08-18 11:30:00	MSFT	Stock	24.405	24.92	24.39	24.885	9600210.0
2011-08-18 12:00:00	MSFT	Stock	24.88	25.09	24.8	24.919	10015359.0
2011-08-18 12:30:00	MSFT	Stock	24.92	24.94	24.78	24.812	3778577.0
2011-08-18 13:00:00	MSFT	Stock	24.81	24.845	24.7	24.8	3045625.0
2011-08-18 13:30:00	MSFT	Stock	24.795	24.83	24.75	24.81	4384038.0

> showing 50 of 78,842 rows — these rows as CSV

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