PREVIEW / stock_1hour / 2015-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-08.parquet
  size:    1.0 MB
  rows:    49,889
  symbols: 3,468

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-09-08 04:00:00	AAPL	Stock	27.97	28.0	27.855	28.0	42172.0
2015-09-08 05:00:00	AAPL	Stock	28.0	28.0625	27.985	28.0425	48696.0
2015-09-08 06:00:00	AAPL	Stock	28.055	28.0625	27.9725	28.0025	190724.0
2015-09-08 07:00:00	AAPL	Stock	27.99	28.0125	27.8125	27.8125	310620.0
2015-09-08 08:00:00	AAPL	Stock	27.8375	28.0625	27.715	27.8375	1424332.0
2015-09-08 09:00:00	AAPL	Stock	27.845	28.14	27.79	28.03	34012624.0
2015-09-08 10:00:00	AAPL	Stock	28.03	28.12	27.8825	27.9325	30427300.0
2015-09-08 11:00:00	AAPL	Stock	27.9325	27.9925	27.8425	27.87	17539300.0
2015-09-08 12:00:00	AAPL	Stock	27.87	27.9725	27.7575	27.7725	17863256.0
2015-09-08 13:00:00	AAPL	Stock	27.7678	27.7958	27.58	27.71	25393528.0
2015-09-08 14:00:00	AAPL	Stock	27.7125	27.8325	27.7062	27.76	22747336.0
2015-09-08 15:00:00	AAPL	Stock	27.76	28.0775	27.7378	28.0775	35461328.0
2015-09-08 16:00:00	AAPL	Stock	28.0775	28.12	27.8878	28.1075	15657872.0
2015-09-08 17:00:00	AAPL	Stock	28.1075	28.15	28.09	28.125	257088.0
2015-09-08 18:00:00	AAPL	Stock	28.115	28.1225	28.0875	28.11	115152.0
2015-09-08 19:00:00	AAPL	Stock	28.11	28.165	28.1	28.1475	293528.0
2015-09-08 04:00:00	MSFT	Stock	43.36	43.36	43.36	43.36	100.0
2015-09-08 05:00:00	MSFT	Stock	43.18	43.48	43.18	43.48	600.0
2015-09-08 06:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	200.0
2015-09-08 07:00:00	MSFT	Stock	43.54	43.54	43.35	43.36	2300.0
2015-09-08 08:00:00	MSFT	Stock	43.26	43.46	43.1	43.35	14564.0
2015-09-08 09:00:00	MSFT	Stock	43.33	44.0	43.24	43.98	4563887.0
2015-09-08 10:00:00	MSFT	Stock	43.98	43.99	43.47	43.66	4960202.0
2015-09-08 11:00:00	MSFT	Stock	43.66	43.7	43.285	43.32	3457872.0
2015-09-08 12:00:00	MSFT	Stock	43.32	43.57	43.28	43.44	2308533.0
2015-09-08 13:00:00	MSFT	Stock	43.45	43.49	43.2	43.43	2345671.0
2015-09-08 14:00:00	MSFT	Stock	43.425	43.84	43.4	43.715	3394875.0
2015-09-08 15:00:00	MSFT	Stock	43.715	43.945	43.69	43.88	5916400.0
2015-09-08 16:00:00	MSFT	Stock	43.89	43.9	43.81	43.81	3376153.0
2015-09-08 17:00:00	MSFT	Stock	43.9	43.92	43.82	43.82	3739.0
2015-09-08 18:00:00	MSFT	Stock	43.9	43.92	43.84	43.84	903.0
2015-09-08 19:00:00	MSFT	Stock	43.85	43.89	43.82	43.89	900.0
2015-09-08 08:00:00	NVDA	Stock	0.55	0.55	0.55	0.55	46600.0
2015-09-08 09:00:00	NVDA	Stock	0.557	0.5625	0.5548	0.5595	28414360.0
2015-09-08 10:00:00	NVDA	Stock	0.5598	0.5615	0.5572	0.561	35072960.0
2015-09-08 11:00:00	NVDA	Stock	0.561	0.5638	0.5602	0.5615	21250520.0
2015-09-08 12:00:00	NVDA	Stock	0.5615	0.565	0.5608	0.5631	15350960.0
2015-09-08 13:00:00	NVDA	Stock	0.563	0.5655	0.5622	0.5655	20068880.0
2015-09-08 14:00:00	NVDA	Stock	0.5658	0.5688	0.5648	0.568	15885680.0
2015-09-08 15:00:00	NVDA	Stock	0.5678	0.5692	0.5662	0.5672	70684160.0
2015-09-08 16:00:00	NVDA	Stock	0.567	0.5675	0.567	0.5675	1785960.0
2015-09-08 17:00:00	NVDA	Stock	0.569	0.569	0.569	0.569	18000.0
2015-09-08 18:00:00	NVDA	Stock	0.567	0.567	0.567	0.567	60000.0
2015-09-08 19:00:00	NVDA	Stock	0.5688	0.5688	0.5688	0.5688	32000.0
2015-09-08 04:00:00	AMZN	Stock	25.1	25.35	25.1	25.35	10760.0
2015-09-08 05:00:00	AMZN	Stock	25.449	25.449	25.448	25.449	6000.0
2015-09-08 06:00:00	AMZN	Stock	25.5	25.5	25.5	25.5	2000.0
2015-09-08 07:00:00	AMZN	Stock	25.4715	25.4715	25.3635	25.3655	18720.0
2015-09-08 08:00:00	AMZN	Stock	25.47	25.5	25.328	25.35	155040.0
2015-09-08 09:00:00	AMZN	Stock	25.35	25.8345	25.35	25.7325	14767480.0

> showing 50 of 49,889 rows — these rows as CSV

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