PREVIEW / stock_1hour / 2010-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-16.parquet
  size:    892 KB
  rows:    43,361
  symbols: 3,467

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-09-16 04:00:00	AAPL	Stock	9.6536	9.6536	9.6536	9.6536	5600.0
2010-09-16 06:00:00	AAPL	Stock	9.6782	9.6782	9.6782	9.6782	2800.0
2010-09-16 07:00:00	AAPL	Stock	9.6864	9.6875	9.6714	9.68	393484.0
2010-09-16 08:00:00	AAPL	Stock	9.68	9.6839	9.6532	9.6625	3978968.0
2010-09-16 09:00:00	AAPL	Stock	9.6618	9.6786	9.625	9.665	63846188.0
2010-09-16 10:00:00	AAPL	Stock	9.6625	9.7266	9.6411	9.7161	112301700.0
2010-09-16 11:00:00	AAPL	Stock	9.7168	9.7311	9.7043	9.7218	70933436.0
2010-09-16 12:00:00	AAPL	Stock	9.7211	9.73	9.7139	9.7286	36729644.0
2010-09-16 13:00:00	AAPL	Stock	9.7271	9.7329	9.7107	9.7175	35074620.0
2010-09-16 14:00:00	AAPL	Stock	9.7175	9.8168	9.7161	9.815	120156652.0
2010-09-16 15:00:00	AAPL	Stock	9.8146	9.8811	9.8036	9.8775	179436460.0
2010-09-16 16:00:00	AAPL	Stock	9.8775	9.9443	9.6461	9.9311	19922168.0
2010-09-16 17:00:00	AAPL	Stock	9.9318	9.9318	9.9132	9.9214	1560440.0
2010-09-16 18:00:00	AAPL	Stock	9.9239	9.9264	9.8775	9.9154	818692.0
2010-09-16 19:00:00	AAPL	Stock	9.9161	9.9214	9.9107	9.9214	749420.0
2010-09-16 07:00:00	MSFT	Stock	25.18	25.18	25.12	25.12	1200.0
2010-09-16 08:00:00	MSFT	Stock	25.1	25.13	25.01	25.05	35704.0
2010-09-16 09:00:00	MSFT	Stock	25.05	25.2	25.03	25.13	3241389.0
2010-09-16 10:00:00	MSFT	Stock	25.125	25.16	25.05	25.112	7140217.0
2010-09-16 11:00:00	MSFT	Stock	25.12	25.24	25.11	25.2	5277437.0
2010-09-16 12:00:00	MSFT	Stock	25.19	25.25	25.12	25.21	4173262.0
2010-09-16 13:00:00	MSFT	Stock	25.2	25.29	25.15	25.218	4249080.0
2010-09-16 14:00:00	MSFT	Stock	25.219	25.34	25.21	25.311	4913902.0
2010-09-16 15:00:00	MSFT	Stock	25.315	25.37	25.28	25.32	9204560.0
2010-09-16 16:00:00	MSFT	Stock	25.33	25.66	25.152	25.57	4812867.0
2010-09-16 17:00:00	MSFT	Stock	25.59	25.6	25.49	25.49	29970.0
2010-09-16 18:00:00	MSFT	Stock	25.51	25.51	25.33	25.48	95178.0
2010-09-16 19:00:00	MSFT	Stock	25.47	25.48	25.45	25.48	11185.0
2010-09-16 08:00:00	NVDA	Stock	0.2612	0.2612	0.2588	0.2612	52000.0
2010-09-16 09:00:00	NVDA	Stock	0.2615	0.2655	0.2605	0.265	46437080.0
2010-09-16 10:00:00	NVDA	Stock	0.2652	0.2665	0.2628	0.2635	85675280.0
2010-09-16 11:00:00	NVDA	Stock	0.2635	0.2643	0.261	0.2615	43789840.0
2010-09-16 12:00:00	NVDA	Stock	0.2615	0.2638	0.2605	0.2638	32188400.0
2010-09-16 13:00:00	NVDA	Stock	0.2636	0.2638	0.2618	0.2632	19643800.0
2010-09-16 14:00:00	NVDA	Stock	0.263	0.2655	0.2625	0.2632	39270480.0
2010-09-16 15:00:00	NVDA	Stock	0.2632	0.2648	0.263	0.264	78131480.0
2010-09-16 16:00:00	NVDA	Stock	0.2643	0.2658	0.2637	0.2651	17791120.0
2010-09-16 17:00:00	NVDA	Stock	0.2658	0.266	0.265	0.266	281440.0
2010-09-16 18:00:00	NVDA	Stock	0.2652	0.2663	0.2652	0.266	650000.0
2010-09-16 19:00:00	NVDA	Stock	0.2655	0.2663	0.2652	0.2663	308000.0
2010-09-16 07:00:00	AMZN	Stock	7.2625	7.2625	7.2625	7.2625	4000.0
2010-09-16 08:00:00	AMZN	Stock	7.2625	7.27	7.2285	7.265	63960.0
2010-09-16 09:00:00	AMZN	Stock	7.26	7.3445	7.2385	7.3295	15746860.0
2010-09-16 10:00:00	AMZN	Stock	7.33	7.3755	7.2915	7.3525	23810380.0
2010-09-16 11:00:00	AMZN	Stock	7.3525	7.374	7.328	7.329	13515660.0
2010-09-16 12:00:00	AMZN	Stock	7.329	7.3505	7.3125	7.347	10100160.0
2010-09-16 13:00:00	AMZN	Stock	7.348	7.3698	7.3405	7.3635	8577400.0
2010-09-16 14:00:00	AMZN	Stock	7.362	7.392	7.3565	7.374	10340140.0
2010-09-16 15:00:00	AMZN	Stock	7.3735	7.4115	7.3625	7.41	23947820.0
2010-09-16 16:00:00	AMZN	Stock	7.405	7.445	7.3714	7.428	724640.0

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

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