PREVIEW / stock_1hour / 2011-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-03.parquet
  size:    945 KB
  rows:    45,365
  symbols: 3,509

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-03 04:00:00	AAPL	Stock	13.9936	14.0714	13.9936	14.0714	359800.0
2011-11-03 05:00:00	AAPL	Stock	14.0857	14.17	14.0857	14.17	182840.0
2011-11-03 06:00:00	AAPL	Stock	14.1768	14.25	14.1768	14.2139	39200.0
2011-11-03 07:00:00	AAPL	Stock	14.2139	14.25	14.1796	14.235	410508.0
2011-11-03 08:00:00	AAPL	Stock	14.2268	14.3164	14.2182	14.3107	3644788.0
2011-11-03 09:00:00	AAPL	Stock	14.3111	14.3143	14.1346	14.1564	65030896.0
2011-11-03 10:00:00	AAPL	Stock	14.1618	14.2064	14.12	14.1721	72881648.0
2011-11-03 11:00:00	AAPL	Stock	14.1721	14.2782	14.1721	14.2425	52957464.0
2011-11-03 12:00:00	AAPL	Stock	14.2418	14.2904	14.2179	14.2671	45400432.0
2011-11-03 13:00:00	AAPL	Stock	14.2679	14.3546	14.25	14.3311	61858944.0
2011-11-03 14:00:00	AAPL	Stock	14.3339	14.3486	14.2932	14.3457	40208588.0
2011-11-03 15:00:00	AAPL	Stock	14.3448	14.4071	14.3443	14.3946	73175172.0
2011-11-03 16:00:00	AAPL	Stock	14.3946	14.3964	14.2029	14.3782	19638444.0
2011-11-03 17:00:00	AAPL	Stock	14.3768	14.3954	14.3736	14.3954	244720.0
2011-11-03 18:00:00	AAPL	Stock	14.3725	14.3954	14.3725	14.3896	115024.0
2011-11-03 19:00:00	AAPL	Stock	14.3889	14.3893	14.3821	14.3857	99428.0
2011-11-03 04:00:00	MSFT	Stock	25.85	25.85	25.68	25.68	6100.0
2011-11-03 06:00:00	MSFT	Stock	25.9	25.95	25.9	25.95	600.0
2011-11-03 07:00:00	MSFT	Stock	25.9	25.98	25.9	25.98	8700.0
2011-11-03 08:00:00	MSFT	Stock	25.98	26.18	25.98	26.17	65290.0
2011-11-03 09:00:00	MSFT	Stock	26.17	26.37	26.01	26.092	5480427.0
2011-11-03 10:00:00	MSFT	Stock	26.1	26.49	25.98	26.27	13329492.0
2011-11-03 11:00:00	MSFT	Stock	26.26	26.44	26.23	26.31	5886227.0
2011-11-03 12:00:00	MSFT	Stock	26.31	26.5	26.29	26.478	5249341.0
2011-11-03 13:00:00	MSFT	Stock	26.47	26.57	26.44	26.495	5485753.0
2011-11-03 14:00:00	MSFT	Stock	26.5	26.585	26.44	26.495	5307186.0
2011-11-03 15:00:00	MSFT	Stock	26.493	26.55	26.36	26.52	13597936.0
2011-11-03 16:00:00	MSFT	Stock	26.52	26.54	26.294	26.53	7784937.0
2011-11-03 17:00:00	MSFT	Stock	26.45	26.53	26.45	26.53	1622330.0
2011-11-03 18:00:00	MSFT	Stock	26.46	26.53	26.46	26.46	7200.0
2011-11-03 19:00:00	MSFT	Stock	26.49	26.5	26.46	26.46	400.0
2011-11-03 06:00:00	NVDA	Stock	0.3445	0.3445	0.3445	0.3445	8000.0
2011-11-03 07:00:00	NVDA	Stock	0.348	0.348	0.348	0.348	12000.0
2011-11-03 08:00:00	NVDA	Stock	0.348	0.3508	0.3458	0.3508	1860000.0
2011-11-03 09:00:00	NVDA	Stock	0.3518	0.3518	0.3428	0.345	53920120.0
2011-11-03 10:00:00	NVDA	Stock	0.345	0.3533	0.34	0.3493	121792560.0
2011-11-03 11:00:00	NVDA	Stock	0.3493	0.3558	0.349	0.3518	80235440.0
2011-11-03 12:00:00	NVDA	Stock	0.3516	0.3585	0.351	0.3572	65018920.0
2011-11-03 13:00:00	NVDA	Stock	0.3572	0.3618	0.3555	0.36	93314480.0
2011-11-03 14:00:00	NVDA	Stock	0.36	0.3618	0.359	0.3615	79155760.0
2011-11-03 15:00:00	NVDA	Stock	0.3615	0.367	0.3615	0.366	214169120.0
2011-11-03 16:00:00	NVDA	Stock	0.366	0.367	0.3454	0.3655	16537000.0
2011-11-03 17:00:00	NVDA	Stock	0.3655	0.3662	0.3652	0.3662	17158800.0
2011-11-03 18:00:00	NVDA	Stock	0.3662	0.3668	0.3655	0.3655	392080.0
2011-11-03 19:00:00	NVDA	Stock	0.3658	0.3658	0.3625	0.365	512000.0
2011-11-03 05:00:00	AMZN	Stock	10.7535	10.7535	10.7535	10.7535	2000.0
2011-11-03 06:00:00	AMZN	Stock	10.8	10.8	10.785	10.785	10000.0
2011-11-03 07:00:00	AMZN	Stock	10.8045	10.8425	10.775	10.8425	50000.0
2011-11-03 08:00:00	AMZN	Stock	10.8445	10.9125	10.799	10.9125	960020.0
2011-11-03 09:00:00	AMZN	Stock	10.9195	10.922	10.663	10.714	18732560.0

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

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