PREVIEW / stock_30min / 2012-09-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-24.parquet
  size:    1.4 MB
  rows:    77,812
  symbols: 3,479

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-09-24 04:00:00	AAPL	Stock	24.9964	24.9964	24.9375	24.9375	49112.0
2012-09-24 04:30:00	AAPL	Stock	24.9464	24.9464	24.9286	24.9286	16800.0
2012-09-24 05:00:00	AAPL	Stock	24.9357	24.9446	24.8893	24.8893	22036.0
2012-09-24 05:30:00	AAPL	Stock	24.8768	24.8929	24.8768	24.8929	6776.0
2012-09-24 06:30:00	AAPL	Stock	24.8921	24.8929	24.875	24.875	19600.0
2012-09-24 07:00:00	AAPL	Stock	24.8446	24.875	24.8114	24.8125	434476.0
2012-09-24 07:30:00	AAPL	Stock	24.8211	24.8482	24.8179	24.825	527772.0
2012-09-24 08:00:00	AAPL	Stock	24.825	24.8571	24.8211	24.8486	1284696.0
2012-09-24 08:30:00	AAPL	Stock	24.8486	24.8486	24.3525	24.4464	15056636.0
2012-09-24 09:00:00	AAPL	Stock	24.4461	24.5379	24.3586	24.5268	10071600.0
2012-09-24 09:30:00	AAPL	Stock	24.5307	24.8193	24.3929	24.7646	141102220.0
2012-09-24 10:00:00	AAPL	Stock	24.7654	24.8257	24.6086	24.6482	61533640.0
2012-09-24 10:30:00	AAPL	Stock	24.6482	24.7118	24.6179	24.7055	34570816.0
2012-09-24 11:00:00	AAPL	Stock	24.6982	24.757	24.6507	24.6664	25655056.0
2012-09-24 11:30:00	AAPL	Stock	24.6668	24.6871	24.6264	24.6786	20988744.0
2012-09-24 12:00:00	AAPL	Stock	24.6779	24.6779	24.5461	24.56	35989744.0
2012-09-24 12:30:00	AAPL	Stock	24.5574	24.5804	24.4796	24.5396	35796880.0
2012-09-24 13:00:00	AAPL	Stock	24.5379	24.5689	24.4539	24.5107	36805440.0
2012-09-24 13:30:00	AAPL	Stock	24.5075	24.5114	24.4168	24.4583	28144508.0
2012-09-24 14:00:00	AAPL	Stock	24.4586	24.6057	24.4471	24.6043	36035020.0
2012-09-24 14:30:00	AAPL	Stock	24.605	24.6964	24.5811	24.6477	38551772.0
2012-09-24 15:00:00	AAPL	Stock	24.6471	24.7118	24.6268	24.6571	28864388.0
2012-09-24 15:30:00	AAPL	Stock	24.6557	24.6732	24.5964	24.6371	38602900.0
2012-09-24 16:00:00	AAPL	Stock	24.6386	24.6715	24.5276	24.6411	15266664.0
2012-09-24 16:30:00	AAPL	Stock	24.6429	24.766	24.6311	24.6393	498456.0
2012-09-24 17:00:00	AAPL	Stock	24.6354	24.6711	24.5732	24.575	744464.0
2012-09-24 17:30:00	AAPL	Stock	24.6386	24.6386	24.5782	24.5964	277480.0
2012-09-24 18:00:00	AAPL	Stock	24.5889	24.5889	24.4643	24.5179	962416.0
2012-09-24 18:30:00	AAPL	Stock	24.5057	24.5321	24.5007	24.525	146048.0
2012-09-24 19:00:00	AAPL	Stock	24.5321	24.5321	24.5146	24.5214	241332.0
2012-09-24 19:30:00	AAPL	Stock	24.5214	24.5357	24.5214	24.5321	238280.0
2012-09-24 07:00:00	MSFT	Stock	31.07	31.07	31.07	31.07	600.0
2012-09-24 07:30:00	MSFT	Stock	31.01	31.01	31.0	31.0	28625.0
2012-09-24 08:00:00	MSFT	Stock	31.07	31.23	31.06	31.07	10192.0
2012-09-24 08:30:00	MSFT	Stock	31.04	31.06	31.0	31.0	24433.0
2012-09-24 09:00:00	MSFT	Stock	31.03	31.1	30.97	31.04	15772.0
2012-09-24 09:30:00	MSFT	Stock	31.0	31.07	30.83	30.84	7829534.0
2012-09-24 10:00:00	MSFT	Stock	30.85	30.86	30.69	30.74	5549633.0
2012-09-24 10:30:00	MSFT	Stock	30.735	30.78	30.7	30.775	2705651.0
2012-09-24 11:00:00	MSFT	Stock	30.775	30.81	30.7	30.715	2474053.0
2012-09-24 11:30:00	MSFT	Stock	30.72	30.72	30.64	30.69	2229514.0
2012-09-24 12:00:00	MSFT	Stock	30.69	30.755	30.67	30.751	1893529.0
2012-09-24 12:30:00	MSFT	Stock	30.76	30.77	30.71	30.73	2286220.0
2012-09-24 13:00:00	MSFT	Stock	30.73	30.79	30.72	30.735	2261742.0
2012-09-24 13:30:00	MSFT	Stock	30.73	30.74	30.64	30.69	1759158.0
2012-09-24 14:00:00	MSFT	Stock	30.69	30.83	30.69	30.815	1582306.0
2012-09-24 14:30:00	MSFT	Stock	30.82	30.88	30.81	30.855	1564364.0
2012-09-24 15:00:00	MSFT	Stock	30.86	30.86	30.78	30.845	2075826.0
2012-09-24 15:30:00	MSFT	Stock	30.84	30.85	30.75	30.75	6357339.0
2012-09-24 16:00:00	MSFT	Stock	30.75	30.798	30.71	30.743	3156272.0

> showing 50 of 77,812 rows — these rows as CSV

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