PREVIEW / stock_1hour / 2010-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-30.parquet
  size:    929 KB
  rows:    43,667
  symbols: 3,499

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-30 04:00:00	AAPL	Stock	9.6268	9.6636	9.6107	9.6636	42000.0
2010-04-30 05:00:00	AAPL	Stock	9.6429	9.6429	9.6407	9.6407	28000.0
2010-04-30 06:00:00	AAPL	Stock	9.6346	9.6429	9.6275	9.6275	47516.0
2010-04-30 07:00:00	AAPL	Stock	9.6275	9.6493	9.6196	9.6304	160188.0
2010-04-30 08:00:00	AAPL	Stock	9.6304	9.6486	9.6114	9.6204	2468144.0
2010-04-30 09:00:00	AAPL	Stock	9.6321	9.6632	9.5036	9.5321	74227776.0
2010-04-30 10:00:00	AAPL	Stock	9.5321	9.5639	9.4679	9.5386	83885004.0
2010-04-30 11:00:00	AAPL	Stock	9.5382	9.5457	9.4968	9.5161	42995960.0
2010-04-30 12:00:00	AAPL	Stock	9.5154	9.5227	9.3607	9.3897	76878340.0
2010-04-30 13:00:00	AAPL	Stock	9.3893	9.4361	9.3757	9.3954	58562000.0
2010-04-30 14:00:00	AAPL	Stock	9.3954	9.4182	9.3571	9.3732	60472720.0
2010-04-30 15:00:00	AAPL	Stock	9.3729	9.3989	9.3214	9.3218	111846000.0
2010-04-30 16:00:00	AAPL	Stock	9.3218	9.4643	9.3214	9.3339	21125860.0
2010-04-30 17:00:00	AAPL	Stock	9.3339	9.4989	9.3325	9.3368	343084.0
2010-04-30 18:00:00	AAPL	Stock	9.3386	9.3393	9.3246	9.3282	454412.0
2010-04-30 19:00:00	AAPL	Stock	9.3286	9.3439	9.3286	9.3364	174636.0
2010-04-30 08:00:00	MSFT	Stock	31.13	31.13	31.01	31.02	4750.0
2010-04-30 09:00:00	MSFT	Stock	31.02	31.08	30.74	30.82	7642924.0
2010-04-30 10:00:00	MSFT	Stock	30.82	30.84	30.66	30.8	12749947.0
2010-04-30 11:00:00	MSFT	Stock	30.8	30.9	30.692	30.856	5591871.0
2010-04-30 12:00:00	MSFT	Stock	30.86	30.86	30.52	30.57	5781970.0
2010-04-30 13:00:00	MSFT	Stock	30.57	30.78	30.57	30.67	5515799.0
2010-04-30 14:00:00	MSFT	Stock	30.67	30.78	30.64	30.65	5311972.0
2010-04-30 15:00:00	MSFT	Stock	30.65	30.76	30.53	30.54	14651125.0
2010-04-30 16:00:00	MSFT	Stock	30.54	30.871	30.53	30.55	4255215.0
2010-04-30 17:00:00	MSFT	Stock	30.55	30.55	30.55	30.55	3890.0
2010-04-30 18:00:00	MSFT	Stock	30.54	30.55	30.52	30.54	4072.0
2010-04-30 19:00:00	MSFT	Stock	30.53	30.53	30.53	30.53	1375.0
2010-04-30 08:00:00	NVDA	Stock	0.4162	0.4162	0.4162	0.4162	28000.0
2010-04-30 09:00:00	NVDA	Stock	0.414	0.414	0.4003	0.4058	148682120.0
2010-04-30 10:00:00	NVDA	Stock	0.4055	0.4065	0.4005	0.402	213040120.0
2010-04-30 11:00:00	NVDA	Stock	0.402	0.4035	0.3978	0.399	134267920.0
2010-04-30 12:00:00	NVDA	Stock	0.3993	0.3993	0.3953	0.396	111144920.0
2010-04-30 13:00:00	NVDA	Stock	0.3962	0.4	0.394	0.3978	121989520.0
2010-04-30 14:00:00	NVDA	Stock	0.3975	0.3985	0.394	0.3955	107630800.0
2010-04-30 15:00:00	NVDA	Stock	0.3958	0.397	0.3925	0.3933	200550760.0
2010-04-30 16:00:00	NVDA	Stock	0.3933	0.3993	0.3925	0.3992	24141960.0
2010-04-30 17:00:00	NVDA	Stock	0.3958	0.3958	0.3958	0.3958	37920.0
2010-04-30 18:00:00	NVDA	Stock	0.3938	0.3965	0.3938	0.3965	68000.0
2010-04-30 19:00:00	NVDA	Stock	0.3935	0.3965	0.3933	0.3962	108000.0
2010-04-30 06:00:00	AMZN	Stock	7.1	7.1	7.1	7.1	2000.0
2010-04-30 08:00:00	AMZN	Stock	7.1	7.113	7.0755	7.113	10860.0
2010-04-30 09:00:00	AMZN	Stock	7.0875	7.0875	6.9025	6.9085	15540940.0
2010-04-30 10:00:00	AMZN	Stock	6.9095	6.948	6.879	6.9315	19655920.0
2010-04-30 11:00:00	AMZN	Stock	6.9335	6.9375	6.8795	6.916	11394380.0
2010-04-30 12:00:00	AMZN	Stock	6.916	6.9205	6.8685	6.8855	13576180.0
2010-04-30 13:00:00	AMZN	Stock	6.885	6.939	6.875	6.9175	12790440.0
2010-04-30 14:00:00	AMZN	Stock	6.9161	6.9345	6.894	6.9005	15732760.0
2010-04-30 15:00:00	AMZN	Stock	6.8985	6.915	6.8455	6.863	24398380.0
2010-04-30 16:00:00	AMZN	Stock	6.8585	6.9109	6.8475	6.8605	1313520.0

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

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