PREVIEW / stock_1hour / 2011-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-16.parquet
  size:    938 KB
  rows:    44,502
  symbols: 3,542

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
2011-09-16 04:00:00	AAPL	Stock	14.0604	14.0604	14.0129	14.035	42000.0
2011-09-16 05:00:00	AAPL	Stock	14.0479	14.1157	14.0446	14.1061	33600.0
2011-09-16 06:00:00	AAPL	Stock	14.1161	14.1429	14.1004	14.1004	22400.0
2011-09-16 07:00:00	AAPL	Stock	14.1143	14.1429	14.0839	14.1161	665000.0
2011-09-16 08:00:00	AAPL	Stock	14.1125	14.1414	14.0857	14.1196	2955876.0
2011-09-16 09:00:00	AAPL	Stock	14.1196	14.2725	14.105	14.2582	163985696.0
2011-09-16 10:00:00	AAPL	Stock	14.2579	14.2811	14.1904	14.2131	109308276.0
2011-09-16 11:00:00	AAPL	Stock	14.2143	14.2679	14.2071	14.2454	63668724.0
2011-09-16 12:00:00	AAPL	Stock	14.2479	14.2832	14.2418	14.2778	50828204.0
2011-09-16 13:00:00	AAPL	Stock	14.2786	14.2804	14.2387	14.2539	43813112.0
2011-09-16 14:00:00	AAPL	Stock	14.255	14.2836	14.2432	14.2793	45257072.0
2011-09-16 15:00:00	AAPL	Stock	14.2804	14.2986	14.2507	14.2943	132394108.0
2011-09-16 16:00:00	AAPL	Stock	14.2948	14.3039	14.1933	14.2886	60785340.0
2011-09-16 17:00:00	AAPL	Stock	14.2868	14.3036	14.2746	14.2925	1246084.0
2011-09-16 18:00:00	AAPL	Stock	14.2868	14.335	14.2868	14.3107	1730652.0
2011-09-16 19:00:00	AAPL	Stock	14.3143	14.3214	14.2857	14.2964	599424.0
2011-09-16 05:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	100.0
2011-09-16 07:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2011-09-16 08:00:00	MSFT	Stock	26.91	26.96	26.9	26.96	19800.0
2011-09-16 09:00:00	MSFT	Stock	26.96	27.15	26.83	27.07	25324079.0
2011-09-16 10:00:00	MSFT	Stock	27.08	27.15	26.975	27.03	9398413.0
2011-09-16 11:00:00	MSFT	Stock	27.025	27.16	27.01	27.16	5861701.0
2011-09-16 12:00:00	MSFT	Stock	27.16	27.24	27.125	27.18	5038548.0
2011-09-16 13:00:00	MSFT	Stock	27.185	27.25	27.16	27.17	5170538.0
2011-09-16 14:00:00	MSFT	Stock	27.18	27.27	27.17	27.26	4456579.0
2011-09-16 15:00:00	MSFT	Stock	27.27	27.27	27.11	27.12	15339172.0
2011-09-16 16:00:00	MSFT	Stock	27.12	27.21	27.06	27.12	16656615.0
2011-09-16 17:00:00	MSFT	Stock	27.07	27.122	27.07	27.07	989619.0
2011-09-16 18:00:00	MSFT	Stock	27.12	27.12	27.06	27.08	14631.0
2011-09-16 19:00:00	MSFT	Stock	27.1	27.12	27.05	27.05	1050.0
2011-09-16 07:00:00	NVDA	Stock	0.388	0.3888	0.388	0.3888	32000.0
2011-09-16 08:00:00	NVDA	Stock	0.3888	0.3888	0.3845	0.3882	650880.0
2011-09-16 09:00:00	NVDA	Stock	0.3882	0.395	0.385	0.3942	210776000.0
2011-09-16 10:00:00	NVDA	Stock	0.394	0.4025	0.3895	0.392	409640000.0
2011-09-16 11:00:00	NVDA	Stock	0.392	0.3932	0.3853	0.392	191396160.0
2011-09-16 12:00:00	NVDA	Stock	0.392	0.3942	0.3902	0.3932	58408200.0
2011-09-16 13:00:00	NVDA	Stock	0.3932	0.3935	0.3893	0.3893	84573960.0
2011-09-16 14:00:00	NVDA	Stock	0.3893	0.3908	0.3878	0.3902	76006080.0
2011-09-16 15:00:00	NVDA	Stock	0.3902	0.3902	0.3845	0.3865	264095280.0
2011-09-16 16:00:00	NVDA	Stock	0.3865	0.391	0.384	0.3855	26240000.0
2011-09-16 17:00:00	NVDA	Stock	0.385	0.3865	0.384	0.3845	1047840.0
2011-09-16 18:00:00	NVDA	Stock	0.3845	0.3873	0.3845	0.387	880200.0
2011-09-16 19:00:00	NVDA	Stock	0.387	0.3882	0.387	0.3882	815000.0
2011-09-16 07:00:00	AMZN	Stock	11.273	11.315	11.27	11.315	87980.0
2011-09-16 08:00:00	AMZN	Stock	11.325	11.34	11.295	11.314	140280.0
2011-09-16 09:00:00	AMZN	Stock	11.3245	11.5245	11.32	11.4945	43566320.0
2011-09-16 10:00:00	AMZN	Stock	11.497	11.5985	11.4885	11.5315	26636500.0
2011-09-16 11:00:00	AMZN	Stock	11.5305	11.715	11.529	11.671	25001300.0
2011-09-16 12:00:00	AMZN	Stock	11.675	11.7455	11.6485	11.72	17078240.0
2011-09-16 13:00:00	AMZN	Stock	11.721	11.772	11.7005	11.757	16239320.0

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

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