PREVIEW / stock_1hour / 2010-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-06.parquet
  size:    916 KB
  rows:    43,422
  symbols: 3,462

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-04-06 04:00:00	AAPL	Stock	8.5089	8.5393	8.5089	8.5393	26040.0
2010-04-06 05:00:00	AAPL	Stock	8.5393	8.5393	8.525	8.5393	31920.0
2010-04-06 06:00:00	AAPL	Stock	8.5361	8.5393	8.5361	8.5386	19040.0
2010-04-06 07:00:00	AAPL	Stock	8.5293	8.5361	8.5196	8.5304	457268.0
2010-04-06 08:00:00	AAPL	Stock	8.5304	8.5304	8.4829	8.5021	3613176.0
2010-04-06 09:00:00	AAPL	Stock	8.5025	8.5175	8.4643	8.4846	76741392.0
2010-04-06 10:00:00	AAPL	Stock	8.4846	8.5107	8.4679	8.5025	81055240.0
2010-04-06 11:00:00	AAPL	Stock	8.503	8.5314	8.4939	8.5247	62395704.0
2010-04-06 12:00:00	AAPL	Stock	8.5243	8.5286	8.5086	8.5229	30012780.0
2010-04-06 13:00:00	AAPL	Stock	8.5229	8.5429	8.5125	8.5343	39592784.0
2010-04-06 14:00:00	AAPL	Stock	8.5346	8.58	8.5314	8.5725	73749228.0
2010-04-06 15:00:00	AAPL	Stock	8.5732	8.5768	8.5418	8.5593	65897748.0
2010-04-06 16:00:00	AAPL	Stock	8.5554	8.56	8.5212	8.5564	6399008.0
2010-04-06 17:00:00	AAPL	Stock	8.5546	8.5589	8.5546	8.5582	352324.0
2010-04-06 18:00:00	AAPL	Stock	8.5589	8.5607	8.555	8.5589	384524.0
2010-04-06 19:00:00	AAPL	Stock	8.5586	8.56	8.5554	8.5582	659092.0
2010-04-06 07:00:00	MSFT	Stock	29.24	29.24	29.24	29.24	400.0
2010-04-06 08:00:00	MSFT	Stock	29.24	29.24	29.17	29.2	14040.0
2010-04-06 09:00:00	MSFT	Stock	29.22	29.25	29.06	29.128	4044138.0
2010-04-06 10:00:00	MSFT	Stock	29.13	29.16	28.98	29.135	8181327.0
2010-04-06 11:00:00	MSFT	Stock	29.135	29.36	29.09	29.355	6587315.0
2010-04-06 12:00:00	MSFT	Stock	29.36	29.4	29.26	29.34	5508387.0
2010-04-06 13:00:00	MSFT	Stock	29.332	29.41	29.33	29.38	3915281.0
2010-04-06 14:00:00	MSFT	Stock	29.37	29.58	29.36	29.45	7104558.0
2010-04-06 15:00:00	MSFT	Stock	29.45	29.49	29.32	29.33	8036956.0
2010-04-06 16:00:00	MSFT	Stock	29.33	29.406	29.25	29.33	2242707.0
2010-04-06 17:00:00	MSFT	Stock	29.34	29.35	29.34	29.34	4419.0
2010-04-06 18:00:00	MSFT	Stock	29.34	29.35	29.32	29.32	3670.0
2010-04-06 19:00:00	MSFT	Stock	29.39	29.39	29.33	29.33	1602.0
2010-04-06 20:00:00	MSFT	Stock	29.36	29.36	29.28	29.28	212200.0
2010-04-06 08:00:00	NVDA	Stock	0.4305	0.4305	0.4305	0.4305	20000.0
2010-04-06 09:00:00	NVDA	Stock	0.4325	0.4362	0.4188	0.4208	136175000.0
2010-04-06 10:00:00	NVDA	Stock	0.4208	0.4258	0.4195	0.4245	279246800.0
2010-04-06 11:00:00	NVDA	Stock	0.4245	0.428	0.424	0.4275	89614640.0
2010-04-06 12:00:00	NVDA	Stock	0.4275	0.428	0.4265	0.4269	60421480.0
2010-04-06 13:00:00	NVDA	Stock	0.4268	0.4272	0.425	0.4254	36234480.0
2010-04-06 14:00:00	NVDA	Stock	0.4255	0.427	0.4253	0.4265	44801280.0
2010-04-06 15:00:00	NVDA	Stock	0.4265	0.4268	0.4248	0.4265	151619960.0
2010-04-06 16:00:00	NVDA	Stock	0.4262	0.4272	0.4245	0.4262	2708880.0
2010-04-06 17:00:00	NVDA	Stock	0.4275	0.428	0.4275	0.4278	116000.0
2010-04-06 18:00:00	NVDA	Stock	0.4288	0.4288	0.4282	0.4282	128000.0
2010-04-06 19:00:00	NVDA	Stock	0.428	0.428	0.427	0.427	44000.0
2010-04-06 20:00:00	NVDA	Stock	0.4395	0.4395	0.4395	0.4395	760000.0
2010-04-06 08:00:00	AMZN	Stock	6.55	6.565	6.55	6.565	46780.0
2010-04-06 09:00:00	AMZN	Stock	6.56	6.8	6.5555	6.787	39533300.0
2010-04-06 10:00:00	AMZN	Stock	6.7887	6.796	6.7175	6.7695	42725020.0
2010-04-06 11:00:00	AMZN	Stock	6.769	6.786	6.7535	6.769	13085640.0
2010-04-06 12:00:00	AMZN	Stock	6.769	6.7775	6.742	6.749	8047900.0
2010-04-06 13:00:00	AMZN	Stock	6.7485	6.793	6.747	6.7695	11604480.0
2010-04-06 14:00:00	AMZN	Stock	6.77	6.7985	6.767	6.794	14990480.0

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

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