PREVIEW / stock_1hour / 2010-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-07.parquet
  size:    895 KB
  rows:    43,009
  symbols: 3,472

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-07 05:00:00	AAPL	Stock	9.1754	9.1754	9.1754	9.1754	2800.0
2010-06-07 06:00:00	AAPL	Stock	9.1964	9.2193	9.1964	9.2143	40348.0
2010-06-07 07:00:00	AAPL	Stock	9.2143	9.2468	9.1964	9.2143	737380.0
2010-06-07 08:00:00	AAPL	Stock	9.2161	9.2571	9.1964	9.2261	4670652.0
2010-06-07 09:00:00	AAPL	Stock	9.2293	9.2554	9.1521	9.235	98509404.0
2010-06-07 10:00:00	AAPL	Stock	9.235	9.2371	9.0104	9.0268	130178272.0
2010-06-07 11:00:00	AAPL	Stock	9.0268	9.1004	9.005	9.0979	94881584.0
2010-06-07 12:00:00	AAPL	Stock	9.0979	9.1643	9.0714	9.1518	62349196.0
2010-06-07 13:00:00	AAPL	Stock	9.1532	9.1875	9.0718	9.0989	141987636.0
2010-06-07 14:00:00	AAPL	Stock	9.1011	9.1214	8.9704	9.0364	156527952.0
2010-06-07 15:00:00	AAPL	Stock	9.0404	9.0629	8.9482	8.9625	175296576.0
2010-06-07 16:00:00	AAPL	Stock	8.9625	8.975	8.9586	8.9709	13792380.0
2010-06-07 17:00:00	AAPL	Stock	8.9679	8.9871	8.9571	8.9746	757568.0
2010-06-07 18:00:00	AAPL	Stock	8.975	8.98	8.9621	8.9732	274876.0
2010-06-07 19:00:00	AAPL	Stock	8.9689	9.0071	8.9689	9.0071	571200.0
2010-06-07 20:00:00	AAPL	Stock	9.0979	9.0979	9.0979	9.0979	5600.0
2010-06-07 04:00:00	MSFT	Stock	25.58	25.79	25.58	25.79	400.0
2010-06-07 06:00:00	MSFT	Stock	25.8	25.85	25.8	25.85	321.0
2010-06-07 07:00:00	MSFT	Stock	25.84	25.88	25.82	25.82	5494.0
2010-06-07 08:00:00	MSFT	Stock	25.86	25.89	25.79	25.82	13500.0
2010-06-07 09:00:00	MSFT	Stock	25.83	25.91	25.6	25.736	6306944.0
2010-06-07 10:00:00	MSFT	Stock	25.73	25.78	25.55	25.57	11309935.0
2010-06-07 11:00:00	MSFT	Stock	25.57	25.75	25.53	25.75	6217737.0
2010-06-07 12:00:00	MSFT	Stock	25.74	25.78	25.68	25.75	3998851.0
2010-06-07 13:00:00	MSFT	Stock	25.75	25.76	25.575	25.61	6483274.0
2010-06-07 14:00:00	MSFT	Stock	25.61	25.64	25.41	25.448	8581004.0
2010-06-07 15:00:00	MSFT	Stock	25.44	25.51	25.24	25.31	24915558.0
2010-06-07 16:00:00	MSFT	Stock	25.3	25.845	23.3	25.27	8534374.0
2010-06-07 17:00:00	MSFT	Stock	25.3	25.3	25.27	25.27	1200.0
2010-06-07 18:00:00	MSFT	Stock	25.3	25.31	25.27	25.31	51201.0
2010-06-07 19:00:00	MSFT	Stock	25.27	25.35	25.27	25.35	3222.0
2010-06-07 20:00:00	MSFT	Stock	25.74	25.74	25.74	25.74	200.0
2010-06-07 09:00:00	NVDA	Stock	0.3048	0.3052	0.2978	0.3032	65831880.0
2010-06-07 10:00:00	NVDA	Stock	0.3032	0.3058	0.2948	0.2949	104154280.0
2010-06-07 11:00:00	NVDA	Stock	0.2948	0.296	0.293	0.2942	89810880.0
2010-06-07 12:00:00	NVDA	Stock	0.294	0.2952	0.2935	0.2948	47438720.0
2010-06-07 13:00:00	NVDA	Stock	0.2946	0.2962	0.2932	0.2935	33269440.0
2010-06-07 14:00:00	NVDA	Stock	0.2932	0.294	0.2898	0.29	70252200.0
2010-06-07 15:00:00	NVDA	Stock	0.29	0.2908	0.2862	0.2878	136511520.0
2010-06-07 16:00:00	NVDA	Stock	0.288	0.3026	0.2862	0.2881	27496720.0
2010-06-07 17:00:00	NVDA	Stock	0.2868	0.2868	0.285	0.2868	236200.0
2010-06-07 18:00:00	NVDA	Stock	0.2862	0.2868	0.285	0.2868	325960.0
2010-06-07 19:00:00	NVDA	Stock	0.2868	0.2872	0.2868	0.2872	24000.0
2010-06-07 04:00:00	AMZN	Stock	6.1725	6.2035	6.1725	6.2035	16000.0
2010-06-07 05:00:00	AMZN	Stock	6.1885	6.229	6.1885	6.229	17000.0
2010-06-07 06:00:00	AMZN	Stock	6.2425	6.3	6.2425	6.275	41000.0
2010-06-07 07:00:00	AMZN	Stock	6.275	6.338	6.2525	6.3245	225000.0
2010-06-07 08:00:00	AMZN	Stock	6.3155	6.3155	6.28	6.3	915100.0
2010-06-07 09:00:00	AMZN	Stock	6.301	6.325	6.2	6.295	23038540.0
2010-06-07 10:00:00	AMZN	Stock	6.2935	6.3303	6.152	6.1635	26988060.0

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

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