PREVIEW / stock_1hour / 2010-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-21.parquet
  size:    915 KB
  rows:    43,330
  symbols: 3,468

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-04-21 04:00:00	AAPL	Stock	9.125	9.205	9.0732	9.1429	98392.0
2010-04-21 05:00:00	AAPL	Stock	9.1964	9.1964	9.1696	9.1964	78568.0
2010-04-21 06:00:00	AAPL	Stock	9.1786	9.2232	9.1786	9.1964	238336.0
2010-04-21 07:00:00	AAPL	Stock	9.2139	9.2846	9.1929	9.2679	2589384.0
2010-04-21 08:00:00	AAPL	Stock	9.265	9.2732	9.1679	9.2732	12242944.0
2010-04-21 09:00:00	AAPL	Stock	9.2743	9.3214	9.1332	9.2776	317817668.0
2010-04-21 10:00:00	AAPL	Stock	9.2775	9.2846	9.2071	9.2343	187304460.0
2010-04-21 11:00:00	AAPL	Stock	9.235	9.2657	9.1894	9.2304	118993504.0
2010-04-21 12:00:00	AAPL	Stock	9.2295	9.2411	9.2107	9.2204	43908032.0
2010-04-21 13:00:00	AAPL	Stock	9.2206	9.2482	9.2089	9.2468	49398020.0
2010-04-21 14:00:00	AAPL	Stock	9.2464	9.2675	9.2095	9.2412	90309380.0
2010-04-21 15:00:00	AAPL	Stock	9.2425	9.2832	9.2396	9.2586	119871584.0
2010-04-21 16:00:00	AAPL	Stock	9.2586	9.275	9.2089	9.2214	15858304.0
2010-04-21 17:00:00	AAPL	Stock	9.2168	9.23	9.215	9.2296	572544.0
2010-04-21 18:00:00	AAPL	Stock	9.2304	9.2579	9.2271	9.2296	647752.0
2010-04-21 19:00:00	AAPL	Stock	9.2314	9.2357	9.2289	9.2357	481068.0
2010-04-21 06:00:00	MSFT	Stock	31.42	31.42	31.42	31.42	900.0
2010-04-21 07:00:00	MSFT	Stock	31.38	31.38	31.38	31.38	1600.0
2010-04-21 08:00:00	MSFT	Stock	31.32	31.46	31.32	31.43	9310.0
2010-04-21 09:00:00	MSFT	Stock	31.43	31.5	31.28	31.41	5006773.0
2010-04-21 10:00:00	MSFT	Stock	31.4	31.44	31.29	31.29	7220451.0
2010-04-21 11:00:00	MSFT	Stock	31.295	31.38	31.23	31.315	8307505.0
2010-04-21 12:00:00	MSFT	Stock	31.31	31.5	31.31	31.48	6093312.0
2010-04-21 13:00:00	MSFT	Stock	31.48	31.49	31.37	31.415	4969211.0
2010-04-21 14:00:00	MSFT	Stock	31.41	31.44	31.25	31.295	6833347.0
2010-04-21 15:00:00	MSFT	Stock	31.3	31.45	31.25	31.32	9252231.0
2010-04-21 16:00:00	MSFT	Stock	31.33	31.45	31.25	31.31	4891609.0
2010-04-21 17:00:00	MSFT	Stock	31.29	31.34	31.29	31.33	992756.0
2010-04-21 18:00:00	MSFT	Stock	31.33	31.35	31.3	31.33	11878.0
2010-04-21 19:00:00	MSFT	Stock	31.33	31.35	31.3	31.3	6721.0
2010-04-21 08:00:00	NVDA	Stock	0.4253	0.4253	0.4253	0.4253	8000.0
2010-04-21 09:00:00	NVDA	Stock	0.4288	0.4295	0.4213	0.4238	109675840.0
2010-04-21 10:00:00	NVDA	Stock	0.4238	0.4238	0.4125	0.4145	199459160.0
2010-04-21 11:00:00	NVDA	Stock	0.4145	0.415	0.41	0.4148	195128840.0
2010-04-21 12:00:00	NVDA	Stock	0.4145	0.4173	0.4135	0.4148	73332680.0
2010-04-21 13:00:00	NVDA	Stock	0.4145	0.4155	0.4122	0.4148	58633120.0
2010-04-21 14:00:00	NVDA	Stock	0.4148	0.415	0.41	0.4136	72139920.0
2010-04-21 15:00:00	NVDA	Stock	0.4135	0.4168	0.4133	0.4145	172241400.0
2010-04-21 16:00:00	NVDA	Stock	0.416	0.416	0.4135	0.4135	2735560.0
2010-04-21 17:00:00	NVDA	Stock	0.426	0.426	0.414	0.4145	164000.0
2010-04-21 18:00:00	NVDA	Stock	0.4155	0.416	0.4135	0.4152	422000.0
2010-04-21 19:00:00	NVDA	Stock	0.415	0.415	0.415	0.415	20000.0
2010-04-21 07:00:00	AMZN	Stock	7.215	7.215	7.21	7.21	6560.0
2010-04-21 08:00:00	AMZN	Stock	7.2245	7.2885	7.2245	7.2705	193320.0
2010-04-21 09:00:00	AMZN	Stock	7.2725	7.45	7.244	7.394	30241860.0
2010-04-21 10:00:00	AMZN	Stock	7.3925	7.422	7.3015	7.3025	28288820.0
2010-04-21 11:00:00	AMZN	Stock	7.3045	7.359	7.24	7.316	19771160.0
2010-04-21 12:00:00	AMZN	Stock	7.3155	7.335	7.29	7.3225	11319180.0
2010-04-21 13:00:00	AMZN	Stock	7.3225	7.351	7.316	7.3475	11801780.0
2010-04-21 14:00:00	AMZN	Stock	7.35	7.3535	7.287	7.3195	12821620.0

> showing 50 of 43,330 rows — these rows as CSV

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