PREVIEW / stock_30min / 2013-07-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-17.parquet
  size:    1.5 MB
  rows:    77,552
  symbols: 3,497

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
2013-07-17 05:00:00	AAPL	Stock	15.335	15.335	15.3186	15.3186	29204.0
2013-07-17 05:30:00	AAPL	Stock	15.3221	15.3221	15.3221	15.3221	2800.0
2013-07-17 06:30:00	AAPL	Stock	15.3218	15.3221	15.3161	15.3161	66640.0
2013-07-17 07:00:00	AAPL	Stock	15.3214	15.3414	15.3214	15.3414	82152.0
2013-07-17 07:30:00	AAPL	Stock	15.3329	15.3375	15.2518	15.2786	677572.0
2013-07-17 08:00:00	AAPL	Stock	15.2893	15.3571	15.2893	15.3264	351036.0
2013-07-17 08:30:00	AAPL	Stock	15.3214	15.3554	15.3125	15.3375	971068.0
2013-07-17 09:00:00	AAPL	Stock	15.3446	15.3571	15.3186	15.35	1084860.0
2013-07-17 09:30:00	AAPL	Stock	15.35	15.4364	15.2936	15.385	40646816.0
2013-07-17 10:00:00	AAPL	Stock	15.3914	15.4357	15.3846	15.4196	18173428.0
2013-07-17 10:30:00	AAPL	Stock	15.4189	15.4279	15.3268	15.3768	19125484.0
2013-07-17 11:00:00	AAPL	Stock	15.3768	15.3989	15.3554	15.3582	9125564.0
2013-07-17 11:30:00	AAPL	Stock	15.3543	15.3596	15.325	15.3415	10077004.0
2013-07-17 12:00:00	AAPL	Stock	15.3404	15.3739	15.3321	15.3539	7877100.0
2013-07-17 12:30:00	AAPL	Stock	15.3543	15.3782	15.3489	15.3607	8208900.0
2013-07-17 13:00:00	AAPL	Stock	15.3589	15.3739	15.3529	15.3696	5690440.0
2013-07-17 13:30:00	AAPL	Stock	15.3707	15.3804	15.3482	15.3632	6713616.0
2013-07-17 14:00:00	AAPL	Stock	15.3575	15.3714	15.3375	15.3528	9202144.0
2013-07-17 14:30:00	AAPL	Stock	15.3521	15.3607	15.3232	15.3421	9729356.0
2013-07-17 15:00:00	AAPL	Stock	15.3382	15.3571	15.3325	15.3446	7514836.0
2013-07-17 15:30:00	AAPL	Stock	15.3446	15.3714	15.3268	15.3679	20210372.0
2013-07-17 16:00:00	AAPL	Stock	15.3636	15.3886	15.3593	15.3732	20302072.0
2013-07-17 16:30:00	AAPL	Stock	15.3682	15.37	15.3435	15.3646	139552.0
2013-07-17 17:00:00	AAPL	Stock	15.3689	15.3714	15.3686	15.3686	11172.0
2013-07-17 17:30:00	AAPL	Stock	15.3686	15.3736	15.3686	15.3736	17220.0
2013-07-17 18:00:00	AAPL	Stock	15.3764	15.3768	15.3732	15.3732	17500.0
2013-07-17 18:30:00	AAPL	Stock	15.3732	15.3732	15.3732	15.3732	5600.0
2013-07-17 19:00:00	AAPL	Stock	15.3764	15.3764	15.3682	15.3682	44436.0
2013-07-17 19:30:00	AAPL	Stock	15.3679	15.3729	15.3679	15.3729	16044.0
2013-07-17 07:00:00	MSFT	Stock	36.25	36.25	36.25	36.25	200.0
2013-07-17 08:00:00	MSFT	Stock	36.15	36.29	36.15	36.29	2462.0
2013-07-17 08:30:00	MSFT	Stock	36.29	36.34	36.29	36.34	4378.0
2013-07-17 09:00:00	MSFT	Stock	36.35	36.42	36.25	36.32	57883.0
2013-07-17 09:30:00	MSFT	Stock	36.34	36.39	36.02	36.115	3629394.0
2013-07-17 10:00:00	MSFT	Stock	36.12	36.14	36.02	36.09	3474152.0
2013-07-17 10:30:00	MSFT	Stock	36.09	36.11	35.9	35.975	3223932.0
2013-07-17 11:00:00	MSFT	Stock	35.975	36.055	35.97	36.02	1772752.0
2013-07-17 11:30:00	MSFT	Stock	36.015	36.05	35.87	36.05	1469587.0
2013-07-17 12:00:00	MSFT	Stock	36.045	36.13	36.04	36.1	1099612.0
2013-07-17 12:30:00	MSFT	Stock	36.09	36.15	36.06	36.08	736623.0
2013-07-17 13:00:00	MSFT	Stock	36.09	36.14	35.98	35.995	1050806.0
2013-07-17 13:30:00	MSFT	Stock	35.997	36.007	35.79	35.84	2747802.0
2013-07-17 14:00:00	MSFT	Stock	35.84	35.915	35.713	35.72	1841234.0
2013-07-17 14:30:00	MSFT	Stock	35.725	35.75	35.49	35.541	4552307.0
2013-07-17 15:00:00	MSFT	Stock	35.55	35.63	35.5	35.604	2128461.0
2013-07-17 15:30:00	MSFT	Stock	35.6	35.75	35.56	35.73	4658579.0
2013-07-17 16:00:00	MSFT	Stock	35.72	36.029	35.63	35.78	2533231.0
2013-07-17 16:30:00	MSFT	Stock	35.78	35.78	35.611	35.68	63109.0
2013-07-17 17:00:00	MSFT	Stock	36.11	36.11	35.56	35.6	2540.0
2013-07-17 17:30:00	MSFT	Stock	35.65	35.65	35.6	35.64	1350.0

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

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