PREVIEW / stock_1hour / 2007-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-20.parquet
  size:    761 KB
  rows:    38,112
  symbols: 3,123

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-20 09:00:00	AAPL	Stock	4.4271	4.4464	4.3836	4.3978	127403612.0
2007-08-20 10:00:00	AAPL	Stock	4.3979	4.4161	4.3439	4.3593	123493888.0
2007-08-20 11:00:00	AAPL	Stock	4.3593	4.3889	4.3311	4.3386	104250832.0
2007-08-20 12:00:00	AAPL	Stock	4.3382	4.3507	4.3214	4.3268	80755892.0
2007-08-20 13:00:00	AAPL	Stock	4.3264	4.3422	4.3036	4.3196	82298300.0
2007-08-20 14:00:00	AAPL	Stock	4.3196	4.3779	4.3089	4.3779	92697108.0
2007-08-20 15:00:00	AAPL	Stock	4.3779	4.3893	4.3518	4.3643	121892708.0
2007-08-20 16:00:00	AAPL	Stock	4.365	4.365	4.3643	4.365	16000208.0
2007-08-20 09:00:00	MSFT	Stock	28.18	28.39	28.13	28.35	4995762.0
2007-08-20 10:00:00	MSFT	Stock	28.35	28.49	28.3	28.37	8480493.0
2007-08-20 11:00:00	MSFT	Stock	28.38	28.42	28.3	28.33	5448905.0
2007-08-20 12:00:00	MSFT	Stock	28.33	28.39	28.2	28.22	4533033.0
2007-08-20 13:00:00	MSFT	Stock	28.23	28.27	28.08	28.14	3836228.0
2007-08-20 14:00:00	MSFT	Stock	28.15	28.23	28.08	28.23	3844582.0
2007-08-20 15:00:00	MSFT	Stock	28.23	28.46	28.17	28.26	8372584.0
2007-08-20 16:00:00	MSFT	Stock	28.26	28.26	28.26	28.26	1916069.0
2007-08-20 08:00:00	NVDA	Stock	0.752	0.7575	0.7502	0.7523	775500.0
2007-08-20 09:00:00	NVDA	Stock	0.7525	0.7567	0.7392	0.7478	68040300.0
2007-08-20 10:00:00	NVDA	Stock	0.7478	0.76	0.7475	0.7507	79285680.0
2007-08-20 11:00:00	NVDA	Stock	0.7507	0.7555	0.7453	0.7528	54769620.0
2007-08-20 12:00:00	NVDA	Stock	0.7528	0.7537	0.7482	0.75	38334000.0
2007-08-20 13:00:00	NVDA	Stock	0.75	0.7535	0.7465	0.747	60077880.0
2007-08-20 14:00:00	NVDA	Stock	0.7473	0.7487	0.7397	0.7447	68384460.0
2007-08-20 15:00:00	NVDA	Stock	0.7447	0.7542	0.7442	0.7485	120029040.0
2007-08-20 16:00:00	NVDA	Stock	0.7485	0.7485	0.7475	0.7475	4704000.0
2007-08-20 19:00:00	NVDA	Stock	0.7482	0.7482	0.7482	0.7482	6000.0
2007-08-20 06:00:00	AMZN	Stock	3.775	3.775	3.775	3.775	2000.0
2007-08-20 07:00:00	AMZN	Stock	3.7755	3.7825	3.7525	3.755	80000.0
2007-08-20 08:00:00	AMZN	Stock	3.7555	3.7725	3.75	3.753	583780.0
2007-08-20 09:00:00	AMZN	Stock	3.755	3.7625	3.702	3.72	19638500.0
2007-08-20 10:00:00	AMZN	Stock	3.7205	3.743	3.706	3.736	18562500.0
2007-08-20 11:00:00	AMZN	Stock	3.735	3.764	3.7185	3.7225	17346800.0
2007-08-20 12:00:00	AMZN	Stock	3.7225	3.726	3.697	3.703	11999180.0
2007-08-20 13:00:00	AMZN	Stock	3.704	3.73	3.69	3.715	10970580.0
2007-08-20 14:00:00	AMZN	Stock	3.7155	3.7425	3.705	3.7375	10399900.0
2007-08-20 15:00:00	AMZN	Stock	3.7385	3.7535	3.7175	3.735	21352620.0
2007-08-20 16:00:00	AMZN	Stock	3.735	3.7425	3.732	3.736	176060.0
2007-08-20 17:00:00	AMZN	Stock	3.736	3.744	3.736	3.744	10000.0
2007-08-20 19:00:00	AMZN	Stock	3.744	3.7445	3.744	3.7445	21800.0
2007-08-20 09:00:00	TLT	Stock	86.96	87.02	86.83	86.97	118014.0
2007-08-20 10:00:00	TLT	Stock	86.93	87.14	86.9	86.99	326500.0
2007-08-20 11:00:00	TLT	Stock	86.99	87.03	86.86	86.99	107400.0
2007-08-20 12:00:00	TLT	Stock	87.0	87.16	86.96	87.16	76400.0
2007-08-20 13:00:00	TLT	Stock	87.17	87.27	87.07	87.1	74100.0
2007-08-20 14:00:00	TLT	Stock	87.14	87.16	86.94	86.96	109000.0
2007-08-20 15:00:00	TLT	Stock	86.95	86.96	86.83	86.84	232766.0
2007-08-20 09:00:00	CL	Stock	33.565	33.935	33.515	33.835	589000.0
2007-08-20 10:00:00	CL	Stock	33.82	33.865	33.515	33.585	431200.0
2007-08-20 11:00:00	CL	Stock	33.59	33.59	33.32	33.32	464800.0
2007-08-20 12:00:00	CL	Stock	33.32	33.415	33.15	33.175	662200.0

> showing 50 of 38,112 rows — these rows as CSV

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