PREVIEW / stock_1hour / 2007-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-01.parquet
  size:    802 KB
  rows:    39,334
  symbols: 3,100

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-01 09:00:00	AAPL	Stock	4.7729	4.7732	4.5632	4.6161	318072328.0
2007-08-01 10:00:00	AAPL	Stock	4.6168	4.7179	4.5979	4.6396	299439028.0
2007-08-01 11:00:00	AAPL	Stock	4.6396	4.7854	4.6214	4.7839	240303308.0
2007-08-01 12:00:00	AAPL	Stock	4.7846	4.835	4.7557	4.7596	223246072.0
2007-08-01 13:00:00	AAPL	Stock	4.7593	4.7643	4.7143	4.75	161970452.0
2007-08-01 14:00:00	AAPL	Stock	4.7493	4.815	4.7404	4.7668	179853324.0
2007-08-01 15:00:00	AAPL	Stock	4.7664	4.83	4.7154	4.8243	192590636.0
2007-08-01 16:00:00	AAPL	Stock	4.8304	4.8304	4.8214	4.8214	9841748.0
2007-08-01 09:00:00	MSFT	Stock	28.95	29.5	28.95	29.31	7501141.0
2007-08-01 10:00:00	MSFT	Stock	29.31	29.55	28.98	29.11	12830187.0
2007-08-01 11:00:00	MSFT	Stock	29.11	29.21	29.05	29.163	10760798.0
2007-08-01 12:00:00	MSFT	Stock	29.17	29.25	29.12	29.18	6771602.0
2007-08-01 13:00:00	MSFT	Stock	29.17	29.18	29.01	29.13	6902296.0
2007-08-01 14:00:00	MSFT	Stock	29.13	29.18	28.87	28.94	8436412.0
2007-08-01 15:00:00	MSFT	Stock	28.94	29.34	28.82	29.34	16678223.0
2007-08-01 16:00:00	MSFT	Stock	29.31	29.34	29.3	29.3	1752292.0
2007-08-01 08:00:00	NVDA	Stock	0.762	0.7642	0.7522	0.7565	381960.0
2007-08-01 09:00:00	NVDA	Stock	0.7565	0.7702	0.7495	0.7532	63537600.0
2007-08-01 10:00:00	NVDA	Stock	0.7533	0.7583	0.7253	0.7277	155545740.0
2007-08-01 11:00:00	NVDA	Stock	0.7273	0.745	0.7217	0.7448	117971340.0
2007-08-01 12:00:00	NVDA	Stock	0.745	0.7532	0.7407	0.7425	70958100.0
2007-08-01 13:00:00	NVDA	Stock	0.7425	0.7472	0.733	0.746	66150780.0
2007-08-01 14:00:00	NVDA	Stock	0.7463	0.7502	0.7363	0.7398	75704340.0
2007-08-01 15:00:00	NVDA	Stock	0.7393	0.7597	0.7317	0.7595	114110220.0
2007-08-01 16:00:00	NVDA	Stock	0.7595	0.76	0.7535	0.7535	14024640.0
2007-08-01 17:00:00	NVDA	Stock	0.7535	0.7535	0.7535	0.7535	18000.0
2007-08-01 19:00:00	NVDA	Stock	0.7582	0.7582	0.7582	0.7582	12000.0
2007-08-01 04:00:00	AMZN	Stock	3.9025	3.9025	3.9	3.9	4000.0
2007-08-01 06:00:00	AMZN	Stock	3.87	3.87	3.8625	3.8625	19000.0
2007-08-01 07:00:00	AMZN	Stock	3.895	3.895	3.8755	3.8755	38400.0
2007-08-01 08:00:00	AMZN	Stock	3.8755	3.92	3.875	3.92	465360.0
2007-08-01 09:00:00	AMZN	Stock	3.92	3.927	3.818	3.875	51680820.0
2007-08-01 10:00:00	AMZN	Stock	3.875	3.8895	3.8025	3.8065	61327480.0
2007-08-01 11:00:00	AMZN	Stock	3.805	3.845	3.77	3.8445	49754600.0
2007-08-01 12:00:00	AMZN	Stock	3.8445	3.88	3.8255	3.8586	43019400.0
2007-08-01 13:00:00	AMZN	Stock	3.8605	3.866	3.811	3.8475	22167540.0
2007-08-01 14:00:00	AMZN	Stock	3.8465	3.8675	3.775	3.7875	26830880.0
2007-08-01 15:00:00	AMZN	Stock	3.7865	3.898	3.753	3.8685	70146740.0
2007-08-01 16:00:00	AMZN	Stock	3.8685	3.8755	3.8625	3.8675	5395260.0
2007-08-01 17:00:00	AMZN	Stock	3.874	3.881	3.874	3.8745	324740.0
2007-08-01 18:00:00	AMZN	Stock	3.8655	3.885	3.8655	3.885	36000.0
2007-08-01 19:00:00	AMZN	Stock	3.8845	3.8845	3.8645	3.87	34920.0
2007-08-01 09:00:00	TLT	Stock	87.26	87.36	87.09	87.3	200460.0
2007-08-01 10:00:00	TLT	Stock	87.33	87.47	87.19	87.47	698900.0
2007-08-01 11:00:00	TLT	Stock	87.47	87.54	87.18	87.19	414400.0
2007-08-01 12:00:00	TLT	Stock	87.19	87.27	87.1	87.18	134600.0
2007-08-01 13:00:00	TLT	Stock	87.19	87.33	87.19	87.28	156816.0
2007-08-01 14:00:00	TLT	Stock	87.28	87.38	87.16	87.36	110180.0
2007-08-01 15:00:00	TLT	Stock	87.33	87.46	87.14	87.15	170395.0
2007-08-01 16:00:00	TLT	Stock	87.17	87.21	87.13	87.13	23400.0

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

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