PREVIEW / stock_1hour / 2007-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-20.parquet
  size:    684 KB
  rows:    32,450
  symbols: 2,548

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-03-20 07:00:00	AAPL	Stock	3.2607	3.2679	3.255	3.2643	470400.0
2007-03-20 08:00:00	AAPL	Stock	3.2643	3.2643	3.2546	3.2607	2854964.0
2007-03-20 09:00:00	AAPL	Stock	3.2607	3.2736	3.2521	3.2579	93154488.0
2007-03-20 10:00:00	AAPL	Stock	3.2571	3.2729	3.2543	3.2621	78824312.0
2007-03-20 11:00:00	AAPL	Stock	3.2618	3.2768	3.2586	3.2746	68184872.0
2007-03-20 12:00:00	AAPL	Stock	3.2746	3.28	3.2686	3.2697	53538324.0
2007-03-20 13:00:00	AAPL	Stock	3.2696	3.2736	3.2568	3.2607	62770036.0
2007-03-20 14:00:00	AAPL	Stock	3.2607	3.2754	3.26	3.2668	53246704.0
2007-03-20 15:00:00	AAPL	Stock	3.2666	3.2764	3.2654	3.2668	65850428.0
2007-03-20 16:00:00	AAPL	Stock	3.2664	3.2739	3.2664	3.2696	2301404.0
2007-03-20 17:00:00	AAPL	Stock	3.2711	3.2739	3.2693	3.2693	582568.0
2007-03-20 18:00:00	AAPL	Stock	3.2696	3.2725	3.2696	3.2725	93520.0
2007-03-20 19:00:00	AAPL	Stock	3.2711	3.2714	3.2682	3.2686	139216.0
2007-03-20 07:00:00	MSFT	Stock	27.85	27.85	27.83	27.83	200.0
2007-03-20 08:00:00	MSFT	Stock	27.83	27.92	27.82	27.91	19705.0
2007-03-20 09:00:00	MSFT	Stock	27.9	27.99	27.76	27.96	6302229.0
2007-03-20 10:00:00	MSFT	Stock	27.97	28.0	27.88	27.92	6427072.0
2007-03-20 11:00:00	MSFT	Stock	27.923	28.09	27.88	28.08	5102234.0
2007-03-20 12:00:00	MSFT	Stock	28.08	28.16	28.01	28.04	5720300.0
2007-03-20 13:00:00	MSFT	Stock	28.04	28.09	27.9	27.96	5933896.0
2007-03-20 14:00:00	MSFT	Stock	27.95	28.04	27.92	27.95	5058626.0
2007-03-20 15:00:00	MSFT	Stock	27.95	27.97	27.82	27.82	10285760.0
2007-03-20 16:00:00	MSFT	Stock	27.82	28.0	27.82	27.84	1132450.0
2007-03-20 17:00:00	MSFT	Stock	27.89	27.92	27.88	27.9	14185.0
2007-03-20 18:00:00	MSFT	Stock	27.9	27.95	27.87	27.95	3972.0
2007-03-20 19:00:00	MSFT	Stock	27.9	27.99	27.9	27.99	10220.0
2007-03-20 08:00:00	NVDA	Stock	0.4752	0.4752	0.475	0.475	96000.0
2007-03-20 09:00:00	NVDA	Stock	0.475	0.4817	0.4732	0.4812	71686020.0
2007-03-20 10:00:00	NVDA	Stock	0.4812	0.4842	0.4778	0.4797	119068440.0
2007-03-20 11:00:00	NVDA	Stock	0.4797	0.4798	0.475	0.476	106049820.0
2007-03-20 12:00:00	NVDA	Stock	0.4758	0.4778	0.475	0.4767	57260520.0
2007-03-20 13:00:00	NVDA	Stock	0.4765	0.477	0.4707	0.4722	70268640.0
2007-03-20 14:00:00	NVDA	Stock	0.4722	0.4757	0.4707	0.4718	112025700.0
2007-03-20 15:00:00	NVDA	Stock	0.472	0.4747	0.4718	0.4722	100549980.0
2007-03-20 16:00:00	NVDA	Stock	0.472	0.4742	0.472	0.4742	3072660.0
2007-03-20 17:00:00	NVDA	Stock	0.4735	0.4742	0.4735	0.4742	183060.0
2007-03-20 19:00:00	NVDA	Stock	0.4742	0.4742	0.4725	0.4725	102000.0
2007-03-20 08:00:00	AMZN	Stock	1.9275	1.9275	1.9275	1.9275	2000.0
2007-03-20 09:00:00	AMZN	Stock	1.925	1.9265	1.9115	1.9135	7380420.0
2007-03-20 10:00:00	AMZN	Stock	1.9138	1.919	1.9115	1.9165	12716160.0
2007-03-20 11:00:00	AMZN	Stock	1.917	1.9235	1.917	1.923	6960540.0
2007-03-20 12:00:00	AMZN	Stock	1.923	1.9305	1.9225	1.929	8099420.0
2007-03-20 13:00:00	AMZN	Stock	1.9285	1.931	1.9255	1.929	12482560.0
2007-03-20 14:00:00	AMZN	Stock	1.929	1.9305	1.9215	1.9238	11344880.0
2007-03-20 15:00:00	AMZN	Stock	1.924	1.9345	1.924	1.9285	14220480.0
2007-03-20 16:00:00	AMZN	Stock	1.929	1.929	1.929	1.929	53420.0
2007-03-20 17:00:00	AMZN	Stock	1.929	1.929	1.929	1.929	280000.0
2007-03-20 09:00:00	CL	Stock	32.65	32.795	32.645	32.755	280400.0
2007-03-20 10:00:00	CL	Stock	32.745	32.795	32.65	32.695	402200.0
2007-03-20 11:00:00	CL	Stock	32.695	32.73	32.635	32.645	394000.0

> showing 50 of 32,450 rows — these rows as CSV

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