PREVIEW / stock_1hour / 2010-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-17.parquet
  size:    1.0 MB
  rows:    47,298
  symbols: 3,536

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-17 06:00:00	AAPL	Stock	11.4736	11.4736	11.4736	11.4736	5600.0
2010-12-17 07:00:00	AAPL	Stock	11.4725	11.5071	11.4679	11.4893	119448.0
2010-12-17 08:00:00	AAPL	Stock	11.4821	11.51	11.4804	11.4929	1652308.0
2010-12-17 09:00:00	AAPL	Stock	11.5007	11.5018	11.4571	11.4707	35390068.0
2010-12-17 10:00:00	AAPL	Stock	11.4707	11.474	11.4407	11.4639	35702100.0
2010-12-17 11:00:00	AAPL	Stock	11.4646	11.4814	11.4614	11.4711	24043628.0
2010-12-17 12:00:00	AAPL	Stock	11.4714	11.4775	11.4597	11.4686	20273904.0
2010-12-17 13:00:00	AAPL	Stock	11.4696	11.4786	11.4625	11.4689	16814420.0
2010-12-17 14:00:00	AAPL	Stock	11.4693	11.4711	11.4504	11.4618	28129808.0
2010-12-17 15:00:00	AAPL	Stock	11.4611	11.4636	11.4368	11.4521	68901560.0
2010-12-17 16:00:00	AAPL	Stock	11.4521	11.4759	11.4321	11.4414	43436400.0
2010-12-17 17:00:00	AAPL	Stock	11.4414	11.4526	11.4321	11.4393	1191260.0
2010-12-17 18:00:00	AAPL	Stock	11.4382	11.4507	11.4357	11.4393	267400.0
2010-12-17 19:00:00	AAPL	Stock	11.4443	11.445	11.4411	11.4418	76860.0
2010-12-17 07:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	500.0
2010-12-17 08:00:00	MSFT	Stock	27.94	27.96	27.94	27.95	27943.0
2010-12-17 09:00:00	MSFT	Stock	27.95	28.03	27.83	27.89	11473041.0
2010-12-17 10:00:00	MSFT	Stock	27.89	27.99	27.82	27.952	6899323.0
2010-12-17 11:00:00	MSFT	Stock	27.958	28.0	27.94	27.97	4098061.0
2010-12-17 12:00:00	MSFT	Stock	27.975	28.05	27.87	28.02	4900928.0
2010-12-17 13:00:00	MSFT	Stock	28.028	28.09	28.0	28.0	6761204.0
2010-12-17 14:00:00	MSFT	Stock	28.01	28.04	27.93	27.958	4729861.0
2010-12-17 15:00:00	MSFT	Stock	27.96	28.01	27.75	27.75	12662841.0
2010-12-17 16:00:00	MSFT	Stock	27.8	27.99	27.75	27.908	19021240.0
2010-12-17 17:00:00	MSFT	Stock	27.93	27.95	27.79	27.792	266495.0
2010-12-17 18:00:00	MSFT	Stock	27.9	27.91	27.783	27.91	23024.0
2010-12-17 19:00:00	MSFT	Stock	27.84	27.91	27.81	27.91	4700.0
2010-12-17 08:00:00	NVDA	Stock	0.3595	0.3595	0.3575	0.3588	116360.0
2010-12-17 09:00:00	NVDA	Stock	0.3592	0.3592	0.3538	0.3588	126066480.0
2010-12-17 10:00:00	NVDA	Stock	0.3588	0.3588	0.3533	0.3553	123932880.0
2010-12-17 11:00:00	NVDA	Stock	0.3553	0.3598	0.3549	0.3596	56580480.0
2010-12-17 12:00:00	NVDA	Stock	0.3595	0.36	0.3578	0.359	38397160.0
2010-12-17 13:00:00	NVDA	Stock	0.3592	0.3602	0.3588	0.36	29401240.0
2010-12-17 14:00:00	NVDA	Stock	0.3602	0.3612	0.3595	0.3604	37802320.0
2010-12-17 15:00:00	NVDA	Stock	0.3605	0.3608	0.3585	0.3595	68638840.0
2010-12-17 16:00:00	NVDA	Stock	0.3592	0.3598	0.3572	0.3592	26998440.0
2010-12-17 17:00:00	NVDA	Stock	0.3593	0.3593	0.3592	0.3592	720720.0
2010-12-17 18:00:00	NVDA	Stock	0.3592	0.3592	0.3588	0.3588	90400.0
2010-12-17 04:00:00	AMZN	Stock	8.9375	8.9375	8.9375	8.9375	2400.0
2010-12-17 07:00:00	AMZN	Stock	8.937	8.937	8.937	8.937	2000.0
2010-12-17 08:00:00	AMZN	Stock	8.9375	8.965	8.9375	8.9545	187860.0
2010-12-17 09:00:00	AMZN	Stock	8.9465	8.9525	8.851	8.8865	31551880.0
2010-12-17 10:00:00	AMZN	Stock	8.8865	8.898	8.8555	8.8745	9703640.0
2010-12-17 11:00:00	AMZN	Stock	8.878	8.9145	8.868	8.8966	6620220.0
2010-12-17 12:00:00	AMZN	Stock	8.8985	8.9195	8.891	8.904	6146580.0
2010-12-17 13:00:00	AMZN	Stock	8.902	8.9165	8.8875	8.8935	6685880.0
2010-12-17 14:00:00	AMZN	Stock	8.8915	8.902	8.8815	8.8855	4770420.0
2010-12-17 15:00:00	AMZN	Stock	8.888	8.896	8.8525	8.874	12737580.0
2010-12-17 16:00:00	AMZN	Stock	8.879	8.8897	8.8612	8.8772	3664200.0
2010-12-17 17:00:00	AMZN	Stock	8.874	8.8895	8.874	8.8791	81720.0

> showing 50 of 47,298 rows — these rows as CSV

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