PREVIEW / stock_30min / 2014-05-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-27.parquet
  size:    1.6 MB
  rows:    82,146
  symbols: 3,574

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
2014-05-27 04:00:00	AAPL	Stock	21.9614	22.0714	21.9614	22.0714	19600.0
2014-05-27 04:30:00	AAPL	Stock	22.0732	22.0732	22.0668	22.0714	59640.0
2014-05-27 05:00:00	AAPL	Stock	22.0993	22.0993	22.0632	22.0632	59612.0
2014-05-27 05:30:00	AAPL	Stock	22.0679	22.0679	22.0575	22.0679	55272.0
2014-05-27 06:00:00	AAPL	Stock	22.0679	22.0871	22.0679	22.0714	45360.0
2014-05-27 06:30:00	AAPL	Stock	22.0625	22.0714	22.0375	22.0714	133336.0
2014-05-27 07:00:00	AAPL	Stock	22.0779	22.0821	22.0625	22.0714	271712.0
2014-05-27 07:30:00	AAPL	Stock	22.0714	22.0836	22.0625	22.0625	166068.0
2014-05-27 08:00:00	AAPL	Stock	22.0625	22.1061	22.0364	22.0714	1224944.0
2014-05-27 08:30:00	AAPL	Stock	22.0743	22.0975	22.0643	22.0879	492072.0
2014-05-27 09:00:00	AAPL	Stock	22.0886	22.0961	21.9836	22.0	1774024.0
2014-05-27 09:30:00	AAPL	Stock	21.9957	22.1746	21.9868	22.1364	64598044.0
2014-05-27 10:00:00	AAPL	Stock	22.1346	22.1949	22.12	22.1734	26883108.0
2014-05-27 10:30:00	AAPL	Stock	22.1737	22.1814	22.1193	22.16	13487712.0
2014-05-27 11:00:00	AAPL	Stock	22.1589	22.1854	22.1382	22.1386	13872348.0
2014-05-27 11:30:00	AAPL	Stock	22.1429	22.1714	22.1282	22.1632	9828728.0
2014-05-27 12:00:00	AAPL	Stock	22.1593	22.2018	22.1521	22.1721	10508848.0
2014-05-27 12:30:00	AAPL	Stock	22.1714	22.2371	22.1686	22.2277	9955568.0
2014-05-27 13:00:00	AAPL	Stock	22.2257	22.3111	22.2179	22.2915	19142172.0
2014-05-27 13:30:00	AAPL	Stock	22.2907	22.3129	22.2439	22.3054	17331216.0
2014-05-27 14:00:00	AAPL	Stock	22.3053	22.3521	22.2996	22.3332	16544920.0
2014-05-27 14:30:00	AAPL	Stock	22.3336	22.345	22.3114	22.3182	13481804.0
2014-05-27 15:00:00	AAPL	Stock	22.3171	22.3432	22.3075	22.3204	14631344.0
2014-05-27 15:30:00	AAPL	Stock	22.3196	22.3482	22.2964	22.3468	26878852.0
2014-05-27 16:00:00	AAPL	Stock	22.3468	22.3536	22.1519	22.3468	21342244.0
2014-05-27 16:30:00	AAPL	Stock	22.345	22.3571	22.345	22.3518	59920.0
2014-05-27 17:00:00	AAPL	Stock	22.3518	22.3807	22.3518	22.3661	377216.0
2014-05-27 17:30:00	AAPL	Stock	22.3707	22.3707	22.3607	22.3707	62944.0
2014-05-27 18:00:00	AAPL	Stock	22.3704	22.3704	22.3661	22.3675	43652.0
2014-05-27 18:30:00	AAPL	Stock	22.37	22.37	22.3468	22.3679	1114260.0
2014-05-27 19:00:00	AAPL	Stock	22.3643	22.3643	22.3596	22.3621	25200.0
2014-05-27 19:30:00	AAPL	Stock	22.3607	22.3657	22.3575	22.3657	63756.0
2014-05-27 04:00:00	MSFT	Stock	40.16	40.29	40.05	40.05	675.0
2014-05-27 04:30:00	MSFT	Stock	40.29	40.29	40.29	40.29	100.0
2014-05-27 07:30:00	MSFT	Stock	40.23	40.23	40.23	40.23	605.0
2014-05-27 08:00:00	MSFT	Stock	40.22	40.22	40.13	40.13	200.0
2014-05-27 08:30:00	MSFT	Stock	40.18	40.18	40.17	40.17	4382.0
2014-05-27 09:00:00	MSFT	Stock	40.16	40.25	40.16	40.25	15244.0
2014-05-27 09:30:00	MSFT	Stock	40.26	40.26	39.81	39.91	3748746.0
2014-05-27 10:00:00	MSFT	Stock	39.9	39.97	39.9	39.93	1524837.0
2014-05-27 10:30:00	MSFT	Stock	39.93	40.02	39.92	39.982	1321185.0
2014-05-27 11:00:00	MSFT	Stock	39.99	40.08	39.93	39.945	1754863.0
2014-05-27 11:30:00	MSFT	Stock	39.95	40.01	39.94	39.975	1055295.0
2014-05-27 12:00:00	MSFT	Stock	39.98	40.086	39.96	40.006	1629137.0
2014-05-27 12:30:00	MSFT	Stock	40.0	40.055	39.94	39.955	744599.0
2014-05-27 13:00:00	MSFT	Stock	39.96	39.96	39.89	39.9	1090233.0
2014-05-27 13:30:00	MSFT	Stock	39.9	40.0	39.89	39.985	657655.0
2014-05-27 14:00:00	MSFT	Stock	39.99	39.99	39.96	39.975	400406.0
2014-05-27 14:30:00	MSFT	Stock	39.98	39.98	39.91	39.957	1369864.0
2014-05-27 15:00:00	MSFT	Stock	39.957	40.03	39.94	40.018	940593.0

> showing 50 of 82,146 rows — these rows as CSV

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