PREVIEW / stock_1hour / 2010-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-13.parquet
  size:    896 KB
  rows:    43,040
  symbols: 3,479

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-13 05:00:00	AAPL	Stock	9.2675	9.2675	9.2675	9.2675	2800.0
2010-07-13 06:00:00	AAPL	Stock	9.2661	9.2661	9.2661	9.2661	2800.0
2010-07-13 07:00:00	AAPL	Stock	9.2018	9.2464	9.2018	9.2321	268800.0
2010-07-13 08:00:00	AAPL	Stock	9.2286	9.2464	9.1893	9.1911	3300976.0
2010-07-13 09:00:00	AAPL	Stock	9.1961	9.2214	8.8011	8.9214	308603792.0
2010-07-13 10:00:00	AAPL	Stock	8.9214	8.9525	8.8011	8.8605	268378096.0
2010-07-13 11:00:00	AAPL	Stock	8.8597	8.9561	8.8571	8.9254	141356404.0
2010-07-13 12:00:00	AAPL	Stock	8.9243	8.9911	8.8968	8.9339	101090220.0
2010-07-13 13:00:00	AAPL	Stock	8.9325	8.9579	8.9054	8.9332	77835296.0
2010-07-13 14:00:00	AAPL	Stock	8.9318	9.0311	8.9254	9.0296	116481792.0
2010-07-13 15:00:00	AAPL	Stock	9.0286	9.0536	8.9868	9.0039	148653316.0
2010-07-13 16:00:00	AAPL	Stock	9.0039	9.0961	8.9007	9.0571	18984896.0
2010-07-13 17:00:00	AAPL	Stock	9.0586	9.0707	9.0571	9.0675	1426992.0
2010-07-13 18:00:00	AAPL	Stock	9.0671	9.0829	8.9929	9.0771	1486464.0
2010-07-13 19:00:00	AAPL	Stock	9.075	9.0871	9.0714	9.0825	547652.0
2010-07-13 05:00:00	MSFT	Stock	24.96	24.96	24.96	24.96	100.0
2010-07-13 06:00:00	MSFT	Stock	24.99	25.05	24.99	25.05	300.0
2010-07-13 07:00:00	MSFT	Stock	25.05	25.07	25.0	25.0	8833.0
2010-07-13 08:00:00	MSFT	Stock	25.05	25.14	25.0	25.08	36927.0
2010-07-13 09:00:00	MSFT	Stock	25.12	25.22	24.98	25.05	7071324.0
2010-07-13 10:00:00	MSFT	Stock	25.045	25.11	24.9	24.985	7515977.0
2010-07-13 11:00:00	MSFT	Stock	24.98	25.19	24.93	25.141	8546989.0
2010-07-13 12:00:00	MSFT	Stock	25.14	25.28	25.14	25.27	7665797.0
2010-07-13 13:00:00	MSFT	Stock	25.27	25.3	25.08	25.1	5700500.0
2010-07-13 14:00:00	MSFT	Stock	25.1	25.19	25.08	25.138	4265825.0
2010-07-13 15:00:00	MSFT	Stock	25.135	25.2	25.09	25.12	11044418.0
2010-07-13 16:00:00	MSFT	Stock	25.12	25.82	25.01	25.74	3885603.0
2010-07-13 17:00:00	MSFT	Stock	25.13	25.78	25.13	25.73	269895.0
2010-07-13 18:00:00	MSFT	Stock	25.72	25.78	25.13	25.72	39667.0
2010-07-13 19:00:00	MSFT	Stock	25.72	25.72	25.68	25.7	60397.0
2010-07-13 08:00:00	NVDA	Stock	0.265	0.27	0.265	0.2678	734000.0
2010-07-13 09:00:00	NVDA	Stock	0.2678	0.271	0.2663	0.269	106604480.0
2010-07-13 10:00:00	NVDA	Stock	0.269	0.2705	0.2672	0.2678	109688080.0
2010-07-13 11:00:00	NVDA	Stock	0.268	0.272	0.2678	0.2695	88221520.0
2010-07-13 12:00:00	NVDA	Stock	0.2692	0.2712	0.2692	0.271	51629680.0
2010-07-13 13:00:00	NVDA	Stock	0.2711	0.273	0.271	0.2715	96455960.0
2010-07-13 14:00:00	NVDA	Stock	0.2718	0.2735	0.2715	0.2732	50569720.0
2010-07-13 15:00:00	NVDA	Stock	0.2732	0.2748	0.2725	0.2732	162022600.0
2010-07-13 16:00:00	NVDA	Stock	0.2728	0.285	0.271	0.2825	20589360.0
2010-07-13 17:00:00	NVDA	Stock	0.2825	0.2862	0.2825	0.285	3876560.0
2010-07-13 18:00:00	NVDA	Stock	0.285	0.2962	0.2848	0.29	9140600.0
2010-07-13 19:00:00	NVDA	Stock	0.2905	0.292	0.29	0.291	1465480.0
2010-07-13 08:00:00	AMZN	Stock	6.0475	6.0475	6.0065	6.017	78780.0
2010-07-13 09:00:00	AMZN	Stock	6.02	6.1125	6.015	6.074	24223120.0
2010-07-13 10:00:00	AMZN	Stock	6.074	6.1175	6.066	6.1085	20400260.0
2010-07-13 11:00:00	AMZN	Stock	6.109	6.176	6.099	6.1615	22583240.0
2010-07-13 12:00:00	AMZN	Stock	6.161	6.244	6.154	6.161	19760240.0
2010-07-13 13:00:00	AMZN	Stock	6.1605	6.179	6.1225	6.1344	11920120.0
2010-07-13 14:00:00	AMZN	Stock	6.1343	6.1675	6.134	6.1629	8890140.0
2010-07-13 15:00:00	AMZN	Stock	6.164	6.223	6.1635	6.185	29738400.0

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

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