PREVIEW / stock_1hour / 2006-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-11.parquet
  size:    608 KB
  rows:    28,946
  symbols: 2,381

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
2006-10-11 08:00:00	AAPL	Stock	2.6239	2.6286	2.6161	2.6214	923048.0
2006-10-11 09:00:00	AAPL	Stock	2.6214	2.6429	2.5946	2.6007	95215204.0
2006-10-11 10:00:00	AAPL	Stock	2.6004	2.6175	2.5964	2.6129	99964760.0
2006-10-11 11:00:00	AAPL	Stock	2.6129	2.6336	2.6111	2.6289	68345116.0
2006-10-11 12:00:00	AAPL	Stock	2.6289	2.6343	2.6229	2.6321	42068544.0
2006-10-11 13:00:00	AAPL	Stock	2.6318	2.6421	2.6314	2.6368	58082332.0
2006-10-11 14:00:00	AAPL	Stock	2.6368	2.6386	2.5929	2.6086	128277884.0
2006-10-11 15:00:00	AAPL	Stock	2.6089	2.6225	2.6036	2.6139	70315252.0
2006-10-11 16:00:00	AAPL	Stock	2.6132	2.6171	2.6111	2.6171	919016.0
2006-10-11 17:00:00	AAPL	Stock	2.6164	2.6175	2.6118	2.6143	497028.0
2006-10-11 18:00:00	AAPL	Stock	2.6118	2.6118	2.6118	2.6118	2800.0
2006-10-11 19:00:00	AAPL	Stock	2.6154	2.6154	2.6154	2.6154	19600.0
2006-10-11 07:00:00	MSFT	Stock	27.66	27.66	27.56	27.56	500.0
2006-10-11 08:00:00	MSFT	Stock	27.6	27.6	27.46	27.5	21965.0
2006-10-11 09:00:00	MSFT	Stock	27.53	27.59	27.44	27.56	5207171.0
2006-10-11 10:00:00	MSFT	Stock	27.559	27.64	27.54	27.57	5095103.0
2006-10-11 11:00:00	MSFT	Stock	27.57	27.66	27.53	27.62	3038743.0
2006-10-11 12:00:00	MSFT	Stock	27.63	27.67	27.5	27.63	3212204.0
2006-10-11 13:00:00	MSFT	Stock	27.63	27.66	27.61	27.63	1930281.0
2006-10-11 14:00:00	MSFT	Stock	27.63	27.65	27.42	27.509	8135333.0
2006-10-11 15:00:00	MSFT	Stock	27.51	27.588	27.47	27.54	8180453.0
2006-10-11 16:00:00	MSFT	Stock	27.54	27.56	27.47	27.51	409277.0
2006-10-11 17:00:00	MSFT	Stock	27.5	27.54	27.49	27.54	10126.0
2006-10-11 18:00:00	MSFT	Stock	27.5	27.5	27.48	27.48	4700.0
2006-10-11 08:00:00	NVDA	Stock	0.5353	0.5353	0.5333	0.5333	102000.0
2006-10-11 09:00:00	NVDA	Stock	0.533	0.5397	0.5252	0.5292	70180380.0
2006-10-11 10:00:00	NVDA	Stock	0.5293	0.5383	0.5272	0.5377	68609880.0
2006-10-11 11:00:00	NVDA	Stock	0.5375	0.5428	0.5363	0.5417	57280320.0
2006-10-11 12:00:00	NVDA	Stock	0.5418	0.5463	0.541	0.5445	49650780.0
2006-10-11 13:00:00	NVDA	Stock	0.5445	0.5487	0.5437	0.5467	45499980.0
2006-10-11 14:00:00	NVDA	Stock	0.5467	0.5473	0.5298	0.5353	102559380.0
2006-10-11 15:00:00	NVDA	Stock	0.5355	0.5417	0.5337	0.5392	66859140.0
2006-10-11 16:00:00	NVDA	Stock	0.5392	0.5417	0.5392	0.5417	3859800.0
2006-10-11 17:00:00	NVDA	Stock	0.54	0.5432	0.5392	0.5392	487020.0
2006-10-11 18:00:00	NVDA	Stock	0.5392	0.5392	0.5392	0.5392	10500.0
2006-10-11 08:00:00	AMZN	Stock	1.63	1.63	1.6245	1.6245	8000.0
2006-10-11 09:00:00	AMZN	Stock	1.622	1.6425	1.6135	1.6355	16728320.0
2006-10-11 10:00:00	AMZN	Stock	1.6355	1.6395	1.626	1.6385	15571200.0
2006-10-11 11:00:00	AMZN	Stock	1.639	1.6565	1.6345	1.6525	18118720.0
2006-10-11 12:00:00	AMZN	Stock	1.653	1.6555	1.6475	1.6495	21142360.0
2006-10-11 13:00:00	AMZN	Stock	1.6495	1.6575	1.6485	1.6555	5976860.0
2006-10-11 14:00:00	AMZN	Stock	1.656	1.6565	1.6295	1.6415	21149120.0
2006-10-11 15:00:00	AMZN	Stock	1.642	1.6525	1.6375	1.6475	26621140.0
2006-10-11 16:00:00	AMZN	Stock	1.6475	1.6505	1.6445	1.6505	216580.0
2006-10-11 17:00:00	AMZN	Stock	1.6455	1.6455	1.6455	1.6455	2260.0
2006-10-11 18:00:00	AMZN	Stock	1.6455	1.6455	1.645	1.645	24000.0
2006-10-11 19:00:00	AMZN	Stock	1.6425	1.6425	1.6425	1.6425	10000.0
2006-10-11 08:00:00	CL	Stock	31.125	31.125	31.125	31.125	25800.0
2006-10-11 09:00:00	CL	Stock	31.005	31.09	31.005	31.01	287200.0
2006-10-11 10:00:00	CL	Stock	31.02	31.3	31.01	31.075	701600.0

> showing 50 of 28,946 rows — these rows as CSV

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