PREVIEW / stock_1hour / 2010-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-02.parquet
  size:    873 KB
  rows:    42,200
  symbols: 3,457

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-07-02 04:00:00	AAPL	Stock	8.9107	8.9107	8.9107	8.9107	2800.0
2010-07-02 05:00:00	AAPL	Stock	8.9661	8.975	8.9661	8.975	5600.0
2010-07-02 06:00:00	AAPL	Stock	8.975	8.9786	8.9393	8.9461	51800.0
2010-07-02 07:00:00	AAPL	Stock	8.9364	8.9364	8.8929	8.9157	532084.0
2010-07-02 08:00:00	AAPL	Stock	8.9196	8.9593	8.85	8.8829	8145816.0
2010-07-02 09:00:00	AAPL	Stock	8.8843	8.9618	8.8668	8.9029	122574228.0
2010-07-02 10:00:00	AAPL	Stock	8.9021	8.9082	8.8121	8.8161	88369792.0
2010-07-02 11:00:00	AAPL	Stock	8.8152	8.8357	8.7536	8.7725	77377916.0
2010-07-02 12:00:00	AAPL	Stock	8.7746	8.7993	8.7196	8.7257	76258224.0
2010-07-02 13:00:00	AAPL	Stock	8.7236	8.7714	8.6857	8.7696	84171304.0
2010-07-02 14:00:00	AAPL	Stock	8.7689	8.7889	8.7442	8.7836	79200548.0
2010-07-02 15:00:00	AAPL	Stock	8.7839	8.9071	8.765	8.8214	138114396.0
2010-07-02 16:00:00	AAPL	Stock	8.8214	8.9411	8.7941	8.8125	13991180.0
2010-07-02 17:00:00	AAPL	Stock	8.8111	8.8143	8.7914	8.7968	526708.0
2010-07-02 18:00:00	AAPL	Stock	8.7971	8.8193	8.7857	8.7964	345184.0
2010-07-02 19:00:00	AAPL	Stock	8.7996	8.8071	8.7904	8.7929	178360.0
2010-07-02 07:00:00	MSFT	Stock	23.2	23.28	23.2	23.28	386.0
2010-07-02 08:00:00	MSFT	Stock	23.16	23.54	23.15	23.24	254912.0
2010-07-02 09:00:00	MSFT	Stock	23.24	23.39	23.06	23.15	8219265.0
2010-07-02 10:00:00	MSFT	Stock	23.14	23.239	23.05	23.16	7643788.0
2010-07-02 11:00:00	MSFT	Stock	23.16	23.25	23.145	23.172	8159524.0
2010-07-02 12:00:00	MSFT	Stock	23.18	23.24	23.13	23.15	4716044.0
2010-07-02 13:00:00	MSFT	Stock	23.14	23.17	23.06	23.158	5813593.0
2010-07-02 14:00:00	MSFT	Stock	23.155	23.19	23.09	23.19	4393794.0
2010-07-02 15:00:00	MSFT	Stock	23.18	23.48	23.16	23.27	15446812.0
2010-07-02 16:00:00	MSFT	Stock	23.25	23.413	23.206	23.26	4150971.0
2010-07-02 17:00:00	MSFT	Stock	23.22	23.22	23.15	23.15	39665.0
2010-07-02 18:00:00	MSFT	Stock	23.21	23.27	23.15	23.2	3144.0
2010-07-02 19:00:00	MSFT	Stock	23.16	23.2	23.15	23.2	1770.0
2010-07-02 20:00:00	MSFT	Stock	23.18	23.18	23.18	23.18	2000.0
2010-07-02 08:00:00	NVDA	Stock	0.26	0.26	0.2588	0.259	306400.0
2010-07-02 09:00:00	NVDA	Stock	0.2588	0.261	0.254	0.2563	97975960.0
2010-07-02 10:00:00	NVDA	Stock	0.2563	0.2572	0.2535	0.2544	127271720.0
2010-07-02 11:00:00	NVDA	Stock	0.2544	0.2545	0.2482	0.2491	128663520.0
2010-07-02 12:00:00	NVDA	Stock	0.2493	0.2523	0.2475	0.2515	109322400.0
2010-07-02 13:00:00	NVDA	Stock	0.2513	0.2553	0.25	0.255	74728800.0
2010-07-02 14:00:00	NVDA	Stock	0.2553	0.2555	0.2535	0.255	54012720.0
2010-07-02 15:00:00	NVDA	Stock	0.255	0.2588	0.2547	0.2563	129441680.0
2010-07-02 16:00:00	NVDA	Stock	0.2565	0.2575	0.254	0.2565	13649480.0
2010-07-02 18:00:00	NVDA	Stock	0.2563	0.2563	0.2563	0.2563	24000.0
2010-07-02 19:00:00	NVDA	Stock	0.2543	0.2543	0.2543	0.2543	16000.0
2010-07-02 08:00:00	AMZN	Stock	5.5625	5.575	5.5375	5.573	97760.0
2010-07-02 09:00:00	AMZN	Stock	5.55	5.5645	5.4605	5.491	15200940.0
2010-07-02 10:00:00	AMZN	Stock	5.4905	5.5295	5.455	5.4675	13727880.0
2010-07-02 11:00:00	AMZN	Stock	5.4675	5.504	5.446	5.4635	11682660.0
2010-07-02 12:00:00	AMZN	Stock	5.461	5.486	5.4415	5.45	8922120.0
2010-07-02 13:00:00	AMZN	Stock	5.45	5.4665	5.428	5.4665	11007640.0
2010-07-02 14:00:00	AMZN	Stock	5.466	5.474	5.4325	5.4498	7094720.0
2010-07-02 15:00:00	AMZN	Stock	5.449	5.492	5.4395	5.4565	17984100.0
2010-07-02 16:00:00	AMZN	Stock	5.4495	5.4701	5.4385	5.45	747200.0

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

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