PREVIEW / stock_30min / 2012-07-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-24.parquet
  size:    1.4 MB
  rows:    74,754
  symbols: 3,472

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
2012-07-24 04:00:00	AAPL	Stock	21.5536	21.5711	21.5536	21.5711	5600.0
2012-07-24 04:30:00	AAPL	Stock	21.6	21.6	21.5986	21.6	26040.0
2012-07-24 05:00:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	2800.0
2012-07-24 05:30:00	AAPL	Stock	21.5961	21.5964	21.5961	21.5964	30800.0
2012-07-24 06:00:00	AAPL	Stock	21.5982	21.5982	21.5714	21.5714	55720.0
2012-07-24 06:30:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	2800.0
2012-07-24 07:00:00	AAPL	Stock	21.5714	21.5982	21.5536	21.5561	448056.0
2012-07-24 07:30:00	AAPL	Stock	21.5704	21.5796	21.4971	21.5304	567420.0
2012-07-24 08:00:00	AAPL	Stock	21.545	21.6854	21.4879	21.6732	1777020.0
2012-07-24 08:30:00	AAPL	Stock	21.6736	21.7314	21.6732	21.7079	1965628.0
2012-07-24 09:00:00	AAPL	Stock	21.7086	21.7589	21.6921	21.6921	2649472.0
2012-07-24 09:30:00	AAPL	Stock	21.6904	21.7743	21.6	21.6368	90313440.0
2012-07-24 10:00:00	AAPL	Stock	21.6479	21.6711	21.5714	21.6219	30642024.0
2012-07-24 10:30:00	AAPL	Stock	21.6211	21.6786	21.5986	21.6314	23889208.0
2012-07-24 11:00:00	AAPL	Stock	21.6343	21.6714	21.6161	21.635	20715408.0
2012-07-24 11:30:00	AAPL	Stock	21.6332	21.6604	21.5757	21.5839	22443260.0
2012-07-24 12:00:00	AAPL	Stock	21.5821	21.5875	21.4154	21.4775	36210972.0
2012-07-24 12:30:00	AAPL	Stock	21.4775	21.5743	21.4382	21.5571	21337512.0
2012-07-24 13:00:00	AAPL	Stock	21.5543	21.5554	21.4529	21.4761	12666584.0
2012-07-24 13:30:00	AAPL	Stock	21.475	21.5436	21.4625	21.5204	14354452.0
2012-07-24 14:00:00	AAPL	Stock	21.5221	21.5225	21.4339	21.4471	19405652.0
2012-07-24 14:30:00	AAPL	Stock	21.4468	21.4786	21.4357	21.4711	18136916.0
2012-07-24 15:00:00	AAPL	Stock	21.4689	21.4693	21.3754	21.4486	35373072.0
2012-07-24 15:30:00	AAPL	Stock	21.4507	21.555	21.4286	21.4743	60848116.0
2012-07-24 16:00:00	AAPL	Stock	21.4746	21.5636	21.4196	21.4196	5765144.0
2012-07-24 16:30:00	AAPL	Stock	21.2861	21.6357	20.1786	20.2946	80666124.0
2012-07-24 17:00:00	AAPL	Stock	20.2957	21.4614	20.2954	20.4311	28110404.0
2012-07-24 17:30:00	AAPL	Stock	20.4286	20.4325	20.3396	20.3589	7261576.0
2012-07-24 18:00:00	AAPL	Stock	20.3589	20.3839	20.3257	20.3679	2469040.0
2012-07-24 18:30:00	AAPL	Stock	20.3671	20.3696	20.3432	20.3486	883736.0
2012-07-24 19:00:00	AAPL	Stock	20.3482	20.3525	20.3	20.3107	1778420.0
2012-07-24 19:30:00	AAPL	Stock	20.3071	20.3354	20.2725	20.2786	1817004.0
2012-07-24 07:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	500.0
2012-07-24 08:00:00	MSFT	Stock	29.25	29.25	29.24	29.25	2025.0
2012-07-24 08:30:00	MSFT	Stock	29.24	29.327	29.22	29.23	1000.0
2012-07-24 09:00:00	MSFT	Stock	29.23	29.485	29.21	29.25	408650.0
2012-07-24 09:30:00	MSFT	Stock	29.24	29.36	29.12	29.15	4363906.0
2012-07-24 10:00:00	MSFT	Stock	29.14	29.24	29.09	29.122	3751301.0
2012-07-24 10:30:00	MSFT	Stock	29.125	29.19	29.06	29.121	2813606.0
2012-07-24 11:00:00	MSFT	Stock	29.125	29.21	29.06	29.17	2658187.0
2012-07-24 11:30:00	MSFT	Stock	29.17	29.19	29.05	29.062	2438729.0
2012-07-24 12:00:00	MSFT	Stock	29.07	29.07	28.95	29.032	4585145.0
2012-07-24 12:30:00	MSFT	Stock	29.03	29.1	29.02	29.082	1692229.0
2012-07-24 13:00:00	MSFT	Stock	29.085	29.12	29.06	29.09	1445718.0
2012-07-24 13:30:00	MSFT	Stock	29.085	29.12	29.03	29.1	3444401.0
2012-07-24 14:00:00	MSFT	Stock	29.11	29.11	28.97	28.99	2158694.0
2012-07-24 14:30:00	MSFT	Stock	28.99	29.01	28.94	28.99	2783203.0
2012-07-24 15:00:00	MSFT	Stock	29.0	29.06	28.9	29.05	3346544.0
2012-07-24 15:30:00	MSFT	Stock	29.04	29.16	28.95	29.16	9415302.0
2012-07-24 16:00:00	MSFT	Stock	29.16	29.19	29.082	29.1	1224158.0

> showing 50 of 74,754 rows — these rows as CSV

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