PREVIEW / stock_1hour / 2009-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-25.parquet
  size:    875 KB
  rows:    41,577
  symbols: 3,416

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-11-25 04:00:00	AAPL	Stock	7.2996	7.3546	7.2996	7.3546	5600.0
2009-11-25 06:00:00	AAPL	Stock	7.3564	7.3564	7.3564	7.3564	2800.0
2009-11-25 07:00:00	AAPL	Stock	7.3375	7.3375	7.3214	7.3321	198016.0
2009-11-25 08:00:00	AAPL	Stock	7.3321	7.3518	7.325	7.3425	3547768.0
2009-11-25 09:00:00	AAPL	Stock	7.3404	7.3446	7.2796	7.3139	55312796.0
2009-11-25 10:00:00	AAPL	Stock	7.3139	7.3207	7.2861	7.3025	44488332.0
2009-11-25 11:00:00	AAPL	Stock	7.3032	7.3257	7.2989	7.312	34748364.0
2009-11-25 12:00:00	AAPL	Stock	7.3125	7.3139	7.2839	7.2951	26501412.0
2009-11-25 13:00:00	AAPL	Stock	7.2943	7.3043	7.2893	7.2979	37448712.0
2009-11-25 14:00:00	AAPL	Stock	7.2979	7.3054	7.2868	7.2979	20120436.0
2009-11-25 15:00:00	AAPL	Stock	7.2973	7.2993	7.2771	7.2904	43333080.0
2009-11-25 16:00:00	AAPL	Stock	7.2914	7.3031	7.2839	7.2846	5683104.0
2009-11-25 17:00:00	AAPL	Stock	7.2829	7.2981	7.2829	7.2871	149940.0
2009-11-25 18:00:00	AAPL	Stock	7.2886	7.2925	7.2846	7.2846	116256.0
2009-11-25 19:00:00	AAPL	Stock	7.2882	7.2911	7.2871	7.2911	61320.0
2009-11-25 06:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	1000.0
2009-11-25 07:00:00	MSFT	Stock	29.9	29.9	29.85	29.85	2651.0
2009-11-25 08:00:00	MSFT	Stock	29.88	29.95	29.82	29.89	56394.0
2009-11-25 09:00:00	MSFT	Stock	29.89	29.96	29.62	29.819	4995489.0
2009-11-25 10:00:00	MSFT	Stock	29.81	29.86	29.7	29.72	4403829.0
2009-11-25 11:00:00	MSFT	Stock	29.73	29.82	29.7	29.74	4544436.0
2009-11-25 12:00:00	MSFT	Stock	29.74	29.75	29.58	29.67	2690515.0
2009-11-25 13:00:00	MSFT	Stock	29.67	29.78	29.66	29.78	2347059.0
2009-11-25 14:00:00	MSFT	Stock	29.78	29.79	29.7	29.78	5503275.0
2009-11-25 15:00:00	MSFT	Stock	29.775	29.79	29.7	29.78	5301124.0
2009-11-25 16:00:00	MSFT	Stock	29.79	29.822	29.748	29.78	1544670.0
2009-11-25 17:00:00	MSFT	Stock	29.814	29.814	29.78	29.78	23009.0
2009-11-25 18:00:00	MSFT	Stock	29.78	29.78	29.77	29.77	1250.0
2009-11-25 19:00:00	MSFT	Stock	29.77	29.77	29.76	29.76	770.0
2009-11-25 08:00:00	NVDA	Stock	0.3288	0.3288	0.3288	0.3288	44000.0
2009-11-25 09:00:00	NVDA	Stock	0.3273	0.3278	0.3244	0.327	41274080.0
2009-11-25 10:00:00	NVDA	Stock	0.3273	0.3301	0.3268	0.33	134822640.0
2009-11-25 11:00:00	NVDA	Stock	0.33	0.3313	0.3283	0.3294	45464800.0
2009-11-25 12:00:00	NVDA	Stock	0.3295	0.33	0.3263	0.3263	19502000.0
2009-11-25 13:00:00	NVDA	Stock	0.3263	0.3265	0.3255	0.3255	18455200.0
2009-11-25 14:00:00	NVDA	Stock	0.3256	0.3283	0.3253	0.328	48306280.0
2009-11-25 15:00:00	NVDA	Stock	0.328	0.3283	0.3265	0.3268	103067160.0
2009-11-25 16:00:00	NVDA	Stock	0.3268	0.3281	0.3267	0.327	27341760.0
2009-11-25 17:00:00	NVDA	Stock	0.328	0.328	0.3263	0.327	228000.0
2009-11-25 18:00:00	NVDA	Stock	0.3253	0.3253	0.3253	0.3253	8000.0
2009-11-25 19:00:00	NVDA	Stock	0.3268	0.327	0.3268	0.327	16000.0
2009-11-25 04:00:00	AMZN	Stock	6.6675	6.6705	6.66	6.6705	12000.0
2009-11-25 05:00:00	AMZN	Stock	6.652	6.652	6.652	6.652	2000.0
2009-11-25 07:00:00	AMZN	Stock	6.66	6.66	6.649	6.66	144900.0
2009-11-25 08:00:00	AMZN	Stock	6.662	6.6925	6.65	6.675	804360.0
2009-11-25 09:00:00	AMZN	Stock	6.6775	6.6775	6.631	6.6455	14322320.0
2009-11-25 10:00:00	AMZN	Stock	6.6495	6.657	6.62	6.63	19248000.0
2009-11-25 11:00:00	AMZN	Stock	6.6315	6.6455	6.625	6.6425	11839280.0
2009-11-25 12:00:00	AMZN	Stock	6.6425	6.6483	6.6361	6.6483	6312660.0
2009-11-25 13:00:00	AMZN	Stock	6.648	6.675	6.6408	6.6725	9317900.0

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

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