PREVIEW / stock_30min / 2013-11-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-18.parquet
  size:    1.6 MB
  rows:    80,735
  symbols: 3,557

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-11-18 04:00:00	AAPL	Stock	18.7496	18.7632	18.7496	18.7632	13300.0
2013-11-18 04:30:00	AAPL	Stock	18.7789	18.7804	18.7789	18.7804	8400.0
2013-11-18 05:00:00	AAPL	Stock	18.7986	18.7986	18.7929	18.7929	8400.0
2013-11-18 05:30:00	AAPL	Stock	18.8011	18.8011	18.8011	18.8011	2800.0
2013-11-18 06:00:00	AAPL	Stock	18.7875	18.8175	18.75	18.7518	229068.0
2013-11-18 06:30:00	AAPL	Stock	18.7507	18.7507	18.7143	18.7143	21084.0
2013-11-18 07:00:00	AAPL	Stock	18.7679	18.8196	18.7679	18.8196	269528.0
2013-11-18 07:30:00	AAPL	Stock	18.8257	18.8368	18.8114	18.8143	95620.0
2013-11-18 08:00:00	AAPL	Stock	18.8036	18.8357	18.7143	18.7589	1140776.0
2013-11-18 08:30:00	AAPL	Stock	18.7639	18.8011	18.7589	18.795	561344.0
2013-11-18 09:00:00	AAPL	Stock	18.7893	18.7943	18.7482	18.7496	721252.0
2013-11-18 09:30:00	AAPL	Stock	18.7496	18.8282	18.6539	18.6679	37380868.0
2013-11-18 10:00:00	AAPL	Stock	18.668	18.6993	18.645	18.6627	19816132.0
2013-11-18 10:30:00	AAPL	Stock	18.6627	18.6996	18.645	18.6785	17236128.0
2013-11-18 11:00:00	AAPL	Stock	18.6786	18.7207	18.6716	18.6843	21452172.0
2013-11-18 11:30:00	AAPL	Stock	18.6846	18.6964	18.6564	18.6786	13957580.0
2013-11-18 12:00:00	AAPL	Stock	18.6786	18.7346	18.6686	18.727	8591688.0
2013-11-18 12:30:00	AAPL	Stock	18.7268	18.7293	18.6875	18.6946	8104040.0
2013-11-18 13:00:00	AAPL	Stock	18.6959	18.6975	18.6714	18.6851	4100684.0
2013-11-18 13:30:00	AAPL	Stock	18.6904	18.7179	18.6739	18.6861	5048568.0
2013-11-18 14:00:00	AAPL	Stock	18.6861	18.7464	18.6789	18.745	7535052.0
2013-11-18 14:30:00	AAPL	Stock	18.7461	18.75	18.6818	18.6818	11446652.0
2013-11-18 15:00:00	AAPL	Stock	18.685	18.6932	18.5189	18.5507	36691592.0
2013-11-18 15:30:00	AAPL	Stock	18.5486	18.5596	18.5071	18.5232	28376096.0
2013-11-18 16:00:00	AAPL	Stock	18.5259	18.6836	18.5043	18.5232	18303936.0
2013-11-18 16:30:00	AAPL	Stock	18.5254	18.5361	18.52	18.5268	158424.0
2013-11-18 17:00:00	AAPL	Stock	18.5236	18.5246	18.5125	18.5243	98532.0
2013-11-18 17:30:00	AAPL	Stock	18.5182	18.5264	18.5179	18.5204	449204.0
2013-11-18 18:00:00	AAPL	Stock	18.5221	18.5221	18.5136	18.5221	70644.0
2013-11-18 18:30:00	AAPL	Stock	18.5236	18.5246	18.5107	18.5143	120848.0
2013-11-18 19:00:00	AAPL	Stock	18.5118	18.5264	18.51	18.5264	163184.0
2013-11-18 19:30:00	AAPL	Stock	18.525	18.5282	18.5114	18.5268	149604.0
2013-11-18 05:30:00	MSFT	Stock	38.05	38.05	38.05	38.05	150.0
2013-11-18 06:00:00	MSFT	Stock	37.85	37.85	37.4	37.44	16850.0
2013-11-18 06:30:00	MSFT	Stock	37.44	37.44	37.37	37.37	11250.0
2013-11-18 07:00:00	MSFT	Stock	37.4	37.42	37.3	37.42	5375.0
2013-11-18 07:30:00	MSFT	Stock	37.43	37.44	37.25	37.28	23960.0
2013-11-18 08:00:00	MSFT	Stock	37.3	37.44	37.17	37.29	77423.0
2013-11-18 08:30:00	MSFT	Stock	37.3	37.32	37.22	37.28	205818.0
2013-11-18 09:00:00	MSFT	Stock	37.28	37.5	37.28	37.35	252066.0
2013-11-18 09:30:00	MSFT	Stock	37.37	37.58	37.22	37.42	9238605.0
2013-11-18 10:00:00	MSFT	Stock	37.42	37.46	37.26	37.305	4639655.0
2013-11-18 10:30:00	MSFT	Stock	37.305	37.41	37.27	37.363	3118065.0
2013-11-18 11:00:00	MSFT	Stock	37.37	37.43	37.323	37.37	2329713.0
2013-11-18 11:30:00	MSFT	Stock	37.36	37.4	37.28	37.308	2241549.0
2013-11-18 12:00:00	MSFT	Stock	37.31	37.44	37.28	37.405	2379112.0
2013-11-18 12:30:00	MSFT	Stock	37.4	37.41	37.35	37.37	1369355.0
2013-11-18 13:00:00	MSFT	Stock	37.38	37.43	37.34	37.4	1390713.0
2013-11-18 13:30:00	MSFT	Stock	37.393	37.42	37.37	37.391	1183723.0
2013-11-18 14:00:00	MSFT	Stock	37.4	37.42	37.37	37.405	2336454.0

> showing 50 of 80,735 rows — these rows as CSV

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