PREVIEW / stock_1hour / 2011-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-07.parquet
  size:    936 KB
  rows:    44,356
  symbols: 3,531

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-03-07 07:00:00	AAPL	Stock	12.8929	12.9286	12.8461	12.8482	582848.0
2011-03-07 08:00:00	AAPL	Stock	12.8468	12.8739	12.8279	12.8696	1816080.0
2011-03-07 09:00:00	AAPL	Stock	12.8696	12.9168	12.7918	12.8325	68186664.0
2011-03-07 10:00:00	AAPL	Stock	12.8325	12.8464	12.7046	12.7306	79559592.0
2011-03-07 11:00:00	AAPL	Stock	12.7325	12.7329	12.6003	12.6289	93831416.0
2011-03-07 12:00:00	AAPL	Stock	12.6293	12.6704	12.5893	12.6032	68006008.0
2011-03-07 13:00:00	AAPL	Stock	12.6004	12.6207	12.5468	12.6043	78225028.0
2011-03-07 14:00:00	AAPL	Stock	12.6029	12.6621	12.5939	12.6471	52124352.0
2011-03-07 15:00:00	AAPL	Stock	12.6461	12.7282	12.6357	12.6929	83922076.0
2011-03-07 16:00:00	AAPL	Stock	12.6922	12.7068	12.6267	12.6786	11030320.0
2011-03-07 17:00:00	AAPL	Stock	12.6786	12.6786	12.6571	12.6668	352884.0
2011-03-07 18:00:00	AAPL	Stock	12.6668	12.6914	12.6532	12.675	463204.0
2011-03-07 19:00:00	AAPL	Stock	12.6711	12.675	12.6689	12.6689	263144.0
2011-03-07 07:00:00	MSFT	Stock	26.04	26.04	26.01	26.01	1900.0
2011-03-07 08:00:00	MSFT	Stock	26.01	26.01	25.9	26.0	13957.0
2011-03-07 09:00:00	MSFT	Stock	25.99	26.27	25.99	26.142	7889863.0
2011-03-07 10:00:00	MSFT	Stock	26.145	26.15	25.77	25.86	10712195.0
2011-03-07 11:00:00	MSFT	Stock	25.86	25.86	25.66	25.74	9368303.0
2011-03-07 12:00:00	MSFT	Stock	25.73	25.79	25.66	25.67	6011387.0
2011-03-07 13:00:00	MSFT	Stock	25.67	25.7	25.58	25.61	9147667.0
2011-03-07 14:00:00	MSFT	Stock	25.62	25.7	25.55	25.68	7954518.0
2011-03-07 15:00:00	MSFT	Stock	25.675	25.8	25.645	25.71	10100472.0
2011-03-07 16:00:00	MSFT	Stock	25.72	25.97	25.67	25.72	3664390.0
2011-03-07 17:00:00	MSFT	Stock	25.79	25.79	25.72	25.72	1616.0
2011-03-07 18:00:00	MSFT	Stock	25.74	25.79	25.72	25.76	8338.0
2011-03-07 19:00:00	MSFT	Stock	25.76	25.8	25.76	25.8	4300.0
2011-03-07 07:00:00	NVDA	Stock	0.52	0.52	0.52	0.52	16000.0
2011-03-07 08:00:00	NVDA	Stock	0.5213	0.5213	0.513	0.5188	251200.0
2011-03-07 09:00:00	NVDA	Stock	0.5182	0.5245	0.508	0.5145	118085360.0
2011-03-07 10:00:00	NVDA	Stock	0.5148	0.5148	0.5022	0.5062	191454720.0
2011-03-07 11:00:00	NVDA	Stock	0.5062	0.5064	0.4988	0.5025	176070080.0
2011-03-07 12:00:00	NVDA	Stock	0.5025	0.5048	0.5008	0.502	78185560.0
2011-03-07 13:00:00	NVDA	Stock	0.502	0.504	0.5008	0.503	76897560.0
2011-03-07 14:00:00	NVDA	Stock	0.503	0.5068	0.502	0.5029	106920680.0
2011-03-07 15:00:00	NVDA	Stock	0.5028	0.515	0.5016	0.5118	249018320.0
2011-03-07 16:00:00	NVDA	Stock	0.512	0.5195	0.5058	0.5112	2125440.0
2011-03-07 17:00:00	NVDA	Stock	0.5118	0.5145	0.5112	0.5145	381760.0
2011-03-07 18:00:00	NVDA	Stock	0.5138	0.5142	0.5122	0.5142	76000.0
2011-03-07 19:00:00	NVDA	Stock	0.5142	0.5145	0.514	0.5145	58400.0
2011-03-07 08:00:00	AMZN	Stock	8.589	8.59	8.571	8.571	15200.0
2011-03-07 09:00:00	AMZN	Stock	8.5865	8.6045	8.469	8.469	19189720.0
2011-03-07 10:00:00	AMZN	Stock	8.469	8.4975	8.4075	8.4405	16991920.0
2011-03-07 11:00:00	AMZN	Stock	8.4435	8.456	8.364	8.396	15257800.0
2011-03-07 12:00:00	AMZN	Stock	8.394	8.4135	8.333	8.3425	13739080.0
2011-03-07 13:00:00	AMZN	Stock	8.3435	8.355	8.3225	8.3325	10653320.0
2011-03-07 14:00:00	AMZN	Stock	8.33	8.38	8.312	8.3755	13651060.0
2011-03-07 15:00:00	AMZN	Stock	8.3755	8.4835	8.3675	8.454	26239540.0
2011-03-07 16:00:00	AMZN	Stock	8.454	8.4595	8.3775	8.449	2374920.0
2011-03-07 17:00:00	AMZN	Stock	8.45	8.4611	8.449	8.4611	38440.0
2011-03-07 18:00:00	AMZN	Stock	8.454	8.454	8.4475	8.4475	35300.0

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

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