PREVIEW / stock_1hour / 2009-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-06.parquet
  size:    807 KB
  rows:    40,000
  symbols: 3,303

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
2009-04-06 07:00:00	AAPL	Stock	4.1768	4.1768	4.1454	4.1454	241920.0
2009-04-06 08:00:00	AAPL	Stock	4.1454	4.1482	4.1068	4.1107	1157436.0
2009-04-06 09:00:00	AAPL	Stock	4.1104	4.1193	4.0643	4.0754	81184880.0
2009-04-06 10:00:00	AAPL	Stock	4.0763	4.1029	4.0504	4.06	89310536.0
2009-04-06 11:00:00	AAPL	Stock	4.0596	4.0782	4.0457	4.0754	53511304.0
2009-04-06 12:00:00	AAPL	Stock	4.0754	4.1282	4.0739	4.1279	46713184.0
2009-04-06 13:00:00	AAPL	Stock	4.1286	4.1868	4.1132	4.1704	92169952.0
2009-04-06 14:00:00	AAPL	Stock	4.1707	4.2204	4.1675	4.2143	128452044.0
2009-04-06 15:00:00	AAPL	Stock	4.2157	4.2411	4.1911	4.23	141601516.0
2009-04-06 16:00:00	AAPL	Stock	4.23	4.2357	4.1429	4.23	16156728.0
2009-04-06 17:00:00	AAPL	Stock	4.2257	4.2286	4.225	4.2286	162596.0
2009-04-06 18:00:00	AAPL	Stock	4.2286	4.2325	4.225	4.225	1056524.0
2009-04-06 19:00:00	AAPL	Stock	4.2236	4.2304	4.2236	4.23	244496.0
2009-04-06 07:00:00	MSFT	Stock	18.88	18.88	18.46	18.69	9400.0
2009-04-06 08:00:00	MSFT	Stock	18.63	18.73	18.54	18.6	61101.0
2009-04-06 09:00:00	MSFT	Stock	18.57	18.69	18.265	18.38	6206523.0
2009-04-06 10:00:00	MSFT	Stock	18.38	18.51	18.33	18.46	7337373.0
2009-04-06 11:00:00	MSFT	Stock	18.46	18.54	18.35	18.39	5376316.0
2009-04-06 12:00:00	MSFT	Stock	18.388	18.48	18.35	18.4	4340279.0
2009-04-06 13:00:00	MSFT	Stock	18.4	18.56	18.37	18.48	5226214.0
2009-04-06 14:00:00	MSFT	Stock	18.48	18.59	18.44	18.56	5700350.0
2009-04-06 15:00:00	MSFT	Stock	18.557	18.75	18.46	18.74	10430746.0
2009-04-06 16:00:00	MSFT	Stock	18.75	18.76	18.365	18.73	2178118.0
2009-04-06 17:00:00	MSFT	Stock	18.72	18.78	18.72	18.78	13303.0
2009-04-06 18:00:00	MSFT	Stock	18.76	18.76	18.74	18.74	79157.0
2009-04-06 19:00:00	MSFT	Stock	18.74	18.76	18.7	18.76	9588.0
2009-04-06 08:00:00	NVDA	Stock	0.2825	0.2825	0.2725	0.2765	184000.0
2009-04-06 09:00:00	NVDA	Stock	0.2763	0.2794	0.2748	0.2769	128530480.0
2009-04-06 10:00:00	NVDA	Stock	0.277	0.2783	0.2745	0.2763	185207520.0
2009-04-06 11:00:00	NVDA	Stock	0.2763	0.278	0.275	0.2775	99031840.0
2009-04-06 12:00:00	NVDA	Stock	0.2772	0.278	0.2763	0.2775	95188200.0
2009-04-06 13:00:00	NVDA	Stock	0.2772	0.281	0.2772	0.2795	97067280.0
2009-04-06 14:00:00	NVDA	Stock	0.2795	0.283	0.278	0.2822	86822680.0
2009-04-06 15:00:00	NVDA	Stock	0.2822	0.2862	0.2812	0.2842	175684360.0
2009-04-06 16:00:00	NVDA	Stock	0.284	0.2858	0.2786	0.283	2956600.0
2009-04-06 17:00:00	NVDA	Stock	0.2812	0.2832	0.2812	0.2832	18600.0
2009-04-06 18:00:00	NVDA	Stock	0.2842	0.2862	0.2842	0.2842	228000.0
2009-04-06 19:00:00	NVDA	Stock	0.2852	0.286	0.285	0.286	60000.0
2009-04-06 07:00:00	AMZN	Stock	3.8965	3.8965	3.8965	3.8965	6000.0
2009-04-06 08:00:00	AMZN	Stock	3.89	3.89	3.87	3.8725	190300.0
2009-04-06 09:00:00	AMZN	Stock	3.8725	3.88	3.825	3.85	14497600.0
2009-04-06 10:00:00	AMZN	Stock	3.85	3.8725	3.8025	3.818	21183180.0
2009-04-06 11:00:00	AMZN	Stock	3.818	3.8345	3.8	3.8095	15740320.0
2009-04-06 12:00:00	AMZN	Stock	3.81	3.8485	3.81	3.8475	10373780.0
2009-04-06 13:00:00	AMZN	Stock	3.847	3.869	3.8235	3.8508	11707400.0
2009-04-06 14:00:00	AMZN	Stock	3.8506	3.883	3.84	3.875	14224740.0
2009-04-06 15:00:00	AMZN	Stock	3.8755	3.918	3.8565	3.896	23688400.0
2009-04-06 16:00:00	AMZN	Stock	3.8995	3.9145	3.845	3.91	2610680.0
2009-04-06 17:00:00	AMZN	Stock	3.9095	3.9095	3.9095	3.9095	2000.0
2009-04-06 18:00:00	AMZN	Stock	3.9095	3.911	3.885	3.885	127100.0

> showing 50 of 40,000 rows — these rows as CSV

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