PREVIEW / stock_1hour / 2007-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-21.parquet
  size:    748 KB
  rows:    36,692
  symbols: 3,019

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-05-21 09:00:00	AAPL	Stock	3.9396	3.9614	3.9304	3.9584	69205220.0
2007-05-21 10:00:00	AAPL	Stock	3.9571	4.0061	3.9536	4.005	136345608.0
2007-05-21 11:00:00	AAPL	Stock	4.005	4.0079	3.9929	4.0011	70980672.0
2007-05-21 12:00:00	AAPL	Stock	4.0011	4.0161	3.8768	3.9929	91883176.0
2007-05-21 13:00:00	AAPL	Stock	3.9929	4.0007	3.9861	3.9943	47997068.0
2007-05-21 14:00:00	AAPL	Stock	3.9943	4.0125	3.9921	4.0082	65802772.0
2007-05-21 15:00:00	AAPL	Stock	4.0079	4.0125	3.9786	3.9996	138951092.0
2007-05-21 16:00:00	AAPL	Stock	3.9993	4.0	3.9989	3.9993	4070696.0
2007-05-21 09:00:00	MSFT	Stock	30.73	31.0	30.73	30.97	3292257.0
2007-05-21 10:00:00	MSFT	Stock	30.97	31.15	30.96	31.14	7030851.0
2007-05-21 11:00:00	MSFT	Stock	31.13	31.15	31.1	31.12	4503826.0
2007-05-21 12:00:00	MSFT	Stock	31.12	31.16	31.1	31.135	4117298.0
2007-05-21 13:00:00	MSFT	Stock	31.14	31.16	31.06	31.08	3870975.0
2007-05-21 14:00:00	MSFT	Stock	31.08	31.11	30.99	31.02	4720651.0
2007-05-21 15:00:00	MSFT	Stock	31.01	31.07	30.892	31.07	10509633.0
2007-05-21 16:00:00	MSFT	Stock	31.06	31.07	31.05	31.05	769700.0
2007-05-21 04:00:00	NVDA	Stock	0.5837	0.5837	0.5837	0.5837	30000.0
2007-05-21 07:00:00	NVDA	Stock	0.584	0.584	0.584	0.584	30000.0
2007-05-21 08:00:00	NVDA	Stock	0.5837	0.5837	0.5837	0.5837	108000.0
2007-05-21 09:00:00	NVDA	Stock	0.5848	0.585	0.58	0.5808	31420320.0
2007-05-21 10:00:00	NVDA	Stock	0.5808	0.5883	0.5792	0.5877	61631340.0
2007-05-21 11:00:00	NVDA	Stock	0.5877	0.5892	0.5847	0.587	42202440.0
2007-05-21 12:00:00	NVDA	Stock	0.5872	0.5892	0.586	0.5863	33771960.0
2007-05-21 13:00:00	NVDA	Stock	0.5862	0.6	0.586	0.5945	283712460.0
2007-05-21 14:00:00	NVDA	Stock	0.5945	0.5967	0.5887	0.5905	73775280.0
2007-05-21 15:00:00	NVDA	Stock	0.5903	0.5907	0.5833	0.5855	111665760.0
2007-05-21 16:00:00	NVDA	Stock	0.5855	0.5875	0.5855	0.5875	4488300.0
2007-05-21 17:00:00	NVDA	Stock	0.5873	0.5873	0.5867	0.5867	80700.0
2007-05-21 19:00:00	NVDA	Stock	0.5873	0.5873	0.5873	0.5873	10200.0
2007-05-21 08:00:00	AMZN	Stock	3.1485	3.1765	3.1485	3.161	938980.0
2007-05-21 09:00:00	AMZN	Stock	3.161	3.2495	3.155	3.235	75446360.0
2007-05-21 10:00:00	AMZN	Stock	3.235	3.2925	3.234	3.289	93542340.0
2007-05-21 11:00:00	AMZN	Stock	3.2895	3.4275	3.2835	3.406	152756960.0
2007-05-21 12:00:00	AMZN	Stock	3.407	3.425	3.3835	3.4135	103012620.0
2007-05-21 13:00:00	AMZN	Stock	3.4142	3.4178	3.3675	3.409	75771800.0
2007-05-21 14:00:00	AMZN	Stock	3.4085	3.434	3.39	3.398	88301700.0
2007-05-21 15:00:00	AMZN	Stock	3.3985	3.419	3.3515	3.4155	121604340.0
2007-05-21 16:00:00	AMZN	Stock	3.415	3.423	3.415	3.42	8557300.0
2007-05-21 17:00:00	AMZN	Stock	3.42	3.4255	3.4185	3.4215	677660.0
2007-05-21 18:00:00	AMZN	Stock	3.425	3.4325	3.425	3.428	623620.0
2007-05-21 19:00:00	AMZN	Stock	3.4275	3.429	3.425	3.4255	229900.0
2007-05-21 09:00:00	TLT	Stock	86.93	86.93	86.83	86.86	54500.0
2007-05-21 10:00:00	TLT	Stock	86.86	86.9	86.85	86.85	73100.0
2007-05-21 11:00:00	TLT	Stock	86.85	86.98	86.85	86.97	20400.0
2007-05-21 12:00:00	TLT	Stock	86.97	87.0	86.94	87.0	20500.0
2007-05-21 13:00:00	TLT	Stock	87.0	87.09	87.0	87.06	27100.0
2007-05-21 14:00:00	TLT	Stock	87.08	87.21	87.08	87.17	107700.0
2007-05-21 15:00:00	TLT	Stock	87.18	87.24	87.18	87.19	46063.0
2007-05-21 16:00:00	TLT	Stock	87.19	87.19	87.19	87.19	300.0
2007-05-21 09:00:00	CL	Stock	33.66	33.66	33.265	33.44	476600.0

> showing 50 of 36,692 rows — these rows as CSV

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