PREVIEW / stock_30min / 2013-09-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-03.parquet
  size:    1.5 MB
  rows:    80,556
  symbols: 3,532

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-09-03 04:00:00	AAPL	Stock	17.6036	17.6071	17.5943	17.5943	25760.0
2013-09-03 04:30:00	AAPL	Stock	17.5357	17.5364	17.5357	17.5364	25200.0
2013-09-03 05:00:00	AAPL	Stock	17.5118	17.5118	17.5118	17.5118	5292.0
2013-09-03 06:00:00	AAPL	Stock	17.5207	17.5207	17.4286	17.4714	37884.0
2013-09-03 06:30:00	AAPL	Stock	17.4964	17.5032	17.4786	17.4893	98840.0
2013-09-03 07:00:00	AAPL	Stock	17.4879	17.5625	17.4879	17.5479	608356.0
2013-09-03 07:30:00	AAPL	Stock	17.5396	17.5589	17.5179	17.5286	353584.0
2013-09-03 08:00:00	AAPL	Stock	17.5311	17.5761	17.5	17.5464	1460144.0
2013-09-03 08:30:00	AAPL	Stock	17.5464	17.5907	17.5464	17.5821	1654576.0
2013-09-03 09:00:00	AAPL	Stock	17.5779	17.6429	17.5714	17.6157	1334620.0
2013-09-03 09:30:00	AAPL	Stock	17.6157	17.8786	17.5839	17.7211	66571260.0
2013-09-03 10:00:00	AAPL	Stock	17.7191	17.7457	17.6189	17.6746	31987732.0
2013-09-03 10:30:00	AAPL	Stock	17.6689	17.7139	17.6643	17.6864	19888540.0
2013-09-03 11:00:00	AAPL	Stock	17.6893	17.7054	17.6175	17.6196	20522264.0
2013-09-03 11:30:00	AAPL	Stock	17.62	17.6389	17.5625	17.6296	20765920.0
2013-09-03 12:00:00	AAPL	Stock	17.6254	17.6957	17.6	17.6375	26508916.0
2013-09-03 12:30:00	AAPL	Stock	17.6332	17.6607	17.5261	17.5379	18636156.0
2013-09-03 13:00:00	AAPL	Stock	17.5417	17.5775	17.515	17.5568	14573664.0
2013-09-03 13:30:00	AAPL	Stock	17.5571	17.56	17.4289	17.4393	24517668.0
2013-09-03 14:00:00	AAPL	Stock	17.4389	17.4989	17.4054	17.4396	18609332.0
2013-09-03 14:30:00	AAPL	Stock	17.4389	17.505	17.4125	17.505	16339456.0
2013-09-03 15:00:00	AAPL	Stock	17.505	17.5321	17.4782	17.5007	16326212.0
2013-09-03 15:30:00	AAPL	Stock	17.4996	17.5143	17.4214	17.4489	22435728.0
2013-09-03 16:00:00	AAPL	Stock	17.4489	17.5947	17.4432	17.4464	6386856.0
2013-09-03 16:30:00	AAPL	Stock	17.4457	17.5005	17.4329	17.4418	204260.0
2013-09-03 17:00:00	AAPL	Stock	17.4493	17.4493	17.4107	17.4168	375172.0
2013-09-03 17:30:00	AAPL	Stock	17.4164	17.4221	17.4111	17.4196	90748.0
2013-09-03 18:00:00	AAPL	Stock	17.4196	17.4196	17.415	17.415	16632.0
2013-09-03 18:30:00	AAPL	Stock	17.4186	17.4232	17.4168	17.4221	31864.0
2013-09-03 19:00:00	AAPL	Stock	17.4232	17.4286	17.4232	17.4286	31220.0
2013-09-03 19:30:00	AAPL	Stock	17.4261	17.4332	17.4261	17.4296	20356.0
2013-09-03 04:00:00	MSFT	Stock	33.4	34.06	33.4	33.48	45540.0
2013-09-03 04:30:00	MSFT	Stock	33.24	33.28	32.89	32.9	24950.0
2013-09-03 05:00:00	MSFT	Stock	33.02	33.02	32.8	32.81	25505.0
2013-09-03 05:30:00	MSFT	Stock	32.83	32.83	32.65	32.74	13114.0
2013-09-03 06:00:00	MSFT	Stock	32.74	32.76	32.73	32.75	12770.0
2013-09-03 06:30:00	MSFT	Stock	32.75	32.8	32.3	32.45	87488.0
2013-09-03 07:00:00	MSFT	Stock	32.49	32.5	32.18	32.35	534113.0
2013-09-03 07:30:00	MSFT	Stock	32.35	32.35	31.68	31.83	734908.0
2013-09-03 08:00:00	MSFT	Stock	31.83	32.4	31.67	31.68	2200936.0
2013-09-03 08:30:00	MSFT	Stock	31.67	31.85	31.62	31.75	2315865.0
2013-09-03 09:00:00	MSFT	Stock	31.75	31.91	31.6	31.73	2484116.0
2013-09-03 09:30:00	MSFT	Stock	31.75	32.07	31.65	31.9	31693984.0
2013-09-03 10:00:00	MSFT	Stock	31.9	31.94	31.47	31.59	18586658.0
2013-09-03 10:30:00	MSFT	Stock	31.59	31.64	31.33	31.41	15175673.0
2013-09-03 11:00:00	MSFT	Stock	31.41	31.48	31.31	31.325	10151741.0
2013-09-03 11:30:00	MSFT	Stock	31.325	31.41	31.29	31.33	8946076.0
2013-09-03 12:00:00	MSFT	Stock	31.33	31.4	31.31	31.378	5119259.0
2013-09-03 12:30:00	MSFT	Stock	31.374	31.5	31.36	31.42	6194474.0
2013-09-03 13:00:00	MSFT	Stock	31.415	31.47	31.34	31.43	5173088.0

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

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