PREVIEW / stock_30min / 2012-04-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-04.parquet
  size:    1.4 MB
  rows:    76,291
  symbols: 3,510

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
2012-04-04 04:00:00	AAPL	Stock	22.3929	22.3929	22.3732	22.3732	16800.0
2012-04-04 05:00:00	AAPL	Stock	22.3239	22.3571	22.3236	22.3236	44436.0
2012-04-04 05:30:00	AAPL	Stock	22.3239	22.3411	22.3214	22.3411	69104.0
2012-04-04 06:00:00	AAPL	Stock	22.3304	22.3304	22.3032	22.3032	25256.0
2012-04-04 06:30:00	AAPL	Stock	22.3036	22.3321	22.3036	22.3036	99400.0
2012-04-04 07:00:00	AAPL	Stock	22.3107	22.3214	22.255	22.2768	516908.0
2012-04-04 07:30:00	AAPL	Stock	22.2793	22.3214	22.2679	22.3036	881188.0
2012-04-04 08:00:00	AAPL	Stock	22.3121	22.3464	22.2696	22.2718	3476508.0
2012-04-04 08:30:00	AAPL	Stock	22.275	22.3036	22.2357	22.2857	2724876.0
2012-04-04 09:00:00	AAPL	Stock	22.2814	22.3079	22.2679	22.3071	2697436.0
2012-04-04 09:30:00	AAPL	Stock	22.3025	22.3407	22.2004	22.3132	95610788.0
2012-04-04 10:00:00	AAPL	Stock	22.3146	22.3146	22.129	22.1661	79539180.0
2012-04-04 10:30:00	AAPL	Stock	22.1671	22.2089	22.1171	22.1496	56942816.0
2012-04-04 11:00:00	AAPL	Stock	22.1482	22.2286	22.1457	22.1918	28428960.0
2012-04-04 11:30:00	AAPL	Stock	22.1921	22.2357	22.1814	22.2054	20688108.0
2012-04-04 12:00:00	AAPL	Stock	22.2032	22.2057	22.1429	22.1921	25275740.0
2012-04-04 12:30:00	AAPL	Stock	22.1921	22.1975	22.1653	22.1764	15483636.0
2012-04-04 13:00:00	AAPL	Stock	22.1739	22.1848	22.1114	22.1187	27471892.0
2012-04-04 13:30:00	AAPL	Stock	22.1188	22.1918	22.0929	22.1607	31855488.0
2012-04-04 14:00:00	AAPL	Stock	22.1572	22.1636	22.0993	22.1221	21192080.0
2012-04-04 14:30:00	AAPL	Stock	22.1228	22.1964	22.1007	22.1589	28261884.0
2012-04-04 15:00:00	AAPL	Stock	22.1596	22.2661	22.1357	22.2461	37946524.0
2012-04-04 15:30:00	AAPL	Stock	22.2464	22.3521	22.2461	22.2889	77137368.0
2012-04-04 16:00:00	AAPL	Stock	22.2936	22.3071	22.201	22.2811	7302848.0
2012-04-04 16:30:00	AAPL	Stock	22.2804	22.2979	22.2434	22.2957	6834492.0
2012-04-04 17:00:00	AAPL	Stock	22.1857	22.2957	22.1857	22.2779	212828.0
2012-04-04 17:30:00	AAPL	Stock	22.2768	22.2857	22.275	22.2761	148652.0
2012-04-04 18:00:00	AAPL	Stock	22.2754	22.2857	22.275	22.2857	103544.0
2012-04-04 18:30:00	AAPL	Stock	22.2857	22.2911	22.2786	22.2786	119476.0
2012-04-04 19:00:00	AAPL	Stock	22.285	22.2857	22.2821	22.2821	79884.0
2012-04-04 19:30:00	AAPL	Stock	22.2839	22.2854	22.2521	22.2521	554596.0
2012-04-04 07:30:00	MSFT	Stock	31.7	31.7	31.7	31.7	1885.0
2012-04-04 08:00:00	MSFT	Stock	31.7	31.7	31.66	31.68	43324.0
2012-04-04 08:30:00	MSFT	Stock	31.68	31.7	31.64	31.69	10809.0
2012-04-04 09:00:00	MSFT	Stock	31.69	31.7	31.64	31.67	12767.0
2012-04-04 09:30:00	MSFT	Stock	31.68	31.69	31.34	31.38	7107895.0
2012-04-04 10:00:00	MSFT	Stock	31.38	31.44	31.19	31.35	6406689.0
2012-04-04 10:30:00	MSFT	Stock	31.345	31.43	31.16	31.19	3477367.0
2012-04-04 11:00:00	MSFT	Stock	31.19	31.21	31.06	31.12	5114876.0
2012-04-04 11:30:00	MSFT	Stock	31.13	31.27	31.13	31.185	2572076.0
2012-04-04 12:00:00	MSFT	Stock	31.185	31.24	31.15	31.19	2251023.0
2012-04-04 12:30:00	MSFT	Stock	31.2	31.215	31.1	31.14	2158924.0
2012-04-04 13:00:00	MSFT	Stock	31.13	31.14	31.05	31.052	1968756.0
2012-04-04 13:30:00	MSFT	Stock	31.06	31.17	31.05	31.148	1976550.0
2012-04-04 14:00:00	MSFT	Stock	31.15	31.22	31.12	31.17	1976822.0
2012-04-04 14:30:00	MSFT	Stock	31.175	31.29	31.16	31.24	2245546.0
2012-04-04 15:00:00	MSFT	Stock	31.235	31.31	31.225	31.27	2638468.0
2012-04-04 15:30:00	MSFT	Stock	31.27	31.32	31.2	31.22	7156448.0
2012-04-04 16:00:00	MSFT	Stock	31.22	31.249	31.16	31.2	1856949.0
2012-04-04 16:30:00	MSFT	Stock	31.21	31.27	31.17	31.19	152524.0

> showing 50 of 76,291 rows — these rows as CSV

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