PREVIEW / stock_1hour / 2014-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-19.parquet
  size:    1.0 MB
  rows:    48,291
  symbols: 3,571

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
2014-08-19 04:00:00	AAPL	Stock	24.85	24.92	24.85	24.9	48584.0
2014-08-19 05:00:00	AAPL	Stock	24.9	24.905	24.885	24.9	8752.0
2014-08-19 06:00:00	AAPL	Stock	24.9	24.9	24.85	24.8625	151632.0
2014-08-19 07:00:00	AAPL	Stock	24.85	24.9	24.85	24.8875	398980.0
2014-08-19 08:00:00	AAPL	Stock	24.8875	24.91	24.79	24.8875	909644.0
2014-08-19 09:00:00	AAPL	Stock	24.8875	24.97	24.83	24.9587	33036004.0
2014-08-19 10:00:00	AAPL	Stock	24.9575	24.985	24.89	24.9398	32107200.0
2014-08-19 11:00:00	AAPL	Stock	24.9388	25.0	24.8875	24.995	31156112.0
2014-08-19 12:00:00	AAPL	Stock	24.995	25.1312	24.96	25.08	60143960.0
2014-08-19 13:00:00	AAPL	Stock	25.08	25.1375	25.0525	25.105	24847220.0
2014-08-19 14:00:00	AAPL	Stock	25.1075	25.155	25.0825	25.1	22006320.0
2014-08-19 15:00:00	AAPL	Stock	25.0975	25.17	25.07	25.1375	40327596.0
2014-08-19 16:00:00	AAPL	Stock	25.14	25.143	25.0975	25.125	12538760.0
2014-08-19 17:00:00	AAPL	Stock	25.1275	25.14	25.1125	25.115	314392.0
2014-08-19 18:00:00	AAPL	Stock	25.1175	25.14	25.08	25.095	388268.0
2014-08-19 19:00:00	AAPL	Stock	25.095	25.1075	25.0825	25.1075	148924.0
2014-08-19 04:00:00	MSFT	Stock	45.08	45.1	45.08	45.1	200.0
2014-08-19 07:00:00	MSFT	Stock	44.99	45.0	44.99	45.0	780.0
2014-08-19 08:00:00	MSFT	Stock	44.98	44.98	44.75	44.94	11865.0
2014-08-19 09:00:00	MSFT	Stock	44.9	45.02	44.83	44.95	3070433.0
2014-08-19 10:00:00	MSFT	Stock	44.94	45.25	44.88	45.22	3979750.0
2014-08-19 11:00:00	MSFT	Stock	45.225	45.25	45.01	45.053	3203091.0
2014-08-19 12:00:00	MSFT	Stock	45.05	45.12	45.03	45.04	1878931.0
2014-08-19 13:00:00	MSFT	Stock	45.04	45.07	45.0	45.045	1900365.0
2014-08-19 14:00:00	MSFT	Stock	45.041	45.12	45.03	45.09	2168992.0
2014-08-19 15:00:00	MSFT	Stock	45.09	45.34	45.09	45.33	7048435.0
2014-08-19 16:00:00	MSFT	Stock	45.33	45.335	45.07	45.18	2546870.0
2014-08-19 17:00:00	MSFT	Stock	45.06	45.38	45.06	45.35	30428.0
2014-08-19 18:00:00	MSFT	Stock	45.35	45.38	45.33	45.35	20687.0
2014-08-19 19:00:00	MSFT	Stock	45.34	45.34	45.34	45.34	5000.0
2014-08-19 09:00:00	NVDA	Stock	0.48	0.4855	0.4788	0.4845	14292080.0
2014-08-19 10:00:00	NVDA	Stock	0.4848	0.4858	0.4838	0.4858	24927560.0
2014-08-19 11:00:00	NVDA	Stock	0.4858	0.4862	0.4852	0.4862	19117280.0
2014-08-19 12:00:00	NVDA	Stock	0.4862	0.4862	0.4848	0.4855	18902320.0
2014-08-19 13:00:00	NVDA	Stock	0.4854	0.4859	0.4838	0.4852	26363600.0
2014-08-19 14:00:00	NVDA	Stock	0.4851	0.4868	0.4848	0.4862	29059840.0
2014-08-19 15:00:00	NVDA	Stock	0.4864	0.4868	0.4839	0.4843	98787280.0
2014-08-19 16:00:00	NVDA	Stock	0.4843	0.4852	0.4843	0.4844	12231360.0
2014-08-19 07:00:00	AMZN	Stock	16.8445	16.8445	16.8445	16.8445	4000.0
2014-08-19 08:00:00	AMZN	Stock	16.7265	16.795	16.7265	16.795	71780.0
2014-08-19 09:00:00	AMZN	Stock	16.7925	16.795	16.6505	16.712	6621940.0
2014-08-19 10:00:00	AMZN	Stock	16.7065	16.7168	16.6685	16.681	4888260.0
2014-08-19 11:00:00	AMZN	Stock	16.687	16.712	16.655	16.7005	3447300.0
2014-08-19 12:00:00	AMZN	Stock	16.696	16.7435	16.6923	16.7375	2667140.0
2014-08-19 13:00:00	AMZN	Stock	16.733	16.771	16.7291	16.756	2075860.0
2014-08-19 14:00:00	AMZN	Stock	16.756	16.7765	16.737	16.765	2768380.0
2014-08-19 15:00:00	AMZN	Stock	16.766	16.7745	16.7505	16.7625	5581760.0
2014-08-19 16:00:00	AMZN	Stock	16.7565	16.7845	16.6952	16.773	421360.0
2014-08-19 18:00:00	AMZN	Stock	16.7535	16.7535	16.7535	16.7535	2000.0
2014-08-19 19:00:00	AMZN	Stock	16.7625	16.7625	16.7625	16.7625	2000.0

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

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