PREVIEW / stock_1hour / 2009-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-23.parquet
  size:    905 KB
  rows:    43,335
  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-23 04:00:00	AAPL	Stock	7.1732	7.1732	7.1732	7.1732	5600.0
2009-11-23 07:00:00	AAPL	Stock	7.2071	7.2321	7.2071	7.2271	239484.0
2009-11-23 08:00:00	AAPL	Stock	7.2146	7.2439	7.14	7.23	1919036.0
2009-11-23 09:00:00	AAPL	Stock	7.2286	7.3214	7.2286	7.3157	79862944.0
2009-11-23 10:00:00	AAPL	Stock	7.3179	7.3371	7.3046	7.3079	97410068.0
2009-11-23 11:00:00	AAPL	Stock	7.3076	7.3196	7.3045	7.3054	32260088.0
2009-11-23 12:00:00	AAPL	Stock	7.3057	7.3214	7.3	7.3204	35187012.0
2009-11-23 13:00:00	AAPL	Stock	7.3204	7.3214	7.2971	7.3016	29474704.0
2009-11-23 14:00:00	AAPL	Stock	7.3025	7.3161	7.2857	7.3082	31219692.0
2009-11-23 15:00:00	AAPL	Stock	7.3079	7.3571	7.3054	7.3525	90300000.0
2009-11-23 16:00:00	AAPL	Stock	7.3521	7.3543	7.3111	7.3432	7384468.0
2009-11-23 17:00:00	AAPL	Stock	7.3464	7.3471	7.3414	7.3454	85540.0
2009-11-23 18:00:00	AAPL	Stock	7.3414	7.3529	7.3393	7.3393	1192828.0
2009-11-23 19:00:00	AAPL	Stock	7.3393	7.3457	7.3364	7.3368	116256.0
2009-11-23 04:00:00	MSFT	Stock	29.7	29.84	29.7	29.84	500.0
2009-11-23 06:00:00	MSFT	Stock	29.76	29.76	29.76	29.76	145.0
2009-11-23 07:00:00	MSFT	Stock	29.76	29.89	29.76	29.89	4825.0
2009-11-23 08:00:00	MSFT	Stock	29.82	29.94	29.62	29.93	16628.0
2009-11-23 09:00:00	MSFT	Stock	29.93	29.99	29.62	29.97	7023976.0
2009-11-23 10:00:00	MSFT	Stock	29.98	30.01	29.9	29.94	9176533.0
2009-11-23 11:00:00	MSFT	Stock	29.94	29.97	29.87	29.88	6508357.0
2009-11-23 12:00:00	MSFT	Stock	29.871	29.96	29.75	29.91	3293268.0
2009-11-23 13:00:00	MSFT	Stock	29.912	29.98	29.88	29.942	2996880.0
2009-11-23 14:00:00	MSFT	Stock	29.94	29.96	29.89	29.9	3391675.0
2009-11-23 15:00:00	MSFT	Stock	29.905	29.95	29.86	29.94	6940530.0
2009-11-23 16:00:00	MSFT	Stock	29.93	29.95	29.851	29.94	1667839.0
2009-11-23 17:00:00	MSFT	Stock	29.847	29.94	29.82	29.82	7857.0
2009-11-23 18:00:00	MSFT	Stock	29.9	29.9	29.88	29.9	900.0
2009-11-23 19:00:00	MSFT	Stock	29.9	29.9	29.88	29.88	2827.0
2009-11-23 08:00:00	NVDA	Stock	0.3255	0.3275	0.3235	0.3275	122000.0
2009-11-23 09:00:00	NVDA	Stock	0.3283	0.3322	0.327	0.3313	45985320.0
2009-11-23 10:00:00	NVDA	Stock	0.3315	0.3332	0.3275	0.3283	94485880.0
2009-11-23 11:00:00	NVDA	Stock	0.328	0.33	0.325	0.325	54606640.0
2009-11-23 12:00:00	NVDA	Stock	0.325	0.3283	0.3243	0.326	62100160.0
2009-11-23 13:00:00	NVDA	Stock	0.326	0.3263	0.3243	0.3245	28694440.0
2009-11-23 14:00:00	NVDA	Stock	0.3245	0.3248	0.3238	0.3245	14483520.0
2009-11-23 15:00:00	NVDA	Stock	0.3243	0.326	0.3235	0.325	72271640.0
2009-11-23 16:00:00	NVDA	Stock	0.3248	0.3276	0.3225	0.3235	5255680.0
2009-11-23 17:00:00	NVDA	Stock	0.3233	0.3233	0.323	0.323	92000.0
2009-11-23 18:00:00	NVDA	Stock	0.323	0.323	0.323	0.323	41000.0
2009-11-23 19:00:00	NVDA	Stock	0.323	0.323	0.323	0.323	31000.0
2009-11-23 04:00:00	AMZN	Stock	6.507	6.52	6.507	6.52	4000.0
2009-11-23 07:00:00	AMZN	Stock	6.523	6.569	6.523	6.569	44120.0
2009-11-23 08:00:00	AMZN	Stock	6.569	6.59	6.55	6.5605	609940.0
2009-11-23 09:00:00	AMZN	Stock	6.5605	6.625	6.55	6.6175	18205560.0
2009-11-23 10:00:00	AMZN	Stock	6.6175	6.641	6.5935	6.597	20173140.0
2009-11-23 11:00:00	AMZN	Stock	6.5975	6.6275	6.5775	6.58	12671480.0
2009-11-23 12:00:00	AMZN	Stock	6.5795	6.635	6.5785	6.6345	12626700.0
2009-11-23 13:00:00	AMZN	Stock	6.6345	6.636	6.601	6.613	14202160.0
2009-11-23 14:00:00	AMZN	Stock	6.612	6.614	6.59	6.6005	7861000.0

> showing 50 of 43,335 rows — these rows as CSV

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