PREVIEW / stock_1hour / 2011-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-22.parquet
  size:    907 KB
  rows:    43,384
  symbols: 3,513

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
2011-11-22 04:00:00	AAPL	Stock	13.2143	13.225	13.2071	13.2107	89600.0
2011-11-22 05:00:00	AAPL	Stock	13.2482	13.2482	13.2482	13.2482	2800.0
2011-11-22 06:00:00	AAPL	Stock	13.2925	13.2925	13.2786	13.2786	69916.0
2011-11-22 07:00:00	AAPL	Stock	13.2661	13.2857	13.2143	13.2482	500892.0
2011-11-22 08:00:00	AAPL	Stock	13.24	13.2582	13.17	13.2143	2217600.0
2011-11-22 09:00:00	AAPL	Stock	13.215	13.3836	13.2054	13.3439	64256472.0
2011-11-22 10:00:00	AAPL	Stock	13.3446	13.38	13.2775	13.2961	67253704.0
2011-11-22 11:00:00	AAPL	Stock	13.2957	13.3257	13.2614	13.3068	46065040.0
2011-11-22 12:00:00	AAPL	Stock	13.3071	13.4164	13.3068	13.4161	49317716.0
2011-11-22 13:00:00	AAPL	Stock	13.4162	13.4518	13.3832	13.4278	41950552.0
2011-11-22 14:00:00	AAPL	Stock	13.4263	13.4604	13.4218	13.4411	38771964.0
2011-11-22 15:00:00	AAPL	Stock	13.4411	13.4975	13.3946	13.4471	70566440.0
2011-11-22 16:00:00	AAPL	Stock	13.4518	13.4538	13.3238	13.4304	10451728.0
2011-11-22 17:00:00	AAPL	Stock	13.3474	13.4468	13.3474	13.4232	292208.0
2011-11-22 18:00:00	AAPL	Stock	13.4225	13.4354	13.4214	13.4286	117012.0
2011-11-22 19:00:00	AAPL	Stock	13.4318	13.4468	13.4114	13.4132	252336.0
2011-11-22 06:00:00	MSFT	Stock	25.17	25.17	25.07	25.07	1300.0
2011-11-22 07:00:00	MSFT	Stock	25.18	25.18	25.05	25.05	2300.0
2011-11-22 08:00:00	MSFT	Stock	25.05	25.05	24.87	24.95	37709.0
2011-11-22 09:00:00	MSFT	Stock	24.95	24.99	24.81	24.85	6580352.0
2011-11-22 10:00:00	MSFT	Stock	24.85	24.88	24.7	24.731	8318924.0
2011-11-22 11:00:00	MSFT	Stock	24.737	24.82	24.65	24.795	7708670.0
2011-11-22 12:00:00	MSFT	Stock	24.795	24.89	24.75	24.88	4857890.0
2011-11-22 13:00:00	MSFT	Stock	24.885	24.96	24.8	24.825	3663069.0
2011-11-22 14:00:00	MSFT	Stock	24.825	24.86	24.73	24.745	4553516.0
2011-11-22 15:00:00	MSFT	Stock	24.74	24.82	24.705	24.79	10970482.0
2011-11-22 16:00:00	MSFT	Stock	24.79	24.817	24.7	24.817	2111750.0
2011-11-22 17:00:00	MSFT	Stock	24.844	24.844	24.75	24.79	11121.0
2011-11-22 18:00:00	MSFT	Stock	24.75	24.76	24.74	24.76	2725.0
2011-11-22 19:00:00	MSFT	Stock	24.76	24.79	24.75	24.76	12168.0
2011-11-22 07:00:00	NVDA	Stock	0.3725	0.3783	0.3725	0.377	76000.0
2011-11-22 08:00:00	NVDA	Stock	0.375	0.3755	0.3625	0.3682	1467360.0
2011-11-22 09:00:00	NVDA	Stock	0.3688	0.379	0.3676	0.3775	209691280.0
2011-11-22 10:00:00	NVDA	Stock	0.3773	0.379	0.3692	0.3717	230238400.0
2011-11-22 11:00:00	NVDA	Stock	0.3717	0.3745	0.3698	0.3733	190303760.0
2011-11-22 12:00:00	NVDA	Stock	0.3733	0.3765	0.3715	0.374	121095800.0
2011-11-22 13:00:00	NVDA	Stock	0.374	0.3763	0.3718	0.3725	91610680.0
2011-11-22 14:00:00	NVDA	Stock	0.3723	0.3753	0.372	0.3748	181094480.0
2011-11-22 15:00:00	NVDA	Stock	0.3748	0.378	0.3738	0.3768	237812280.0
2011-11-22 16:00:00	NVDA	Stock	0.3768	0.3773	0.3742	0.3768	22472680.0
2011-11-22 17:00:00	NVDA	Stock	0.3772	0.3772	0.375	0.375	221600.0
2011-11-22 19:00:00	NVDA	Stock	0.3755	0.3763	0.375	0.376	175760.0
2011-11-22 05:00:00	AMZN	Stock	9.478	9.483	9.478	9.483	6000.0
2011-11-22 07:00:00	AMZN	Stock	9.43	9.45	9.4025	9.413	53400.0
2011-11-22 08:00:00	AMZN	Stock	9.4065	9.445	9.271	9.307	773040.0
2011-11-22 09:00:00	AMZN	Stock	9.3055	9.488	9.28	9.4435	20835860.0
2011-11-22 10:00:00	AMZN	Stock	9.4435	9.4675	9.2355	9.2488	30694340.0
2011-11-22 11:00:00	AMZN	Stock	9.256	9.3054	9.179	9.2865	24026140.0
2011-11-22 12:00:00	AMZN	Stock	9.2865	9.444	9.273	9.444	26057260.0
2011-11-22 13:00:00	AMZN	Stock	9.444	9.5165	9.4245	9.4955	27733600.0

> showing 50 of 43,384 rows — these rows as CSV

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