PREVIEW / stock_1hour / 2010-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-29.parquet
  size:    883 KB
  rows:    42,233
  symbols: 3,452

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-29 06:00:00	AAPL	Stock	9.3446	9.3636	9.3393	9.3393	23520.0
2010-07-29 07:00:00	AAPL	Stock	9.3589	9.3589	9.325	9.325	563836.0
2010-07-29 08:00:00	AAPL	Stock	9.3296	9.3389	9.305	9.325	2706172.0
2010-07-29 09:00:00	AAPL	Stock	9.3239	9.3804	9.2679	9.3511	101279416.0
2010-07-29 10:00:00	AAPL	Stock	9.3511	9.3539	9.2871	9.2893	77462756.0
2010-07-29 11:00:00	AAPL	Stock	9.2907	9.2911	9.1868	9.2004	93770040.0
2010-07-29 12:00:00	AAPL	Stock	9.2018	9.2046	9.1464	9.1871	80002356.0
2010-07-29 13:00:00	AAPL	Stock	9.1864	9.2071	9.175	9.1857	67873652.0
2010-07-29 14:00:00	AAPL	Stock	9.1859	9.2911	9.1679	9.2746	97189456.0
2010-07-29 15:00:00	AAPL	Stock	9.275	9.2996	9.2143	9.2182	103069876.0
2010-07-29 16:00:00	AAPL	Stock	9.2244	9.3191	9.2036	9.2054	17959116.0
2010-07-29 17:00:00	AAPL	Stock	9.2182	9.2182	9.2	9.2021	330176.0
2010-07-29 18:00:00	AAPL	Stock	9.2096	9.2182	9.2	9.2104	158508.0
2010-07-29 19:00:00	AAPL	Stock	9.2068	9.2104	9.2029	9.2036	164248.0
2010-07-29 04:00:00	MSFT	Stock	26.01	26.5	26.01	26.2	1100.0
2010-07-29 06:00:00	MSFT	Stock	26.15	26.15	26.12	26.12	2930.0
2010-07-29 07:00:00	MSFT	Stock	26.1	26.1	26.08	26.08	3820.0
2010-07-29 08:00:00	MSFT	Stock	26.08	26.1	25.98	26.08	49101.0
2010-07-29 09:00:00	MSFT	Stock	26.07	26.19	25.98	26.0	4557417.0
2010-07-29 10:00:00	MSFT	Stock	26.0	26.13	25.96	26.008	6884357.0
2010-07-29 11:00:00	MSFT	Stock	26.005	26.01	25.64	25.76	11022459.0
2010-07-29 12:00:00	MSFT	Stock	25.76	25.78	25.6	25.77	7115069.0
2010-07-29 13:00:00	MSFT	Stock	25.76	26.26	25.75	26.201	10445007.0
2010-07-29 14:00:00	MSFT	Stock	26.2	26.41	26.14	26.36	10606117.0
2010-07-29 15:00:00	MSFT	Stock	26.36	26.38	26.03	26.04	12820908.0
2010-07-29 16:00:00	MSFT	Stock	26.03	26.256	26.0	26.035	5486380.0
2010-07-29 17:00:00	MSFT	Stock	26.03	26.09	26.01	26.01	37911.0
2010-07-29 18:00:00	MSFT	Stock	26.02	26.05	26.02	26.03	15311.0
2010-07-29 19:00:00	MSFT	Stock	26.03	26.03	26.02	26.02	1900.0
2010-07-29 06:00:00	NVDA	Stock	0.2375	0.2375	0.236	0.236	112000.0
2010-07-29 07:00:00	NVDA	Stock	0.236	0.2375	0.2322	0.2325	2532600.0
2010-07-29 08:00:00	NVDA	Stock	0.2325	0.2385	0.2312	0.233	108797520.0
2010-07-29 09:00:00	NVDA	Stock	0.233	0.24	0.2315	0.233	610759040.0
2010-07-29 10:00:00	NVDA	Stock	0.233	0.235	0.2283	0.2312	543663680.0
2010-07-29 11:00:00	NVDA	Stock	0.2315	0.232	0.2278	0.2283	267653680.0
2010-07-29 12:00:00	NVDA	Stock	0.2281	0.2308	0.2268	0.2305	273613760.0
2010-07-29 13:00:00	NVDA	Stock	0.2305	0.232	0.229	0.2305	151953280.0
2010-07-29 14:00:00	NVDA	Stock	0.2306	0.231	0.229	0.2305	183098640.0
2010-07-29 15:00:00	NVDA	Stock	0.2305	0.2312	0.2278	0.2283	388561480.0
2010-07-29 16:00:00	NVDA	Stock	0.2283	0.2313	0.2275	0.2285	12182520.0
2010-07-29 17:00:00	NVDA	Stock	0.2283	0.2288	0.2278	0.2283	754960.0
2010-07-29 18:00:00	NVDA	Stock	0.2283	0.2288	0.228	0.2288	961840.0
2010-07-29 19:00:00	NVDA	Stock	0.2285	0.2288	0.2283	0.2288	1169400.0
2010-07-29 07:00:00	AMZN	Stock	5.9	5.9	5.9	5.9	14000.0
2010-07-29 08:00:00	AMZN	Stock	5.9	5.9	5.875	5.8855	189400.0
2010-07-29 09:00:00	AMZN	Stock	5.8875	5.9435	5.877	5.887	18277980.0
2010-07-29 10:00:00	AMZN	Stock	5.8875	5.8935	5.8305	5.867	18913980.0
2010-07-29 11:00:00	AMZN	Stock	5.867	5.8675	5.7815	5.81	22031660.0
2010-07-29 12:00:00	AMZN	Stock	5.811	5.818	5.776	5.818	12903020.0
2010-07-29 13:00:00	AMZN	Stock	5.8175	5.8445	5.805	5.82	10277920.0

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

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