PREVIEW / stock_1hour / 2016-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-11.parquet
  size:    1.0 MB
  rows:    47,341
  symbols: 3,190

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-10-11 04:00:00	AAPL	Stock	29.1025	29.2375	29.1025	29.2125	81916.0
2016-10-11 05:00:00	AAPL	Stock	29.2275	29.25	29.175	29.2025	60724.0
2016-10-11 06:00:00	AAPL	Stock	29.22	29.375	29.2	29.3525	449984.0
2016-10-11 07:00:00	AAPL	Stock	29.3525	29.75	29.3	29.5875	2209132.0
2016-10-11 08:00:00	AAPL	Stock	29.5625	29.6475	29.2725	29.455	4792672.0
2016-10-11 09:00:00	AAPL	Stock	29.4575	29.6725	29.365	29.5398	53668656.0
2016-10-11 10:00:00	AAPL	Stock	29.54	29.54	29.3025	29.3838	32179816.0
2016-10-11 11:00:00	AAPL	Stock	29.3825	29.4175	29.2475	29.281	39372588.0
2016-10-11 12:00:00	AAPL	Stock	29.2815	29.3575	29.166	29.3275	22765408.0
2016-10-11 13:00:00	AAPL	Stock	29.325	29.3272	29.0912	29.11	19449876.0
2016-10-11 14:00:00	AAPL	Stock	29.11	29.18	29.05	29.1275	21533936.0
2016-10-11 15:00:00	AAPL	Stock	29.1285	29.165	29.0675	29.085	29274004.0
2016-10-11 16:00:00	AAPL	Stock	29.075	29.11	28.9375	29.0875	12702340.0
2016-10-11 17:00:00	AAPL	Stock	29.0875	29.1125	29.08	29.11	75600.0
2016-10-11 18:00:00	AAPL	Stock	29.1125	29.1225	29.0975	29.1125	62304.0
2016-10-11 19:00:00	AAPL	Stock	29.1125	29.125	29.1	29.1225	114208.0
2016-10-11 06:00:00	MSFT	Stock	57.65	57.65	57.59	57.59	200.0
2016-10-11 07:00:00	MSFT	Stock	58.25	58.25	58.06	58.06	450.0
2016-10-11 08:00:00	MSFT	Stock	58.05	58.05	57.85	57.89	22305.0
2016-10-11 09:00:00	MSFT	Stock	57.89	58.02	57.541	57.57	2681907.0
2016-10-11 10:00:00	MSFT	Stock	57.58	57.73	57.5	57.515	2180352.0
2016-10-11 11:00:00	MSFT	Stock	57.51	57.525	57.26	57.33	2360380.0
2016-10-11 12:00:00	MSFT	Stock	57.33	57.385	57.16	57.26	2076779.0
2016-10-11 13:00:00	MSFT	Stock	57.26	57.26	57.05	57.18	2951138.0
2016-10-11 14:00:00	MSFT	Stock	57.18	57.195	56.89	57.025	3819677.0
2016-10-11 15:00:00	MSFT	Stock	57.02	57.23	57.005	57.18	5336981.0
2016-10-11 16:00:00	MSFT	Stock	57.19	57.29	57.19	57.25	3251052.0
2016-10-11 17:00:00	MSFT	Stock	57.31	57.31	57.31	57.31	214.0
2016-10-11 08:00:00	NVDA	Stock	1.6848	1.6848	1.675	1.675	68000.0
2016-10-11 09:00:00	NVDA	Stock	1.6838	1.6838	1.648	1.6528	62578880.0
2016-10-11 10:00:00	NVDA	Stock	1.653	1.6675	1.651	1.6592	48123560.0
2016-10-11 11:00:00	NVDA	Stock	1.6592	1.667	1.6565	1.6645	30084720.0
2016-10-11 12:00:00	NVDA	Stock	1.6645	1.672	1.664	1.6658	21011120.0
2016-10-11 13:00:00	NVDA	Stock	1.6658	1.666	1.6543	1.6568	30236400.0
2016-10-11 14:00:00	NVDA	Stock	1.6568	1.6588	1.6405	1.6468	43293120.0
2016-10-11 15:00:00	NVDA	Stock	1.6465	1.6548	1.6455	1.653	62193880.0
2016-10-11 16:00:00	NVDA	Stock	1.6532	1.6555	1.6528	1.6538	16065280.0
2016-10-11 17:00:00	NVDA	Stock	1.6532	1.6532	1.645	1.65	283200.0
2016-10-11 18:00:00	NVDA	Stock	1.6532	1.6532	1.6488	1.6488	130560.0
2016-10-11 04:00:00	AMZN	Stock	42.055	42.055	42.055	42.055	4680.0
2016-10-11 05:00:00	AMZN	Stock	42.0855	42.0855	42.0855	42.0855	2000.0
2016-10-11 07:00:00	AMZN	Stock	42.0545	42.1445	42.0545	42.125	31000.0
2016-10-11 08:00:00	AMZN	Stock	42.0625	42.139	42.025	42.025	73540.0
2016-10-11 09:00:00	AMZN	Stock	42.0485	42.0645	41.716	41.8675	9711800.0
2016-10-11 10:00:00	AMZN	Stock	41.877	41.907	41.6165	41.6285	12989280.0
2016-10-11 11:00:00	AMZN	Stock	41.6385	41.7705	41.6215	41.6798	7710300.0
2016-10-11 12:00:00	AMZN	Stock	41.6725	41.7095	41.6115	41.6795	4002140.0
2016-10-11 13:00:00	AMZN	Stock	41.668	41.671	41.4715	41.5485	5426040.0
2016-10-11 14:00:00	AMZN	Stock	41.5545	41.612	41.4722	41.484	6415780.0
2016-10-11 15:00:00	AMZN	Stock	41.478	41.5603	41.4175	41.5415	12543800.0

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

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