PREVIEW / stock_1hour / 2010-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-13.parquet
  size:    944 KB
  rows:    45,806
  symbols: 3,502

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-13 04:00:00	AAPL	Stock	10.7257	10.7339	10.7257	10.7339	9940.0
2010-10-13 05:00:00	AAPL	Stock	10.7679	10.7679	10.7679	10.7679	4200.0
2010-10-13 06:00:00	AAPL	Stock	10.7621	10.7621	10.7621	10.7621	9884.0
2010-10-13 07:00:00	AAPL	Stock	10.7596	10.7743	10.7143	10.7468	1483188.0
2010-10-13 08:00:00	AAPL	Stock	10.7468	10.7714	10.725	10.7486	6177948.0
2010-10-13 09:00:00	AAPL	Stock	10.7482	10.7757	10.7143	10.7586	109675412.0
2010-10-13 10:00:00	AAPL	Stock	10.7589	10.7779	10.7325	10.7621	93340548.0
2010-10-13 11:00:00	AAPL	Stock	10.7613	10.7843	10.745	10.7636	67604040.0
2010-10-13 12:00:00	AAPL	Stock	10.7636	10.7686	10.7429	10.7461	36438416.0
2010-10-13 13:00:00	AAPL	Stock	10.7469	10.7536	10.7143	10.7396	64177176.0
2010-10-13 14:00:00	AAPL	Stock	10.74	10.7571	10.7071	10.7371	71271312.0
2010-10-13 15:00:00	AAPL	Stock	10.7368	10.7536	10.7118	10.7171	82323640.0
2010-10-13 16:00:00	AAPL	Stock	10.7193	11.0628	10.7171	10.7541	70587412.0
2010-10-13 17:00:00	AAPL	Stock	10.7229	10.7232	10.7146	10.7154	1062740.0
2010-10-13 18:00:00	AAPL	Stock	10.7154	10.7196	10.7104	10.7132	857976.0
2010-10-13 19:00:00	AAPL	Stock	10.7132	10.7286	10.7111	10.7143	540652.0
2010-10-13 20:00:00	AAPL	Stock	10.6736	10.6736	10.6736	10.6736	6816600.0
2010-10-13 04:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	200.0
2010-10-13 05:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	100.0
2010-10-13 07:00:00	MSFT	Stock	25.05	25.1	25.05	25.05	5860.0
2010-10-13 08:00:00	MSFT	Stock	25.03	25.07	25.02	25.05	48878.0
2010-10-13 09:00:00	MSFT	Stock	25.05	25.09	24.96	24.97	8915386.0
2010-10-13 10:00:00	MSFT	Stock	24.975	25.07	24.89	25.07	8265683.0
2010-10-13 11:00:00	MSFT	Stock	25.07	25.17	25.04	25.165	7133785.0
2010-10-13 12:00:00	MSFT	Stock	25.17	25.255	25.15	25.24	6879391.0
2010-10-13 13:00:00	MSFT	Stock	25.23	25.3	25.16	25.3	7033939.0
2010-10-13 14:00:00	MSFT	Stock	25.3	25.41	25.29	25.408	11309818.0
2010-10-13 15:00:00	MSFT	Stock	25.4	25.54	25.31	25.31	21208244.0
2010-10-13 16:00:00	MSFT	Stock	25.31	25.46	24.961	25.33	3367949.0
2010-10-13 17:00:00	MSFT	Stock	24.83	25.34	24.83	25.34	68974.0
2010-10-13 18:00:00	MSFT	Stock	25.33	25.34	25.32	25.33	57896.0
2010-10-13 19:00:00	MSFT	Stock	25.34	25.35	25.3	25.3	24150.0
2010-10-13 20:00:00	MSFT	Stock	24.95	24.95	24.95	24.95	137900.0
2010-10-13 08:00:00	NVDA	Stock	0.2778	0.2798	0.2775	0.2798	528000.0
2010-10-13 09:00:00	NVDA	Stock	0.279	0.2806	0.277	0.2806	122418280.0
2010-10-13 10:00:00	NVDA	Stock	0.2805	0.2848	0.2805	0.284	210267320.0
2010-10-13 11:00:00	NVDA	Stock	0.284	0.2845	0.2818	0.2845	75021600.0
2010-10-13 12:00:00	NVDA	Stock	0.2845	0.2872	0.2838	0.2868	125112800.0
2010-10-13 13:00:00	NVDA	Stock	0.2865	0.2868	0.285	0.2858	117948040.0
2010-10-13 14:00:00	NVDA	Stock	0.2858	0.2875	0.2858	0.2869	114971360.0
2010-10-13 15:00:00	NVDA	Stock	0.287	0.287	0.283	0.2835	175013040.0
2010-10-13 16:00:00	NVDA	Stock	0.2835	0.285	0.2832	0.2849	18366080.0
2010-10-13 17:00:00	NVDA	Stock	0.2758	0.2835	0.2758	0.2825	543600.0
2010-10-13 18:00:00	NVDA	Stock	0.2835	0.2842	0.283	0.283	82400.0
2010-10-13 07:00:00	AMZN	Stock	7.8565	7.9125	7.8565	7.87	59800.0
2010-10-13 08:00:00	AMZN	Stock	7.87	8.0	7.8445	7.8865	357780.0
2010-10-13 09:00:00	AMZN	Stock	7.8865	7.889	7.751	7.775	21041480.0
2010-10-13 10:00:00	AMZN	Stock	7.776	7.7995	7.74	7.7766	15920880.0
2010-10-13 11:00:00	AMZN	Stock	7.776	7.782	7.7275	7.7645	13997000.0
2010-10-13 12:00:00	AMZN	Stock	7.7638	7.7945	7.75	7.767	7524540.0

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

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