PREVIEW / stock_1hour / 2009-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-15.parquet
  size:    874 KB
  rows:    43,621
  symbols: 3,341

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
2009-06-15 07:00:00	AAPL	Stock	4.8561	4.8564	4.8393	4.8471	56448.0
2009-06-15 08:00:00	AAPL	Stock	4.8536	4.8568	4.8182	4.8529	2005360.0
2009-06-15 09:00:00	AAPL	Stock	4.8507	4.8875	4.8175	4.8593	103449948.0
2009-06-15 10:00:00	AAPL	Stock	4.8589	4.8904	4.8314	4.8511	126526148.0
2009-06-15 11:00:00	AAPL	Stock	4.8511	4.8532	4.825	4.8314	58561020.0
2009-06-15 12:00:00	AAPL	Stock	4.8311	4.8346	4.8196	4.8314	42395220.0
2009-06-15 13:00:00	AAPL	Stock	4.8314	4.8407	4.8232	4.8357	40817448.0
2009-06-15 14:00:00	AAPL	Stock	4.8357	4.8568	4.8332	4.8543	56534884.0
2009-06-15 15:00:00	AAPL	Stock	4.8543	4.8614	4.8411	4.8604	86530752.0
2009-06-15 16:00:00	AAPL	Stock	4.8604	4.8639	4.8311	4.8557	12906152.0
2009-06-15 17:00:00	AAPL	Stock	4.8582	4.8618	4.8571	4.8586	5865832.0
2009-06-15 18:00:00	AAPL	Stock	4.8604	4.8604	4.8543	4.8586	285908.0
2009-06-15 19:00:00	AAPL	Stock	4.8586	4.8607	4.8554	4.8607	130536.0
2009-06-15 20:00:00	AAPL	Stock	4.8289	4.8289	4.8289	4.8289	13244.0
2009-06-15 07:00:00	MSFT	Stock	23.2	23.23	23.14	23.23	5726.0
2009-06-15 08:00:00	MSFT	Stock	23.24	23.3	23.14	23.3	80181.0
2009-06-15 09:00:00	MSFT	Stock	23.3	23.54	23.19	23.37	9385457.0
2009-06-15 10:00:00	MSFT	Stock	23.38	23.41	23.05	23.06	11251025.0
2009-06-15 11:00:00	MSFT	Stock	23.07	23.32	23.02	23.3	8444670.0
2009-06-15 12:00:00	MSFT	Stock	23.3	23.32	23.17	23.22	3921991.0
2009-06-15 13:00:00	MSFT	Stock	23.21	23.27	23.06	23.09	5298620.0
2009-06-15 14:00:00	MSFT	Stock	23.09	23.23	23.04	23.14	5403033.0
2009-06-15 15:00:00	MSFT	Stock	23.15	23.48	23.11	23.44	15491871.0
2009-06-15 16:00:00	MSFT	Stock	23.41	23.45	23.266	23.39	5934855.0
2009-06-15 17:00:00	MSFT	Stock	23.44	23.45	23.39	23.44	1048462.0
2009-06-15 18:00:00	MSFT	Stock	23.43	23.44	23.41	23.44	14808.0
2009-06-15 19:00:00	MSFT	Stock	23.41	23.42	23.32	23.39	11678.0
2009-06-15 08:00:00	NVDA	Stock	0.2858	0.2858	0.2812	0.2812	22000.0
2009-06-15 09:00:00	NVDA	Stock	0.2825	0.2862	0.28	0.2805	60463000.0
2009-06-15 10:00:00	NVDA	Stock	0.2803	0.2828	0.278	0.2788	92189720.0
2009-06-15 11:00:00	NVDA	Stock	0.279	0.2805	0.278	0.279	49963000.0
2009-06-15 12:00:00	NVDA	Stock	0.2792	0.2818	0.2785	0.2818	46594720.0
2009-06-15 13:00:00	NVDA	Stock	0.2815	0.2818	0.279	0.2803	37852680.0
2009-06-15 14:00:00	NVDA	Stock	0.2803	0.282	0.279	0.28	35418880.0
2009-06-15 15:00:00	NVDA	Stock	0.2796	0.2838	0.2796	0.2825	96842800.0
2009-06-15 16:00:00	NVDA	Stock	0.2825	0.2832	0.2805	0.2825	17078400.0
2009-06-15 17:00:00	NVDA	Stock	0.2825	0.2842	0.2825	0.2842	4068240.0
2009-06-15 18:00:00	NVDA	Stock	0.2838	0.2838	0.2838	0.2838	24000.0
2009-06-15 19:00:00	NVDA	Stock	0.2818	0.2818	0.2818	0.2818	84000.0
2009-06-15 07:00:00	AMZN	Stock	4.195	4.195	4.13	4.13	8000.0
2009-06-15 08:00:00	AMZN	Stock	4.1835	4.1835	4.1355	4.141	44200.0
2009-06-15 09:00:00	AMZN	Stock	4.141	4.1495	4.0815	4.085	15258960.0
2009-06-15 10:00:00	AMZN	Stock	4.0855	4.1215	4.05	4.066	22753580.0
2009-06-15 11:00:00	AMZN	Stock	4.0655	4.0935	4.0545	4.089	10883340.0
2009-06-15 12:00:00	AMZN	Stock	4.091	4.1035	4.081	4.101	6485420.0
2009-06-15 13:00:00	AMZN	Stock	4.101	4.11	4.08	4.1055	8806680.0
2009-06-15 14:00:00	AMZN	Stock	4.1045	4.122	4.098	4.118	10108320.0
2009-06-15 15:00:00	AMZN	Stock	4.1181	4.165	4.1085	4.1555	27125640.0
2009-06-15 16:00:00	AMZN	Stock	4.155	4.1555	4.0734	4.1525	2102800.0
2009-06-15 17:00:00	AMZN	Stock	4.1555	4.1595	4.1555	4.1595	1144420.0

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

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