PREVIEW / stock_30min / 2014-08-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-18.parquet
  size:    1.6 MB
  rows:    83,796
  symbols: 3,589

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-08-18 04:00:00	AAPL	Stock	24.495	24.645	24.495	24.645	8000.0
2014-08-18 04:30:00	AAPL	Stock	24.645	24.65	24.6375	24.6375	5420.0
2014-08-18 05:00:00	AAPL	Stock	24.63	24.645	24.63	24.645	800.0
2014-08-18 05:30:00	AAPL	Stock	24.6375	24.6375	24.625	24.625	6800.0
2014-08-18 06:00:00	AAPL	Stock	24.63	24.64	24.63	24.64	23152.0
2014-08-18 06:30:00	AAPL	Stock	24.6325	24.6475	24.625	24.625	24808.0
2014-08-18 07:00:00	AAPL	Stock	24.6325	24.6525	24.63	24.6525	63360.0
2014-08-18 07:30:00	AAPL	Stock	24.6525	24.665	24.6475	24.65	126092.0
2014-08-18 08:00:00	AAPL	Stock	24.6525	24.6725	24.61	24.63	693236.0
2014-08-18 08:30:00	AAPL	Stock	24.6425	24.6475	24.63	24.6425	202028.0
2014-08-18 09:00:00	AAPL	Stock	24.6425	24.675	24.585	24.61	811824.0
2014-08-18 09:30:00	AAPL	Stock	24.6225	24.6825	24.495	24.6775	30916676.0
2014-08-18 10:00:00	AAPL	Stock	24.6775	24.7225	24.635	24.7022	14853800.0
2014-08-18 10:30:00	AAPL	Stock	24.7025	24.7475	24.675	24.745	9986520.0
2014-08-18 11:00:00	AAPL	Stock	24.745	24.775	24.72	24.7682	11848872.0
2014-08-18 11:30:00	AAPL	Stock	24.77	24.7825	24.5625	24.7375	11292156.0
2014-08-18 12:00:00	AAPL	Stock	24.7385	24.77	24.715	24.74	7741000.0
2014-08-18 12:30:00	AAPL	Stock	24.74	24.77	24.7325	24.77	6318800.0
2014-08-18 13:00:00	AAPL	Stock	24.7688	24.8	24.7625	24.7892	8149640.0
2014-08-18 13:30:00	AAPL	Stock	24.7888	24.8425	24.785	24.8142	9959880.0
2014-08-18 14:00:00	AAPL	Stock	24.8142	24.835	24.775	24.81	10186904.0
2014-08-18 14:30:00	AAPL	Stock	24.8098	24.815	24.765	24.795	7485648.0
2014-08-18 15:00:00	AAPL	Stock	24.795	24.81	24.7875	24.7938	7417668.0
2014-08-18 15:30:00	AAPL	Stock	24.7925	24.7975	24.7675	24.785	16940464.0
2014-08-18 16:00:00	AAPL	Stock	24.79	24.805	24.7593	24.79	22579152.0
2014-08-18 16:30:00	AAPL	Stock	24.79	24.8	24.7372	24.7925	109400.0
2014-08-18 17:00:00	AAPL	Stock	24.8	25.7195	24.7925	24.8125	50812.0
2014-08-18 17:30:00	AAPL	Stock	24.8125	24.815	24.79	24.8125	675000.0
2014-08-18 18:00:00	AAPL	Stock	24.8125	24.825	24.79	24.8225	268608.0
2014-08-18 18:30:00	AAPL	Stock	24.8225	24.8325	24.8125	24.8125	77604.0
2014-08-18 19:00:00	AAPL	Stock	24.8225	24.825	24.815	24.82	45628.0
2014-08-18 19:30:00	AAPL	Stock	24.82	24.8325	24.82	24.8325	58976.0
2014-08-18 07:00:00	MSFT	Stock	44.85	45.0	44.85	45.0	200.0
2014-08-18 07:30:00	MSFT	Stock	45.1	45.15	45.01	45.05	3910.0
2014-08-18 08:00:00	MSFT	Stock	45.05	45.11	45.0	45.06	9346.0
2014-08-18 08:30:00	MSFT	Stock	45.05	45.09	44.98	45.0	8886.0
2014-08-18 09:00:00	MSFT	Stock	45.0	45.02	44.86	44.92	27873.0
2014-08-18 09:30:00	MSFT	Stock	44.94	45.0	44.68	44.83	3419992.0
2014-08-18 10:00:00	MSFT	Stock	44.83	44.88	44.765	44.87	1799898.0
2014-08-18 10:30:00	MSFT	Stock	44.87	44.92	44.78	44.912	1768580.0
2014-08-18 11:00:00	MSFT	Stock	44.91	44.945	44.81	44.865	1447614.0
2014-08-18 11:30:00	MSFT	Stock	44.865	45.0	44.7	44.845	1799792.0
2014-08-18 12:00:00	MSFT	Stock	44.85	44.94	44.84	44.93	721367.0
2014-08-18 12:30:00	MSFT	Stock	44.925	44.93	44.85	44.91	694439.0
2014-08-18 13:00:00	MSFT	Stock	44.91	44.92	44.86	44.9	781763.0
2014-08-18 13:30:00	MSFT	Stock	44.9	44.96	44.89	44.93	753099.0
2014-08-18 14:00:00	MSFT	Stock	44.935	45.0	44.93	44.975	875705.0
2014-08-18 14:30:00	MSFT	Stock	44.98	45.05	44.96	45.04	2459332.0
2014-08-18 15:00:00	MSFT	Stock	45.035	45.09	45.03	45.05	1296714.0
2014-08-18 15:30:00	MSFT	Stock	45.05	45.11	45.01	45.105	2927496.0

> showing 50 of 83,796 rows — these rows as CSV

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