PREVIEW / stock_30min / 2006-07-24

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-24.parquet
  size:    899 KB
  rows:    49,646
  symbols: 2,319

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
2006-07-24 08:00:00	AAPL	Stock	2.1857	2.1893	2.1789	2.1789	423024.0
2006-07-24 08:30:00	AAPL	Stock	2.1821	2.1875	2.1786	2.1875	888580.0
2006-07-24 09:00:00	AAPL	Stock	2.1875	2.1968	2.1861	2.1882	2543268.0
2006-07-24 09:30:00	AAPL	Stock	2.1879	2.2179	2.1768	2.1829	127055404.0
2006-07-24 10:00:00	AAPL	Stock	2.1825	2.1929	2.1657	2.1779	86202984.0
2006-07-24 10:30:00	AAPL	Stock	2.1775	2.1857	2.1693	2.1729	59283504.0
2006-07-24 11:00:00	AAPL	Stock	2.1729	2.1761	2.1582	2.1661	74775568.0
2006-07-24 11:30:00	AAPL	Stock	2.1661	2.1857	2.1625	2.175	54666192.0
2006-07-24 12:00:00	AAPL	Stock	2.1754	2.18	2.1679	2.1775	32036816.0
2006-07-24 12:30:00	AAPL	Stock	2.1779	2.18	2.1704	2.1757	32677428.0
2006-07-24 13:00:00	AAPL	Stock	2.1757	2.1775	2.1707	2.175	29498224.0
2006-07-24 13:30:00	AAPL	Stock	2.1754	2.1832	2.1718	2.1786	33267024.0
2006-07-24 14:00:00	AAPL	Stock	2.1782	2.1836	2.1757	2.1804	21952196.0
2006-07-24 14:30:00	AAPL	Stock	2.1804	2.1911	2.1793	2.1879	37736832.0
2006-07-24 15:00:00	AAPL	Stock	2.1879	2.1957	2.1861	2.1932	48681500.0
2006-07-24 15:30:00	AAPL	Stock	2.1931	2.1961	2.1871	2.1961	50590932.0
2006-07-24 16:00:00	AAPL	Stock	2.1961	2.2057	2.1932	2.2	2101344.0
2006-07-24 16:30:00	AAPL	Stock	2.2	2.2	2.1936	2.1979	10984960.0
2006-07-24 17:00:00	AAPL	Stock	2.1971	2.2004	2.1968	2.1971	348880.0
2006-07-24 17:30:00	AAPL	Stock	2.1968	2.2046	2.1968	2.1971	74900.0
2006-07-24 18:00:00	AAPL	Stock	2.1968	2.1986	2.1961	2.1971	135296.0
2006-07-24 08:00:00	MSFT	Stock	23.95	23.98	23.92	23.93	6101.0
2006-07-24 08:30:00	MSFT	Stock	23.93	24.03	23.93	24.0	117768.0
2006-07-24 09:00:00	MSFT	Stock	23.99	24.07	23.94	24.0	181592.0
2006-07-24 09:30:00	MSFT	Stock	24.01	24.02	23.79	23.94	9918454.0
2006-07-24 10:00:00	MSFT	Stock	23.94	24.06	23.92	24.02	4405137.0
2006-07-24 10:30:00	MSFT	Stock	24.03	24.11	23.943	24.1	5504290.0
2006-07-24 11:00:00	MSFT	Stock	24.11	24.11	24.01	24.04	2796196.0
2006-07-24 11:30:00	MSFT	Stock	24.03	24.05	23.96	24.02	2342816.0
2006-07-24 12:00:00	MSFT	Stock	24.02	24.03	23.89	23.96	4202533.0
2006-07-24 12:30:00	MSFT	Stock	23.96	23.97	23.85	23.85	2531885.0
2006-07-24 13:00:00	MSFT	Stock	23.86	23.86	23.8	23.82	3189302.0
2006-07-24 13:30:00	MSFT	Stock	23.82	23.88	23.79	23.82	3215423.0
2006-07-24 14:00:00	MSFT	Stock	23.81	23.91	23.81	23.9	2763344.0
2006-07-24 14:30:00	MSFT	Stock	23.91	24.0	23.9	23.95	3501173.0
2006-07-24 15:00:00	MSFT	Stock	23.95	24.0	23.92	23.98	3815485.0
2006-07-24 15:30:00	MSFT	Stock	23.98	24.05	23.95	23.98	6168538.0
2006-07-24 16:00:00	MSFT	Stock	24.0	24.04	23.951	24.03	67681.0
2006-07-24 16:30:00	MSFT	Stock	24.03	24.04	24.0	24.0	1387400.0
2006-07-24 17:00:00	MSFT	Stock	24.03	24.04	24.0	24.01	1280837.0
2006-07-24 17:30:00	MSFT	Stock	24.01	24.05	24.01	24.05	1128.0
2006-07-24 18:00:00	MSFT	Stock	24.05	24.05	24.05	24.05	100.0
2006-07-24 06:30:00	NVDA	Stock	0.2933	0.2933	0.2933	0.2933	300000.0
2006-07-24 07:00:00	NVDA	Stock	0.2937	0.3017	0.29	0.29	443520.0
2006-07-24 08:00:00	NVDA	Stock	0.2903	0.2967	0.2873	0.2967	2133360.0
2006-07-24 08:30:00	NVDA	Stock	0.2967	0.3217	0.2953	0.3142	13128420.0
2006-07-24 09:00:00	NVDA	Stock	0.3128	0.314	0.305	0.3067	11762160.0
2006-07-24 09:30:00	NVDA	Stock	0.3071	0.32	0.3055	0.3128	158535120.0
2006-07-24 10:00:00	NVDA	Stock	0.313	0.316	0.3125	0.3153	66984600.0
2006-07-24 10:30:00	NVDA	Stock	0.3157	0.3202	0.3152	0.3188	100747320.0

> showing 50 of 49,646 rows — these rows as CSV

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