PREVIEW / stock_30min / 2014-03-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-24.parquet
  size:    1.6 MB
  rows:    81,998
  symbols: 3,552

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-24 04:00:00	AAPL	Stock	19.1425	19.3711	19.1425	19.2929	50960.0
2014-03-24 04:30:00	AAPL	Stock	19.3086	19.3214	19.2743	19.2964	391776.0
2014-03-24 05:00:00	AAPL	Stock	19.3036	19.3036	19.1786	19.1786	326004.0
2014-03-24 05:30:00	AAPL	Stock	19.1821	19.2282	19.1789	19.2282	168112.0
2014-03-24 06:00:00	AAPL	Stock	19.2279	19.2279	19.1804	19.1975	31360.0
2014-03-24 06:30:00	AAPL	Stock	19.1907	19.2125	19.1907	19.2125	67200.0
2014-03-24 07:00:00	AAPL	Stock	19.215	19.3179	19.2093	19.2636	684012.0
2014-03-24 07:30:00	AAPL	Stock	19.2643	19.2893	19.25	19.2893	400764.0
2014-03-24 08:00:00	AAPL	Stock	19.2871	19.3152	19.2057	19.2182	2008160.0
2014-03-24 08:30:00	AAPL	Stock	19.2321	19.2571	19.2175	19.2432	973560.0
2014-03-24 09:00:00	AAPL	Stock	19.2357	19.2496	19.2179	19.2186	1696828.0
2014-03-24 09:30:00	AAPL	Stock	19.2293	19.3036	19.1839	19.2525	65429896.0
2014-03-24 10:00:00	AAPL	Stock	19.2531	19.285	19.2243	19.2393	26462660.0
2014-03-24 10:30:00	AAPL	Stock	19.2393	19.2446	19.1196	19.1814	25179224.0
2014-03-24 11:00:00	AAPL	Stock	19.1814	19.19	19.1214	19.1821	15867264.0
2014-03-24 11:30:00	AAPL	Stock	19.1854	19.2068	19.125	19.1532	13728008.0
2014-03-24 12:00:00	AAPL	Stock	19.15	19.1975	19.1282	19.1425	9965704.0
2014-03-24 12:30:00	AAPL	Stock	19.1425	19.1832	19.1093	19.1611	8950340.0
2014-03-24 13:00:00	AAPL	Stock	19.1679	19.2071	19.1582	19.1796	8021412.0
2014-03-24 13:30:00	AAPL	Stock	19.1782	19.2568	19.1711	19.2486	12610332.0
2014-03-24 14:00:00	AAPL	Stock	19.2468	19.2682	19.2321	19.2632	8196664.0
2014-03-24 14:30:00	AAPL	Stock	19.2625	19.2957	19.2429	19.2625	16061668.0
2014-03-24 15:00:00	AAPL	Stock	19.2629	19.2782	19.1989	19.2782	11746420.0
2014-03-24 15:30:00	AAPL	Stock	19.2786	19.292	19.2118	19.2554	23155776.0
2014-03-24 16:00:00	AAPL	Stock	19.2536	19.2679	19.1615	19.2561	44854824.0
2014-03-24 16:30:00	AAPL	Stock	19.2518	19.265	19.2497	19.265	1577352.0
2014-03-24 17:00:00	AAPL	Stock	19.2607	19.28	19.2607	19.28	338968.0
2014-03-24 17:30:00	AAPL	Stock	19.2714	19.2775	19.2536	19.2679	263060.0
2014-03-24 18:00:00	AAPL	Stock	19.2536	19.2661	19.2536	19.2611	279020.0
2014-03-24 18:30:00	AAPL	Stock	19.2679	19.2704	19.2625	19.2625	30240.0
2014-03-24 19:00:00	AAPL	Stock	19.2643	19.2657	19.2557	19.2618	113876.0
2014-03-24 19:30:00	AAPL	Stock	19.2618	19.2618	19.2429	19.2461	128604.0
2014-03-24 06:30:00	MSFT	Stock	40.27	40.27	40.27	40.27	500.0
2014-03-24 07:30:00	MSFT	Stock	40.28	40.35	40.28	40.35	1120.0
2014-03-24 08:00:00	MSFT	Stock	40.28	40.36	40.08	40.35	3517.0
2014-03-24 08:30:00	MSFT	Stock	40.35	40.47	40.35	40.46	43636.0
2014-03-24 09:00:00	MSFT	Stock	40.46	40.62	40.36	40.36	50885.0
2014-03-24 09:30:00	MSFT	Stock	40.34	40.51	40.21	40.26	5038563.0
2014-03-24 10:00:00	MSFT	Stock	40.265	40.31	40.16	40.22	3603241.0
2014-03-24 10:30:00	MSFT	Stock	40.22	40.25	39.93	40.041	3718568.0
2014-03-24 11:00:00	MSFT	Stock	40.045	40.07	39.86	40.02	2644505.0
2014-03-24 11:30:00	MSFT	Stock	40.03	40.13	39.92	40.05	5471200.0
2014-03-24 12:00:00	MSFT	Stock	40.05	40.15	39.99	40.02	2316524.0
2014-03-24 12:30:00	MSFT	Stock	40.02	40.06	39.99	40.04	1240363.0
2014-03-24 13:00:00	MSFT	Stock	40.05	40.4	40.04	40.393	2282041.0
2014-03-24 13:30:00	MSFT	Stock	40.39	40.51	40.0	40.5	2211163.0
2014-03-24 14:00:00	MSFT	Stock	40.5	40.582	40.46	40.54	1862951.0
2014-03-24 14:30:00	MSFT	Stock	40.54	40.64	40.45	40.62	2288627.0
2014-03-24 15:00:00	MSFT	Stock	40.611	40.62	40.46	40.59	2061063.0
2014-03-24 15:30:00	MSFT	Stock	40.6	40.64	40.49	40.49	4737029.0

> showing 50 of 81,998 rows — these rows as CSV

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