PREVIEW / stock_1hour / 2013-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-22.parquet
  size:    965 KB
  rows:    45,294
  symbols: 3,479

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-04-22 04:00:00	AAPL	Stock	13.9639	13.9643	13.9625	13.9643	8400.0
2013-04-22 05:00:00	AAPL	Stock	13.9679	14.0143	13.9679	14.0143	39452.0
2013-04-22 06:00:00	AAPL	Stock	14.0186	14.0186	14.0054	14.0171	22400.0
2013-04-22 07:00:00	AAPL	Stock	14.0071	14.0121	13.8425	13.8932	655396.0
2013-04-22 08:00:00	AAPL	Stock	13.8932	14.0232	13.8571	13.9979	4170012.0
2013-04-22 09:00:00	AAPL	Stock	13.9986	14.2071	13.9741	14.1904	72498888.0
2013-04-22 10:00:00	AAPL	Stock	14.1861	14.1964	14.0478	14.1195	65387672.0
2013-04-22 11:00:00	AAPL	Stock	14.1168	14.2243	14.0886	14.1693	64088724.0
2013-04-22 12:00:00	AAPL	Stock	14.1714	14.1993	14.1339	14.1386	27971216.0
2013-04-22 13:00:00	AAPL	Stock	14.1371	14.1686	14.1	14.1593	26928272.0
2013-04-22 14:00:00	AAPL	Stock	14.1607	14.2993	14.1575	14.2911	55480516.0
2013-04-22 15:00:00	AAPL	Stock	14.2907	14.3643	14.2321	14.2386	76723584.0
2013-04-22 16:00:00	AAPL	Stock	14.2382	14.3052	14.0746	14.2429	10719632.0
2013-04-22 17:00:00	AAPL	Stock	14.2436	14.2857	14.2382	14.2757	1292900.0
2013-04-22 18:00:00	AAPL	Stock	14.2761	14.2768	14.2386	14.2604	280392.0
2013-04-22 19:00:00	AAPL	Stock	14.2607	14.2657	14.2361	14.2393	284088.0
2013-04-22 08:00:00	MSFT	Stock	29.5	29.86	29.5	29.82	11117.0
2013-04-22 09:00:00	MSFT	Stock	29.8	31.15	29.8	31.08	35830092.0
2013-04-22 10:00:00	MSFT	Stock	31.085	31.18	30.8	30.93	20561652.0
2013-04-22 11:00:00	MSFT	Stock	30.93	30.94	30.68	30.775	10363630.0
2013-04-22 12:00:00	MSFT	Stock	30.775	31.0	30.76	30.96	12880834.0
2013-04-22 13:00:00	MSFT	Stock	30.96	31.02	30.92	30.965	11368873.0
2013-04-22 14:00:00	MSFT	Stock	30.96	31.05	30.95	30.96	13595530.0
2013-04-22 15:00:00	MSFT	Stock	30.965	30.99	30.8	30.81	21592742.0
2013-04-22 16:00:00	MSFT	Stock	30.81	31.01	30.75	30.85	8062361.0
2013-04-22 17:00:00	MSFT	Stock	30.83	30.84	30.8	30.83	82948.0
2013-04-22 18:00:00	MSFT	Stock	30.81	30.81	30.8	30.8	3600.0
2013-04-22 19:00:00	MSFT	Stock	30.83	30.84	30.83	30.83	4589.0
2013-04-22 09:00:00	NVDA	Stock	0.3143	0.3168	0.313	0.3135	31460680.0
2013-04-22 10:00:00	NVDA	Stock	0.3133	0.3148	0.3115	0.3133	46380960.0
2013-04-22 11:00:00	NVDA	Stock	0.3135	0.3143	0.312	0.314	23003880.0
2013-04-22 12:00:00	NVDA	Stock	0.314	0.3155	0.314	0.3152	26526840.0
2013-04-22 13:00:00	NVDA	Stock	0.315	0.3163	0.3145	0.3154	30416720.0
2013-04-22 14:00:00	NVDA	Stock	0.3155	0.3175	0.3153	0.3163	24426840.0
2013-04-22 15:00:00	NVDA	Stock	0.3163	0.317	0.3148	0.3148	52331400.0
2013-04-22 16:00:00	NVDA	Stock	0.3148	0.3154	0.314	0.314	10552560.0
2013-04-22 07:00:00	AMZN	Stock	13.0325	13.0325	13.0325	13.0325	2000.0
2013-04-22 08:00:00	AMZN	Stock	13.028	13.0625	13.0065	13.007	55540.0
2013-04-22 09:00:00	AMZN	Stock	13.01	13.0655	12.9015	13.0405	8065320.0
2013-04-22 10:00:00	AMZN	Stock	13.0385	13.071	12.9315	13.0577	7054280.0
2013-04-22 11:00:00	AMZN	Stock	13.061	13.1215	13.01	13.1025	4108440.0
2013-04-22 12:00:00	AMZN	Stock	13.102	13.2	13.0965	13.1455	5307560.0
2013-04-22 13:00:00	AMZN	Stock	13.152	13.1545	13.075	13.08	3651160.0
2013-04-22 14:00:00	AMZN	Stock	13.0825	13.1985	13.081	13.1615	3389980.0
2013-04-22 15:00:00	AMZN	Stock	13.164	13.23	13.1582	13.1755	8031000.0
2013-04-22 16:00:00	AMZN	Stock	13.1775	13.2115	13.016	13.1655	966760.0
2013-04-22 17:00:00	AMZN	Stock	13.1775	13.1775	13.1775	13.1775	381140.0
2013-04-22 19:00:00	AMZN	Stock	13.195	13.195	13.195	13.195	5600.0
2013-04-22 04:00:00	META	Stock	25.78	25.78	25.75	25.75	2500.0
2013-04-22 05:00:00	META	Stock	25.85	25.85	25.85	25.85	800.0

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

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