PREVIEW / stock_1hour / 2015-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-22.parquet
  size:    1.0 MB
  rows:    48,564
  symbols: 3,502

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
2015-04-22 04:00:00	AAPL	Stock	31.745	31.745	31.6	31.6	23268.0
2015-04-22 05:00:00	AAPL	Stock	31.595	31.6425	31.5625	31.625	13484.0
2015-04-22 06:00:00	AAPL	Stock	31.6075	31.65	31.55	31.6	47352.0
2015-04-22 07:00:00	AAPL	Stock	31.6125	31.7125	31.6125	31.705	124236.0
2015-04-22 08:00:00	AAPL	Stock	31.7	31.75	31.5525	31.7425	398384.0
2015-04-22 09:00:00	AAPL	Stock	31.7425	31.7925	31.58	31.6825	19682840.0
2015-04-22 10:00:00	AAPL	Stock	31.6825	31.7525	31.5825	31.7275	17049344.0
2015-04-22 11:00:00	AAPL	Stock	31.7275	31.8182	31.7275	31.8025	13232340.0
2015-04-22 12:00:00	AAPL	Stock	31.805	31.93	31.755	31.9035	14964748.0
2015-04-22 13:00:00	AAPL	Stock	31.905	31.975	31.85	31.971	14527172.0
2015-04-22 14:00:00	AAPL	Stock	31.97	32.08	31.96	32.0762	17325004.0
2015-04-22 15:00:00	AAPL	Stock	32.075	32.2175	32.075	32.1575	30958736.0
2015-04-22 16:00:00	AAPL	Stock	32.1575	32.16	32.0025	32.07	12916488.0
2015-04-22 17:00:00	AAPL	Stock	32.0575	32.1	32.045	32.075	152532.0
2015-04-22 18:00:00	AAPL	Stock	32.075	32.1225	32.075	32.1125	69532.0
2015-04-22 19:00:00	AAPL	Stock	32.1025	32.1175	32.0875	32.1125	144736.0
2015-04-22 04:00:00	MSFT	Stock	42.51	42.51	42.5	42.5	300.0
2015-04-22 07:00:00	MSFT	Stock	42.49	42.51	42.42	42.42	3708.0
2015-04-22 08:00:00	MSFT	Stock	42.5	42.6	42.42	42.6	12412.0
2015-04-22 09:00:00	MSFT	Stock	42.62	42.83	42.59	42.66	2432382.0
2015-04-22 10:00:00	MSFT	Stock	42.68	42.94	42.55	42.925	3730800.0
2015-04-22 11:00:00	MSFT	Stock	42.925	43.08	42.92	43.06	3924095.0
2015-04-22 12:00:00	MSFT	Stock	43.06	43.1	43.01	43.04	2247746.0
2015-04-22 13:00:00	MSFT	Stock	43.034	43.09	42.96	43.048	2065616.0
2015-04-22 14:00:00	MSFT	Stock	43.05	43.12	43.0	43.03	2589293.0
2015-04-22 15:00:00	MSFT	Stock	43.03	43.13	42.97	42.98	4115716.0
2015-04-22 16:00:00	MSFT	Stock	42.985	43.025	42.65	42.982	2547920.0
2015-04-22 17:00:00	MSFT	Stock	42.75	42.75	42.73	42.75	13134.0
2015-04-22 18:00:00	MSFT	Stock	42.73	42.79	42.73	42.79	18030.0
2015-04-22 19:00:00	MSFT	Stock	42.79	42.87	42.75	42.85	3556.0
2015-04-22 08:00:00	NVDA	Stock	0.5492	0.5492	0.5488	0.5488	80000.0
2015-04-22 09:00:00	NVDA	Stock	0.5492	0.5562	0.5492	0.553	15480720.0
2015-04-22 10:00:00	NVDA	Stock	0.553	0.553	0.5462	0.5525	27353000.0
2015-04-22 11:00:00	NVDA	Stock	0.5528	0.5552	0.5518	0.5522	26348280.0
2015-04-22 12:00:00	NVDA	Stock	0.5522	0.5549	0.5505	0.5545	10115280.0
2015-04-22 13:00:00	NVDA	Stock	0.5545	0.5575	0.5542	0.5568	11595400.0
2015-04-22 14:00:00	NVDA	Stock	0.5566	0.5576	0.5542	0.5562	17463280.0
2015-04-22 15:00:00	NVDA	Stock	0.5562	0.5585	0.556	0.5578	59072800.0
2015-04-22 16:00:00	NVDA	Stock	0.5578	0.5605	0.5538	0.5548	26017400.0
2015-04-22 17:00:00	NVDA	Stock	0.5545	0.5545	0.549	0.549	47560.0
2015-04-22 18:00:00	NVDA	Stock	0.5572	0.5572	0.5572	0.5572	20000.0
2015-04-22 04:00:00	AMZN	Stock	19.5505	19.5505	19.485	19.485	11900.0
2015-04-22 06:00:00	AMZN	Stock	19.451	19.451	19.4415	19.4415	14200.0
2015-04-22 07:00:00	AMZN	Stock	19.508	19.556	19.486	19.556	73160.0
2015-04-22 08:00:00	AMZN	Stock	19.4945	19.6465	19.4945	19.6465	108700.0
2015-04-22 09:00:00	AMZN	Stock	19.644	19.665	19.477	19.5035	7990020.0
2015-04-22 10:00:00	AMZN	Stock	19.5045	19.5735	19.4	19.57	13777320.0
2015-04-22 11:00:00	AMZN	Stock	19.571	19.714	19.5525	19.693	12229320.0
2015-04-22 12:00:00	AMZN	Stock	19.693	19.6965	19.5245	19.5405	6685480.0
2015-04-22 13:00:00	AMZN	Stock	19.546	19.569	19.4615	19.4835	5545260.0

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

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