PREVIEW / stock_30min / 2011-07-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-14.parquet
  size:    1.4 MB
  rows:    73,878
  symbols: 3,518

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
2011-07-14 04:30:00	AAPL	Stock	12.7857	12.7907	12.7857	12.7893	16520.0
2011-07-14 05:30:00	AAPL	Stock	12.7761	12.7761	12.7321	12.7321	14000.0
2011-07-14 06:00:00	AAPL	Stock	12.7707	12.8125	12.7707	12.8107	86520.0
2011-07-14 06:30:00	AAPL	Stock	12.7975	12.8371	12.7864	12.8214	117180.0
2011-07-14 07:00:00	AAPL	Stock	12.8221	12.885	12.8114	12.885	478464.0
2011-07-14 07:30:00	AAPL	Stock	12.8904	12.9093	12.875	12.9	1348088.0
2011-07-14 08:00:00	AAPL	Stock	12.9054	12.9143	12.8857	12.9004	1911168.0
2011-07-14 08:30:00	AAPL	Stock	12.8982	12.9446	12.8893	12.9404	2802716.0
2011-07-14 09:00:00	AAPL	Stock	12.9364	12.9425	12.8896	12.8914	2818032.0
2011-07-14 09:30:00	AAPL	Stock	12.8936	12.9146	12.8286	12.8921	72403296.0
2011-07-14 10:00:00	AAPL	Stock	12.8929	12.91	12.8854	12.8961	33815768.0
2011-07-14 10:30:00	AAPL	Stock	12.8961	12.8971	12.8218	12.8225	34902308.0
2011-07-14 11:00:00	AAPL	Stock	12.8218	12.8439	12.8071	12.8396	26098800.0
2011-07-14 11:30:00	AAPL	Stock	12.8396	12.84	12.8154	12.8268	15978816.0
2011-07-14 12:00:00	AAPL	Stock	12.8271	12.8275	12.7693	12.7939	26808152.0
2011-07-14 12:30:00	AAPL	Stock	12.7939	12.8114	12.7507	12.7679	18825772.0
2011-07-14 13:00:00	AAPL	Stock	12.7679	12.7825	12.7264	12.7629	27040020.0
2011-07-14 13:30:00	AAPL	Stock	12.7657	12.8286	12.7514	12.825	33999560.0
2011-07-14 14:00:00	AAPL	Stock	12.8259	12.8343	12.7936	12.8116	20194524.0
2011-07-14 14:30:00	AAPL	Stock	12.8116	12.8236	12.7789	12.7889	20004180.0
2011-07-14 15:00:00	AAPL	Stock	12.7889	12.8054	12.7446	12.7846	26092248.0
2011-07-14 15:30:00	AAPL	Stock	12.7839	12.8261	12.7629	12.7825	41050716.0
2011-07-14 16:00:00	AAPL	Stock	12.7807	12.8904	12.7686	12.85	11675076.0
2011-07-14 16:30:00	AAPL	Stock	12.8504	12.8564	12.7979	12.8518	979020.0
2011-07-14 17:00:00	AAPL	Stock	12.8536	12.8857	12.7775	12.8839	1681316.0
2011-07-14 17:30:00	AAPL	Stock	12.8843	12.8893	12.8714	12.8893	586796.0
2011-07-14 18:00:00	AAPL	Stock	12.8911	12.9018	12.7775	12.8964	512792.0
2011-07-14 18:30:00	AAPL	Stock	12.8943	12.8943	12.8871	12.8911	207088.0
2011-07-14 19:00:00	AAPL	Stock	12.8893	12.8982	12.8868	12.8929	154952.0
2011-07-14 19:30:00	AAPL	Stock	12.8971	12.8971	12.8718	12.875	345688.0
2011-07-14 06:30:00	MSFT	Stock	26.6	26.6	26.6	26.6	500.0
2011-07-14 07:00:00	MSFT	Stock	26.61	26.61	26.56	26.61	2800.0
2011-07-14 07:30:00	MSFT	Stock	26.61	26.68	26.56	26.58	800.0
2011-07-14 08:00:00	MSFT	Stock	26.68	26.68	26.59	26.61	6878.0
2011-07-14 08:30:00	MSFT	Stock	26.64	26.69	26.63	26.69	13100.0
2011-07-14 09:00:00	MSFT	Stock	26.69	26.69	26.63	26.63	8500.0
2011-07-14 09:30:00	MSFT	Stock	26.63	27.0	26.57	26.99	7069891.0
2011-07-14 10:00:00	MSFT	Stock	26.99	27.01	26.77	26.86	7247853.0
2011-07-14 10:30:00	MSFT	Stock	26.87	26.9	26.61	26.64	4195575.0
2011-07-14 11:00:00	MSFT	Stock	26.64	26.72	26.63	26.68	2231778.0
2011-07-14 11:30:00	MSFT	Stock	26.675	26.68	26.59	26.665	1901267.0
2011-07-14 12:00:00	MSFT	Stock	26.67	26.67	26.54	26.585	1909732.0
2011-07-14 12:30:00	MSFT	Stock	26.585	26.63	26.49	26.5	1710856.0
2011-07-14 13:00:00	MSFT	Stock	26.5	26.52	26.36	26.43	3230473.0
2011-07-14 13:30:00	MSFT	Stock	26.43	26.57	26.41	26.57	3301782.0
2011-07-14 14:00:00	MSFT	Stock	26.57	26.6	26.43	26.47	2499965.0
2011-07-14 14:30:00	MSFT	Stock	26.466	26.5	26.44	26.461	1552768.0
2011-07-14 15:00:00	MSFT	Stock	26.465	26.545	26.38	26.475	2656503.0
2011-07-14 15:30:00	MSFT	Stock	26.475	26.57	26.43	26.47	4914369.0
2011-07-14 16:00:00	MSFT	Stock	26.48	26.71	26.47	26.47	1353359.0

> showing 50 of 73,878 rows — these rows as CSV

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