PREVIEW / stock_30min / 2014-04-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-16.parquet
  size:    1.6 MB
  rows:    82,244
  symbols: 3,545

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-04-16 04:00:00	AAPL	Stock	18.5436	18.5436	18.5436	18.5436	2800.0
2014-04-16 04:30:00	AAPL	Stock	18.5464	18.5464	18.5464	18.5464	2800.0
2014-04-16 05:00:00	AAPL	Stock	18.5464	18.5464	18.5464	18.5464	2800.0
2014-04-16 05:30:00	AAPL	Stock	18.5536	18.5714	18.5536	18.5714	18172.0
2014-04-16 06:00:00	AAPL	Stock	18.5714	18.5714	18.5536	18.5536	5880.0
2014-04-16 06:30:00	AAPL	Stock	18.5571	18.5571	18.5536	18.5536	9800.0
2014-04-16 07:00:00	AAPL	Stock	18.5693	18.5711	18.5693	18.5707	14000.0
2014-04-16 07:30:00	AAPL	Stock	18.5536	18.5793	18.55	18.5736	89544.0
2014-04-16 08:00:00	AAPL	Stock	18.5764	18.5875	18.5189	18.5354	264768.0
2014-04-16 08:30:00	AAPL	Stock	18.5268	18.5357	18.485	18.4886	294784.0
2014-04-16 09:00:00	AAPL	Stock	18.4886	18.5143	18.4886	18.5086	440244.0
2014-04-16 09:30:00	AAPL	Stock	18.5018	18.5429	18.3989	18.4064	27817244.0
2014-04-16 10:00:00	AAPL	Stock	18.4007	18.4593	18.3868	18.425	14920444.0
2014-04-16 10:30:00	AAPL	Stock	18.4284	18.4496	18.362	18.38	14230804.0
2014-04-16 11:00:00	AAPL	Stock	18.3864	18.4507	18.3714	18.4471	9104032.0
2014-04-16 11:30:00	AAPL	Stock	18.4507	18.4982	18.4293	18.4925	11086880.0
2014-04-16 12:00:00	AAPL	Stock	18.4925	18.6104	18.4918	18.6025	21327180.0
2014-04-16 12:30:00	AAPL	Stock	18.6025	18.6104	18.5104	18.5104	11900644.0
2014-04-16 13:00:00	AAPL	Stock	18.5086	18.5425	18.4736	18.5309	8694840.0
2014-04-16 13:30:00	AAPL	Stock	18.5357	18.5357	18.4746	18.5299	5976236.0
2014-04-16 14:00:00	AAPL	Stock	18.5329	18.5329	18.4682	18.485	5766740.0
2014-04-16 14:30:00	AAPL	Stock	18.4854	18.5307	18.4854	18.5179	5953444.0
2014-04-16 15:00:00	AAPL	Stock	18.5239	18.5268	18.5014	18.5243	7308476.0
2014-04-16 15:30:00	AAPL	Stock	18.5243	18.5386	18.5107	18.5348	17226356.0
2014-04-16 16:00:00	AAPL	Stock	18.5361	18.5398	18.4718	18.5	7646212.0
2014-04-16 16:30:00	AAPL	Stock	18.4175	18.5361	18.4175	18.5361	205772.0
2014-04-16 17:00:00	AAPL	Stock	18.5361	18.5361	18.4814	18.4821	899248.0
2014-04-16 17:30:00	AAPL	Stock	18.4961	18.4975	18.4961	18.4975	5628.0
2014-04-16 18:00:00	AAPL	Stock	18.4875	18.5361	18.4643	18.5361	293384.0
2014-04-16 18:30:00	AAPL	Stock	18.4821	18.4821	18.4807	18.4807	8400.0
2014-04-16 19:00:00	AAPL	Stock	18.4646	18.4646	18.4643	18.4643	23912.0
2014-04-16 19:30:00	AAPL	Stock	18.4375	18.4554	18.4357	18.4464	89376.0
2014-04-16 07:30:00	MSFT	Stock	40.0	40.0	40.0	40.0	200.0
2014-04-16 08:00:00	MSFT	Stock	40.05	40.1	39.95	40.0	6422.0
2014-04-16 08:30:00	MSFT	Stock	40.05	40.07	39.95	39.95	12056.0
2014-04-16 09:00:00	MSFT	Stock	39.99	40.03	39.95	40.02	6114.0
2014-04-16 09:30:00	MSFT	Stock	40.06	40.35	39.94	40.07	5726915.0
2014-04-16 10:00:00	MSFT	Stock	40.07	40.305	39.99	40.161	1949482.0
2014-04-16 10:30:00	MSFT	Stock	40.16	40.22	39.95	39.985	1461637.0
2014-04-16 11:00:00	MSFT	Stock	39.985	40.11	39.905	40.069	1329927.0
2014-04-16 11:30:00	MSFT	Stock	40.07	40.13	40.01	40.08	1849064.0
2014-04-16 12:00:00	MSFT	Stock	40.082	40.35	40.07	40.292	1924724.0
2014-04-16 12:30:00	MSFT	Stock	40.296	40.3	40.06	40.07	1131981.0
2014-04-16 13:00:00	MSFT	Stock	40.06	40.14	39.98	40.075	1122568.0
2014-04-16 13:30:00	MSFT	Stock	40.07	40.17	40.0	40.17	1351145.0
2014-04-16 14:00:00	MSFT	Stock	40.17	40.2	40.01	40.05	1238264.0
2014-04-16 14:30:00	MSFT	Stock	40.05	40.215	40.05	40.17	1151585.0
2014-04-16 15:00:00	MSFT	Stock	40.16	40.24	40.06	40.23	1379313.0
2014-04-16 15:30:00	MSFT	Stock	40.23	40.415	40.19	40.39	5648544.0
2014-04-16 16:00:00	MSFT	Stock	40.4	40.44	40.166	40.18	1656116.0

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

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