PREVIEW / stock_1hour / 2010-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-18.parquet
  size:    922 KB
  rows:    43,552
  symbols: 3,481

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-06-18 04:00:00	AAPL	Stock	9.68	9.6807	9.6611	9.6682	28112.0
2010-06-18 05:00:00	AAPL	Stock	9.6732	9.6943	9.6682	9.6943	30408.0
2010-06-18 06:00:00	AAPL	Stock	9.7086	9.7086	9.7086	9.7086	8400.0
2010-06-18 07:00:00	AAPL	Stock	9.7146	9.7768	9.7146	9.7589	1840356.0
2010-06-18 08:00:00	AAPL	Stock	9.7546	9.7607	9.7175	9.7304	3126900.0
2010-06-18 09:00:00	AAPL	Stock	9.7321	9.7468	9.6936	9.7125	189913360.0
2010-06-18 10:00:00	AAPL	Stock	9.7132	9.8186	9.7114	9.817	173071052.0
2010-06-18 11:00:00	AAPL	Stock	9.817	9.8214	9.7746	9.7843	92454656.0
2010-06-18 12:00:00	AAPL	Stock	9.7836	9.7993	9.7582	9.7739	63422996.0
2010-06-18 13:00:00	AAPL	Stock	9.7732	9.7911	9.7618	9.7704	41844488.0
2010-06-18 14:00:00	AAPL	Stock	9.7696	9.7968	9.7679	9.7854	53630360.0
2010-06-18 15:00:00	AAPL	Stock	9.7861	9.7904	9.7429	9.7882	123203836.0
2010-06-18 16:00:00	AAPL	Stock	9.7882	9.7934	9.7139	9.79	34052956.0
2010-06-18 17:00:00	AAPL	Stock	9.7893	9.7925	9.7889	9.7907	333284.0
2010-06-18 18:00:00	AAPL	Stock	9.7925	9.7925	9.7857	9.7864	335412.0
2010-06-18 19:00:00	AAPL	Stock	9.7864	9.7889	9.7839	9.7843	278348.0
2010-06-18 20:00:00	AAPL	Stock	9.7846	9.7911	9.7846	9.7911	100800.0
2010-06-18 04:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	400.0
2010-06-18 07:00:00	MSFT	Stock	26.3	26.4	26.3	26.4	741.0
2010-06-18 08:00:00	MSFT	Stock	26.31	26.39	26.31	26.34	49060.0
2010-06-18 09:00:00	MSFT	Stock	26.34	26.44	26.17	26.27	17829262.0
2010-06-18 10:00:00	MSFT	Stock	26.27	26.53	26.26	26.44	6599531.0
2010-06-18 11:00:00	MSFT	Stock	26.44	26.5	26.25	26.301	4294607.0
2010-06-18 12:00:00	MSFT	Stock	26.31	26.35	26.2	26.259	3013523.0
2010-06-18 13:00:00	MSFT	Stock	26.25	26.41	26.24	26.38	3580995.0
2010-06-18 14:00:00	MSFT	Stock	26.375	26.42	26.34	26.37	2752816.0
2010-06-18 15:00:00	MSFT	Stock	26.37	26.45	26.3	26.43	8411675.0
2010-06-18 16:00:00	MSFT	Stock	26.43	26.45	26.29	26.33	3943029.0
2010-06-18 17:00:00	MSFT	Stock	26.33	26.37	26.33	26.33	560.0
2010-06-18 18:00:00	MSFT	Stock	26.44	26.44	26.37	26.37	2540.0
2010-06-18 19:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	200.0
2010-06-18 20:00:00	MSFT	Stock	26.32	26.32	26.32	26.32	1000.0
2010-06-18 08:00:00	NVDA	Stock	0.3068	0.3068	0.3055	0.3062	101400.0
2010-06-18 09:00:00	NVDA	Stock	0.3062	0.3075	0.305	0.3052	124418920.0
2010-06-18 10:00:00	NVDA	Stock	0.3052	0.3095	0.305	0.3087	131192960.0
2010-06-18 11:00:00	NVDA	Stock	0.3086	0.311	0.3083	0.31	131308520.0
2010-06-18 12:00:00	NVDA	Stock	0.31	0.3113	0.305	0.3065	94599360.0
2010-06-18 13:00:00	NVDA	Stock	0.3062	0.3075	0.3052	0.306	54487200.0
2010-06-18 14:00:00	NVDA	Stock	0.306	0.308	0.3055	0.3073	71265720.0
2010-06-18 15:00:00	NVDA	Stock	0.3073	0.3078	0.305	0.3073	167044080.0
2010-06-18 16:00:00	NVDA	Stock	0.3073	0.308	0.306	0.3073	124427120.0
2010-06-18 17:00:00	NVDA	Stock	0.3085	0.3085	0.3085	0.3085	20000.0
2010-06-18 18:00:00	NVDA	Stock	0.3065	0.3085	0.3065	0.3085	48800.0
2010-06-18 19:00:00	NVDA	Stock	0.3085	0.3085	0.3083	0.3085	128000.0
2010-06-18 08:00:00	AMZN	Stock	6.2839	6.3	6.2839	6.3	4000.0
2010-06-18 09:00:00	AMZN	Stock	6.28	6.3255	6.264	6.291	21052300.0
2010-06-18 10:00:00	AMZN	Stock	6.296	6.365	6.281	6.361	9569520.0
2010-06-18 11:00:00	AMZN	Stock	6.3641	6.374	6.3105	6.314	6217760.0
2010-06-18 12:00:00	AMZN	Stock	6.316	6.335	6.27	6.2875	6315100.0
2010-06-18 13:00:00	AMZN	Stock	6.287	6.2935	6.265	6.28	4532440.0

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

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