PREVIEW / stock_1hour / 2011-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-03.parquet
  size:    957 KB
  rows:    45,650
  symbols: 3,528

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-03 04:00:00	AAPL	Stock	13.57	13.6186	13.5443	13.6179	45640.0
2011-10-03 05:00:00	AAPL	Stock	13.6179	13.6179	13.5743	13.5825	44800.0
2011-10-03 06:00:00	AAPL	Stock	13.6175	13.6746	13.6071	13.6746	89600.0
2011-10-03 07:00:00	AAPL	Stock	13.6643	13.7125	13.6429	13.7125	1071560.0
2011-10-03 08:00:00	AAPL	Stock	13.7107	13.7296	13.6136	13.6575	2758980.0
2011-10-03 09:00:00	AAPL	Stock	13.6518	13.6518	13.3896	13.4075	128381008.0
2011-10-03 10:00:00	AAPL	Stock	13.4082	13.6657	13.3929	13.4815	121151492.0
2011-10-03 11:00:00	AAPL	Stock	13.4807	13.6482	13.4525	13.5911	72150008.0
2011-10-03 12:00:00	AAPL	Stock	13.5911	13.6007	13.4564	13.475	44673104.0
2011-10-03 13:00:00	AAPL	Stock	13.475	13.4821	13.3921	13.4669	78581720.0
2011-10-03 14:00:00	AAPL	Stock	13.4611	13.4986	13.3275	13.3946	68273240.0
2011-10-03 15:00:00	AAPL	Stock	13.39	13.5471	13.3607	13.3693	117730452.0
2011-10-03 16:00:00	AAPL	Stock	13.3825	13.6121	13.3293	13.3714	24881304.0
2011-10-03 17:00:00	AAPL	Stock	13.3779	13.3839	13.3536	13.3786	424172.0
2011-10-03 18:00:00	AAPL	Stock	13.3818	13.3861	13.3593	13.3629	387688.0
2011-10-03 19:00:00	AAPL	Stock	13.3668	13.3668	13.3214	13.3571	562352.0
2011-10-03 04:00:00	MSFT	Stock	24.76	24.76	24.6	24.6	300.0
2011-10-03 06:00:00	MSFT	Stock	24.68	24.8	24.68	24.8	2350.0
2011-10-03 07:00:00	MSFT	Stock	24.8	24.8	24.7	24.78	18020.0
2011-10-03 08:00:00	MSFT	Stock	24.79	24.89	24.65	24.69	67436.0
2011-10-03 09:00:00	MSFT	Stock	24.7	25.0	24.62	24.68	5413269.0
2011-10-03 10:00:00	MSFT	Stock	24.69	25.335	24.64	24.98	11815118.0
2011-10-03 11:00:00	MSFT	Stock	24.97	25.14	24.9	25.09	6094491.0
2011-10-03 12:00:00	MSFT	Stock	25.09	25.12	24.8	24.838	4102792.0
2011-10-03 13:00:00	MSFT	Stock	24.84	24.88	24.68	24.79	7101440.0
2011-10-03 14:00:00	MSFT	Stock	24.785	24.87	24.62	24.69	7462945.0
2011-10-03 15:00:00	MSFT	Stock	24.69	24.85	24.52	24.53	15578963.0
2011-10-03 16:00:00	MSFT	Stock	24.53	25.12	24.42	24.5	5457989.0
2011-10-03 17:00:00	MSFT	Stock	24.5	24.53	24.43	24.53	39885.0
2011-10-03 18:00:00	MSFT	Stock	24.53	24.53	24.45	24.5	10289.0
2011-10-03 19:00:00	MSFT	Stock	24.5	24.5	24.46	24.48	4402.0
2011-10-03 07:00:00	NVDA	Stock	0.3062	0.3125	0.3062	0.312	44000.0
2011-10-03 08:00:00	NVDA	Stock	0.3125	0.3125	0.3078	0.308	627200.0
2011-10-03 09:00:00	NVDA	Stock	0.3083	0.317	0.3075	0.3108	86037560.0
2011-10-03 10:00:00	NVDA	Stock	0.3105	0.3185	0.309	0.311	218420240.0
2011-10-03 11:00:00	NVDA	Stock	0.3108	0.315	0.3093	0.3103	124089360.0
2011-10-03 12:00:00	NVDA	Stock	0.3104	0.3115	0.3049	0.3053	72159480.0
2011-10-03 13:00:00	NVDA	Stock	0.3055	0.306	0.299	0.3	103684240.0
2011-10-03 14:00:00	NVDA	Stock	0.2995	0.3035	0.2955	0.2972	144946280.0
2011-10-03 15:00:00	NVDA	Stock	0.2972	0.3	0.2952	0.2952	172013000.0
2011-10-03 16:00:00	NVDA	Stock	0.2955	0.3125	0.2938	0.295	25712000.0
2011-10-03 17:00:00	NVDA	Stock	0.2945	0.2945	0.2938	0.2938	84280.0
2011-10-03 18:00:00	NVDA	Stock	0.2945	0.2945	0.2928	0.2932	218880.0
2011-10-03 19:00:00	NVDA	Stock	0.293	0.2942	0.293	0.2942	160400.0
2011-10-03 04:00:00	AMZN	Stock	10.8345	10.8345	10.8345	10.8345	8000.0
2011-10-03 05:00:00	AMZN	Stock	10.8465	11.005	10.8465	10.9965	56000.0
2011-10-03 06:00:00	AMZN	Stock	10.965	10.965	10.9465	10.955	28000.0
2011-10-03 07:00:00	AMZN	Stock	10.955	10.955	10.927	10.935	58000.0
2011-10-03 08:00:00	AMZN	Stock	10.925	10.972	10.8115	10.834	830420.0
2011-10-03 09:00:00	AMZN	Stock	10.834	10.995	10.7535	10.81	18756240.0

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

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