PREVIEW / stock_30min / 2005-04-27

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-04-27.parquet
  size:    814 KB
  rows:    43,869
  symbols: 1,966

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-27 07:00:00	AAPL	Stock	1.2857	1.2857	1.2857	1.2857	25200.0
2005-04-27 08:00:00	AAPL	Stock	1.2875	1.2929	1.2857	1.2868	369320.0
2005-04-27 08:30:00	AAPL	Stock	1.2868	1.2868	1.2696	1.2714	2664620.0
2005-04-27 09:00:00	AAPL	Stock	1.2711	1.2925	1.2711	1.28	2420152.0
2005-04-27 09:30:00	AAPL	Stock	1.2818	1.2929	1.2729	1.28	101594836.0
2005-04-27 10:00:00	AAPL	Stock	1.28	1.28	1.2682	1.2721	63729876.0
2005-04-27 10:30:00	AAPL	Stock	1.2721	1.2927	1.2711	1.2843	77144452.0
2005-04-27 11:00:00	AAPL	Stock	1.2846	1.2957	1.2757	1.2907	40290684.0
2005-04-27 11:30:00	AAPL	Stock	1.2911	1.2946	1.2818	1.2886	39390988.0
2005-04-27 12:00:00	AAPL	Stock	1.2886	1.2954	1.2882	1.2918	25881800.0
2005-04-27 12:30:00	AAPL	Stock	1.2918	1.2936	1.2861	1.2904	24911768.0
2005-04-27 13:00:00	AAPL	Stock	1.2904	1.2986	1.2871	1.2939	40637156.0
2005-04-27 13:30:00	AAPL	Stock	1.2936	1.2954	1.2839	1.2879	29491756.0
2005-04-27 14:00:00	AAPL	Stock	1.2882	1.2911	1.2846	1.2886	28370440.0
2005-04-27 14:30:00	AAPL	Stock	1.2882	1.2946	1.2857	1.2943	29999032.0
2005-04-27 15:00:00	AAPL	Stock	1.2943	1.2982	1.2861	1.2864	33243420.0
2005-04-27 15:30:00	AAPL	Stock	1.2864	1.2882	1.2796	1.2829	51301376.0
2005-04-27 16:00:00	AAPL	Stock	1.2829	1.285	1.2821	1.2829	2285584.0
2005-04-27 16:30:00	AAPL	Stock	1.2839	1.2871	1.2821	1.2871	279300.0
2005-04-27 17:00:00	AAPL	Stock	1.2871	1.2871	1.2839	1.2854	81200.0
2005-04-27 17:30:00	AAPL	Stock	1.2829	1.2861	1.2829	1.2861	157920.0
2005-04-27 18:00:00	AAPL	Stock	1.2854	1.2854	1.2854	1.2854	60200.0
2005-04-27 08:00:00	MSFT	Stock	24.75	24.76	24.73	24.76	5924.0
2005-04-27 08:30:00	MSFT	Stock	24.76	24.76	24.66	24.67	22590.0
2005-04-27 09:00:00	MSFT	Stock	24.66	24.74	24.64	24.64	399281.0
2005-04-27 09:30:00	MSFT	Stock	24.66	24.85	24.63	24.83	6320863.0
2005-04-27 10:00:00	MSFT	Stock	24.82	24.84	24.77	24.79	3158815.0
2005-04-27 10:30:00	MSFT	Stock	24.78	24.91	24.78	24.87	4485982.0
2005-04-27 11:00:00	MSFT	Stock	24.87	24.99	24.81	24.97	3335472.0
2005-04-27 11:30:00	MSFT	Stock	24.961	25.0	24.93	24.99	3999575.0
2005-04-27 12:00:00	MSFT	Stock	24.98	25.15	24.98	25.09	4405713.0
2005-04-27 12:30:00	MSFT	Stock	25.09	25.1	25.01	25.03	1914863.0
2005-04-27 13:00:00	MSFT	Stock	25.03	25.12	25.02	25.08	3356407.0
2005-04-27 13:30:00	MSFT	Stock	25.08	25.09	24.96	24.99	2163430.0
2005-04-27 14:00:00	MSFT	Stock	24.99	25.05	24.95	25.02	2330246.0
2005-04-27 14:30:00	MSFT	Stock	25.012	25.1	24.97	25.079	2521662.0
2005-04-27 15:00:00	MSFT	Stock	25.08	25.1	24.96	24.992	3605196.0
2005-04-27 15:30:00	MSFT	Stock	25.0	25.05	24.94	24.97	4363038.0
2005-04-27 16:00:00	MSFT	Stock	24.98	25.0	24.89	24.95	245389.0
2005-04-27 16:30:00	MSFT	Stock	24.95	24.999	24.93	24.99	50417.0
2005-04-27 17:00:00	MSFT	Stock	24.99	25.01	24.99	25.01	8792.0
2005-04-27 17:30:00	MSFT	Stock	25.01	25.05	24.95	25.05	18550.0
2005-04-27 08:00:00	NVDA	Stock	0.1837	0.1837	0.1833	0.1833	384000.0
2005-04-27 08:30:00	NVDA	Stock	0.1833	0.1846	0.1833	0.1833	180000.0
2005-04-27 09:00:00	NVDA	Stock	0.1829	0.1874	0.1821	0.1825	1459200.0
2005-04-27 09:30:00	NVDA	Stock	0.1825	0.1832	0.1768	0.177	124179360.0
2005-04-27 10:00:00	NVDA	Stock	0.177	0.1787	0.1767	0.1781	73870200.0
2005-04-27 10:30:00	NVDA	Stock	0.178	0.18	0.178	0.179	58936320.0
2005-04-27 11:00:00	NVDA	Stock	0.1791	0.1791	0.1765	0.1787	51453600.0
2005-04-27 11:30:00	NVDA	Stock	0.1787	0.1789	0.1777	0.1787	36537480.0

> showing 50 of 43,869 rows — these rows as CSV

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