PREVIEW / stock_1hour / 2007-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-16.parquet
  size:    753 KB
  rows:    36,921
  symbols: 3,015

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-05-16 09:00:00	AAPL	Stock	3.8761	3.9518	3.8479	3.8539	140375340.0
2007-05-16 10:00:00	AAPL	Stock	3.8539	3.8661	3.8307	3.8393	143534104.0
2007-05-16 11:00:00	AAPL	Stock	3.8389	3.8554	3.7946	3.8125	165670232.0
2007-05-16 12:00:00	AAPL	Stock	3.8125	3.8425	3.6936	3.8296	422877280.0
2007-05-16 13:00:00	AAPL	Stock	3.8293	3.8304	3.8068	3.8139	53944884.0
2007-05-16 14:00:00	AAPL	Stock	3.8136	3.8286	3.8071	3.8182	62135920.0
2007-05-16 15:00:00	AAPL	Stock	3.8186	3.8361	3.815	3.8325	92357300.0
2007-05-16 16:00:00	AAPL	Stock	3.8332	3.8336	3.8332	3.8336	9329628.0
2007-05-16 09:00:00	MSFT	Stock	31.0	31.06	30.93	30.98	3752532.0
2007-05-16 10:00:00	MSFT	Stock	30.98	31.03	30.94	30.97	6346318.0
2007-05-16 11:00:00	MSFT	Stock	30.97	31.05	30.81	31.03	8650628.0
2007-05-16 12:00:00	MSFT	Stock	31.03	31.07	30.95	31.05	3513864.0
2007-05-16 13:00:00	MSFT	Stock	31.04	31.05	30.94	30.97	4645405.0
2007-05-16 14:00:00	MSFT	Stock	30.96	31.04	30.94	30.96	3516510.0
2007-05-16 15:00:00	MSFT	Stock	30.96	31.09	30.95	31.08	7353116.0
2007-05-16 16:00:00	MSFT	Stock	31.07	31.07	31.07	31.07	1595524.0
2007-05-16 08:00:00	NVDA	Stock	0.5817	0.5817	0.5783	0.5817	94500.0
2007-05-16 09:00:00	NVDA	Stock	0.5793	0.5793	0.5733	0.575	44024460.0
2007-05-16 10:00:00	NVDA	Stock	0.575	0.5758	0.5658	0.5672	106415100.0
2007-05-16 11:00:00	NVDA	Stock	0.5673	0.5722	0.5642	0.5715	73821180.0
2007-05-16 12:00:00	NVDA	Stock	0.5717	0.573	0.5687	0.573	49720560.0
2007-05-16 13:00:00	NVDA	Stock	0.573	0.5757	0.5707	0.5748	45334980.0
2007-05-16 14:00:00	NVDA	Stock	0.5748	0.581	0.5748	0.5802	68656680.0
2007-05-16 15:00:00	NVDA	Stock	0.5802	0.582	0.5782	0.582	97994520.0
2007-05-16 16:00:00	NVDA	Stock	0.582	0.582	0.5773	0.5773	9123180.0
2007-05-16 05:00:00	AMZN	Stock	3.035	3.035	3.0325	3.0325	4000.0
2007-05-16 07:00:00	AMZN	Stock	3.03	3.03	3.0255	3.0255	11800.0
2007-05-16 08:00:00	AMZN	Stock	3.0335	3.0385	3.03	3.0385	60500.0
2007-05-16 09:00:00	AMZN	Stock	3.0375	3.0605	3.0305	3.049	26121580.0
2007-05-16 10:00:00	AMZN	Stock	3.049	3.0556	3.0185	3.0195	25864220.0
2007-05-16 11:00:00	AMZN	Stock	3.02	3.0375	3.005	3.0325	29247820.0
2007-05-16 12:00:00	AMZN	Stock	3.0325	3.0465	3.0245	3.0445	15033660.0
2007-05-16 13:00:00	AMZN	Stock	3.0445	3.0695	3.0375	3.0665	26017240.0
2007-05-16 14:00:00	AMZN	Stock	3.067	3.087	3.0655	3.0845	29402900.0
2007-05-16 15:00:00	AMZN	Stock	3.084	3.167	3.073	3.163	116105500.0
2007-05-16 16:00:00	AMZN	Stock	3.161	3.172	3.1585	3.16	17729380.0
2007-05-16 17:00:00	AMZN	Stock	3.161	3.1675	3.1505	3.1615	357580.0
2007-05-16 18:00:00	AMZN	Stock	3.17	3.175	3.1665	3.1695	224600.0
2007-05-16 19:00:00	AMZN	Stock	3.1695	3.17	3.1645	3.1675	128600.0
2007-05-16 09:00:00	TLT	Stock	87.86	87.92	87.83	87.92	77800.0
2007-05-16 10:00:00	TLT	Stock	87.92	88.0	87.89	87.99	117440.0
2007-05-16 11:00:00	TLT	Stock	87.97	87.98	87.85	87.89	83000.0
2007-05-16 12:00:00	TLT	Stock	87.87	87.96	87.87	87.92	41400.0
2007-05-16 13:00:00	TLT	Stock	87.91	87.92	87.85	87.85	13000.0
2007-05-16 14:00:00	TLT	Stock	87.86	87.92	87.84	87.91	196700.0
2007-05-16 15:00:00	TLT	Stock	87.91	87.95	87.88	87.88	64500.0
2007-05-16 16:00:00	TLT	Stock	87.92	87.92	87.87	87.87	3200.0
2007-05-16 08:00:00	CL	Stock	33.17	33.17	33.17	33.17	50200.0
2007-05-16 09:00:00	CL	Stock	33.225	33.31	33.165	33.26	454600.0
2007-05-16 10:00:00	CL	Stock	33.255	33.44	33.255	33.38	585450.0

> showing 50 of 36,921 rows — these rows as CSV

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