PREVIEW / stock_30min / 2012-07-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-09.parquet
  size:    1.4 MB
  rows:    73,082
  symbols: 3,475

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-09 04:00:00	AAPL	Stock	21.7321	21.7321	21.6071	21.6071	8400.0
2012-07-09 05:00:00	AAPL	Stock	21.5539	21.5893	21.5536	21.5893	77000.0
2012-07-09 06:30:00	AAPL	Stock	21.6321	21.6429	21.6321	21.635	16800.0
2012-07-09 07:00:00	AAPL	Stock	21.6354	21.655	21.635	21.6361	83944.0
2012-07-09 07:30:00	AAPL	Stock	21.6429	21.6518	21.6214	21.6389	101640.0
2012-07-09 08:00:00	AAPL	Stock	21.6568	21.6786	21.6	21.6754	728784.0
2012-07-09 08:30:00	AAPL	Stock	21.675	21.6786	21.625	21.6354	1234828.0
2012-07-09 09:00:00	AAPL	Stock	21.6464	21.6579	21.6071	21.6246	688800.0
2012-07-09 09:30:00	AAPL	Stock	21.6182	21.8382	21.5754	21.7774	77687680.0
2012-07-09 10:00:00	AAPL	Stock	21.7698	21.8179	21.7111	21.7975	31471272.0
2012-07-09 10:30:00	AAPL	Stock	21.7954	21.8892	21.7389	21.8857	43545796.0
2012-07-09 11:00:00	AAPL	Stock	21.8829	21.8875	21.8132	21.8418	20851796.0
2012-07-09 11:30:00	AAPL	Stock	21.8421	21.8532	21.7736	21.7868	18701704.0
2012-07-09 12:00:00	AAPL	Stock	21.785	21.8493	21.7818	21.815	20853840.0
2012-07-09 12:30:00	AAPL	Stock	21.8175	21.8571	21.8168	21.8507	14282520.0
2012-07-09 13:00:00	AAPL	Stock	21.8518	21.8711	21.8371	21.8589	14389956.0
2012-07-09 13:30:00	AAPL	Stock	21.8589	21.9193	21.8554	21.8986	19543244.0
2012-07-09 14:00:00	AAPL	Stock	21.8961	21.9125	21.8646	21.8704	14640556.0
2012-07-09 14:30:00	AAPL	Stock	21.8737	21.8896	21.7896	21.827	23502472.0
2012-07-09 15:00:00	AAPL	Stock	21.8243	21.8829	21.8214	21.8829	18122692.0
2012-07-09 15:30:00	AAPL	Stock	21.8825	21.925	21.8518	21.9246	39298280.0
2012-07-09 16:00:00	AAPL	Stock	21.9246	21.9464	21.82	21.94	11918844.0
2012-07-09 16:30:00	AAPL	Stock	21.94	21.9418	21.893	21.9346	510692.0
2012-07-09 17:00:00	AAPL	Stock	21.9321	21.9414	21.9307	21.9414	93688.0
2012-07-09 17:30:00	AAPL	Stock	21.9382	21.9418	21.9246	21.9407	60088.0
2012-07-09 18:00:00	AAPL	Stock	21.9393	21.9404	21.9339	21.9339	86016.0
2012-07-09 18:30:00	AAPL	Stock	21.9336	21.9375	21.9314	21.9375	122500.0
2012-07-09 19:00:00	AAPL	Stock	21.9375	21.9421	21.9364	21.9375	105728.0
2012-07-09 19:30:00	AAPL	Stock	21.9361	21.9464	21.9289	21.9464	219520.0
2012-07-09 07:30:00	MSFT	Stock	30.08	30.08	30.08	30.08	100.0
2012-07-09 08:00:00	MSFT	Stock	30.13	30.2	30.11	30.11	8624.0
2012-07-09 08:30:00	MSFT	Stock	30.18	30.18	30.14	30.15	3131.0
2012-07-09 09:00:00	MSFT	Stock	30.15	30.18	30.06	30.18	12150.0
2012-07-09 09:30:00	MSFT	Stock	30.12	30.23	30.02	30.05	2987178.0
2012-07-09 10:00:00	MSFT	Stock	30.05	30.1	29.92	29.96	2825235.0
2012-07-09 10:30:00	MSFT	Stock	29.95	29.97	29.83	29.94	1996282.0
2012-07-09 11:00:00	MSFT	Stock	29.945	30.02	29.91	29.99	3089462.0
2012-07-09 11:30:00	MSFT	Stock	29.985	30.0	29.79	29.79	1775073.0
2012-07-09 12:00:00	MSFT	Stock	29.79	29.86	29.78	29.83	1014040.0
2012-07-09 12:30:00	MSFT	Stock	29.835	29.92	29.82	29.89	827410.0
2012-07-09 13:00:00	MSFT	Stock	29.88	29.99	29.85	29.98	1298549.0
2012-07-09 13:30:00	MSFT	Stock	29.971	30.03	29.96	29.99	2132970.0
2012-07-09 14:00:00	MSFT	Stock	29.99	30.0	29.88	29.905	1601367.0
2012-07-09 14:30:00	MSFT	Stock	29.91	29.93	29.85	29.913	1358637.0
2012-07-09 15:00:00	MSFT	Stock	29.92	29.97	29.89	29.955	2176036.0
2012-07-09 15:30:00	MSFT	Stock	29.95	30.01	29.93	30.01	4488326.0
2012-07-09 16:00:00	MSFT	Stock	30.01	30.055	29.942	30.0	1917738.0
2012-07-09 16:30:00	MSFT	Stock	30.03	30.03	29.925	29.99	84023.0
2012-07-09 17:00:00	MSFT	Stock	29.98	29.98	29.96	29.96	3700.0
2012-07-09 18:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	300.0

> showing 50 of 73,082 rows — these rows as CSV

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