PREVIEW / stock_1hour / 2013-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-26.parquet
  size:    1.0 MB
  rows:    47,394
  symbols: 3,532

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
2013-12-26 05:00:00	AAPL	Stock	20.3475	20.3475	20.3475	20.3475	5600.0
2013-12-26 06:00:00	AAPL	Stock	20.2893	20.2893	20.2861	20.2861	8400.0
2013-12-26 07:00:00	AAPL	Stock	20.3125	20.3314	20.3036	20.3314	189280.0
2013-12-26 08:00:00	AAPL	Stock	20.2914	20.3429	20.2739	20.2914	1034012.0
2013-12-26 09:00:00	AAPL	Stock	20.2964	20.3393	20.1206	20.1396	41624828.0
2013-12-26 10:00:00	AAPL	Stock	20.1396	20.2121	20.1361	20.1918	27126848.0
2013-12-26 11:00:00	AAPL	Stock	20.1946	20.2804	20.1829	20.23	21125216.0
2013-12-26 12:00:00	AAPL	Stock	20.2316	20.2368	20.1875	20.2096	10676092.0
2013-12-26 13:00:00	AAPL	Stock	20.2114	20.2139	20.1821	20.1975	8529024.0
2013-12-26 14:00:00	AAPL	Stock	20.1964	20.2014	20.1639	20.1857	13144768.0
2013-12-26 15:00:00	AAPL	Stock	20.186	20.1875	20.1268	20.1368	25635456.0
2013-12-26 16:00:00	AAPL	Stock	20.1393	20.191	20.1339	20.1357	13301484.0
2013-12-26 17:00:00	AAPL	Stock	20.1364	20.1393	20.1271	20.1271	162960.0
2013-12-26 18:00:00	AAPL	Stock	20.1261	20.13	20.1189	20.125	58492.0
2013-12-26 19:00:00	AAPL	Stock	20.1254	20.1339	20.1214	20.1261	111580.0
2013-12-26 07:00:00	MSFT	Stock	37.12	37.12	37.12	37.12	100.0
2013-12-26 08:00:00	MSFT	Stock	37.17	37.26	37.08	37.23	555500.0
2013-12-26 09:00:00	MSFT	Stock	37.23	37.49	37.17	37.39	2241171.0
2013-12-26 10:00:00	MSFT	Stock	37.39	37.42	37.33	37.395	2163447.0
2013-12-26 11:00:00	MSFT	Stock	37.39	37.43	37.35	37.405	2371656.0
2013-12-26 12:00:00	MSFT	Stock	37.4	37.46	37.39	37.44	1482605.0
2013-12-26 13:00:00	MSFT	Stock	37.44	37.467	37.4	37.45	1371303.0
2013-12-26 14:00:00	MSFT	Stock	37.45	37.47	37.4	37.415	1366966.0
2013-12-26 15:00:00	MSFT	Stock	37.415	37.46	37.4	37.43	2883773.0
2013-12-26 16:00:00	MSFT	Stock	37.44	37.48	37.139	37.48	2744962.0
2013-12-26 17:00:00	MSFT	Stock	37.49	37.49	37.44	37.44	620.0
2013-12-26 18:00:00	MSFT	Stock	37.48	37.49	37.47	37.47	1000.0
2013-12-26 19:00:00	MSFT	Stock	37.47	37.47	37.41	37.41	1199.0
2013-12-26 09:00:00	NVDA	Stock	0.397	0.3981	0.3948	0.3968	26518040.0
2013-12-26 10:00:00	NVDA	Stock	0.3969	0.3978	0.3933	0.3938	16732160.0
2013-12-26 11:00:00	NVDA	Stock	0.3939	0.394	0.3918	0.3918	13740160.0
2013-12-26 12:00:00	NVDA	Stock	0.3919	0.393	0.3908	0.3928	27661080.0
2013-12-26 13:00:00	NVDA	Stock	0.393	0.3933	0.3922	0.3933	13428960.0
2013-12-26 14:00:00	NVDA	Stock	0.3933	0.3933	0.391	0.3916	12594960.0
2013-12-26 15:00:00	NVDA	Stock	0.3915	0.3925	0.391	0.3918	26305000.0
2013-12-26 16:00:00	NVDA	Stock	0.3918	0.3918	0.3918	0.3918	30484040.0
2013-12-26 08:00:00	AMZN	Stock	20.015	20.07	20.015	20.07	9360.0
2013-12-26 09:00:00	AMZN	Stock	20.05	20.095	19.8405	19.9025	6025220.0
2013-12-26 10:00:00	AMZN	Stock	19.9035	20.0745	19.8725	20.0285	5724000.0
2013-12-26 11:00:00	AMZN	Stock	20.028	20.089	20.0045	20.077	3060220.0
2013-12-26 12:00:00	AMZN	Stock	20.078	20.195	20.072	20.183	4448600.0
2013-12-26 13:00:00	AMZN	Stock	20.1882	20.2125	20.144	20.19	3512360.0
2013-12-26 14:00:00	AMZN	Stock	20.1898	20.1898	20.1295	20.1622	1958360.0
2013-12-26 15:00:00	AMZN	Stock	20.153	20.226	20.14	20.2195	8090900.0
2013-12-26 16:00:00	AMZN	Stock	20.209	20.2236	20.078	20.2025	395640.0
2013-12-26 17:00:00	AMZN	Stock	20.202	20.217	20.202	20.217	14000.0
2013-12-26 18:00:00	AMZN	Stock	20.2165	20.2195	20.2165	20.2195	7620.0
2013-12-26 19:00:00	AMZN	Stock	20.2	20.2	20.15	20.155	29000.0
2013-12-26 05:00:00	META	Stock	58.41	58.41	57.75	57.75	2300.0
2013-12-26 06:00:00	META	Stock	57.73	57.96	57.73	57.96	4390.0

> showing 50 of 47,394 rows — these rows as CSV

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