PREVIEW / stock_1hour / 2010-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-15.parquet
  size:    894 KB
  rows:    42,781
  symbols: 3,465

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-03-15 05:00:00	AAPL	Stock	8.085	8.085	8.085	8.085	2800.0
2010-03-15 07:00:00	AAPL	Stock	8.0714	8.0732	8.0679	8.0686	72184.0
2010-03-15 08:00:00	AAPL	Stock	8.0679	8.0682	8.0204	8.0461	1881068.0
2010-03-15 09:00:00	AAPL	Stock	8.0379	8.0536	7.9768	7.9796	71185100.0
2010-03-15 10:00:00	AAPL	Stock	7.9804	8.0015	7.9121	7.9286	102662700.0
2010-03-15 11:00:00	AAPL	Stock	7.9286	7.9439	7.8661	7.9214	93789388.0
2010-03-15 12:00:00	AAPL	Stock	7.9207	7.9493	7.9068	7.9314	48596464.0
2010-03-15 13:00:00	AAPL	Stock	7.9304	7.9357	7.9171	7.9309	24415048.0
2010-03-15 14:00:00	AAPL	Stock	7.9307	7.9557	7.9125	7.9471	41740216.0
2010-03-15 15:00:00	AAPL	Stock	7.9475	8.0032	7.9414	7.9964	87184720.0
2010-03-15 16:00:00	AAPL	Stock	7.9964	7.9982	7.9286	7.9968	12998020.0
2010-03-15 17:00:00	AAPL	Stock	7.9964	7.9979	7.9946	7.9957	164836.0
2010-03-15 18:00:00	AAPL	Stock	7.9961	7.9961	7.9643	7.9768	680988.0
2010-03-15 19:00:00	AAPL	Stock	7.9786	7.9786	7.9532	7.9607	684376.0
2010-03-15 06:00:00	MSFT	Stock	29.15	29.15	29.1	29.1	340.0
2010-03-15 07:00:00	MSFT	Stock	29.21	29.24	29.2	29.24	625.0
2010-03-15 08:00:00	MSFT	Stock	29.22	29.23	29.15	29.23	8783.0
2010-03-15 09:00:00	MSFT	Stock	29.18	29.37	29.17	29.25	4249241.0
2010-03-15 10:00:00	MSFT	Stock	29.25	29.3	29.13	29.16	7823883.0
2010-03-15 11:00:00	MSFT	Stock	29.16	29.21	29.06	29.08	5452345.0
2010-03-15 12:00:00	MSFT	Stock	29.085	29.17	29.01	29.15	4421788.0
2010-03-15 13:00:00	MSFT	Stock	29.14	29.17	29.08	29.12	2302330.0
2010-03-15 14:00:00	MSFT	Stock	29.12	29.17	29.065	29.17	2857627.0
2010-03-15 15:00:00	MSFT	Stock	29.17	29.33	29.16	29.3	8059482.0
2010-03-15 16:00:00	MSFT	Stock	29.29	29.32	29.157	29.31	1868665.0
2010-03-15 17:00:00	MSFT	Stock	29.28	29.3	29.26	29.29	4700.0
2010-03-15 18:00:00	MSFT	Stock	29.27	29.29	29.25	29.25	12265.0
2010-03-15 19:00:00	MSFT	Stock	29.29	29.29	29.25	29.25	4636.0
2010-03-15 08:00:00	NVDA	Stock	0.4312	0.4312	0.4312	0.4312	20000.0
2010-03-15 09:00:00	NVDA	Stock	0.4312	0.4345	0.4262	0.431	58911000.0
2010-03-15 10:00:00	NVDA	Stock	0.4308	0.435	0.4293	0.43	66727960.0
2010-03-15 11:00:00	NVDA	Stock	0.4302	0.4308	0.427	0.4278	58364200.0
2010-03-15 12:00:00	NVDA	Stock	0.4275	0.4288	0.4268	0.428	39409320.0
2010-03-15 13:00:00	NVDA	Stock	0.428	0.4285	0.4268	0.4268	21322000.0
2010-03-15 14:00:00	NVDA	Stock	0.4269	0.4278	0.425	0.427	42241880.0
2010-03-15 15:00:00	NVDA	Stock	0.4271	0.4295	0.4265	0.429	58056640.0
2010-03-15 16:00:00	NVDA	Stock	0.4288	0.429	0.4288	0.429	436080.0
2010-03-15 19:00:00	NVDA	Stock	0.43	0.43	0.43	0.43	8000.0
2010-03-15 08:00:00	AMZN	Stock	6.521	6.5875	6.521	6.5415	120260.0
2010-03-15 09:00:00	AMZN	Stock	6.55	6.6	6.545	6.565	19725840.0
2010-03-15 10:00:00	AMZN	Stock	6.564	6.5725	6.453	6.4605	31618620.0
2010-03-15 11:00:00	AMZN	Stock	6.4605	6.4945	6.4315	6.4925	20966860.0
2010-03-15 12:00:00	AMZN	Stock	6.4935	6.5075	6.4765	6.4935	9783240.0
2010-03-15 13:00:00	AMZN	Stock	6.493	6.507	6.4815	6.491	9023120.0
2010-03-15 14:00:00	AMZN	Stock	6.491	6.5145	6.4665	6.509	12070080.0
2010-03-15 15:00:00	AMZN	Stock	6.5095	6.5585	6.5	6.5565	20386580.0
2010-03-15 16:00:00	AMZN	Stock	6.5555	6.5585	6.5135	6.5585	2247780.0
2010-03-15 17:00:00	AMZN	Stock	6.5615	6.5615	6.5615	6.5615	36800.0
2010-03-15 18:00:00	AMZN	Stock	6.5565	6.5565	6.5565	6.5565	16520.0
2010-03-15 08:00:00	TLT	Stock	90.45	90.5	90.36	90.46	40201.0

> showing 50 of 42,781 rows — these rows as CSV

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