PREVIEW / stock_1hour / 2010-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-30.parquet
  size:    920 KB
  rows:    44,754
  symbols: 3,483

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
2010-06-30 04:00:00	AAPL	Stock	9.2139	9.2139	9.2139	9.2139	2800.0
2010-06-30 05:00:00	AAPL	Stock	9.1782	9.2493	9.1782	9.2493	50540.0
2010-06-30 06:00:00	AAPL	Stock	9.2489	9.2493	9.2264	9.2264	46956.0
2010-06-30 07:00:00	AAPL	Stock	9.2264	9.2661	9.2093	9.2093	708204.0
2010-06-30 08:00:00	AAPL	Stock	9.2143	9.2286	9.1518	9.1589	5348588.0
2010-06-30 09:00:00	AAPL	Stock	9.1589	9.1921	9.0825	9.1264	144518220.0
2010-06-30 10:00:00	AAPL	Stock	9.1264	9.2132	9.1036	9.1093	137458832.0
2010-06-30 11:00:00	AAPL	Stock	9.1093	9.1964	9.1048	9.1714	72301012.0
2010-06-30 12:00:00	AAPL	Stock	9.1711	9.2025	9.1439	9.1629	44914044.0
2010-06-30 13:00:00	AAPL	Stock	9.1626	9.1786	9.13	9.1379	42270984.0
2010-06-30 14:00:00	AAPL	Stock	9.1379	9.1539	9.0996	9.1143	63232848.0
2010-06-30 15:00:00	AAPL	Stock	9.1143	9.1775	8.9289	8.9836	187289872.0
2010-06-30 16:00:00	AAPL	Stock	8.9818	9.1777	8.9614	8.9807	28995652.0
2010-06-30 17:00:00	AAPL	Stock	9.1342	9.1342	8.9696	8.9796	1602888.0
2010-06-30 18:00:00	AAPL	Stock	8.9764	8.9807	8.9714	8.975	383488.0
2010-06-30 19:00:00	AAPL	Stock	8.98	8.9911	8.9736	8.9893	642068.0
2010-06-30 20:00:00	AAPL	Stock	9.175	9.175	9.175	9.175	2800.0
2010-06-30 04:00:00	MSFT	Stock	23.5	23.5	23.5	23.5	450.0
2010-06-30 05:00:00	MSFT	Stock	23.58	23.58	23.57	23.57	865.0
2010-06-30 06:00:00	MSFT	Stock	23.58	23.61	23.55	23.6	1505.0
2010-06-30 07:00:00	MSFT	Stock	23.47	23.55	23.47	23.49	8852.0
2010-06-30 08:00:00	MSFT	Stock	23.46	23.53	23.4	23.43	108301.0
2010-06-30 09:00:00	MSFT	Stock	23.41	23.49	23.22	23.351	8847329.0
2010-06-30 10:00:00	MSFT	Stock	23.36	23.5	23.34	23.44	11732351.0
2010-06-30 11:00:00	MSFT	Stock	23.46	23.65	23.44	23.6	8058702.0
2010-06-30 12:00:00	MSFT	Stock	23.61	23.68	23.49	23.54	4969905.0
2010-06-30 13:00:00	MSFT	Stock	23.55	23.63	23.44	23.515	6530521.0
2010-06-30 14:00:00	MSFT	Stock	23.51	23.55	23.28	23.36	10323259.0
2010-06-30 15:00:00	MSFT	Stock	23.35	23.36	22.95	23.0	23423438.0
2010-06-30 16:00:00	MSFT	Stock	23.0	23.6	22.95	22.97	5101036.0
2010-06-30 17:00:00	MSFT	Stock	23.32	23.5	22.98	23.0	52245.0
2010-06-30 18:00:00	MSFT	Stock	23.0	23.07	22.98	23.05	33026.0
2010-06-30 19:00:00	MSFT	Stock	23.09	23.09	23.01	23.01	26082.0
2010-06-30 20:00:00	MSFT	Stock	23.62	23.62	23.62	23.62	1400.0
2010-06-30 08:00:00	NVDA	Stock	0.2665	0.2665	0.2638	0.265	273120.0
2010-06-30 09:00:00	NVDA	Stock	0.2643	0.2652	0.259	0.264	56442080.0
2010-06-30 10:00:00	NVDA	Stock	0.264	0.265	0.2605	0.2608	109674720.0
2010-06-30 11:00:00	NVDA	Stock	0.261	0.2632	0.2605	0.2612	95427400.0
2010-06-30 12:00:00	NVDA	Stock	0.2612	0.2618	0.26	0.261	52664200.0
2010-06-30 13:00:00	NVDA	Stock	0.261	0.2625	0.2603	0.2615	42038720.0
2010-06-30 14:00:00	NVDA	Stock	0.2615	0.2623	0.2592	0.261	70250560.0
2010-06-30 15:00:00	NVDA	Stock	0.2608	0.261	0.2553	0.2553	159759840.0
2010-06-30 16:00:00	NVDA	Stock	0.2553	0.2608	0.2538	0.255	11134280.0
2010-06-30 17:00:00	NVDA	Stock	0.262	0.262	0.254	0.255	220240.0
2010-06-30 18:00:00	NVDA	Stock	0.2558	0.2558	0.2553	0.2553	100000.0
2010-06-30 19:00:00	NVDA	Stock	0.2543	0.2553	0.254	0.2553	78000.0
2010-06-30 08:00:00	AMZN	Stock	5.475	5.475	5.438	5.438	161700.0
2010-06-30 09:00:00	AMZN	Stock	5.434	5.6235	5.4055	5.5825	41307380.0
2010-06-30 10:00:00	AMZN	Stock	5.5835	5.6	5.5445	5.555	33697320.0
2010-06-30 11:00:00	AMZN	Stock	5.5595	5.617	5.542	5.6028	20326460.0

> showing 50 of 44,754 rows — these rows as CSV

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