PREVIEW / stock_1hour / 2011-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-01.parquet
  size:    959 KB
  rows:    44,577
  symbols: 3,534

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-04-01 05:00:00	AAPL	Stock	12.4786	12.4786	12.4786	12.4786	2800.0
2011-04-01 06:00:00	AAPL	Stock	12.4707	12.4707	12.4707	12.4707	2800.0
2011-04-01 07:00:00	AAPL	Stock	12.4796	12.5179	12.4732	12.4907	255528.0
2011-04-01 08:00:00	AAPL	Stock	12.4893	12.5536	12.4446	12.5332	3290252.0
2011-04-01 09:00:00	AAPL	Stock	12.5329	12.5567	12.4336	12.4529	67214252.0
2011-04-01 10:00:00	AAPL	Stock	12.4545	12.4929	12.44	12.4643	53299260.0
2011-04-01 11:00:00	AAPL	Stock	12.4639	12.4875	12.4575	12.4732	29058540.0
2011-04-01 12:00:00	AAPL	Stock	12.4739	12.4793	12.4546	12.4636	18514608.0
2011-04-01 13:00:00	AAPL	Stock	12.4625	12.4664	12.4225	12.4407	28851088.0
2011-04-01 14:00:00	AAPL	Stock	12.4411	12.4479	12.3379	12.3621	55710172.0
2011-04-01 15:00:00	AAPL	Stock	12.3604	12.3693	12.2607	12.3054	139110888.0
2011-04-01 16:00:00	AAPL	Stock	12.3054	12.5461	12.2861	12.2964	18208708.0
2011-04-01 17:00:00	AAPL	Stock	12.2996	12.3	12.2911	12.2989	193340.0
2011-04-01 18:00:00	AAPL	Stock	12.3	12.3057	12.2964	12.2986	291060.0
2011-04-01 19:00:00	AAPL	Stock	12.3021	12.3107	12.2986	12.3107	309232.0
2011-04-01 06:00:00	MSFT	Stock	25.49	25.49	25.49	25.49	100.0
2011-04-01 07:00:00	MSFT	Stock	25.54	25.54	25.5	25.5	2000.0
2011-04-01 08:00:00	MSFT	Stock	25.5	25.54	25.36	25.52	62409.0
2011-04-01 09:00:00	MSFT	Stock	25.52	25.56	25.33	25.35	6147763.0
2011-04-01 10:00:00	MSFT	Stock	25.345	25.455	25.31	25.35	9714266.0
2011-04-01 11:00:00	MSFT	Stock	25.35	25.47	25.31	25.445	13585303.0
2011-04-01 12:00:00	MSFT	Stock	25.45	25.47	25.4	25.42	4720991.0
2011-04-01 13:00:00	MSFT	Stock	25.42	25.445	25.395	25.432	8172219.0
2011-04-01 14:00:00	MSFT	Stock	25.44	25.47	25.395	25.46	6066907.0
2011-04-01 15:00:00	MSFT	Stock	25.46	25.48	25.34	25.47	11006573.0
2011-04-01 16:00:00	MSFT	Stock	25.47	25.49	25.389	25.45	2639228.0
2011-04-01 17:00:00	MSFT	Stock	25.47	25.47	25.47	25.47	1000.0
2011-04-01 18:00:00	MSFT	Stock	25.48	25.48	25.45	25.45	46355.0
2011-04-01 19:00:00	MSFT	Stock	25.46	25.5	25.46	25.5	2250.0
2011-04-01 08:00:00	NVDA	Stock	0.4618	0.4678	0.4618	0.4645	731800.0
2011-04-01 09:00:00	NVDA	Stock	0.466	0.468	0.453	0.456	123941760.0
2011-04-01 10:00:00	NVDA	Stock	0.456	0.456	0.4512	0.4539	172055400.0
2011-04-01 11:00:00	NVDA	Stock	0.454	0.4542	0.4515	0.4533	107444120.0
2011-04-01 12:00:00	NVDA	Stock	0.4533	0.4542	0.4515	0.4515	50286960.0
2011-04-01 13:00:00	NVDA	Stock	0.4515	0.4518	0.4498	0.451	74319040.0
2011-04-01 14:00:00	NVDA	Stock	0.451	0.453	0.45	0.4529	73571880.0
2011-04-01 15:00:00	NVDA	Stock	0.4528	0.4555	0.4488	0.455	215225600.0
2011-04-01 16:00:00	NVDA	Stock	0.455	0.4552	0.4506	0.4548	24040960.0
2011-04-01 17:00:00	NVDA	Stock	0.455	0.4552	0.455	0.455	152400.0
2011-04-01 18:00:00	NVDA	Stock	0.4552	0.4552	0.455	0.455	744760.0
2011-04-01 19:00:00	NVDA	Stock	0.455	0.455	0.4545	0.455	116280.0
2011-04-01 07:00:00	AMZN	Stock	9.072	9.072	9.0645	9.0715	29800.0
2011-04-01 08:00:00	AMZN	Stock	9.06	9.0775	9.0065	9.0775	329240.0
2011-04-01 09:00:00	AMZN	Stock	9.0735	9.1145	9.038	9.0625	12657540.0
2011-04-01 10:00:00	AMZN	Stock	9.06	9.1625	9.05	9.1305	21982520.0
2011-04-01 11:00:00	AMZN	Stock	9.132	9.1625	9.122	9.148	9303560.0
2011-04-01 12:00:00	AMZN	Stock	9.1465	9.1545	9.1	9.1255	7725580.0
2011-04-01 13:00:00	AMZN	Stock	9.1259	9.131	9.094	9.1072	5205040.0
2011-04-01 14:00:00	AMZN	Stock	9.107	9.109	9.0125	9.0326	9589000.0
2011-04-01 15:00:00	AMZN	Stock	9.029	9.0295	8.9295	9.006	39113920.0

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

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