PREVIEW / stock_1hour / 2007-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-17.parquet
  size:    755 KB
  rows:    38,054
  symbols: 3,102

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-09-17 09:00:00	AAPL	Stock	4.9639	5.0211	4.9586	4.9968	144823924.0
2007-09-17 10:00:00	AAPL	Stock	4.9968	5.0089	4.9459	4.9596	174962004.0
2007-09-17 11:00:00	AAPL	Stock	4.9594	4.9711	4.9143	4.9314	96549292.0
2007-09-17 12:00:00	AAPL	Stock	4.9314	4.9461	4.9193	4.9407	66031924.0
2007-09-17 13:00:00	AAPL	Stock	4.9407	4.9679	4.9375	4.9543	73598056.0
2007-09-17 14:00:00	AAPL	Stock	4.955	4.9804	4.9525	4.9629	66249848.0
2007-09-17 15:00:00	AAPL	Stock	4.9629	4.975	4.9393	4.9432	85339884.0
2007-09-17 16:00:00	AAPL	Stock	4.9436	4.9436	4.9432	4.9432	7072436.0
2007-09-17 09:00:00	MSFT	Stock	28.79	28.85	28.7	28.78	4456893.0
2007-09-17 10:00:00	MSFT	Stock	28.78	28.88	28.65	28.66	6022444.0
2007-09-17 11:00:00	MSFT	Stock	28.651	28.72	28.65	28.7	4857609.0
2007-09-17 12:00:00	MSFT	Stock	28.7	28.71	28.65	28.69	2884407.0
2007-09-17 13:00:00	MSFT	Stock	28.7	28.71	28.66	28.66	2463249.0
2007-09-17 14:00:00	MSFT	Stock	28.66	28.69	28.62	28.66	4918698.0
2007-09-17 15:00:00	MSFT	Stock	28.66	28.76	28.64	28.72	6865617.0
2007-09-17 16:00:00	MSFT	Stock	28.73	28.73	28.72	28.725	1377951.0
2007-09-17 08:00:00	NVDA	Stock	0.8	0.8142	0.8	0.81	164160.0
2007-09-17 09:00:00	NVDA	Stock	0.8125	0.8125	0.7958	0.8065	53947400.0
2007-09-17 10:00:00	NVDA	Stock	0.8068	0.808	0.7988	0.802	50285240.0
2007-09-17 11:00:00	NVDA	Stock	0.8023	0.806	0.8015	0.8052	44325240.0
2007-09-17 12:00:00	NVDA	Stock	0.8055	0.8123	0.8048	0.8108	45047120.0
2007-09-17 13:00:00	NVDA	Stock	0.8108	0.816	0.809	0.8102	40320760.0
2007-09-17 14:00:00	NVDA	Stock	0.8102	0.811	0.807	0.8072	31005680.0
2007-09-17 15:00:00	NVDA	Stock	0.8072	0.8095	0.804	0.8045	39229000.0
2007-09-17 16:00:00	NVDA	Stock	0.805	0.811	0.8045	0.8045	32313640.0
2007-09-17 17:00:00	NVDA	Stock	0.8045	0.8045	0.8045	0.8045	124000.0
2007-09-17 19:00:00	NVDA	Stock	0.8072	0.8072	0.8072	0.8072	24000.0
2007-09-17 06:00:00	AMZN	Stock	4.35	4.35	4.325	4.325	12400.0
2007-09-17 07:00:00	AMZN	Stock	4.334	4.384	4.334	4.3575	24000.0
2007-09-17 08:00:00	AMZN	Stock	4.3725	4.3725	4.352	4.3625	119680.0
2007-09-17 09:00:00	AMZN	Stock	4.36	4.37	4.325	4.325	17769560.0
2007-09-17 10:00:00	AMZN	Stock	4.3265	4.329	4.299	4.3175	19840160.0
2007-09-17 11:00:00	AMZN	Stock	4.3185	4.3325	4.3145	4.319	6976980.0
2007-09-17 12:00:00	AMZN	Stock	4.32	4.34	4.319	4.3345	5692840.0
2007-09-17 13:00:00	AMZN	Stock	4.3345	4.3445	4.3265	4.3285	8836980.0
2007-09-17 14:00:00	AMZN	Stock	4.3285	4.359	4.3285	4.338	12126720.0
2007-09-17 15:00:00	AMZN	Stock	4.3375	4.3475	4.3305	4.3455	12043640.0
2007-09-17 16:00:00	AMZN	Stock	4.3467	4.371	4.34	4.34	3188080.0
2007-09-17 18:00:00	AMZN	Stock	4.3465	4.349	4.3465	4.349	23300.0
2007-09-17 19:00:00	AMZN	Stock	4.3495	4.3495	4.3495	4.3495	9800.0
2007-09-17 09:00:00	TLT	Stock	89.82	89.93	89.77	89.81	20800.0
2007-09-17 10:00:00	TLT	Stock	89.78	89.93	89.76	89.91	330600.0
2007-09-17 11:00:00	TLT	Stock	89.91	90.1	89.85	90.1	98000.0
2007-09-17 12:00:00	TLT	Stock	90.1	90.12	89.97	90.06	90000.0
2007-09-17 13:00:00	TLT	Stock	90.04	90.09	90.01	90.03	87300.0
2007-09-17 14:00:00	TLT	Stock	90.03	90.11	89.95	90.1	229000.0
2007-09-17 15:00:00	TLT	Stock	90.11	90.39	90.06	90.31	359800.0
2007-09-17 16:00:00	TLT	Stock	90.34	90.39	90.31	90.34	42500.0
2007-09-17 09:00:00	CL	Stock	33.78	34.085	33.77	33.945	345800.0
2007-09-17 10:00:00	CL	Stock	33.945	34.22	33.89	34.185	969000.0

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

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