PREVIEW / stock_1hour / 2007-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-24.parquet
  size:    745 KB
  rows:    37,075
  symbols: 3,101

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-24 09:00:00	AAPL	Stock	4.6618	4.6989	4.6361	4.6893	84338352.0
2007-08-24 10:00:00	AAPL	Stock	4.6893	4.7707	4.6893	4.7629	200867380.0
2007-08-24 11:00:00	AAPL	Stock	4.7625	4.8054	4.7557	4.7932	169331512.0
2007-08-24 12:00:00	AAPL	Stock	4.7936	4.8143	4.7732	4.8071	103763968.0
2007-08-24 13:00:00	AAPL	Stock	4.8071	4.8125	4.785	4.7882	71681792.0
2007-08-24 14:00:00	AAPL	Stock	4.7879	4.8179	4.7786	4.8171	103182380.0
2007-08-24 15:00:00	AAPL	Stock	4.8175	4.8346	4.7857	4.8319	145800172.0
2007-08-24 16:00:00	AAPL	Stock	4.8318	4.8321	4.8311	4.8321	12697496.0
2007-08-24 09:00:00	MSFT	Stock	28.21	28.26	28.07	28.095	3420456.0
2007-08-24 10:00:00	MSFT	Stock	28.092	28.23	28.09	28.23	6332835.0
2007-08-24 11:00:00	MSFT	Stock	28.23	28.42	28.2	28.42	5277454.0
2007-08-24 12:00:00	MSFT	Stock	28.41	28.65	28.39	28.59	6798560.0
2007-08-24 13:00:00	MSFT	Stock	28.582	28.68	28.56	28.6	4263592.0
2007-08-24 14:00:00	MSFT	Stock	28.61	28.73	28.59	28.72	4510070.0
2007-08-24 15:00:00	MSFT	Stock	28.715	28.84	28.66	28.8	9919588.0
2007-08-24 16:00:00	MSFT	Stock	28.81	28.81	28.81	28.81	2155221.0
2007-08-24 08:00:00	NVDA	Stock	0.7978	0.798	0.7978	0.798	96000.0
2007-08-24 09:00:00	NVDA	Stock	0.796	0.804	0.7918	0.798	33077160.0
2007-08-24 10:00:00	NVDA	Stock	0.7983	0.8055	0.7983	0.8033	52454820.0
2007-08-24 11:00:00	NVDA	Stock	0.8033	0.8057	0.7979	0.8013	40504260.0
2007-08-24 12:00:00	NVDA	Stock	0.8015	0.802	0.7973	0.7992	44232600.0
2007-08-24 13:00:00	NVDA	Stock	0.7993	0.8013	0.7983	0.7997	49368480.0
2007-08-24 14:00:00	NVDA	Stock	0.7995	0.8055	0.7993	0.8048	54106380.0
2007-08-24 15:00:00	NVDA	Stock	0.8047	0.8055	0.8013	0.8038	58139220.0
2007-08-24 16:00:00	NVDA	Stock	0.8042	0.8052	0.8025	0.8025	13686960.0
2007-08-24 19:00:00	NVDA	Stock	0.805	0.8053	0.805	0.8053	18000.0
2007-08-24 06:00:00	AMZN	Stock	3.865	3.875	3.865	3.865	8000.0
2007-08-24 08:00:00	AMZN	Stock	3.86	3.8945	3.8455	3.8505	191120.0
2007-08-24 09:00:00	AMZN	Stock	3.85	3.92	3.8345	3.8975	16684380.0
2007-08-24 10:00:00	AMZN	Stock	3.8985	3.94	3.896	3.913	21430480.0
2007-08-24 11:00:00	AMZN	Stock	3.9129	3.93	3.906	3.9245	10341020.0
2007-08-24 12:00:00	AMZN	Stock	3.9245	3.93	3.903	3.91	13549920.0
2007-08-24 13:00:00	AMZN	Stock	3.91	3.9205	3.902	3.9205	7866460.0
2007-08-24 14:00:00	AMZN	Stock	3.9205	3.9465	3.9165	3.936	14598580.0
2007-08-24 15:00:00	AMZN	Stock	3.9358	3.97	3.9245	3.964	24541900.0
2007-08-24 16:00:00	AMZN	Stock	3.9625	3.966	3.961	3.966	3029280.0
2007-08-24 17:00:00	AMZN	Stock	3.9625	3.965	3.961	3.965	53700.0
2007-08-24 18:00:00	AMZN	Stock	3.965	3.9665	3.965	3.965	10000.0
2007-08-24 19:00:00	AMZN	Stock	3.965	3.965	3.961	3.961	12000.0
2007-08-24 09:00:00	TLT	Stock	87.77	87.82	87.7	87.79	394000.0
2007-08-24 10:00:00	TLT	Stock	87.76	87.95	87.56	87.92	280400.0
2007-08-24 11:00:00	TLT	Stock	87.92	88.0	87.85	87.99	282768.0
2007-08-24 12:00:00	TLT	Stock	87.97	88.0	87.86	87.88	106000.0
2007-08-24 13:00:00	TLT	Stock	87.9	88.08	87.86	88.03	175800.0
2007-08-24 14:00:00	TLT	Stock	88.02	88.05	87.89	87.94	142946.0
2007-08-24 15:00:00	TLT	Stock	87.91	87.99	87.9	87.92	197400.0
2007-08-24 16:00:00	TLT	Stock	87.85	87.85	87.85	87.85	10400.0
2007-08-24 09:00:00	CL	Stock	33.455	33.47	33.255	33.325	290400.0
2007-08-24 10:00:00	CL	Stock	33.335	33.51	33.255	33.265	367600.0
2007-08-24 11:00:00	CL	Stock	33.26	33.365	33.255	33.31	260400.0

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

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