PREVIEW / stock_30min / 2012-07-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-12.parquet
  size:    1.4 MB
  rows:    74,529
  symbols: 3,446

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-12 04:00:00	AAPL	Stock	21.5357	21.5357	21.4893	21.5357	81200.0
2012-07-12 04:30:00	AAPL	Stock	21.5018	21.5018	21.5018	21.5018	4200.0
2012-07-12 06:00:00	AAPL	Stock	21.5	21.5179	21.4929	21.4932	40656.0
2012-07-12 06:30:00	AAPL	Stock	21.4821	21.4821	21.4107	21.4107	22400.0
2012-07-12 07:00:00	AAPL	Stock	21.4607	21.4646	21.4168	21.4282	211288.0
2012-07-12 07:30:00	AAPL	Stock	21.4218	21.4446	21.4054	21.4393	208516.0
2012-07-12 08:00:00	AAPL	Stock	21.4429	21.4893	21.4193	21.4821	898996.0
2012-07-12 08:30:00	AAPL	Stock	21.4754	21.5522	21.4196	21.4225	1111572.0
2012-07-12 09:00:00	AAPL	Stock	21.4286	21.4621	21.405	21.4425	2158688.0
2012-07-12 09:30:00	AAPL	Stock	21.4371	21.5071	21.3036	21.3495	69366332.0
2012-07-12 10:00:00	AAPL	Stock	21.3557	21.3642	21.2125	21.2771	39683504.0
2012-07-12 10:30:00	AAPL	Stock	21.28	21.2943	21.1671	21.2657	47559372.0
2012-07-12 11:00:00	AAPL	Stock	21.265	21.3314	21.2571	21.3211	31376240.0
2012-07-12 11:30:00	AAPL	Stock	21.3218	21.4175	21.3154	21.4036	26605628.0
2012-07-12 12:00:00	AAPL	Stock	21.4014	21.4218	21.3504	21.3728	20313132.0
2012-07-12 12:30:00	AAPL	Stock	21.3671	21.3829	21.3436	21.3568	12210688.0
2012-07-12 13:00:00	AAPL	Stock	21.3589	21.5371	21.3584	21.4921	36030428.0
2012-07-12 13:30:00	AAPL	Stock	21.4894	21.5525	21.4382	21.4486	26240508.0
2012-07-12 14:00:00	AAPL	Stock	21.4468	21.4889	21.4183	21.4873	20290760.0
2012-07-12 14:30:00	AAPL	Stock	21.4875	21.5314	21.4714	21.5243	17735844.0
2012-07-12 15:00:00	AAPL	Stock	21.5273	21.5307	21.4375	21.4868	25585504.0
2012-07-12 15:30:00	AAPL	Stock	21.4839	21.5168	21.3793	21.3874	38432632.0
2012-07-12 16:00:00	AAPL	Stock	21.3893	21.395	21.375	21.3946	3936156.0
2012-07-12 16:30:00	AAPL	Stock	21.3925	21.3993	21.3893	21.3982	460544.0
2012-07-12 17:00:00	AAPL	Stock	21.3964	21.3993	21.3939	21.3946	49392.0
2012-07-12 17:30:00	AAPL	Stock	21.395	21.395	21.3946	21.3946	14000.0
2012-07-12 18:00:00	AAPL	Stock	21.3971	21.4	21.2766	21.4	98588.0
2012-07-12 18:30:00	AAPL	Stock	21.4	21.4	21.3907	21.3936	91532.0
2012-07-12 19:00:00	AAPL	Stock	21.3964	21.3979	21.39	21.3925	79940.0
2012-07-12 19:30:00	AAPL	Stock	21.3921	21.3925	21.3571	21.3629	208208.0
2012-07-12 07:00:00	MSFT	Stock	29.22	29.22	29.15	29.15	500.0
2012-07-12 07:30:00	MSFT	Stock	29.14	29.32	29.14	29.24	24400.0
2012-07-12 08:00:00	MSFT	Stock	29.29	29.36	29.12	29.23	49879.0
2012-07-12 08:30:00	MSFT	Stock	29.28	29.3	29.14	29.18	68622.0
2012-07-12 09:00:00	MSFT	Stock	29.15	29.3	29.14	29.15	115671.0
2012-07-12 09:30:00	MSFT	Stock	29.18	29.18	28.7	28.76	9164166.0
2012-07-12 10:00:00	MSFT	Stock	28.76	28.84	28.71	28.805	7140283.0
2012-07-12 10:30:00	MSFT	Stock	28.805	28.81	28.73	28.79	3840631.0
2012-07-12 11:00:00	MSFT	Stock	28.8	28.89	28.78	28.819	3846523.0
2012-07-12 11:30:00	MSFT	Stock	28.82	28.89	28.78	28.87	2666939.0
2012-07-12 12:00:00	MSFT	Stock	28.87	28.88	28.77	28.784	1450807.0
2012-07-12 12:30:00	MSFT	Stock	28.788	28.81	28.72	28.74	3067427.0
2012-07-12 13:00:00	MSFT	Stock	28.745	28.87	28.72	28.84	3709357.0
2012-07-12 13:30:00	MSFT	Stock	28.85	28.875	28.77	28.79	2496325.0
2012-07-12 14:00:00	MSFT	Stock	28.79	28.835	28.75	28.805	2769022.0
2012-07-12 14:30:00	MSFT	Stock	28.8	28.84	28.75	28.78	5235127.0
2012-07-12 15:00:00	MSFT	Stock	28.78	28.79	28.71	28.739	5619719.0
2012-07-12 15:30:00	MSFT	Stock	28.73	28.76	28.54	28.63	10104397.0
2012-07-12 16:00:00	MSFT	Stock	28.63	28.774	28.6	28.6	1373936.0
2012-07-12 16:30:00	MSFT	Stock	28.63	28.64	28.62	28.63	98692.0

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

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