PREVIEW / stock_30min / 2014-09-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-10.parquet
  size:    1.6 MB
  rows:    82,505
  symbols: 3,569

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-09-10 04:00:00	AAPL	Stock	23.475	24.6	23.475	24.2625	148524.0
2014-09-10 04:30:00	AAPL	Stock	24.2675	24.345	24.2275	24.325	88892.0
2014-09-10 05:00:00	AAPL	Stock	24.345	24.4375	24.345	24.4375	111208.0
2014-09-10 05:30:00	AAPL	Stock	24.43	24.4475	24.3875	24.4125	38168.0
2014-09-10 06:00:00	AAPL	Stock	24.405	24.6175	24.3925	24.5875	180628.0
2014-09-10 06:30:00	AAPL	Stock	24.585	24.6625	24.545	24.64	133264.0
2014-09-10 07:00:00	AAPL	Stock	24.63	24.6475	24.4625	24.53	713308.0
2014-09-10 07:30:00	AAPL	Stock	24.53	24.5425	24.3375	24.3875	996984.0
2014-09-10 08:00:00	AAPL	Stock	24.4125	24.6275	24.255	24.3975	1677532.0
2014-09-10 08:30:00	AAPL	Stock	24.3975	24.495	24.275	24.495	1708520.0
2014-09-10 09:00:00	AAPL	Stock	24.4825	24.6275	24.455	24.515	3392568.0
2014-09-10 09:30:00	AAPL	Stock	24.5025	24.825	24.4475	24.57	65042408.0
2014-09-10 10:00:00	AAPL	Stock	24.5675	24.645	24.44	24.5925	38749928.0
2014-09-10 10:30:00	AAPL	Stock	24.5995	24.725	24.5025	24.6888	27194936.0
2014-09-10 11:00:00	AAPL	Stock	24.6875	24.7825	24.575	24.755	24188176.0
2014-09-10 11:30:00	AAPL	Stock	24.7542	24.9375	24.7542	24.9125	27912920.0
2014-09-10 12:00:00	AAPL	Stock	24.91	24.98	24.855	24.9798	18006652.0
2014-09-10 12:30:00	AAPL	Stock	24.98	25.185	24.9765	25.1102	30072536.0
2014-09-10 13:00:00	AAPL	Stock	25.111	25.2775	25.105	25.205	27762156.0
2014-09-10 13:30:00	AAPL	Stock	25.2048	25.205	25.015	25.045	23967420.0
2014-09-10 14:00:00	AAPL	Stock	25.045	25.1	24.975	25.0858	14330160.0
2014-09-10 14:30:00	AAPL	Stock	25.085	25.13	25.03	25.0818	12993616.0
2014-09-10 15:00:00	AAPL	Stock	25.0825	25.2125	25.06	25.2025	17939348.0
2014-09-10 15:30:00	AAPL	Stock	25.205	25.2625	25.1575	25.245	37778164.0
2014-09-10 16:00:00	AAPL	Stock	25.25	25.26	24.4975	25.2375	7249168.0
2014-09-10 16:30:00	AAPL	Stock	25.23	25.25	24.4835	25.24	849024.0
2014-09-10 17:00:00	AAPL	Stock	25.2375	25.25	25.2275	25.245	347460.0
2014-09-10 17:30:00	AAPL	Stock	25.2475	25.25	25.215	25.215	1017684.0
2014-09-10 18:00:00	AAPL	Stock	25.215	25.25	25.2125	25.2375	295292.0
2014-09-10 18:30:00	AAPL	Stock	25.2375	25.2475	25.235	25.2425	99200.0
2014-09-10 19:00:00	AAPL	Stock	25.24	25.255	25.24	25.2525	97036.0
2014-09-10 19:30:00	AAPL	Stock	25.2525	25.2975	25.25	25.2975	244692.0
2014-09-10 06:00:00	MSFT	Stock	46.97	47.08	46.97	47.08	1300.0
2014-09-10 07:00:00	MSFT	Stock	46.99	47.0	46.95	46.95	4300.0
2014-09-10 08:00:00	MSFT	Stock	46.85	46.93	46.85	46.9	11700.0
2014-09-10 08:30:00	MSFT	Stock	46.87	46.9	46.87	46.9	6772.0
2014-09-10 09:00:00	MSFT	Stock	46.9	46.93	46.82	46.83	39408.0
2014-09-10 09:30:00	MSFT	Stock	46.82	46.875	46.28	46.71	4909108.0
2014-09-10 10:00:00	MSFT	Stock	46.705	46.81	46.63	46.695	1885354.0
2014-09-10 10:30:00	MSFT	Stock	46.7	46.75	46.64	46.72	2054023.0
2014-09-10 11:00:00	MSFT	Stock	46.72	46.75	46.66	46.715	2476045.0
2014-09-10 11:30:00	MSFT	Stock	46.72	46.78	46.66	46.78	1416590.0
2014-09-10 12:00:00	MSFT	Stock	46.77	46.78	46.72	46.745	793772.0
2014-09-10 12:30:00	MSFT	Stock	46.75	46.79	46.71	46.76	618219.0
2014-09-10 13:00:00	MSFT	Stock	46.765	46.84	46.72	46.805	1242088.0
2014-09-10 13:30:00	MSFT	Stock	46.81	46.88	46.8	46.86	879199.0
2014-09-10 14:00:00	MSFT	Stock	46.86	46.94	46.81	46.82	1372000.0
2014-09-10 14:30:00	MSFT	Stock	46.81	46.817	46.7	46.76	1400576.0
2014-09-10 15:00:00	MSFT	Stock	46.755	46.84	46.75	46.815	1557442.0
2014-09-10 15:30:00	MSFT	Stock	46.815	46.86	46.75	46.825	3090412.0

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

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