PREVIEW / stock_1hour / 2008-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-01.parquet
  size:    841 KB
  rows:    40,102
  symbols: 3,285

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
2008-05-01 07:00:00	AAPL	Stock	6.2479	6.2711	6.2464	6.2611	358624.0
2008-05-01 08:00:00	AAPL	Stock	6.2643	6.2857	6.2125	6.25	5732300.0
2008-05-01 09:00:00	AAPL	Stock	6.2496	6.3279	6.2125	6.3132	118966904.0
2008-05-01 10:00:00	AAPL	Stock	6.315	6.3525	6.3045	6.335	143130120.0
2008-05-01 11:00:00	AAPL	Stock	6.3343	6.3757	6.3307	6.3411	109133668.0
2008-05-01 12:00:00	AAPL	Stock	6.3418	6.4089	6.3418	6.3932	117023704.0
2008-05-01 13:00:00	AAPL	Stock	6.3932	6.4107	6.3518	6.3711	98046312.0
2008-05-01 14:00:00	AAPL	Stock	6.3705	6.4071	6.3593	6.3897	91944440.0
2008-05-01 15:00:00	AAPL	Stock	6.3896	6.4286	6.3714	6.4286	185362520.0
2008-05-01 16:00:00	AAPL	Stock	6.4276	6.4464	6.3571	6.4393	20321672.0
2008-05-01 17:00:00	AAPL	Stock	6.4361	6.4411	6.4296	6.4296	329476.0
2008-05-01 18:00:00	AAPL	Stock	6.4296	6.4375	6.4286	6.4325	722204.0
2008-05-01 19:00:00	AAPL	Stock	6.4325	6.4357	6.4286	6.4293	430808.0
2008-05-01 08:00:00	MSFT	Stock	28.6	28.6	28.49	28.52	48449.0
2008-05-01 09:00:00	MSFT	Stock	28.5	28.68	28.46	28.631	6049794.0
2008-05-01 10:00:00	MSFT	Stock	28.64	28.89	28.63	28.78	9759600.0
2008-05-01 11:00:00	MSFT	Stock	28.77	28.85	28.71	28.81	6436821.0
2008-05-01 12:00:00	MSFT	Stock	28.81	29.12	28.8	29.032	7251773.0
2008-05-01 13:00:00	MSFT	Stock	29.032	29.29	28.81	29.09	12327912.0
2008-05-01 14:00:00	MSFT	Stock	29.082	29.19	29.01	29.15	7771095.0
2008-05-01 15:00:00	MSFT	Stock	29.14	29.49	29.07	29.36	17768197.0
2008-05-01 16:00:00	MSFT	Stock	29.361	29.43	28.5	29.4	2806255.0
2008-05-01 17:00:00	MSFT	Stock	29.39	29.42	28.595	29.4	66983.0
2008-05-01 18:00:00	MSFT	Stock	29.4	29.42	29.35	29.36	18380.0
2008-05-01 19:00:00	MSFT	Stock	29.35	29.35	29.29	29.32	6723.0
2008-05-01 08:00:00	NVDA	Stock	0.5162	0.5213	0.5138	0.52	681160.0
2008-05-01 09:00:00	NVDA	Stock	0.5213	0.5318	0.5175	0.5282	167709640.0
2008-05-01 10:00:00	NVDA	Stock	0.5282	0.5305	0.5245	0.5282	190127760.0
2008-05-01 11:00:00	NVDA	Stock	0.5282	0.5332	0.5275	0.5305	126651040.0
2008-05-01 12:00:00	NVDA	Stock	0.5306	0.5372	0.5302	0.5362	156813160.0
2008-05-01 13:00:00	NVDA	Stock	0.5362	0.5375	0.5308	0.5318	97133200.0
2008-05-01 14:00:00	NVDA	Stock	0.5318	0.5362	0.5305	0.533	98636480.0
2008-05-01 15:00:00	NVDA	Stock	0.533	0.5388	0.5305	0.5375	151888480.0
2008-05-01 16:00:00	NVDA	Stock	0.5375	0.538	0.5311	0.5375	17431840.0
2008-05-01 17:00:00	NVDA	Stock	0.5382	0.5388	0.5322	0.5375	1156000.0
2008-05-01 18:00:00	NVDA	Stock	0.5375	0.5388	0.5375	0.5385	144000.0
2008-05-01 19:00:00	NVDA	Stock	0.5385	0.5412	0.5385	0.5412	168000.0
2008-05-01 08:00:00	AMZN	Stock	3.925	3.976	3.925	3.9315	600940.0
2008-05-01 09:00:00	AMZN	Stock	3.9375	3.947	3.8985	3.9355	16225640.0
2008-05-01 10:00:00	AMZN	Stock	3.936	3.9825	3.9275	3.9715	29020360.0
2008-05-01 11:00:00	AMZN	Stock	3.9715	3.9955	3.924	3.9295	21498280.0
2008-05-01 12:00:00	AMZN	Stock	3.9295	3.995	3.9295	3.99	19112220.0
2008-05-01 13:00:00	AMZN	Stock	3.989	4.0005	3.9705	3.979	15867200.0
2008-05-01 14:00:00	AMZN	Stock	3.978	3.9875	3.9605	3.9662	14567320.0
2008-05-01 15:00:00	AMZN	Stock	3.9665	3.9715	3.9335	3.968	22942320.0
2008-05-01 16:00:00	AMZN	Stock	3.968	3.9755	3.9508	3.968	2687020.0
2008-05-01 08:00:00	TLT	Stock	92.5	93.1	92.5	93.1	7600.0
2008-05-01 09:00:00	TLT	Stock	93.25	93.65	93.25	93.47	539189.0
2008-05-01 10:00:00	TLT	Stock	93.46	93.5	93.0	93.21	836373.0
2008-05-01 11:00:00	TLT	Stock	93.22	93.41	93.04	93.28	471504.0

> showing 50 of 40,102 rows — these rows as CSV

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