PREVIEW / stock_30min / 2014-01-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-14.parquet
  size:    1.6 MB
  rows:    80,940
  symbols: 3,521

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-01-14 06:00:00	AAPL	Stock	19.1482	19.1482	19.1482	19.1482	5600.0
2014-01-14 06:30:00	AAPL	Stock	19.16	19.1707	19.1575	19.1704	28000.0
2014-01-14 07:00:00	AAPL	Stock	19.1704	19.25	19.1704	19.2471	157164.0
2014-01-14 07:30:00	AAPL	Stock	19.2346	19.2679	19.2346	19.26	293272.0
2014-01-14 08:00:00	AAPL	Stock	19.2654	19.2654	19.1875	19.2032	993440.0
2014-01-14 08:30:00	AAPL	Stock	19.2043	19.2321	19.1982	19.2311	567308.0
2014-01-14 09:00:00	AAPL	Stock	19.225	19.2429	19.2107	19.2179	802676.0
2014-01-14 09:30:00	AAPL	Stock	19.2154	19.3214	19.2021	19.2579	49804244.0
2014-01-14 10:00:00	AAPL	Stock	19.2587	19.3786	19.2579	19.3611	33210184.0
2014-01-14 10:30:00	AAPL	Stock	19.3607	19.4207	19.3271	19.4178	19796280.0
2014-01-14 11:00:00	AAPL	Stock	19.4143	19.4679	19.4075	19.4357	22753668.0
2014-01-14 11:30:00	AAPL	Stock	19.4407	19.4679	19.4061	19.4668	14641676.0
2014-01-14 12:00:00	AAPL	Stock	19.4679	19.5179	19.4614	19.5179	14663264.0
2014-01-14 12:30:00	AAPL	Stock	19.5171	19.5261	19.4246	19.4354	13705804.0
2014-01-14 13:00:00	AAPL	Stock	19.4354	19.4604	19.4216	19.4473	11744964.0
2014-01-14 13:30:00	AAPL	Stock	19.4475	19.4625	19.4389	19.4518	6863080.0
2014-01-14 14:00:00	AAPL	Stock	19.4525	19.4711	19.3946	19.4707	11867996.0
2014-01-14 14:30:00	AAPL	Stock	19.4664	19.4762	19.4421	19.4443	7930748.0
2014-01-14 15:00:00	AAPL	Stock	19.4475	19.4614	19.425	19.4421	10292128.0
2014-01-14 15:30:00	AAPL	Stock	19.4421	19.5193	19.4393	19.5139	28219856.0
2014-01-14 16:00:00	AAPL	Stock	19.5134	19.5261	19.2475	19.5179	17623732.0
2014-01-14 16:30:00	AAPL	Stock	19.5186	19.5229	19.4026	19.5143	98000.0
2014-01-14 17:00:00	AAPL	Stock	19.5193	19.535	19.5143	19.535	309512.0
2014-01-14 17:30:00	AAPL	Stock	19.5332	19.5336	19.5139	19.5321	310688.0
2014-01-14 18:00:00	AAPL	Stock	19.5286	19.5482	19.5286	19.5482	261884.0
2014-01-14 18:30:00	AAPL	Stock	19.5446	19.5461	19.5339	19.5357	109228.0
2014-01-14 19:00:00	AAPL	Stock	19.5339	19.5436	19.5339	19.5432	60788.0
2014-01-14 19:30:00	AAPL	Stock	19.5429	19.5454	19.5354	19.5357	169344.0
2014-01-14 04:00:00	MSFT	Stock	34.89	34.93	34.89	34.93	1000.0
2014-01-14 04:30:00	MSFT	Stock	34.9	35.0	34.9	35.0	7990.0
2014-01-14 05:00:00	MSFT	Stock	34.92	35.02	34.89	34.95	4295.0
2014-01-14 05:30:00	MSFT	Stock	34.89	34.94	34.64	34.73	2280.0
2014-01-14 06:00:00	MSFT	Stock	34.73	34.74	34.7	34.7	16047.0
2014-01-14 06:30:00	MSFT	Stock	34.66	34.7	34.66	34.7	7300.0
2014-01-14 07:00:00	MSFT	Stock	34.73	34.74	34.69	34.7	28031.0
2014-01-14 07:30:00	MSFT	Stock	34.7	34.72	34.7	34.72	18800.0
2014-01-14 08:00:00	MSFT	Stock	34.73	34.74	34.7	34.711	36945.0
2014-01-14 08:30:00	MSFT	Stock	34.73	34.73	34.71	34.72	24907.0
2014-01-14 09:00:00	MSFT	Stock	34.72	34.74	34.7	34.71	55197.0
2014-01-14 09:30:00	MSFT	Stock	34.73	35.085	34.63	35.04	5713917.0
2014-01-14 10:00:00	MSFT	Stock	35.03	35.31	35.025	35.249	3420766.0
2014-01-14 10:30:00	MSFT	Stock	35.24	35.48	35.22	35.47	2568292.0
2014-01-14 11:00:00	MSFT	Stock	35.47	35.666	35.44	35.64	3458936.0
2014-01-14 11:30:00	MSFT	Stock	35.645	35.74	35.61	35.69	2355764.0
2014-01-14 12:00:00	MSFT	Stock	35.685	35.78	35.64	35.725	1696193.0
2014-01-14 12:30:00	MSFT	Stock	35.73	35.88	35.72	35.81	2125613.0
2014-01-14 13:00:00	MSFT	Stock	35.82	35.85	35.73	35.765	1535141.0
2014-01-14 13:30:00	MSFT	Stock	35.765	35.814	35.75	35.81	1051896.0
2014-01-14 14:00:00	MSFT	Stock	35.81	35.82	35.73	35.76	2549962.0
2014-01-14 14:30:00	MSFT	Stock	35.765	35.88	35.76	35.84	1343820.0

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

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