PREVIEW / stock_1hour / 2013-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-20.parquet
  size:    1.0 MB
  rows:    48,527
  symbols: 3,511

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-06-20 04:00:00	AAPL	Stock	15.0875	15.0875	14.9986	14.9986	54404.0
2013-06-20 05:00:00	AAPL	Stock	15.0036	15.02	15.0036	15.0036	89208.0
2013-06-20 06:00:00	AAPL	Stock	15.0036	15.0036	14.9732	15.0	70000.0
2013-06-20 07:00:00	AAPL	Stock	14.9879	15.0125	14.9754	14.9971	953960.0
2013-06-20 08:00:00	AAPL	Stock	14.9996	15.0714	14.9821	15.0136	2461480.0
2013-06-20 09:00:00	AAPL	Stock	15.02	15.1585	14.9304	15.1386	63042896.0
2013-06-20 10:00:00	AAPL	Stock	15.1389	15.2136	15.0582	15.085	67898208.0
2013-06-20 11:00:00	AAPL	Stock	15.0836	15.0964	15.0236	15.0486	35704760.0
2013-06-20 12:00:00	AAPL	Stock	15.0486	15.0554	14.9679	14.9711	28722008.0
2013-06-20 13:00:00	AAPL	Stock	14.9693	15.0357	14.9571	15.0189	26186496.0
2013-06-20 14:00:00	AAPL	Stock	15.0182	15.0214	14.865	14.8911	42049028.0
2013-06-20 15:00:00	AAPL	Stock	14.8893	14.9118	14.8275	14.8732	65970716.0
2013-06-20 16:00:00	AAPL	Stock	14.88	15.0724	14.8578	14.8768	19144972.0
2013-06-20 17:00:00	AAPL	Stock	14.8804	14.8804	14.8689	14.8714	132972.0
2013-06-20 18:00:00	AAPL	Stock	14.8786	14.8875	14.8736	14.8736	71960.0
2013-06-20 19:00:00	AAPL	Stock	14.8736	14.8904	14.8732	14.8886	117432.0
2013-06-20 05:00:00	MSFT	Stock	34.27	34.27	34.25	34.25	900.0
2013-06-20 06:00:00	MSFT	Stock	34.3	34.3	34.3	34.3	500.0
2013-06-20 07:00:00	MSFT	Stock	34.29	34.4	34.29	34.34	10000.0
2013-06-20 08:00:00	MSFT	Stock	34.3	34.47	34.25	34.36	22334.0
2013-06-20 09:00:00	MSFT	Stock	34.32	34.32	34.02	34.27	6396962.0
2013-06-20 10:00:00	MSFT	Stock	34.26	34.33	34.03	34.06	8181432.0
2013-06-20 11:00:00	MSFT	Stock	34.06	34.1	33.87	33.875	6682833.0
2013-06-20 12:00:00	MSFT	Stock	33.875	33.94	33.68	33.75	4644611.0
2013-06-20 13:00:00	MSFT	Stock	33.75	33.86	33.62	33.769	4684734.0
2013-06-20 14:00:00	MSFT	Stock	33.765	33.766	33.46	33.46	5250035.0
2013-06-20 15:00:00	MSFT	Stock	33.47	33.6	33.37	33.49	12479025.0
2013-06-20 16:00:00	MSFT	Stock	33.49	34.047	33.41	33.48	3912044.0
2013-06-20 17:00:00	MSFT	Stock	33.48	33.58	33.45	33.45	3108.0
2013-06-20 18:00:00	MSFT	Stock	33.55	33.62	33.55	33.55	1415.0
2013-06-20 19:00:00	MSFT	Stock	33.54	33.55	33.49	33.5	1700.0
2013-06-20 04:00:00	NVDA	Stock	0.371	0.371	0.3705	0.3705	83560.0
2013-06-20 07:00:00	NVDA	Stock	0.3703	0.3775	0.3698	0.37	300000.0
2013-06-20 08:00:00	NVDA	Stock	0.3698	0.3698	0.3675	0.3675	76000.0
2013-06-20 09:00:00	NVDA	Stock	0.3675	0.3685	0.3628	0.3642	61826880.0
2013-06-20 10:00:00	NVDA	Stock	0.3642	0.365	0.3601	0.3602	119275160.0
2013-06-20 11:00:00	NVDA	Stock	0.3602	0.3642	0.3585	0.3618	94729960.0
2013-06-20 12:00:00	NVDA	Stock	0.3615	0.365	0.3615	0.3635	54879000.0
2013-06-20 13:00:00	NVDA	Stock	0.3636	0.3645	0.362	0.3626	47718240.0
2013-06-20 14:00:00	NVDA	Stock	0.3625	0.363	0.3593	0.3593	63479760.0
2013-06-20 15:00:00	NVDA	Stock	0.3594	0.3622	0.3584	0.3608	165768720.0
2013-06-20 16:00:00	NVDA	Stock	0.361	0.361	0.3584	0.361	5679760.0
2013-06-20 04:00:00	AMZN	Stock	13.801	13.801	13.801	13.801	2000.0
2013-06-20 05:00:00	AMZN	Stock	13.8125	13.825	13.8125	13.816	42860.0
2013-06-20 06:00:00	AMZN	Stock	13.7695	13.7875	13.741	13.741	12000.0
2013-06-20 07:00:00	AMZN	Stock	13.792	13.8	13.775	13.775	66140.0
2013-06-20 08:00:00	AMZN	Stock	13.78	13.9	13.78	13.8	128900.0
2013-06-20 09:00:00	AMZN	Stock	13.828	13.93	13.754	13.85	8635700.0
2013-06-20 10:00:00	AMZN	Stock	13.861	13.891	13.775	13.8365	9880480.0
2013-06-20 11:00:00	AMZN	Stock	13.833	13.8515	13.772	13.839	4859760.0

> showing 50 of 48,527 rows — these rows as CSV

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