PREVIEW / stock_1hour / 2013-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-04.parquet
  size:    948 KB
  rows:    44,554
  symbols: 3,460

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
2013-01-04 04:00:00	AAPL	Stock	19.3361	19.3714	19.3361	19.3714	11200.0
2013-01-04 05:00:00	AAPL	Stock	19.3821	19.3821	19.3821	19.3821	2800.0
2013-01-04 06:00:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	5600.0
2013-01-04 07:00:00	AAPL	Stock	19.3875	19.4371	19.3875	19.4071	260540.0
2013-01-04 08:00:00	AAPL	Stock	19.4071	19.4521	19.1764	19.2032	7912240.0
2013-01-04 09:00:00	AAPL	Stock	19.1946	19.2368	19.1143	19.1389	75393528.0
2013-01-04 10:00:00	AAPL	Stock	19.1414	19.1564	18.8146	18.82	163970380.0
2013-01-04 11:00:00	AAPL	Stock	18.8268	18.9214	18.7904	18.9029	70197736.0
2013-01-04 12:00:00	AAPL	Stock	18.9029	19.0168	18.8689	18.9214	64866844.0
2013-01-04 13:00:00	AAPL	Stock	18.9219	18.9786	18.84	18.8519	44641996.0
2013-01-04 14:00:00	AAPL	Stock	18.8518	18.9271	18.8286	18.9236	45535168.0
2013-01-04 15:00:00	AAPL	Stock	18.9204	18.9679	18.8021	18.8218	103394508.0
2013-01-04 16:00:00	AAPL	Stock	18.8186	19.1786	18.7675	18.7704	10278912.0
2013-01-04 17:00:00	AAPL	Stock	18.7707	18.7818	18.7625	18.7732	344372.0
2013-01-04 18:00:00	AAPL	Stock	18.7796	18.7814	18.7675	18.7764	324604.0
2013-01-04 19:00:00	AAPL	Stock	18.7679	18.7768	18.7518	18.7571	406336.0
2013-01-04 06:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	100.0
2013-01-04 07:00:00	MSFT	Stock	27.3	27.39	27.26	27.3	4103.0
2013-01-04 08:00:00	MSFT	Stock	27.3	27.32	27.22	27.26	36688.0
2013-01-04 09:00:00	MSFT	Stock	27.25	27.34	27.02	27.06	5009345.0
2013-01-04 10:00:00	MSFT	Stock	27.06	27.09	26.82	26.855	9919856.0
2013-01-04 11:00:00	MSFT	Stock	26.86	26.97	26.85	26.92	6318620.0
2013-01-04 12:00:00	MSFT	Stock	26.91	26.94	26.88	26.89	4318764.0
2013-01-04 13:00:00	MSFT	Stock	26.88	26.93	26.855	26.865	3962156.0
2013-01-04 14:00:00	MSFT	Stock	26.87	26.9	26.82	26.845	4685623.0
2013-01-04 15:00:00	MSFT	Stock	26.85	26.89	26.73	26.76	14262094.0
2013-01-04 16:00:00	MSFT	Stock	26.75	26.948	26.74	26.75	3166876.0
2013-01-04 17:00:00	MSFT	Stock	26.75	26.79	26.74	26.78	41672.0
2013-01-04 18:00:00	MSFT	Stock	26.77	26.79	26.76	26.78	12447.0
2013-01-04 19:00:00	MSFT	Stock	26.78	26.78	26.77	26.77	9495.0
2013-01-04 09:00:00	NVDA	Stock	0.317	0.3225	0.317	0.3205	32825760.0
2013-01-04 10:00:00	NVDA	Stock	0.3205	0.3225	0.319	0.3224	61733600.0
2013-01-04 11:00:00	NVDA	Stock	0.3224	0.326	0.3223	0.3255	88765000.0
2013-01-04 12:00:00	NVDA	Stock	0.3255	0.326	0.3238	0.3251	52841560.0
2013-01-04 13:00:00	NVDA	Stock	0.325	0.3283	0.325	0.3283	50972560.0
2013-01-04 14:00:00	NVDA	Stock	0.3283	0.3298	0.328	0.3295	74509240.0
2013-01-04 15:00:00	NVDA	Stock	0.3295	0.3298	0.3288	0.329	124340200.0
2013-01-04 16:00:00	NVDA	Stock	0.3291	0.3298	0.326	0.3288	18015320.0
2013-01-04 17:00:00	NVDA	Stock	0.33	0.3313	0.33	0.3313	116800.0
2013-01-04 18:00:00	NVDA	Stock	0.331	0.331	0.331	0.331	84000.0
2013-01-04 19:00:00	NVDA	Stock	0.3313	0.3313	0.331	0.3313	68000.0
2013-01-04 05:00:00	AMZN	Stock	12.9575	12.9575	12.9575	12.9575	2000.0
2013-01-04 08:00:00	AMZN	Stock	12.94	12.95	12.831	12.831	119800.0
2013-01-04 09:00:00	AMZN	Stock	12.8375	12.922	12.8325	12.9128	4691300.0
2013-01-04 10:00:00	AMZN	Stock	12.913	12.9585	12.871	12.909	8584460.0
2013-01-04 11:00:00	AMZN	Stock	12.9014	12.9745	12.891	12.966	4639160.0
2013-01-04 12:00:00	AMZN	Stock	12.9653	12.99	12.9295	12.9335	3239940.0
2013-01-04 13:00:00	AMZN	Stock	12.9365	12.9545	12.9115	12.9335	2811260.0
2013-01-04 14:00:00	AMZN	Stock	12.929	12.959	12.923	12.9575	2372200.0
2013-01-04 15:00:00	AMZN	Stock	12.9575	12.9735	12.937	12.9565	9051840.0

> showing 50 of 44,554 rows — these rows as CSV

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