PREVIEW / stock_30min / 2012-07-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-16.parquet
  size:    1.4 MB
  rows:    73,068
  symbols: 3,475

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-07-16 04:00:00	AAPL	Stock	21.6071	21.6071	21.5718	21.5718	59248.0
2012-07-16 04:30:00	AAPL	Stock	21.5718	21.5718	21.5718	21.5718	2800.0
2012-07-16 05:00:00	AAPL	Stock	21.6071	21.6071	21.605	21.605	22400.0
2012-07-16 05:30:00	AAPL	Stock	21.5714	21.5714	21.5714	21.5714	8400.0
2012-07-16 07:00:00	AAPL	Stock	21.6036	21.6054	21.5804	21.5893	32060.0
2012-07-16 07:30:00	AAPL	Stock	21.6014	21.6071	21.6014	21.6071	8400.0
2012-07-16 08:00:00	AAPL	Stock	21.5946	21.5946	21.5675	21.5864	461944.0
2012-07-16 08:30:00	AAPL	Stock	21.5793	21.5893	21.5561	21.5729	601216.0
2012-07-16 09:00:00	AAPL	Stock	21.5854	21.6196	21.5757	21.615	701456.0
2012-07-16 09:30:00	AAPL	Stock	21.615	21.7761	21.6079	21.6686	62091372.0
2012-07-16 10:00:00	AAPL	Stock	21.6686	21.7404	21.6686	21.7132	27485052.0
2012-07-16 10:30:00	AAPL	Stock	21.7139	21.7357	21.6936	21.7089	17686340.0
2012-07-16 11:00:00	AAPL	Stock	21.7086	21.8436	21.7011	21.8046	38410848.0
2012-07-16 11:30:00	AAPL	Stock	21.8039	21.8086	21.7539	21.7729	17781148.0
2012-07-16 12:00:00	AAPL	Stock	21.7768	21.8029	21.7239	21.7411	16423512.0
2012-07-16 12:30:00	AAPL	Stock	21.7454	21.7707	21.7186	21.7604	11999596.0
2012-07-16 13:00:00	AAPL	Stock	21.7631	21.8089	21.7546	21.7993	13412840.0
2012-07-16 13:30:00	AAPL	Stock	21.7993	21.8079	21.7689	21.7725	9236080.0
2012-07-16 14:00:00	AAPL	Stock	21.7764	21.7986	21.7589	21.7611	9428244.0
2012-07-16 14:30:00	AAPL	Stock	21.7621	21.7739	21.7293	21.7581	13814052.0
2012-07-16 15:00:00	AAPL	Stock	21.7582	21.7836	21.7243	21.7273	11874072.0
2012-07-16 15:30:00	AAPL	Stock	21.7254	21.7321	21.6304	21.6768	40259296.0
2012-07-16 16:00:00	AAPL	Stock	21.6768	21.7322	21.6475	21.6696	3882004.0
2012-07-16 16:30:00	AAPL	Stock	21.67	21.6768	21.6629	21.6629	309988.0
2012-07-16 17:00:00	AAPL	Stock	21.6746	21.6768	21.6493	21.6607	1637440.0
2012-07-16 17:30:00	AAPL	Stock	21.6493	21.6643	21.6479	21.6643	77000.0
2012-07-16 18:00:00	AAPL	Stock	21.6604	21.6607	21.6536	21.6607	66584.0
2012-07-16 18:30:00	AAPL	Stock	21.6557	21.6639	21.6557	21.6639	14476.0
2012-07-16 19:00:00	AAPL	Stock	21.6668	21.6668	21.6582	21.6582	23940.0
2012-07-16 19:30:00	AAPL	Stock	21.6611	21.6679	21.6611	21.6643	68264.0
2012-07-16 07:30:00	MSFT	Stock	29.41	29.41	29.41	29.41	400.0
2012-07-16 08:00:00	MSFT	Stock	29.39	29.39	29.35	29.35	2850.0
2012-07-16 08:30:00	MSFT	Stock	29.35	29.38	29.3	29.35	8074.0
2012-07-16 09:00:00	MSFT	Stock	29.35	29.62	29.35	29.52	45785.0
2012-07-16 09:30:00	MSFT	Stock	29.5	29.51	29.04	29.13	2839016.0
2012-07-16 10:00:00	MSFT	Stock	29.13	29.32	29.09	29.315	2197166.0
2012-07-16 10:30:00	MSFT	Stock	29.32	29.385	29.29	29.329	2184167.0
2012-07-16 11:00:00	MSFT	Stock	29.325	29.49	29.29	29.46	2035373.0
2012-07-16 11:30:00	MSFT	Stock	29.458	29.49	29.4	29.489	1341795.0
2012-07-16 12:00:00	MSFT	Stock	29.49	29.53	29.325	29.36	1842188.0
2012-07-16 12:30:00	MSFT	Stock	29.37	29.39	29.25	29.32	1962043.0
2012-07-16 13:00:00	MSFT	Stock	29.325	29.38	29.3	29.375	1060702.0
2012-07-16 13:30:00	MSFT	Stock	29.376	29.51	29.37	29.45	1684272.0
2012-07-16 14:00:00	MSFT	Stock	29.45	29.51	29.45	29.45	1136092.0
2012-07-16 14:30:00	MSFT	Stock	29.46	29.47	29.34	29.37	1533981.0
2012-07-16 15:00:00	MSFT	Stock	29.367	29.46	29.325	29.436	1827451.0
2012-07-16 15:30:00	MSFT	Stock	29.43	29.44	29.34	29.44	3910173.0
2012-07-16 16:00:00	MSFT	Stock	29.44	29.5	29.354	29.46	1421067.0
2012-07-16 16:30:00	MSFT	Stock	29.44	29.46	29.423	29.423	12805.0
2012-07-16 17:00:00	MSFT	Stock	29.44	29.48	29.44	29.48	420561.0

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

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