PREVIEW / stock_1hour / 2015-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-19.parquet
  size:    1.0 MB
  rows:    48,764
  symbols: 3,505

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-02-19 04:00:00	AAPL	Stock	32.1475	32.16	32.125	32.125	16264.0
2015-02-19 05:00:00	AAPL	Stock	32.135	32.195	32.075	32.175	19492.0
2015-02-19 06:00:00	AAPL	Stock	32.1875	32.22	32.175	32.22	48496.0
2015-02-19 07:00:00	AAPL	Stock	32.2175	32.2375	32.0875	32.1375	223796.0
2015-02-19 08:00:00	AAPL	Stock	32.15	32.19	32.1025	32.125	634012.0
2015-02-19 09:00:00	AAPL	Stock	32.13	32.2225	32.0825	32.1662	25291268.0
2015-02-19 10:00:00	AAPL	Stock	32.165	32.2575	32.1025	32.1825	28389276.0
2015-02-19 11:00:00	AAPL	Stock	32.1825	32.2	32.1225	32.1812	17814252.0
2015-02-19 12:00:00	AAPL	Stock	32.18	32.1925	32.1075	32.18	12741704.0
2015-02-19 13:00:00	AAPL	Stock	32.18	32.1975	32.15	32.175	10723360.0
2015-02-19 14:00:00	AAPL	Stock	32.1725	32.1825	32.09	32.1675	13830640.0
2015-02-19 15:00:00	AAPL	Stock	32.1688	32.22	32.0825	32.115	24116472.0
2015-02-19 16:00:00	AAPL	Stock	32.1135	32.1935	32.075	32.1175	5115096.0
2015-02-19 17:00:00	AAPL	Stock	32.1175	32.1275	32.1075	32.1125	81920.0
2015-02-19 18:00:00	AAPL	Stock	32.1125	32.1372	32.11	32.11	74028.0
2015-02-19 19:00:00	AAPL	Stock	32.11	32.1425	32.105	32.125	142972.0
2015-02-19 04:00:00	MSFT	Stock	43.46	43.46	43.46	43.46	100.0
2015-02-19 05:00:00	MSFT	Stock	43.53	43.53	43.52	43.53	1900.0
2015-02-19 06:00:00	MSFT	Stock	43.53	43.53	43.53	43.53	400.0
2015-02-19 07:00:00	MSFT	Stock	43.58	43.58	43.51	43.51	1633.0
2015-02-19 08:00:00	MSFT	Stock	43.54	43.55	43.5	43.5	4574.0
2015-02-19 09:00:00	MSFT	Stock	43.4	43.45	43.05	43.21	5124867.0
2015-02-19 10:00:00	MSFT	Stock	43.2	43.305	43.175	43.25	3994439.0
2015-02-19 11:00:00	MSFT	Stock	43.25	43.526	43.18	43.43	3698357.0
2015-02-19 12:00:00	MSFT	Stock	43.43	43.465	43.27	43.377	1846950.0
2015-02-19 13:00:00	MSFT	Stock	43.375	43.42	43.315	43.41	1525246.0
2015-02-19 14:00:00	MSFT	Stock	43.418	43.45	43.37	43.385	1689132.0
2015-02-19 15:00:00	MSFT	Stock	43.385	43.51	43.38	43.51	4600393.0
2015-02-19 16:00:00	MSFT	Stock	43.5	43.54	43.343	43.5	3414834.0
2015-02-19 17:00:00	MSFT	Stock	43.5	43.52	43.5	43.52	678.0
2015-02-19 18:00:00	MSFT	Stock	43.52	43.53	43.52	43.53	1316.0
2015-02-19 19:00:00	MSFT	Stock	43.55	43.55	43.52	43.55	3583.0
2015-02-19 08:00:00	NVDA	Stock	0.55	0.55	0.55	0.55	46040.0
2015-02-19 09:00:00	NVDA	Stock	0.5565	0.561	0.5532	0.5567	16869080.0
2015-02-19 10:00:00	NVDA	Stock	0.5568	0.5568	0.5542	0.5545	18870400.0
2015-02-19 11:00:00	NVDA	Stock	0.5548	0.5562	0.5542	0.556	12641000.0
2015-02-19 12:00:00	NVDA	Stock	0.556	0.556	0.5528	0.5555	17626680.0
2015-02-19 13:00:00	NVDA	Stock	0.5555	0.5558	0.5542	0.5548	10737080.0
2015-02-19 14:00:00	NVDA	Stock	0.555	0.5551	0.5528	0.5531	16224840.0
2015-02-19 15:00:00	NVDA	Stock	0.5532	0.5545	0.552	0.5545	50079080.0
2015-02-19 16:00:00	NVDA	Stock	0.5544	0.5547	0.5525	0.5547	13801560.0
2015-02-19 17:00:00	NVDA	Stock	0.5535	0.5535	0.5535	0.5535	12000.0
2015-02-19 18:00:00	NVDA	Stock	0.553	0.5535	0.553	0.5535	16000.0
2015-02-19 05:00:00	AMZN	Stock	18.58	18.58	18.58	18.58	10000.0
2015-02-19 07:00:00	AMZN	Stock	18.691	18.6925	18.65	18.6895	20000.0
2015-02-19 08:00:00	AMZN	Stock	18.6685	18.725	18.6685	18.6855	115000.0
2015-02-19 09:00:00	AMZN	Stock	18.6995	19.0621	18.656	19.0405	12745640.0
2015-02-19 10:00:00	AMZN	Stock	19.0405	19.094	18.977	19.005	10283060.0
2015-02-19 11:00:00	AMZN	Stock	19.007	19.0445	18.965	19.0175	5635340.0
2015-02-19 12:00:00	AMZN	Stock	19.008	19.024	18.9255	18.965	4955380.0

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

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