PREVIEW / stock_1hour / 2007-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-13.parquet
  size:    778 KB
  rows:    38,391
  symbols: 3,134

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
2007-08-13 09:00:00	AAPL	Stock	4.5829	4.595	4.5179	4.5289	122300332.0
2007-08-13 10:00:00	AAPL	Stock	4.5296	4.5754	4.5282	4.5643	110559904.0
2007-08-13 11:00:00	AAPL	Stock	4.5636	4.6175	4.5621	4.6093	121104228.0
2007-08-13 12:00:00	AAPL	Stock	4.6086	4.6096	4.5718	4.5986	68372416.0
2007-08-13 13:00:00	AAPL	Stock	4.5982	4.6	4.5643	4.5971	75774048.0
2007-08-13 14:00:00	AAPL	Stock	4.5971	4.6196	4.5786	4.595	78258320.0
2007-08-13 15:00:00	AAPL	Stock	4.5969	4.6014	4.5586	4.5661	125185732.0
2007-08-13 16:00:00	AAPL	Stock	4.5661	4.5668	4.5639	4.5639	14168616.0
2007-08-13 09:00:00	MSFT	Stock	28.94	28.97	28.52	28.54	5289736.0
2007-08-13 10:00:00	MSFT	Stock	28.55	28.68	28.49	28.55	7101871.0
2007-08-13 11:00:00	MSFT	Stock	28.55	28.79	28.44	28.77	6135627.0
2007-08-13 12:00:00	MSFT	Stock	28.77	28.81	28.63	28.75	3597059.0
2007-08-13 13:00:00	MSFT	Stock	28.75	28.77	28.53	28.75	5707817.0
2007-08-13 14:00:00	MSFT	Stock	28.75	28.99	28.74	28.96	5146286.0
2007-08-13 15:00:00	MSFT	Stock	28.95	28.97	28.58	28.65	10672485.0
2007-08-13 16:00:00	MSFT	Stock	28.66	28.66	28.63	28.63	1863581.0
2007-08-13 08:00:00	NVDA	Stock	0.725	0.7397	0.725	0.7387	789540.0
2007-08-13 09:00:00	NVDA	Stock	0.7392	0.744	0.71	0.7173	113306640.0
2007-08-13 10:00:00	NVDA	Stock	0.7173	0.7353	0.7162	0.7265	125544660.0
2007-08-13 11:00:00	NVDA	Stock	0.7263	0.7322	0.7225	0.731	63612540.0
2007-08-13 12:00:00	NVDA	Stock	0.731	0.7342	0.728	0.7335	53766300.0
2007-08-13 13:00:00	NVDA	Stock	0.7337	0.735	0.7283	0.7348	57584100.0
2007-08-13 14:00:00	NVDA	Stock	0.7347	0.743	0.7332	0.7388	80300700.0
2007-08-13 15:00:00	NVDA	Stock	0.7393	0.7405	0.7235	0.7257	177764760.0
2007-08-13 16:00:00	NVDA	Stock	0.7252	0.7252	0.716	0.7238	2958660.0
2007-08-13 17:00:00	NVDA	Stock	0.723	0.7237	0.7182	0.7217	413580.0
2007-08-13 18:00:00	NVDA	Stock	0.7232	0.7252	0.7223	0.7223	8620080.0
2007-08-13 19:00:00	NVDA	Stock	0.7223	0.7223	0.72	0.72	75000.0
2007-08-13 07:00:00	AMZN	Stock	3.765	3.77	3.765	3.77	16000.0
2007-08-13 08:00:00	AMZN	Stock	3.7825	3.815	3.7825	3.8	119860.0
2007-08-13 09:00:00	AMZN	Stock	3.793	3.808	3.7605	3.7625	16450300.0
2007-08-13 10:00:00	AMZN	Stock	3.762	3.816	3.76	3.786	24219640.0
2007-08-13 11:00:00	AMZN	Stock	3.787	3.8085	3.7815	3.798	18122580.0
2007-08-13 12:00:00	AMZN	Stock	3.7985	3.8065	3.775	3.7865	12514380.0
2007-08-13 13:00:00	AMZN	Stock	3.7865	3.7965	3.75	3.77	12061400.0
2007-08-13 14:00:00	AMZN	Stock	3.772	3.777	3.7465	3.7545	12398000.0
2007-08-13 15:00:00	AMZN	Stock	3.7545	3.767	3.735	3.7445	19285820.0
2007-08-13 16:00:00	AMZN	Stock	3.743	3.7435	3.735	3.735	411480.0
2007-08-13 17:00:00	AMZN	Stock	3.7175	3.735	3.7175	3.735	35840.0
2007-08-13 19:00:00	AMZN	Stock	3.73	3.73	3.718	3.718	28500.0
2007-08-13 09:00:00	TLT	Stock	85.92	86.15	85.9	86.1	241800.0
2007-08-13 10:00:00	TLT	Stock	86.11	86.18	86.07	86.14	228700.0
2007-08-13 11:00:00	TLT	Stock	86.11	86.22	86.11	86.16	416000.0
2007-08-13 12:00:00	TLT	Stock	86.15	86.36	86.13	86.33	198200.0
2007-08-13 13:00:00	TLT	Stock	86.3	86.4	86.27	86.33	92600.0
2007-08-13 14:00:00	TLT	Stock	86.32	86.39	86.28	86.34	58500.0
2007-08-13 15:00:00	TLT	Stock	86.34	86.36	86.26	86.34	73700.0
2007-08-13 16:00:00	TLT	Stock	86.32	86.4	86.32	86.33	2000.0
2007-08-13 09:00:00	CL	Stock	33.65	33.65	33.1	33.335	563600.0
2007-08-13 10:00:00	CL	Stock	33.335	33.42	33.095	33.1145	978400.0

> showing 50 of 38,391 rows — these rows as CSV

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