PREVIEW / stock_1hour / 2010-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-23.parquet
  size:    919 KB
  rows:    44,467
  symbols: 3,463

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-08-23 06:00:00	AAPL	Stock	8.9446	8.9464	8.9446	8.9464	11200.0
2010-08-23 07:00:00	AAPL	Stock	8.9518	8.9893	8.9518	8.9818	249200.0
2010-08-23 08:00:00	AAPL	Stock	8.9732	8.9875	8.9536	8.9821	2334976.0
2010-08-23 09:00:00	AAPL	Stock	8.9821	9.0	8.9564	8.9586	45387188.0
2010-08-23 10:00:00	AAPL	Stock	8.9568	8.9586	8.8464	8.8596	93669772.0
2010-08-23 11:00:00	AAPL	Stock	8.8596	8.8621	8.8268	8.8414	50235528.0
2010-08-23 12:00:00	AAPL	Stock	8.8418	8.8654	8.8339	8.8357	26230764.0
2010-08-23 13:00:00	AAPL	Stock	8.8339	8.8439	8.8093	8.8232	38677016.0
2010-08-23 14:00:00	AAPL	Stock	8.8249	8.8375	8.8054	8.8076	41737892.0
2010-08-23 15:00:00	AAPL	Stock	8.8075	8.8196	8.7589	8.7786	94048948.0
2010-08-23 16:00:00	AAPL	Stock	8.7786	8.9982	8.7721	8.7804	14771764.0
2010-08-23 17:00:00	AAPL	Stock	8.7789	8.7804	8.7611	8.77	1716344.0
2010-08-23 18:00:00	AAPL	Stock	8.77	8.7786	8.7664	8.7668	371560.0
2010-08-23 19:00:00	AAPL	Stock	8.7671	8.7707	8.7607	8.7639	353052.0
2010-08-23 08:00:00	MSFT	Stock	24.31	24.38	24.3	24.35	13679.0
2010-08-23 09:00:00	MSFT	Stock	24.33	24.64	24.31	24.62	5916280.0
2010-08-23 10:00:00	MSFT	Stock	24.615	24.62	24.27	24.31	10835638.0
2010-08-23 11:00:00	MSFT	Stock	24.315	24.36	24.27	24.32	5694480.0
2010-08-23 12:00:00	MSFT	Stock	24.31	24.38	24.28	24.285	3291689.0
2010-08-23 13:00:00	MSFT	Stock	24.28	24.42	24.24	24.4	5669268.0
2010-08-23 14:00:00	MSFT	Stock	24.4	24.54	24.395	24.48	4625507.0
2010-08-23 15:00:00	MSFT	Stock	24.48	24.5	24.26	24.28	12115150.0
2010-08-23 16:00:00	MSFT	Stock	24.28	24.398	24.21	24.24	2685439.0
2010-08-23 17:00:00	MSFT	Stock	24.22	24.28	24.2	24.24	130981.0
2010-08-23 18:00:00	MSFT	Stock	24.24	24.28	24.2	24.24	24168.0
2010-08-23 19:00:00	MSFT	Stock	24.18	24.25	24.18	24.23	7176.0
2010-08-23 08:00:00	NVDA	Stock	0.2503	0.252	0.2498	0.2513	660000.0
2010-08-23 09:00:00	NVDA	Stock	0.2503	0.2563	0.2498	0.2507	105043600.0
2010-08-23 10:00:00	NVDA	Stock	0.2507	0.251	0.247	0.2482	139815680.0
2010-08-23 11:00:00	NVDA	Stock	0.248	0.2485	0.2448	0.2453	134785440.0
2010-08-23 12:00:00	NVDA	Stock	0.2455	0.2473	0.2453	0.2453	50669680.0
2010-08-23 13:00:00	NVDA	Stock	0.2453	0.2468	0.2448	0.2468	50051560.0
2010-08-23 14:00:00	NVDA	Stock	0.2466	0.2481	0.2462	0.2465	91997280.0
2010-08-23 15:00:00	NVDA	Stock	0.2465	0.2475	0.2453	0.2458	153483200.0
2010-08-23 16:00:00	NVDA	Stock	0.2455	0.2478	0.245	0.245	9091200.0
2010-08-23 17:00:00	NVDA	Stock	0.2465	0.2465	0.242	0.2448	1491680.0
2010-08-23 18:00:00	NVDA	Stock	0.2453	0.2453	0.2428	0.243	281520.0
2010-08-23 19:00:00	NVDA	Stock	0.2428	0.2428	0.2415	0.2415	107840.0
2010-08-23 20:00:00	NVDA	Stock	0.245	0.245	0.245	0.245	1784000.0
2010-08-23 06:00:00	AMZN	Stock	6.4245	6.4245	6.4245	6.4245	2000.0
2010-08-23 08:00:00	AMZN	Stock	6.364	6.4215	6.364	6.4195	41540.0
2010-08-23 09:00:00	AMZN	Stock	6.4	6.461	6.3665	6.45	9473820.0
2010-08-23 10:00:00	AMZN	Stock	6.448	6.4505	6.3455	6.3625	17359460.0
2010-08-23 11:00:00	AMZN	Stock	6.3637	6.3725	6.325	6.3705	10930360.0
2010-08-23 12:00:00	AMZN	Stock	6.371	6.407	6.3685	6.378	9438360.0
2010-08-23 13:00:00	AMZN	Stock	6.378	6.3844	6.3545	6.376	5223220.0
2010-08-23 14:00:00	AMZN	Stock	6.3765	6.4	6.367	6.3718	7488580.0
2010-08-23 15:00:00	AMZN	Stock	6.372	6.386	6.3265	6.33	14370420.0
2010-08-23 16:00:00	AMZN	Stock	6.33	6.3804	6.322	6.335	2394660.0
2010-08-23 17:00:00	AMZN	Stock	6.3295	6.33	6.3295	6.33	261220.0

> showing 50 of 44,467 rows — these rows as CSV

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