PREVIEW / stock_1hour / 2015-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-12.parquet
  size:    1.0 MB
  rows:    48,976
  symbols: 3,545

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-01-12 04:00:00	AAPL	Stock	28.1	28.3	28.1	28.3	10488.0
2015-01-12 05:00:00	AAPL	Stock	28.15	28.175	28.1375	28.1625	17200.0
2015-01-12 06:00:00	AAPL	Stock	28.1625	28.18	28.1325	28.1325	47024.0
2015-01-12 07:00:00	AAPL	Stock	28.1525	28.175	28.1225	28.1275	129572.0
2015-01-12 08:00:00	AAPL	Stock	28.1325	28.175	28.0025	28.0325	989596.0
2015-01-12 09:00:00	AAPL	Stock	28.0375	28.16	27.61	27.63	28793156.0
2015-01-12 10:00:00	AAPL	Stock	27.6325	27.675	27.34	27.6562	40797016.0
2015-01-12 11:00:00	AAPL	Stock	27.6575	27.6825	27.455	27.5125	19615536.0
2015-01-12 12:00:00	AAPL	Stock	27.5125	27.615	27.425	27.4325	14919744.0
2015-01-12 13:00:00	AAPL	Stock	27.4348	27.4425	27.2275	27.295	23706548.0
2015-01-12 14:00:00	AAPL	Stock	27.295	27.355	27.2	27.3175	18193812.0
2015-01-12 15:00:00	AAPL	Stock	27.3175	27.415	27.205	27.315	32127028.0
2015-01-12 16:00:00	AAPL	Stock	27.3125	28.1095	27.2925	27.3425	5732408.0
2015-01-12 17:00:00	AAPL	Stock	27.3425	27.3425	27.3125	27.325	109708.0
2015-01-12 18:00:00	AAPL	Stock	27.3325	27.36	27.3125	27.33	160328.0
2015-01-12 19:00:00	AAPL	Stock	27.3375	27.35	27.325	27.33	110740.0
2015-01-12 04:00:00	MSFT	Stock	47.4	47.5	47.38	47.48	4226.0
2015-01-12 05:00:00	MSFT	Stock	47.51	47.51	47.51	47.51	300.0
2015-01-12 06:00:00	MSFT	Stock	47.52	47.52	47.48	47.48	1738.0
2015-01-12 07:00:00	MSFT	Stock	47.51	47.51	47.4	47.4	4924.0
2015-01-12 08:00:00	MSFT	Stock	47.32	47.38	47.3	47.3	6665.0
2015-01-12 09:00:00	MSFT	Stock	47.35	47.54	46.51	46.73	2761861.0
2015-01-12 10:00:00	MSFT	Stock	46.73	46.96	46.59	46.8	3618919.0
2015-01-12 11:00:00	MSFT	Stock	46.81	46.85	46.585	46.639	2095234.0
2015-01-12 12:00:00	MSFT	Stock	46.64	46.86	46.62	46.69	1735163.0
2015-01-12 13:00:00	MSFT	Stock	46.69	46.75	46.61	46.685	1868476.0
2015-01-12 14:00:00	MSFT	Stock	46.685	46.71	46.36	46.53	2663157.0
2015-01-12 15:00:00	MSFT	Stock	46.53	46.76	46.425	46.61	4895938.0
2015-01-12 16:00:00	MSFT	Stock	46.6	46.709	46.54	46.62	3147121.0
2015-01-12 17:00:00	MSFT	Stock	46.62	46.62	46.6	46.6	11737.0
2015-01-12 18:00:00	MSFT	Stock	46.61	46.62	46.6	46.62	17239.0
2015-01-12 19:00:00	MSFT	Stock	46.6	46.6	46.6	46.6	800.0
2015-01-12 08:00:00	NVDA	Stock	0.4985	0.4985	0.4908	0.4908	16000.0
2015-01-12 09:00:00	NVDA	Stock	0.4998	0.4999	0.4895	0.4899	25673920.0
2015-01-12 10:00:00	NVDA	Stock	0.4898	0.4935	0.4878	0.4928	28821240.0
2015-01-12 11:00:00	NVDA	Stock	0.4929	0.4946	0.49	0.4901	19627880.0
2015-01-12 12:00:00	NVDA	Stock	0.4902	0.4938	0.4901	0.4935	24337760.0
2015-01-12 13:00:00	NVDA	Stock	0.4932	0.4944	0.4915	0.493	11698400.0
2015-01-12 14:00:00	NVDA	Stock	0.493	0.4942	0.491	0.492	10052800.0
2015-01-12 15:00:00	NVDA	Stock	0.4918	0.4928	0.4892	0.4923	49448720.0
2015-01-12 16:00:00	NVDA	Stock	0.4923	0.4923	0.4919	0.492	17727440.0
2015-01-12 08:00:00	AMZN	Stock	14.8725	14.8725	14.825	14.846	90120.0
2015-01-12 09:00:00	AMZN	Stock	14.8625	14.9255	14.464	14.521	10844260.0
2015-01-12 10:00:00	AMZN	Stock	14.5204	14.675	14.4995	14.6555	11591360.0
2015-01-12 11:00:00	AMZN	Stock	14.6575	14.682	14.5135	14.528	7092700.0
2015-01-12 12:00:00	AMZN	Stock	14.533	14.6225	14.5308	14.595	5381420.0
2015-01-12 13:00:00	AMZN	Stock	14.5912	14.606	14.5515	14.565	4569880.0
2015-01-12 14:00:00	AMZN	Stock	14.5685	14.61	14.52	14.536	6038780.0
2015-01-12 15:00:00	AMZN	Stock	14.5375	14.5994	14.501	14.57	13578700.0
2015-01-12 16:00:00	AMZN	Stock	14.5705	14.6182	14.5	14.5676	694080.0

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

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