PREVIEW / stock_1hour / 2007-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-12.parquet
  size:    768 KB
  rows:    37,623
  symbols: 3,066

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-07-12 09:00:00	AAPL	Stock	4.7804	4.7943	4.75	4.7589	165722900.0
2007-07-12 10:00:00	AAPL	Stock	4.7586	4.7779	4.7429	4.7579	116312784.0
2007-07-12 11:00:00	AAPL	Stock	4.7575	4.7675	4.7282	4.7523	64549632.0
2007-07-12 12:00:00	AAPL	Stock	4.7521	4.7711	4.7464	4.7521	74506796.0
2007-07-12 13:00:00	AAPL	Stock	4.7525	4.7668	4.7514	4.7625	45053120.0
2007-07-12 14:00:00	AAPL	Stock	4.7618	4.7675	4.7557	4.7596	50374184.0
2007-07-12 15:00:00	AAPL	Stock	4.7593	4.7896	4.7579	4.7893	149887584.0
2007-07-12 16:00:00	AAPL	Stock	4.7893	4.7893	4.7861	4.7882	11067504.0
2007-07-12 09:00:00	MSFT	Stock	29.56	29.67	29.44	29.64	3435987.0
2007-07-12 10:00:00	MSFT	Stock	29.64	29.67	29.55	29.61	5195950.0
2007-07-12 11:00:00	MSFT	Stock	29.61	29.66	29.49	29.6	3829927.0
2007-07-12 12:00:00	MSFT	Stock	29.61	29.7	29.59	29.63	5455144.0
2007-07-12 13:00:00	MSFT	Stock	29.63	29.69	29.58	29.62	4590562.0
2007-07-12 14:00:00	MSFT	Stock	29.63	29.8	29.62	29.8	7305162.0
2007-07-12 15:00:00	MSFT	Stock	29.79	30.1	29.78	30.1	19403024.0
2007-07-12 16:00:00	MSFT	Stock	30.1	30.11	30.07	30.07	2053616.0
2007-07-12 08:00:00	NVDA	Stock	0.7583	0.7608	0.7583	0.7583	24840.0
2007-07-12 09:00:00	NVDA	Stock	0.7567	0.7633	0.7567	0.7612	35511840.0
2007-07-12 10:00:00	NVDA	Stock	0.761	0.7615	0.7558	0.7595	57636180.0
2007-07-12 11:00:00	NVDA	Stock	0.7597	0.7642	0.7547	0.7638	54804900.0
2007-07-12 12:00:00	NVDA	Stock	0.764	0.769	0.7637	0.7668	52476840.0
2007-07-12 13:00:00	NVDA	Stock	0.7668	0.7697	0.7653	0.7673	31264920.0
2007-07-12 14:00:00	NVDA	Stock	0.7673	0.7688	0.7667	0.7688	48103680.0
2007-07-12 15:00:00	NVDA	Stock	0.7688	0.77	0.768	0.7698	128209080.0
2007-07-12 16:00:00	NVDA	Stock	0.7698	0.7698	0.7585	0.7667	18668640.0
2007-07-12 17:00:00	NVDA	Stock	0.7663	0.7663	0.7657	0.7657	18000.0
2007-07-12 19:00:00	NVDA	Stock	0.7647	0.7647	0.7645	0.7645	37200.0
2007-07-12 08:00:00	AMZN	Stock	3.554	3.555	3.5525	3.5525	30340.0
2007-07-12 09:00:00	AMZN	Stock	3.555	3.6785	3.555	3.6715	58059780.0
2007-07-12 10:00:00	AMZN	Stock	3.671	3.6715	3.611	3.6345	42351040.0
2007-07-12 11:00:00	AMZN	Stock	3.634	3.64	3.5365	3.623	24330020.0
2007-07-12 12:00:00	AMZN	Stock	3.6235	3.6305	3.616	3.6235	16095320.0
2007-07-12 13:00:00	AMZN	Stock	3.6235	3.638	3.618	3.626	19927700.0
2007-07-12 14:00:00	AMZN	Stock	3.625	3.6255	3.6005	3.608	20384980.0
2007-07-12 15:00:00	AMZN	Stock	3.6085	3.6395	3.6085	3.638	37552060.0
2007-07-12 16:00:00	AMZN	Stock	3.6395	3.644	3.634	3.6375	5023400.0
2007-07-12 17:00:00	AMZN	Stock	3.637	3.639	3.637	3.637	26400.0
2007-07-12 18:00:00	AMZN	Stock	3.6425	3.6425	3.6375	3.6425	24000.0
2007-07-12 19:00:00	AMZN	Stock	3.645	3.645	3.645	3.645	2000.0
2007-07-12 09:00:00	TLT	Stock	84.55	84.58	84.33	84.37	40000.0
2007-07-12 10:00:00	TLT	Stock	84.38	84.41	84.15	84.2	238400.0
2007-07-12 11:00:00	TLT	Stock	84.19	84.22	84.04	84.05	239300.0
2007-07-12 12:00:00	TLT	Stock	84.07	84.09	83.9	83.95	841200.0
2007-07-12 13:00:00	TLT	Stock	83.94	84.05	83.87	84.02	141700.0
2007-07-12 14:00:00	TLT	Stock	84.02	84.18	84.01	84.17	29500.0
2007-07-12 15:00:00	TLT	Stock	84.16	84.16	83.98	84.03	395409.0
2007-07-12 16:00:00	TLT	Stock	84.06	84.06	84.03	84.03	7400.0
2007-07-12 08:00:00	CL	Stock	33.445	33.445	33.445	33.445	210000.0
2007-07-12 09:00:00	CL	Stock	33.5	33.75	33.5	33.535	444600.0
2007-07-12 10:00:00	CL	Stock	33.54	33.75	33.54	33.745	692200.0

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

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