PREVIEW / stock_30min / 2011-01-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-14.parquet
  size:    1.4 MB
  rows:    76,880
  symbols: 3,524

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-01-14 05:00:00	AAPL	Stock	12.3929	12.3929	12.3875	12.3929	21000.0
2011-01-14 05:30:00	AAPL	Stock	12.3929	12.3929	12.3929	12.3929	26712.0
2011-01-14 06:00:00	AAPL	Stock	12.3964	12.3964	12.3929	12.3929	39200.0
2011-01-14 07:00:00	AAPL	Stock	12.3854	12.3854	12.3396	12.3571	248864.0
2011-01-14 07:30:00	AAPL	Stock	12.3568	12.3568	12.3218	12.3357	284620.0
2011-01-14 08:00:00	AAPL	Stock	12.3393	12.3421	12.3154	12.3286	750036.0
2011-01-14 08:30:00	AAPL	Stock	12.3214	12.3364	12.3154	12.3289	690676.0
2011-01-14 09:00:00	AAPL	Stock	12.3268	12.3589	12.325	12.3532	1312248.0
2011-01-14 09:30:00	AAPL	Stock	12.3532	12.3596	12.3014	12.3211	51424100.0
2011-01-14 10:00:00	AAPL	Stock	12.3207	12.3589	12.3207	12.35	37663724.0
2011-01-14 10:30:00	AAPL	Stock	12.35	12.3879	12.3393	12.3879	29693440.0
2011-01-14 11:00:00	AAPL	Stock	12.3879	12.4057	12.3786	12.3897	21700112.0
2011-01-14 11:30:00	AAPL	Stock	12.3903	12.3954	12.3793	12.3825	12940788.0
2011-01-14 12:00:00	AAPL	Stock	12.3821	12.4046	12.3796	12.395	12888064.0
2011-01-14 12:30:00	AAPL	Stock	12.395	12.4143	12.3936	12.4107	11062072.0
2011-01-14 13:00:00	AAPL	Stock	12.4118	12.4171	12.3979	12.4094	10409392.0
2011-01-14 13:30:00	AAPL	Stock	12.4107	12.4286	12.4093	12.4271	13944812.0
2011-01-14 14:00:00	AAPL	Stock	12.4271	12.4279	12.4118	12.4182	11520712.0
2011-01-14 14:30:00	AAPL	Stock	12.4193	12.42	12.4018	12.4042	13463296.0
2011-01-14 15:00:00	AAPL	Stock	12.4046	12.425	12.4042	12.4157	18505620.0
2011-01-14 15:30:00	AAPL	Stock	12.4168	12.4457	12.4132	12.445	45699416.0
2011-01-14 16:00:00	AAPL	Stock	12.4457	12.4464	12.3825	12.4464	11923772.0
2011-01-14 16:30:00	AAPL	Stock	12.4457	12.4461	12.4173	12.4421	587020.0
2011-01-14 17:00:00	AAPL	Stock	12.4396	12.4457	12.4393	12.4396	363524.0
2011-01-14 17:30:00	AAPL	Stock	12.44	12.4439	12.4371	12.4393	392308.0
2011-01-14 18:00:00	AAPL	Stock	12.44	12.4446	12.4368	12.4407	196980.0
2011-01-14 18:30:00	AAPL	Stock	12.4393	12.4411	12.4357	12.4371	195132.0
2011-01-14 19:00:00	AAPL	Stock	12.4361	12.4375	12.4357	12.4361	383432.0
2011-01-14 19:30:00	AAPL	Stock	12.4357	12.4461	12.4357	12.4429	179368.0
2011-01-14 07:00:00	MSFT	Stock	28.24	28.25	28.2	28.21	4300.0
2011-01-14 07:30:00	MSFT	Stock	28.21	28.21	28.19	28.2	4200.0
2011-01-14 08:00:00	MSFT	Stock	28.21	28.27	28.2	28.2	49400.0
2011-01-14 08:30:00	MSFT	Stock	28.2	28.2	28.19	28.19	17973.0
2011-01-14 09:00:00	MSFT	Stock	28.19	28.27	28.04	28.04	182029.0
2011-01-14 09:30:00	MSFT	Stock	28.07	28.11	27.91	28.0	10980241.0
2011-01-14 10:00:00	MSFT	Stock	28.0	28.14	27.99	28.071	6596553.0
2011-01-14 10:30:00	MSFT	Stock	28.07	28.15	28.07	28.09	4080998.0
2011-01-14 11:00:00	MSFT	Stock	28.088	28.13	28.07	28.1	5665947.0
2011-01-14 11:30:00	MSFT	Stock	28.091	28.12	28.07	28.12	3350537.0
2011-01-14 12:00:00	MSFT	Stock	28.11	28.23	28.11	28.14	3288528.0
2011-01-14 12:30:00	MSFT	Stock	28.14	28.19	28.07	28.18	3113668.0
2011-01-14 13:00:00	MSFT	Stock	28.181	28.25	28.165	28.222	2202987.0
2011-01-14 13:30:00	MSFT	Stock	28.22	28.26	28.21	28.25	2704393.0
2011-01-14 14:00:00	MSFT	Stock	28.258	28.3	28.24	28.26	3167432.0
2011-01-14 14:30:00	MSFT	Stock	28.26	28.38	28.25	28.325	2554258.0
2011-01-14 15:00:00	MSFT	Stock	28.32	28.358	28.22	28.235	3698677.0
2011-01-14 15:30:00	MSFT	Stock	28.23	28.3	28.2	28.3	5640808.0
2011-01-14 16:00:00	MSFT	Stock	28.3	28.32	28.13	28.21	2852365.0
2011-01-14 16:30:00	MSFT	Stock	28.24	28.25	28.227	28.25	7700.0
2011-01-14 17:00:00	MSFT	Stock	28.28	28.3	28.28	28.28	20897.0

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

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