PREVIEW / stock_30min / 2014-02-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-11.parquet
  size:    1.6 MB
  rows:    83,803
  symbols: 3,548

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
2014-02-11 04:00:00	AAPL	Stock	18.975	19.0	18.975	18.9843	8400.0
2014-02-11 05:00:00	AAPL	Stock	18.9893	18.9893	18.9893	18.9893	2800.0
2014-02-11 05:30:00	AAPL	Stock	18.9914	18.9914	18.9821	18.9821	33600.0
2014-02-11 06:00:00	AAPL	Stock	18.9611	18.9611	18.9493	18.9493	17752.0
2014-02-11 06:30:00	AAPL	Stock	18.9493	18.9546	18.9493	18.9546	27720.0
2014-02-11 07:00:00	AAPL	Stock	18.9607	18.9643	18.9464	18.9643	67620.0
2014-02-11 07:30:00	AAPL	Stock	18.9536	18.9536	18.9329	18.9393	150360.0
2014-02-11 08:00:00	AAPL	Stock	18.9329	18.9607	18.9214	18.9504	620060.0
2014-02-11 08:30:00	AAPL	Stock	18.9464	18.9679	18.9286	18.9679	1601460.0
2014-02-11 09:00:00	AAPL	Stock	18.9607	18.9679	18.9436	18.945	861000.0
2014-02-11 09:30:00	AAPL	Stock	18.9504	19.0393	18.9107	18.9896	40593532.0
2014-02-11 10:00:00	AAPL	Stock	18.9904	19.0854	18.9614	19.0536	27039264.0
2014-02-11 10:30:00	AAPL	Stock	19.0536	19.1025	19.0446	19.0957	18590824.0
2014-02-11 11:00:00	AAPL	Stock	19.0954	19.1518	19.0946	19.1504	19043304.0
2014-02-11 11:30:00	AAPL	Stock	19.1518	19.1682	19.1257	19.1289	14154280.0
2014-02-11 12:00:00	AAPL	Stock	19.1293	19.1536	19.1118	19.1218	11052020.0
2014-02-11 12:30:00	AAPL	Stock	19.1207	19.1661	19.1132	19.1639	8359736.0
2014-02-11 13:00:00	AAPL	Stock	19.1643	19.18	19.1425	19.1665	11563608.0
2014-02-11 13:30:00	AAPL	Stock	19.165	19.1861	19.1482	19.1611	8734264.0
2014-02-11 14:00:00	AAPL	Stock	19.1607	19.1739	19.1511	19.1618	8629936.0
2014-02-11 14:30:00	AAPL	Stock	19.1619	19.1829	19.1539	19.1782	9384228.0
2014-02-11 15:00:00	AAPL	Stock	19.1782	19.2054	19.1743	19.1882	15928276.0
2014-02-11 15:30:00	AAPL	Stock	19.1864	19.2021	19.1193	19.1414	26492648.0
2014-02-11 16:00:00	AAPL	Stock	19.1414	19.1643	19.1018	19.1518	9733304.0
2014-02-11 16:30:00	AAPL	Stock	19.1443	19.1443	19.0951	19.1357	526568.0
2014-02-11 17:00:00	AAPL	Stock	19.1357	19.1514	19.1357	19.1514	75768.0
2014-02-11 17:30:00	AAPL	Stock	19.1432	19.1446	19.1411	19.1429	271068.0
2014-02-11 18:00:00	AAPL	Stock	19.1432	19.1457	19.1418	19.1429	40768.0
2014-02-11 18:30:00	AAPL	Stock	19.1414	19.1554	19.1414	19.1554	134008.0
2014-02-11 19:00:00	AAPL	Stock	19.1536	19.155	19.1486	19.1486	35868.0
2014-02-11 19:30:00	AAPL	Stock	19.1539	19.1539	19.1436	19.15	138964.0
2014-02-11 04:00:00	MSFT	Stock	36.73	36.76	36.73	36.76	2038.0
2014-02-11 08:00:00	MSFT	Stock	36.96	36.96	36.9	36.9	1000.0
2014-02-11 08:30:00	MSFT	Stock	36.95	37.01	36.92	36.92	13289.0
2014-02-11 09:00:00	MSFT	Stock	36.94	36.94	36.86	36.87	6448.0
2014-02-11 09:30:00	MSFT	Stock	36.88	37.09	36.86	37.06	3636587.0
2014-02-11 10:00:00	MSFT	Stock	37.06	37.17	37.04	37.16	2816072.0
2014-02-11 10:30:00	MSFT	Stock	37.157	37.25	37.02	37.077	2686486.0
2014-02-11 11:00:00	MSFT	Stock	37.07	37.21	37.04	37.195	1742329.0
2014-02-11 11:30:00	MSFT	Stock	37.2	37.25	37.08	37.1	1635205.0
2014-02-11 12:00:00	MSFT	Stock	37.1	37.14	37.06	37.075	1143884.0
2014-02-11 12:30:00	MSFT	Stock	37.07	37.17	37.07	37.12	850991.0
2014-02-11 13:00:00	MSFT	Stock	37.125	37.22	37.12	37.2	1155345.0
2014-02-11 13:30:00	MSFT	Stock	37.2	37.25	37.17	37.225	937191.0
2014-02-11 14:00:00	MSFT	Stock	37.23	37.25	37.17	37.225	1186335.0
2014-02-11 14:30:00	MSFT	Stock	37.22	37.25	37.19	37.23	1316806.0
2014-02-11 15:00:00	MSFT	Stock	37.24	37.26	37.21	37.23	1878370.0
2014-02-11 15:30:00	MSFT	Stock	37.225	37.235	37.1	37.2	5425705.0
2014-02-11 16:00:00	MSFT	Stock	37.19	37.207	37.12	37.15	4608896.0
2014-02-11 16:30:00	MSFT	Stock	37.143	37.2	37.143	37.16	69830.0

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

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