PREVIEW / stock_1hour / 2012-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-05.parquet
  size:    933 KB
  rows:    44,043
  symbols: 3,492

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-03-05 04:00:00	AAPL	Stock	19.4107	19.4436	19.4107	19.4436	13020.0
2012-03-05 05:00:00	AAPL	Stock	19.4546	19.4643	19.4546	19.4643	22400.0
2012-03-05 06:00:00	AAPL	Stock	19.4786	19.4904	19.4679	19.4679	55552.0
2012-03-05 07:00:00	AAPL	Stock	19.4643	19.4643	19.4339	19.4554	343588.0
2012-03-05 08:00:00	AAPL	Stock	19.4468	19.5057	19.4432	19.4929	3673180.0
2012-03-05 09:00:00	AAPL	Stock	19.4954	19.5529	19.4511	19.5052	68228748.0
2012-03-05 10:00:00	AAPL	Stock	19.506	19.5378	19.3968	19.4014	93479428.0
2012-03-05 11:00:00	AAPL	Stock	19.4035	19.4216	18.7857	19.1943	277443852.0
2012-03-05 12:00:00	AAPL	Stock	19.1964	19.275	19.0918	19.141	86280628.0
2012-03-05 13:00:00	AAPL	Stock	19.14	19.1814	18.9643	19.0271	74027772.0
2012-03-05 14:00:00	AAPL	Stock	19.0243	19.0804	18.9107	19.01	94398192.0
2012-03-05 15:00:00	AAPL	Stock	19.0104	19.1046	18.9689	19.0486	100068584.0
2012-03-05 16:00:00	AAPL	Stock	19.0414	19.1779	19.0085	19.075	5776008.0
2012-03-05 17:00:00	AAPL	Stock	19.0732	19.0768	19.0414	19.0464	844788.0
2012-03-05 18:00:00	AAPL	Stock	19.0529	19.0536	19.0054	19.0071	276640.0
2012-03-05 19:00:00	AAPL	Stock	19.0071	19.0189	18.9889	19.0071	917056.0
2012-03-05 04:00:00	MSFT	Stock	32.0	32.0	31.87	31.88	885.0
2012-03-05 07:00:00	MSFT	Stock	31.93	31.99	31.93	31.99	1500.0
2012-03-05 08:00:00	MSFT	Stock	31.99	32.15	31.98	32.01	10972.0
2012-03-05 09:00:00	MSFT	Stock	32.05	32.05	31.84	31.97	3613431.0
2012-03-05 10:00:00	MSFT	Stock	31.97	32.05	31.78	31.835	9070889.0
2012-03-05 11:00:00	MSFT	Stock	31.84	31.86	31.72	31.755	9567438.0
2012-03-05 12:00:00	MSFT	Stock	31.75	31.78	31.62	31.765	4228199.0
2012-03-05 13:00:00	MSFT	Stock	31.77	31.838	31.72	31.75	4230641.0
2012-03-05 14:00:00	MSFT	Stock	31.755	31.81	31.7	31.79	4526580.0
2012-03-05 15:00:00	MSFT	Stock	31.795	31.88	31.77	31.8	7485049.0
2012-03-05 16:00:00	MSFT	Stock	31.79	32.08	31.734	31.8	2233810.0
2012-03-05 17:00:00	MSFT	Stock	31.83	31.84	31.83	31.84	1800.0
2012-03-05 18:00:00	MSFT	Stock	31.87	31.88	31.87	31.88	1000.0
2012-03-05 19:00:00	MSFT	Stock	31.84	31.86	31.79	31.79	24538.0
2012-03-05 08:00:00	NVDA	Stock	0.3838	0.3838	0.3838	0.3838	16000.0
2012-03-05 09:00:00	NVDA	Stock	0.383	0.3833	0.3775	0.3784	57020600.0
2012-03-05 10:00:00	NVDA	Stock	0.3785	0.3785	0.3733	0.3755	131636600.0
2012-03-05 11:00:00	NVDA	Stock	0.3755	0.376	0.3725	0.373	74501320.0
2012-03-05 12:00:00	NVDA	Stock	0.3728	0.3733	0.3692	0.3699	60532000.0
2012-03-05 13:00:00	NVDA	Stock	0.37	0.3705	0.369	0.3692	47089920.0
2012-03-05 14:00:00	NVDA	Stock	0.369	0.3713	0.3688	0.371	46853320.0
2012-03-05 15:00:00	NVDA	Stock	0.371	0.3728	0.3708	0.3718	94696120.0
2012-03-05 16:00:00	NVDA	Stock	0.3718	0.3845	0.3689	0.3721	1067640.0
2012-03-05 17:00:00	NVDA	Stock	0.3715	0.3723	0.3715	0.3723	484360.0
2012-03-05 18:00:00	NVDA	Stock	0.3723	0.3723	0.3723	0.3723	26000.0
2012-03-05 19:00:00	NVDA	Stock	0.3725	0.3745	0.3725	0.3745	238640.0
2012-03-05 07:00:00	AMZN	Stock	8.8845	8.929	8.8845	8.923	27000.0
2012-03-05 08:00:00	AMZN	Stock	8.944	8.95	8.9205	8.95	84000.0
2012-03-05 09:00:00	AMZN	Stock	8.956	9.0875	8.909	9.0535	17500820.0
2012-03-05 10:00:00	AMZN	Stock	9.05	9.091	8.977	8.9905	20524140.0
2012-03-05 11:00:00	AMZN	Stock	8.9905	9.038	8.935	9.005	15901960.0
2012-03-05 12:00:00	AMZN	Stock	9.0025	9.055	8.9795	8.993	7815500.0
2012-03-05 13:00:00	AMZN	Stock	8.993	9.0225	8.9845	9.016	7940320.0
2012-03-05 14:00:00	AMZN	Stock	9.016	9.057	9.001	9.0505	7596260.0

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

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