PREVIEW / stock_30min / 2013-08-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-02.parquet
  size:    1.5 MB
  rows:    78,514
  symbols: 3,516

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
2013-08-02 05:00:00	AAPL	Stock	16.3232	16.3232	16.3232	16.3232	2800.0
2013-08-02 05:30:00	AAPL	Stock	16.3232	16.3232	16.3232	16.3232	2800.0
2013-08-02 07:00:00	AAPL	Stock	16.3179	16.3179	16.3179	16.3179	14000.0
2013-08-02 07:30:00	AAPL	Stock	16.3171	16.3218	16.3046	16.3107	88480.0
2013-08-02 08:00:00	AAPL	Stock	16.3079	16.3643	16.2143	16.3571	679140.0
2013-08-02 08:30:00	AAPL	Stock	16.3571	16.3643	16.3136	16.35	1059856.0
2013-08-02 09:00:00	AAPL	Stock	16.3482	16.3639	16.3446	16.3504	772016.0
2013-08-02 09:30:00	AAPL	Stock	16.3525	16.4132	16.3093	16.3621	52448312.0
2013-08-02 10:00:00	AAPL	Stock	16.3636	16.3929	16.3496	16.3618	25508588.0
2013-08-02 10:30:00	AAPL	Stock	16.3611	16.3775	16.3368	16.3429	11349240.0
2013-08-02 11:00:00	AAPL	Stock	16.342	16.3825	16.3182	16.3675	15986936.0
2013-08-02 11:30:00	AAPL	Stock	16.3692	16.3875	16.3586	16.3771	7318752.0
2013-08-02 12:00:00	AAPL	Stock	16.3782	16.4104	16.3714	16.4075	8383396.0
2013-08-02 12:30:00	AAPL	Stock	16.4079	16.4504	16.4062	16.4482	21256872.0
2013-08-02 13:00:00	AAPL	Stock	16.4468	16.5	16.4329	16.4764	17836672.0
2013-08-02 13:30:00	AAPL	Stock	16.4736	16.4857	16.4379	16.4543	10359552.0
2013-08-02 14:00:00	AAPL	Stock	16.4532	16.4843	16.4518	16.4816	9217544.0
2013-08-02 14:30:00	AAPL	Stock	16.4807	16.5	16.4696	16.4996	13139448.0
2013-08-02 15:00:00	AAPL	Stock	16.4982	16.5304	16.4908	16.5204	22099644.0
2013-08-02 15:30:00	AAPL	Stock	16.52	16.5282	16.4689	16.5218	36699936.0
2013-08-02 16:00:00	AAPL	Stock	16.5196	16.5264	16.4236	16.5061	17239544.0
2013-08-02 16:30:00	AAPL	Stock	16.5193	16.5193	16.5	16.5193	950404.0
2013-08-02 17:00:00	AAPL	Stock	16.5168	16.5239	16.5168	16.5193	92540.0
2013-08-02 17:30:00	AAPL	Stock	16.5204	16.5204	16.5179	16.5179	160916.0
2013-08-02 18:00:00	AAPL	Stock	16.5179	16.5211	16.5179	16.5179	22820.0
2013-08-02 18:30:00	AAPL	Stock	16.5179	16.52	16.5164	16.5193	81732.0
2013-08-02 19:00:00	AAPL	Stock	16.5193	16.53	16.5193	16.5236	130060.0
2013-08-02 19:30:00	AAPL	Stock	16.5232	16.5232	16.5025	16.5036	398384.0
2013-08-02 07:00:00	MSFT	Stock	31.61	31.61	31.61	31.61	729.0
2013-08-02 08:00:00	MSFT	Stock	31.69	31.81	31.68	31.81	9215.0
2013-08-02 08:30:00	MSFT	Stock	31.69	31.69	31.59	31.59	11500.0
2013-08-02 09:00:00	MSFT	Stock	31.62	31.7	31.61	31.7	13540.0
2013-08-02 09:30:00	MSFT	Stock	31.7	31.72	31.565	31.65	3424359.0
2013-08-02 10:00:00	MSFT	Stock	31.65	31.78	31.61	31.77	2908974.0
2013-08-02 10:30:00	MSFT	Stock	31.78	31.78	31.62	31.62	1509269.0
2013-08-02 11:00:00	MSFT	Stock	31.63	31.74	31.6	31.695	2004913.0
2013-08-02 11:30:00	MSFT	Stock	31.69	31.75	31.69	31.72	1536585.0
2013-08-02 12:00:00	MSFT	Stock	31.72	31.725	31.67	31.678	1101854.0
2013-08-02 12:30:00	MSFT	Stock	31.675	31.72	31.67	31.69	1225114.0
2013-08-02 13:00:00	MSFT	Stock	31.7	31.75	31.68	31.74	1246735.0
2013-08-02 13:30:00	MSFT	Stock	31.74	31.76	31.7	31.74	1103487.0
2013-08-02 14:00:00	MSFT	Stock	31.74	31.8	31.73	31.781	1122416.0
2013-08-02 14:30:00	MSFT	Stock	31.78	31.85	31.77	31.81	1140339.0
2013-08-02 15:00:00	MSFT	Stock	31.815	31.85	31.78	31.79	1407286.0
2013-08-02 15:30:00	MSFT	Stock	31.785	31.9	31.75	31.89	5926082.0
2013-08-02 16:00:00	MSFT	Stock	31.88	31.89	31.703	31.703	2877010.0
2013-08-02 16:30:00	MSFT	Stock	31.88	31.88	31.79	31.88	331778.0
2013-08-02 17:00:00	MSFT	Stock	31.82	31.86	31.82	31.86	600.0
2013-08-02 17:30:00	MSFT	Stock	31.87	31.87	31.81	31.81	1379.0
2013-08-02 18:00:00	MSFT	Stock	31.83	31.83	31.83	31.83	129.0

> showing 50 of 78,514 rows — these rows as CSV

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