PREVIEW / stock_30min / 2005-01-20

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-01-20.parquet
  size:    818 KB
  rows:    44,005
  symbols: 1,899

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-01-20 08:00:00	AAPL	Stock	1.2366	1.2418	1.2366	1.2375	1379784.0
2005-01-20 08:30:00	AAPL	Stock	1.2393	1.2438	1.2377	1.242	1788360.0
2005-01-20 09:00:00	AAPL	Stock	1.242	1.2455	1.2395	1.2432	1345400.0
2005-01-20 09:30:00	AAPL	Stock	1.2438	1.2536	1.2405	1.2482	116563944.0
2005-01-20 10:00:00	AAPL	Stock	1.248	1.2607	1.2475	1.2552	101446912.0
2005-01-20 10:30:00	AAPL	Stock	1.2552	1.2605	1.2527	1.2596	50376312.0
2005-01-20 11:00:00	AAPL	Stock	1.2595	1.2679	1.2588	1.2675	79468144.0
2005-01-20 11:30:00	AAPL	Stock	1.2679	1.2727	1.2571	1.2691	86074912.0
2005-01-20 12:00:00	AAPL	Stock	1.2686	1.27	1.2568	1.2689	62730080.0
2005-01-20 12:30:00	AAPL	Stock	1.2689	1.2714	1.2657	1.267	51470888.0
2005-01-20 13:00:00	AAPL	Stock	1.2671	1.2705	1.2595	1.2638	60047344.0
2005-01-20 13:30:00	AAPL	Stock	1.2636	1.2702	1.26	1.2605	38827824.0
2005-01-20 14:00:00	AAPL	Stock	1.2607	1.2705	1.2607	1.2641	58144968.0
2005-01-20 14:30:00	AAPL	Stock	1.2641	1.267	1.2602	1.2641	51599016.0
2005-01-20 15:00:00	AAPL	Stock	1.2641	1.2677	1.2604	1.2616	47294968.0
2005-01-20 15:30:00	AAPL	Stock	1.2616	1.2632	1.2559	1.2579	80073448.0
2005-01-20 16:00:00	AAPL	Stock	1.258	1.2686	1.258	1.2679	10538976.0
2005-01-20 16:30:00	AAPL	Stock	1.2661	1.2661	1.2582	1.2625	711200.0
2005-01-20 17:00:00	AAPL	Stock	1.2602	1.2623	1.2602	1.2623	176400.0
2005-01-20 17:30:00	AAPL	Stock	1.2625	1.2677	1.2604	1.2614	209160.0
2005-01-20 18:00:00	AAPL	Stock	1.2611	1.2632	1.2611	1.2629	296072.0
2005-01-20 08:00:00	MSFT	Stock	25.76	25.79	25.7	25.79	16353.0
2005-01-20 08:30:00	MSFT	Stock	25.8	25.85	25.8	25.81	30557.0
2005-01-20 09:00:00	MSFT	Stock	25.8	25.9	25.8	25.83	174228.0
2005-01-20 09:30:00	MSFT	Stock	25.835	26.001	25.82	25.92	7134653.0
2005-01-20 10:00:00	MSFT	Stock	25.92	26.03	25.85	25.97	5440852.0
2005-01-20 10:30:00	MSFT	Stock	25.97	26.03	25.95	25.98	3390683.0
2005-01-20 11:00:00	MSFT	Stock	25.97	26.03	25.94	25.979	2671467.0
2005-01-20 11:30:00	MSFT	Stock	25.98	26.071	25.96	26.05	5798203.0
2005-01-20 12:00:00	MSFT	Stock	26.05	26.1	25.98	26.01	2996126.0
2005-01-20 12:30:00	MSFT	Stock	26.02	26.03	25.95	25.95	2330203.0
2005-01-20 13:00:00	MSFT	Stock	25.96	25.97	25.86	25.9	5481986.0
2005-01-20 13:30:00	MSFT	Stock	25.89	25.93	25.85	25.88	2878616.0
2005-01-20 14:00:00	MSFT	Stock	25.89	25.99	25.88	25.89	4428136.0
2005-01-20 14:30:00	MSFT	Stock	25.89	25.96	25.88	25.941	2785118.0
2005-01-20 15:00:00	MSFT	Stock	25.94	25.97	25.85	25.86	4019965.0
2005-01-20 15:30:00	MSFT	Stock	25.86	25.94	25.74	25.85	6840941.0
2005-01-20 16:00:00	MSFT	Stock	25.86	25.935	25.84	25.86	601002.0
2005-01-20 16:30:00	MSFT	Stock	25.86	25.86	25.83	25.84	101432.0
2005-01-20 17:00:00	MSFT	Stock	25.83	25.9	25.83	25.9	8500.0
2005-01-20 17:30:00	MSFT	Stock	25.85	25.94	25.84	25.85	4450.0
2005-01-20 18:00:00	MSFT	Stock	25.85	25.86	25.85	25.85	2000.0
2005-01-20 09:00:00	NVDA	Stock	0.1754	0.1771	0.1741	0.1742	1346400.0
2005-01-20 09:30:00	NVDA	Stock	0.1743	0.1782	0.1743	0.1778	67835400.0
2005-01-20 10:00:00	NVDA	Stock	0.1778	0.1806	0.1776	0.1795	53115360.0
2005-01-20 10:30:00	NVDA	Stock	0.1794	0.1796	0.1785	0.1792	34010760.0
2005-01-20 11:00:00	NVDA	Stock	0.1792	0.1806	0.1792	0.18	35953680.0
2005-01-20 11:30:00	NVDA	Stock	0.18	0.1827	0.1793	0.1823	44098080.0
2005-01-20 12:00:00	NVDA	Stock	0.1823	0.1823	0.1802	0.181	43797840.0
2005-01-20 12:30:00	NVDA	Stock	0.181	0.1815	0.1806	0.1808	24716760.0

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

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