PREVIEW / stock_1hour / 2013-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-15.parquet
  size:    945 KB
  rows:    44,525
  symbols: 3,457

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
2013-01-15 04:00:00	AAPL	Stock	17.8575	17.8575	17.8575	17.8575	14000.0
2013-01-15 05:00:00	AAPL	Stock	17.8929	17.8929	17.875	17.875	8400.0
2013-01-15 06:00:00	AAPL	Stock	17.8557	17.875	17.8554	17.8746	55300.0
2013-01-15 07:00:00	AAPL	Stock	17.8754	17.9707	17.8668	17.9707	969612.0
2013-01-15 08:00:00	AAPL	Stock	17.9493	18.015	17.8661	17.9146	3032512.0
2013-01-15 09:00:00	AAPL	Stock	17.9186	17.9282	17.4382	17.5437	211636404.0
2013-01-15 10:00:00	AAPL	Stock	17.5496	17.5975	17.4554	17.4804	123422124.0
2013-01-15 11:00:00	AAPL	Stock	17.4814	17.4821	17.2821	17.2871	135562952.0
2013-01-15 12:00:00	AAPL	Stock	17.2857	17.5321	17.2786	17.4411	107058392.0
2013-01-15 13:00:00	AAPL	Stock	17.4411	17.5	17.3964	17.4114	58292276.0
2013-01-15 14:00:00	AAPL	Stock	17.4179	17.4375	17.3304	17.358	69803272.0
2013-01-15 15:00:00	AAPL	Stock	17.3586	17.4321	17.2636	17.3504	129394496.0
2013-01-15 16:00:00	AAPL	Stock	17.3543	17.4602	17.3164	17.3275	16970408.0
2013-01-15 17:00:00	AAPL	Stock	17.3279	17.5643	17.3214	17.5014	4657408.0
2013-01-15 18:00:00	AAPL	Stock	17.5082	17.5179	17.4746	17.5	1287076.0
2013-01-15 19:00:00	AAPL	Stock	17.5	17.5107	17.4793	17.4954	1268764.0
2013-01-15 07:00:00	MSFT	Stock	26.82	26.82	26.82	26.82	2400.0
2013-01-15 08:00:00	MSFT	Stock	26.83	26.9	26.77	26.8	26093.0
2013-01-15 09:00:00	MSFT	Stock	26.79	27.17	26.76	26.98	7044189.0
2013-01-15 10:00:00	MSFT	Stock	26.98	26.98	26.86	26.925	5729816.0
2013-01-15 11:00:00	MSFT	Stock	26.925	26.98	26.9	26.95	3665834.0
2013-01-15 12:00:00	MSFT	Stock	26.95	27.01	26.93	26.98	2834669.0
2013-01-15 13:00:00	MSFT	Stock	26.982	27.13	26.945	27.07	11574681.0
2013-01-15 14:00:00	MSFT	Stock	27.06	27.2	27.02	27.17	4834391.0
2013-01-15 15:00:00	MSFT	Stock	27.17	27.29	27.16	27.21	10093316.0
2013-01-15 16:00:00	MSFT	Stock	27.21	27.29	26.876	27.25	1626858.0
2013-01-15 17:00:00	MSFT	Stock	27.22	27.22	27.18	27.21	36274.0
2013-01-15 18:00:00	MSFT	Stock	26.99	27.22	26.99	27.21	5642.0
2013-01-15 19:00:00	MSFT	Stock	27.21	27.23	27.19	27.21	8816.0
2013-01-15 08:00:00	NVDA	Stock	0.3052	0.3052	0.3038	0.304	54000.0
2013-01-15 09:00:00	NVDA	Stock	0.3042	0.3045	0.3008	0.3012	39886080.0
2013-01-15 10:00:00	NVDA	Stock	0.301	0.3012	0.299	0.2995	57125840.0
2013-01-15 11:00:00	NVDA	Stock	0.2995	0.3018	0.2985	0.3	62245160.0
2013-01-15 12:00:00	NVDA	Stock	0.3	0.301	0.2995	0.3002	33200400.0
2013-01-15 13:00:00	NVDA	Stock	0.3	0.3005	0.2982	0.2982	44250800.0
2013-01-15 14:00:00	NVDA	Stock	0.2982	0.299	0.298	0.2986	48476760.0
2013-01-15 15:00:00	NVDA	Stock	0.2988	0.2995	0.2978	0.2992	75257080.0
2013-01-15 16:00:00	NVDA	Stock	0.299	0.305	0.2988	0.299	2798520.0
2013-01-15 17:00:00	NVDA	Stock	0.2992	0.3	0.2988	0.3	521000.0
2013-01-15 18:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	80000.0
2013-01-15 19:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	32000.0
2013-01-15 04:00:00	AMZN	Stock	13.69	13.69	13.69	13.69	6000.0
2013-01-15 06:00:00	AMZN	Stock	13.58	13.58	13.58	13.58	2000.0
2013-01-15 07:00:00	AMZN	Stock	13.6225	13.6225	13.5765	13.5765	15420.0
2013-01-15 08:00:00	AMZN	Stock	13.5955	13.6075	13.563	13.575	165460.0
2013-01-15 09:00:00	AMZN	Stock	13.57	13.6065	13.4705	13.522	7940600.0
2013-01-15 10:00:00	AMZN	Stock	13.511	13.5375	13.465	13.526	6797760.0
2013-01-15 11:00:00	AMZN	Stock	13.532	13.613	13.531	13.591	8053520.0
2013-01-15 12:00:00	AMZN	Stock	13.587	13.6365	13.5765	13.603	4013300.0
2013-01-15 13:00:00	AMZN	Stock	13.6015	13.6142	13.5285	13.536	6111000.0

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

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