PREVIEW / stock_1hour / 2010-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-26.parquet
  size:    900 KB
  rows:    42,627
  symbols: 3,458

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-03-26 04:00:00	AAPL	Stock	8.1679	8.1679	8.1679	8.1679	26348.0
2010-03-26 05:00:00	AAPL	Stock	8.1875	8.2007	8.1829	8.1861	103852.0
2010-03-26 06:00:00	AAPL	Stock	8.1861	8.2079	8.185	8.185	112980.0
2010-03-26 07:00:00	AAPL	Stock	8.1704	8.2139	8.1704	8.2107	1285060.0
2010-03-26 08:00:00	AAPL	Stock	8.2107	8.2132	8.1746	8.1843	4571504.0
2010-03-26 09:00:00	AAPL	Stock	8.1839	8.2471	8.1625	8.2318	99857240.0
2010-03-26 10:00:00	AAPL	Stock	8.2321	8.2839	8.2304	8.2436	129664108.0
2010-03-26 11:00:00	AAPL	Stock	8.2418	8.2789	8.2418	8.2507	60519116.0
2010-03-26 12:00:00	AAPL	Stock	8.2518	8.2632	8.2	8.2032	71001700.0
2010-03-26 13:00:00	AAPL	Stock	8.2036	8.2289	8.1854	8.2036	59035536.0
2010-03-26 14:00:00	AAPL	Stock	8.2054	8.2354	8.1868	8.2218	52984960.0
2010-03-26 15:00:00	AAPL	Stock	8.2218	8.25	8.2054	8.2468	79375156.0
2010-03-26 16:00:00	AAPL	Stock	8.2468	8.2661	8.2167	8.2546	15324008.0
2010-03-26 17:00:00	AAPL	Stock	8.2546	8.2568	8.25	8.2554	471688.0
2010-03-26 18:00:00	AAPL	Stock	8.2464	8.2571	8.2464	8.255	346668.0
2010-03-26 19:00:00	AAPL	Stock	8.255	8.2561	8.2511	8.2536	104076.0
2010-03-26 20:00:00	AAPL	Stock	8.0896	8.0896	8.0896	8.0896	244552.0
2010-03-26 06:00:00	MSFT	Stock	30.15	30.15	30.15	30.15	100.0
2010-03-26 07:00:00	MSFT	Stock	30.15	30.22	30.11	30.11	1500.0
2010-03-26 08:00:00	MSFT	Stock	30.1	30.3	30.1	30.2	51807.0
2010-03-26 09:00:00	MSFT	Stock	30.21	30.21	29.89	29.952	8622306.0
2010-03-26 10:00:00	MSFT	Stock	29.95	29.97	29.81	29.85	9319058.0
2010-03-26 11:00:00	MSFT	Stock	29.84	29.87	29.74	29.76	5053632.0
2010-03-26 12:00:00	MSFT	Stock	29.755	29.83	29.61	29.64	7197323.0
2010-03-26 13:00:00	MSFT	Stock	29.64	29.76	29.61	29.641	4434860.0
2010-03-26 14:00:00	MSFT	Stock	29.642	29.8	29.61	29.7	6337532.0
2010-03-26 15:00:00	MSFT	Stock	29.69	29.71	29.59	29.66	9558151.0
2010-03-26 16:00:00	MSFT	Stock	29.66	30.0	29.6	29.67	2823349.0
2010-03-26 17:00:00	MSFT	Stock	29.68	29.7	29.67	29.67	3100.0
2010-03-26 18:00:00	MSFT	Stock	29.67	29.68	29.67	29.68	3464.0
2010-03-26 19:00:00	MSFT	Stock	29.68	29.7	29.68	29.7	5846.0
2010-03-26 20:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	366.0
2010-03-26 07:00:00	NVDA	Stock	0.435	0.435	0.435	0.435	4000.0
2010-03-26 08:00:00	NVDA	Stock	0.4362	0.4412	0.4362	0.4412	45280.0
2010-03-26 09:00:00	NVDA	Stock	0.438	0.4418	0.4368	0.4372	40589480.0
2010-03-26 10:00:00	NVDA	Stock	0.4372	0.4405	0.4345	0.4358	51377200.0
2010-03-26 11:00:00	NVDA	Stock	0.4358	0.4385	0.4352	0.437	34927240.0
2010-03-26 12:00:00	NVDA	Stock	0.437	0.438	0.4308	0.4322	45069800.0
2010-03-26 13:00:00	NVDA	Stock	0.432	0.4338	0.43	0.4324	67237640.0
2010-03-26 14:00:00	NVDA	Stock	0.4322	0.4345	0.4318	0.4332	45244200.0
2010-03-26 15:00:00	NVDA	Stock	0.4335	0.434	0.432	0.4332	54107040.0
2010-03-26 16:00:00	NVDA	Stock	0.4335	0.4348	0.4328	0.4338	5501040.0
2010-03-26 19:00:00	NVDA	Stock	0.4338	0.4338	0.4338	0.4338	40000.0
2010-03-26 05:00:00	AMZN	Stock	6.765	6.765	6.765	6.765	4000.0
2010-03-26 07:00:00	AMZN	Stock	6.78	6.7835	6.78	6.7835	4000.0
2010-03-26 08:00:00	AMZN	Stock	6.75	6.7975	6.741	6.765	305880.0
2010-03-26 09:00:00	AMZN	Stock	6.775	6.8495	6.7385	6.7836	32740760.0
2010-03-26 10:00:00	AMZN	Stock	6.7855	6.8105	6.7455	6.765	24601320.0
2010-03-26 11:00:00	AMZN	Stock	6.765	6.795	6.761	6.7615	12044240.0
2010-03-26 12:00:00	AMZN	Stock	6.7605	6.7875	6.706	6.7125	17167900.0

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

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