PREVIEW / stock_30min / 2014-03-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-25.parquet
  size:    1.6 MB
  rows:    82,665
  symbols: 3,522

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-03-25 04:00:00	AAPL	Stock	19.2857	19.2857	19.2857	19.2857	2800.0
2014-03-25 04:30:00	AAPL	Stock	19.3039	19.3039	19.3039	19.3039	2800.0
2014-03-25 05:00:00	AAPL	Stock	19.2857	19.2857	19.2857	19.2857	2800.0
2014-03-25 06:00:00	AAPL	Stock	19.3021	19.3021	19.3021	19.3021	2800.0
2014-03-25 06:30:00	AAPL	Stock	19.3136	19.3136	19.2786	19.2786	36456.0
2014-03-25 07:00:00	AAPL	Stock	19.2804	19.3082	19.2804	19.3082	94724.0
2014-03-25 07:30:00	AAPL	Stock	19.3079	19.35	19.3036	19.3343	254380.0
2014-03-25 08:00:00	AAPL	Stock	19.3304	19.3304	19.2611	19.2754	505092.0
2014-03-25 08:30:00	AAPL	Stock	19.275	19.3189	19.275	19.3093	558096.0
2014-03-25 09:00:00	AAPL	Stock	19.3089	19.3593	19.3089	19.3311	853580.0
2014-03-25 09:30:00	AAPL	Stock	19.3393	19.3882	19.2954	19.3754	38237584.0
2014-03-25 10:00:00	AAPL	Stock	19.3771	19.4286	19.3771	19.3817	25024440.0
2014-03-25 10:30:00	AAPL	Stock	19.3836	19.3896	19.3186	19.3343	18576320.0
2014-03-25 11:00:00	AAPL	Stock	19.3343	19.4018	19.325	19.3896	10025596.0
2014-03-25 11:30:00	AAPL	Stock	19.3923	19.3929	19.3011	19.3279	10639776.0
2014-03-25 12:00:00	AAPL	Stock	19.3293	19.3518	19.2711	19.2943	12615848.0
2014-03-25 12:30:00	AAPL	Stock	19.2904	19.3604	19.2843	19.3507	7969864.0
2014-03-25 13:00:00	AAPL	Stock	19.3536	19.3929	19.3314	19.3818	8559348.0
2014-03-25 13:30:00	AAPL	Stock	19.3805	19.3968	19.3518	19.3689	8565872.0
2014-03-25 14:00:00	AAPL	Stock	19.3704	19.3764	19.3446	19.3614	5239332.0
2014-03-25 14:30:00	AAPL	Stock	19.3607	19.4204	19.3607	19.4186	10667020.0
2014-03-25 15:00:00	AAPL	Stock	19.4196	19.4679	19.4175	19.4636	24269112.0
2014-03-25 15:30:00	AAPL	Stock	19.4639	19.4911	19.4489	19.4643	24732456.0
2014-03-25 16:00:00	AAPL	Stock	19.4639	19.4702	19.2489	19.4554	9036244.0
2014-03-25 16:30:00	AAPL	Stock	19.4554	19.4639	19.4336	19.4429	492044.0
2014-03-25 17:00:00	AAPL	Stock	19.4464	19.4639	19.4321	19.4429	481040.0
2014-03-25 17:30:00	AAPL	Stock	19.4511	19.4639	19.4357	19.4411	108388.0
2014-03-25 18:00:00	AAPL	Stock	19.4482	19.455	19.4482	19.455	98420.0
2014-03-25 18:30:00	AAPL	Stock	19.4568	19.4679	19.4568	19.4596	342748.0
2014-03-25 19:00:00	AAPL	Stock	19.4632	19.4907	19.4614	19.4907	235340.0
2014-03-25 19:30:00	AAPL	Stock	19.49	19.5018	19.4739	19.5018	172396.0
2014-03-25 07:00:00	MSFT	Stock	40.54	40.54	40.52	40.52	1500.0
2014-03-25 07:30:00	MSFT	Stock	40.55	40.6	40.55	40.55	1448.0
2014-03-25 08:00:00	MSFT	Stock	40.56	40.72	40.48	40.72	19987.0
2014-03-25 08:30:00	MSFT	Stock	40.72	40.78	40.72	40.75	8504.0
2014-03-25 09:00:00	MSFT	Stock	40.72	40.72	40.65	40.68	13552.0
2014-03-25 09:30:00	MSFT	Stock	40.66	40.99	40.65	40.705	3874136.0
2014-03-25 10:00:00	MSFT	Stock	40.71	40.74	40.49	40.55	3819440.0
2014-03-25 10:30:00	MSFT	Stock	40.54	40.55	40.13	40.255	3165425.0
2014-03-25 11:00:00	MSFT	Stock	40.25	40.36	40.145	40.17	2656550.0
2014-03-25 11:30:00	MSFT	Stock	40.18	40.234	40.03	40.09	2920835.0
2014-03-25 12:00:00	MSFT	Stock	40.08	40.12	39.96	40.05	4238747.0
2014-03-25 12:30:00	MSFT	Stock	40.05	40.24	40.02	40.13	3468203.0
2014-03-25 13:00:00	MSFT	Stock	40.14	40.23	40.05	40.19	1853838.0
2014-03-25 13:30:00	MSFT	Stock	40.195	40.24	40.09	40.105	1796011.0
2014-03-25 14:00:00	MSFT	Stock	40.11	40.16	40.03	40.08	1712337.0
2014-03-25 14:30:00	MSFT	Stock	40.09	40.19	40.07	40.156	1388946.0
2014-03-25 15:00:00	MSFT	Stock	40.16	40.41	40.15	40.32	2517261.0
2014-03-25 15:30:00	MSFT	Stock	40.315	40.46	40.28	40.35	4963818.0
2014-03-25 16:00:00	MSFT	Stock	40.34	40.37	40.12	40.34	2170642.0

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

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