PREVIEW / stock_1hour / 2010-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-31.parquet
  size:    910 KB
  rows:    43,335
  symbols: 3,541

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-31 08:00:00	AAPL	Stock	11.5571	11.5571	11.5382	11.5418	172396.0
2010-12-31 09:00:00	AAPL	Stock	11.5386	11.5529	11.4793	11.5004	27358856.0
2010-12-31 10:00:00	AAPL	Stock	11.4989	11.5207	11.4804	11.4957	32538800.0
2010-12-31 11:00:00	AAPL	Stock	11.4954	11.4986	11.4761	11.4926	23925160.0
2010-12-31 12:00:00	AAPL	Stock	11.4929	11.5057	11.4881	11.495	15686972.0
2010-12-31 13:00:00	AAPL	Stock	11.4947	11.5043	11.4936	11.4975	13655012.0
2010-12-31 14:00:00	AAPL	Stock	11.4979	11.5125	11.4921	11.5075	17911096.0
2010-12-31 15:00:00	AAPL	Stock	11.5077	11.525	11.4754	11.5157	44724568.0
2010-12-31 16:00:00	AAPL	Stock	11.52	11.5493	11.4996	11.5393	13441764.0
2010-12-31 17:00:00	AAPL	Stock	11.5375	11.5429	11.5321	11.5429	55160.0
2010-12-31 18:00:00	AAPL	Stock	11.5396	11.5429	11.52	11.5307	186060.0
2010-12-31 19:00:00	AAPL	Stock	11.5357	11.5493	11.5357	11.5493	57680.0
2010-12-31 07:00:00	MSFT	Stock	27.86	27.86	27.86	27.86	300.0
2010-12-31 08:00:00	MSFT	Stock	27.88	27.88	27.8	27.84	1200.0
2010-12-31 09:00:00	MSFT	Stock	27.83	27.87	27.67	27.78	2817099.0
2010-12-31 10:00:00	MSFT	Stock	27.77	27.79	27.63	27.67	4367459.0
2010-12-31 11:00:00	MSFT	Stock	27.67	27.81	27.64	27.801	2913832.0
2010-12-31 12:00:00	MSFT	Stock	27.8	27.84	27.74	27.77	2029750.0
2010-12-31 13:00:00	MSFT	Stock	27.77	27.81	27.75	27.78	1193989.0
2010-12-31 14:00:00	MSFT	Stock	27.785	27.79	27.74	27.78	1410773.0
2010-12-31 15:00:00	MSFT	Stock	27.776	27.91	27.75	27.91	5478088.0
2010-12-31 16:00:00	MSFT	Stock	27.92	27.98	27.766	27.92	2945426.0
2010-12-31 17:00:00	MSFT	Stock	27.92	27.93	27.92	27.92	1056.0
2010-12-31 18:00:00	MSFT	Stock	27.91	27.97	27.91	27.95	27400.0
2010-12-31 19:00:00	MSFT	Stock	27.92	27.95	27.9	27.9	12045.0
2010-12-31 09:00:00	NVDA	Stock	0.375	0.3795	0.3745	0.3788	47536720.0
2010-12-31 10:00:00	NVDA	Stock	0.3788	0.3855	0.3775	0.3815	109368720.0
2010-12-31 11:00:00	NVDA	Stock	0.3813	0.383	0.3798	0.3813	39200960.0
2010-12-31 12:00:00	NVDA	Stock	0.381	0.3818	0.3808	0.3815	22302520.0
2010-12-31 13:00:00	NVDA	Stock	0.3813	0.3818	0.38	0.3806	22808640.0
2010-12-31 14:00:00	NVDA	Stock	0.3808	0.383	0.3805	0.3825	34644400.0
2010-12-31 15:00:00	NVDA	Stock	0.3825	0.3855	0.3825	0.3855	102649480.0
2010-12-31 16:00:00	NVDA	Stock	0.385	0.3862	0.3819	0.3858	10676960.0
2010-12-31 17:00:00	NVDA	Stock	0.3858	0.3858	0.384	0.384	257320.0
2010-12-31 18:00:00	NVDA	Stock	0.385	0.385	0.385	0.385	48000.0
2010-12-31 05:00:00	AMZN	Stock	9.153	9.153	9.153	9.153	2000.0
2010-12-31 08:00:00	AMZN	Stock	9.1165	9.1165	9.1	9.113	44460.0
2010-12-31 09:00:00	AMZN	Stock	9.115	9.115	9.0375	9.057	9265280.0
2010-12-31 10:00:00	AMZN	Stock	9.055	9.07	9.0175	9.028	9884860.0
2010-12-31 11:00:00	AMZN	Stock	9.0305	9.035	8.9865	8.9903	9055340.0
2010-12-31 12:00:00	AMZN	Stock	8.9903	9.002	8.977	8.9886	7807740.0
2010-12-31 13:00:00	AMZN	Stock	8.989	9.0095	8.9845	8.9895	5183640.0
2010-12-31 14:00:00	AMZN	Stock	8.99	8.993	8.9795	8.9845	5092320.0
2010-12-31 15:00:00	AMZN	Stock	8.983	9.0025	8.9755	8.996	17812200.0
2010-12-31 16:00:00	AMZN	Stock	8.9925	9.0126	8.992	9.004	1574220.0
2010-12-31 17:00:00	AMZN	Stock	9.0015	9.0025	9.0005	9.002	109000.0
2010-12-31 18:00:00	AMZN	Stock	9.0035	9.009	9.0	9.009	45600.0
2010-12-31 19:00:00	AMZN	Stock	9.009	9.012	9.0055	9.011	33000.0
2010-12-31 09:00:00	TSLA	Stock	1.784	1.8167	1.7667	1.7833	2729715.0
2010-12-31 10:00:00	TSLA	Stock	1.7833	1.8	1.7833	1.7907	1407855.0

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

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