PREVIEW / stock_30min / 2005-04-18

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-04-18.parquet
  size:    823 KB
  rows:    44,271
  symbols: 1,970

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-18 07:00:00	AAPL	Stock	1.2411	1.2411	1.2411	1.2411	16800.0
2005-04-18 07:30:00	AAPL	Stock	1.2464	1.2536	1.2464	1.2529	161000.0
2005-04-18 08:00:00	AAPL	Stock	1.2529	1.2636	1.2446	1.2536	6695220.0
2005-04-18 08:30:00	AAPL	Stock	1.255	1.2675	1.2357	1.2668	4189696.0
2005-04-18 09:00:00	AAPL	Stock	1.2671	1.2739	1.2504	1.2546	14555548.0
2005-04-18 09:30:00	AAPL	Stock	1.25	1.2746	1.2143	1.2571	271975508.0
2005-04-18 10:00:00	AAPL	Stock	1.2579	1.2739	1.2411	1.2554	227903648.0
2005-04-18 10:30:00	AAPL	Stock	1.2554	1.2639	1.2446	1.2611	100528932.0
2005-04-18 11:00:00	AAPL	Stock	1.2614	1.2789	1.2579	1.2736	111183100.0
2005-04-18 11:30:00	AAPL	Stock	1.2736	1.2746	1.2589	1.265	67396252.0
2005-04-18 12:00:00	AAPL	Stock	1.265	1.275	1.2636	1.2729	66110856.0
2005-04-18 12:30:00	AAPL	Stock	1.2732	1.2943	1.2711	1.2896	97239688.0
2005-04-18 13:00:00	AAPL	Stock	1.29	1.2964	1.2846	1.2875	82743892.0
2005-04-18 13:30:00	AAPL	Stock	1.2871	1.2904	1.2793	1.2811	44389408.0
2005-04-18 14:00:00	AAPL	Stock	1.2811	1.2882	1.2768	1.2789	40415900.0
2005-04-18 14:30:00	AAPL	Stock	1.2796	1.2836	1.2636	1.2671	61510904.0
2005-04-18 15:00:00	AAPL	Stock	1.2671	1.2818	1.2596	1.2807	93486960.0
2005-04-18 15:30:00	AAPL	Stock	1.2811	1.2814	1.2704	1.2721	77919100.0
2005-04-18 16:00:00	AAPL	Stock	1.2721	1.2761	1.2696	1.2707	2089248.0
2005-04-18 16:30:00	AAPL	Stock	1.2711	1.2779	1.2711	1.2768	1026872.0
2005-04-18 17:00:00	AAPL	Stock	1.2757	1.2768	1.2721	1.2768	108332.0
2005-04-18 17:30:00	AAPL	Stock	1.275	1.2775	1.2732	1.275	305200.0
2005-04-18 18:00:00	AAPL	Stock	1.275	1.2771	1.275	1.2771	40600.0
2005-04-18 07:30:00	MSFT	Stock	24.36	24.36	24.36	24.36	200.0
2005-04-18 08:00:00	MSFT	Stock	24.36	24.49	24.36	24.47	31219.0
2005-04-18 08:30:00	MSFT	Stock	24.48	24.48	24.46	24.48	41706.0
2005-04-18 09:00:00	MSFT	Stock	24.47	24.49	24.41	24.43	239223.0
2005-04-18 09:30:00	MSFT	Stock	24.45	24.74	24.4	24.7	9682498.0
2005-04-18 10:00:00	MSFT	Stock	24.69	24.71	24.61	24.63	7013514.0
2005-04-18 10:30:00	MSFT	Stock	24.63	24.68	24.54	24.61	5414880.0
2005-04-18 11:00:00	MSFT	Stock	24.61	24.7	24.61	24.68	5265800.0
2005-04-18 11:30:00	MSFT	Stock	24.68	24.69	24.61	24.641	3760892.0
2005-04-18 12:00:00	MSFT	Stock	24.64	24.71	24.63	24.71	3591693.0
2005-04-18 12:30:00	MSFT	Stock	24.71	24.83	24.67	24.78	5922761.0
2005-04-18 13:00:00	MSFT	Stock	24.79	24.84	24.72	24.78	5407449.0
2005-04-18 13:30:00	MSFT	Stock	24.77	24.8	24.71	24.74	3535751.0
2005-04-18 14:00:00	MSFT	Stock	24.73	24.78	24.62	24.65	5151440.0
2005-04-18 14:30:00	MSFT	Stock	24.65	24.69	24.58	24.65	5953197.0
2005-04-18 15:00:00	MSFT	Stock	24.64	24.71	24.61	24.688	5550872.0
2005-04-18 15:30:00	MSFT	Stock	24.69	24.71	24.62	24.67	6123087.0
2005-04-18 16:00:00	MSFT	Stock	24.67	24.78	24.65	24.7	2208142.0
2005-04-18 16:30:00	MSFT	Stock	24.67	24.73	24.67	24.67	1032343.0
2005-04-18 17:00:00	MSFT	Stock	24.73	24.73	24.71	24.71	1460.0
2005-04-18 17:30:00	MSFT	Stock	24.71	24.74	24.71	24.74	2883.0
2005-04-18 18:00:00	MSFT	Stock	24.74	24.92	24.74	24.74	2459.0
2005-04-18 08:00:00	NVDA	Stock	0.178	0.178	0.1779	0.1779	168000.0
2005-04-18 08:30:00	NVDA	Stock	0.1767	0.1767	0.1766	0.1766	85200.0
2005-04-18 09:00:00	NVDA	Stock	0.1779	0.1783	0.1762	0.1763	984000.0
2005-04-18 09:30:00	NVDA	Stock	0.1768	0.1799	0.1767	0.1787	56274240.0
2005-04-18 10:00:00	NVDA	Stock	0.1787	0.1807	0.1782	0.1782	40574880.0

> showing 50 of 44,271 rows — these rows as CSV

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