PREVIEW / stock_1hour / 2011-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-03.parquet
  size:    926 KB
  rows:    44,124
  symbols: 3,522

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-02-03 06:00:00	AAPL	Stock	12.2911	12.2911	12.2911	12.2911	2800.0
2011-02-03 07:00:00	AAPL	Stock	12.2664	12.2775	12.2607	12.2621	91000.0
2011-02-03 08:00:00	AAPL	Stock	12.2711	12.2821	12.2386	12.2679	1269352.0
2011-02-03 09:00:00	AAPL	Stock	12.2643	12.2857	12.2349	12.245	40278868.0
2011-02-03 10:00:00	AAPL	Stock	12.2436	12.2564	12.0911	12.1875	130290496.0
2011-02-03 11:00:00	AAPL	Stock	12.1889	12.2668	12.1625	12.2536	65718744.0
2011-02-03 12:00:00	AAPL	Stock	12.2536	12.2668	12.2339	12.2621	33088328.0
2011-02-03 13:00:00	AAPL	Stock	12.2611	12.2654	12.2164	12.2411	29795752.0
2011-02-03 14:00:00	AAPL	Stock	12.2404	12.2782	12.2325	12.2701	32864944.0
2011-02-03 15:00:00	AAPL	Stock	12.2689	12.2943	12.2632	12.2646	49812504.0
2011-02-03 16:00:00	AAPL	Stock	12.2657	12.2711	12.2197	12.2632	5107340.0
2011-02-03 17:00:00	AAPL	Stock	12.2625	12.2643	12.2589	12.2589	264852.0
2011-02-03 18:00:00	AAPL	Stock	12.2607	12.2657	12.25	12.2504	276472.0
2011-02-03 19:00:00	AAPL	Stock	12.2514	12.2571	12.2361	12.25	320320.0
2011-02-03 04:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	100.0
2011-02-03 07:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	400.0
2011-02-03 08:00:00	MSFT	Stock	27.92	28.11	27.92	28.11	58783.0
2011-02-03 09:00:00	MSFT	Stock	28.1	28.12	27.65	27.71	5852435.0
2011-02-03 10:00:00	MSFT	Stock	27.715	27.75	27.54	27.71	8291110.0
2011-02-03 11:00:00	MSFT	Stock	27.718	27.73	27.58	27.64	8807588.0
2011-02-03 12:00:00	MSFT	Stock	27.631	27.695	27.59	27.62	5424534.0
2011-02-03 13:00:00	MSFT	Stock	27.62	27.62	27.58	27.6	4536651.0
2011-02-03 14:00:00	MSFT	Stock	27.6	27.64	27.58	27.59	5043916.0
2011-02-03 15:00:00	MSFT	Stock	27.59	27.74	27.58	27.65	17481448.0
2011-02-03 16:00:00	MSFT	Stock	27.65	27.7	27.64	27.66	4300891.0
2011-02-03 17:00:00	MSFT	Stock	27.95	27.95	27.65	27.68	10200.0
2011-02-03 18:00:00	MSFT	Stock	27.65	27.68	27.65	27.65	16024.0
2011-02-03 19:00:00	MSFT	Stock	27.67	27.67	27.65	27.67	6690.0
2011-02-03 07:00:00	NVDA	Stock	0.6362	0.6375	0.6362	0.6375	12000.0
2011-02-03 08:00:00	NVDA	Stock	0.6388	0.6435	0.6385	0.6425	652640.0
2011-02-03 09:00:00	NVDA	Stock	0.6423	0.6425	0.6293	0.632	112890360.0
2011-02-03 10:00:00	NVDA	Stock	0.6322	0.6335	0.6213	0.6273	234231360.0
2011-02-03 11:00:00	NVDA	Stock	0.6273	0.6273	0.6145	0.6228	196146680.0
2011-02-03 12:00:00	NVDA	Stock	0.6228	0.627	0.6202	0.6217	86724640.0
2011-02-03 13:00:00	NVDA	Stock	0.6218	0.622	0.6138	0.6168	97087720.0
2011-02-03 14:00:00	NVDA	Stock	0.617	0.624	0.6168	0.6218	88139600.0
2011-02-03 15:00:00	NVDA	Stock	0.622	0.629	0.6218	0.6278	201005480.0
2011-02-03 16:00:00	NVDA	Stock	0.6273	0.6298	0.6226	0.625	3071360.0
2011-02-03 17:00:00	NVDA	Stock	0.627	0.627	0.625	0.627	60000.0
2011-02-03 18:00:00	NVDA	Stock	0.6275	0.6275	0.6263	0.6275	68000.0
2011-02-03 19:00:00	NVDA	Stock	0.627	0.628	0.6265	0.627	306800.0
2011-02-03 08:00:00	AMZN	Stock	8.679	8.679	8.63	8.67	93420.0
2011-02-03 09:00:00	AMZN	Stock	8.67	8.7335	8.639	8.64	13217840.0
2011-02-03 10:00:00	AMZN	Stock	8.6445	8.662	8.6025	8.6228	19422880.0
2011-02-03 11:00:00	AMZN	Stock	8.6245	8.7105	8.5975	8.691	12162820.0
2011-02-03 12:00:00	AMZN	Stock	8.687	8.71	8.6505	8.679	5894560.0
2011-02-03 13:00:00	AMZN	Stock	8.6809	8.686	8.657	8.6855	4496300.0
2011-02-03 14:00:00	AMZN	Stock	8.6835	8.705	8.6775	8.692	5941900.0
2011-02-03 15:00:00	AMZN	Stock	8.69	8.7215	8.6775	8.6855	10186520.0
2011-02-03 16:00:00	AMZN	Stock	8.6855	8.69	8.6668	8.6805	1090200.0

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

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