PREVIEW / stock_1hour / 2005-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-30.parquet
  size:    590 KB
  rows:    28,072
  symbols: 2,089

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
2005-09-30 08:00:00	AAPL	Stock	1.8696	1.8711	1.8639	1.8693	207284.0
2005-09-30 09:00:00	AAPL	Stock	1.8686	1.875	1.8529	1.8671	62648880.0
2005-09-30 10:00:00	AAPL	Stock	1.8671	1.9025	1.8639	1.9	115441284.0
2005-09-30 11:00:00	AAPL	Stock	1.9004	1.9071	1.8882	1.8943	67660936.0
2005-09-30 12:00:00	AAPL	Stock	1.8943	1.91	1.8932	1.9086	57850716.0
2005-09-30 13:00:00	AAPL	Stock	1.9086	1.9089	1.8968	1.8979	48535340.0
2005-09-30 14:00:00	AAPL	Stock	1.8982	1.905	1.8939	1.9	56935032.0
2005-09-30 15:00:00	AAPL	Stock	1.9004	1.9161	1.8975	1.9161	100557156.0
2005-09-30 16:00:00	AAPL	Stock	1.9146	1.9161	1.905	1.9143	2921212.0
2005-09-30 17:00:00	AAPL	Stock	1.9143	1.9179	1.9093	1.9125	329644.0
2005-09-30 18:00:00	AAPL	Stock	1.9146	1.9171	1.9107	1.9136	381080.0
2005-09-30 07:00:00	MSFT	Stock	26.08	26.08	26.08	26.08	201.0
2005-09-30 08:00:00	MSFT	Stock	25.92	25.93	25.91	25.93	2700.0
2005-09-30 09:00:00	MSFT	Stock	25.92	25.95	25.72	25.81	7779957.0
2005-09-30 10:00:00	MSFT	Stock	25.82	25.95	25.79	25.81	6387808.0
2005-09-30 11:00:00	MSFT	Stock	25.82	25.82	25.66	25.67	5372020.0
2005-09-30 12:00:00	MSFT	Stock	25.674	25.91	25.64	25.652	6237648.0
2005-09-30 13:00:00	MSFT	Stock	25.659	25.75	25.62	25.688	5029777.0
2005-09-30 14:00:00	MSFT	Stock	25.68	25.81	25.67	25.74	7795062.0
2005-09-30 15:00:00	MSFT	Stock	25.74	25.801	25.61	25.72	14151631.0
2005-09-30 16:00:00	MSFT	Stock	25.72	25.75	25.685	25.73	1077821.0
2005-09-30 17:00:00	MSFT	Stock	25.73	25.74	25.72	25.74	89450.0
2005-09-30 18:00:00	MSFT	Stock	25.73	25.74	25.73	25.74	22668.0
2005-09-30 09:00:00	NVDA	Stock	0.2836	0.2878	0.2827	0.2878	101348520.0
2005-09-30 10:00:00	NVDA	Stock	0.2879	0.2882	0.2857	0.288	102127080.0
2005-09-30 11:00:00	NVDA	Stock	0.288	0.288	0.2839	0.2852	53639760.0
2005-09-30 12:00:00	NVDA	Stock	0.2852	0.2867	0.2849	0.2862	34630320.0
2005-09-30 13:00:00	NVDA	Stock	0.2862	0.2864	0.285	0.2852	31428840.0
2005-09-30 14:00:00	NVDA	Stock	0.285	0.2867	0.285	0.2858	43611600.0
2005-09-30 15:00:00	NVDA	Stock	0.2858	0.2865	0.2848	0.2855	77966400.0
2005-09-30 16:00:00	NVDA	Stock	0.2857	0.2858	0.2853	0.2857	1577760.0
2005-09-30 17:00:00	NVDA	Stock	0.2863	0.2867	0.2857	0.2862	394440.0
2005-09-30 18:00:00	NVDA	Stock	0.2863	0.2863	0.2863	0.2863	30000.0
2005-09-30 08:00:00	AMZN	Stock	2.2395	2.2395	2.225	2.2375	49020.0
2005-09-30 09:00:00	AMZN	Stock	2.2375	2.2665	2.2295	2.2615	17779900.0
2005-09-30 10:00:00	AMZN	Stock	2.2615	2.292	2.2525	2.28	29123760.0
2005-09-30 11:00:00	AMZN	Stock	2.28	2.28	2.245	2.2505	13780600.0
2005-09-30 12:00:00	AMZN	Stock	2.2505	2.2785	2.2505	2.2725	10993500.0
2005-09-30 13:00:00	AMZN	Stock	2.2725	2.28	2.2636	2.2745	10237260.0
2005-09-30 14:00:00	AMZN	Stock	2.275	2.2825	2.269	2.2695	11224260.0
2005-09-30 15:00:00	AMZN	Stock	2.27	2.2775	2.2535	2.269	24166360.0
2005-09-30 16:00:00	AMZN	Stock	2.265	2.2695	2.2605	2.2657	801140.0
2005-09-30 17:00:00	AMZN	Stock	2.265	2.2665	2.2505	2.2505	340980.0
2005-09-30 18:00:00	AMZN	Stock	2.2545	2.2545	2.2545	2.2545	2000.0
2005-09-30 08:00:00	CL	Stock	26.28	26.28	26.28	26.28	1400.0
2005-09-30 09:00:00	CL	Stock	26.215	26.235	26.005	26.11	345000.0
2005-09-30 10:00:00	CL	Stock	26.105	26.175	25.91	26.17	668200.0
2005-09-30 11:00:00	CL	Stock	26.17	26.23	26.075	26.09	325200.0
2005-09-30 12:00:00	CL	Stock	26.095	26.2	26.095	26.165	162600.0
2005-09-30 13:00:00	CL	Stock	26.175	26.22	26.155	26.165	209000.0

> showing 50 of 28,072 rows — these rows as CSV

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