PREVIEW / stock_30min / 2014-10-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-07.parquet
  size:    1.6 MB
  rows:    82,631
  symbols: 3,570

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-07 04:00:00	AAPL	Stock	24.8575	24.8575	24.8575	24.8575	800.0
2014-10-07 04:30:00	AAPL	Stock	24.795	24.795	24.785	24.785	1200.0
2014-10-07 05:00:00	AAPL	Stock	24.785	24.785	24.75	24.755	22400.0
2014-10-07 05:30:00	AAPL	Stock	24.755	24.795	24.755	24.795	9784.0
2014-10-07 06:00:00	AAPL	Stock	24.7875	24.925	24.7875	24.925	23528.0
2014-10-07 06:30:00	AAPL	Stock	24.935	24.935	24.875	24.8925	10400.0
2014-10-07 07:00:00	AAPL	Stock	24.8875	24.955	24.8875	24.9175	170912.0
2014-10-07 07:30:00	AAPL	Stock	24.9175	24.925	24.875	24.9225	195616.0
2014-10-07 08:00:00	AAPL	Stock	24.92	24.9875	24.8925	24.95	303956.0
2014-10-07 08:30:00	AAPL	Stock	24.95	24.9625	24.9125	24.9425	233224.0
2014-10-07 09:00:00	AAPL	Stock	24.945	24.955	24.825	24.8625	424884.0
2014-10-07 09:30:00	AAPL	Stock	24.86	25.0225	24.8475	24.9925	25115680.0
2014-10-07 10:00:00	AAPL	Stock	24.99	25.03	24.9225	24.9675	18213552.0
2014-10-07 10:30:00	AAPL	Stock	24.9675	25.0125	24.92	24.9338	12767444.0
2014-10-07 11:00:00	AAPL	Stock	24.935	24.9575	24.805	24.8225	11522080.0
2014-10-07 11:30:00	AAPL	Stock	24.82	24.925	24.79	24.91	8660548.0
2014-10-07 12:00:00	AAPL	Stock	24.9125	24.9725	24.905	24.927	6225448.0
2014-10-07 12:30:00	AAPL	Stock	24.9272	24.9375	24.84	24.872	6240844.0
2014-10-07 13:00:00	AAPL	Stock	24.8725	24.905	24.82	24.8975	6267468.0
2014-10-07 13:30:00	AAPL	Stock	24.8972	24.9025	24.8375	24.8908	5517472.0
2014-10-07 14:00:00	AAPL	Stock	24.8903	24.8903	24.7975	24.8012	8183288.0
2014-10-07 14:30:00	AAPL	Stock	24.8025	24.8125	24.765	24.7802	8747548.0
2014-10-07 15:00:00	AAPL	Stock	24.78	24.8075	24.69	24.7675	14104304.0
2014-10-07 15:30:00	AAPL	Stock	24.765	24.795	24.6825	24.6875	18680128.0
2014-10-07 16:00:00	AAPL	Stock	24.6875	24.92	24.6675	24.695	4672932.0
2014-10-07 16:30:00	AAPL	Stock	24.6975	24.7075	24.6875	24.7	234508.0
2014-10-07 17:00:00	AAPL	Stock	24.7	24.7025	24.69	24.6925	17480.0
2014-10-07 17:30:00	AAPL	Stock	24.7	24.705	24.69	24.7025	52340.0
2014-10-07 18:00:00	AAPL	Stock	24.7	24.7025	24.6875	24.6875	145956.0
2014-10-07 18:30:00	AAPL	Stock	24.6975	24.7	24.6875	24.7	54752.0
2014-10-07 19:00:00	AAPL	Stock	24.6975	24.7	24.6925	24.6975	41712.0
2014-10-07 19:30:00	AAPL	Stock	24.7025	24.705	24.6875	24.7	50880.0
2014-10-07 08:00:00	MSFT	Stock	45.96	46.0	45.9	45.9	2960.0
2014-10-07 09:00:00	MSFT	Stock	45.95	45.95	45.86	45.89	14450.0
2014-10-07 09:30:00	MSFT	Stock	45.86	45.93	45.42	45.48	3461568.0
2014-10-07 10:00:00	MSFT	Stock	45.48	45.695	45.48	45.695	1676874.0
2014-10-07 10:30:00	MSFT	Stock	45.7	45.87	45.59	45.605	1739514.0
2014-10-07 11:00:00	MSFT	Stock	45.6	45.66	45.51	45.641	1095605.0
2014-10-07 11:30:00	MSFT	Stock	45.649	45.71	45.58	45.675	1218714.0
2014-10-07 12:00:00	MSFT	Stock	45.675	45.77	45.65	45.735	1036282.0
2014-10-07 12:30:00	MSFT	Stock	45.73	45.755	45.6	45.64	1123197.0
2014-10-07 13:00:00	MSFT	Stock	45.64	45.7	45.55	45.69	952896.0
2014-10-07 13:30:00	MSFT	Stock	45.68	45.725	45.62	45.71	978084.0
2014-10-07 14:00:00	MSFT	Stock	45.71	45.869	45.69	45.73	1851182.0
2014-10-07 14:30:00	MSFT	Stock	45.73	45.74	45.64	45.73	1670284.0
2014-10-07 15:00:00	MSFT	Stock	45.73	45.75	45.5	45.635	1994041.0
2014-10-07 15:30:00	MSFT	Stock	45.64	45.74	45.5	45.515	3859294.0
2014-10-07 16:00:00	MSFT	Stock	45.53	45.681	45.51	45.53	1847851.0
2014-10-07 16:30:00	MSFT	Stock	45.51	45.51	45.4	45.4	4830.0
2014-10-07 17:00:00	MSFT	Stock	45.47	45.47	45.47	45.47	200.0

> showing 50 of 82,631 rows — these rows as CSV

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