PREVIEW / stock_1hour / 2012-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-24.parquet
  size:    946 KB
  rows:    45,112
  symbols: 3,553

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-24 04:00:00	AAPL	Stock	20.4896	20.6607	20.4896	20.6607	67200.0
2012-04-24 05:00:00	AAPL	Stock	20.6293	20.7143	20.6293	20.6821	111244.0
2012-04-24 06:00:00	AAPL	Stock	20.7139	20.7139	20.6071	20.6429	155652.0
2012-04-24 07:00:00	AAPL	Stock	20.625	20.6429	20.1189	20.1443	5943672.0
2012-04-24 08:00:00	AAPL	Stock	20.15	20.3214	19.9386	19.9457	14998032.0
2012-04-24 09:00:00	AAPL	Stock	19.9429	20.25	19.9107	20.1043	158297048.0
2012-04-24 10:00:00	AAPL	Stock	20.0982	20.2746	20.0357	20.052	114949324.0
2012-04-24 11:00:00	AAPL	Stock	20.0532	20.1029	19.9464	20.0357	100565192.0
2012-04-24 12:00:00	AAPL	Stock	20.0357	20.0707	19.9286	19.9421	66468808.0
2012-04-24 13:00:00	AAPL	Stock	19.9404	19.9779	19.8257	19.8304	100821196.0
2012-04-24 14:00:00	AAPL	Stock	19.8297	20.1339	19.8214	20.1239	140143780.0
2012-04-24 15:00:00	AAPL	Stock	20.1239	20.1421	19.9404	20.0139	161163856.0
2012-04-24 16:00:00	AAPL	Stock	20.0104	21.5793	19.8286	21.5121	143224788.0
2012-04-24 17:00:00	AAPL	Stock	21.5121	21.5179	21.2732	21.4436	32186196.0
2012-04-24 18:00:00	AAPL	Stock	21.44	21.5343	21.4286	21.4411	7686756.0
2012-04-24 19:00:00	AAPL	Stock	21.4446	21.5857	21.4386	21.5646	5409908.0
2012-04-24 08:00:00	MSFT	Stock	32.1	32.17	32.05	32.05	22084.0
2012-04-24 09:00:00	MSFT	Stock	32.07	32.22	32.0	32.03	5010983.0
2012-04-24 10:00:00	MSFT	Stock	32.02	32.16	32.0	32.06	6214123.0
2012-04-24 11:00:00	MSFT	Stock	32.05	32.1	32.0	32.042	5368801.0
2012-04-24 12:00:00	MSFT	Stock	32.05	32.06	31.92	31.94	4194900.0
2012-04-24 13:00:00	MSFT	Stock	31.942	31.97	31.89	31.91	3340393.0
2012-04-24 14:00:00	MSFT	Stock	31.9	31.93	31.85	31.9	4813209.0
2012-04-24 15:00:00	MSFT	Stock	31.905	31.94	31.83	31.922	8693741.0
2012-04-24 16:00:00	MSFT	Stock	31.92	32.08	31.892	32.0	2491941.0
2012-04-24 17:00:00	MSFT	Stock	32.0	32.04	31.92	32.0	124289.0
2012-04-24 18:00:00	MSFT	Stock	31.99	31.99	31.95	31.95	17800.0
2012-04-24 19:00:00	MSFT	Stock	31.95	31.97	31.92	31.96	52540.0
2012-04-24 08:00:00	NVDA	Stock	0.3335	0.334	0.3335	0.334	84000.0
2012-04-24 09:00:00	NVDA	Stock	0.3313	0.3345	0.3245	0.325	134295880.0
2012-04-24 10:00:00	NVDA	Stock	0.3248	0.3283	0.3238	0.327	63668880.0
2012-04-24 11:00:00	NVDA	Stock	0.3268	0.3288	0.3248	0.3257	92891560.0
2012-04-24 12:00:00	NVDA	Stock	0.3258	0.3263	0.3215	0.3218	85172720.0
2012-04-24 13:00:00	NVDA	Stock	0.3218	0.3233	0.32	0.3218	97400000.0
2012-04-24 14:00:00	NVDA	Stock	0.3218	0.3223	0.32	0.3213	62614520.0
2012-04-24 15:00:00	NVDA	Stock	0.3211	0.3213	0.3188	0.3205	152126760.0
2012-04-24 16:00:00	NVDA	Stock	0.3205	0.3308	0.32	0.323	39661600.0
2012-04-24 17:00:00	NVDA	Stock	0.3235	0.3248	0.323	0.3245	808160.0
2012-04-24 18:00:00	NVDA	Stock	0.3235	0.3238	0.323	0.3238	112000.0
2012-04-24 19:00:00	NVDA	Stock	0.3238	0.3263	0.3238	0.325	372000.0
2012-04-24 07:00:00	AMZN	Stock	9.4435	9.449	9.4435	9.4485	12000.0
2012-04-24 08:00:00	AMZN	Stock	9.45	9.4535	9.421	9.421	153780.0
2012-04-24 09:00:00	AMZN	Stock	9.425	9.4745	9.3255	9.4575	9223380.0
2012-04-24 10:00:00	AMZN	Stock	9.449	9.5315	9.4461	9.507	14975520.0
2012-04-24 11:00:00	AMZN	Stock	9.5095	9.535	9.4645	9.4945	7839060.0
2012-04-24 12:00:00	AMZN	Stock	9.497	9.5025	9.415	9.4235	5030200.0
2012-04-24 13:00:00	AMZN	Stock	9.4235	9.4735	9.4235	9.4627	8345440.0
2012-04-24 14:00:00	AMZN	Stock	9.4625	9.4886	9.4505	9.47	4838680.0
2012-04-24 15:00:00	AMZN	Stock	9.4695	9.52	9.454	9.5165	12858780.0
2012-04-24 16:00:00	AMZN	Stock	9.5165	9.6025	9.4713	9.6	3364240.0

> showing 50 of 45,112 rows — these rows as CSV

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