PREVIEW / stock_1hour / 2010-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-12.parquet
  size:    902 KB
  rows:    43,010
  symbols: 3,480

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
2010-10-12 04:00:00	AAPL	Stock	10.5393	10.5393	10.4821	10.4821	8400.0
2010-10-12 05:00:00	AAPL	Stock	10.4286	10.4818	10.4286	10.4689	62552.0
2010-10-12 07:00:00	AAPL	Stock	10.4961	10.5371	10.4646	10.5357	515424.0
2010-10-12 08:00:00	AAPL	Stock	10.5375	10.5786	10.5229	10.5743	3645180.0
2010-10-12 09:00:00	AAPL	Stock	10.5721	10.5961	10.4461	10.485	107793084.0
2010-10-12 10:00:00	AAPL	Stock	10.485	10.6143	10.4821	10.6036	107168040.0
2010-10-12 11:00:00	AAPL	Stock	10.6032	10.6333	10.5914	10.6086	59738028.0
2010-10-12 12:00:00	AAPL	Stock	10.6082	10.6204	10.5975	10.6046	30165044.0
2010-10-12 13:00:00	AAPL	Stock	10.6052	10.6089	10.5932	10.6043	18133276.0
2010-10-12 14:00:00	AAPL	Stock	10.6057	10.6464	10.5893	10.6293	88334372.0
2010-10-12 15:00:00	AAPL	Stock	10.6282	10.6964	10.6071	10.6693	120150688.0
2010-10-12 16:00:00	AAPL	Stock	10.6693	10.6886	10.5399	10.6736	16636788.0
2010-10-12 17:00:00	AAPL	Stock	10.6746	10.6782	10.6693	10.675	718788.0
2010-10-12 18:00:00	AAPL	Stock	10.6725	10.6786	10.6621	10.6761	715932.0
2010-10-12 19:00:00	AAPL	Stock	10.6761	10.6871	10.6754	10.6868	811916.0
2010-10-12 07:00:00	MSFT	Stock	24.43	24.58	24.43	24.58	2600.0
2010-10-12 08:00:00	MSFT	Stock	24.56	24.6	24.5	24.57	28662.0
2010-10-12 09:00:00	MSFT	Stock	24.57	24.69	24.43	24.45	6777027.0
2010-10-12 10:00:00	MSFT	Stock	24.45	24.65	24.44	24.6	6664854.0
2010-10-12 11:00:00	MSFT	Stock	24.605	24.65	24.58	24.626	4121856.0
2010-10-12 12:00:00	MSFT	Stock	24.63	24.67	24.59	24.62	2659211.0
2010-10-12 13:00:00	MSFT	Stock	24.61	24.67	24.6	24.67	2701015.0
2010-10-12 14:00:00	MSFT	Stock	24.67	24.79	24.64	24.76	7629023.0
2010-10-12 15:00:00	MSFT	Stock	24.76	24.93	24.72	24.83	14609991.0
2010-10-12 16:00:00	MSFT	Stock	24.83	24.99	24.684	24.94	3660509.0
2010-10-12 17:00:00	MSFT	Stock	24.93	25.01	24.83	24.98	111660.0
2010-10-12 18:00:00	MSFT	Stock	24.98	25.0	24.83	25.0	69898.0
2010-10-12 19:00:00	MSFT	Stock	24.98	24.99	24.94	24.94	15997.0
2010-10-12 05:00:00	NVDA	Stock	0.2652	0.2652	0.264	0.264	44000.0
2010-10-12 08:00:00	NVDA	Stock	0.2712	0.2715	0.265	0.265	36000.0
2010-10-12 09:00:00	NVDA	Stock	0.2675	0.2703	0.2658	0.2683	84601480.0
2010-10-12 10:00:00	NVDA	Stock	0.2684	0.2755	0.268	0.2755	156986440.0
2010-10-12 11:00:00	NVDA	Stock	0.2752	0.2755	0.2735	0.2741	71562360.0
2010-10-12 12:00:00	NVDA	Stock	0.2743	0.2755	0.2738	0.2748	50330080.0
2010-10-12 13:00:00	NVDA	Stock	0.2748	0.275	0.274	0.2748	19476400.0
2010-10-12 14:00:00	NVDA	Stock	0.2745	0.2763	0.2738	0.2752	76257240.0
2010-10-12 15:00:00	NVDA	Stock	0.2752	0.2768	0.2745	0.2758	102370800.0
2010-10-12 16:00:00	NVDA	Stock	0.2755	0.2792	0.2734	0.2734	19811680.0
2010-10-12 17:00:00	NVDA	Stock	0.2763	0.2763	0.2758	0.2763	369600.0
2010-10-12 18:00:00	NVDA	Stock	0.2763	0.2765	0.2763	0.2765	128000.0
2010-10-12 19:00:00	NVDA	Stock	0.2765	0.2765	0.2752	0.2752	457480.0
2010-10-12 04:00:00	AMZN	Stock	7.627	7.627	7.627	7.627	2000.0
2010-10-12 06:00:00	AMZN	Stock	7.6275	7.6275	7.6275	7.6275	2000.0
2010-10-12 07:00:00	AMZN	Stock	7.62	7.6335	7.62	7.6335	6000.0
2010-10-12 08:00:00	AMZN	Stock	7.6145	7.6515	7.61	7.6515	86420.0
2010-10-12 09:00:00	AMZN	Stock	7.66	7.66	7.57	7.5845	17011780.0
2010-10-12 10:00:00	AMZN	Stock	7.581	7.746	7.579	7.7275	20475160.0
2010-10-12 11:00:00	AMZN	Stock	7.729	7.75	7.7045	7.742	8302260.0
2010-10-12 12:00:00	AMZN	Stock	7.7425	7.759	7.716	7.74	8114180.0
2010-10-12 13:00:00	AMZN	Stock	7.74	7.7845	7.731	7.779	8079480.0

> showing 50 of 43,010 rows — these rows as CSV

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