PREVIEW / stock_1hour / 2012-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-07.parquet
  size:    946 KB
  rows:    45,277
  symbols: 3,496

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-08-07 04:00:00	AAPL	Stock	22.3029	22.3246	22.3029	22.3125	30184.0
2012-08-07 05:00:00	AAPL	Stock	22.3071	22.3071	22.3	22.3	10416.0
2012-08-07 06:00:00	AAPL	Stock	22.2857	22.2946	22.2857	22.2946	15400.0
2012-08-07 07:00:00	AAPL	Stock	22.2786	22.3125	22.2625	22.2639	486164.0
2012-08-07 08:00:00	AAPL	Stock	22.2786	22.3214	22.2718	22.2996	2376220.0
2012-08-07 09:00:00	AAPL	Stock	22.2961	22.3214	22.0729	22.1913	69136116.0
2012-08-07 10:00:00	AAPL	Stock	22.1914	22.2768	22.1304	22.1657	55648992.0
2012-08-07 11:00:00	AAPL	Stock	22.1661	22.2746	22.125	22.2611	33466748.0
2012-08-07 12:00:00	AAPL	Stock	22.2607	22.3125	22.2411	22.25	31897208.0
2012-08-07 13:00:00	AAPL	Stock	22.2472	22.2661	22.2032	22.2089	18458412.0
2012-08-07 14:00:00	AAPL	Stock	22.2111	22.2357	22.1882	22.2104	14518644.0
2012-08-07 15:00:00	AAPL	Stock	22.2089	22.2157	22.1325	22.1775	46138988.0
2012-08-07 16:00:00	AAPL	Stock	22.1825	22.1907	22.1668	22.1668	6314644.0
2012-08-07 17:00:00	AAPL	Stock	22.1757	22.1764	22.1543	22.1571	215880.0
2012-08-07 18:00:00	AAPL	Stock	22.1571	22.1714	22.1571	22.1714	49000.0
2012-08-07 19:00:00	AAPL	Stock	22.1707	22.1707	22.1607	22.1607	68264.0
2012-08-07 05:00:00	MSFT	Stock	30.0	30.0	30.0	30.0	160.0
2012-08-07 07:00:00	MSFT	Stock	29.89	29.89	29.89	29.89	1000.0
2012-08-07 08:00:00	MSFT	Stock	29.98	30.05	29.95	30.04	56850.0
2012-08-07 09:00:00	MSFT	Stock	30.04	30.15	29.87	30.02	3567876.0
2012-08-07 10:00:00	MSFT	Stock	30.02	30.265	30.01	30.22	4505701.0
2012-08-07 11:00:00	MSFT	Stock	30.228	30.325	30.18	30.31	3641417.0
2012-08-07 12:00:00	MSFT	Stock	30.3	30.34	30.26	30.319	3029586.0
2012-08-07 13:00:00	MSFT	Stock	30.31	30.34	30.26	30.32	2681779.0
2012-08-07 14:00:00	MSFT	Stock	30.32	30.35	30.28	30.32	2148373.0
2012-08-07 15:00:00	MSFT	Stock	30.32	30.33	30.2	30.25	6306009.0
2012-08-07 16:00:00	MSFT	Stock	30.26	30.316	30.2	30.28	1802858.0
2012-08-07 17:00:00	MSFT	Stock	30.21	30.26	30.2	30.26	1095.0
2012-08-07 18:00:00	MSFT	Stock	30.26	30.26	30.26	30.26	300.0
2012-08-07 19:00:00	MSFT	Stock	30.22	30.26	30.22	30.22	520.0
2012-08-07 07:00:00	NVDA	Stock	0.3555	0.356	0.3555	0.356	40000.0
2012-08-07 08:00:00	NVDA	Stock	0.3508	0.3525	0.3508	0.3525	8000.0
2012-08-07 09:00:00	NVDA	Stock	0.354	0.355	0.352	0.3539	52791440.0
2012-08-07 10:00:00	NVDA	Stock	0.3538	0.3545	0.3518	0.353	64769200.0
2012-08-07 11:00:00	NVDA	Stock	0.3528	0.355	0.3525	0.355	62983280.0
2012-08-07 12:00:00	NVDA	Stock	0.355	0.3575	0.3545	0.3572	48007360.0
2012-08-07 13:00:00	NVDA	Stock	0.357	0.3572	0.3553	0.356	27185280.0
2012-08-07 14:00:00	NVDA	Stock	0.356	0.3562	0.354	0.3545	47939920.0
2012-08-07 15:00:00	NVDA	Stock	0.3545	0.3548	0.353	0.3538	93273720.0
2012-08-07 16:00:00	NVDA	Stock	0.3538	0.3543	0.3502	0.354	9296920.0
2012-08-07 17:00:00	NVDA	Stock	0.3542	0.3558	0.3542	0.3542	113320.0
2012-08-07 18:00:00	NVDA	Stock	0.355	0.3553	0.355	0.3553	160000.0
2012-08-07 07:00:00	AMZN	Stock	11.7875	11.7875	11.736	11.737	18000.0
2012-08-07 08:00:00	AMZN	Stock	11.7135	11.796	11.7135	11.763	120200.0
2012-08-07 09:00:00	AMZN	Stock	11.7625	11.763	11.6625	11.7525	6535900.0
2012-08-07 10:00:00	AMZN	Stock	11.75	11.8165	11.7145	11.8165	8075800.0
2012-08-07 11:00:00	AMZN	Stock	11.811	11.888	11.766	11.877	7652140.0
2012-08-07 12:00:00	AMZN	Stock	11.874	11.9	11.85	11.8564	4607480.0
2012-08-07 13:00:00	AMZN	Stock	11.8565	11.865	11.8175	11.8302	2978840.0
2012-08-07 14:00:00	AMZN	Stock	11.834	11.8585	11.8195	11.841	2380260.0

> showing 50 of 45,277 rows — these rows as CSV

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