PREVIEW / stock_30min / 2013-12-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-30.parquet
  size:    1.6 MB
  rows:    82,639
  symbols: 3,546

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-12-30 04:00:00	AAPL	Stock	19.95	19.9671	19.95	19.9671	39760.0
2013-12-30 04:30:00	AAPL	Stock	19.97	19.97	19.9546	19.9643	16800.0
2013-12-30 05:00:00	AAPL	Stock	19.9643	19.9714	19.9643	19.9714	5600.0
2013-12-30 05:30:00	AAPL	Stock	19.9643	19.9686	19.9643	19.9686	40376.0
2013-12-30 06:00:00	AAPL	Stock	19.9464	19.9464	19.9286	19.9286	46172.0
2013-12-30 06:30:00	AAPL	Stock	19.9032	19.9032	19.8771	19.8936	17220.0
2013-12-30 07:00:00	AAPL	Stock	19.8925	19.9182	19.8668	19.8929	316680.0
2013-12-30 07:30:00	AAPL	Stock	19.9029	19.9068	19.8857	19.8925	107352.0
2013-12-30 08:00:00	AAPL	Stock	19.8929	19.9286	19.8679	19.9011	529872.0
2013-12-30 08:30:00	AAPL	Stock	19.9018	19.9464	19.8929	19.9375	700812.0
2013-12-30 09:00:00	AAPL	Stock	19.9371	19.9371	19.8943	19.9207	405860.0
2013-12-30 09:30:00	AAPL	Stock	19.9093	19.9304	19.7971	19.8604	41984348.0
2013-12-30 10:00:00	AAPL	Stock	19.8604	19.866	19.7286	19.75	27686288.0
2013-12-30 10:30:00	AAPL	Stock	19.7532	19.785	19.7257	19.7486	20715968.0
2013-12-30 11:00:00	AAPL	Stock	19.7514	19.8329	19.7486	19.8164	16786672.0
2013-12-30 11:30:00	AAPL	Stock	19.8193	19.8265	19.775	19.8214	13545112.0
2013-12-30 12:00:00	AAPL	Stock	19.8245	19.8304	19.7471	19.7501	14097020.0
2013-12-30 12:30:00	AAPL	Stock	19.7514	19.7686	19.7361	19.7418	7117320.0
2013-12-30 13:00:00	AAPL	Stock	19.7439	19.7796	19.7325	19.7671	6587784.0
2013-12-30 13:30:00	AAPL	Stock	19.7675	19.7679	19.7327	19.7393	4692688.0
2013-12-30 14:00:00	AAPL	Stock	19.7393	19.7932	19.7329	19.7889	7886984.0
2013-12-30 14:30:00	AAPL	Stock	19.7889	19.86	19.7886	19.8303	12289144.0
2013-12-30 15:00:00	AAPL	Stock	19.8296	19.8786	19.8279	19.8448	9718408.0
2013-12-30 15:30:00	AAPL	Stock	19.8432	19.8514	19.7847	19.8036	20620292.0
2013-12-30 16:00:00	AAPL	Stock	19.8043	19.8121	19.7824	19.7961	7769832.0
2013-12-30 16:30:00	AAPL	Stock	19.7875	19.9738	19.7714	19.7975	381192.0
2013-12-30 17:00:00	AAPL	Stock	19.7896	19.7896	19.7786	19.7786	119868.0
2013-12-30 17:30:00	AAPL	Stock	19.7754	19.8043	19.775	19.7821	115304.0
2013-12-30 18:00:00	AAPL	Stock	19.7757	19.7857	19.7757	19.7857	82936.0
2013-12-30 18:30:00	AAPL	Stock	19.7754	19.7768	19.775	19.775	33852.0
2013-12-30 19:00:00	AAPL	Stock	19.7857	19.7857	19.775	19.775	19460.0
2013-12-30 19:30:00	AAPL	Stock	19.7743	19.7786	19.7411	19.7536	191072.0
2013-12-30 06:00:00	MSFT	Stock	37.4	37.4	37.4	37.4	300.0
2013-12-30 07:30:00	MSFT	Stock	37.1	37.32	37.1	37.15	5733.0
2013-12-30 08:00:00	MSFT	Stock	37.22	37.23	37.2	37.2	1078.0
2013-12-30 08:30:00	MSFT	Stock	37.151	37.16	37.151	37.16	400.0
2013-12-30 09:00:00	MSFT	Stock	37.2	37.22	37.2	37.22	570.0
2013-12-30 09:30:00	MSFT	Stock	37.26	37.27	36.935	36.99	2192794.0
2013-12-30 10:00:00	MSFT	Stock	36.98	37.04	36.901	37.04	1386409.0
2013-12-30 10:30:00	MSFT	Stock	37.037	37.18	37.02	37.145	1611463.0
2013-12-30 11:00:00	MSFT	Stock	37.145	37.15	37.09	37.1	1150906.0
2013-12-30 11:30:00	MSFT	Stock	37.1	37.15	37.09	37.135	760441.0
2013-12-30 12:00:00	MSFT	Stock	37.135	37.15	37.12	37.145	570594.0
2013-12-30 12:30:00	MSFT	Stock	37.141	37.26	37.13	37.253	1299740.0
2013-12-30 13:00:00	MSFT	Stock	37.25	37.34	37.25	37.26	975816.0
2013-12-30 13:30:00	MSFT	Stock	37.26	37.29	37.26	37.27	486838.0
2013-12-30 14:00:00	MSFT	Stock	37.28	37.38	37.26	37.375	823217.0
2013-12-30 14:30:00	MSFT	Stock	37.372	37.38	37.305	37.31	648958.0
2013-12-30 15:00:00	MSFT	Stock	37.319	37.32	37.19	37.19	800770.0
2013-12-30 15:30:00	MSFT	Stock	37.19	37.3	37.18	37.28	1869629.0

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

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