PREVIEW / stock_30min / 2011-03-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-15.parquet
  size:    1.5 MB
  rows:    79,450
  symbols: 3,529

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
2011-03-15 04:00:00	AAPL	Stock	12.4607	12.4607	12.3161	12.3286	36400.0
2011-03-15 04:30:00	AAPL	Stock	12.3425	12.3518	12.3225	12.325	40992.0
2011-03-15 05:00:00	AAPL	Stock	12.3218	12.3218	12.1446	12.1643	160300.0
2011-03-15 05:30:00	AAPL	Stock	12.1071	12.1707	12.1071	12.1261	253820.0
2011-03-15 06:00:00	AAPL	Stock	12.1261	12.2036	12.1261	12.1796	728672.0
2011-03-15 06:30:00	AAPL	Stock	12.1796	12.2821	12.1796	12.2411	254744.0
2011-03-15 07:00:00	AAPL	Stock	12.2411	12.3571	12.2411	12.2554	1293152.0
2011-03-15 07:30:00	AAPL	Stock	12.2657	12.2932	12.2236	12.2589	1678796.0
2011-03-15 08:00:00	AAPL	Stock	12.2607	12.3561	12.2571	12.3357	4429880.0
2011-03-15 08:30:00	AAPL	Stock	12.3357	12.3375	12.2154	12.2682	4532472.0
2011-03-15 09:00:00	AAPL	Stock	12.2686	12.3243	12.2179	12.2189	4775148.0
2011-03-15 09:30:00	AAPL	Stock	12.2179	12.2832	12.1464	12.1936	175731444.0
2011-03-15 10:00:00	AAPL	Stock	12.1925	12.3036	12.1786	12.3024	75536384.0
2011-03-15 10:30:00	AAPL	Stock	12.3015	12.3496	12.2682	12.3324	73738112.0
2011-03-15 11:00:00	AAPL	Stock	12.3336	12.3379	12.2979	12.3293	41367620.0
2011-03-15 11:30:00	AAPL	Stock	12.33	12.3554	12.3146	12.3279	30771104.0
2011-03-15 12:00:00	AAPL	Stock	12.33	12.4225	12.3254	12.4189	44536156.0
2011-03-15 12:30:00	AAPL	Stock	12.4196	12.4229	12.3236	12.3721	37609264.0
2011-03-15 13:00:00	AAPL	Stock	12.3739	12.3786	12.3446	12.3497	19869640.0
2011-03-15 13:30:00	AAPL	Stock	12.3482	12.3661	12.345	12.3534	20486872.0
2011-03-15 14:00:00	AAPL	Stock	12.3532	12.39	12.3261	12.3875	36678600.0
2011-03-15 14:30:00	AAPL	Stock	12.3861	12.4032	12.3489	12.3686	32917612.0
2011-03-15 15:00:00	AAPL	Stock	12.37	12.4179	12.3614	12.4014	31491292.0
2011-03-15 15:30:00	AAPL	Stock	12.4001	12.4136	12.33	12.3368	57701700.0
2011-03-15 16:00:00	AAPL	Stock	12.3368	12.338	12.303	12.3261	11686640.0
2011-03-15 16:30:00	AAPL	Stock	12.3611	12.3611	12.3086	12.3179	3697428.0
2011-03-15 17:00:00	AAPL	Stock	12.402	12.402	12.3039	12.3154	857192.0
2011-03-15 17:30:00	AAPL	Stock	12.3107	12.32	12.3107	12.315	278936.0
2011-03-15 18:00:00	AAPL	Stock	12.315	12.3368	12.2929	12.2957	502376.0
2011-03-15 18:30:00	AAPL	Stock	12.2929	12.2989	12.27	12.2857	645344.0
2011-03-15 19:00:00	AAPL	Stock	12.2861	12.3894	12.2714	12.3894	206388.0
2011-03-15 19:30:00	AAPL	Stock	12.3	12.3211	12.2836	12.3211	458416.0
2011-03-15 04:00:00	MSFT	Stock	25.41	25.41	25.0	25.03	6090.0
2011-03-15 04:30:00	MSFT	Stock	25.1	25.1	25.1	25.1	200.0
2011-03-15 05:00:00	MSFT	Stock	25.04	25.04	24.89	24.9	1640.0
2011-03-15 05:30:00	MSFT	Stock	24.87	24.88	24.6	24.65	6500.0
2011-03-15 06:00:00	MSFT	Stock	24.81	24.81	24.65	24.78	9100.0
2011-03-15 06:30:00	MSFT	Stock	24.83	24.88	24.66	24.88	4485.0
2011-03-15 07:00:00	MSFT	Stock	24.91	25.09	24.91	25.05	22400.0
2011-03-15 07:30:00	MSFT	Stock	25.06	25.1	25.05	25.1	16700.0
2011-03-15 08:00:00	MSFT	Stock	25.1	25.2	25.1	25.1	65338.0
2011-03-15 08:30:00	MSFT	Stock	25.1	25.1	24.97	24.97	175998.0
2011-03-15 09:00:00	MSFT	Stock	24.97	25.16	24.96	25.09	364306.0
2011-03-15 09:30:00	MSFT	Stock	25.1	25.41	25.0	25.14	13657644.0
2011-03-15 10:00:00	MSFT	Stock	25.139	25.4	25.09	25.388	8480461.0
2011-03-15 10:30:00	MSFT	Stock	25.38	25.417	25.29	25.405	6328064.0
2011-03-15 11:00:00	MSFT	Stock	25.4	25.405	25.26	25.27	6315935.0
2011-03-15 11:30:00	MSFT	Stock	25.28	25.29	25.24	25.25	3598723.0
2011-03-15 12:00:00	MSFT	Stock	25.25	25.43	25.23	25.39	3848416.0
2011-03-15 12:30:00	MSFT	Stock	25.39	25.4	25.25	25.285	2224900.0

> showing 50 of 79,450 rows — these rows as CSV

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