PREVIEW / stock_1hour / 2007-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-29.parquet
  size:    750 KB
  rows:    36,982
  symbols: 3,021

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-29 09:00:00	AAPL	Stock	4.0875	4.1021	4.0561	4.063	97662684.0
2007-05-29 10:00:00	AAPL	Stock	4.065	4.0779	4.0489	4.0618	104354908.0
2007-05-29 11:00:00	AAPL	Stock	4.0611	4.0639	4.0407	4.0464	78195040.0
2007-05-29 12:00:00	AAPL	Stock	4.0464	4.05	4.0268	4.0404	66587808.0
2007-05-29 13:00:00	AAPL	Stock	4.0397	4.0496	4.0246	4.0371	59818696.0
2007-05-29 14:00:00	AAPL	Stock	4.0368	4.0793	4.0339	4.0689	103186468.0
2007-05-29 15:00:00	AAPL	Stock	4.0689	4.0882	4.0643	4.0839	112272244.0
2007-05-29 16:00:00	AAPL	Stock	4.0839	4.0839	4.0839	4.0839	3958836.0
2007-05-29 09:00:00	MSFT	Stock	30.49	30.64	30.39	30.64	4512728.0
2007-05-29 10:00:00	MSFT	Stock	30.64	30.81	30.54	30.8	6893789.0
2007-05-29 11:00:00	MSFT	Stock	30.801	30.83	30.69	30.69	5015685.0
2007-05-29 12:00:00	MSFT	Stock	30.69	30.69	30.54	30.62	3987429.0
2007-05-29 13:00:00	MSFT	Stock	30.621	30.64	30.48	30.55	4254824.0
2007-05-29 14:00:00	MSFT	Stock	30.55	30.66	30.5	30.64	3587149.0
2007-05-29 15:00:00	MSFT	Stock	30.63	30.83	30.63	30.8	9761425.0
2007-05-29 16:00:00	MSFT	Stock	30.79	30.79	30.79	30.79	2735404.0
2007-05-29 09:00:00	NVDA	Stock	0.5588	0.5642	0.557	0.564	29576940.0
2007-05-29 10:00:00	NVDA	Stock	0.564	0.5663	0.559	0.5653	42794100.0
2007-05-29 11:00:00	NVDA	Stock	0.5653	0.5678	0.5645	0.5645	39213300.0
2007-05-29 12:00:00	NVDA	Stock	0.5645	0.5678	0.5642	0.5672	55470180.0
2007-05-29 13:00:00	NVDA	Stock	0.5672	0.5687	0.5627	0.563	43013100.0
2007-05-29 14:00:00	NVDA	Stock	0.563	0.567	0.5612	0.5667	38298360.0
2007-05-29 15:00:00	NVDA	Stock	0.5667	0.5688	0.5658	0.5673	58854660.0
2007-05-29 16:00:00	NVDA	Stock	0.567	0.5675	0.567	0.567	4555500.0
2007-05-29 17:00:00	NVDA	Stock	0.5667	0.5667	0.5667	0.5667	30000.0
2007-05-29 08:00:00	AMZN	Stock	3.4325	3.4325	3.42	3.425	147820.0
2007-05-29 09:00:00	AMZN	Stock	3.425	3.4325	3.386	3.415	31323700.0
2007-05-29 10:00:00	AMZN	Stock	3.4145	3.48	3.399	3.4665	59051680.0
2007-05-29 11:00:00	AMZN	Stock	3.466	3.489	3.4505	3.4515	32446260.0
2007-05-29 12:00:00	AMZN	Stock	3.451	3.4665	3.4	3.4575	24857840.0
2007-05-29 13:00:00	AMZN	Stock	3.457	3.475	3.432	3.4425	20313200.0
2007-05-29 14:00:00	AMZN	Stock	3.443	3.459	3.4355	3.453	18848520.0
2007-05-29 15:00:00	AMZN	Stock	3.453	3.4888	3.451	3.4815	41953520.0
2007-05-29 16:00:00	AMZN	Stock	3.4815	3.486	3.4815	3.486	3161120.0
2007-05-29 17:00:00	AMZN	Stock	3.486	3.486	3.4835	3.4835	139860.0
2007-05-29 18:00:00	AMZN	Stock	3.485	3.486	3.483	3.486	32740.0
2007-05-29 19:00:00	AMZN	Stock	3.487	3.4875	3.48	3.48	41200.0
2007-05-29 09:00:00	TLT	Stock	86.51	86.55	86.51	86.54	154000.0
2007-05-29 10:00:00	TLT	Stock	86.52	86.57	86.42	86.44	239600.0
2007-05-29 11:00:00	TLT	Stock	86.45	86.45	86.32	86.43	156900.0
2007-05-29 12:00:00	TLT	Stock	86.42	86.42	86.35	86.35	79300.0
2007-05-29 13:00:00	TLT	Stock	86.35	86.46	86.32	86.43	84700.0
2007-05-29 14:00:00	TLT	Stock	86.43	86.44	85.83	86.4	127700.0
2007-05-29 15:00:00	TLT	Stock	86.4	86.41	86.34	86.36	210800.0
2007-05-29 09:00:00	CL	Stock	33.225	33.415	33.175	33.395	195400.0
2007-05-29 10:00:00	CL	Stock	33.4	33.42	33.295	33.31	469200.0
2007-05-29 11:00:00	CL	Stock	33.315	33.5	33.29	33.365	613400.0
2007-05-29 12:00:00	CL	Stock	33.365	33.37	33.29	33.33	295000.0
2007-05-29 13:00:00	CL	Stock	33.335	33.385	33.28	33.385	277200.0
2007-05-29 14:00:00	CL	Stock	33.385	33.42	33.345	33.4	410000.0

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

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