PREVIEW / stock_1hour / 2011-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-25.parquet
  size:    924 KB
  rows:    44,143
  symbols: 3,476

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-10-25 04:00:00	AAPL	Stock	14.5282	14.5282	14.5146	14.5146	14000.0
2011-10-25 05:00:00	AAPL	Stock	14.5286	14.5386	14.5286	14.5386	5600.0
2011-10-25 06:00:00	AAPL	Stock	14.5429	14.5446	14.5429	14.5429	8400.0
2011-10-25 07:00:00	AAPL	Stock	14.5321	14.5593	14.5096	14.5179	311836.0
2011-10-25 08:00:00	AAPL	Stock	14.52	14.5696	14.4379	14.45	2138416.0
2011-10-25 09:00:00	AAPL	Stock	14.4536	14.5196	14.2807	14.3486	97438880.0
2011-10-25 10:00:00	AAPL	Stock	14.3579	14.4132	14.3104	14.3757	73094308.0
2011-10-25 11:00:00	AAPL	Stock	14.3736	14.3954	14.29	14.299	42959252.0
2011-10-25 12:00:00	AAPL	Stock	14.2989	14.3496	14.2821	14.3036	33552148.0
2011-10-25 13:00:00	AAPL	Stock	14.305	14.345	14.2896	14.3036	25508000.0
2011-10-25 14:00:00	AAPL	Stock	14.3054	14.3082	14.2096	14.2786	67974396.0
2011-10-25 15:00:00	AAPL	Stock	14.2786	14.2875	14.1921	14.2093	69881952.0
2011-10-25 16:00:00	AAPL	Stock	14.2146	14.3257	14.1343	14.1771	10661392.0
2011-10-25 17:00:00	AAPL	Stock	14.4918	14.4918	14.1657	14.1839	955108.0
2011-10-25 18:00:00	AAPL	Stock	14.1789	14.2061	14.1464	14.1607	371308.0
2011-10-25 19:00:00	AAPL	Stock	14.1643	14.1875	14.1521	14.1657	135408.0
2011-10-25 05:00:00	MSFT	Stock	27.23	27.23	27.23	27.23	600.0
2011-10-25 06:00:00	MSFT	Stock	27.18	27.18	27.15	27.15	300.0
2011-10-25 07:00:00	MSFT	Stock	27.16	27.17	27.16	27.17	1250.0
2011-10-25 08:00:00	MSFT	Stock	27.17	27.22	27.07	27.13	9469.0
2011-10-25 09:00:00	MSFT	Stock	27.13	27.23	27.04	27.13	6679726.0
2011-10-25 10:00:00	MSFT	Stock	27.13	27.15	26.96	27.04	8191315.0
2011-10-25 11:00:00	MSFT	Stock	27.035	27.1	26.99	27.013	5618654.0
2011-10-25 12:00:00	MSFT	Stock	27.01	27.12	26.99	27.02	4433508.0
2011-10-25 13:00:00	MSFT	Stock	27.011	27.11	27.01	27.065	4241588.0
2011-10-25 14:00:00	MSFT	Stock	27.06	27.06	26.88	26.99	5956288.0
2011-10-25 15:00:00	MSFT	Stock	26.99	27.05	26.72	26.82	13144047.0
2011-10-25 16:00:00	MSFT	Stock	26.79	27.326	26.77	26.85	3610427.0
2011-10-25 17:00:00	MSFT	Stock	27.19	27.19	26.83	26.85	4600.0
2011-10-25 18:00:00	MSFT	Stock	26.82	26.87	26.81	26.87	22476.0
2011-10-25 19:00:00	MSFT	Stock	26.83	26.83	26.81	26.81	13658.0
2011-10-25 08:00:00	NVDA	Stock	0.3725	0.3725	0.3713	0.3715	85600.0
2011-10-25 09:00:00	NVDA	Stock	0.3715	0.3715	0.3625	0.3662	95154640.0
2011-10-25 10:00:00	NVDA	Stock	0.3665	0.3733	0.3647	0.3703	113072440.0
2011-10-25 11:00:00	NVDA	Stock	0.3703	0.3708	0.3638	0.366	69232800.0
2011-10-25 12:00:00	NVDA	Stock	0.3658	0.3695	0.3652	0.367	52659320.0
2011-10-25 13:00:00	NVDA	Stock	0.3669	0.3692	0.3662	0.3665	32851960.0
2011-10-25 14:00:00	NVDA	Stock	0.3666	0.3668	0.3625	0.365	63727360.0
2011-10-25 15:00:00	NVDA	Stock	0.365	0.3662	0.3605	0.3615	114303560.0
2011-10-25 16:00:00	NVDA	Stock	0.3615	0.3659	0.3545	0.36	19277080.0
2011-10-25 17:00:00	NVDA	Stock	0.3755	0.3755	0.3568	0.3595	518000.0
2011-10-25 18:00:00	NVDA	Stock	0.3582	0.3598	0.3582	0.3598	226000.0
2011-10-25 19:00:00	NVDA	Stock	0.3588	0.3592	0.3588	0.359	40000.0
2011-10-25 07:00:00	AMZN	Stock	11.8625	11.9125	11.8625	11.9125	61140.0
2011-10-25 08:00:00	AMZN	Stock	11.9	11.9485	11.8435	11.8505	534900.0
2011-10-25 09:00:00	AMZN	Stock	11.85	11.9505	11.534	11.651	26344260.0
2011-10-25 10:00:00	AMZN	Stock	11.6475	11.717	11.505	11.576	25215680.0
2011-10-25 11:00:00	AMZN	Stock	11.5715	11.5995	11.4505	11.4635	14513520.0
2011-10-25 12:00:00	AMZN	Stock	11.4633	11.5925	11.43	11.573	19327600.0
2011-10-25 13:00:00	AMZN	Stock	11.5736	11.642	11.439	11.4693	19706720.0

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

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