PREVIEW / stock_1hour / 2010-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-24.parquet
  size:    885 KB
  rows:    42,675
  symbols: 3,437

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
2010-06-24 05:00:00	AAPL	Stock	9.6429	9.6429	9.6429	9.6429	28000.0
2010-06-24 07:00:00	AAPL	Stock	9.6489	9.6518	9.6021	9.6136	494424.0
2010-06-24 08:00:00	AAPL	Stock	9.6121	9.7104	9.5989	9.6836	8137836.0
2010-06-24 09:00:00	AAPL	Stock	9.6832	9.757	9.6307	9.64	126884576.0
2010-06-24 10:00:00	AAPL	Stock	9.6414	9.7211	9.6071	9.6471	129893820.0
2010-06-24 11:00:00	AAPL	Stock	9.6471	9.6864	9.6071	9.6586	83488776.0
2010-06-24 12:00:00	AAPL	Stock	9.6589	9.6875	9.6111	9.6461	53223044.0
2010-06-24 13:00:00	AAPL	Stock	9.6461	9.7314	9.6257	9.7261	69509804.0
2010-06-24 14:00:00	AAPL	Stock	9.7254	9.7261	9.6189	9.6346	86052876.0
2010-06-24 15:00:00	AAPL	Stock	9.6337	9.6532	9.575	9.5975	129204152.0
2010-06-24 16:00:00	AAPL	Stock	9.5975	9.6562	9.5961	9.6293	16997652.0
2010-06-24 17:00:00	AAPL	Stock	9.6257	9.6536	9.6218	9.6446	1787856.0
2010-06-24 18:00:00	AAPL	Stock	9.6429	9.6486	9.6071	9.6464	340088.0
2010-06-24 19:00:00	AAPL	Stock	9.6471	9.66	9.6429	9.6589	604212.0
2010-06-24 07:00:00	MSFT	Stock	25.2	25.2	25.11	25.18	4940.0
2010-06-24 08:00:00	MSFT	Stock	25.19	25.45	25.15	25.45	242900.0
2010-06-24 09:00:00	MSFT	Stock	25.44	25.72	25.21	25.23	12334487.0
2010-06-24 10:00:00	MSFT	Stock	25.23	25.39	25.02	25.105	15563259.0
2010-06-24 11:00:00	MSFT	Stock	25.11	25.195	24.99	25.14	8753951.0
2010-06-24 12:00:00	MSFT	Stock	25.135	25.195	24.99	25.08	5557878.0
2010-06-24 13:00:00	MSFT	Stock	25.08	25.39	25.05	25.39	5558852.0
2010-06-24 14:00:00	MSFT	Stock	25.385	25.44	25.01	25.05	8543282.0
2010-06-24 15:00:00	MSFT	Stock	25.05	25.158	24.93	25.0	19080742.0
2010-06-24 16:00:00	MSFT	Stock	25.0	25.17	24.946	25.09	7279786.0
2010-06-24 17:00:00	MSFT	Stock	25.08	25.12	25.02	25.12	20625.0
2010-06-24 18:00:00	MSFT	Stock	25.0	25.09	25.0	25.07	27937.0
2010-06-24 19:00:00	MSFT	Stock	25.05	25.07	25.02	25.07	4990.0
2010-06-24 08:00:00	NVDA	Stock	0.293	0.293	0.2835	0.2898	174600.0
2010-06-24 09:00:00	NVDA	Stock	0.29	0.2922	0.285	0.2855	90418480.0
2010-06-24 10:00:00	NVDA	Stock	0.2855	0.2872	0.2838	0.2848	140003760.0
2010-06-24 11:00:00	NVDA	Stock	0.285	0.285	0.2818	0.2838	77472000.0
2010-06-24 12:00:00	NVDA	Stock	0.2835	0.286	0.2825	0.2838	34529320.0
2010-06-24 13:00:00	NVDA	Stock	0.2838	0.2865	0.282	0.2864	56787520.0
2010-06-24 14:00:00	NVDA	Stock	0.2862	0.2865	0.2785	0.2788	112914720.0
2010-06-24 15:00:00	NVDA	Stock	0.2786	0.2795	0.2768	0.2778	187496160.0
2010-06-24 16:00:00	NVDA	Stock	0.2778	0.2827	0.2772	0.2785	15880560.0
2010-06-24 17:00:00	NVDA	Stock	0.2795	0.2795	0.2788	0.2792	128000.0
2010-06-24 18:00:00	NVDA	Stock	0.2792	0.2792	0.2785	0.2785	154000.0
2010-06-24 19:00:00	NVDA	Stock	0.2785	0.279	0.2785	0.279	176000.0
2010-06-24 08:00:00	AMZN	Stock	6.0215	6.055	6.01	6.048	60500.0
2010-06-24 09:00:00	AMZN	Stock	6.0495	6.0495	5.8765	5.89	22653620.0
2010-06-24 10:00:00	AMZN	Stock	5.8905	5.94	5.865	5.872	30269160.0
2010-06-24 11:00:00	AMZN	Stock	5.8715	5.944	5.84	5.926	20715820.0
2010-06-24 12:00:00	AMZN	Stock	5.9265	5.946	5.8715	5.8975	14036860.0
2010-06-24 13:00:00	AMZN	Stock	5.8975	5.948	5.889	5.945	13929480.0
2010-06-24 14:00:00	AMZN	Stock	5.945	5.974	5.9225	5.9425	17767580.0
2010-06-24 15:00:00	AMZN	Stock	5.942	5.9485	5.86	5.916	29819720.0
2010-06-24 16:00:00	AMZN	Stock	5.9135	5.9225	5.905	5.9195	710140.0
2010-06-24 17:00:00	AMZN	Stock	5.9195	5.925	5.9195	5.925	72000.0
2010-06-24 18:00:00	AMZN	Stock	5.9165	5.95	5.9165	5.95	112580.0

> showing 50 of 42,675 rows — these rows as CSV

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