PREVIEW / stock_1hour / 2010-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-26.parquet
  size:    603 KB
  rows:    26,476
  symbols: 3,376

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-11-26 04:00:00	AAPL	Stock	11.2429	11.2429	11.0957	11.0957	44800.0
2010-11-26 05:00:00	AAPL	Stock	11.1071	11.1214	11.0804	11.0911	19600.0
2010-11-26 06:00:00	AAPL	Stock	11.0982	11.1282	11.0982	11.1282	74200.0
2010-11-26 07:00:00	AAPL	Stock	11.1271	11.2118	11.1271	11.1907	447776.0
2010-11-26 08:00:00	AAPL	Stock	11.1879	11.205	11.1786	11.2018	3888192.0
2010-11-26 09:00:00	AAPL	Stock	11.2018	11.2939	11.1764	11.2779	65872128.0
2010-11-26 10:00:00	AAPL	Stock	11.2768	11.3464	11.2714	11.2807	82994744.0
2010-11-26 11:00:00	AAPL	Stock	11.28	11.3157	11.2771	11.2968	39211984.0
2010-11-26 12:00:00	AAPL	Stock	11.2961	11.3007	11.2643	11.2771	38183040.0
2010-11-26 13:00:00	AAPL	Stock	11.2771	11.2886	11.2354	11.2389	4628064.0
2010-11-26 14:00:00	AAPL	Stock	11.2393	11.2436	11.1899	11.2436	123256.0
2010-11-26 15:00:00	AAPL	Stock	11.2418	11.2482	11.2379	11.2382	211708.0
2010-11-26 16:00:00	AAPL	Stock	11.2382	11.2446	11.2379	11.2411	149352.0
2010-11-26 04:00:00	MSFT	Stock	25.15	25.15	25.15	25.15	600.0
2010-11-26 05:00:00	MSFT	Stock	25.1	25.1	24.88	24.96	4200.0
2010-11-26 06:00:00	MSFT	Stock	24.95	25.05	24.95	25.05	4100.0
2010-11-26 07:00:00	MSFT	Stock	25.1	25.18	25.07	25.18	2000.0
2010-11-26 08:00:00	MSFT	Stock	25.22	25.3	25.18	25.2	33272.0
2010-11-26 09:00:00	MSFT	Stock	25.2	25.27	25.08	25.23	3263306.0
2010-11-26 10:00:00	MSFT	Stock	25.23	25.41	25.23	25.305	4078671.0
2010-11-26 11:00:00	MSFT	Stock	25.31	25.34	25.22	25.3	4713913.0
2010-11-26 12:00:00	MSFT	Stock	25.3	25.4	25.29	25.35	5627552.0
2010-11-26 13:00:00	MSFT	Stock	25.34	25.36	25.23	25.27	1485798.0
2010-11-26 14:00:00	MSFT	Stock	25.27	25.27	25.27	25.27	1926.0
2010-11-26 15:00:00	MSFT	Stock	25.26	25.4	25.26	25.4	3849.0
2010-11-26 16:00:00	MSFT	Stock	25.37	25.37	25.37	25.37	100.0
2010-11-26 08:00:00	NVDA	Stock	0.3485	0.3488	0.3485	0.3488	16000.0
2010-11-26 09:00:00	NVDA	Stock	0.3438	0.346	0.3435	0.3445	28723440.0
2010-11-26 10:00:00	NVDA	Stock	0.3448	0.3455	0.3425	0.344	40348760.0
2010-11-26 11:00:00	NVDA	Stock	0.344	0.3453	0.3418	0.343	32234520.0
2010-11-26 12:00:00	NVDA	Stock	0.343	0.3432	0.341	0.341	32034360.0
2010-11-26 13:00:00	NVDA	Stock	0.3413	0.3413	0.3388	0.341	4724320.0
2010-11-26 15:00:00	NVDA	Stock	0.3393	0.3393	0.3393	0.3393	8000.0
2010-11-26 16:00:00	NVDA	Stock	0.3388	0.3388	0.3388	0.3388	16000.0
2010-11-26 05:00:00	AMZN	Stock	8.828	8.8385	8.818	8.818	6000.0
2010-11-26 07:00:00	AMZN	Stock	8.758	8.77	8.7575	8.7695	24000.0
2010-11-26 08:00:00	AMZN	Stock	8.773	8.8525	8.7635	8.847	669420.0
2010-11-26 09:00:00	AMZN	Stock	8.854	8.9495	8.817	8.876	28720740.0
2010-11-26 10:00:00	AMZN	Stock	8.88	8.883	8.808	8.8392	22516060.0
2010-11-26 11:00:00	AMZN	Stock	8.8415	8.879	8.8215	8.879	12321100.0
2010-11-26 12:00:00	AMZN	Stock	8.8795	8.9045	8.848	8.8768	19235200.0
2010-11-26 13:00:00	AMZN	Stock	8.875	8.8944	8.85	8.855	1305020.0
2010-11-26 14:00:00	AMZN	Stock	8.8625	8.866	8.85	8.854	75980.0
2010-11-26 15:00:00	AMZN	Stock	8.855	8.8625	8.854	8.862	39200.0
2010-11-26 16:00:00	AMZN	Stock	8.853	8.8625	8.853	8.8625	13620.0
2010-11-26 07:00:00	TSLA	Stock	2.35	2.35	2.35	2.35	1500.0
2010-11-26 08:00:00	TSLA	Stock	2.3773	2.3773	2.3667	2.3733	25500.0
2010-11-26 09:00:00	TSLA	Stock	2.3667	2.4	2.3167	2.352	2096520.0
2010-11-26 10:00:00	TSLA	Stock	2.3505	2.3687	2.338	2.342	1155045.0
2010-11-26 11:00:00	TSLA	Stock	2.3447	2.36	2.338	2.35	799095.0

> showing 50 of 26,476 rows — these rows as CSV

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