PREVIEW / stock_1hour / 2007-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-04.parquet
  size:    763 KB
  rows:    37,808
  symbols: 3,105

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-09-04 09:00:00	AAPL	Stock	4.9979	5.0875	4.9943	5.0723	211926484.0
2007-09-04 10:00:00	AAPL	Stock	5.0729	5.1169	5.0679	5.0968	235144168.0
2007-09-04 11:00:00	AAPL	Stock	5.0968	5.1107	5.0906	5.1032	106756272.0
2007-09-04 12:00:00	AAPL	Stock	5.1032	5.1211	5.0925	5.1125	96296368.0
2007-09-04 13:00:00	AAPL	Stock	5.1129	5.1486	5.1079	5.1457	113693664.0
2007-09-04 14:00:00	AAPL	Stock	5.1457	5.1782	5.1332	5.1721	120950452.0
2007-09-04 15:00:00	AAPL	Stock	5.1721	5.2046	5.1211	5.1489	284546248.0
2007-09-04 16:00:00	AAPL	Stock	5.1493	5.1496	5.1486	5.1486	11829664.0
2007-09-04 09:00:00	MSFT	Stock	28.5	28.77	28.48	28.74	4215290.0
2007-09-04 10:00:00	MSFT	Stock	28.75	29.0	28.74	28.94	7036622.0
2007-09-04 11:00:00	MSFT	Stock	28.93	29.06	28.86	28.88	4452293.0
2007-09-04 12:00:00	MSFT	Stock	28.88	28.98	28.84	28.95	2354793.0
2007-09-04 13:00:00	MSFT	Stock	28.95	29.04	28.9	29.02	3373409.0
2007-09-04 14:00:00	MSFT	Stock	29.02	29.07	28.98	29.0	4305652.0
2007-09-04 15:00:00	MSFT	Stock	29.01	29.1	28.79	28.81	9986190.0
2007-09-04 16:00:00	MSFT	Stock	28.81	28.82	28.8	28.81	2037518.0
2007-09-04 07:00:00	NVDA	Stock	0.8432	0.8432	0.8432	0.8432	30000.0
2007-09-04 08:00:00	NVDA	Stock	0.8538	0.86	0.8523	0.8558	1440720.0
2007-09-04 09:00:00	NVDA	Stock	0.8567	0.8815	0.8432	0.8797	108750660.0
2007-09-04 10:00:00	NVDA	Stock	0.8802	0.8813	0.8743	0.8758	104206260.0
2007-09-04 11:00:00	NVDA	Stock	0.8758	0.877	0.871	0.872	73104720.0
2007-09-04 12:00:00	NVDA	Stock	0.872	0.8725	0.865	0.8685	57226500.0
2007-09-04 13:00:00	NVDA	Stock	0.8685	0.873	0.8633	0.8707	62096100.0
2007-09-04 14:00:00	NVDA	Stock	0.8707	0.879	0.8705	0.877	69011040.0
2007-09-04 15:00:00	NVDA	Stock	0.877	0.8827	0.8748	0.879	112423860.0
2007-09-04 16:00:00	NVDA	Stock	0.8783	0.879	0.8758	0.8767	4269240.0
2007-09-04 17:00:00	NVDA	Stock	0.8758	0.8768	0.8758	0.8768	102240.0
2007-09-04 18:00:00	NVDA	Stock	0.875	0.875	0.875	0.875	145740.0
2007-09-04 19:00:00	NVDA	Stock	0.8758	0.8767	0.8757	0.8767	75000.0
2007-09-04 07:00:00	AMZN	Stock	3.96	3.96	3.96	3.96	6000.0
2007-09-04 08:00:00	AMZN	Stock	3.9625	3.9955	3.96	3.987	155660.0
2007-09-04 09:00:00	AMZN	Stock	3.992	4.1	3.9865	4.075	26050880.0
2007-09-04 10:00:00	AMZN	Stock	4.075	4.106	4.061	4.075	21846400.0
2007-09-04 11:00:00	AMZN	Stock	4.075	4.1425	4.072	4.131	23110620.0
2007-09-04 12:00:00	AMZN	Stock	4.13	4.1375	4.1155	4.1195	11789420.0
2007-09-04 13:00:00	AMZN	Stock	4.1195	4.155	4.1195	4.151	14253580.0
2007-09-04 14:00:00	AMZN	Stock	4.1515	4.1765	4.149	4.1685	23887000.0
2007-09-04 15:00:00	AMZN	Stock	4.168	4.175	4.1255	4.1375	33672440.0
2007-09-04 16:00:00	AMZN	Stock	4.1405	4.15	4.135	4.141	4279640.0
2007-09-04 17:00:00	AMZN	Stock	4.1405	4.1405	4.135	4.135	57560.0
2007-09-04 18:00:00	AMZN	Stock	4.1475	4.1475	4.138	4.138	13600.0
2007-09-04 19:00:00	AMZN	Stock	4.146	4.146	4.1455	4.1455	33600.0
2007-09-04 09:00:00	TLT	Stock	88.83	88.83	88.61	88.72	123100.0
2007-09-04 10:00:00	TLT	Stock	88.72	88.72	88.21	88.28	267171.0
2007-09-04 11:00:00	TLT	Stock	88.29	88.37	88.24	88.37	92300.0
2007-09-04 12:00:00	TLT	Stock	88.36	88.49	88.31	88.49	49200.0
2007-09-04 13:00:00	TLT	Stock	88.5	88.54	88.42	88.5	34000.0
2007-09-04 14:00:00	TLT	Stock	88.51	88.54	88.38	88.45	77400.0
2007-09-04 15:00:00	TLT	Stock	88.45	88.56	88.45	88.52	233600.0
2007-09-04 16:00:00	TLT	Stock	88.52	88.56	88.52	88.56	200.0

> showing 50 of 37,808 rows — these rows as CSV

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