PREVIEW / stock_1hour / 2007-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-16.parquet
  size:    809 KB
  rows:    39,561
  symbols: 3,145

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-16 09:00:00	AAPL	Stock	4.1789	4.2321	4.1375	4.1407	210793744.0
2007-08-16 10:00:00	AAPL	Stock	4.1406	4.1446	3.9864	4.0757	397648328.0
2007-08-16 11:00:00	AAPL	Stock	4.075	4.1336	4.0411	4.0664	224178416.0
2007-08-16 12:00:00	AAPL	Stock	4.065	4.0664	4.0	4.0068	204699600.0
2007-08-16 13:00:00	AAPL	Stock	4.0071	4.1393	3.9871	4.1232	221167632.0
2007-08-16 14:00:00	AAPL	Stock	4.1243	4.175	4.0804	4.1189	198674196.0
2007-08-16 15:00:00	AAPL	Stock	4.1196	4.2093	4.0214	4.1893	257480636.0
2007-08-16 16:00:00	AAPL	Stock	4.1886	4.1907	4.1804	4.1804	22691704.0
2007-08-16 09:00:00	MSFT	Stock	27.88	28.15	27.8	27.91	6093833.0
2007-08-16 10:00:00	MSFT	Stock	27.9	28.35	27.89	28.17	8257016.0
2007-08-16 11:00:00	MSFT	Stock	28.16	28.34	27.85	28.0	7159361.0
2007-08-16 12:00:00	MSFT	Stock	28.0	28.01	27.51	27.6	10129051.0
2007-08-16 13:00:00	MSFT	Stock	27.6	28.0	27.52	27.84	8077812.0
2007-08-16 14:00:00	MSFT	Stock	27.84	28.04	27.68	27.76	9027251.0
2007-08-16 15:00:00	MSFT	Stock	27.76	27.97	27.51	27.84	16779527.0
2007-08-16 16:00:00	MSFT	Stock	27.84	27.86	27.81	27.81	3373194.0
2007-08-16 07:00:00	NVDA	Stock	0.7133	0.7133	0.7133	0.7133	6000.0
2007-08-16 08:00:00	NVDA	Stock	0.7103	0.7167	0.7017	0.7115	973740.0
2007-08-16 09:00:00	NVDA	Stock	0.7122	0.7208	0.7075	0.7143	82001340.0
2007-08-16 10:00:00	NVDA	Stock	0.7143	0.7157	0.6977	0.7042	124897980.0
2007-08-16 11:00:00	NVDA	Stock	0.704	0.7117	0.6983	0.6992	92935560.0
2007-08-16 12:00:00	NVDA	Stock	0.6995	0.6995	0.675	0.6783	112166940.0
2007-08-16 13:00:00	NVDA	Stock	0.6782	0.7027	0.675	0.6985	110043840.0
2007-08-16 14:00:00	NVDA	Stock	0.6988	0.7125	0.6935	0.7021	90941520.0
2007-08-16 15:00:00	NVDA	Stock	0.702	0.7155	0.6847	0.71	124697040.0
2007-08-16 16:00:00	NVDA	Stock	0.71	0.7167	0.7095	0.7102	19946820.0
2007-08-16 17:00:00	NVDA	Stock	0.7115	0.715	0.7115	0.715	149700.0
2007-08-16 18:00:00	NVDA	Stock	0.7128	0.7128	0.7093	0.7093	78000.0
2007-08-16 19:00:00	NVDA	Stock	0.7095	0.715	0.7095	0.7128	45600.0
2007-08-16 05:00:00	AMZN	Stock	3.6085	3.6085	3.5855	3.5855	6000.0
2007-08-16 07:00:00	AMZN	Stock	3.588	3.6	3.575	3.599	46000.0
2007-08-16 08:00:00	AMZN	Stock	3.5985	3.619	3.581	3.6025	653020.0
2007-08-16 09:00:00	AMZN	Stock	3.608	3.619	3.5725	3.575	21777320.0
2007-08-16 10:00:00	AMZN	Stock	3.575	3.59	3.5335	3.5568	30346060.0
2007-08-16 11:00:00	AMZN	Stock	3.5568	3.598	3.553	3.5595	23271260.0
2007-08-16 12:00:00	AMZN	Stock	3.5625	3.5655	3.513	3.5175	29789340.0
2007-08-16 13:00:00	AMZN	Stock	3.517	3.57	3.5025	3.553	37532900.0
2007-08-16 14:00:00	AMZN	Stock	3.552	3.61	3.537	3.603	25623540.0
2007-08-16 15:00:00	AMZN	Stock	3.603	3.662	3.5425	3.6285	35055700.0
2007-08-16 16:00:00	AMZN	Stock	3.6395	3.662	3.5669	3.6425	878440.0
2007-08-16 17:00:00	AMZN	Stock	3.6425	3.65	3.64	3.64	204100.0
2007-08-16 18:00:00	AMZN	Stock	3.6495	3.6535	3.63	3.63	48900.0
2007-08-16 09:00:00	TLT	Stock	86.87	87.06	86.76	87.06	210100.0
2007-08-16 10:00:00	TLT	Stock	87.08	87.14	86.92	87.05	271200.0
2007-08-16 11:00:00	TLT	Stock	87.06	87.13	86.94	86.99	371700.0
2007-08-16 12:00:00	TLT	Stock	87.0	87.57	87.0	87.49	457200.0
2007-08-16 13:00:00	TLT	Stock	87.52	87.6	87.16	87.21	583400.0
2007-08-16 14:00:00	TLT	Stock	87.21	87.49	87.08	87.48	193600.0
2007-08-16 15:00:00	TLT	Stock	87.49	87.6	87.03	87.1	191900.0
2007-08-16 16:00:00	TLT	Stock	87.1	87.14	87.08	87.14	8400.0

> showing 50 of 39,561 rows — these rows as CSV

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