PREVIEW / stock_1hour / 2016-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-08.parquet
  size:    1.0 MB
  rows:    48,724
  symbols: 3,306

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
2016-06-08 06:00:00	AAPL	Stock	24.75	24.75	24.75	24.75	800.0
2016-06-08 07:00:00	AAPL	Stock	24.7625	24.7875	24.7575	24.7875	13748.0
2016-06-08 08:00:00	AAPL	Stock	24.7575	24.795	24.7575	24.7875	40268.0
2016-06-08 09:00:00	AAPL	Stock	24.795	24.89	24.755	24.8725	10235076.0
2016-06-08 10:00:00	AAPL	Stock	24.875	24.8775	24.6825	24.686	15788872.0
2016-06-08 11:00:00	AAPL	Stock	24.6852	24.805	24.67	24.765	10009928.0
2016-06-08 12:00:00	AAPL	Stock	24.7675	24.7902	24.735	24.7675	5217020.0
2016-06-08 13:00:00	AAPL	Stock	24.77	24.785	24.7138	24.7275	6754956.0
2016-06-08 14:00:00	AAPL	Stock	24.7275	24.775	24.7175	24.7355	7078944.0
2016-06-08 15:00:00	AAPL	Stock	24.7375	24.765	24.6975	24.735	12522380.0
2016-06-08 16:00:00	AAPL	Stock	24.735	24.86	24.705	24.71	6855844.0
2016-06-08 17:00:00	AAPL	Stock	24.7075	24.7125	24.6875	24.7125	60748.0
2016-06-08 18:00:00	AAPL	Stock	24.7125	24.7175	24.7075	24.7125	6928.0
2016-06-08 19:00:00	AAPL	Stock	24.7	24.7075	24.6925	24.7	20508.0
2016-06-08 08:00:00	MSFT	Stock	52.09	52.09	52.09	52.09	1000.0
2016-06-08 09:00:00	MSFT	Stock	52.12	52.44	52.0	52.29	1837207.0
2016-06-08 10:00:00	MSFT	Stock	52.285	52.295	51.87	52.03	3350617.0
2016-06-08 11:00:00	MSFT	Stock	52.03	52.14	51.94	52.13	2768686.0
2016-06-08 12:00:00	MSFT	Stock	52.13	52.23	52.075	52.155	1732911.0
2016-06-08 13:00:00	MSFT	Stock	52.16	52.2	52.01	52.05	1438709.0
2016-06-08 14:00:00	MSFT	Stock	52.045	52.18	51.97	52.05	1988199.0
2016-06-08 15:00:00	MSFT	Stock	52.05	52.1	51.97	52.04	3732033.0
2016-06-08 16:00:00	MSFT	Stock	52.04	52.156	52.04	52.07	2372766.0
2016-06-08 17:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	2600.0
2016-06-08 18:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	100.0
2016-06-08 19:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	600.0
2016-06-08 08:00:00	NVDA	Stock	1.1668	1.1668	1.163	1.163	36000.0
2016-06-08 09:00:00	NVDA	Stock	1.166	1.166	1.1512	1.1515	32226480.0
2016-06-08 10:00:00	NVDA	Stock	1.1512	1.1571	1.145	1.1534	50273080.0
2016-06-08 11:00:00	NVDA	Stock	1.1535	1.1598	1.153	1.157	26910440.0
2016-06-08 12:00:00	NVDA	Stock	1.157	1.161	1.157	1.1603	18655320.0
2016-06-08 13:00:00	NVDA	Stock	1.1605	1.1618	1.1545	1.1546	23422640.0
2016-06-08 14:00:00	NVDA	Stock	1.1545	1.16	1.1538	1.158	22041160.0
2016-06-08 15:00:00	NVDA	Stock	1.158	1.1582	1.1528	1.1545	45759480.0
2016-06-08 16:00:00	NVDA	Stock	1.1548	1.1567	1.1545	1.155	9401240.0
2016-06-08 17:00:00	NVDA	Stock	1.1555	1.1562	1.1545	1.1545	144000.0
2016-06-08 18:00:00	NVDA	Stock	1.156	1.156	1.1545	1.1545	40000.0
2016-06-08 19:00:00	NVDA	Stock	1.156	1.1562	1.156	1.1562	116560.0
2016-06-08 06:00:00	AMZN	Stock	36.3445	36.3475	36.3445	36.3475	11780.0
2016-06-08 07:00:00	AMZN	Stock	36.292	36.325	36.292	36.3245	46740.0
2016-06-08 08:00:00	AMZN	Stock	36.3085	36.3325	36.2625	36.3075	115500.0
2016-06-08 09:00:00	AMZN	Stock	36.3	36.4195	36.206	36.2988	6310380.0
2016-06-08 10:00:00	AMZN	Stock	36.306	36.3325	36.08	36.199	7216500.0
2016-06-08 11:00:00	AMZN	Stock	36.1875	36.375	36.1595	36.3525	4763000.0
2016-06-08 12:00:00	AMZN	Stock	36.3548	36.471	36.345	36.3983	6373860.0
2016-06-08 13:00:00	AMZN	Stock	36.378	36.4255	36.3255	36.38	2396720.0
2016-06-08 14:00:00	AMZN	Stock	36.385	36.4405	36.3397	36.4	3695220.0
2016-06-08 15:00:00	AMZN	Stock	36.391	36.415	36.321	36.3325	5352380.0
2016-06-08 16:00:00	AMZN	Stock	36.332	36.3475	36.325	36.3475	2181840.0
2016-06-08 17:00:00	AMZN	Stock	36.3475	36.3475	36.3475	36.3475	6520.0

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

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