PREVIEW / stock_1hour / 2012-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-03.parquet
  size:    638 KB
  rows:    27,731
  symbols: 3,440

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-07-03 04:00:00	AAPL	Stock	21.1789	21.2379	21.1789	21.2143	96600.0
2012-07-03 05:00:00	AAPL	Stock	21.2111	21.2357	21.2071	21.2071	14000.0
2012-07-03 06:00:00	AAPL	Stock	21.2214	21.2214	21.2089	21.2143	50820.0
2012-07-03 07:00:00	AAPL	Stock	21.2143	21.2486	21.1857	21.2446	444304.0
2012-07-03 08:00:00	AAPL	Stock	21.2321	21.2607	21.1857	21.2429	2268252.0
2012-07-03 09:00:00	AAPL	Stock	21.2464	21.3343	21.2143	21.3289	63083188.0
2012-07-03 10:00:00	AAPL	Stock	21.3282	21.4089	21.3086	21.3867	70940296.0
2012-07-03 11:00:00	AAPL	Stock	21.3875	21.4286	21.3768	21.39	52846136.0
2012-07-03 12:00:00	AAPL	Stock	21.3921	21.4136	21.3714	21.4071	45114944.0
2012-07-03 13:00:00	AAPL	Stock	21.4075	21.4143	21.3964	21.4046	4475044.0
2012-07-03 14:00:00	AAPL	Stock	21.4075	21.4125	21.4046	21.4046	237468.0
2012-07-03 15:00:00	AAPL	Stock	21.405	21.4107	21.405	21.4089	145544.0
2012-07-03 16:00:00	AAPL	Stock	21.4064	21.4107	21.4036	21.4071	205436.0
2012-07-03 05:00:00	MSFT	Stock	29.99	29.99	29.99	29.99	100.0
2012-07-03 06:00:00	MSFT	Stock	30.06	30.11	30.06	30.11	200.0
2012-07-03 07:00:00	MSFT	Stock	30.11	30.19	30.05	30.14	18187.0
2012-07-03 08:00:00	MSFT	Stock	30.14	30.35	30.07	30.18	98584.0
2012-07-03 09:00:00	MSFT	Stock	30.18	30.46	30.12	30.311	3758408.0
2012-07-03 10:00:00	MSFT	Stock	30.32	30.53	30.312	30.49	4121910.0
2012-07-03 11:00:00	MSFT	Stock	30.49	30.64	30.47	30.54	4542208.0
2012-07-03 12:00:00	MSFT	Stock	30.55	30.76	30.545	30.76	7010121.0
2012-07-03 13:00:00	MSFT	Stock	30.76	30.79	30.528	30.72	1130388.0
2012-07-03 14:00:00	MSFT	Stock	30.76	30.76	30.67	30.71	19942.0
2012-07-03 15:00:00	MSFT	Stock	30.71	30.75	30.71	30.75	2350.0
2012-07-03 16:00:00	MSFT	Stock	30.65	30.65	30.64	30.64	495.0
2012-07-03 07:00:00	NVDA	Stock	0.3402	0.3402	0.3378	0.3378	14000.0
2012-07-03 08:00:00	NVDA	Stock	0.3375	0.3388	0.3375	0.3375	174000.0
2012-07-03 09:00:00	NVDA	Stock	0.3358	0.3415	0.3338	0.3408	28808920.0
2012-07-03 10:00:00	NVDA	Stock	0.341	0.3456	0.341	0.345	56186400.0
2012-07-03 11:00:00	NVDA	Stock	0.345	0.3453	0.343	0.345	41333920.0
2012-07-03 12:00:00	NVDA	Stock	0.3448	0.3458	0.3438	0.345	81813240.0
2012-07-03 13:00:00	NVDA	Stock	0.3453	0.3453	0.3436	0.345	8799640.0
2012-07-03 14:00:00	NVDA	Stock	0.3453	0.3453	0.3445	0.3448	1537160.0
2012-07-03 15:00:00	NVDA	Stock	0.3455	0.3455	0.345	0.345	28000.0
2012-07-03 07:00:00	AMZN	Stock	11.4735	11.4735	11.4735	11.4735	4000.0
2012-07-03 08:00:00	AMZN	Stock	11.461	11.475	11.425	11.46	134000.0
2012-07-03 09:00:00	AMZN	Stock	11.454	11.465	11.4	11.4205	5692540.0
2012-07-03 10:00:00	AMZN	Stock	11.428	11.45	11.384	11.3905	7107480.0
2012-07-03 11:00:00	AMZN	Stock	11.388	11.446	11.3795	11.389	4982340.0
2012-07-03 12:00:00	AMZN	Stock	11.3915	11.4765	11.384	11.4765	6263560.0
2012-07-03 13:00:00	AMZN	Stock	11.4765	11.4815	11.4203	11.4385	1324640.0
2012-07-03 14:00:00	AMZN	Stock	11.4765	11.4765	11.4545	11.4545	40060.0
2012-07-03 15:00:00	AMZN	Stock	11.472	11.4745	11.4625	11.463	86160.0
2012-07-03 04:00:00	META	Stock	30.53	30.72	30.53	30.72	2899.0
2012-07-03 07:00:00	META	Stock	30.88	30.98	30.88	30.95	6246.0
2012-07-03 08:00:00	META	Stock	30.92	30.96	30.85	30.9	19123.0
2012-07-03 09:00:00	META	Stock	30.9	31.39	30.8	31.38	2421926.0
2012-07-03 10:00:00	META	Stock	31.37	31.44	30.91	31.06	2810187.0
2012-07-03 11:00:00	META	Stock	31.05	31.17	31.02	31.059	1055088.0
2012-07-03 12:00:00	META	Stock	31.05	31.3	31.0	31.2	2276340.0

> showing 50 of 27,731 rows — these rows as CSV

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