PREVIEW / stock_1hour / 2010-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-16.parquet
  size:    905 KB
  rows:    43,094
  symbols: 3,476

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-03-16 04:00:00	AAPL	Stock	7.98	7.98	7.98	7.98	3416.0
2010-03-16 05:00:00	AAPL	Stock	7.99	7.99	7.99	7.99	15120.0
2010-03-16 06:00:00	AAPL	Stock	8.0279	8.0304	8.0279	8.0304	54964.0
2010-03-16 07:00:00	AAPL	Stock	8.03	8.0389	8.0268	8.0389	209748.0
2010-03-16 08:00:00	AAPL	Stock	8.0325	8.0357	7.9857	7.9929	1956248.0
2010-03-16 09:00:00	AAPL	Stock	7.9929	8.0171	7.9732	7.9874	50992200.0
2010-03-16 10:00:00	AAPL	Stock	7.9871	8.0118	7.9468	8.0114	68283600.0
2010-03-16 11:00:00	AAPL	Stock	8.0114	8.035	7.9979	8.02	77483168.0
2010-03-16 12:00:00	AAPL	Stock	8.0196	8.0271	8.0036	8.0086	21908768.0
2010-03-16 13:00:00	AAPL	Stock	8.0084	8.0139	7.9957	7.9993	22069432.0
2010-03-16 14:00:00	AAPL	Stock	7.9989	8.0286	7.9729	8.005	80769024.0
2010-03-16 15:00:00	AAPL	Stock	8.0054	8.0218	7.9911	8.0196	66263260.0
2010-03-16 16:00:00	AAPL	Stock	8.0196	8.0214	7.9892	8.0161	10796632.0
2010-03-16 17:00:00	AAPL	Stock	7.9943	8.0189	7.9943	8.0179	214844.0
2010-03-16 18:00:00	AAPL	Stock	8.0179	8.0196	8.0114	8.0182	173376.0
2010-03-16 19:00:00	AAPL	Stock	8.0161	8.0179	8.0093	8.0121	243012.0
2010-03-16 07:00:00	MSFT	Stock	29.35	29.35	29.35	29.35	500.0
2010-03-16 08:00:00	MSFT	Stock	29.35	29.4	29.32	29.39	12895.0
2010-03-16 09:00:00	MSFT	Stock	29.38	29.49	29.29	29.315	3305650.0
2010-03-16 10:00:00	MSFT	Stock	29.32	29.42	29.25	29.395	5108857.0
2010-03-16 11:00:00	MSFT	Stock	29.4	29.48	29.27	29.28	5486331.0
2010-03-16 12:00:00	MSFT	Stock	29.281	29.34	29.25	29.275	2860553.0
2010-03-16 13:00:00	MSFT	Stock	29.28	29.3	29.22	29.255	2643082.0
2010-03-16 14:00:00	MSFT	Stock	29.26	29.45	29.2	29.34	6666198.0
2010-03-16 15:00:00	MSFT	Stock	29.33	29.43	29.229	29.37	7987142.0
2010-03-16 16:00:00	MSFT	Stock	29.37	29.42	29.277	29.37	2054028.0
2010-03-16 17:00:00	MSFT	Stock	29.41	29.41	29.35	29.35	2800.0
2010-03-16 18:00:00	MSFT	Stock	29.35	29.35	29.33	29.33	2458.0
2010-03-16 19:00:00	MSFT	Stock	29.36	29.37	29.34	29.35	7018.0
2010-03-16 08:00:00	NVDA	Stock	0.4285	0.4285	0.4285	0.4285	12000.0
2010-03-16 09:00:00	NVDA	Stock	0.429	0.434	0.428	0.434	39409080.0
2010-03-16 10:00:00	NVDA	Stock	0.434	0.4438	0.4332	0.4435	144448400.0
2010-03-16 11:00:00	NVDA	Stock	0.4438	0.446	0.4425	0.4436	121508840.0
2010-03-16 12:00:00	NVDA	Stock	0.4438	0.4452	0.4435	0.445	62031480.0
2010-03-16 13:00:00	NVDA	Stock	0.445	0.4465	0.4448	0.445	73000880.0
2010-03-16 14:00:00	NVDA	Stock	0.445	0.4452	0.4406	0.4428	103002720.0
2010-03-16 15:00:00	NVDA	Stock	0.4427	0.445	0.4422	0.444	99260440.0
2010-03-16 16:00:00	NVDA	Stock	0.444	0.4441	0.442	0.444	15535440.0
2010-03-16 17:00:00	NVDA	Stock	0.443	0.443	0.4342	0.4342	608480.0
2010-03-16 18:00:00	NVDA	Stock	0.4438	0.4438	0.4438	0.4438	5507400.0
2010-03-16 19:00:00	NVDA	Stock	0.443	0.4438	0.443	0.4438	16000.0
2010-03-16 08:00:00	AMZN	Stock	6.55	6.55	6.55	6.55	4000.0
2010-03-16 09:00:00	AMZN	Stock	6.5555	6.5905	6.525	6.5905	10372700.0
2010-03-16 10:00:00	AMZN	Stock	6.5896	6.614	6.556	6.6125	17804580.0
2010-03-16 11:00:00	AMZN	Stock	6.612	6.6145	6.58	6.598	11045080.0
2010-03-16 12:00:00	AMZN	Stock	6.599	6.607	6.5919	6.5995	4755900.0
2010-03-16 13:00:00	AMZN	Stock	6.6	6.6025	6.589	6.5935	4930760.0
2010-03-16 14:00:00	AMZN	Stock	6.593	6.611	6.5695	6.581	14707220.0
2010-03-16 15:00:00	AMZN	Stock	6.5815	6.6065	6.5795	6.5885	16037680.0
2010-03-16 16:00:00	AMZN	Stock	6.59	6.6	6.5346	6.6	814960.0

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

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