PREVIEW / stock_1hour / 2010-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-14.parquet
  size:    876 KB
  rows:    42,121
  symbols: 3,426

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-07-14 05:00:00	AAPL	Stock	9.0714	9.0714	9.0657	9.0657	8400.0
2010-07-14 06:00:00	AAPL	Stock	9.0536	9.0536	9.0429	9.0446	25200.0
2010-07-14 07:00:00	AAPL	Stock	9.0446	9.0446	8.9725	8.9871	550256.0
2010-07-14 08:00:00	AAPL	Stock	8.9871	9.0125	8.8689	8.8789	7174216.0
2010-07-14 09:00:00	AAPL	Stock	8.8789	9.0104	8.8507	8.9329	122849804.0
2010-07-14 10:00:00	AAPL	Stock	8.9329	9.0639	8.9225	9.04	150050264.0
2010-07-14 11:00:00	AAPL	Stock	9.0393	9.1357	9.0232	9.12	148476132.0
2010-07-14 12:00:00	AAPL	Stock	9.1214	9.125	9.0596	9.06	67814852.0
2010-07-14 13:00:00	AAPL	Stock	9.06	9.0732	9.0018	9.0179	75689964.0
2010-07-14 14:00:00	AAPL	Stock	9.0175	9.055	8.975	9.0375	108146948.0
2010-07-14 15:00:00	AAPL	Stock	9.0386	9.0532	8.9825	9.03	112426552.0
2010-07-14 16:00:00	AAPL	Stock	9.0279	9.0347	8.9857	9.0171	13158908.0
2010-07-14 17:00:00	AAPL	Stock	9.1212	9.1212	9.0025	9.015	325500.0
2010-07-14 18:00:00	AAPL	Stock	9.0161	9.0261	9.0143	9.0143	86492.0
2010-07-14 19:00:00	AAPL	Stock	9.0161	9.0214	9.0114	9.02	154532.0
2010-07-14 07:00:00	MSFT	Stock	25.63	25.64	25.48	25.64	16400.0
2010-07-14 08:00:00	MSFT	Stock	25.6	25.74	25.55	25.6	241112.0
2010-07-14 09:00:00	MSFT	Stock	25.61	25.61	25.37	25.4	11303270.0
2010-07-14 10:00:00	MSFT	Stock	25.4	25.5	25.29	25.398	8892169.0
2010-07-14 11:00:00	MSFT	Stock	25.39	25.54	25.29	25.48	7825885.0
2010-07-14 12:00:00	MSFT	Stock	25.48	25.53	25.44	25.484	6834337.0
2010-07-14 13:00:00	MSFT	Stock	25.48	25.5	25.26	25.26	5476663.0
2010-07-14 14:00:00	MSFT	Stock	25.26	25.5	25.12	25.31	8372831.0
2010-07-14 15:00:00	MSFT	Stock	25.305	25.46	25.23	25.45	11441902.0
2010-07-14 16:00:00	MSFT	Stock	25.449	25.5	25.24	25.46	5531794.0
2010-07-14 17:00:00	MSFT	Stock	25.47	25.48	25.46	25.46	5683.0
2010-07-14 18:00:00	MSFT	Stock	24.766	25.5	24.766	25.4	44511.0
2010-07-14 19:00:00	MSFT	Stock	25.4	25.4	25.39	25.4	23000.0
2010-07-14 04:00:00	NVDA	Stock	0.291	0.291	0.291	0.291	12800.0
2010-07-14 06:00:00	NVDA	Stock	0.2898	0.2898	0.2898	0.2898	8000.0
2010-07-14 07:00:00	NVDA	Stock	0.2872	0.2875	0.2788	0.28	875600.0
2010-07-14 08:00:00	NVDA	Stock	0.2818	0.2875	0.2792	0.2808	12512240.0
2010-07-14 09:00:00	NVDA	Stock	0.2812	0.287	0.2752	0.2775	288528920.0
2010-07-14 10:00:00	NVDA	Stock	0.2775	0.2788	0.274	0.276	362233040.0
2010-07-14 11:00:00	NVDA	Stock	0.276	0.2775	0.2755	0.2765	126491880.0
2010-07-14 12:00:00	NVDA	Stock	0.2766	0.2785	0.2763	0.277	76690600.0
2010-07-14 13:00:00	NVDA	Stock	0.2772	0.2775	0.2743	0.2746	100320840.0
2010-07-14 14:00:00	NVDA	Stock	0.2745	0.2752	0.2718	0.2752	141618480.0
2010-07-14 15:00:00	NVDA	Stock	0.275	0.276	0.273	0.2758	150553840.0
2010-07-14 16:00:00	NVDA	Stock	0.2758	0.2772	0.2725	0.2758	11928400.0
2010-07-14 17:00:00	NVDA	Stock	0.276	0.2763	0.2758	0.2763	155800.0
2010-07-14 18:00:00	NVDA	Stock	0.2763	0.2765	0.2748	0.2755	483120.0
2010-07-14 19:00:00	NVDA	Stock	0.275	0.276	0.2748	0.2755	248000.0
2010-07-14 06:00:00	AMZN	Stock	6.2	6.2	6.2	6.2	40000.0
2010-07-14 07:00:00	AMZN	Stock	6.2145	6.2145	6.2145	6.2145	2000.0
2010-07-14 08:00:00	AMZN	Stock	6.2075	6.225	6.1745	6.1745	243940.0
2010-07-14 09:00:00	AMZN	Stock	6.1625	6.1625	6.08	6.0995	15673120.0
2010-07-14 10:00:00	AMZN	Stock	6.0975	6.1305	6.0738	6.1215	16688100.0
2010-07-14 11:00:00	AMZN	Stock	6.1205	6.1875	6.113	6.168	13650600.0
2010-07-14 12:00:00	AMZN	Stock	6.168	6.185	6.148	6.1705	7685960.0

> showing 50 of 42,121 rows — these rows as CSV

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