PREVIEW / stock_30min / 2013-01-29

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-29.parquet
  size:    1.5 MB
  rows:    78,579
  symbols: 3,489

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-01-29 04:00:00	AAPL	Stock	16.1604	16.1786	16.1386	16.1429	137200.0
2013-01-29 04:30:00	AAPL	Stock	16.1429	16.1496	16.1382	16.1493	36400.0
2013-01-29 05:00:00	AAPL	Stock	16.1496	16.1643	16.1371	16.1571	47600.0
2013-01-29 05:30:00	AAPL	Stock	16.1571	16.1571	16.1525	16.1525	5600.0
2013-01-29 06:00:00	AAPL	Stock	16.1429	16.1429	16.1318	16.1421	41440.0
2013-01-29 06:30:00	AAPL	Stock	16.1329	16.1429	16.1071	16.1207	100884.0
2013-01-29 07:00:00	AAPL	Stock	16.1214	16.1286	16.1004	16.1232	273616.0
2013-01-29 07:30:00	AAPL	Stock	16.1232	16.1661	16.1232	16.125	231000.0
2013-01-29 08:00:00	AAPL	Stock	16.125	16.2036	16.1036	16.2011	1718360.0
2013-01-29 08:30:00	AAPL	Stock	16.1968	16.2593	16.1789	16.2054	3890348.0
2013-01-29 09:00:00	AAPL	Stock	16.2114	16.3804	16.2114	16.3741	7311332.0
2013-01-29 09:30:00	AAPL	Stock	16.375	16.375	16.2346	16.2468	105211736.0
2013-01-29 10:00:00	AAPL	Stock	16.2475	16.3161	16.1471	16.2861	64407700.0
2013-01-29 10:30:00	AAPL	Stock	16.286	16.4075	16.2771	16.3643	75724208.0
2013-01-29 11:00:00	AAPL	Stock	16.3643	16.4125	16.2968	16.3918	46532780.0
2013-01-29 11:30:00	AAPL	Stock	16.3904	16.4071	16.3393	16.4032	30109072.0
2013-01-29 12:00:00	AAPL	Stock	16.4043	16.4071	16.3036	16.3254	33209092.0
2013-01-29 12:30:00	AAPL	Stock	16.3254	16.365	16.3014	16.3125	21545160.0
2013-01-29 13:00:00	AAPL	Stock	16.3139	16.3482	16.275	16.2989	18767644.0
2013-01-29 13:30:00	AAPL	Stock	16.3004	16.3643	16.2926	16.3457	19184648.0
2013-01-29 14:00:00	AAPL	Stock	16.3471	16.3821	16.3075	16.3214	17126984.0
2013-01-29 14:30:00	AAPL	Stock	16.3179	16.3589	16.3086	16.3586	14380072.0
2013-01-29 15:00:00	AAPL	Stock	16.3593	16.4193	16.3526	16.4104	40184340.0
2013-01-29 15:30:00	AAPL	Stock	16.4089	16.4357	16.3596	16.3725	50173032.0
2013-01-29 16:00:00	AAPL	Stock	16.3668	16.3971	16.3293	16.3968	11925284.0
2013-01-29 16:30:00	AAPL	Stock	16.3893	16.4048	16.3668	16.3746	410116.0
2013-01-29 17:00:00	AAPL	Stock	16.3786	16.3925	16.3668	16.38	365736.0
2013-01-29 17:30:00	AAPL	Stock	16.38	16.3804	16.3679	16.3804	215992.0
2013-01-29 18:00:00	AAPL	Stock	16.38	16.38	16.3679	16.3714	214704.0
2013-01-29 18:30:00	AAPL	Stock	16.3707	16.3786	16.3679	16.3732	252588.0
2013-01-29 19:00:00	AAPL	Stock	16.3811	16.3918	16.3679	16.3686	272244.0
2013-01-29 19:30:00	AAPL	Stock	16.3704	16.375	16.3654	16.3654	136752.0
2013-01-29 07:00:00	MSFT	Stock	27.85	27.87	27.85	27.87	4200.0
2013-01-29 07:30:00	MSFT	Stock	27.85	27.85	27.84	27.84	5100.0
2013-01-29 08:00:00	MSFT	Stock	27.87	27.92	27.84	27.89	18170.0
2013-01-29 08:30:00	MSFT	Stock	27.89	27.89	27.86	27.87	8182.0
2013-01-29 09:00:00	MSFT	Stock	27.87	27.91	27.81	27.86	43155.0
2013-01-29 09:30:00	MSFT	Stock	27.82	27.9	27.7	27.79	4506610.0
2013-01-29 10:00:00	MSFT	Stock	27.795	27.82	27.6	27.74	4399212.0
2013-01-29 10:30:00	MSFT	Stock	27.74	27.89	27.71	27.85	3331552.0
2013-01-29 11:00:00	MSFT	Stock	27.85	28.0	27.81	27.992	3968863.0
2013-01-29 11:30:00	MSFT	Stock	27.995	28.04	27.93	27.955	3398717.0
2013-01-29 12:00:00	MSFT	Stock	27.955	28.0	27.92	27.945	1591344.0
2013-01-29 12:30:00	MSFT	Stock	27.943	27.96	27.86	27.9	4161739.0
2013-01-29 13:00:00	MSFT	Stock	27.905	27.96	27.87	27.95	1870981.0
2013-01-29 13:30:00	MSFT	Stock	27.95	27.98	27.92	27.955	1712415.0
2013-01-29 14:00:00	MSFT	Stock	27.956	28.0	27.94	27.97	1384491.0
2013-01-29 14:30:00	MSFT	Stock	27.965	27.99	27.95	27.972	1535134.0
2013-01-29 15:00:00	MSFT	Stock	27.975	28.09	27.97	28.08	3546267.0
2013-01-29 15:30:00	MSFT	Stock	28.075	28.13	28.0	28.01	7800111.0

> showing 50 of 78,579 rows — these rows as CSV

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