PREVIEW / stock_1hour / 2012-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-26.parquet
  size:    964 KB
  rows:    45,640
  symbols: 3,556

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-03-26 04:00:00	AAPL	Stock	21.3571	21.3571	21.3514	21.3514	11200.0
2012-03-26 05:00:00	AAPL	Stock	21.3071	21.3214	21.3071	21.3214	26712.0
2012-03-26 06:00:00	AAPL	Stock	21.3446	21.3625	21.3446	21.3611	392336.0
2012-03-26 07:00:00	AAPL	Stock	21.3611	21.4107	21.3493	21.3821	628292.0
2012-03-26 08:00:00	AAPL	Stock	21.3832	21.4721	21.345	21.4254	4696328.0
2012-03-26 09:00:00	AAPL	Stock	21.4282	21.4286	21.3239	21.3789	78931944.0
2012-03-26 10:00:00	AAPL	Stock	21.3721	21.38	21.2593	21.3246	82035940.0
2012-03-26 11:00:00	AAPL	Stock	21.3264	21.3571	21.3036	21.3233	39054568.0
2012-03-26 12:00:00	AAPL	Stock	21.3214	21.3564	21.3036	21.3268	25943064.0
2012-03-26 13:00:00	AAPL	Stock	21.3268	21.5275	21.3146	21.5054	73459484.0
2012-03-26 14:00:00	AAPL	Stock	21.505	21.6686	21.5032	21.6343	129740576.0
2012-03-26 15:00:00	AAPL	Stock	21.6332	21.6839	21.6111	21.6743	128010820.0
2012-03-26 16:00:00	AAPL	Stock	21.6746	21.6857	21.2789	21.6454	28649796.0
2012-03-26 17:00:00	AAPL	Stock	21.346	21.6782	21.346	21.6686	591360.0
2012-03-26 18:00:00	AAPL	Stock	21.6714	21.6821	21.6679	21.6779	386064.0
2012-03-26 19:00:00	AAPL	Stock	21.6796	21.6796	21.6518	21.6607	354452.0
2012-03-26 06:00:00	MSFT	Stock	31.95	31.95	31.95	31.95	185.0
2012-03-26 08:00:00	MSFT	Stock	32.11	32.25	32.06	32.12	36340.0
2012-03-26 09:00:00	MSFT	Stock	32.17	32.4	32.13	32.37	4378891.0
2012-03-26 10:00:00	MSFT	Stock	32.36	32.52	32.355	32.41	5743457.0
2012-03-26 11:00:00	MSFT	Stock	32.405	32.5	32.39	32.475	3463071.0
2012-03-26 12:00:00	MSFT	Stock	32.475	32.52	32.44	32.51	3497269.0
2012-03-26 13:00:00	MSFT	Stock	32.505	32.57	32.5	32.514	2814292.0
2012-03-26 14:00:00	MSFT	Stock	32.51	32.58	32.45	32.505	4350773.0
2012-03-26 15:00:00	MSFT	Stock	32.505	32.61	32.46	32.59	9311565.0
2012-03-26 16:00:00	MSFT	Stock	32.58	32.65	31.97	32.59	2672250.0
2012-03-26 17:00:00	MSFT	Stock	32.59	32.66	32.59	32.61	22805.0
2012-03-26 18:00:00	MSFT	Stock	32.61	32.66	32.6	32.66	9784.0
2012-03-26 19:00:00	MSFT	Stock	32.61	32.66	32.61	32.66	7210.0
2012-03-26 08:00:00	NVDA	Stock	0.365	0.3675	0.365	0.3675	233600.0
2012-03-26 09:00:00	NVDA	Stock	0.367	0.3672	0.3642	0.3655	25559960.0
2012-03-26 10:00:00	NVDA	Stock	0.3652	0.3682	0.3638	0.3681	59700000.0
2012-03-26 11:00:00	NVDA	Stock	0.3682	0.3695	0.3678	0.3692	50150040.0
2012-03-26 12:00:00	NVDA	Stock	0.3692	0.3698	0.368	0.3684	35640120.0
2012-03-26 13:00:00	NVDA	Stock	0.3682	0.3685	0.3678	0.3679	15176400.0
2012-03-26 14:00:00	NVDA	Stock	0.3678	0.3692	0.3678	0.368	22989720.0
2012-03-26 15:00:00	NVDA	Stock	0.3682	0.3687	0.3672	0.368	62871000.0
2012-03-26 16:00:00	NVDA	Stock	0.368	0.3692	0.3655	0.368	15009040.0
2012-03-26 17:00:00	NVDA	Stock	0.3675	0.3682	0.3675	0.3682	112000.0
2012-03-26 18:00:00	NVDA	Stock	0.3682	0.3682	0.3675	0.3682	416040.0
2012-03-26 19:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	20000.0
2012-03-26 07:00:00	AMZN	Stock	9.795	9.795	9.7785	9.7785	10000.0
2012-03-26 08:00:00	AMZN	Stock	9.78	9.8075	9.78	9.8	261700.0
2012-03-26 09:00:00	AMZN	Stock	9.7875	9.925	9.775	9.92	18837900.0
2012-03-26 10:00:00	AMZN	Stock	9.917	9.9975	9.9	9.9825	32989640.0
2012-03-26 11:00:00	AMZN	Stock	9.981	9.988	9.933	9.961	13796900.0
2012-03-26 12:00:00	AMZN	Stock	9.961	9.9955	9.931	9.9855	12665520.0
2012-03-26 13:00:00	AMZN	Stock	9.986	10.0835	9.9775	10.077	19452680.0
2012-03-26 14:00:00	AMZN	Stock	10.079	10.1345	10.07	10.092	20220180.0
2012-03-26 15:00:00	AMZN	Stock	10.0901	10.1485	10.0765	10.144	28063720.0

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

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