PREVIEW / stock_1hour / 2009-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-28.parquet
  size:    838 KB
  rows:    40,951
  symbols: 3,361

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-05-28 04:00:00	AAPL	Stock	4.7157	4.7157	4.7157	4.7157	2800.0
2009-05-28 05:00:00	AAPL	Stock	4.7218	4.7321	4.7218	4.7321	5600.0
2009-05-28 07:00:00	AAPL	Stock	4.7589	4.7671	4.7304	4.7304	42280.0
2009-05-28 08:00:00	AAPL	Stock	4.7464	4.7857	4.7446	4.7786	1738212.0
2009-05-28 09:00:00	AAPL	Stock	4.7768	4.8121	4.7611	4.7804	64282764.0
2009-05-28 10:00:00	AAPL	Stock	4.7811	4.7814	4.7154	4.7578	96185152.0
2009-05-28 11:00:00	AAPL	Stock	4.7579	4.7789	4.7521	4.7704	50897812.0
2009-05-28 12:00:00	AAPL	Stock	4.7707	4.7721	4.7364	4.7486	31206364.0
2009-05-28 13:00:00	AAPL	Stock	4.7489	4.8021	4.7446	4.7996	67884572.0
2009-05-28 14:00:00	AAPL	Stock	4.7996	4.8325	4.7968	4.8264	82515440.0
2009-05-28 15:00:00	AAPL	Stock	4.8264	4.8354	4.7946	4.8221	80581480.0
2009-05-28 16:00:00	AAPL	Stock	4.823	4.8318	4.7659	4.83	7474180.0
2009-05-28 17:00:00	AAPL	Stock	4.8268	4.8321	4.8268	4.8286	179592.0
2009-05-28 18:00:00	AAPL	Stock	4.8279	4.8318	4.8186	4.8268	1155840.0
2009-05-28 19:00:00	AAPL	Stock	4.8268	4.8296	4.8232	4.8296	182392.0
2009-05-28 08:00:00	MSFT	Stock	20.25	20.3	20.25	20.3	12390.0
2009-05-28 09:00:00	MSFT	Stock	20.3	20.505	20.22	20.45	3876379.0
2009-05-28 10:00:00	MSFT	Stock	20.45	20.45	20.05	20.168	7075380.0
2009-05-28 11:00:00	MSFT	Stock	20.17	20.43	20.15	20.38	5775345.0
2009-05-28 12:00:00	MSFT	Stock	20.39	20.41	20.2	20.28	3490730.0
2009-05-28 13:00:00	MSFT	Stock	20.28	20.59	20.26	20.48	6897412.0
2009-05-28 14:00:00	MSFT	Stock	20.48	20.63	20.46	20.56	5270421.0
2009-05-28 15:00:00	MSFT	Stock	20.57	20.6	20.42	20.45	10781168.0
2009-05-28 16:00:00	MSFT	Stock	20.45	20.49	20.388	20.45	1557065.0
2009-05-28 17:00:00	MSFT	Stock	20.45	20.45	20.44	20.45	1998.0
2009-05-28 18:00:00	MSFT	Stock	20.45	20.45	20.44	20.45	5530.0
2009-05-28 19:00:00	MSFT	Stock	20.45	20.45	20.42	20.42	2490.0
2009-05-28 09:00:00	NVDA	Stock	0.2625	0.265	0.257	0.2572	90700960.0
2009-05-28 10:00:00	NVDA	Stock	0.2572	0.2588	0.2515	0.2584	158360360.0
2009-05-28 11:00:00	NVDA	Stock	0.2583	0.2625	0.258	0.2623	86600000.0
2009-05-28 12:00:00	NVDA	Stock	0.2625	0.2625	0.258	0.2595	68445480.0
2009-05-28 13:00:00	NVDA	Stock	0.2598	0.2638	0.2592	0.2618	168880600.0
2009-05-28 14:00:00	NVDA	Stock	0.2618	0.2629	0.2606	0.2623	156704520.0
2009-05-28 15:00:00	NVDA	Stock	0.2625	0.263	0.2608	0.2628	251297480.0
2009-05-28 16:00:00	NVDA	Stock	0.2628	0.2628	0.2601	0.2601	12688240.0
2009-05-28 17:00:00	NVDA	Stock	0.2623	0.2623	0.2623	0.2623	40000.0
2009-05-28 18:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	4000.0
2009-05-28 19:00:00	NVDA	Stock	0.2612	0.2612	0.2612	0.2612	12000.0
2009-05-28 08:00:00	AMZN	Stock	3.8745	3.9125	3.8745	3.901	111320.0
2009-05-28 09:00:00	AMZN	Stock	3.8895	3.955	3.8525	3.8562	13939420.0
2009-05-28 10:00:00	AMZN	Stock	3.8565	3.8565	3.794	3.8285	22564200.0
2009-05-28 11:00:00	AMZN	Stock	3.829	3.867	3.811	3.862	10674740.0
2009-05-28 12:00:00	AMZN	Stock	3.8605	3.8655	3.826	3.829	7653420.0
2009-05-28 13:00:00	AMZN	Stock	3.829	3.8955	3.828	3.8515	15408500.0
2009-05-28 14:00:00	AMZN	Stock	3.8515	3.8928	3.849	3.8825	9213680.0
2009-05-28 15:00:00	AMZN	Stock	3.8825	3.891	3.8545	3.8825	16992040.0
2009-05-28 16:00:00	AMZN	Stock	3.8785	3.8825	3.8145	3.8594	554960.0
2009-05-28 17:00:00	AMZN	Stock	3.8845	3.8845	3.8845	3.8845	4000.0
2009-05-28 19:00:00	AMZN	Stock	3.887	3.887	3.887	3.887	2000.0
2009-05-28 08:00:00	TLT	Stock	90.75	91.26	90.7	91.2	185739.0

> showing 50 of 40,951 rows — these rows as CSV

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