PREVIEW / stock_30min / 2009-11-12

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-12.parquet
  size:    1.3 MB
  rows:    71,260
  symbols: 3,401

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
2009-11-12 05:00:00	AAPL	Stock	7.2379	7.2379	7.2379	7.2379	6888.0
2009-11-12 05:30:00	AAPL	Stock	7.2571	7.2571	7.2571	7.2571	2800.0
2009-11-12 07:00:00	AAPL	Stock	7.25	7.25	7.2232	7.2296	43288.0
2009-11-12 07:30:00	AAPL	Stock	7.2304	7.2321	7.2239	7.2239	32480.0
2009-11-12 08:00:00	AAPL	Stock	7.2182	7.2482	7.2182	7.2482	212324.0
2009-11-12 08:30:00	AAPL	Stock	7.2464	7.2529	7.2336	7.2436	446096.0
2009-11-12 09:00:00	AAPL	Stock	7.2425	7.2604	7.2425	7.2604	341040.0
2009-11-12 09:30:00	AAPL	Stock	7.2604	7.3168	7.255	7.3079	56047684.0
2009-11-12 10:00:00	AAPL	Stock	7.3089	7.3146	7.2643	7.2971	33971448.0
2009-11-12 10:30:00	AAPL	Stock	7.2968	7.3132	7.2832	7.2836	27329204.0
2009-11-12 11:00:00	AAPL	Stock	7.2836	7.2864	7.2625	7.2839	31185504.0
2009-11-12 11:30:00	AAPL	Stock	7.2839	7.3132	7.25	7.2629	25548404.0
2009-11-12 12:00:00	AAPL	Stock	7.2629	7.2736	7.2589	7.2693	9833068.0
2009-11-12 12:30:00	AAPL	Stock	7.2682	7.2836	7.2518	7.2725	12673556.0
2009-11-12 13:00:00	AAPL	Stock	7.2718	7.2768	7.2464	7.2621	18618264.0
2009-11-12 13:30:00	AAPL	Stock	7.2629	7.2707	7.2561	7.265	9482900.0
2009-11-12 14:00:00	AAPL	Stock	7.2643	7.2768	7.2596	7.266	10935372.0
2009-11-12 14:30:00	AAPL	Stock	7.2654	7.2757	7.2332	7.2368	19668236.0
2009-11-12 15:00:00	AAPL	Stock	7.2368	7.2425	7.2036	7.2164	37483432.0
2009-11-12 15:30:00	AAPL	Stock	7.2164	7.2314	7.1939	7.2143	46960564.0
2009-11-12 16:00:00	AAPL	Stock	7.2143	7.2623	7.2043	7.2164	9671060.0
2009-11-12 16:30:00	AAPL	Stock	7.2186	7.3137	7.2146	7.2179	996912.0
2009-11-12 17:00:00	AAPL	Stock	7.2161	7.2161	7.2139	7.2139	107968.0
2009-11-12 17:30:00	AAPL	Stock	7.2146	7.2146	7.2039	7.2039	70980.0
2009-11-12 18:00:00	AAPL	Stock	7.2089	7.2589	7.2046	7.2046	5559316.0
2009-11-12 18:30:00	AAPL	Stock	7.2043	7.2139	7.2043	7.2139	49644.0
2009-11-12 19:00:00	AAPL	Stock	7.2171	7.2186	7.2161	7.2161	66500.0
2009-11-12 19:30:00	AAPL	Stock	7.2161	7.2161	7.2139	7.2139	46704.0
2009-11-12 07:00:00	MSFT	Stock	29.0	29.0	29.0	29.0	200.0
2009-11-12 08:00:00	MSFT	Stock	29.1	29.1	29.0	29.01	4356.0
2009-11-12 08:30:00	MSFT	Stock	29.11	29.12	29.08	29.08	1200.0
2009-11-12 09:00:00	MSFT	Stock	29.05	29.12	29.0	29.0	388873.0
2009-11-12 09:30:00	MSFT	Stock	29.0	29.49	29.0	29.47	7157107.0
2009-11-12 10:00:00	MSFT	Stock	29.46	29.49	29.34	29.37	5421414.0
2009-11-12 10:30:00	MSFT	Stock	29.36	29.4	29.31	29.33	2740792.0
2009-11-12 11:00:00	MSFT	Stock	29.32	29.38	29.3	29.37	3585643.0
2009-11-12 11:30:00	MSFT	Stock	29.37	29.45	29.32	29.387	2640286.0
2009-11-12 12:00:00	MSFT	Stock	29.39	29.4	29.34	29.37	1888896.0
2009-11-12 12:30:00	MSFT	Stock	29.37	29.4	29.33	29.35	2447077.0
2009-11-12 13:00:00	MSFT	Stock	29.36	29.37	29.32	29.36	3244635.0
2009-11-12 13:30:00	MSFT	Stock	29.351	29.4	29.33	29.37	1882048.0
2009-11-12 14:00:00	MSFT	Stock	29.37	29.39	29.34	29.35	1660850.0
2009-11-12 14:30:00	MSFT	Stock	29.35	29.39	29.35	29.39	2045513.0
2009-11-12 15:00:00	MSFT	Stock	29.39	29.4	29.35	29.36	5109381.0
2009-11-12 15:30:00	MSFT	Stock	29.37	29.42	29.34	29.37	10716831.0
2009-11-12 16:00:00	MSFT	Stock	29.37	29.5	29.33	29.49	2203623.0
2009-11-12 16:30:00	MSFT	Stock	29.49	29.514	29.342	29.48	376457.0
2009-11-12 17:00:00	MSFT	Stock	29.47	29.48	29.47	29.48	1700.0
2009-11-12 17:30:00	MSFT	Stock	29.47	29.5	29.42	29.45	33157.0
2009-11-12 18:00:00	MSFT	Stock	29.39	29.39	29.39	29.39	11525.0

> showing 50 of 71,260 rows — these rows as CSV

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