PREVIEW / stock_1hour / 2005-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-25.parquet
  size:    546 KB
  rows:    25,947
  symbols: 1,971

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-04-25 07:00:00	AAPL	Stock	1.2932	1.2964	1.2914	1.2914	42000.0
2005-04-25 08:00:00	AAPL	Stock	1.2914	1.3018	1.2857	1.2929	5329632.0
2005-04-25 09:00:00	AAPL	Stock	1.2932	1.3064	1.2896	1.2982	134989540.0
2005-04-25 10:00:00	AAPL	Stock	1.2982	1.3221	1.2968	1.315	178980536.0
2005-04-25 11:00:00	AAPL	Stock	1.3154	1.3193	1.3104	1.3154	79980012.0
2005-04-25 12:00:00	AAPL	Stock	1.3154	1.3157	1.305	1.3057	53626496.0
2005-04-25 13:00:00	AAPL	Stock	1.305	1.3157	1.3039	1.3082	59611272.0
2005-04-25 14:00:00	AAPL	Stock	1.3082	1.3182	1.3079	1.3132	72570456.0
2005-04-25 15:00:00	AAPL	Stock	1.3129	1.3214	1.3089	1.3214	147880768.0
2005-04-25 16:00:00	AAPL	Stock	1.3204	1.3236	1.3193	1.3232	4190452.0
2005-04-25 17:00:00	AAPL	Stock	1.3225	1.3229	1.3189	1.3229	362124.0
2005-04-25 18:00:00	AAPL	Stock	1.3232	1.3232	1.3214	1.3214	166516.0
2005-04-25 08:00:00	MSFT	Stock	24.98	25.04	24.98	25.04	10045.0
2005-04-25 09:00:00	MSFT	Stock	25.04	25.18	25.02	25.11	6734303.0
2005-04-25 10:00:00	MSFT	Stock	25.11	25.28	25.1	25.13	8541231.0
2005-04-25 11:00:00	MSFT	Stock	25.13	25.24	25.12	25.14	5165873.0
2005-04-25 12:00:00	MSFT	Stock	25.14	25.15	24.98	25.04	6059422.0
2005-04-25 13:00:00	MSFT	Stock	25.05	25.17	25.0	25.01	7356061.0
2005-04-25 14:00:00	MSFT	Stock	25.01	25.06	24.96	24.979	6138894.0
2005-04-25 15:00:00	MSFT	Stock	24.97	25.19	24.86	24.98	14906676.0
2005-04-25 16:00:00	MSFT	Stock	24.99	25.0	24.96	24.97	12859826.0
2005-04-25 17:00:00	MSFT	Stock	25.125	25.125	24.96	24.99	62572.0
2005-04-25 18:00:00	MSFT	Stock	24.98	24.98	24.98	24.98	2520.0
2005-04-25 09:00:00	NVDA	Stock	0.1857	0.1889	0.1857	0.1867	37157160.0
2005-04-25 10:00:00	NVDA	Stock	0.1866	0.1897	0.1864	0.1882	59343360.0
2005-04-25 11:00:00	NVDA	Stock	0.1882	0.1889	0.1878	0.1887	28042800.0
2005-04-25 12:00:00	NVDA	Stock	0.1887	0.1892	0.1882	0.189	31540320.0
2005-04-25 13:00:00	NVDA	Stock	0.189	0.1896	0.1879	0.1879	47282280.0
2005-04-25 14:00:00	NVDA	Stock	0.1879	0.1887	0.1875	0.1877	28864800.0
2005-04-25 15:00:00	NVDA	Stock	0.1877	0.1884	0.1869	0.1883	75690000.0
2005-04-25 16:00:00	NVDA	Stock	0.1882	0.189	0.1875	0.1882	6520800.0
2005-04-25 17:00:00	NVDA	Stock	0.1882	0.19	0.1882	0.19	414000.0
2005-04-25 18:00:00	NVDA	Stock	0.1887	0.1887	0.1883	0.1883	480000.0
2005-04-25 08:00:00	AMZN	Stock	1.65	1.655	1.65	1.655	18000.0
2005-04-25 09:00:00	AMZN	Stock	1.6555	1.6655	1.6525	1.659	8494240.0
2005-04-25 10:00:00	AMZN	Stock	1.659	1.6735	1.656	1.665	15583060.0
2005-04-25 11:00:00	AMZN	Stock	1.665	1.6695	1.6575	1.6685	12408840.0
2005-04-25 12:00:00	AMZN	Stock	1.6685	1.675	1.664	1.672	5701200.0
2005-04-25 13:00:00	AMZN	Stock	1.672	1.6745	1.667	1.667	7626800.0
2005-04-25 14:00:00	AMZN	Stock	1.6675	1.6795	1.6665	1.672	9109600.0
2005-04-25 15:00:00	AMZN	Stock	1.6715	1.676	1.657	1.6705	24451700.0
2005-04-25 16:00:00	AMZN	Stock	1.6705	1.6875	1.667	1.667	388380.0
2005-04-25 17:00:00	AMZN	Stock	1.67	1.6835	1.67	1.6835	199600.0
2005-04-25 09:00:00	CL	Stock	25.735	25.84	25.52	25.69	288200.0
2005-04-25 10:00:00	CL	Stock	25.705	25.79	25.51	25.7	737600.0
2005-04-25 11:00:00	CL	Stock	25.715	25.9	25.715	25.75	387000.0
2005-04-25 12:00:00	CL	Stock	25.75	25.835	25.695	25.795	287400.0
2005-04-25 13:00:00	CL	Stock	25.79	25.89	25.72	25.775	313000.0
2005-04-25 14:00:00	CL	Stock	25.77	25.915	25.77	25.815	520000.0
2005-04-25 15:00:00	CL	Stock	25.795	25.85	25.725	25.82	512800.0

> showing 50 of 25,947 rows — these rows as CSV

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