PREVIEW / stock_1hour / 2012-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-20.parquet
  size:    936 KB
  rows:    44,194
  symbols: 3,476

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
2012-09-20 04:00:00	AAPL	Stock	24.9643	24.9643	24.9643	24.9643	2800.0
2012-09-20 05:00:00	AAPL	Stock	24.9821	24.9821	24.9314	24.9468	58212.0
2012-09-20 06:00:00	AAPL	Stock	24.9504	24.9821	24.9504	24.9821	38276.0
2012-09-20 07:00:00	AAPL	Stock	24.9911	25.0286	24.9643	25.0	477680.0
2012-09-20 08:00:00	AAPL	Stock	24.9968	25.0179	24.9536	24.9854	1520008.0
2012-09-20 09:00:00	AAPL	Stock	24.9854	24.9975	24.7721	24.8154	75733364.0
2012-09-20 10:00:00	AAPL	Stock	24.815	24.9404	24.8036	24.9254	64063020.0
2012-09-20 11:00:00	AAPL	Stock	24.9281	24.9532	24.8929	24.9382	30512692.0
2012-09-20 12:00:00	AAPL	Stock	24.9382	24.9532	24.895	24.9075	21110600.0
2012-09-20 13:00:00	AAPL	Stock	24.9075	24.9421	24.875	24.9146	24160024.0
2012-09-20 14:00:00	AAPL	Stock	24.9146	24.9936	24.9104	24.9714	31528112.0
2012-09-20 15:00:00	AAPL	Stock	24.97	25.0021	24.9146	24.9534	46587436.0
2012-09-20 16:00:00	AAPL	Stock	24.9568	24.9768	24.919	24.975	11824932.0
2012-09-20 17:00:00	AAPL	Stock	24.975	24.9761	24.9536	24.9704	759304.0
2012-09-20 18:00:00	AAPL	Stock	24.9743	24.9814	24.9743	24.9761	334936.0
2012-09-20 19:00:00	AAPL	Stock	24.9807	24.9818	24.9643	24.9818	344260.0
2012-09-20 08:00:00	MSFT	Stock	30.99	30.99	30.91	30.94	16025.0
2012-09-20 09:00:00	MSFT	Stock	30.94	31.16	30.89	31.1	4909207.0
2012-09-20 10:00:00	MSFT	Stock	31.1	31.36	31.08	31.313	6714165.0
2012-09-20 11:00:00	MSFT	Stock	31.32	31.48	31.31	31.37	9127463.0
2012-09-20 12:00:00	MSFT	Stock	31.36	31.44	31.34	31.43	3270782.0
2012-09-20 13:00:00	MSFT	Stock	31.43	31.48	31.38	31.395	3700471.0
2012-09-20 14:00:00	MSFT	Stock	31.395	31.426	31.33	31.398	5130959.0
2012-09-20 15:00:00	MSFT	Stock	31.395	31.47	31.34	31.47	7034019.0
2012-09-20 16:00:00	MSFT	Stock	31.47	31.47	31.05	31.44	4675665.0
2012-09-20 17:00:00	MSFT	Stock	31.44	31.48	31.44	31.48	174560.0
2012-09-20 18:00:00	MSFT	Stock	31.48	31.5	31.45	31.47	3415.0
2012-09-20 19:00:00	MSFT	Stock	31.47	31.5	31.47	31.5	4475.0
2012-09-20 08:00:00	NVDA	Stock	0.3388	0.3388	0.3388	0.3388	20000.0
2012-09-20 09:00:00	NVDA	Stock	0.3388	0.343	0.3382	0.3398	46672920.0
2012-09-20 10:00:00	NVDA	Stock	0.3398	0.3433	0.3395	0.343	56294920.0
2012-09-20 11:00:00	NVDA	Stock	0.3431	0.3438	0.3408	0.3408	40226480.0
2012-09-20 12:00:00	NVDA	Stock	0.3408	0.341	0.3375	0.3385	35503760.0
2012-09-20 13:00:00	NVDA	Stock	0.3385	0.3393	0.338	0.338	27928280.0
2012-09-20 14:00:00	NVDA	Stock	0.338	0.339	0.3375	0.339	31415120.0
2012-09-20 15:00:00	NVDA	Stock	0.3388	0.3405	0.3388	0.3405	68753080.0
2012-09-20 16:00:00	NVDA	Stock	0.3405	0.341	0.3378	0.3399	1616280.0
2012-09-20 17:00:00	NVDA	Stock	0.34	0.34	0.34	0.34	545600.0
2012-09-20 18:00:00	NVDA	Stock	0.3395	0.3395	0.3395	0.3395	12600.0
2012-09-20 07:00:00	AMZN	Stock	13.0275	13.0275	13.0275	13.0275	2000.0
2012-09-20 08:00:00	AMZN	Stock	13.05	13.0845	13.005	13.015	182680.0
2012-09-20 09:00:00	AMZN	Stock	13.02	13.035	12.963	12.9655	7005560.0
2012-09-20 10:00:00	AMZN	Stock	12.9695	13.042	12.955	13.022	7679020.0
2012-09-20 11:00:00	AMZN	Stock	13.0225	13.0365	12.9	12.998	14761840.0
2012-09-20 12:00:00	AMZN	Stock	13.0015	13.015	12.953	12.9555	6127900.0
2012-09-20 13:00:00	AMZN	Stock	12.957	13.0	12.953	12.975	4507200.0
2012-09-20 14:00:00	AMZN	Stock	12.9755	13.008	12.95	12.98	5123400.0
2012-09-20 15:00:00	AMZN	Stock	12.983	13.0435	12.9808	13.04	9343180.0
2012-09-20 16:00:00	AMZN	Stock	13.0405	13.084	12.9875	13.03	3228900.0
2012-09-20 17:00:00	AMZN	Stock	13.0405	13.0405	13.0125	13.0125	161200.0

> showing 50 of 44,194 rows — these rows as CSV

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