PREVIEW / stock_1hour / 2007-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-02.parquet
  size:    801 KB
  rows:    39,478
  symbols: 3,074

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-02 09:00:00	AAPL	Stock	4.8804	4.8914	4.8221	4.8607	161892444.0
2007-08-02 10:00:00	AAPL	Stock	4.8607	4.8607	4.7911	4.8175	189323344.0
2007-08-02 11:00:00	AAPL	Stock	4.8175	4.8639	4.7982	4.8621	95381972.0
2007-08-02 12:00:00	AAPL	Stock	4.8607	4.8621	4.8257	4.8289	66385144.0
2007-08-02 13:00:00	AAPL	Stock	4.8296	4.8464	4.8129	4.8304	73072104.0
2007-08-02 14:00:00	AAPL	Stock	4.8311	4.8554	4.8225	4.855	73905664.0
2007-08-02 15:00:00	AAPL	Stock	4.8543	4.875	4.8486	4.8732	143545444.0
2007-08-02 16:00:00	AAPL	Stock	4.8732	4.8746	4.8732	4.8746	13417964.0
2007-08-02 09:00:00	MSFT	Stock	29.19	29.37	29.02	29.28	4043283.0
2007-08-02 10:00:00	MSFT	Stock	29.28	29.6	29.19	29.51	8982555.0
2007-08-02 11:00:00	MSFT	Stock	29.51	29.75	29.47	29.75	6167825.0
2007-08-02 12:00:00	MSFT	Stock	29.75	29.79	29.52	29.6	5217880.0
2007-08-02 13:00:00	MSFT	Stock	29.61	29.66	29.41	29.532	4858180.0
2007-08-02 14:00:00	MSFT	Stock	29.53	29.62	29.42	29.45	4866757.0
2007-08-02 15:00:00	MSFT	Stock	29.46	29.7	29.45	29.52	10182299.0
2007-08-02 16:00:00	MSFT	Stock	29.5	29.52	29.5	29.52	2040454.0
2007-08-02 08:00:00	NVDA	Stock	0.7625	0.7632	0.7592	0.7602	169800.0
2007-08-02 09:00:00	NVDA	Stock	0.7623	0.7663	0.7525	0.7608	49700640.0
2007-08-02 10:00:00	NVDA	Stock	0.7608	0.761	0.748	0.7517	50158500.0
2007-08-02 11:00:00	NVDA	Stock	0.7518	0.7577	0.746	0.7575	53429520.0
2007-08-02 12:00:00	NVDA	Stock	0.7575	0.759	0.7547	0.755	64853820.0
2007-08-02 13:00:00	NVDA	Stock	0.755	0.7558	0.748	0.75	60815280.0
2007-08-02 14:00:00	NVDA	Stock	0.75	0.7556	0.7447	0.7452	57999900.0
2007-08-02 15:00:00	NVDA	Stock	0.7453	0.756	0.7435	0.7533	115163700.0
2007-08-02 16:00:00	NVDA	Stock	0.7527	0.7568	0.7503	0.7537	398160.0
2007-08-02 17:00:00	NVDA	Stock	0.7537	0.7537	0.7537	0.7537	66660.0
2007-08-02 18:00:00	NVDA	Stock	0.7563	0.7567	0.7508	0.7567	72000.0
2007-08-02 08:00:00	AMZN	Stock	3.88	3.8995	3.8655	3.8935	395720.0
2007-08-02 09:00:00	AMZN	Stock	3.8925	3.9175	3.806	3.857	28216740.0
2007-08-02 10:00:00	AMZN	Stock	3.856	3.8895	3.83	3.8625	26530740.0
2007-08-02 11:00:00	AMZN	Stock	3.8615	3.9465	3.844	3.9305	23686280.0
2007-08-02 12:00:00	AMZN	Stock	3.931	3.944	3.8985	3.919	17278180.0
2007-08-02 13:00:00	AMZN	Stock	3.919	3.9675	3.9125	3.9505	31191660.0
2007-08-02 14:00:00	AMZN	Stock	3.9495	3.979	3.9265	3.9425	28620360.0
2007-08-02 15:00:00	AMZN	Stock	3.943	3.988	3.937	3.983	41291080.0
2007-08-02 16:00:00	AMZN	Stock	3.983	3.99	3.974	3.985	6850140.0
2007-08-02 17:00:00	AMZN	Stock	3.985	3.985	3.9825	3.985	46000.0
2007-08-02 18:00:00	AMZN	Stock	3.98	3.986	3.8705	3.9315	74460.0
2007-08-02 19:00:00	AMZN	Stock	3.987	3.995	3.987	3.995	51400.0
2007-08-02 09:00:00	TLT	Stock	87.21	87.21	87.05	87.13	387097.0
2007-08-02 10:00:00	TLT	Stock	87.09	87.22	86.99	87.16	505000.0
2007-08-02 11:00:00	TLT	Stock	87.16	87.23	87.09	87.09	75477.0
2007-08-02 12:00:00	TLT	Stock	87.07	87.2	87.04	87.15	98500.0
2007-08-02 13:00:00	TLT	Stock	87.16	87.44	87.16	87.29	428185.0
2007-08-02 14:00:00	TLT	Stock	87.23	87.45	87.2	87.42	104800.0
2007-08-02 15:00:00	TLT	Stock	87.42	87.45	87.3	87.35	470700.0
2007-08-02 16:00:00	TLT	Stock	87.35	87.35	87.35	87.35	500.0
2007-08-02 09:00:00	CL	Stock	34.005	34.045	33.315	33.43	823200.0
2007-08-02 10:00:00	CL	Stock	33.44	33.825	33.415	33.715	1118200.0
2007-08-02 11:00:00	CL	Stock	33.715	33.76	33.595	33.61	862112.0

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

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