PREVIEW / stock_1hour / 2010-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-10.parquet
  size:    948 KB
  rows:    45,311
  symbols: 3,504

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-05-10 04:00:00	AAPL	Stock	9.1071	9.1429	8.9696	9.0521	338604.0
2010-05-10 05:00:00	AAPL	Stock	9.0521	9.0521	8.9475	9.0	385616.0
2010-05-10 06:00:00	AAPL	Stock	9.0	9.0029	8.9643	8.975	410984.0
2010-05-10 07:00:00	AAPL	Stock	8.9643	9.0218	8.875	8.8907	5313336.0
2010-05-10 08:00:00	AAPL	Stock	8.8893	8.9275	8.8482	8.8596	14933716.0
2010-05-10 09:00:00	AAPL	Stock	8.8596	9.0179	8.8082	8.9443	251176100.0
2010-05-10 10:00:00	AAPL	Stock	8.9436	9.0714	8.9129	9.0409	226476292.0
2010-05-10 11:00:00	AAPL	Stock	9.0407	9.0946	9.0228	9.0685	93537024.0
2010-05-10 12:00:00	AAPL	Stock	9.0682	9.085	9.0257	9.0396	61859056.0
2010-05-10 13:00:00	AAPL	Stock	9.0379	9.0521	8.9936	9.0391	94869600.0
2010-05-10 14:00:00	AAPL	Stock	9.0396	9.0643	9.0	9.0543	75990460.0
2010-05-10 15:00:00	AAPL	Stock	9.0518	9.0718	9.0036	9.0675	127574748.0
2010-05-10 16:00:00	AAPL	Stock	9.0661	9.0839	8.9704	9.0682	26017320.0
2010-05-10 17:00:00	AAPL	Stock	9.0671	9.0714	9.0643	9.0657	193368.0
2010-05-10 18:00:00	AAPL	Stock	9.0686	9.1089	9.0661	9.1018	1123528.0
2010-05-10 19:00:00	AAPL	Stock	9.1036	9.1064	9.075	9.0771	955080.0
2010-05-10 04:00:00	MSFT	Stock	29.08	29.16	29.08	29.16	300.0
2010-05-10 05:00:00	MSFT	Stock	29.21	29.21	29.14	29.14	2850.0
2010-05-10 07:00:00	MSFT	Stock	29.03	29.18	28.95	29.1	46275.0
2010-05-10 08:00:00	MSFT	Stock	29.06	29.14	28.98	29.06	242174.0
2010-05-10 09:00:00	MSFT	Stock	29.06	29.48	28.71	29.12	14425909.0
2010-05-10 10:00:00	MSFT	Stock	29.121	29.22	28.9	28.96	15882298.0
2010-05-10 11:00:00	MSFT	Stock	28.965	29.15	28.95	29.09	9083015.0
2010-05-10 12:00:00	MSFT	Stock	29.09	29.12	28.99	28.99	6265530.0
2010-05-10 13:00:00	MSFT	Stock	28.99	29.07	28.83	28.87	9335255.0
2010-05-10 14:00:00	MSFT	Stock	28.864	29.0	28.78	28.95	6216708.0
2010-05-10 15:00:00	MSFT	Stock	28.96	28.99	28.76	28.93	16519513.0
2010-05-10 16:00:00	MSFT	Stock	28.94	29.082	28.789	28.789	6881345.0
2010-05-10 17:00:00	MSFT	Stock	28.92	28.92	28.9	28.9	12157.0
2010-05-10 18:00:00	MSFT	Stock	28.94	28.94	28.89	28.89	20248.0
2010-05-10 19:00:00	MSFT	Stock	28.88	28.9	28.88	28.9	2100.0
2010-05-10 07:00:00	NVDA	Stock	0.375	0.375	0.375	0.375	28000.0
2010-05-10 08:00:00	NVDA	Stock	0.3602	0.3688	0.3592	0.365	867200.0
2010-05-10 09:00:00	NVDA	Stock	0.3642	0.3745	0.3625	0.364	145421200.0
2010-05-10 10:00:00	NVDA	Stock	0.3645	0.365	0.3612	0.3632	194452160.0
2010-05-10 11:00:00	NVDA	Stock	0.3632	0.368	0.3628	0.3664	151071360.0
2010-05-10 12:00:00	NVDA	Stock	0.3665	0.3665	0.3631	0.364	60860000.0
2010-05-10 13:00:00	NVDA	Stock	0.3642	0.365	0.3608	0.3618	127387680.0
2010-05-10 14:00:00	NVDA	Stock	0.3612	0.3648	0.36	0.3648	116631360.0
2010-05-10 15:00:00	NVDA	Stock	0.3646	0.3648	0.3628	0.3642	159975400.0
2010-05-10 16:00:00	NVDA	Stock	0.3638	0.3651	0.3638	0.364	8325360.0
2010-05-10 17:00:00	NVDA	Stock	0.364	0.3648	0.364	0.3648	160000.0
2010-05-10 18:00:00	NVDA	Stock	0.3648	0.3675	0.3648	0.3675	161520.0
2010-05-10 19:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	20000.0
2010-05-10 04:00:00	AMZN	Stock	6.525	6.546	6.525	6.546	17920.0
2010-05-10 05:00:00	AMZN	Stock	6.59	6.59	6.59	6.59	4000.0
2010-05-10 07:00:00	AMZN	Stock	6.57	6.574	6.539	6.539	55760.0
2010-05-10 08:00:00	AMZN	Stock	6.54	6.55	6.422	6.45	748640.0
2010-05-10 09:00:00	AMZN	Stock	6.44	6.6105	6.4375	6.546	24917980.0
2010-05-10 10:00:00	AMZN	Stock	6.5465	6.6	6.501	6.564	26057540.0

> showing 50 of 45,311 rows — these rows as CSV

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