PREVIEW / stock_1hour / 2007-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-28.parquet
  size:    825 KB
  rows:    40,775
  symbols: 3,222

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-11-28 06:00:00	AAPL	Stock	6.2532	6.2714	6.2496	6.2714	39200.0
2007-11-28 07:00:00	AAPL	Stock	6.285	6.3186	6.2768	6.3107	859964.0
2007-11-28 08:00:00	AAPL	Stock	6.3107	6.3254	6.2911	6.3018	8034656.0
2007-11-28 09:00:00	AAPL	Stock	6.3018	6.3239	6.2679	6.2946	188440504.0
2007-11-28 10:00:00	AAPL	Stock	6.2947	6.3729	6.2625	6.3475	244524532.0
2007-11-28 11:00:00	AAPL	Stock	6.3468	6.3921	6.3379	6.3914	115631376.0
2007-11-28 12:00:00	AAPL	Stock	6.3918	6.41	6.3768	6.3871	113704556.0
2007-11-28 13:00:00	AAPL	Stock	6.3868	6.4246	6.3768	6.4171	105072856.0
2007-11-28 14:00:00	AAPL	Stock	6.4171	6.4286	6.3993	6.4157	126390152.0
2007-11-28 15:00:00	AAPL	Stock	6.4157	6.45	6.3911	6.4332	215725160.0
2007-11-28 16:00:00	AAPL	Stock	6.4354	6.4418	6.369	6.4386	25405660.0
2007-11-28 17:00:00	AAPL	Stock	6.4389	6.4407	6.2432	6.4407	5133016.0
2007-11-28 18:00:00	AAPL	Stock	6.4386	6.4425	6.2432	6.4375	1367576.0
2007-11-28 19:00:00	AAPL	Stock	6.4375	6.4464	6.4375	6.4461	670068.0
2007-11-28 07:00:00	MSFT	Stock	33.11	33.4	33.11	33.37	32053.0
2007-11-28 08:00:00	MSFT	Stock	33.37	33.44	33.28	33.41	325518.0
2007-11-28 09:00:00	MSFT	Stock	33.4	33.45	33.08	33.14	8394854.0
2007-11-28 10:00:00	MSFT	Stock	33.14	33.5	32.9	33.44	16024661.0
2007-11-28 11:00:00	MSFT	Stock	33.442	33.45	33.25	33.35	8462768.0
2007-11-28 12:00:00	MSFT	Stock	33.35	33.41	33.22	33.27	7511774.0
2007-11-28 13:00:00	MSFT	Stock	33.27	33.4	33.23	33.36	8101105.0
2007-11-28 14:00:00	MSFT	Stock	33.36	33.62	33.29	33.59	10818538.0
2007-11-28 15:00:00	MSFT	Stock	33.59	33.89	33.53	33.69	21834817.0
2007-11-28 16:00:00	MSFT	Stock	33.69	33.712	33.06	33.65	6587081.0
2007-11-28 17:00:00	MSFT	Stock	33.65	33.7	33.06	33.63	490840.0
2007-11-28 18:00:00	MSFT	Stock	33.62	33.66	33.61	33.61	2210.0
2007-11-28 19:00:00	MSFT	Stock	33.65	33.65	33.6	33.65	1240.0
2007-11-28 08:00:00	NVDA	Stock	0.7708	0.785	0.7708	0.785	290680.0
2007-11-28 09:00:00	NVDA	Stock	0.785	0.8245	0.781	0.8023	87315080.0
2007-11-28 10:00:00	NVDA	Stock	0.8023	0.8322	0.798	0.8218	116913880.0
2007-11-28 11:00:00	NVDA	Stock	0.822	0.825	0.8175	0.8233	64801840.0
2007-11-28 12:00:00	NVDA	Stock	0.8235	0.8275	0.8212	0.8234	53670720.0
2007-11-28 13:00:00	NVDA	Stock	0.8235	0.825	0.8195	0.8225	45173720.0
2007-11-28 14:00:00	NVDA	Stock	0.8225	0.8258	0.8158	0.8198	50170480.0
2007-11-28 15:00:00	NVDA	Stock	0.8196	0.8242	0.812	0.8212	123040960.0
2007-11-28 16:00:00	NVDA	Stock	0.8208	0.823	0.8177	0.8212	24412440.0
2007-11-28 17:00:00	NVDA	Stock	0.8212	0.8248	0.7698	0.8178	8382000.0
2007-11-28 07:00:00	AMZN	Stock	4.3	4.335	4.3	4.332	16000.0
2007-11-28 08:00:00	AMZN	Stock	4.3025	4.375	4.3025	4.375	1362060.0
2007-11-28 09:00:00	AMZN	Stock	4.3775	4.396	4.3375	4.396	35255280.0
2007-11-28 10:00:00	AMZN	Stock	4.3955	4.4725	4.3905	4.455	45958020.0
2007-11-28 11:00:00	AMZN	Stock	4.455	4.461	4.414	4.4365	21064300.0
2007-11-28 12:00:00	AMZN	Stock	4.4365	4.46	4.433	4.442	15169540.0
2007-11-28 13:00:00	AMZN	Stock	4.442	4.487	4.435	4.4755	15481160.0
2007-11-28 14:00:00	AMZN	Stock	4.4755	4.4865	4.4185	4.4735	31171840.0
2007-11-28 15:00:00	AMZN	Stock	4.474	4.5285	4.467	4.513	53672780.0
2007-11-28 16:00:00	AMZN	Stock	4.513	4.5245	4.4452	4.5155	8019740.0
2007-11-28 17:00:00	AMZN	Stock	4.515	4.5155	4.2795	4.5155	826500.0
2007-11-28 18:00:00	AMZN	Stock	4.515	4.5375	4.515	4.5375	40500.0
2007-11-28 19:00:00	AMZN	Stock	4.5155	4.5325	4.5125	4.5125	21000.0

> showing 50 of 40,775 rows — these rows as CSV

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