PREVIEW / stock_30min / 2013-11-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-19.parquet
  size:    1.6 MB
  rows:    81,072
  symbols: 3,546

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-19 05:30:00	AAPL	Stock	18.5114	18.5114	18.5107	18.5107	5600.0
2013-11-19 07:00:00	AAPL	Stock	18.5107	18.5268	18.5107	18.5268	47600.0
2013-11-19 07:30:00	AAPL	Stock	18.5107	18.5214	18.5	18.5089	85260.0
2013-11-19 08:00:00	AAPL	Stock	18.5196	18.5664	18.5082	18.5643	319256.0
2013-11-19 08:30:00	AAPL	Stock	18.5625	18.6	18.5557	18.5571	436940.0
2013-11-19 09:00:00	AAPL	Stock	18.5671	18.5832	18.5379	18.545	462728.0
2013-11-19 09:30:00	AAPL	Stock	18.5568	18.6604	18.5154	18.6489	33631528.0
2013-11-19 10:00:00	AAPL	Stock	18.6489	18.6921	18.6061	18.6071	20347964.0
2013-11-19 10:30:00	AAPL	Stock	18.6075	18.6425	18.5964	18.6	15681232.0
2013-11-19 11:00:00	AAPL	Stock	18.6	18.6121	18.5371	18.5714	14160188.0
2013-11-19 11:30:00	AAPL	Stock	18.5689	18.6021	18.5468	18.5986	10614716.0
2013-11-19 12:00:00	AAPL	Stock	18.6018	18.6336	18.585	18.6186	14379568.0
2013-11-19 12:30:00	AAPL	Stock	18.6186	18.6271	18.5614	18.5614	13567148.0
2013-11-19 13:00:00	AAPL	Stock	18.5625	18.5905	18.5268	18.5329	10509772.0
2013-11-19 13:30:00	AAPL	Stock	18.5307	18.5582	18.4989	18.5371	12867484.0
2013-11-19 14:00:00	AAPL	Stock	18.5375	18.5621	18.5175	18.5196	10934644.0
2013-11-19 14:30:00	AAPL	Stock	18.5218	18.5714	18.5196	18.5429	8641724.0
2013-11-19 15:00:00	AAPL	Stock	18.5404	18.5871	18.54	18.5779	7948836.0
2013-11-19 15:30:00	AAPL	Stock	18.5786	18.5814	18.5446	18.5536	14689976.0
2013-11-19 16:00:00	AAPL	Stock	18.5525	18.5853	18.5361	18.5454	11173204.0
2013-11-19 16:30:00	AAPL	Stock	18.5454	18.5853	18.5443	18.5525	54152.0
2013-11-19 17:00:00	AAPL	Stock	18.5496	18.5514	18.5354	18.5393	226632.0
2013-11-19 17:30:00	AAPL	Stock	18.5364	18.5425	18.5357	18.5379	102004.0
2013-11-19 18:00:00	AAPL	Stock	18.5361	18.5514	18.5357	18.5514	153636.0
2013-11-19 18:30:00	AAPL	Stock	18.5514	18.5661	18.5514	18.5571	180824.0
2013-11-19 19:00:00	AAPL	Stock	18.555	18.5571	18.5536	18.5536	44688.0
2013-11-19 19:30:00	AAPL	Stock	18.5511	18.5636	18.5511	18.5636	25200.0
2013-11-19 04:00:00	MSFT	Stock	36.82	36.82	36.82	36.82	562.0
2013-11-19 06:00:00	MSFT	Stock	36.8	36.86	36.8	36.86	2200.0
2013-11-19 06:30:00	MSFT	Stock	36.86	36.86	36.86	36.86	848.0
2013-11-19 07:00:00	MSFT	Stock	36.85	36.85	36.85	36.85	300.0
2013-11-19 07:30:00	MSFT	Stock	36.85	36.85	36.85	36.85	3650.0
2013-11-19 08:00:00	MSFT	Stock	36.88	36.92	36.8	36.9	16468.0
2013-11-19 08:30:00	MSFT	Stock	36.87	36.98	36.84	36.98	22191.0
2013-11-19 09:00:00	MSFT	Stock	36.95	37.0	36.7	36.82	165501.0
2013-11-19 09:30:00	MSFT	Stock	36.84	37.23	36.72	37.13	7070831.0
2013-11-19 10:00:00	MSFT	Stock	37.135	37.18	36.9	36.927	3436060.0
2013-11-19 10:30:00	MSFT	Stock	36.92	36.99	36.835	36.93	2740866.0
2013-11-19 11:00:00	MSFT	Stock	36.93	36.945	36.85	36.92	2362014.0
2013-11-19 11:30:00	MSFT	Stock	36.92	37.02	36.84	36.91	2532343.0
2013-11-19 12:00:00	MSFT	Stock	36.91	37.1	36.88	37.04	2983522.0
2013-11-19 12:30:00	MSFT	Stock	37.03	37.06	36.87	36.895	1751753.0
2013-11-19 13:00:00	MSFT	Stock	36.89	36.94	36.82	36.85	2793694.0
2013-11-19 13:30:00	MSFT	Stock	36.85	36.87	36.76	36.8	2464492.0
2013-11-19 14:00:00	MSFT	Stock	36.8	36.85	36.79	36.81	1694872.0
2013-11-19 14:30:00	MSFT	Stock	36.81	36.86	36.8	36.845	2412111.0
2013-11-19 15:00:00	MSFT	Stock	36.85	36.91	36.795	36.813	2664641.0
2013-11-19 15:30:00	MSFT	Stock	36.82	36.82	36.67	36.74	6485279.0
2013-11-19 16:00:00	MSFT	Stock	36.74	36.971	36.62	36.63	1370454.0
2013-11-19 16:30:00	MSFT	Stock	36.63	36.922	36.62	36.7	14596.0

> showing 50 of 81,072 rows — these rows as CSV

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