PREVIEW / stock_1hour / 2011-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-02.parquet
  size:    947 KB
  rows:    45,282
  symbols: 3,514

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-02 04:00:00	AAPL	Stock	12.3225	12.3496	12.3225	12.3496	8400.0
2011-02-02 05:00:00	AAPL	Stock	12.3393	12.3393	12.3286	12.3286	8400.0
2011-02-02 06:00:00	AAPL	Stock	12.3429	12.3429	12.3286	12.3286	33600.0
2011-02-02 07:00:00	AAPL	Stock	12.3314	12.3539	12.3214	12.3321	203112.0
2011-02-02 08:00:00	AAPL	Stock	12.3279	12.3279	12.2893	12.2961	1141000.0
2011-02-02 09:00:00	AAPL	Stock	12.2961	12.3304	12.2643	12.3057	48893376.0
2011-02-02 10:00:00	AAPL	Stock	12.3057	12.3179	12.2696	12.295	53320624.0
2011-02-02 11:00:00	AAPL	Stock	12.2957	12.3104	12.2725	12.3104	32453512.0
2011-02-02 12:00:00	AAPL	Stock	12.3104	12.3125	12.2911	12.3021	19826072.0
2011-02-02 13:00:00	AAPL	Stock	12.3032	12.3064	12.2807	12.2857	21023240.0
2011-02-02 14:00:00	AAPL	Stock	12.2879	12.3211	12.2839	12.3134	20998068.0
2011-02-02 15:00:00	AAPL	Stock	12.3129	12.3207	12.2707	12.2971	50860824.0
2011-02-02 16:00:00	AAPL	Stock	12.2971	12.3225	12.2769	12.29	5241012.0
2011-02-02 17:00:00	AAPL	Stock	12.2879	12.29	12.2857	12.2879	90300.0
2011-02-02 18:00:00	AAPL	Stock	12.2893	12.2971	12.2875	12.2882	93240.0
2011-02-02 19:00:00	AAPL	Stock	12.2875	12.2893	12.2821	12.285	210476.0
2011-02-02 04:00:00	MSFT	Stock	28.13	28.13	28.13	28.13	100.0
2011-02-02 05:00:00	MSFT	Stock	28.15	28.15	28.15	28.15	100.0
2011-02-02 07:00:00	MSFT	Stock	27.99	28.03	27.98	27.98	4000.0
2011-02-02 08:00:00	MSFT	Stock	27.97	28.05	27.85	27.91	27675.0
2011-02-02 09:00:00	MSFT	Stock	27.88	28.05	27.87	28.02	4860837.0
2011-02-02 10:00:00	MSFT	Stock	28.02	28.11	27.91	28.03	8110684.0
2011-02-02 11:00:00	MSFT	Stock	28.03	28.08	27.88	28.078	6416389.0
2011-02-02 12:00:00	MSFT	Stock	28.08	28.08	27.96	27.99	4499042.0
2011-02-02 13:00:00	MSFT	Stock	27.992	28.01	27.94	28.0	4929580.0
2011-02-02 14:00:00	MSFT	Stock	28.005	28.06	27.98	28.05	4600606.0
2011-02-02 15:00:00	MSFT	Stock	28.04	28.05	27.89	27.94	9695844.0
2011-02-02 16:00:00	MSFT	Stock	27.94	28.01	27.91	27.94	1350566.0
2011-02-02 17:00:00	MSFT	Stock	27.93	28.02	27.93	27.95	4402.0
2011-02-02 18:00:00	MSFT	Stock	27.94	27.94	27.93	27.93	7362.0
2011-02-02 19:00:00	MSFT	Stock	27.93	27.93	27.93	27.93	5200.0
2011-02-02 07:00:00	NVDA	Stock	0.611	0.611	0.611	0.611	6000.0
2011-02-02 08:00:00	NVDA	Stock	0.6115	0.6125	0.611	0.611	112000.0
2011-02-02 09:00:00	NVDA	Stock	0.612	0.62	0.608	0.6188	90274520.0
2011-02-02 10:00:00	NVDA	Stock	0.6188	0.6378	0.6143	0.633	340082040.0
2011-02-02 11:00:00	NVDA	Stock	0.6329	0.6473	0.6288	0.647	230466720.0
2011-02-02 12:00:00	NVDA	Stock	0.6468	0.6473	0.638	0.6402	138474160.0
2011-02-02 13:00:00	NVDA	Stock	0.6404	0.6543	0.6393	0.6508	249553760.0
2011-02-02 14:00:00	NVDA	Stock	0.6508	0.6535	0.6463	0.6503	210375360.0
2011-02-02 15:00:00	NVDA	Stock	0.6503	0.6515	0.6378	0.6398	327487680.0
2011-02-02 16:00:00	NVDA	Stock	0.6395	0.6438	0.6118	0.6412	14066520.0
2011-02-02 17:00:00	NVDA	Stock	0.6412	0.6412	0.6393	0.6398	173600.0
2011-02-02 18:00:00	NVDA	Stock	0.642	0.642	0.6393	0.6393	110320.0
2011-02-02 19:00:00	NVDA	Stock	0.6395	0.6402	0.639	0.6402	428000.0
2011-02-02 06:00:00	AMZN	Stock	8.6055	8.6055	8.6055	8.6055	2000.0
2011-02-02 08:00:00	AMZN	Stock	8.6	8.6	8.5715	8.5715	70060.0
2011-02-02 09:00:00	AMZN	Stock	8.5695	8.625	8.5435	8.595	10597000.0
2011-02-02 10:00:00	AMZN	Stock	8.595	8.66	8.5618	8.6225	13322840.0
2011-02-02 11:00:00	AMZN	Stock	8.62	8.65	8.5975	8.648	6433800.0
2011-02-02 12:00:00	AMZN	Stock	8.6475	8.709	8.626	8.694	12323980.0

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

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