PREVIEW / stock_1hour / 2010-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-22.parquet
  size:    893 KB
  rows:    43,022
  symbols: 3,464

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-22 04:00:00	AAPL	Stock	9.1075	9.1782	9.1075	9.1782	25200.0
2010-07-22 05:00:00	AAPL	Stock	9.1957	9.1957	9.1786	9.1786	25200.0
2010-07-22 06:00:00	AAPL	Stock	9.1711	9.1939	9.1711	9.1839	194068.0
2010-07-22 07:00:00	AAPL	Stock	9.1864	9.1889	9.1425	9.1875	962332.0
2010-07-22 08:00:00	AAPL	Stock	9.1836	9.1893	9.1454	9.1861	5155360.0
2010-07-22 09:00:00	AAPL	Stock	9.1857	9.2143	9.1182	9.1321	107000600.0
2010-07-22 10:00:00	AAPL	Stock	9.1321	9.2857	9.1264	9.2614	172546052.0
2010-07-22 11:00:00	AAPL	Stock	9.2621	9.2786	9.2146	9.2321	64575084.0
2010-07-22 12:00:00	AAPL	Stock	9.2329	9.2746	9.2282	9.2593	46108440.0
2010-07-22 13:00:00	AAPL	Stock	9.2607	9.2821	9.2321	9.2464	48764128.0
2010-07-22 14:00:00	AAPL	Stock	9.2475	9.2821	9.2464	9.2684	54108908.0
2010-07-22 15:00:00	AAPL	Stock	9.2679	9.2857	9.2075	9.2604	121279368.0
2010-07-22 16:00:00	AAPL	Stock	9.26	9.2622	9.2064	9.2196	14478744.0
2010-07-22 17:00:00	AAPL	Stock	9.2157	9.2604	9.2154	9.2239	469896.0
2010-07-22 18:00:00	AAPL	Stock	9.2232	9.2507	9.2189	9.225	356160.0
2010-07-22 19:00:00	AAPL	Stock	9.2186	9.2429	9.2186	9.2429	269276.0
2010-07-22 05:00:00	MSFT	Stock	25.42	25.42	25.42	25.42	500.0
2010-07-22 06:00:00	MSFT	Stock	25.5	25.65	25.46	25.55	3100.0
2010-07-22 07:00:00	MSFT	Stock	25.54	25.57	25.46	25.52	27095.0
2010-07-22 08:00:00	MSFT	Stock	25.52	25.59	25.45	25.57	383452.0
2010-07-22 09:00:00	MSFT	Stock	25.57	25.85	25.47	25.69	9155307.0
2010-07-22 10:00:00	MSFT	Stock	25.69	25.85	25.68	25.795	10668091.0
2010-07-22 11:00:00	MSFT	Stock	25.8	25.9	25.74	25.81	7987691.0
2010-07-22 12:00:00	MSFT	Stock	25.81	25.9	25.75	25.9	5712601.0
2010-07-22 13:00:00	MSFT	Stock	25.9	25.99	25.83	25.832	6817896.0
2010-07-22 14:00:00	MSFT	Stock	25.84	25.95	25.806	25.92	6791716.0
2010-07-22 15:00:00	MSFT	Stock	25.92	25.99	25.7	25.88	16726330.0
2010-07-22 16:00:00	MSFT	Stock	25.88	26.2	25.55	25.78	7400256.0
2010-07-22 17:00:00	MSFT	Stock	25.78	25.87	25.72	25.76	359568.0
2010-07-22 18:00:00	MSFT	Stock	25.74	25.84	25.67	25.71	114140.0
2010-07-22 19:00:00	MSFT	Stock	25.7	25.76	25.6	25.69	59817.0
2010-07-22 08:00:00	NVDA	Stock	0.2605	0.263	0.2605	0.2625	510000.0
2010-07-22 09:00:00	NVDA	Stock	0.2625	0.2638	0.2605	0.2618	60857960.0
2010-07-22 10:00:00	NVDA	Stock	0.2618	0.2663	0.2618	0.265	99957200.0
2010-07-22 11:00:00	NVDA	Stock	0.265	0.2655	0.2625	0.2632	52391880.0
2010-07-22 12:00:00	NVDA	Stock	0.2632	0.2635	0.261	0.2625	62391840.0
2010-07-22 13:00:00	NVDA	Stock	0.2628	0.264	0.2625	0.2638	22262920.0
2010-07-22 14:00:00	NVDA	Stock	0.2635	0.265	0.263	0.2648	54502280.0
2010-07-22 15:00:00	NVDA	Stock	0.2648	0.2652	0.2623	0.2635	94589640.0
2010-07-22 16:00:00	NVDA	Stock	0.2635	0.2648	0.2588	0.2618	3874200.0
2010-07-22 17:00:00	NVDA	Stock	0.2618	0.2632	0.2618	0.2625	311600.0
2010-07-22 18:00:00	NVDA	Stock	0.2628	0.2628	0.262	0.262	597080.0
2010-07-22 19:00:00	NVDA	Stock	0.262	0.2628	0.262	0.262	156000.0
2010-07-22 06:00:00	AMZN	Stock	5.91	5.91	5.91	5.91	2000.0
2010-07-22 07:00:00	AMZN	Stock	5.9125	5.9125	5.912	5.9125	28000.0
2010-07-22 08:00:00	AMZN	Stock	5.925	5.937	5.9135	5.92	255160.0
2010-07-22 09:00:00	AMZN	Stock	5.9245	6.0	5.901	5.9225	16797120.0
2010-07-22 10:00:00	AMZN	Stock	5.922	6.021	5.9215	5.952	28773800.0
2010-07-22 11:00:00	AMZN	Stock	5.953	5.9792	5.9117	5.9342	14378900.0
2010-07-22 12:00:00	AMZN	Stock	5.934	5.964	5.922	5.93	13555120.0

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

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