PREVIEW / stock_1hour / 2010-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-10.parquet
  size:    875 KB
  rows:    41,762
  symbols: 3,445

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-09-10 04:00:00	AAPL	Stock	9.4375	9.4375	9.4375	9.4375	2800.0
2010-09-10 06:00:00	AAPL	Stock	9.4286	9.4286	9.4286	9.4286	2800.0
2010-09-10 07:00:00	AAPL	Stock	9.4357	9.4357	9.4107	9.4171	173768.0
2010-09-10 08:00:00	AAPL	Stock	9.4132	9.4386	9.4039	9.4039	2435468.0
2010-09-10 09:00:00	AAPL	Stock	9.4036	9.4185	9.3357	9.3839	91117068.0
2010-09-10 10:00:00	AAPL	Stock	9.3846	9.4464	9.3696	9.4432	68237316.0
2010-09-10 11:00:00	AAPL	Stock	9.4436	9.4457	9.3871	9.3978	35144228.0
2010-09-10 12:00:00	AAPL	Stock	9.3964	9.3976	9.3554	9.3839	43784664.0
2010-09-10 13:00:00	AAPL	Stock	9.3846	9.3929	9.3693	9.3868	32765040.0
2010-09-10 14:00:00	AAPL	Stock	9.3864	9.425	9.3839	9.4154	41758780.0
2010-09-10 15:00:00	AAPL	Stock	9.415	9.4246	9.3905	9.4071	59341548.0
2010-09-10 16:00:00	AAPL	Stock	9.4075	9.4186	9.3679	9.4007	7465808.0
2010-09-10 17:00:00	AAPL	Stock	9.4004	9.4107	9.4	9.4029	129276.0
2010-09-10 18:00:00	AAPL	Stock	9.4029	9.4075	9.4004	9.4025	180908.0
2010-09-10 19:00:00	AAPL	Stock	9.4036	9.4125	9.4036	9.4043	110208.0
2010-09-10 05:00:00	MSFT	Stock	23.91	23.91	23.89	23.89	2900.0
2010-09-10 06:00:00	MSFT	Stock	23.93	23.99	23.9	23.99	5700.0
2010-09-10 07:00:00	MSFT	Stock	23.95	23.99	23.94	23.99	4900.0
2010-09-10 08:00:00	MSFT	Stock	23.99	24.08	23.97	24.05	169936.0
2010-09-10 09:00:00	MSFT	Stock	24.04	24.04	23.87	23.94	5724557.0
2010-09-10 10:00:00	MSFT	Stock	23.94	23.94	23.85	23.9	10283949.0
2010-09-10 11:00:00	MSFT	Stock	23.9	23.9	23.79	23.81	7504901.0
2010-09-10 12:00:00	MSFT	Stock	23.81	23.87	23.79	23.795	4946427.0
2010-09-10 13:00:00	MSFT	Stock	23.8	23.86	23.79	23.825	3889740.0
2010-09-10 14:00:00	MSFT	Stock	23.825	23.88	23.81	23.825	6608208.0
2010-09-10 15:00:00	MSFT	Stock	23.83	23.88	23.8	23.85	12450677.0
2010-09-10 16:00:00	MSFT	Stock	23.85	23.9	23.81	23.83	1727769.0
2010-09-10 17:00:00	MSFT	Stock	23.86	23.87	23.84	23.85	520897.0
2010-09-10 18:00:00	MSFT	Stock	23.85	23.87	23.84	23.85	24779.0
2010-09-10 19:00:00	MSFT	Stock	23.87	23.87	23.86	23.87	1100.0
2010-09-10 09:00:00	NVDA	Stock	0.2547	0.257	0.2527	0.255	69595480.0
2010-09-10 10:00:00	NVDA	Stock	0.2547	0.2563	0.2525	0.2535	77918960.0
2010-09-10 11:00:00	NVDA	Stock	0.2535	0.2538	0.2503	0.2515	68606120.0
2010-09-10 12:00:00	NVDA	Stock	0.2513	0.2518	0.2498	0.2509	56809920.0
2010-09-10 13:00:00	NVDA	Stock	0.251	0.251	0.2496	0.25	75596600.0
2010-09-10 14:00:00	NVDA	Stock	0.25	0.2533	0.2495	0.2516	84465120.0
2010-09-10 15:00:00	NVDA	Stock	0.2518	0.2538	0.251	0.253	139701640.0
2010-09-10 16:00:00	NVDA	Stock	0.253	0.2533	0.2518	0.253	35931960.0
2010-09-10 17:00:00	NVDA	Stock	0.2533	0.2533	0.2533	0.2533	50400.0
2010-09-10 07:00:00	AMZN	Stock	7.021	7.1705	7.021	7.0445	74000.0
2010-09-10 08:00:00	AMZN	Stock	7.03	7.0385	7.02	7.02	45000.0
2010-09-10 09:00:00	AMZN	Stock	7.019	7.1215	7.002	7.1045	22600480.0
2010-09-10 10:00:00	AMZN	Stock	7.1025	7.13	7.0835	7.094	21039520.0
2010-09-10 11:00:00	AMZN	Stock	7.0945	7.0965	7.038	7.0445	10346740.0
2010-09-10 12:00:00	AMZN	Stock	7.0475	7.0825	7.0255	7.069	8719840.0
2010-09-10 13:00:00	AMZN	Stock	7.0685	7.0885	7.059	7.07	7373680.0
2010-09-10 14:00:00	AMZN	Stock	7.069	7.1125	7.065	7.1	9765540.0
2010-09-10 15:00:00	AMZN	Stock	7.101	7.1225	7.0965	7.122	17896720.0
2010-09-10 16:00:00	AMZN	Stock	7.122	7.1395	7.0912	7.122	625540.0
2010-09-10 18:00:00	AMZN	Stock	7.122	7.13	7.122	7.1275	68000.0

> showing 50 of 41,762 rows — these rows as CSV

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