PREVIEW / stock_1hour / 2010-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-06.parquet
  size:    898 KB
  rows:    43,098
  symbols: 3,469

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-06 04:00:00	AAPL	Stock	8.9286	8.9821	8.9286	8.9643	79968.0
2010-07-06 05:00:00	AAPL	Stock	8.9643	8.9911	8.9286	8.9632	207872.0
2010-07-06 06:00:00	AAPL	Stock	8.9643	8.9643	8.9414	8.9464	130256.0
2010-07-06 07:00:00	AAPL	Stock	8.9464	8.9521	8.8929	8.9268	748916.0
2010-07-06 08:00:00	AAPL	Stock	8.9271	8.9536	8.8571	8.9275	3453716.0
2010-07-06 09:00:00	AAPL	Stock	8.9279	8.9975	8.9279	8.9457	94308088.0
2010-07-06 10:00:00	AAPL	Stock	8.9429	9.0286	8.9286	8.9921	101097388.0
2010-07-06 11:00:00	AAPL	Stock	8.9921	9.0046	8.9314	8.9564	66519712.0
2010-07-06 12:00:00	AAPL	Stock	8.9564	8.9757	8.8661	8.8825	74422180.0
2010-07-06 13:00:00	AAPL	Stock	8.8804	8.9139	8.8116	8.8321	69931764.0
2010-07-06 14:00:00	AAPL	Stock	8.8325	8.8653	8.8004	8.8304	70166012.0
2010-07-06 15:00:00	AAPL	Stock	8.8321	8.8793	8.7914	8.8786	108370864.0
2010-07-06 16:00:00	AAPL	Stock	8.8793	8.98	8.8221	8.8893	17540096.0
2010-07-06 17:00:00	AAPL	Stock	8.8893	8.9071	8.8893	8.9014	414372.0
2010-07-06 18:00:00	AAPL	Stock	8.9007	8.9057	8.8214	8.9007	222460.0
2010-07-06 19:00:00	AAPL	Stock	8.9018	8.9161	8.9018	8.9057	508760.0
2010-07-06 06:00:00	MSFT	Stock	23.67	23.7	23.54	23.6	4700.0
2010-07-06 07:00:00	MSFT	Stock	23.58	23.65	23.45	23.58	24228.0
2010-07-06 08:00:00	MSFT	Stock	23.5	23.6	23.49	23.57	36793.0
2010-07-06 09:00:00	MSFT	Stock	23.58	23.84	23.55	23.76	8132307.0
2010-07-06 10:00:00	MSFT	Stock	23.76	24.06	23.71	23.97	12229430.0
2010-07-06 11:00:00	MSFT	Stock	23.97	24.09	23.87	24.03	7706321.0
2010-07-06 12:00:00	MSFT	Stock	24.03	24.04	23.75	23.795	7038726.0
2010-07-06 13:00:00	MSFT	Stock	23.792	23.88	23.67	23.71	7088180.0
2010-07-06 14:00:00	MSFT	Stock	23.708	23.8	23.584	23.7	7503498.0
2010-07-06 15:00:00	MSFT	Stock	23.685	23.83	23.61	23.83	16246061.0
2010-07-06 16:00:00	MSFT	Stock	23.8	23.9	23.627	23.84	3552423.0
2010-07-06 17:00:00	MSFT	Stock	23.87	23.9	23.85	23.9	8747.0
2010-07-06 18:00:00	MSFT	Stock	23.88	23.9	23.27	23.89	20926.0
2010-07-06 19:00:00	MSFT	Stock	23.87	23.92	23.87	23.92	1797.0
2010-07-06 20:00:00	MSFT	Stock	23.98	23.98	23.98	23.98	500.0
2010-07-06 08:00:00	NVDA	Stock	0.2612	0.2638	0.2605	0.2628	335920.0
2010-07-06 09:00:00	NVDA	Stock	0.2612	0.2643	0.2547	0.261	121552600.0
2010-07-06 10:00:00	NVDA	Stock	0.261	0.263	0.2595	0.2625	134899280.0
2010-07-06 11:00:00	NVDA	Stock	0.2624	0.2635	0.2594	0.26	62890120.0
2010-07-06 12:00:00	NVDA	Stock	0.2603	0.2612	0.2553	0.2556	83230280.0
2010-07-06 13:00:00	NVDA	Stock	0.2555	0.2565	0.2533	0.2539	94929240.0
2010-07-06 14:00:00	NVDA	Stock	0.2538	0.2555	0.2519	0.2535	73624560.0
2010-07-06 15:00:00	NVDA	Stock	0.2533	0.2543	0.2513	0.2533	118565960.0
2010-07-06 16:00:00	NVDA	Stock	0.2535	0.2574	0.2525	0.2526	2482640.0
2010-07-06 18:00:00	NVDA	Stock	0.255	0.2565	0.2538	0.2547	104000.0
2010-07-06 08:00:00	AMZN	Stock	5.513	5.565	5.513	5.565	22000.0
2010-07-06 09:00:00	AMZN	Stock	5.563	5.6265	5.5325	5.5665	21184800.0
2010-07-06 10:00:00	AMZN	Stock	5.5675	5.5985	5.55	5.5645	16742260.0
2010-07-06 11:00:00	AMZN	Stock	5.5645	5.604	5.5625	5.6032	12600160.0
2010-07-06 12:00:00	AMZN	Stock	5.604	5.6125	5.52	5.528	10967200.0
2010-07-06 13:00:00	AMZN	Stock	5.53	5.545	5.48	5.487	9820300.0
2010-07-06 14:00:00	AMZN	Stock	5.4865	5.52	5.473	5.4975	9463180.0
2010-07-06 15:00:00	AMZN	Stock	5.4975	5.51	5.45	5.5025	19757340.0
2010-07-06 16:00:00	AMZN	Stock	5.5025	5.5504	5.499	5.515	1145400.0

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

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