PREVIEW / stock_1hour / 2010-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-22.parquet
  size:    894 KB
  rows:    42,675
  symbols: 3,475

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-09-22 05:00:00	AAPL	Stock	10.125	10.125	10.0914	10.0946	22400.0
2010-09-22 06:00:00	AAPL	Stock	10.1018	10.1018	10.1018	10.1018	14000.0
2010-09-22 07:00:00	AAPL	Stock	10.1	10.125	10.0889	10.0946	325584.0
2010-09-22 08:00:00	AAPL	Stock	10.0914	10.1107	10.0754	10.0857	2491076.0
2010-09-22 09:00:00	AAPL	Stock	10.0861	10.285	10.0836	10.2614	133199164.0
2010-09-22 10:00:00	AAPL	Stock	10.2618	10.275	10.1843	10.2314	133580216.0
2010-09-22 11:00:00	AAPL	Stock	10.2318	10.2382	10.1875	10.2357	57092308.0
2010-09-22 12:00:00	AAPL	Stock	10.2354	10.25	10.2146	10.225	40191564.0
2010-09-22 13:00:00	AAPL	Stock	10.225	10.2579	10.2089	10.2436	55128892.0
2010-09-22 14:00:00	AAPL	Stock	10.2425	10.2757	10.2186	10.2693	58531368.0
2010-09-22 15:00:00	AAPL	Stock	10.2696	10.2768	10.2379	10.2764	76378092.0
2010-09-22 16:00:00	AAPL	Stock	10.2768	10.2836	10.2125	10.2821	14785960.0
2010-09-22 17:00:00	AAPL	Stock	10.1012	10.2875	10.1012	10.2839	615860.0
2010-09-22 18:00:00	AAPL	Stock	10.2839	10.2857	10.2768	10.2804	817040.0
2010-09-22 19:00:00	AAPL	Stock	10.2779	10.285	10.2779	10.285	144900.0
2010-09-22 04:00:00	MSFT	Stock	25.34	25.34	25.06	25.06	16750.0
2010-09-22 05:00:00	MSFT	Stock	25.07	25.12	25.01	25.01	3400.0
2010-09-22 06:00:00	MSFT	Stock	25.06	25.06	24.98	24.98	9000.0
2010-09-22 07:00:00	MSFT	Stock	25.09	25.09	24.84	24.9	86235.0
2010-09-22 08:00:00	MSFT	Stock	24.9	24.95	24.83	24.86	182065.0
2010-09-22 09:00:00	MSFT	Stock	24.88	24.97	24.66	24.67	17185578.0
2010-09-22 10:00:00	MSFT	Stock	24.67	24.68	24.5	24.57	20500902.0
2010-09-22 11:00:00	MSFT	Stock	24.565	24.57	24.36	24.455	14191121.0
2010-09-22 12:00:00	MSFT	Stock	24.455	24.5	24.38	24.4	8480211.0
2010-09-22 13:00:00	MSFT	Stock	24.405	24.5	24.38	24.46	6568667.0
2010-09-22 14:00:00	MSFT	Stock	24.46	24.51	24.4	24.457	6398614.0
2010-09-22 15:00:00	MSFT	Stock	24.456	24.61	24.45	24.61	14431224.0
2010-09-22 16:00:00	MSFT	Stock	24.61	25.16	24.468	24.6	3383254.0
2010-09-22 17:00:00	MSFT	Stock	25.042	25.042	24.58	24.63	43288.0
2010-09-22 18:00:00	MSFT	Stock	24.63	24.63	24.6	24.63	52833.0
2010-09-22 19:00:00	MSFT	Stock	24.61	24.63	24.61	24.63	11473.0
2010-09-22 08:00:00	NVDA	Stock	0.2778	0.2822	0.2778	0.282	350120.0
2010-09-22 09:00:00	NVDA	Stock	0.2825	0.2872	0.2795	0.2842	183760040.0
2010-09-22 10:00:00	NVDA	Stock	0.2842	0.2846	0.2808	0.2812	246986880.0
2010-09-22 11:00:00	NVDA	Stock	0.2814	0.283	0.2804	0.2822	135183120.0
2010-09-22 12:00:00	NVDA	Stock	0.2822	0.2835	0.281	0.2812	68774680.0
2010-09-22 13:00:00	NVDA	Stock	0.2812	0.2838	0.2805	0.2838	75119560.0
2010-09-22 14:00:00	NVDA	Stock	0.2836	0.2858	0.2825	0.285	98907440.0
2010-09-22 15:00:00	NVDA	Stock	0.285	0.2855	0.283	0.2854	175122080.0
2010-09-22 16:00:00	NVDA	Stock	0.2852	0.2852	0.282	0.2828	4855600.0
2010-09-22 17:00:00	NVDA	Stock	0.2807	0.2807	0.2807	0.2807	74760.0
2010-09-22 18:00:00	NVDA	Stock	0.2848	0.2862	0.284	0.284	327200.0
2010-09-22 19:00:00	NVDA	Stock	0.2858	0.2858	0.285	0.285	61000.0
2010-09-22 04:00:00	AMZN	Stock	7.4745	7.4825	7.4745	7.4825	14900.0
2010-09-22 07:00:00	AMZN	Stock	7.4825	7.4865	7.4825	7.485	74160.0
2010-09-22 08:00:00	AMZN	Stock	7.4995	7.5	7.475	7.475	306200.0
2010-09-22 09:00:00	AMZN	Stock	7.49	7.5695	7.455	7.526	22972900.0
2010-09-22 10:00:00	AMZN	Stock	7.526	7.5475	7.46	7.5215	23799780.0
2010-09-22 11:00:00	AMZN	Stock	7.5245	7.5835	7.4995	7.579	17645180.0
2010-09-22 12:00:00	AMZN	Stock	7.5785	7.5885	7.546	7.5615	9851080.0

> showing 50 of 42,675 rows — these rows as CSV

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