PREVIEW / stock_1hour / 2010-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-02.parquet
  size:    931 KB
  rows:    44,427
  symbols: 3,531

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-12-02 04:00:00	AAPL	Stock	11.3539	11.3571	11.3464	11.3464	70000.0
2010-12-02 05:00:00	AAPL	Stock	11.3571	11.3571	11.3143	11.3143	36400.0
2010-12-02 06:00:00	AAPL	Stock	11.3261	11.3286	11.3214	11.3286	48048.0
2010-12-02 07:00:00	AAPL	Stock	11.3218	11.3736	11.3218	11.3736	555968.0
2010-12-02 08:00:00	AAPL	Stock	11.3629	11.375	11.3429	11.3479	6501152.0
2010-12-02 09:00:00	AAPL	Stock	11.3446	11.3929	11.3179	11.3525	79985444.0
2010-12-02 10:00:00	AAPL	Stock	11.3532	11.3786	11.2461	11.2939	106974364.0
2010-12-02 11:00:00	AAPL	Stock	11.2925	11.3375	11.2825	11.3336	48842612.0
2010-12-02 12:00:00	AAPL	Stock	11.3321	11.3414	11.3004	11.3354	27316324.0
2010-12-02 13:00:00	AAPL	Stock	11.3364	11.3732	11.3354	11.3671	39521412.0
2010-12-02 14:00:00	AAPL	Stock	11.3686	11.3886	11.3504	11.3511	47220180.0
2010-12-02 15:00:00	AAPL	Stock	11.3511	11.3896	11.3507	11.3618	82094292.0
2010-12-02 16:00:00	AAPL	Stock	11.3625	11.3729	11.3454	11.3561	19444236.0
2010-12-02 17:00:00	AAPL	Stock	11.3536	11.3625	11.3493	11.3582	412384.0
2010-12-02 18:00:00	AAPL	Stock	11.3571	11.3625	11.3536	11.36	82320.0
2010-12-02 19:00:00	AAPL	Stock	11.3564	11.3714	11.3486	11.3686	662760.0
2010-12-02 04:00:00	MSFT	Stock	26.0	26.11	26.0	26.11	200.0
2010-12-02 05:00:00	MSFT	Stock	26.1	26.17	26.1	26.17	200.0
2010-12-02 07:00:00	MSFT	Stock	26.05	26.19	26.02	26.09	10900.0
2010-12-02 08:00:00	MSFT	Stock	26.11	26.19	26.1	26.1	78867.0
2010-12-02 09:00:00	MSFT	Stock	26.09	26.66	26.05	26.66	12803343.0
2010-12-02 10:00:00	MSFT	Stock	26.66	26.92	26.55	26.63	27797174.0
2010-12-02 11:00:00	MSFT	Stock	26.62	26.98	26.6	26.88	11312158.0
2010-12-02 12:00:00	MSFT	Stock	26.88	26.91	26.78	26.78	6575974.0
2010-12-02 13:00:00	MSFT	Stock	26.785	26.79	26.7	26.76	4718108.0
2010-12-02 14:00:00	MSFT	Stock	26.75	26.86	26.72	26.856	5449845.0
2010-12-02 15:00:00	MSFT	Stock	26.855	26.91	26.78	26.9	13349289.0
2010-12-02 16:00:00	MSFT	Stock	26.9	26.91	26.718	26.89	4215131.0
2010-12-02 17:00:00	MSFT	Stock	26.89	26.9	26.88	26.89	10614.0
2010-12-02 18:00:00	MSFT	Stock	26.89	26.9	26.88	26.88	32388.0
2010-12-02 19:00:00	MSFT	Stock	26.88	26.89	26.87	26.89	6316.0
2010-12-02 08:00:00	NVDA	Stock	0.3553	0.361	0.3553	0.3565	63600.0
2010-12-02 09:00:00	NVDA	Stock	0.3578	0.3592	0.355	0.3582	62784320.0
2010-12-02 10:00:00	NVDA	Stock	0.3582	0.36	0.3578	0.3581	84681960.0
2010-12-02 11:00:00	NVDA	Stock	0.3582	0.3608	0.3578	0.359	57544320.0
2010-12-02 12:00:00	NVDA	Stock	0.359	0.3592	0.3568	0.3585	67213560.0
2010-12-02 13:00:00	NVDA	Stock	0.3585	0.3592	0.3578	0.3589	68021000.0
2010-12-02 14:00:00	NVDA	Stock	0.359	0.3602	0.3585	0.3602	48802920.0
2010-12-02 15:00:00	NVDA	Stock	0.3601	0.3618	0.3595	0.3598	116295040.0
2010-12-02 16:00:00	NVDA	Stock	0.3595	0.3609	0.3588	0.36	4906920.0
2010-12-02 17:00:00	NVDA	Stock	0.3553	0.3625	0.3553	0.3625	167000.0
2010-12-02 04:00:00	AMZN	Stock	8.835	8.8475	8.751	8.806	34000.0
2010-12-02 05:00:00	AMZN	Stock	8.85	8.85	8.85	8.85	2000.0
2010-12-02 06:00:00	AMZN	Stock	8.85	8.85	8.85	8.85	2000.0
2010-12-02 07:00:00	AMZN	Stock	8.85	8.8695	8.825	8.845	72000.0
2010-12-02 08:00:00	AMZN	Stock	8.85	8.8995	8.8295	8.8295	534180.0
2010-12-02 09:00:00	AMZN	Stock	8.8255	8.8485	8.7405	8.76	19224360.0
2010-12-02 10:00:00	AMZN	Stock	8.765	8.81	8.696	8.773	29049460.0
2010-12-02 11:00:00	AMZN	Stock	8.775	8.8305	8.766	8.815	13814180.0
2010-12-02 12:00:00	AMZN	Stock	8.813	8.829	8.7895	8.793	8766540.0

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

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