PREVIEW / stock_1hour / 2008-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-28.parquet
  size:    515 KB
  rows:    24,474
  symbols: 3,234

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
2008-11-28 04:00:00	AAPL	Stock	3.3843	3.3843	3.3839	3.3839	15400.0
2008-11-28 07:00:00	AAPL	Stock	3.3661	3.3664	3.3661	3.3664	52416.0
2008-11-28 08:00:00	AAPL	Stock	3.3843	3.3925	3.3729	3.3857	799960.0
2008-11-28 09:00:00	AAPL	Stock	3.3857	3.3925	3.3075	3.3161	61146092.0
2008-11-28 10:00:00	AAPL	Stock	3.3146	3.33	3.2807	3.2975	84728196.0
2008-11-28 11:00:00	AAPL	Stock	3.2978	3.3286	3.2864	3.3257	54437992.0
2008-11-28 12:00:00	AAPL	Stock	3.3257	3.3261	3.2843	3.3096	76153448.0
2008-11-28 13:00:00	AAPL	Stock	3.3064	3.3141	3.2982	3.3021	22792252.0
2008-11-28 14:00:00	AAPL	Stock	3.3021	3.3036	3.3004	3.3004	237692.0
2008-11-28 15:00:00	AAPL	Stock	3.3004	3.3014	3.2929	3.2982	121324.0
2008-11-28 16:00:00	AAPL	Stock	3.3004	3.3068	3.3	3.3	28280.0
2008-11-28 04:00:00	MSFT	Stock	20.35	20.35	20.35	20.35	250.0
2008-11-28 07:00:00	MSFT	Stock	20.35	20.35	20.35	20.35	349.0
2008-11-28 08:00:00	MSFT	Stock	20.4	20.4	20.21	20.21	7305.0
2008-11-28 09:00:00	MSFT	Stock	20.23	20.32	20.02	20.09	4137935.0
2008-11-28 10:00:00	MSFT	Stock	20.09	20.19	20.02	20.08	4943573.0
2008-11-28 11:00:00	MSFT	Stock	20.075	20.17	20.04	20.14	4849051.0
2008-11-28 12:00:00	MSFT	Stock	20.15	20.25	20.1	20.23	8533247.0
2008-11-28 13:00:00	MSFT	Stock	20.23	20.3	20.08	20.25	6015108.0
2008-11-28 14:00:00	MSFT	Stock	20.31	20.32	20.22	20.22	2236900.0
2008-11-28 15:00:00	MSFT	Stock	20.25	20.25	20.25	20.25	150.0
2008-11-28 16:00:00	MSFT	Stock	20.22	20.22	20.22	20.22	100.0
2008-11-28 08:00:00	NVDA	Stock	0.1893	0.1893	0.1893	0.1893	32000.0
2008-11-28 09:00:00	NVDA	Stock	0.1888	0.189	0.1843	0.1858	23620360.0
2008-11-28 10:00:00	NVDA	Stock	0.1858	0.19	0.1853	0.1873	40892520.0
2008-11-28 11:00:00	NVDA	Stock	0.1873	0.189	0.186	0.1885	32506880.0
2008-11-28 12:00:00	NVDA	Stock	0.1883	0.1888	0.185	0.187	54650200.0
2008-11-28 13:00:00	NVDA	Stock	0.1868	0.1871	0.1865	0.1868	20321080.0
2008-11-28 14:00:00	NVDA	Stock	0.1873	0.1873	0.1868	0.1868	76600.0
2008-11-28 15:00:00	NVDA	Stock	0.1868	0.1875	0.1868	0.1875	73000.0
2008-11-28 07:00:00	AMZN	Stock	2.1775	2.1775	2.1775	2.1775	10000.0
2008-11-28 08:00:00	AMZN	Stock	2.198	2.198	2.17	2.17	179800.0
2008-11-28 09:00:00	AMZN	Stock	2.1925	2.205	2.1525	2.154	12679540.0
2008-11-28 10:00:00	AMZN	Stock	2.1545	2.1765	2.131	2.1475	15071780.0
2008-11-28 11:00:00	AMZN	Stock	2.148	2.1515	2.111	2.1285	14271500.0
2008-11-28 12:00:00	AMZN	Stock	2.128	2.154	2.1144	2.1325	18085960.0
2008-11-28 13:00:00	AMZN	Stock	2.1335	2.1452	2.125	2.135	9323060.0
2008-11-28 14:00:00	AMZN	Stock	2.137	2.1495	2.135	2.1495	4010000.0
2008-11-28 07:00:00	TLT	Stock	105.12	105.12	105.12	105.12	500.0
2008-11-28 09:00:00	TLT	Stock	105.25	105.37	104.94	105.16	92698.0
2008-11-28 10:00:00	TLT	Stock	105.18	105.57	105.13	105.38	473479.0
2008-11-28 11:00:00	TLT	Stock	105.38	105.74	105.38	105.7	142788.0
2008-11-28 12:00:00	TLT	Stock	105.69	105.97	105.66	105.72	253054.0
2008-11-28 13:00:00	TLT	Stock	105.51	106.35	105.51	105.7	24218.0
2008-11-28 09:00:00	CL	Stock	31.66	32.41	31.66	32.39	416170.0
2008-11-28 10:00:00	CL	Stock	32.365	32.615	32.285	32.337	955154.0
2008-11-28 11:00:00	CL	Stock	32.335	32.375	31.995	32.28	547030.0
2008-11-28 12:00:00	CL	Stock	32.265	32.66	32.245	32.55	1044640.0
2008-11-28 13:00:00	CL	Stock	32.615	32.615	32.385	32.535	721290.0
2008-11-28 14:00:00	CL	Stock	32.55	32.55	32.55	32.55	200.0

> showing 50 of 24,474 rows — these rows as CSV

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