PREVIEW / stock_30min / 2013-12-31

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-31.parquet
  size:    1.6 MB
  rows:    83,660
  symbols: 3,551

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-31 07:00:00	AAPL	Stock	19.805	19.81	19.8036	19.8036	14000.0
2013-12-31 07:30:00	AAPL	Stock	19.7868	19.7868	19.7482	19.75	150080.0
2013-12-31 08:00:00	AAPL	Stock	19.75	19.7857	19.7482	19.7854	159012.0
2013-12-31 08:30:00	AAPL	Stock	19.7854	19.8196	19.7789	19.7839	104608.0
2013-12-31 09:00:00	AAPL	Stock	19.7957	19.8114	19.7857	19.7957	365932.0
2013-12-31 09:30:00	AAPL	Stock	19.7904	19.9725	19.7857	19.9629	39560052.0
2013-12-31 10:00:00	AAPL	Stock	19.9661	20.0282	19.9504	20.0246	21739732.0
2013-12-31 10:30:00	AAPL	Stock	20.027	20.0386	19.9804	20.007	18377968.0
2013-12-31 11:00:00	AAPL	Stock	20.0071	20.0346	20.0036	20.0289	9457812.0
2013-12-31 11:30:00	AAPL	Stock	20.0289	20.0457	20.0143	20.0386	10552192.0
2013-12-31 12:00:00	AAPL	Stock	20.0379	20.0386	19.9907	20.0211	8034432.0
2013-12-31 12:30:00	AAPL	Stock	20.02	20.0304	20.0036	20.0295	5788244.0
2013-12-31 13:00:00	AAPL	Stock	20.03	20.0318	19.9975	20.025	5632676.0
2013-12-31 13:30:00	AAPL	Stock	20.0253	20.0279	20.0036	20.0107	4653292.0
2013-12-31 14:00:00	AAPL	Stock	20.0107	20.0196	19.9914	19.9975	5884900.0
2013-12-31 14:30:00	AAPL	Stock	19.9979	19.9982	19.9522	19.9874	11026036.0
2013-12-31 15:00:00	AAPL	Stock	19.9879	19.9971	19.9718	19.9732	7148148.0
2013-12-31 15:30:00	AAPL	Stock	19.9739	20.0439	19.9718	20.0414	26357492.0
2013-12-31 16:00:00	AAPL	Stock	20.0396	20.0464	19.8376	20.0396	14011424.0
2013-12-31 16:30:00	AAPL	Stock	20.0461	20.0479	20.04	20.0479	124096.0
2013-12-31 17:00:00	AAPL	Stock	20.0479	20.0479	20.0396	20.0396	119224.0
2013-12-31 17:30:00	AAPL	Stock	20.0464	20.0479	20.0407	20.0479	47040.0
2013-12-31 18:00:00	AAPL	Stock	20.0479	20.0514	20.0432	20.0514	50736.0
2013-12-31 18:30:00	AAPL	Stock	20.045	20.045	20.0429	20.0429	18256.0
2013-12-31 19:00:00	AAPL	Stock	20.0432	20.0432	20.0429	20.0429	5600.0
2013-12-31 19:30:00	AAPL	Stock	20.0443	20.0464	20.0421	20.0421	36764.0
2013-12-31 08:00:00	MSFT	Stock	37.29	37.29	37.25	37.25	484.0
2013-12-31 08:30:00	MSFT	Stock	37.37	37.37	37.37	37.37	123.0
2013-12-31 09:00:00	MSFT	Stock	37.4	37.4	37.34	37.38	7463.0
2013-12-31 09:30:00	MSFT	Stock	37.37	37.44	37.217	37.335	1758984.0
2013-12-31 10:00:00	MSFT	Stock	37.33	37.47	37.33	37.362	1196761.0
2013-12-31 10:30:00	MSFT	Stock	37.364	37.48	37.36	37.45	961512.0
2013-12-31 11:00:00	MSFT	Stock	37.45	37.58	37.42	37.45	1528616.0
2013-12-31 11:30:00	MSFT	Stock	37.46	37.47	37.32	37.36	856381.0
2013-12-31 12:00:00	MSFT	Stock	37.36	37.39	37.27	37.34	767690.0
2013-12-31 12:30:00	MSFT	Stock	37.34	37.42	37.33	37.345	650207.0
2013-12-31 13:00:00	MSFT	Stock	37.35	37.36	37.32	37.34	393973.0
2013-12-31 13:30:00	MSFT	Stock	37.34	37.41	37.34	37.384	627156.0
2013-12-31 14:00:00	MSFT	Stock	37.39	37.42	37.37	37.39	495593.0
2013-12-31 14:30:00	MSFT	Stock	37.39	37.4	37.32	37.33	659408.0
2013-12-31 15:00:00	MSFT	Stock	37.34	37.38	37.3	37.38	793296.0
2013-12-31 15:30:00	MSFT	Stock	37.38	37.45	37.36	37.43	2614809.0
2013-12-31 16:00:00	MSFT	Stock	37.43	37.53	37.38	37.43	3449710.0
2013-12-31 16:30:00	MSFT	Stock	37.43	37.45	37.43	37.45	4849.0
2013-12-31 17:00:00	MSFT	Stock	37.376	37.376	37.376	37.376	251.0
2013-12-31 17:30:00	MSFT	Stock	37.45	37.45	37.41	37.41	200.0
2013-12-31 18:30:00	MSFT	Stock	37.41	37.41	37.41	37.41	580.0
2013-12-31 19:00:00	MSFT	Stock	37.43	37.43	37.43	37.43	300.0
2013-12-31 19:30:00	MSFT	Stock	37.41	37.41	37.41	37.41	1070.0
2013-12-31 08:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	56000.0

> showing 50 of 83,660 rows — these rows as CSV

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