PREVIEW / stock_30min / 2012-11-28

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-28.parquet
  size:    1.4 MB
  rows:    74,942
  symbols: 3,482

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-11-28 04:00:00	AAPL	Stock	20.8218	20.8218	20.8054	20.8054	5600.0
2012-11-28 06:00:00	AAPL	Stock	20.7946	20.7946	20.7946	20.7946	5600.0
2012-11-28 06:30:00	AAPL	Stock	20.7861	20.7861	20.7571	20.7571	42308.0
2012-11-28 07:00:00	AAPL	Stock	20.7529	20.8054	20.7529	20.8054	174552.0
2012-11-28 07:30:00	AAPL	Stock	20.7857	20.7857	20.7396	20.7464	232820.0
2012-11-28 08:00:00	AAPL	Stock	20.7425	20.8036	20.655	20.6996	1815324.0
2012-11-28 08:30:00	AAPL	Stock	20.7071	20.7071	20.6289	20.6429	2412788.0
2012-11-28 09:00:00	AAPL	Stock	20.6429	20.6607	20.5621	20.6196	5015752.0
2012-11-28 09:30:00	AAPL	Stock	20.6196	20.6429	20.5054	20.5771	81308136.0
2012-11-28 10:00:00	AAPL	Stock	20.5704	20.6161	20.4379	20.5904	66545416.0
2012-11-28 10:30:00	AAPL	Stock	20.5889	20.7036	20.5564	20.6189	46151616.0
2012-11-28 11:00:00	AAPL	Stock	20.6179	20.6966	20.6107	20.6643	30787876.0
2012-11-28 11:30:00	AAPL	Stock	20.6643	20.6704	20.6107	20.635	17241896.0
2012-11-28 12:00:00	AAPL	Stock	20.6346	20.8043	20.5907	20.7843	42553196.0
2012-11-28 12:30:00	AAPL	Stock	20.7814	20.8661	20.7709	20.8311	35907396.0
2012-11-28 13:00:00	AAPL	Stock	20.8379	20.8532	20.7871	20.8192	16201052.0
2012-11-28 13:30:00	AAPL	Stock	20.8193	20.9214	20.81	20.8304	26650848.0
2012-11-28 14:00:00	AAPL	Stock	20.8282	20.8571	20.7436	20.7848	23552648.0
2012-11-28 14:30:00	AAPL	Stock	20.785	20.8282	20.6982	20.7557	25406052.0
2012-11-28 15:00:00	AAPL	Stock	20.7618	20.864	20.7454	20.8546	25637668.0
2012-11-28 15:30:00	AAPL	Stock	20.8579	20.8639	20.8018	20.8143	39601912.0
2012-11-28 16:00:00	AAPL	Stock	20.8214	20.8329	20.5994	20.8139	16221072.0
2012-11-28 16:30:00	AAPL	Stock	20.8125	20.864	20.8043	20.8193	1259776.0
2012-11-28 17:00:00	AAPL	Stock	20.8089	20.82	20.8046	20.82	119028.0
2012-11-28 17:30:00	AAPL	Stock	20.82	20.8232	20.8139	20.8179	112672.0
2012-11-28 18:00:00	AAPL	Stock	20.8129	20.8268	20.8043	20.8054	292376.0
2012-11-28 18:30:00	AAPL	Stock	20.8096	20.8118	20.8	20.8075	55188.0
2012-11-28 19:00:00	AAPL	Stock	20.8157	20.8157	20.8007	20.8007	12600.0
2012-11-28 19:30:00	AAPL	Stock	20.8061	20.8189	20.8061	20.815	125188.0
2012-11-28 06:00:00	MSFT	Stock	27.23	27.23	27.23	27.23	1000.0
2012-11-28 07:30:00	MSFT	Stock	27.1	27.1	27.1	27.1	300.0
2012-11-28 08:00:00	MSFT	Stock	27.17	27.19	27.1	27.1	64010.0
2012-11-28 08:30:00	MSFT	Stock	27.14	27.14	27.02	27.08	136018.0
2012-11-28 09:00:00	MSFT	Stock	27.05	27.11	27.0	27.01	162432.0
2012-11-28 09:30:00	MSFT	Stock	27.01	27.03	26.77	26.87	6227171.0
2012-11-28 10:00:00	MSFT	Stock	26.86	27.07	26.82	27.02	5155837.0
2012-11-28 10:30:00	MSFT	Stock	27.02	27.23	27.01	27.18	4315316.0
2012-11-28 11:00:00	MSFT	Stock	27.17	27.18	27.05	27.095	4450259.0
2012-11-28 11:30:00	MSFT	Stock	27.1	27.15	27.06	27.1	3026401.0
2012-11-28 12:00:00	MSFT	Stock	27.1	27.12	27.03	27.09	5312684.0
2012-11-28 12:30:00	MSFT	Stock	27.09	27.24	27.09	27.22	3168026.0
2012-11-28 13:00:00	MSFT	Stock	27.23	27.23	27.14	27.173	1544173.0
2012-11-28 13:30:00	MSFT	Stock	27.18	27.3	27.17	27.222	2107417.0
2012-11-28 14:00:00	MSFT	Stock	27.225	27.26	27.17	27.19	1529543.0
2012-11-28 14:30:00	MSFT	Stock	27.19	27.27	27.18	27.27	1780375.0
2012-11-28 15:00:00	MSFT	Stock	27.27	27.32	27.21	27.32	2803933.0
2012-11-28 15:30:00	MSFT	Stock	27.32	27.39	27.31	27.34	5993723.0
2012-11-28 16:00:00	MSFT	Stock	27.34	27.39	27.102	27.33	3411670.0
2012-11-28 16:30:00	MSFT	Stock	27.33	27.37	27.33	27.36	128586.0
2012-11-28 17:00:00	MSFT	Stock	27.34	27.37	27.08	27.36	7400.0

> showing 50 of 74,942 rows — these rows as CSV

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