PREVIEW / stock_1hour / 2012-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-31.parquet
  size:    981 KB
  rows:    46,151
  symbols: 3,523

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-12-31 06:00:00	AAPL	Stock	18.15	18.1732	18.15	18.1732	19600.0
2012-12-31 07:00:00	AAPL	Stock	18.15	18.175	18.0893	18.115	271376.0
2012-12-31 08:00:00	AAPL	Stock	18.1268	18.3146	18.0075	18.2864	4249700.0
2012-12-31 09:00:00	AAPL	Stock	18.2857	18.7286	18.1786	18.7118	97404188.0
2012-12-31 10:00:00	AAPL	Stock	18.7118	18.8293	18.6304	18.7554	107344300.0
2012-12-31 11:00:00	AAPL	Stock	18.7571	18.8	18.6468	18.755	61441436.0
2012-12-31 12:00:00	AAPL	Stock	18.7589	18.8768	18.6386	18.7918	75888680.0
2012-12-31 13:00:00	AAPL	Stock	18.7925	18.9107	18.7264	18.7686	68417440.0
2012-12-31 14:00:00	AAPL	Stock	18.7714	19.1179	18.7679	19.0795	87460436.0
2012-12-31 15:00:00	AAPL	Stock	19.0739	19.1214	18.9543	19.035	114583700.0
2012-12-31 16:00:00	AAPL	Stock	19.0311	19.0578	18.7955	19.0143	23084040.0
2012-12-31 17:00:00	AAPL	Stock	19.0089	19.0368	19.0089	19.03	673960.0
2012-12-31 18:00:00	AAPL	Stock	19.0336	19.0368	19.0129	19.0196	413336.0
2012-12-31 19:00:00	AAPL	Stock	19.0143	19.0357	19.01	19.0143	493276.0
2012-12-31 07:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	4950.0
2012-12-31 08:00:00	MSFT	Stock	26.5	26.72	26.42	26.64	21835.0
2012-12-31 09:00:00	MSFT	Stock	26.65	26.67	26.5	26.583	3639883.0
2012-12-31 10:00:00	MSFT	Stock	26.584	26.6	26.4	26.42	5638500.0
2012-12-31 11:00:00	MSFT	Stock	26.416	26.49	26.37	26.43	4298614.0
2012-12-31 12:00:00	MSFT	Stock	26.43	26.68	26.42	26.53	4774510.0
2012-12-31 13:00:00	MSFT	Stock	26.54	26.65	26.46	26.533	4853929.0
2012-12-31 14:00:00	MSFT	Stock	26.535	26.73	26.52	26.71	4997947.0
2012-12-31 15:00:00	MSFT	Stock	26.715	26.77	26.55	26.72	10442603.0
2012-12-31 16:00:00	MSFT	Stock	26.72	26.79	26.219	26.77	3583854.0
2012-12-31 17:00:00	MSFT	Stock	26.75	26.78	26.67	26.72	49037.0
2012-12-31 18:00:00	MSFT	Stock	26.75	26.75	26.71	26.72	5488.0
2012-12-31 19:00:00	MSFT	Stock	26.71	26.77	26.7	26.77	7157.0
2012-12-31 07:00:00	NVDA	Stock	0.3008	0.3008	0.3005	0.3005	20000.0
2012-12-31 08:00:00	NVDA	Stock	0.3005	0.3025	0.3005	0.3025	68000.0
2012-12-31 09:00:00	NVDA	Stock	0.3018	0.3044	0.3008	0.3038	52289280.0
2012-12-31 10:00:00	NVDA	Stock	0.3038	0.304	0.3009	0.3012	35832160.0
2012-12-31 11:00:00	NVDA	Stock	0.3012	0.3025	0.301	0.3015	34636120.0
2012-12-31 12:00:00	NVDA	Stock	0.3015	0.3038	0.3008	0.3032	44098960.0
2012-12-31 13:00:00	NVDA	Stock	0.3032	0.3048	0.302	0.3036	42536400.0
2012-12-31 14:00:00	NVDA	Stock	0.3035	0.3073	0.3032	0.3068	31170360.0
2012-12-31 15:00:00	NVDA	Stock	0.3068	0.3078	0.3061	0.3075	67827280.0
2012-12-31 16:00:00	NVDA	Stock	0.3073	0.3075	0.3025	0.3064	4258240.0
2012-12-31 17:00:00	NVDA	Stock	0.3062	0.3073	0.3062	0.3065	55840.0
2012-12-31 18:00:00	NVDA	Stock	0.3065	0.3075	0.3065	0.3075	148800.0
2012-12-31 19:00:00	NVDA	Stock	0.3075	0.3075	0.3075	0.3075	100000.0
2012-12-31 06:00:00	AMZN	Stock	12.116	12.116	12.0985	12.1	82000.0
2012-12-31 07:00:00	AMZN	Stock	12.086	12.086	11.95	12.05	84700.0
2012-12-31 08:00:00	AMZN	Stock	12.1875	12.2125	12.051	12.1745	524700.0
2012-12-31 09:00:00	AMZN	Stock	12.173	12.3335	12.1375	12.3295	10303140.0
2012-12-31 10:00:00	AMZN	Stock	12.322	12.4591	12.2725	12.3805	17183420.0
2012-12-31 11:00:00	AMZN	Stock	12.3735	12.427	12.357	12.3825	4173200.0
2012-12-31 12:00:00	AMZN	Stock	12.38	12.51	12.3625	12.4635	5814520.0
2012-12-31 13:00:00	AMZN	Stock	12.457	12.52	12.403	12.4285	6288800.0
2012-12-31 14:00:00	AMZN	Stock	12.4267	12.6175	12.416	12.6042	6492000.0
2012-12-31 15:00:00	AMZN	Stock	12.6085	12.6205	12.5025	12.5635	12850040.0

> showing 50 of 46,151 rows — these rows as CSV

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