PREVIEW / stock_1hour / 2014-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-16.parquet
  size:    1.0 MB
  rows:    47,772
  symbols: 3,518

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-01-16 05:00:00	AAPL	Stock	19.9339	19.9368	19.9339	19.9368	14000.0
2014-01-16 06:00:00	AAPL	Stock	19.9336	19.9336	19.9179	19.9179	8120.0
2014-01-16 07:00:00	AAPL	Stock	19.9179	19.9379	19.8496	19.8629	321188.0
2014-01-16 08:00:00	AAPL	Stock	19.8786	19.9379	19.7932	19.8179	1391768.0
2014-01-16 09:00:00	AAPL	Stock	19.8143	19.8875	19.7029	19.7869	47877536.0
2014-01-16 10:00:00	AAPL	Stock	19.7886	19.85	19.7432	19.7843	34101312.0
2014-01-16 11:00:00	AAPL	Stock	19.7873	19.8748	19.7754	19.8404	21986916.0
2014-01-16 12:00:00	AAPL	Stock	19.8407	19.8439	19.7839	19.8321	11707108.0
2014-01-16 13:00:00	AAPL	Stock	19.8336	19.8654	19.8136	19.8146	13275136.0
2014-01-16 14:00:00	AAPL	Stock	19.8154	19.8554	19.8036	19.8518	12341980.0
2014-01-16 15:00:00	AAPL	Stock	19.8518	19.8551	19.7786	19.7936	25115608.0
2014-01-16 16:00:00	AAPL	Stock	19.7946	19.8205	19.7679	19.7875	10437952.0
2014-01-16 17:00:00	AAPL	Stock	19.7882	19.7964	19.7589	19.7857	175056.0
2014-01-16 18:00:00	AAPL	Stock	19.7857	19.7946	19.7714	19.7714	201992.0
2014-01-16 19:00:00	AAPL	Stock	19.7846	19.7854	19.7339	19.7439	142212.0
2014-01-16 04:00:00	MSFT	Stock	36.83	36.83	36.78	36.82	1169.0
2014-01-16 05:00:00	MSFT	Stock	36.83	36.83	36.83	36.83	100.0
2014-01-16 06:00:00	MSFT	Stock	36.83	36.88	36.8	36.8	1600.0
2014-01-16 07:00:00	MSFT	Stock	36.8	36.8	36.66	36.66	5740.0
2014-01-16 08:00:00	MSFT	Stock	36.66	36.75	36.66	36.7	5001.0
2014-01-16 09:00:00	MSFT	Stock	36.72	37.0	36.528	36.574	4291365.0
2014-01-16 10:00:00	MSFT	Stock	36.57	36.655	36.39	36.42	4353792.0
2014-01-16 11:00:00	MSFT	Stock	36.42	36.49	36.33	36.46	3705743.0
2014-01-16 12:00:00	MSFT	Stock	36.47	36.47	36.31	36.385	3282999.0
2014-01-16 13:00:00	MSFT	Stock	36.38	36.67	36.37	36.605	4003818.0
2014-01-16 14:00:00	MSFT	Stock	36.605	36.63	36.52	36.63	2384298.0
2014-01-16 15:00:00	MSFT	Stock	36.63	36.89	36.61	36.88	9399629.0
2014-01-16 16:00:00	MSFT	Stock	36.89	36.89	36.58	36.83	5143462.0
2014-01-16 17:00:00	MSFT	Stock	36.359	36.89	36.359	36.83	11944.0
2014-01-16 18:00:00	MSFT	Stock	36.84	36.89	36.84	36.84	14182.0
2014-01-16 19:00:00	MSFT	Stock	36.83	36.83	36.82	36.82	1700.0
2014-01-16 06:00:00	NVDA	Stock	0.405	0.405	0.405	0.405	4000.0
2014-01-16 09:00:00	NVDA	Stock	0.4003	0.4022	0.3989	0.399	36938720.0
2014-01-16 10:00:00	NVDA	Stock	0.3991	0.4015	0.3985	0.4013	35819440.0
2014-01-16 11:00:00	NVDA	Stock	0.401	0.402	0.4004	0.4008	14108920.0
2014-01-16 12:00:00	NVDA	Stock	0.4006	0.4015	0.4003	0.4015	19695080.0
2014-01-16 13:00:00	NVDA	Stock	0.4015	0.402	0.401	0.401	11094680.0
2014-01-16 14:00:00	NVDA	Stock	0.401	0.4018	0.4005	0.401	16478800.0
2014-01-16 15:00:00	NVDA	Stock	0.401	0.402	0.4004	0.4015	48089680.0
2014-01-16 16:00:00	NVDA	Stock	0.4015	0.4017	0.3998	0.3998	31702400.0
2014-01-16 17:00:00	NVDA	Stock	0.397	0.397	0.397	0.397	16000.0
2014-01-16 08:00:00	AMZN	Stock	19.725	19.725	19.6465	19.65	109900.0
2014-01-16 09:00:00	AMZN	Stock	19.7	19.725	19.4705	19.698	13298820.0
2014-01-16 10:00:00	AMZN	Stock	19.684	19.85	19.6595	19.756	8733560.0
2014-01-16 11:00:00	AMZN	Stock	19.7415	19.8995	19.7105	19.863	6257320.0
2014-01-16 12:00:00	AMZN	Stock	19.8675	19.923	19.8205	19.902	4885520.0
2014-01-16 13:00:00	AMZN	Stock	19.91	19.9645	19.8765	19.909	3206500.0
2014-01-16 14:00:00	AMZN	Stock	19.9035	19.9162	19.805	19.829	3174400.0
2014-01-16 15:00:00	AMZN	Stock	19.8305	19.842	19.729	19.79	5560720.0
2014-01-16 16:00:00	AMZN	Stock	19.79	19.791	19.7473	19.7625	1214980.0

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

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