PREVIEW / stock_30min / 2014-10-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-14.parquet
  size:    1.6 MB
  rows:    85,814
  symbols: 3,564

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-10-14 04:00:00	AAPL	Stock	25.055	25.0575	25.05	25.0575	6600.0
2014-10-14 04:30:00	AAPL	Stock	25.0475	25.0475	24.995	24.995	6188.0
2014-10-14 05:00:00	AAPL	Stock	24.965	24.975	24.925	24.925	7720.0
2014-10-14 05:30:00	AAPL	Stock	24.925	24.975	24.9225	24.975	27076.0
2014-10-14 06:00:00	AAPL	Stock	24.955	25.0725	24.955	24.9925	8400.0
2014-10-14 06:30:00	AAPL	Stock	25.035	25.035	24.9975	24.9975	5416.0
2014-10-14 07:00:00	AAPL	Stock	25.035	25.1	25.025	25.05	131508.0
2014-10-14 07:30:00	AAPL	Stock	25.05	25.0675	25.025	25.055	98516.0
2014-10-14 08:00:00	AAPL	Stock	25.0425	25.1625	25.0	25.1125	899996.0
2014-10-14 08:30:00	AAPL	Stock	25.1225	25.1375	25.07	25.12	368124.0
2014-10-14 09:00:00	AAPL	Stock	25.115	25.125	25.0425	25.1	369828.0
2014-10-14 09:30:00	AAPL	Stock	25.0975	25.13	24.795	24.85	36448796.0
2014-10-14 10:00:00	AAPL	Stock	24.8525	25.0325	24.7225	24.865	28040260.0
2014-10-14 10:30:00	AAPL	Stock	24.8625	25.0625	24.845	24.9975	18596256.0
2014-10-14 11:00:00	AAPL	Stock	24.9962	25.0975	24.9625	25.0248	11640892.0
2014-10-14 11:30:00	AAPL	Stock	25.0238	25.1028	24.98	25.054	10539844.0
2014-10-14 12:00:00	AAPL	Stock	25.0525	25.115	24.975	24.9962	10611332.0
2014-10-14 12:30:00	AAPL	Stock	24.9962	25.01	24.95	24.965	7589648.0
2014-10-14 13:00:00	AAPL	Stock	24.9662	24.975	24.8625	24.875	9879684.0
2014-10-14 13:30:00	AAPL	Stock	24.875	24.89	24.7375	24.7825	15423940.0
2014-10-14 14:00:00	AAPL	Stock	24.78	24.89	24.7325	24.7388	11871128.0
2014-10-14 14:30:00	AAPL	Stock	24.74	24.865	24.7025	24.8025	14569684.0
2014-10-14 15:00:00	AAPL	Stock	24.8025	24.85	24.7	24.77	17820740.0
2014-10-14 15:30:00	AAPL	Stock	24.7675	24.9075	24.6425	24.6975	30646300.0
2014-10-14 16:00:00	AAPL	Stock	24.6875	24.9922	24.6875	24.7425	12607780.0
2014-10-14 16:30:00	AAPL	Stock	24.745	27.4225	20.4163	24.775	190688.0
2014-10-14 17:00:00	AAPL	Stock	24.7825	24.79	24.6875	24.79	437232.0
2014-10-14 17:30:00	AAPL	Stock	24.7775	24.79	24.6875	24.77	1177524.0
2014-10-14 18:00:00	AAPL	Stock	24.775	24.85	24.77	24.8	220716.0
2014-10-14 18:30:00	AAPL	Stock	24.8	24.8125	24.79	24.81	21908.0
2014-10-14 19:00:00	AAPL	Stock	24.81	24.82	24.8025	24.8125	37232.0
2014-10-14 19:30:00	AAPL	Stock	24.8175	24.8225	24.805	24.82	47944.0
2014-10-14 05:30:00	MSFT	Stock	43.5	43.65	43.5	43.65	700.0
2014-10-14 06:00:00	MSFT	Stock	43.51	43.51	43.5	43.5	5700.0
2014-10-14 06:30:00	MSFT	Stock	43.55	43.55	43.55	43.55	100.0
2014-10-14 07:00:00	MSFT	Stock	43.7	43.7	43.6	43.6	4753.0
2014-10-14 07:30:00	MSFT	Stock	43.7	43.7	43.7	43.7	697.0
2014-10-14 08:00:00	MSFT	Stock	43.65	44.01	43.65	44.01	7810.0
2014-10-14 08:30:00	MSFT	Stock	43.96	44.01	43.92	43.92	1762.0
2014-10-14 09:00:00	MSFT	Stock	43.91	43.91	43.86	43.89	13598.0
2014-10-14 09:30:00	MSFT	Stock	43.89	44.38	43.56	44.37	4649830.0
2014-10-14 10:00:00	MSFT	Stock	44.37	44.38	43.89	43.944	3807997.0
2014-10-14 10:30:00	MSFT	Stock	43.95	44.01	43.81	43.93	2877288.0
2014-10-14 11:00:00	MSFT	Stock	43.94	44.0	43.68	43.71	2639543.0
2014-10-14 11:30:00	MSFT	Stock	43.71	43.97	43.69	43.935	2168893.0
2014-10-14 12:00:00	MSFT	Stock	43.93	43.96	43.85	43.88	2104668.0
2014-10-14 12:30:00	MSFT	Stock	43.885	44.08	43.85	44.07	1200529.0
2014-10-14 13:00:00	MSFT	Stock	44.065	44.18	44.01	44.096	1477061.0
2014-10-14 13:30:00	MSFT	Stock	44.1	44.125	43.92	44.09	943426.0
2014-10-14 14:00:00	MSFT	Stock	44.09	44.15	43.8	43.81	1694177.0

> showing 50 of 85,814 rows — these rows as CSV

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