PREVIEW / stock_30min / 2012-04-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-23.parquet
  size:    1.5 MB
  rows:    79,324
  symbols: 3,525

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-23 04:00:00	AAPL	Stock	20.4643	20.4643	20.2857	20.3568	165060.0
2012-04-23 04:30:00	AAPL	Stock	20.3532	20.3532	20.3214	20.3214	14000.0
2012-04-23 05:00:00	AAPL	Stock	20.2904	20.2904	20.1861	20.1875	242592.0
2012-04-23 05:30:00	AAPL	Stock	20.1964	20.25	20.1821	20.25	94388.0
2012-04-23 06:00:00	AAPL	Stock	20.2675	20.2679	20.2411	20.2679	80668.0
2012-04-23 06:30:00	AAPL	Stock	20.2232	20.2639	20.2143	20.2639	78680.0
2012-04-23 07:00:00	AAPL	Stock	20.2639	20.3489	20.2536	20.3393	1082648.0
2012-04-23 07:30:00	AAPL	Stock	20.3271	20.3386	20.25	20.2857	692048.0
2012-04-23 08:00:00	AAPL	Stock	20.2939	20.3429	20.2686	20.3068	3073336.0
2012-04-23 08:30:00	AAPL	Stock	20.3068	20.4754	20.3068	20.4339	4232676.0
2012-04-23 09:00:00	AAPL	Stock	20.4321	20.4636	20.3571	20.3907	2845052.0
2012-04-23 09:30:00	AAPL	Stock	20.3789	20.5954	20.1861	20.4425	155125460.0
2012-04-23 10:00:00	AAPL	Stock	20.4425	20.4457	20.2039	20.3114	79644040.0
2012-04-23 10:30:00	AAPL	Stock	20.3111	20.3254	19.8793	20.0114	148637384.0
2012-04-23 11:00:00	AAPL	Stock	20.0107	20.2143	19.9682	20.1818	69440924.0
2012-04-23 11:30:00	AAPL	Stock	20.184	20.3214	20.1307	20.3212	54156984.0
2012-04-23 12:00:00	AAPL	Stock	20.3186	20.5425	20.2739	20.5239	81096988.0
2012-04-23 12:30:00	AAPL	Stock	20.525	20.5589	20.2861	20.3621	66710924.0
2012-04-23 13:00:00	AAPL	Stock	20.3621	20.446	20.3039	20.4445	35218792.0
2012-04-23 13:30:00	AAPL	Stock	20.4396	20.5668	20.4039	20.4714	50366848.0
2012-04-23 14:00:00	AAPL	Stock	20.4775	20.5161	20.3243	20.4446	37013676.0
2012-04-23 14:30:00	AAPL	Stock	20.4461	20.5146	20.3468	20.3498	38234672.0
2012-04-23 15:00:00	AAPL	Stock	20.3529	20.4782	20.3468	20.4418	36406328.0
2012-04-23 15:30:00	AAPL	Stock	20.4429	20.4982	20.3932	20.4286	58809912.0
2012-04-23 16:00:00	AAPL	Stock	20.4282	20.5536	20.302	20.4143	20754776.0
2012-04-23 16:30:00	AAPL	Stock	20.4161	20.5154	20.4161	20.45	2410296.0
2012-04-23 17:00:00	AAPL	Stock	20.45	20.4629	20.44	20.4454	388192.0
2012-04-23 17:30:00	AAPL	Stock	20.4482	20.4571	20.4179	20.4564	115332.0
2012-04-23 18:00:00	AAPL	Stock	20.4554	20.4554	20.4421	20.4464	119700.0
2012-04-23 18:30:00	AAPL	Stock	20.4464	20.4518	20.4325	20.4375	214872.0
2012-04-23 19:00:00	AAPL	Stock	20.4446	20.4482	20.43	20.43	231224.0
2012-04-23 19:30:00	AAPL	Stock	20.4371	20.4411	20.4304	20.4411	215376.0
2012-04-23 04:00:00	MSFT	Stock	32.38	32.38	32.28	32.28	800.0
2012-04-23 05:30:00	MSFT	Stock	32.2	32.2	32.2	32.2	450.0
2012-04-23 06:00:00	MSFT	Stock	32.25	32.25	32.25	32.25	100.0
2012-04-23 06:30:00	MSFT	Stock	32.2	32.2	32.16	32.16	2300.0
2012-04-23 07:00:00	MSFT	Stock	32.25	32.25	32.2	32.23	3250.0
2012-04-23 07:30:00	MSFT	Stock	32.22	32.25	32.2	32.2	3950.0
2012-04-23 08:00:00	MSFT	Stock	32.24	32.25	32.15	32.16	34329.0
2012-04-23 08:30:00	MSFT	Stock	32.17	32.21	32.15	32.21	6280.0
2012-04-23 09:00:00	MSFT	Stock	32.2	32.42	32.15	32.3	71572.0
2012-04-23 09:30:00	MSFT	Stock	32.3	32.5	32.17	32.18	10113703.0
2012-04-23 10:00:00	MSFT	Stock	32.18	32.29	32.1	32.17	6627847.0
2012-04-23 10:30:00	MSFT	Stock	32.17	32.24	32.08	32.1	4217435.0
2012-04-23 11:00:00	MSFT	Stock	32.1	32.2	32.03	32.13	2428900.0
2012-04-23 11:30:00	MSFT	Stock	32.13	32.15	32.085	32.107	3341902.0
2012-04-23 12:00:00	MSFT	Stock	32.1	32.26	32.09	32.1	5542934.0
2012-04-23 12:30:00	MSFT	Stock	32.1	32.16	32.1	32.128	2400516.0
2012-04-23 13:00:00	MSFT	Stock	32.12	32.15	32.1	32.14	1916787.0
2012-04-23 13:30:00	MSFT	Stock	32.14	32.19	32.115	32.18	2707982.0

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

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