PREVIEW / stock_1hour / 2010-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-19.parquet
  size:    935 KB
  rows:    45,204
  symbols: 3,494

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-10-19 04:00:00	AAPL	Stock	10.7486	10.8186	10.7214	10.7618	172200.0
2010-10-19 05:00:00	AAPL	Stock	10.7957	10.81	10.7786	10.8032	160216.0
2010-10-19 06:00:00	AAPL	Stock	10.7918	10.7943	10.7718	10.7939	246736.0
2010-10-19 07:00:00	AAPL	Stock	10.7807	10.8086	10.6986	10.75	2612064.0
2010-10-19 08:00:00	AAPL	Stock	10.75	11.0207	10.7321	10.8964	50906968.0
2010-10-19 09:00:00	AAPL	Stock	10.8971	11.0	10.715	10.9821	293021568.0
2010-10-19 10:00:00	AAPL	Stock	10.9832	11.2061	10.9507	11.1329	287652736.0
2010-10-19 11:00:00	AAPL	Stock	11.1332	11.1557	11.0504	11.133	127991080.0
2010-10-19 12:00:00	AAPL	Stock	11.135	11.1679	11.1093	11.1454	68614700.0
2010-10-19 13:00:00	AAPL	Stock	11.1461	11.1464	11.0236	11.0381	86089920.0
2010-10-19 14:00:00	AAPL	Stock	11.0382	11.0671	10.9529	11.0329	138235552.0
2010-10-19 15:00:00	AAPL	Stock	11.0348	11.0589	10.94	11.0589	138011188.0
2010-10-19 16:00:00	AAPL	Stock	11.0589	11.0604	10.9778	11.025	12091996.0
2010-10-19 17:00:00	AAPL	Stock	11.0286	11.0286	10.9925	10.995	1525216.0
2010-10-19 18:00:00	AAPL	Stock	10.9982	11.0536	10.9893	10.9961	1578444.0
2010-10-19 19:00:00	AAPL	Stock	10.9896	10.9989	10.9464	10.9529	2017792.0
2010-10-19 05:00:00	MSFT	Stock	25.29	25.29	25.29	25.29	200.0
2010-10-19 07:00:00	MSFT	Stock	25.32	25.32	25.01	25.08	77350.0
2010-10-19 08:00:00	MSFT	Stock	25.13	25.27	25.06	25.2	117312.0
2010-10-19 09:00:00	MSFT	Stock	25.2	25.37	24.97	25.03	12042413.0
2010-10-19 10:00:00	MSFT	Stock	25.025	25.27	25.0	25.185	10818708.0
2010-10-19 11:00:00	MSFT	Stock	25.185	25.21	25.1	25.14	6257594.0
2010-10-19 12:00:00	MSFT	Stock	25.145	25.19	25.07	25.145	4665161.0
2010-10-19 13:00:00	MSFT	Stock	25.15	25.17	25.04	25.07	4474221.0
2010-10-19 14:00:00	MSFT	Stock	25.07	25.13	24.95	25.13	9877693.0
2010-10-19 15:00:00	MSFT	Stock	25.12	25.15	25.0	25.08	13751631.0
2010-10-19 16:00:00	MSFT	Stock	25.07	25.14	25.04	25.12	3128335.0
2010-10-19 17:00:00	MSFT	Stock	25.82	25.82	25.08	25.12	8863.0
2010-10-19 18:00:00	MSFT	Stock	25.11	25.11	25.08	25.08	60291.0
2010-10-19 19:00:00	MSFT	Stock	25.1	25.1	25.07	25.1	3310.0
2010-10-19 08:00:00	NVDA	Stock	0.28	0.2825	0.2783	0.2783	128000.0
2010-10-19 09:00:00	NVDA	Stock	0.2788	0.281	0.2755	0.2785	122978680.0
2010-10-19 10:00:00	NVDA	Stock	0.2783	0.2811	0.2772	0.2792	116223400.0
2010-10-19 11:00:00	NVDA	Stock	0.279	0.2838	0.2781	0.2835	142984080.0
2010-10-19 12:00:00	NVDA	Stock	0.2832	0.2842	0.2815	0.2829	65830760.0
2010-10-19 13:00:00	NVDA	Stock	0.283	0.283	0.28	0.2801	64641080.0
2010-10-19 14:00:00	NVDA	Stock	0.2801	0.2803	0.2775	0.2798	115347280.0
2010-10-19 15:00:00	NVDA	Stock	0.2798	0.2822	0.2788	0.2822	221255320.0
2010-10-19 16:00:00	NVDA	Stock	0.2822	0.2835	0.28	0.282	5299800.0
2010-10-19 17:00:00	NVDA	Stock	0.2808	0.2828	0.2808	0.2828	75000.0
2010-10-19 18:00:00	NVDA	Stock	0.282	0.282	0.282	0.282	417040.0
2010-10-19 19:00:00	NVDA	Stock	0.2808	0.2808	0.2808	0.2808	67000.0
2010-10-19 04:00:00	AMZN	Stock	8.1	8.1	8.1	8.1	2000.0
2010-10-19 05:00:00	AMZN	Stock	8.125	8.1445	8.125	8.1445	8000.0
2010-10-19 06:00:00	AMZN	Stock	8.085	8.085	8.05	8.05	13000.0
2010-10-19 07:00:00	AMZN	Stock	8.075	8.0795	8.0	8.0	120800.0
2010-10-19 08:00:00	AMZN	Stock	8.0195	8.08	8.0	8.04	346400.0
2010-10-19 09:00:00	AMZN	Stock	8.027	8.0665	7.9105	7.9365	22137400.0
2010-10-19 10:00:00	AMZN	Stock	7.9415	8.14	7.9225	8.092	34133280.0
2010-10-19 11:00:00	AMZN	Stock	8.0925	8.0985	8.0275	8.0882	12681140.0

> showing 50 of 45,204 rows — these rows as CSV

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