PREVIEW / stock_1hour / 2010-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-04.parquet
  size:    892 KB
  rows:    42,720
  symbols: 3,446

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-04 07:00:00	AAPL	Stock	7.4836	7.4839	7.4704	7.4711	78484.0
2010-03-04 08:00:00	AAPL	Stock	7.475	7.4839	7.4607	7.4839	1068508.0
2010-03-04 09:00:00	AAPL	Stock	7.4839	7.5329	7.4511	7.525	72621836.0
2010-03-04 10:00:00	AAPL	Stock	7.525	7.5264	7.4661	7.4893	82764192.0
2010-03-04 11:00:00	AAPL	Stock	7.4907	7.5164	7.4875	7.5118	39153688.0
2010-03-04 12:00:00	AAPL	Stock	7.5118	7.515	7.4986	7.5036	23870252.0
2010-03-04 13:00:00	AAPL	Stock	7.5043	7.5143	7.4929	7.4982	25280976.0
2010-03-04 14:00:00	AAPL	Stock	7.4984	7.5282	7.4971	7.5229	42376432.0
2010-03-04 15:00:00	AAPL	Stock	7.5225	7.5311	7.5018	7.5268	57661268.0
2010-03-04 16:00:00	AAPL	Stock	7.5254	7.5314	7.4694	7.5268	9191672.0
2010-03-04 17:00:00	AAPL	Stock	7.5268	7.5304	7.5257	7.5304	296156.0
2010-03-04 18:00:00	AAPL	Stock	7.5304	7.6214	7.5304	7.5964	6406624.0
2010-03-04 19:00:00	AAPL	Stock	7.5946	7.6036	7.5946	7.6	1057728.0
2010-03-04 08:00:00	MSFT	Stock	28.57	28.59	28.5	28.55	13016.0
2010-03-04 09:00:00	MSFT	Stock	28.55	28.55	28.27	28.4	5640858.0
2010-03-04 10:00:00	MSFT	Stock	28.39	28.49	28.34	28.41	6107088.0
2010-03-04 11:00:00	MSFT	Stock	28.41	28.45	28.37	28.428	5593741.0
2010-03-04 12:00:00	MSFT	Stock	28.43	28.49	28.39	28.46	4292199.0
2010-03-04 13:00:00	MSFT	Stock	28.461	28.52	28.39	28.47	3420536.0
2010-03-04 14:00:00	MSFT	Stock	28.46	28.6	28.44	28.534	4781194.0
2010-03-04 15:00:00	MSFT	Stock	28.532	28.65	28.47	28.63	7739950.0
2010-03-04 16:00:00	MSFT	Stock	28.63	28.65	28.42	28.59	3864609.0
2010-03-04 17:00:00	MSFT	Stock	28.6	28.6	28.57	28.57	961.0
2010-03-04 18:00:00	MSFT	Stock	28.57	28.63	28.5	28.57	2366.0
2010-03-04 19:00:00	MSFT	Stock	28.55	28.62	28.55	28.56	3300.0
2010-03-04 08:00:00	NVDA	Stock	0.42	0.4213	0.4182	0.4185	142160.0
2010-03-04 09:00:00	NVDA	Stock	0.418	0.4208	0.4142	0.4198	56840440.0
2010-03-04 10:00:00	NVDA	Stock	0.4198	0.4199	0.4128	0.4173	83836240.0
2010-03-04 11:00:00	NVDA	Stock	0.4171	0.4178	0.413	0.4133	75707480.0
2010-03-04 12:00:00	NVDA	Stock	0.413	0.4134	0.4115	0.4125	63058360.0
2010-03-04 13:00:00	NVDA	Stock	0.4125	0.416	0.412	0.4133	60393960.0
2010-03-04 14:00:00	NVDA	Stock	0.4133	0.4135	0.4118	0.412	61599200.0
2010-03-04 15:00:00	NVDA	Stock	0.4122	0.4168	0.4112	0.4165	140399080.0
2010-03-04 16:00:00	NVDA	Stock	0.4162	0.4166	0.4108	0.4108	10023760.0
2010-03-04 17:00:00	NVDA	Stock	0.4125	0.4125	0.4125	0.4125	40000.0
2010-03-04 18:00:00	NVDA	Stock	0.4165	0.4165	0.4165	0.4165	487720.0
2010-03-04 19:00:00	NVDA	Stock	0.413	0.413	0.411	0.411	67000.0
2010-03-04 08:00:00	AMZN	Stock	6.3	6.3375	6.2945	6.3375	155820.0
2010-03-04 09:00:00	AMZN	Stock	6.341	6.385	6.2785	6.3625	18787680.0
2010-03-04 10:00:00	AMZN	Stock	6.3615	6.3765	6.3295	6.365	28136820.0
2010-03-04 11:00:00	AMZN	Stock	6.3645	6.419	6.358	6.399	28139780.0
2010-03-04 12:00:00	AMZN	Stock	6.3995	6.3995	6.3715	6.3856	10056280.0
2010-03-04 13:00:00	AMZN	Stock	6.386	6.4025	6.3755	6.4006	9326400.0
2010-03-04 14:00:00	AMZN	Stock	6.401	6.433	6.3935	6.4295	18648700.0
2010-03-04 15:00:00	AMZN	Stock	6.4285	6.4425	6.396	6.4265	31911180.0
2010-03-04 16:00:00	AMZN	Stock	6.427	6.441	6.2888	6.4375	3219860.0
2010-03-04 17:00:00	AMZN	Stock	6.2945	6.4325	6.2945	6.4325	16000.0
2010-03-04 18:00:00	AMZN	Stock	6.4265	6.434	6.4125	6.415	328000.0
2010-03-04 19:00:00	AMZN	Stock	6.424	6.435	6.424	6.435	56300.0
2010-03-04 08:00:00	TLT	Stock	91.07	91.07	90.92	90.92	3842.0

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

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