PREVIEW / stock_1hour / 2010-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-19.parquet
  size:    867 KB
  rows:    41,915
  symbols: 3,449

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-19 04:00:00	AAPL	Stock	8.9461	8.9721	8.9461	8.9721	8400.0
2010-07-19 05:00:00	AAPL	Stock	8.9986	8.9996	8.9961	8.9961	13720.0
2010-07-19 06:00:00	AAPL	Stock	8.9725	9.0175	8.9725	9.0175	109732.0
2010-07-19 07:00:00	AAPL	Stock	8.9771	8.9771	8.8807	8.8932	3579604.0
2010-07-19 08:00:00	AAPL	Stock	8.9043	8.9511	8.8821	8.9339	4961292.0
2010-07-19 09:00:00	AAPL	Stock	8.9339	8.9371	8.7393	8.75	176681568.0
2010-07-19 10:00:00	AAPL	Stock	8.75	8.8571	8.5571	8.5899	275312940.0
2010-07-19 11:00:00	AAPL	Stock	8.5893	8.6954	8.5782	8.6571	136122420.0
2010-07-19 12:00:00	AAPL	Stock	8.6568	8.6743	8.6	8.6396	83954976.0
2010-07-19 13:00:00	AAPL	Stock	8.6385	8.6489	8.6004	8.6135	60797044.0
2010-07-19 14:00:00	AAPL	Stock	8.6121	8.7606	8.6093	8.7143	123580828.0
2010-07-19 15:00:00	AAPL	Stock	8.7145	8.7786	8.7057	8.7729	135345308.0
2010-07-19 16:00:00	AAPL	Stock	8.7707	8.9268	8.6707	8.6879	14550228.0
2010-07-19 17:00:00	AAPL	Stock	8.6943	8.7125	8.6875	8.6954	651756.0
2010-07-19 18:00:00	AAPL	Stock	8.6929	8.7707	8.6929	8.7007	396116.0
2010-07-19 19:00:00	AAPL	Stock	8.7032	8.7032	8.6929	8.6929	438228.0
2010-07-19 04:00:00	MSFT	Stock	24.97	24.97	24.97	24.97	497.0
2010-07-19 05:00:00	MSFT	Stock	24.97	25.01	24.97	25.01	1697.0
2010-07-19 07:00:00	MSFT	Stock	25.03	25.05	25.01	25.02	5362.0
2010-07-19 08:00:00	MSFT	Stock	25.02	25.1	24.97	25.1	82847.0
2010-07-19 09:00:00	MSFT	Stock	25.08	25.3	24.91	25.21	4858298.0
2010-07-19 10:00:00	MSFT	Stock	25.21	25.23	25.05	25.11	6464802.0
2010-07-19 11:00:00	MSFT	Stock	25.12	25.21	25.08	25.185	4371114.0
2010-07-19 12:00:00	MSFT	Stock	25.18	25.19	25.07	25.1	3861172.0
2010-07-19 13:00:00	MSFT	Stock	25.1	25.11	25.03	25.1	2324657.0
2010-07-19 14:00:00	MSFT	Stock	25.1	25.29	25.09	25.19	4592305.0
2010-07-19 15:00:00	MSFT	Stock	25.19	25.285	25.14	25.24	7437289.0
2010-07-19 16:00:00	MSFT	Stock	25.24	25.24	24.85	24.91	2500122.0
2010-07-19 17:00:00	MSFT	Stock	24.91	24.95	24.9	24.9	10075.0
2010-07-19 18:00:00	MSFT	Stock	24.94	25.23	24.89	24.92	740542.0
2010-07-19 19:00:00	MSFT	Stock	24.92	24.98	24.87	24.98	5582.0
2010-07-19 07:00:00	NVDA	Stock	0.255	0.255	0.2545	0.2547	100000.0
2010-07-19 08:00:00	NVDA	Stock	0.254	0.2558	0.2538	0.2553	1230960.0
2010-07-19 09:00:00	NVDA	Stock	0.255	0.2588	0.253	0.257	123539480.0
2010-07-19 10:00:00	NVDA	Stock	0.257	0.2578	0.255	0.2567	138090240.0
2010-07-19 11:00:00	NVDA	Stock	0.2568	0.259	0.2563	0.2585	71993960.0
2010-07-19 12:00:00	NVDA	Stock	0.2583	0.2595	0.2568	0.258	80412040.0
2010-07-19 13:00:00	NVDA	Stock	0.258	0.2588	0.2572	0.2584	44872720.0
2010-07-19 14:00:00	NVDA	Stock	0.2583	0.2618	0.258	0.2605	116369560.0
2010-07-19 15:00:00	NVDA	Stock	0.2605	0.2625	0.2603	0.2615	196599400.0
2010-07-19 16:00:00	NVDA	Stock	0.2612	0.2616	0.253	0.2545	17226800.0
2010-07-19 17:00:00	NVDA	Stock	0.2545	0.2572	0.2533	0.2555	836080.0
2010-07-19 18:00:00	NVDA	Stock	0.2558	0.2563	0.255	0.255	456400.0
2010-07-19 19:00:00	NVDA	Stock	0.2545	0.2563	0.2545	0.256	250000.0
2010-07-19 08:00:00	AMZN	Stock	5.908	5.9245	5.902	5.9245	41700.0
2010-07-19 09:00:00	AMZN	Stock	5.9205	5.9615	5.9005	5.9275	8188900.0
2010-07-19 10:00:00	AMZN	Stock	5.9275	5.948	5.85	5.8905	20339240.0
2010-07-19 11:00:00	AMZN	Stock	5.89	5.9685	5.885	5.9605	10745920.0
2010-07-19 12:00:00	AMZN	Stock	5.9605	6.0278	5.9465	6.02	16218720.0
2010-07-19 13:00:00	AMZN	Stock	6.019	6.019	5.961	5.9658	11001480.0

> showing 50 of 41,915 rows — these rows as CSV

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