PREVIEW / stock_1hour / 2009-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-23.parquet
  size:    870 KB
  rows:    41,307
  symbols: 3,369

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
2009-10-23 04:00:00	AAPL	Stock	7.3214	7.3214	7.3214	7.3214	2800.0
2009-10-23 05:00:00	AAPL	Stock	7.3057	7.325	7.3057	7.325	11200.0
2009-10-23 06:00:00	AAPL	Stock	7.3375	7.3375	7.3321	7.3321	24164.0
2009-10-23 07:00:00	AAPL	Stock	7.3286	7.3571	7.3286	7.3536	216104.0
2009-10-23 08:00:00	AAPL	Stock	7.3564	7.3811	7.3246	7.3675	3545892.0
2009-10-23 09:00:00	AAPL	Stock	7.3661	7.3696	7.2957	7.3178	84094920.0
2009-10-23 10:00:00	AAPL	Stock	7.3175	7.3421	7.2857	7.2879	84924672.0
2009-10-23 11:00:00	AAPL	Stock	7.2868	7.3075	7.2679	7.2975	56716604.0
2009-10-23 12:00:00	AAPL	Stock	7.2954	7.3093	7.2786	7.2969	29993740.0
2009-10-23 13:00:00	AAPL	Stock	7.2971	7.3071	7.2707	7.2843	39344620.0
2009-10-23 14:00:00	AAPL	Stock	7.2843	7.3157	7.2757	7.2904	49880628.0
2009-10-23 15:00:00	AAPL	Stock	7.2904	7.3061	7.2582	7.2814	65498440.0
2009-10-23 16:00:00	AAPL	Stock	7.2818	7.2836	7.2721	7.2786	5136768.0
2009-10-23 17:00:00	AAPL	Stock	7.2818	7.2818	7.2714	7.2804	191436.0
2009-10-23 18:00:00	AAPL	Stock	7.2821	7.2971	7.2786	7.2811	587748.0
2009-10-23 19:00:00	AAPL	Stock	7.2811	7.2829	7.2786	7.2786	101304.0
2009-10-23 05:00:00	MSFT	Stock	26.72	26.72	26.72	26.72	300.0
2009-10-23 06:00:00	MSFT	Stock	26.79	27.0	26.75	26.75	2050.0
2009-10-23 07:00:00	MSFT	Stock	26.89	27.05	26.75	26.9	84291.0
2009-10-23 08:00:00	MSFT	Stock	26.9	29.22	26.76	29.12	14126473.0
2009-10-23 09:00:00	MSFT	Stock	29.12	29.68	28.63	28.851	77748028.0
2009-10-23 10:00:00	MSFT	Stock	28.86	28.9	28.23	28.252	60369633.0
2009-10-23 11:00:00	MSFT	Stock	28.26	28.59	28.23	28.41	38750650.0
2009-10-23 12:00:00	MSFT	Stock	28.405	28.55	28.13	28.147	25345339.0
2009-10-23 13:00:00	MSFT	Stock	28.15	28.35	28.0	28.072	19263211.0
2009-10-23 14:00:00	MSFT	Stock	28.07	28.14	27.88	27.97	20826026.0
2009-10-23 15:00:00	MSFT	Stock	27.97	28.14	27.9	28.03	19871276.0
2009-10-23 16:00:00	MSFT	Stock	28.03	28.63	28.0	28.05	3875788.0
2009-10-23 17:00:00	MSFT	Stock	28.05	28.07	28.02	28.02	29035.0
2009-10-23 18:00:00	MSFT	Stock	28.03	28.03	27.95	27.99	70821.0
2009-10-23 19:00:00	MSFT	Stock	27.97	28.0	27.96	27.99	30858.0
2009-10-23 08:00:00	NVDA	Stock	0.34	0.346	0.34	0.3455	182000.0
2009-10-23 09:00:00	NVDA	Stock	0.3442	0.3448	0.3308	0.3333	73404240.0
2009-10-23 10:00:00	NVDA	Stock	0.3335	0.3355	0.3283	0.3288	85846160.0
2009-10-23 11:00:00	NVDA	Stock	0.3288	0.3308	0.3275	0.3298	50053800.0
2009-10-23 12:00:00	NVDA	Stock	0.33	0.3307	0.3283	0.3285	37020200.0
2009-10-23 13:00:00	NVDA	Stock	0.3285	0.3298	0.3268	0.3278	32496480.0
2009-10-23 14:00:00	NVDA	Stock	0.3278	0.33	0.3271	0.3273	36303200.0
2009-10-23 15:00:00	NVDA	Stock	0.3273	0.3298	0.3268	0.3288	101800840.0
2009-10-23 16:00:00	NVDA	Stock	0.3285	0.3301	0.3275	0.3288	7932000.0
2009-10-23 17:00:00	NVDA	Stock	0.3283	0.3288	0.3283	0.3288	104000.0
2009-10-23 18:00:00	NVDA	Stock	0.3288	0.3288	0.3288	0.3288	40000.0
2009-10-23 19:00:00	NVDA	Stock	0.3288	0.3288	0.3288	0.3288	4000.0
2009-10-23 06:00:00	AMZN	Stock	5.33	5.3865	5.33	5.3865	135700.0
2009-10-23 07:00:00	AMZN	Stock	5.3955	5.4565	5.375	5.4025	2908520.0
2009-10-23 08:00:00	AMZN	Stock	5.4	5.5125	5.35	5.4865	27479440.0
2009-10-23 09:00:00	AMZN	Stock	5.486	5.6585	5.45	5.6365	234963620.0
2009-10-23 10:00:00	AMZN	Stock	5.635	5.743	5.6335	5.711	209892840.0
2009-10-23 11:00:00	AMZN	Stock	5.71	5.82	5.7065	5.8145	142311640.0
2009-10-23 12:00:00	AMZN	Stock	5.8145	5.87	5.8	5.849	116855180.0

> showing 50 of 41,307 rows — these rows as CSV

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