PREVIEW / stock_1hour / 2009-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-06.parquet
  size:    878 KB
  rows:    42,146
  symbols: 3,368

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
2009-11-06 05:00:00	AAPL	Stock	6.9407	6.9629	6.9407	6.9514	11200.0
2009-11-06 07:00:00	AAPL	Stock	6.9393	6.9504	6.9143	6.9461	113008.0
2009-11-06 08:00:00	AAPL	Stock	6.9464	6.9621	6.8393	6.8632	6095600.0
2009-11-06 09:00:00	AAPL	Stock	6.8632	6.9711	6.8518	6.95	75515104.0
2009-11-06 10:00:00	AAPL	Stock	6.95	6.9582	6.8839	6.9267	64101884.0
2009-11-06 11:00:00	AAPL	Stock	6.9243	6.9449	6.9164	6.9204	30603608.0
2009-11-06 12:00:00	AAPL	Stock	6.9189	6.9455	6.9189	6.9293	24079216.0
2009-11-06 13:00:00	AAPL	Stock	6.9302	6.9429	6.9232	6.9275	21425852.0
2009-11-06 14:00:00	AAPL	Stock	6.9275	6.9339	6.9143	6.9286	20332928.0
2009-11-06 15:00:00	AAPL	Stock	6.9296	6.9436	6.9179	6.9411	36322636.0
2009-11-06 16:00:00	AAPL	Stock	6.9407	6.9496	6.9179	6.9436	5121004.0
2009-11-06 17:00:00	AAPL	Stock	6.9461	6.9482	6.9439	6.9482	86016.0
2009-11-06 18:00:00	AAPL	Stock	6.9471	6.9486	6.9407	6.9482	3089632.0
2009-11-06 19:00:00	AAPL	Stock	6.9482	6.9511	6.9475	6.9511	97944.0
2009-11-06 07:00:00	MSFT	Stock	28.5	28.6	28.46	28.5	1570.0
2009-11-06 08:00:00	MSFT	Stock	28.58	28.62	28.28	28.35	100591.0
2009-11-06 09:00:00	MSFT	Stock	28.35	28.6	28.2	28.58	7291530.0
2009-11-06 10:00:00	MSFT	Stock	28.58	28.63	28.28	28.44	6949282.0
2009-11-06 11:00:00	MSFT	Stock	28.43	28.53	28.41	28.478	4422378.0
2009-11-06 12:00:00	MSFT	Stock	28.49	28.52	28.43	28.46	4012226.0
2009-11-06 13:00:00	MSFT	Stock	28.45	28.55	28.44	28.47	2890663.0
2009-11-06 14:00:00	MSFT	Stock	28.47	28.623	28.45	28.48	4163717.0
2009-11-06 15:00:00	MSFT	Stock	28.48	28.52	28.42	28.52	6657643.0
2009-11-06 16:00:00	MSFT	Stock	28.52	28.6	28.43	28.52	993317.0
2009-11-06 17:00:00	MSFT	Stock	28.506	28.58	28.5	28.53	4198.0
2009-11-06 18:00:00	MSFT	Stock	28.57	28.57	28.52	28.52	322729.0
2009-11-06 19:00:00	MSFT	Stock	28.58	28.58	28.54	28.57	1500.0
2009-11-06 07:00:00	NVDA	Stock	0.325	0.33	0.325	0.3283	221640.0
2009-11-06 08:00:00	NVDA	Stock	0.329	0.3295	0.3195	0.3213	15296760.0
2009-11-06 09:00:00	NVDA	Stock	0.3208	0.3315	0.3065	0.3243	453287200.0
2009-11-06 10:00:00	NVDA	Stock	0.3243	0.3325	0.3238	0.3316	369835440.0
2009-11-06 11:00:00	NVDA	Stock	0.3318	0.3358	0.3273	0.3282	272676760.0
2009-11-06 12:00:00	NVDA	Stock	0.3283	0.33	0.3258	0.3275	136014600.0
2009-11-06 13:00:00	NVDA	Stock	0.3275	0.3288	0.3265	0.327	65522760.0
2009-11-06 14:00:00	NVDA	Stock	0.3271	0.329	0.3258	0.3283	78642920.0
2009-11-06 15:00:00	NVDA	Stock	0.3283	0.33	0.3265	0.329	227513680.0
2009-11-06 16:00:00	NVDA	Stock	0.329	0.3295	0.3276	0.329	16710840.0
2009-11-06 17:00:00	NVDA	Stock	0.3278	0.3278	0.3278	0.3278	91200.0
2009-11-06 18:00:00	NVDA	Stock	0.3288	0.329	0.328	0.329	211200.0
2009-11-06 19:00:00	NVDA	Stock	0.329	0.3295	0.3278	0.3278	477200.0
2009-11-06 04:00:00	AMZN	Stock	6.05	6.1	6.05	6.1	16000.0
2009-11-06 05:00:00	AMZN	Stock	6.1155	6.1155	6.1155	6.1155	10000.0
2009-11-06 06:00:00	AMZN	Stock	6.1155	6.1155	6.112	6.1125	79000.0
2009-11-06 07:00:00	AMZN	Stock	6.1155	6.19	6.093	6.13	172260.0
2009-11-06 08:00:00	AMZN	Stock	6.128	6.2115	6.095	6.1225	4664880.0
2009-11-06 09:00:00	AMZN	Stock	6.1225	6.2845	6.0305	6.268	59165380.0
2009-11-06 10:00:00	AMZN	Stock	6.268	6.349	6.2125	6.2725	78633800.0
2009-11-06 11:00:00	AMZN	Stock	6.273	6.3135	6.267	6.2972	33273800.0
2009-11-06 12:00:00	AMZN	Stock	6.2976	6.33	6.289	6.301	21031000.0
2009-11-06 13:00:00	AMZN	Stock	6.3011	6.3215	6.293	6.3002	10934500.0

> showing 50 of 42,146 rows — these rows as CSV

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